What is SQL? SQL, short name for Structured Query Language, is used as the file extension for Structured Query Language code files. .SQL files are text files that can be opened by Notepad or any text editors. See the sample .SQL file included below.

File Extension: .SQL

MIME Type: text/plain

File Content: Structured Query Language

.SQL files are text files with Structured Query Language (SQL) statement codes. Here is a sample .SQL Structured Query Language file containing some simple SQL statements:

-- Creating a table
CREATE TABLE fyi_links (id INTEGER PRIMARY KEY,
  url VARCHAR(16) NOT NULL,
  notes VARCHAR(16),
  counts INTEGER,
  created TIMESTAMP DEFAULT CURRENT_TIMESTAMP());
     
-- Inserting a row
INSERT INTO fyi_links VALUES (101, 
  'dev.fyicenter.com', 
  NULL,
  0,
  '2006-04-30');
  
-- Retrieving data
SELECT * FROM fyi_links ORDER BY created DESC;

.SQL Structured Query Language file sample: Click sample.sql to download.

Since .SQL text files are in text format, you can use Notepad or any text editor to create or modify them. No special software is needed.

For for information on how to use .SQL Structured Query Language files, see links below:

• MySQL Documentation: MySQL Reference Manuals.