You can run the following statement to return a list of available character sets in MySQL:
SHOW CHARACTER SET;
This returns a list displaying the character set name, a description, its default collation, and its maximum length.
Continue reading
Category: MySQL
How to Find the Collations Supported by the Server in MySQL
Running the following statement lists all collations supported by the server in MySQL:
SHOW COLLATION;
However, the resulting list is quite long, and if you have a collation in mind, you can always filter the list with either the LIKE clause or the WHERE clause.
How to Export the results of a Query using MySQL Workbench
You can use MySQL Workbench to run a query, then export the results of that query to a file.
To do this:
- Run the query
- Click Export on the Results Grid menu bar
How to Save a MySQL Query Result to a .CSV File
You can save a query result to a .CSV file by using the SELECT ... INTO OUTFILE statement.
You specify the name/location of the file as well as other options, such as field terminators, line terminators, etc.
SQL DROP TABLE Syntax – Listed by DBMS
This article lists the SQL DROP TABLE syntax, as implemented by various database management systems (DBMSs). The syntax is listed exactly as each vendor has listed it on their website. Click on the applicable link to view more detail about the syntax for a particular vendor.
The DBMSs covered are MySQL, SQL Server, PostgreSQL, and Oracle Database.
SQL TRUNCATE Syntax – Listed by DBMS
This article lists the SQL TRUNCATE syntax, as implemented by various database management systems (DBMSs). The syntax is listed exactly as each vendor has listed it on their website. Click on the applicable link to view more detail about the syntax for a particular vendor.
The DBMSs covered are MySQL, SQL Server, PostgreSQL, and Oracle Database.
SQL DELETE Syntax – Listed by DBMS
This article lists the SQL DELETE syntax, as implemented by various database management systems (DBMSs). The syntax is listed exactly as each vendor has listed it on their website. Click on the applicable link to view more detail about the syntax for a particular vendor.
The DBMSs covered are MySQL, SQL Server, PostgreSQL, and Oracle Database.
SQL UPDATE Syntax – Listed by DBMS
This article lists the SQL UPDATE syntax, as implemented by various database management systems (DBMSs). The syntax is listed exactly as each vendor has listed it on their website. Click on the applicable link to view more detail about the syntax for a particular vendor.
The DBMSs covered are MySQL, SQL Server, PostgreSQL, and Oracle Database.
SQL INSERT Syntax – Listed by DBMS
This article lists the SQL INSERT syntax, as implemented by various database management systems (DBMSs). The syntax is listed exactly as each vendor has listed it on their website. Click on the applicable link to view more detail about the syntax for a particular vendor.
The DBMSs covered are MySQL, SQL Server, PostgreSQL, and Oracle Database.
SQL SELECT Syntax – Listed by DBMS
This article lists the SQL SELECT syntax, as implemented by various database management systems (DBMSs). The syntax is listed exactly as each vendor has listed it on their website. Click on the applicable link to view more detail about the syntax for a particular vendor.
The DBMSs covered are MySQL, SQL Server, PostgreSQL, and Oracle Database.