hino wrote:
- Original Message - From: "Jeff" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, November 29, 2005 11:42 AM
Subject: Insert query problem
All,
I can't get this query to run, it keeps compaining that there is a
problem:
The Query:
insert into
tickets
(id,from,dep
- Original Message -
From: "Jeff" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, November 29, 2005 11:42 AM
Subject: Insert query problem
All,
I can't get this query to run, it keeps compaining that there is a
problem:
The Query:
insert into
tickets(id,from,de
You can use backticks ( ` ) to escape the names:
INSERT INTO `tickets` ( `id` , `from` , `departement` .
hth,
melanie
From: "Jeff" <[EMAIL PROTECTED]>
To:
Subject: Insert query problem
Date: Tue, 29 Nov 2005 11:42:34 -0500
All,
I can't get this query to run, it
Many Many wrong SQL syntax error check your symbol (') becareful it 'very
important .
You can do that.
Cheer!!
From: "Jeff" <[EMAIL PROTECTED]>
To:
Subject: Insert query problem
Date: Tue, 29 Nov 2005 11:42:34 -0500
All,
I can't get this query to run, it k
Jeff wrote:
tickets(id,from,department,subject,body,lastaction,lastpost,priority,sta
tus,created,fromname,lastpostname,attach,ct,uniq,notify,replyto)
values(null,'jmckeon','1','test','test
test',unix_timestamp(now()),'"[EMAIL PROTECTED]"
<[EMAIL PROTECTED]>','Medium','Open',unix_timestamp(now())
Nevermind, found that usig `from` works.
Jeff
> -Original Message-
> From: Jeff [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 29, 2005 11:43
> To: mysql@lists.mysql.com
> Subject: Insert query problem
>
>
> All,
>
> I can't get this query to
"Jeff" <[EMAIL PROTECTED]> wrote on 11/29/2005 11:42:34 AM:
> All,
>
> I can't get this query to run, it keeps compaining that there is a
> problem:
>
> The Query:
>
> insert into
> tickets(id,from,department,subject,body,lastaction,lastpost,priority,sta
> tus,created,fromname,lastpostname,atta
All,
I can't get this query to run, it keeps compaining that there is a
problem:
The Query:
insert into
tickets(id,from,department,subject,body,lastaction,lastpost,priority,sta
tus,created,fromname,lastpostname,attach,ct,uniq,notify,replyto)
values(null,'jmckeon','1','test','test
test',unix_time
Hi,
I have FreeBSD 5.1beta with mysql 4.0.13.
When I try to insert 18MB data into myisam table using command "mysql emls
< big_query", it says "Error 1030 (Got error 12 from table handler)". After
that myisam table crashes and I have to run mysqlcheck command to fix the
index.
The query is on
