摘要：alter table bill CONVERT TO CHARACTER SET utf8mb4;https://www.cnblogs.com/liushao/p/6370326.html 阅读全文

摘要：--导入大文件50G文件到mysql1、修改配置innodb_flush_log_at_trx_commit=0 2、导入时的注意事项set autocommit=1;show variables like 'autocommit';set names utf8;source f://file.sq 阅读全文

摘要：1 关闭MySQL服务 2 用*/bin/mysqld-nt.exe 启动进程 ---注意此处是mysqld-nt3 运行命令：mysqld-nt --skip-grant-tables 4 >use mysql; >update user set password=password('soft'); 5 关闭mysqld-nt进程,重启mysql服务运行 mysql -u root -p 123 即可。 阅读全文

摘要：select FROM_UNIXTIME(1291345910,'%Y-%m-%d %h:%i:%s'); 阅读全文

摘要：备份：mysqldump -uroot -psoft bugs >bugs0610.sql还原：mysql -uroot -psoft bugs<bugs0610.sql 阅读全文

摘要：下载文件：/Files/kuailewangzi1212/绿色版mysql.rar MySql绿色版安装 1、解压MySQL Server 5.1.rar到MySQL Server 5.1目录下 2、修改MySQL Server 5.1文件夹下my.ini文件 basedir="G:/MySql/MySQL Server 5.1/" datadir="G:/MySql/MySQL Server 5.1/Data/" 将目录修改正确 3、执行bin目录下的install.cmd文件 4、启... 阅读全文

摘要：1、mysql的安装目录下my.ini文件有两处修改default-character-set=gb2312或者utf8或gbk2、运行命令 set names gb2312;3、表字段(字符类型)要修改字符集ALTER TABLE `test`.`tt` MODIFY COLUMN `name` VARCHAR(100) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci DEFAULT NULL; 阅读全文

摘要：create view SystemInfoasSELECT table_name,ordinal_position as colorder,column_name as colName, case extra when 'auto_increment' then 1 else 0 end as IsIdentity, case column_key when 'pri' then 1 else 0 end as isKey, data_type as type,0 as bits, case when character_maximum_length is N 阅读全文

摘要：使用方法call USP_P_SPLITPAGE 'select * from tt',1,10;------------------------DELIMITER $$DROP PROCEDURE IF EXISTS `USP_P_SPLITPAGE` $$CREATE DEFINER=`root`@`localhost` PROCEDURE `USP_P_SPLITPAGE`(`sql` varchar(1024),pagesize int,CURRENTPAGE int)BEGIN SET @skip= (CURRENTPAGE - 1 )* pagesize ; SET 阅读全文