1.数据库
新建
create database myDatabase
删除
drop database myDatabase
2.表
新建表:
CREATE TABLE `my_table` (
`cid` int(11) UNSIGNED NOT NULL AUTO_INCREMENT ,
`class_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '分类名称' ,
`class_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL ,
`class_conf` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL ,
`uid` int(11) UNSIGNED NOT NULL COMMENT '用户ID' ,
`update_at` datetime NOT NULL COMMENT '更新时间' ,
PRIMARY KEY (`cid`),
UNIQUE INDEX `class_name` (`class_name`) USING BTREE
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci
AUTO_INCREMENT=8
CHECKSUM=0
ROW_FORMAT=DYNAMIC
DELAY_KEY_WRITE=0
;
添加字段:
ALTER TABLE tableName ADD NAME VARCHAR(255) default '';
ALTER TABLE tableName ADD ID int unsgned not null auto-increment primary key;
ALTER TABLE ipc ADD mac1 VARCHAR(50) DEFAULT '';
......
修改字段:
......
删除字段:
ALTER TABLE tableName DROP NAME;
......
添加、删除索引:
1.添加、删除primary key
ALTER TABLE `table_name` ADD PRIMARY KEY ( `column` );// 添加
ALTER TABLE `table_name` DROP PRIMARY KEY; // 删除
2.添加、删除index索引
ALTER TABLE table_name ADD index(c_name); // 添加
ALTER TABLE table_name DROP index c_name; // 删除
3.添加联合索引
4.添加、删除unique索引
ALTER TABLE table_name ADD unique(c_name); // 添加
ALTER TABLE table_name DROP unique c_name; // 删除
修改索引:
......
密码修改:
mysqladmin -u用户名 -p旧密码 password 新密码
或进入mysql命令行
SET PASSWORD FOR '用户名'@'主机' = PASSWORD(‘密码');
创建新用户并授权:
grant all privileges on *.* to 用户名@'%' identified by '密码' with grant option;