Page 1 of 1

Simple MySQL Commands?

Posted: Fri Oct 06, 2006 6:22 pm
by dclamp
I just want to know if some one can tell me the simple MySQL commands for like:
-Add To Table
-Remove from table
-Edit from table
-Check from table
--Like what login scripts do
-Create Table
-Remove Table

thanks in advanced!

Posted: Fri Oct 06, 2006 6:34 pm
by volka
INSERT INTO tablename
DELETE FROM tablename
UPDATE tablename
SELECT FROM tablename ... WHERE
CREATE TABLE tablename
DROP tablename

see http://dev.mysql.com/doc/refman/5.0/en/index.html

Posted: Fri Oct 06, 2006 6:46 pm
by dclamp
how do i write them in php i ment.

Posted: Fri Oct 06, 2006 6:47 pm
by volka
That is explained and illustrated with examples e.g. at
http://de2.php.net/mysql
http://de2.php.net/mysqli
http://de2.php.net/pdo