CRUD en Mysql

INSERT INTO table_name ( field1, field2,...fieldN )
   VALUES
   ( value1, value2,...valueN );

UPDATE table_name SET field1 = new-value1, field2 = new-value2
[WHERE Clause]
DELETE FROM table_name [WHERE Clause]
SELECT field1, field2,...fieldN 
FROM table_name1, table_name2...
[WHERE Clause]
[WHERE condition1 [AND [OR]] condition2.....

Publicado por

Juan Pablo Fuentes

Formador de programación y bases de datos