Mysql学习——数据库基础操作（1）

CREATE DATABASE 数据库名; 例如：CREATE DATABASE TEST_DB;

drop database 数据库名;
例如：drop database TEST_DB;

use 数据库名;
use TEST_DB;

CREATE TABLE 表名(列名 数据类型);

CREATE TABLE IF NOT EXISTS `User`(
   `User_id` INT UNSIGNED AUTO_INCREMENT,
   `User_Name` VARCHAR(100) NOT NULL,
   `Address` VARCHAR(40) NOT NULL,
   `Create_Time` DATE,
   PRIMARY KEY ( `User_id` )
)ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE 表名;

DROP TABLE User;

INSERT INTO 表名( field1, field2,...fieldN )
                       VALUES
                       ( value1, value2,...valueN );

INSERT INTO User( User_Name, Address,Create_Time)
                       VALUES
                       ( 'admin','天津','2020-03-30');

SELECT User_Name,Address,Create_Time
FROM User
where User_Name='admin'

UPDATE table_name SET field1=new-value1, field2=new-value2
[WHERE Clause]

UPDATE User SET User_Name='Test'
WHERE Address='天津'

DELETE FROM table_name [WHERE Clause]

DELETE FROM User WHERE UserName='admin'