创建连接mysql -uroot -p //mysql连接创建数据库CREATE DATABASE 数据库名;mysqladmin -u root -p create RUNOOB删除数据库mysqladmin -u root -p drop RUNOOB//drop database RUNOOB;//
选取了数据库 use RUNOOB;创建MySQL数据表CREATE TABLE table_name (column_name column_type);
CREATE TABLE IF NOT EXISTS `runoob_tbl`( `runoob_id` INT UNSIGNED AUTO_INCREMENT, `runoob_title` VARCHAR(100) NOT NULL, `runoob_author` VARCHAR(40) NOT NULL, `submission_date` DATE, PRIMARY KEY ( `runoob_id` ))ENGINE=InnoDB DEFAULT CHARSET=utf8;描述表desc table_name;show tables;删除MySQL数据表DROP TABLE table_name ;查看表字段信息SHOW COLUMNS FROM testalter_tbl;添加/删除字段ALTER TABLE testalter_tbl ADD i INT;ALTER TABLE testalter_tbl ADD i INT AFTER c;ALTER TABLE testalter_tbl DROP i;修改字段类型及名称ALTER TABLE testalter_tbl MODIFY c CHAR(10);修改表名ALTER TABLE testalter_tbl RENAME TO alter_tbl;
创建索引CREATE INDEX indexName ON mytable(username(length)); 修改表结构(添加索引)ALTER table tableName ADD INDEX indexName(columnName)DROP INDEX [indexName] ON mytable; 显示索引信息SHOW INDEX FROM table_name;
转载于:https://www.cnblogs.com/dream98/p/11179479.html
