{"id":1626,"date":"2024-02-20T00:00:00","date_gmt":"2024-02-20T05:00:00","guid":{"rendered":"https:\/\/molecularsciences.org\/content\/?p=1626"},"modified":"2024-02-21T07:51:22","modified_gmt":"2024-02-21T12:51:22","slug":"mysql-cheat-sheet","status":"publish","type":"post","link":"https:\/\/molecularsciences.org\/content\/mysql-cheat-sheet\/","title":{"rendered":"MySQL Cheat Sheet"},"content":{"rendered":"\n

MySQL is a popular relational database management system (RDBMS) known for its performance and flexibility. This cheat sheet provides essential commands and queries for interacting with MySQL databases efficiently.<\/p>\n\n\n\n

Connecting to MySQL:<\/strong><\/h4>\n\n\n\n
Command<\/th>Description<\/th><\/tr><\/thead>
mysql -u [username] -p<\/code><\/td>Connect to MySQL server with a username and password.<\/td><\/tr>
CREATE DATABASE [database_name];<\/code><\/td>Create a new database.<\/td><\/tr>
USE [database_name];<\/code><\/td>Switch to a specific database.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Managing Tables:<\/strong><\/h4>\n\n\n\n
Command<\/th>Description<\/th><\/tr><\/thead>
CREATE TABLE [table_name] ([column_definitions]);<\/code><\/td>Create a new table with specified columns.<\/td><\/tr>
DESCRIBE [table_name];<\/code><\/td>Display the structure of a table.<\/td><\/tr>
SHOW TABLES;<\/code><\/td>Show all tables in the current database.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Inserting Data:<\/strong><\/h4>\n\n\n\n
Command<\/th>Description<\/th><\/tr><\/thead>
INSERT INTO [table_name] VALUES (value1, value2, ...);<\/code><\/td>Insert data into a table.<\/td><\/tr>
INSERT INTO [table_name] (column1, column2, ...) VALUES (value1, value2, ...);<\/code><\/td>Insert data with specified columns.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Querying Data:<\/strong><\/h4>\n\n\n\n
Command<\/th>Description<\/th><\/tr><\/thead>
SELECT * FROM [table_name];<\/code><\/td>Retrieve all columns from a table.<\/td><\/tr>
SELECT column1, column2 FROM [table_name] WHERE condition;<\/code><\/td>Retrieve specific columns with conditions.<\/td><\/tr>
UPDATE [table_name] SET column1 = value1 WHERE condition;<\/code><\/td>Update data in a table.<\/td><\/tr>
DELETE FROM [table_name] WHERE condition;<\/code><\/td>Delete data from a table.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Filtering and Sorting:<\/strong><\/h4>\n\n\n\n
Command<\/th>Description<\/th><\/tr><\/thead>
SELECT * FROM [table_name] WHERE condition ORDER BY column_name ASC\/DESC;<\/code><\/td>Filter and sort query results.<\/td><\/tr>
LIMIT [number];<\/code><\/td>Limit the number of rows returned.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Aggregation Functions:<\/strong><\/h4>\n\n\n\n
Command<\/th>Description<\/th><\/tr><\/thead>
SELECT COUNT(column_name) FROM [table_name];<\/code><\/td>Count the number of rows in a table.<\/td><\/tr>
SELECT AVG(column_name) FROM [table_name];<\/code><\/td>Calculate the average value of a column.<\/td><\/tr>
SELECT MAX(column_name) FROM [table_name];<\/code><\/td>Retrieve the maximum value in a column.<\/td><\/tr>
SELECT MIN(column_name) FROM [table_name];<\/code><\/td>Retrieve the minimum value in a column.<\/td><\/tr>
SELECT SUM(column_name) FROM [table_name];<\/code><\/td>Calculate the sum of values in a column.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Conclusion<\/h3>\n\n\n\n

This MySQL cheat sheet provides a concise reference for essential commands to manage databases, tables, and data. Whether you are a beginner or an experienced user, these commands cover a wide range of tasks, from creating databases and tables to querying and modifying data. Customize these commands based on your specific use cases and database configurations.<\/p>\n","protected":false},"excerpt":{"rendered":"

MySQL is a popular relational database management system (RDBMS) known for its performance and flexibility. This cheat sheet provides essential commands and queries for interacting with MySQL databases efficiently. Connecting to MySQL: Command Description mysql -u [username] -p Connect to MySQL server with a username and password. CREATE DATABASE [database_name]; Create a new database. USE […]<\/p>\n","protected":false},"author":1,"featured_media":1781,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16,204],"tags":[14,27],"class_list":["post-1626","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database","category-mysql","tag-database","tag-mysql"],"_links":{"self":[{"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/posts\/1626","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/comments?post=1626"}],"version-history":[{"count":1,"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/posts\/1626\/revisions"}],"predecessor-version":[{"id":1627,"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/posts\/1626\/revisions\/1627"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/media\/1781"}],"wp:attachment":[{"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/media?parent=1626"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/categories?post=1626"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/tags?post=1626"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}