https://blog.csdn.net/HackProgramerzh-cnhttps://blog.csdn.net/https://blog.csdn.net/HackProgramer/article/details/38701389https://blog.csdn.net/HackProgramer/article/details/38701389HackProgramerWed, 20 Aug 2014 09:07:06 +0800https://blog.csdn.net/HackProgramer/article/details/38676757https://blog.csdn.net/HackProgramer/article/details/38676757HackProgramerTue, 19 Aug 2014 07:58:16 +0800https://blog.csdn.net/HackProgramer/article/details/38662857https://blog.csdn.net/HackProgramer/article/details/38662857HackProgramerMon, 18 Aug 2014 16:46:52 +0800https://blog.csdn.net/HackProgramer/article/details/38661985https://blog.csdn.net/HackProgramer/article/details/38661985HackProgramerMon, 18 Aug 2014 15:56:03 +0800https://blog.csdn.net/HackProgramer/article/details/38661735https://blog.csdn.net/HackProgramer/article/details/38661735HackProgramerMon, 18 Aug 2014 15:45:21 +0800     作用：保持数据的完整性（要成功全部成功、要失败全部失败） 特点：原子性（事物的最小单位，不再被分隔）、一致性、隔离性（如远程操作数据，本地也在开，也就是多个事物间是相对独立的，互不影响的）、持久性     特征 原子性：事务是不可分割的最小单位 一致性：事务中的多个操作最终状态是一致的 隔离性：同一数据库多个事务彼此间是独立的]]>https://blog.csdn.net/HackProgramer/article/details/38661757https://blog.csdn.net/HackProgramer/article/details/38661757HackProgramerMon, 18 Aug 2014 15:44:12 +0800update user set password=password('new password') where user='root'; change password-->这其实是在操作mysql里自带的一张表  里面专门用来存用户的   主键约束---->唯一     一张表最多一个，最少零个，不能为空 自]]>https://blog.csdn.net/HackProgramer/article/details/38660823https://blog.csdn.net/HackProgramer/article/details/38660823HackProgramerMon, 18 Aug 2014 14:56:51 +0800https://blog.csdn.net/HackProgramer/article/details/38660727https://blog.csdn.net/HackProgramer/article/details/38660727HackProgramerMon, 18 Aug 2014 14:54:00 +0800 脚本名;     导出整个数据库结构和数据 mysqldump -h localhost -uroot -p123456 database > dump.sql   导出单个数据表结构和数据 mysqldump -h localhost -uroot -p12345]]>https://blog.csdn.net/HackProgramer/article/details/38660711https://blog.csdn.net/HackProgramer/article/details/38660711HackProgramerMon, 18 Aug 2014 14:53:30 +0800use 数据库 　　然后施用source号令，后面参数为脚本文件（如这里用到的.sql） 　　mysql>source d:\chai.sql   修改表结构： alter table behaviour（表名） m]]>https://blog.csdn.net/HackProgramer/article/details/38619267https://blog.csdn.net/HackProgramer/article/details/38619267HackProgramerSat, 16 Aug 2014 21:59:02 +0800https://blog.csdn.net/HackProgramer/article/details/38610863https://blog.csdn.net/HackProgramer/article/details/38610863HackProgramerSat, 16 Aug 2014 10:17:53 +0800https://blog.csdn.net/HackProgramer/article/details/38592131https://blog.csdn.net/HackProgramer/article/details/38592131HackProgramerFri, 15 Aug 2014 22:07:56 +0800https://blog.csdn.net/HackProgramer/article/details/38591297https://blog.csdn.net/HackProgramer/article/details/38591297HackProgramerFri, 15 Aug 2014 21:49:05 +0800https://blog.csdn.net/HackProgramer/article/details/38588417https://blog.csdn.net/HackProgramer/article/details/38588417HackProgramerFri, 15 Aug 2014 17:41:04 +0800https://blog.csdn.net/HackProgramer/article/details/38587449https://blog.csdn.net/HackProgramer/article/details/38587449HackProgramerFri, 15 Aug 2014 16:42:42 +0800 status; 　　以下是代码片段： 　　mysql> status; 　　-------------]]>https://blog.csdn.net/HackProgramer/article/details/38587485https://blog.csdn.net/HackProgramer/article/details/38587485HackProgramerFri, 15 Aug 2014 16:42:16 +0800 select ASCII('2');     -> 50 mysql> select ASCII(2);     -> 50 mysql> select ASCII('dx');]]>https://blog.csdn.net/HackProgramer/article/details/38583671https://blog.csdn.net/HackProgramer/article/details/38583671HackProgramerFri, 15 Aug 2014 13:15:24 +0800https://blog.csdn.net/HackProgramer/article/details/38561583https://blog.csdn.net/HackProgramer/article/details/38561583HackProgramerThu, 14 Aug 2014 17:31:07 +0800https://blog.csdn.net/HackProgramer/article/details/38561545https://blog.csdn.net/HackProgramer/article/details/38561545HackProgramerThu, 14 Aug 2014 17:29:22 +0800https://blog.csdn.net/HackProgramer/article/details/38561379https://blog.csdn.net/HackProgramer/article/details/38561379HackProgramerThu, 14 Aug 2014 17:22:27 +0800