MySQL Forums
Forum List  »  Newbie

keyword inserting in table structure
Posted by: roky abm
Date: July 06, 2005 01:43AM

i have been trying to run the following SQL query however the limit is a keyword and hence i cannot insert it.However i cannot change the field name from limit to something else hence need to get a solution on this.Plz help.......

regards
SQL::
CREATE TABLE code_rotator (
id int(11) NOT NULL auto_increment,
title text NOT NULL,
code text NOT NULL,
weight int(11) NOT NULL default '1',
wcount int(11) NOT NULL default '0',
limit int(11) NOT NULL default '0',
tcount int(11) NOT NULL default '0',
dsub varchar(15) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `code_rotator`
--

INSERT INTO code_rotator (id, title, code, weight, wcount, limit, tcount, dsub) VALUES (3,'abc.com','<script language=\\\'JavaScript\\\' type=\\\'text/javascript\\\'\r\nsrc=\\\'http://www.abc.com/swarm/links.pl?id=194000&cat=3&num=5\\\'>\r\n</script>',1,1,0,83787,'');

Options: ReplyQuote


Subject
Written By
Posted
keyword inserting in table structure
July 06, 2005 01:43AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.