主页 / user-40918

Karthick's questions

Martin Hope
Karthick
Asked: 2014-08-04 23:10:09 +0800 CST
  • 5

我在尝试 ping 时在 mysql 中收到以下错误。我正在使用 mysql 版本 5.5.37-0ubuntu0.12.04.1。每当我使用 mysqladmin 时，都会出现以下错误。

请建议如何清除此问题

karthick.g.s@sumtwo:~$ mysqladmin -u root -p ping
Warning: mysqladmin: unknown variable 'loose-local-infile=1'
mysqladmin: unknown variable 'local-infile=1'
mysql-5.5 mysqladmin
Martin Hope
Karthick
Asked: 2014-08-01 23:37:23 +0800 CST
  • 3

嗨，我需要将表的自动增量设置为 S1。我尝试通过更改表并通过新表创建我知道如何设置 auto_increment 但是当我尝试将自动增量设置为 S1 时我无法做到。因为我需要主键值应该是 S1,S2,S3 如下记录。任何人都可以为此建议数据类型，

 desc test_1;
+-------+--------------+------+-----+---------+-------+
| Field | Type         | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+-------+
| id    | varchar(10)  | NO   | PRI | NULL    |       |
| name  | varchar(100) | NO   |     | NULL    |       |
+-------+--------------+------+-----+---------+-------+
2 rows in set (0.00 sec)

mysql> ALTER TABLE test_1 AUTO_INCREMENT='S1';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''S1'' at line 1

mysql> create table tbl(ID varchar(100) not null primary key auto_increment,name varchar(100)) auto_increment='s1';
ERROR 1063 (42000): Incorrect column specifier for column 'ID'
mysql> create table tbl(ID text not null primary key auto_increment,name varchar(100)) auto_increment='s1';
ERROR 1063 (42000): Incorrect column specifier for column 'ID'
mysql> create table tbl(ID varchar(100) not null primary key auto_increment,name varchar(100)) auto_increment='s';
ERROR 1063 (42000): Incorrect column specifier for column 'ID'
mysql mysql-5.5
Martin Hope
Karthick
Asked: 2014-07-19 23:44:46 +0800 CST
  • 1

也通过了下面的链接，但我无法在 mysql 中导入 CSV 文件。即使我尝试过使用 > LOAD DATA LOCAL INFILE 但同样的错误仍然存​​在。请帮助我。我尝试过的查询已在下面附加

MySQL import csv 只得到一半的行

mysql> LOAD DATA INFILE 'home/karthick.g.s/Desktop/karthick.csv'
    -> INTO TABLE test_1
    -> FIELDS TERMINATED BY ','
    -> ENCLOSED BY '^' 
    -> LINES TERMINATED BY '\r\n';
ERROR 13 (HY000): Can't get stat of '/var/lib/mysql/home/karthick.g.s/Desktop/karthick.csv' (Errcode: 2)
mysql> LOAD DATA LOCAL INFILE 'home/karthick.g.s/Desktop/karthick.csv'
    -> INTO TABLE test_1
    -> FIELDS TERMINATED BY ','
    -> ENCLOSED BY '^'
    -> LINES TERMINATED BY '\r\n';
ERROR 1148 (42000): The used command is not allowed with this MySQL version

我正在使用版本 5.5.37-0ubuntu0.12.04.1

mysql-5.5 csv