Shulou(Shulou.com)05/31 Report--

This article mainly explains "what are the basic SQL sentences commonly used in MYSQL". The content of the explanation is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "what are the basic SQL sentences commonly used in MYSQL".

Start and stop net stop mysql of mysql service-stop net start mysql-start login mysqlmysql-h localhost-u root-P 3306-pmysql-h localhost-u root-p 123456 exit mysqlmysql > exit; view database mysql > SHOW DATABASES; create and delete database mysql > CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name [DEFAULT] CHARACTER SET [=] charset_name;-create mysql > DROP DATABASE db_name -- delete and view the database storage engine, use the database, view the currently used database mysql > SHOW ENGINES;-- view the storage engine mysql > USE db_name;-- use the database mysql > SELECT DATABASE ();-- View the data tables in the current database display library mysql > USE db_name;-- use the database mysql > SHOW TABLES -- display data tables create and delete data tables mysql > CREATE TABLE [IF NOT EXISTS] table_name (column_name column_type...)-create mysql > DROP TABLE table_name;-- delete the structure of viewing data tables mysql > DESC table_name;mysql > DESCRIBE table_name;mysql > EXPLAIN table_name;mysql > SHOW COLUMNS FROM table_name Thank you for your reading, these are the contents of "what are the basic SQL sentences commonly used in MYSQL". After the study of this article, I believe you have a deeper understanding of what the basic SQL sentences commonly used in MYSQL have, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.