mySQL

[megacool]

I have no previous mySQL experience. I am using a free script that adds records to a Table in mySQL. But the problem is that.. what if i want to delete one single record? (row).. is it possible? or do i need another php script for it.. by the way my host is using phpMyAdmin for mySQL admin. And i also wanted to know how can i export a Database..? or probably save/backup it offline. Thanks for help.

[neon]

Try looking at the fourms at phpbuilder.com and they should have answers to just about all of those questions. Also the phpMyAdmin docs should tell you how to do it. Anyway good luck.

[perlboy]

You're best bet is to see if it is possible to delete with an inclusion of a where rule. This would probably rely on you to have defined a unique key to the MySQL database so that way you can directely reference a specific record.

If you are able to parse MySQL commands directely to the daemon run this.

delete from TABLE_NAME where COLUMNNAME='VALUE';

be careful not to define some sort of wild card in the VALUE part though.

Bye..

Stuart Low
thedude@perlboy.org