//mysqlddl实操createdropdatabse；mysql>showdatabases;+--------------------+|Database|+--------------------+|information_schema||aaz||admin-tp6||cmf||easyadmin||heima||hm||lycms||mysql||newtp||nonecms||performance_schema||pyg||snake||sys||thinkcmf||xhhds||yzncms|+--------------------+18rowsinset(0.01sec)mysql>createdatabasewtes;QueryOK,1rowaffected(0.00sec)mysql>showdatabases;+--------------------+|Database|+--------------------+|information_schema||aaz||admin-tp6||cmf||easyadmin||heima||hm||lycms||mysql||newtp||nonecms||performance_schema||pyg||snake||sys||thinkcmf||wtes||xhhds||yzncms|+--------------------+19rowsinset(0.00sec)mysql>dropdatabasewtes;QueryOK,0rowsaffected(0.01sec)mysql>showdatabases;+--------------------+|Database|+--------------------+|information_schema||aaz||admin-tp6||cmf||easyadmin||heima||hm||lycms||mysql||newtp||nonecms||performance_schema||pyg||snake||sys||thinkcmf||xhhds||yzncms|+--------------------+18rowsinset(0.00sec)mysql>uselycmsDatabasechangedmysql>showtables;+-----------------+|Tables_in_lycms|+-----------------+|v1_ad||v1_banner||v1_collect||v1_column||v1_email_log||v1_kami||v1_say||v1_see_record||v1_tort||v1_user||v1_user_info||v1_vod||v1_vod_actor||v1_vod_director||v1_vod_play||v1_vod_type|+-----------------+16rowsinset(0.00sec)mysql>createtablev1_test(idint(10),namevarchar(8),sextinyint(1));QueryOK,0rowsaffected(0.01sec)mysql>showtables;+-----------------+|Tables_in_lycms|+-----------------+|v1_ad||v1_banner||v1_collect||v1_column||v1_email_log||v1_kami||v1_say||v1_see_record||v1_test||v1_tort||v1_user||v1_user_info||v1_vod||v1_vod_actor||v1_vod_director||v1_vod_play||v1_vod_type|+-----------------+17rowsinset(0.00sec)mysql>descv1_test->;+-------+------------+------+-----+---------+-------+|Field|Type|Null|Key|Default|Extra|+-------+------------+------+-----+---------+-------+|id|int(10)|YES||NULL|||name|varchar(8)|YES||NULL|||sex|tinyint(1)|YES||NULL||+-------+------------+------+-----+---------+-------+3rowsinset(0.01sec)mysql>showcreatetablev1_test;+---------+--------------------------------------------------------------------------------------------------------------------------------------------------------------+|Table|CreateTable|+---------+--------------------------------------------------------------------------------------------------------------------------------------------------------------+|v1_test|CREATETABLE`v1_test`(`id`int(10)DEFAULTNULL,`name`varchar(8)DEFAULTNULL,`sex`tinyint(1)DEFAULTNULL)ENGINE=MyISAMDEFAULTCHARSET=utf8|+---------+--------------------------------------------------------------------------------------------------------------------------------------------------------------+1rowinset(0.00sec)mysql>altertablev1_testmodifynamevarchar(12);QueryOK,0rowsaffected(0.01sec)Records:0Duplicates:0Warnings:0mysql>showcreatetablev1_test->;+---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------+|Table|CreateTable|+---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------+|v1_test|CREATETABLE`v1_test`(`id`int(10)DEFAULTNULL,`name`varchar(12)DEFAULTNULL,`sex`tinyint(1)DEFAULTNULL)ENGINE=MyISAMDEFAULTCHARSET=utf8|+---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------+1rowinset(0.00sec)mysql>altertablev1_testaddagetinyint;QueryOK,0rowsaffected(0.01sec)Records:0Duplicates:0Warnings:0mysql>showcreatetablev1_test;+---------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+|Table|CreateTable|+---------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+|v1_test|CREATETABLE`v1_test`(`id`int(10)DEFAULTNULL,`name`varchar(12)DEFAULTNULL,`sex`tinyint(1)DEFAULTNULL,`age`tinyint(4)DEFAULTNULL)ENGINE=MyISAMDEFAULTCHARSET=utf8|+---------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+1rowinset(0.00sec)mysql>altertablev1_testnameunamevarchar(12);ERROR1064(42000):YouhaveanerrorinyourSQLsyntax;checkthemanualthatcorrespondstoyourMySQLserverversionfortherightsyntaxtousenear'nameunamevarchar(12)'atline1mysql>altertablev1_testmodifynameunamevarchar(12);ERROR1064(42000):YouhaveanerrorinyourSQLsyntax;checkthemanualthatcorrespondstoyourMySQLserverversionfortherightsyntaxtousenear'unamevarchar(12)'atline1mysql>altertablev1_testchangenameunamevarchar(12);QueryOK,0rowsaffected(0.00sec)Records:0Duplicates:0Warnings:0mysql>altertablev1_testdropage;QueryOK,0rowsaffected(0.01sec)Records:0Duplicates:0Warnings:0mysql>showcreatetablev1_test;+---------+----------------------------------------------------------------------------------------------------------------------------------------------------------------+|Table|CreateTable|+---------+----------------------------------------------------------------------------------------------------------------------------------------------------------------+|v1_test|CREATETABLE`v1_test`(`id`int(10)DEFAULTNULL,`uname`varchar(12)DEFAULTNULL,`sex`tinyint(1)DEFAULTNULL)ENGINE=MyISAMDEFAULTCHARSET=utf8|+---------+----------------------------------------------------------------------------------------------------------------------------------------------------------------+1rowinset(0.00sec)mysql>altertablev1_testaddagetinyintbeforesex;ERROR1064(42000):YouhaveanerrorinyourSQLsyntax;checkthemanualthatcorrespondstoyourMySQLserverversionfortherightsyntaxtousenear'beforesex'atline1mysql>altertablev1_testaddagetinyintafteruname;QueryOK,0rowsaffected(0.01sec)Records:0Duplicates:0Warnings:0mysql>altertablev1_testuidint(11)first;ERROR1064(42000):YouhaveanerrorinyourSQLsyntax;checkthemanualthatcorrespondstoyourMySQLserverversionfortherightsyntaxtousenear'uidint(11)first'atline1mysql>altertablev1_testadduidint(11)first;QueryOK,0rowsaffected(0.01sec)Records:0Duplicates:0Warnings:0mysql>showcreatetablev1_test;+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+|Table|CreateTable|+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+|v1_test|CREATETABLE`v1_test`(`uid`int(11)DEFAULTNULL,`id`int(10)DEFAULTNULL,`uname`varchar(12)DEFAULTNULL,`age`tinyint(4)DEFAULTNULL,`sex`tinyint(1)DEFAULTNULL)ENGINE=MyISAMDEFAULTCHARSET=utf8|+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+1rowinset(0.00sec)mysql>altertablev1_testrenametest;QueryOK,0rowsaffected(0.00sec)mysql>showcreatetableest;ERROR1146(42S02):Table'lycms.est'doesn'texistmysql>showcreatetabletest;+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+|Table|CreateTable|+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+|test|CREATETABLE`test`(`uid`int(11)DEFAULTNULL,`id`int(10)DEFAULTNULL,`uname`varchar(12)DEFAULTNULL,`age`tinyint(4)DEFAULTNULL,`sex`tinyint(1)DEFAULTNULL)ENGINE=MyISAMDEFAULTCHARSET=utf8|+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+1rowinset(0.00sec)mysql>createindexid_indexontest(id);QueryOK,0rowsaffected(0.01sec)Records:0Duplicates:0Warnings:0mysql>createuniqueindexuid_oontest(uid);QueryOK,0rowsaffected(0.01sec)Records:0Duplicates:0Warnings:0mysql>showcreatetabletest;+-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+|Table|CreateTable|+-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+|test|CREATETABLE`test`(`uid`int(11)DEFAULTNULL,`id`int(10)DEFAULTNULL,`uname`varchar(12)DEFAULTNULL,`age`tinyint(4)DEFAULTNULL,`sex`tinyint(1)DEFAULTNULL,UNIQUEKEY`uid_o`(`uid`),KEY`id_index`(`id`))ENGINE=MyISAMDEFAULTCHARSET=utf8|+-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+1rowinset(0.00sec)mysql>dropindexid_indexontest;QueryOK,0rowsaffected(0.01sec)Records:0Duplicates:0Warnings:0mysql>showcreatetabletest;+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+|Table|CreateTable|+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+|test|CREATETABLE`test`(`uid`int(11)DEFAULTNULL,`id`int(10)DEFAULTNULL,`uname`varchar(12)DEFAULTNULL,`age`tinyint(4)DEFAULTNULL,`sex`tinyint(1)DEFAULTNULL,UNIQUEKEY`uid_o`(`uid`))ENGINE=MyISAMDEFAULTCHARSET=utf8|+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+1rowinset(0.00sec)mysql>showindexfromtest;+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+|Table|Non_unique|Key_name|Seq_in_index|Column_name|Collation|Cardinality|Sub_part|Packed|Null|Index_type|Comment|Index_comment|+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+|test|0|uid_o|1|uid|A|NULL|NULL|NULL|YES|BTREE|||+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+1rowinset(0.00sec)mysql>showindexfromtest\G;***************************1.row***************************Table:testNon_unique:0Key_name:uid_oSeq_in_index:1Column_name:uidCollation:ACardinality:NULLSub_part:NULLPacked:NULLNull:YESIndex_type:BTREEComment:Index_comment:1rowinset(0.00sec)ERROR:Noqueryspecifiedmysql>//mysqlDML实操mysql>insertintotest(uid,id,uname,age,sex)values(1,1,'yyds',11,1);QueryOK,1rowaffected(0.01sec)mysql>select*fromtest;+------+------+-------+------+------+|uid|id|uname|age|sex|+------+------+-------+------+------+|1|1|yyds|11|1|+------+------+-------+------+------+1rowinset(0.00sec)mysql>insertintotest(uid,id,uname,age,sex)values(2,2,'yyds',11,1);QueryOK,1rowaffected(0.00sec)mysql>select*fromtest;+------+------+-------+------+------+|uid|id|uname|age|sex|+------+------+-------+------+------+|1|1|yyds|11|1||2|2|yyds|11|1|+------+------+-------+------+------+2rowsinset(0.00sec)mysql>deletefromtestwhereuid=2;QueryOK,1rowaffected(0.00sec)mysql>select*fromtest;+------+------+-------+------+------+|uid|id|uname|age|sex|+------+------+-------+------+------+|1|1|yyds|11|1|+------+------+-------+------+------+1rowinset(0.00sec)mysql>updatetestsetuname='xswl'whereid=1;QueryOK,1rowaffected(0.00sec)Rowsmatched:1Changed:1Warnings:0mysql>select*fromtest;+------+------+-------+------+------+|uid|id|uname|age|sex|+------+------+-------+------+------+|1|1|xswl|11|1|+------+------+-------+------+------+1rowinset(0.00sec)

创建一张用户表

mysql>createtableuser(->uidint(10)notnullauto_incrementcomment'用户ID',->unamevarchar(10)notnull,->pwdchar(32)notnull,->sextinyint(1)notnull,->agetinyintnotnull,->telchar(11)notnull,->create_timeint(10)notnull,->update_timeint(10)notnull,->PRIMARYKEY(`uid`),->UNIQUEKEY(`uname`)->)engine=innodbauto_increment=20001defaultcharset=utf8;QueryOK,0rowsaffected(0.02sec)mysql>showcreatetableuser;+-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+|Table|CreateTable|+-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+|user|CREATETABLE`user`(`uid`int(10)NOTNULLAUTO_INCREMENTCOMMENT'用户ID',`uname`varchar(10)NOTNULL,`pwd`char(32)NOTNULL,`sex`tinyint(1)NOTNULL,`age`tinyint(4)NOTNULL,`tel`char(11)NOTNULL,`create_time`int(10)NOTNULL,`update_time`int(10)NOTNULL,PRIMARYKEY(`uid`),UNIQUEKEY`uname`(`uname`))ENGINE=InnoDBAUTO_INCREMENT=20001DEFAULTCHARSET=utf8|+-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+1rowinset(0.00sec)mysql>


更多相关文章

  1. 实例演绎pdo在用户登录环节是怎么防sql注入及实战预处理与会话跟
  2. 总结mysql 常用DDL, DML语言并实操;
  3. 一个前端后端的综合实例
  4. 创建用户表
  5. 完成一个用户注册页面，对表单字段进行验证（密码长度、密码一致、验
  6. php简单实现模拟用户登陆验证
  7. PHP模拟用户登陆验证
  8. 完成一个用户注册页面, 用xmind文件中总结的字符串函数库,对表单
  9. zy0809

随机推荐

  1. Android 驱动开发文章收录
  2. android 默认浏览器 无法下载，此手机不支
  3. 【30篇突击 android】源码统计 十三
  4. android ATD configeration
  5. android之屏幕适配之一理论知识
  6. android传感器总结
  7. 【Demo实例】Android FTP上传带进度条（优
  8. Android通过http协议POST传输方式(输出流
  9. 使用InjectView和findViewById说拜拜
  10. Android SDK 源码解析项目