Guides:SQL/How do I
Basic Setup and Administration
- Guides:MySQL/MySQL_Quick_Start_Guide Basic setup and management for the MySQL server
SQL (pronounced S-Q-L, not Sequal, although Sequal was the old name for the language developed by IBM in the 1970s) is an ISO standard language. Although not all of the current SQL standards have been adopted by all the modern SQL servers, the queries here should still work in whatever modern SQL server you're currently running. There may be a few small differences (for instance, Oracle requires a COMMIT command in some cases to actually save the changes to the database).
However, these articles lean more towards MySQL than any other SQL server. This is due mainly to the fact MySQL is, by far, the most popular SQL server in use today, works on just about all modern network operating systems, and it also happens to be free. If your not using MySQL and a few queries don't work, please check your user manual for your server's idiosyncrasies, and add a note regarding these (and how to make the query work in your particular SQL sever and server version number) in the discussion tab.
- Create and Delete a Database
- Create and Delete a Table
- Insert and Remove Columns from a Table
- Add and Remove Data in a Table
- Show and Find Records in a Table
- Guides:SQL/How do I/Using WHERE to Find Records -- this section does not cover unions/joins
- Do Math on Table Data
Accessing a SQL database from various programming languages.
- Microsoft SQL Server
- MySQL Server