MYSQL _ common database commands

MYSQL _ common database commands 1. log on to www.2cto.com $ mysql -- user = root -- password = xxxxxx 2. database Operations list all databases mysql> show databases; create database mysql> create database x123; delete database mysql> drop database x123; connect to and use database mysql> use x123; 3. data table operation display data table mysql> show tables; create data table mysql> create table mytable (name VARCHAR (20), sex CHAR (1), birth DATE); display mysql> describe mytable; insert data into the table mysql> insert into mytable values ('xieyan ', 'F', '2017-01-01 '); for specific conditions, find mysql> select * from mytable where sex = "f"; for Fuzzy conditions, find mysql> select * from mytable where name like "% xie % "; delete the data table mysql> drop table mytable; read and insert data from the TXT file. SAE does not support the load data command (TXT file format: Use spaces to separate fields, and use line breaks to separate records) mysql> load data local infile "testme.txt" into table mytable;