MySql command line client command Series Analysis

1. Start and Exit 1. Enter MySQL: Start MySQL Command Line Client (DOS interface of MySQL) and enter the password for installation. At this time, the prompt is: mysql & gt; 2. exit MySQL: quit or exit 2. database operation 1. create database Command: create database for example: create a database named xhkdb mysql> create database xhkdb; 2. Display All database commands: show databases (Note: There is finally s) mysql> show databases; 3. delete database command: drop database For example: delete database mysql> drop database xhkdb; 4. Connect database command: use for example: if the xhkdb database exists, try to access it: mysql> use xhkdb; www.2cto.com screen prompt: Database changed 5. currently selected (connected) database mysql> select Database (); 6. Table information contained in the current database: Mysql> show tables; (Note: There is a last s) 3. Perform table operations. before the operation, connect to a database. 1. Run the table creation command: create table ([,...]); mysql> create table 'testa '(-> 'id' int (10) unsigned not null AUTO_INCREMENT,-> 'name' varchar (20) default null, -> primary key ('id') www.2cto.com->) ENGINE = MyISAM AUTO_INCREMENT = 65 default charset = utf8; 2. Table Structure command: desc table name, or show columns from table name mysql> DESCRIBE MyClass mysql> desc MyClass; mysql> show colum Ns from MyClass; 3. Delete table command: drop table example: delete a table named MyClass mysql> drop table MyClass; 4. insert Data command: insert into [([,...])] values (value 1) [, (value n)] 5. query the data in the table 1). query all rows. mysql> select * from MyClass; 2) mysql> select * from MyClass order by id limit; www.2cto.com 6. delete table data command: delete from table name where expression example: delete mysql> delete from MyClass where id = 1; 7. Modify Table data: update table name set field = new value ,... Where condition mysql> update MyClass set name = "Mary" where id = 1; 8. add a field to the table: Command: alter table name add field type other; for example: A passtest field is added to the MyClass table and the type is int (4). The default value is 0 mysql> alter table MyClass add passtest int (4) default "0" 9. Change table name: Command: rename table original table name to new table name; for example, in the table MyClass name changed to YouClass mysql> rename table MyClass to YouClass; Author: crystalwiner