Mysql Common commands

Mysql Common commands
Mysql operation connection Mysql $ mysql-h host address-u user name-p password Reset mysql user password update user set password = password ("password") where user = 'username '; the Database operation displays show databases for all databases. enter the name of a database use database. create Database <database Name> delete database <Database Name> Table operation displays show tables for all tables; create a new table create table name (Field List); delete the drop table Name; clear the table record: delete from table name; display the table record: select * from table name; insert into <Table Name> [(<field name 1> [,.. <field name n>])] values (Value 1) [, (value n)] update field content update table name set field name = add field alter table name add field type in the table; modify the rename table original table name to the new table name. Of course, these operations can be more intuitive through the GUI, but after all, commands are the basis, only by understanding the commands can you understand how the GUI runs and how it works.