摘要： 1。Mysql默认情况下不区分大小写。如何设置区分大小写： my.ini：在mysqld节下加入下面一行 set-variable=lower_case_table_names=0 （0：大小写敏感；1：大小写不敏感）重启一下MySql服务。2。执行sql：；+ 回车。3。show databases;4. use database name;5. show tables;6. create table table_Name(id int, name varchar(20));..... 阅读全文

摘要： 代码Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--declare@Temptable(Codevarchar(10),IDint,SIntint)insertinto@Temp(Code,ID,SInt)select'01',1,3unionselect'01',2,3unionselect'01',2,3unionselect'02',1,3unionselect'02',3,5unionselect'02',2,6unionselect'03 阅读全文