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 run, it keeps compaining that there is a > problem: > > The Query: > > insert into > tickets(id,from,department,subject,body,lastaction,lastpost,pr > iority,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()),'Jeff > McKeon','Jeff McKeon','','','ks5hslajdfasd','1','[EMAIL PROTECTED]') > > The error: > > You have an error in your SQL syntax near > 'from,department,subject,body,lastaction,lastpost,priority,sta > tus,create > d,fromnam' at line 1 > > I suspect it doesn't like the fact that I have a field named > "from" but I KNOW it's possible to write to this table and > that field, I just can't figure out the correct syntax to get > it to accept the fieldname "from". > > Thanks, > > Jeff > > > > -- > > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?> [EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
