(Structured Query Language) Pronounced "S-Q-L" or "see-quill," a language used to interrogate and process data in a relational database. Originally developed by IBM for its mainframes, SQL commands can be used to interactively work with a database or can be embedded within a script or programming language to interface to a database. Programming extensions to SQL have turned it into a full-blown database programming language, and all major database management systems (DBMSs) support it. ANSI standardized SQL, but most DBMSs have some proprietary enhancement, which if used, makes SQL non-standard. Moving an application from one SQL database to another sometimes requires tweaking, the age old problem in this business! See MySQL, MDX, CLI, ODBC, IDAPI and SQL injection. The following SQL query selects customers with credit limits of at least $5,000 and puts them into sequence from highest credit limit to lowest. The blue words are SQL verbs. See SPUFI. select name, city, state, zipcode from customer where creditlimit > 4999 order by creditlimit desc
SQL (Structured Query Language) is defined as a standard programming language used to put in, get out or process information from a database.
An example of SQL is using code like "order by" or "sum" to access information in a database.
- For example, an employer might hold the IT manager responsible for administering database hardware and software that use the SQL programming language and interface with applications made by Oracle and Microsoft and Research in Motion.
- One example would be, when a user logs into your website, you can have your PHP script look up their address within your user table in the SQL database, and return a customized welcome statement on the page.
- SQL: An acronym for Structured Query Language, SQL is a language that allows for updating, requesting, or deleting information from any database associated with your website.
- Supported scripting languages include ASP.NET, Perl, PHP, as well as SQL and MySQL for database features.