MYSQL
liuwzh
这个作者很懒,什么都没留下…
展开
-
MySQL Error Number 1045 Access denied
mysql -u root -p GRANT ALL on *.* to 'new_user'@'192.168.22.10' IDENTIFIED BY 'new_user_password';原创 2010-09-13 00:21:00 · 366 阅读 · 0 评论 -
MySQL中设置Auto Increment的值
ALTER TABLE tablename AUTO_INCREMENT =1tablename就是需要重置auto_increment的表原创 2010-10-04 12:30:00 · 1770 阅读 · 0 评论 -
csv to mysql
LOAD DATA INFILE '/home/xxxxx/source/xxxxx.csv' INTO TABLE t_shop FIELDS TERMINATED BY ',' LINES TERMINATED BY '/n' (SHOP_ID,SHOP_NM);原创 2010-10-19 19:23:00 · 314 阅读 · 0 评论