[asterisk-users] create table in mysql using asterisk
Eyal
eyal at mcr-m.com
Mon Jan 9 01:44:36 CST 2012
Hi,
I try to create a new table using MYSQL command in asterisk.
This is what i write:
Query resultid ${connid} CREATE TABLE IF NOT EXISTS "conference_600"
("id" int(11) NOT NULL auto_increment, "channel_id" varchar(40),
"number_in_line" int(2), PRIMARY KEY("id")")
and this is the warning that i get in the cli:
app_addon_sql_mysql.c:383 aMYSQL_query: aMYSQL_query: mysql_query
failed. Error: 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 '"conference_600" ("id" int(11) NOT NULL auto_increment,
"channel_id" varchar(40)' at line 1
What is the problem do you think?
Do I in the direction or have a completely different way to do this?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20120109/f72e39cd/attachment.htm>
More information about the asterisk-users
mailing list