随笔分类 -  Mysql

linux mysql启动错误
摘要：启动mysql时报错：Starting mysqld daemon with databases from /var/lib/mysqlSTOPPING server from pid file /var/run/mysqld/mysqld.pid071112 00:22:06 mysqld ended查看日志：＃less /var/log/mysqld.log其中有一段如下：071112 0:22:06 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write to file '/var/run/mysqld/mysqld 阅读全文
posted @ 2012-09-04 16:41 小0 阅读(516) 评论(0) 推荐(0)
mysql 语句集
摘要：1.查看MYSQL 数据库编码SHOW VARIABLES LIKE 'character_set_%';mysql> show variables like 'character_set_%';其中，set_connection是连接编码，latin1是瑞典编码。2.导入.TXT文件与导出*.TXTload data infile 'TXT文件的完整路径' into table 表名；linux:TXT文件的完整路径=‘/tmp/aaa.txt’windowns:TXT文件的完整路径='e:\\aaa.txt'.txt的文 阅读全文
posted @ 2011-09-07 19:24 小0 阅读(167) 评论(0) 推荐(0)