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!
Simple MySQL Commands?
Moderator: General Moderators
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
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
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
http://de2.php.net/mysql
http://de2.php.net/mysqli
http://de2.php.net/pdo