Start MySQL
- start service:
sudo service mysql start
- login:
mysql-u root
New Database
-
CREATE Database < databases name;; The
- is not case-sensitive in most SQL systems, but it is customary to keep uppercase letters, variables and data lowercase
Connect to database
-
use < database name;
- display: Database changed, indicating successful connection
datasheet
- data table is a database The component is where the data resides in the database
- new data table:
CREATE table < table name > (< column name 1> data type (data length),< column name 2> data type (data length), ... . );
Insert Data
INSERT into table name (column name 1, column name 2,...) Values (value 1, value 2,...)
Data type
- int,float,double,enum,set,char,varchar,text,date,time,year
- data type int,float,double The data does not need to use single quotes ' ' Parcels, the rest of the data types, such as Char,varchar,text,enum,date's data need to be wrapped in single quotes
MySQL CREATE DATABASE and insert data
