Simple MySQL Commands?

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
dclamp
Forum Commoner
Posts: 35
Joined: Sun Sep 17, 2006 10:05 am

Simple MySQL Commands?

Post 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!
User avatar
volka
DevNet Evangelist
Posts: 8391
Joined: Tue May 07, 2002 9:48 am
Location: Berlin, ger

Post 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
User avatar
dclamp
Forum Commoner
Posts: 35
Joined: Sun Sep 17, 2006 10:05 am

Post by dclamp »

how do i write them in php i ment.
User avatar
volka
DevNet Evangelist
Posts: 8391
Joined: Tue May 07, 2002 9:48 am
Location: Berlin, ger

Post 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
Post Reply