JAVA

1，循环插入数据 DROP PROCEDURE IF EXISTS test_insert; DELIMITER ;; CREATE PROCEDURE testtt_insert () BEGIN DECLARE i INT DEFAULT 1; while i<11001 do --插入语句 set i = i+1; end while; commit; end;; call test_insert(); DROP PROCEDURE IF EXISTS test_insert..

mysql5.5以上使用cmake   下载source  code 下 mysql-5.5.**.tar.gz   一、一些依赖 1.安装make编译器 下载地址： http://www.gnu.org/software/make/ [c-sharp] view plaincopy   tar zxvf make-3.82.tar.gz   cd make

一、插入中文乱码，查看编码 show VARIABLES like 'character_set%'   character_set_client utf8 character_set_connection utf8 character_set_database utf8 character_set_filesystem binary character_set_results ut

mysql -u root -p #输入密码MySQL 5.7.6 and later:ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass'; MySQL 5.7.5 and earlier:SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPass');