qq_30359677的博客

1、进入MySQLmysql -y root -p2、查看数据库show databases;3、创建数据库create database if not exists db_namedefault character set utf8mb4collate utf8mb4_unicode_ci;4、修改数据库alter database db_namedefault ...

1、插入数据1、insert …valuesinsert into mysql_test.customersvalue(901,'zhangsan','f','beijing','chaoyang');2、insert…setinsert into mysql_test.customersset cust_name='lisi',cust_add='wuhan';3、inse...

1、创建表create table customers(cust_id int not null auto_increment,cust_name char(50) not null,cust_sex char(1) not null default 0,cust_add char(50) null,cust_contact char(50) null,primary key(cu...

1、索引的定义普通索引 （index或key）唯一性索引 （unique)主键 （primary key）2、用create index 创建索引create index index_custon mysql_test.customers(cust_name,sex);3、用alter table 创建索引alter table mysql_test.tb_stuadd ...