qmail 관련 mysql 오류입니다....도와주세요...
글쓴이: samskara / 작성시간: 수, 2003/08/27 - 3:18오후
리눅스 관련 사항은 초보라서 이렇게 도움을 다시 한번 구하고자 합니다...
아래와 같은 메세지가 나타납니다...
[root@khol /]# mysql -u root -p qmail
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 35 to server version: 3.23.41
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> insert into users(id,crypt,name,uid,gid,shell,home,start_date) value('asline',encrypt('9999'),'asline12','9999',1250,1000,'/bin/false','/user2/mail01/asline','2003-08-27');
ERROR 1064: You have an error in your SQL syntax near 'value('asline',encrypt('9999'),'asline12','9999',1250,1000,'/bin/false','/user2/' at line 1
Forums:
database 올려드립니다...도와 주세요....
mysql> desc user;
+-------------+---------------------+------+-----+------------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+---------------------+------+-----+------------+-------+
| id | varchar(32) | | PRI | | |
| crypt | varchar(32) binary | | | | |
| passwd | varchar(32) binary | | | | |
| name | varchar(50) | | | | |
| uid | int(10) unsigned | | | 65534 | |
| gid | int(10) unsigned | | | 65534 | |
| shell | varchar(100) binary | | | | |
| home | varchar(100) binary | | | | |
| start_date | date | | MUL | 0000-00-00 | |
| expire_date | date | | MUL | 3000-12-31 | |
| active | enum('Y','N') | | MUL | Y | |
| quota_size | int(10) unsigned | | | 0 | |
| signature | tinytext | YES | | NULL | |
| ip | varchar(20) | YES | | NULL | |
+-------------+---------------------+------+-----+------------+-------+
14 rows in set (0.00 sec)
여기까지는 접근을 했습니다....
mysql> insert into users(id,crypt,passwd,name,uid,gid,shell,home,start_date)
-> values('test',encrypt('9999'),'9999','test','9999',1250,1000,'/bin/false','/user2/mail01/test','2003-08-27');
ERROR 1146: Table 'qmail.users' doesn't exist
mysql>
한참을 봤습니당. 뭐가 문제가 있나~~^^table 이름
한참을 봤습니당. 뭐가 문제가 있나~~
^^
table 이름이 user입니까? users입니가?
users란 table은 없는것 같습니다. user table은 있는것 같구요..
그럼.~~
void main()
{
printf("Hello World\n");
exit(0);
}
/* 초심으로 돌아가자~~~~~ */
댓글 달기