Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
SQL example (Read 23208 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
SQL example
20.10.09 at 16:40:38
 
SQL example
 
SQL is short for Simpel Query Language. It is an English command language to interact with databases.
 
Example:
select * from mytable;
 
This command will retrieve all data from the table mytable.
 
Example:
update mytable set field_a = 5
 
This command will update all rows in the table mytable and set the field field_a to 5.
 
Other commands include, insert and delete.
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1