Guides:SQL/How do I

From CoderGuide

Return to the SQL Guides Index

Contents 1 Basic Setup and Administration 2 SQL operations 3 APIs 4 Implementation Specifics

Basic Setup and Administration

• Guides:MySQL/MySQL_Quick_Start_Guide Basic setup and management for the MySQL server

SQL operations

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

APIs

Accessing a SQL database from various programming languages.

• MySQL
  • Perl DBI API (DBD:mysql)
  • PHP and MySQL

Implementation Specifics

• Microsoft SQL Server
  • Get Database and Table Information in a Microsoft SQL Server
• MySQL Server
  • Define and Use a Saved Function in MySQL