Posted By

zwigby on 08/04/10


Tagged


Versions (?)

SQL Basics


 / Published in: SQL
 

URL: http://www.w3schools.com/sql/default.asp

  1. /* Select */
  2. SELECT column_name(s)
  3. FROM table_name
  4.  
  5. /* Insert */
  6. INSERT INTO table_name (column1, column2, column3,...)
  7. VALUES (value1, value2, value3,...)
  8.  
  9. /* Update */
  10. UPDATE table_name
  11. SET column1=value, column2=value2,...
  12. WHERE some_column=some_value
  13.  
  14. /* Delete */
  15. DELETE FROM table_name
  16. WHERE some_column=some_value

Report this snippet  

You need to login to post a comment.