Beginner error when creating table

Dev Shed Forums Sponsor:

February 6th, 2012, 03:13 AM

kimmi_baby

Registered User

Join Date: Jun 2010

Posts: 14

Time spent in forums: 6 h 38 m 59 sec
Reputation Power: 0

Beginner error when creating table

I have a database and a table that I'm creating for a joomla component but whenever I install the component I get an error in the database, can someone please tell me what I'm doing wrong?

Code:

DROP TABLE IF EXISTS `#__accordion`;
 
CREATE TABLE `#__accordion` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `greeting` varchar(25) NOT NULL,
   'title' varchar(125) NOT NULL,
   'price' money NOT NULL,
   'description' varchar(125) NOT NULL,
   'image' varchar(125) NOT NULL,
   PRIMARY KEY  (`id`)) 
ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;
 
INSERT INTO '#__accordion' (title, price, description) VALUES ('HTML is the best', '40', 'Book to learn HTML');

There are a few questions I have as well... I'm not too sure what value to set for the image field. I hear the best way to do it is to store a link in the image row... I'm just not sure how to do it.

I will appreciate any help! I have been looking on different tutorials but I keep getting errors.

February 6th, 2012, 03:26 AM

kimmi_baby

Registered User

Join Date: Jun 2010

Posts: 14

Time spent in forums: 6 h 38 m 59 sec
Reputation Power: 0

This is the error that I get:

JInstaller: :Install: Error SQL DB function failed with error number 1064
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 ''title' varchar(125) NOT NULL, 'price' money NOT NULL, 'description' var' at line 4 SQL=CREATE TABLE `jos_accordion` ( `id` int(11) unsigned NOT NULL auto_increment, `greeting` varchar(25) NOT NULL, 'title' varchar(125) NOT NULL, 'price' money NOT NULL, 'description' varchar(125) NOT NULL, 'image' varchar(125) NOT NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=utf8; "

February 6th, 2012, 03:41 AM

TonyF123

Contributing User

Join Date: Sep 2007

Location: Purley, Surrey

Posts: 224

Time spent in forums: 4 Weeks 1 Day 19 h 30 m 30 sec
Reputation Power: 25

you have single quotes ' around title. Get rid of them, and the unnecessary back ticks ` around the others and it should work.

February 6th, 2012, 03:53 AM

kimmi_baby

Registered User

Join Date: Jun 2010

Posts: 14

Time spent in forums: 6 h 38 m 59 sec
Reputation Power: 0

so i don't need to create them like 'title' and 'description' ?

February 6th, 2012, 04:06 AM

kimmi_baby

Registered User

Join Date: Jun 2010

Posts: 14

Time spent in forums: 6 h 38 m 59 sec
Reputation Power: 0

I'm still getting errors with or without the single quotes...

February 6th, 2012, 05:39 AM

r937

SQL Consultant

Join Date: Feb 2003

Location: Toronto Canada

Posts: 25,046

Time spent in forums: 3 Months 2 Days 22 h 44 sec
Reputation Power: 3829

Quote:

Originally Posted by kimmi_baby

I'm still getting errors with or without the single quotes...

you must've changed something, right? and you're still getting errors?

well, we can't see what you've tried, so the only thing we can say now is, you've done something else wrong

__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book

February 6th, 2012, 06:32 AM

kimmi_baby

Registered User

Join Date: Jun 2010

Posts: 14

Time spent in forums: 6 h 38 m 59 sec
Reputation Power: 0

Code:

DROP TABLE IF EXISTS `#__accordion`;
 
CREATE TABLE `#__accordion` (
   id int(11) unsigned NOT NULL auto_increment,
   greeting varchar(25) NOT NULL,
   title varchar(125) NOT NULL,
   price int(100) NOT NULL,
   description varchar(125) NOT NULL,
   image varchar(125) NOT NULL,
   PRIMARY KEY  (`id`)) 
ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;

INSERT INTO `#__accordion` (greeting, title, price, description, image) VALUES ('Hello'), ('BookName'), ('40'), ('this is description') ('image');

I'm getting errors with my insert now...

February 6th, 2012, 06:35 AM

kimmi_baby

Registered User

Join Date: Jun 2010

Posts: 14

Time spent in forums: 6 h 38 m 59 sec
Reputation Power: 0

Quote:

Originally Posted by kimmi_baby

Code:

DROP TABLE IF EXISTS `#__accordion`;
 
CREATE TABLE `#__accordion` (
   id int(11) unsigned NOT NULL auto_increment,
   greeting varchar(25) NOT NULL,
   title varchar(125) NOT NULL,
   price int(100) NOT NULL,
   description varchar(125) NOT NULL,
   image varchar(125) NOT NULL,
   PRIMARY KEY  (`id`)) 
ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;

INSERT INTO `#__accordion` (greeting, title, price, description, image) VALUES ('Hello'), ('BookName'), ('40'), ('this is description') ('image');

I'm getting errors with my insert now...

I fixed it with this

Code:

DROP TABLE IF EXISTS `#__accordion`;
 
CREATE TABLE `#__accordion` (
   id int(11) unsigned NOT NULL auto_increment,
   greeting varchar(25) NOT NULL,
   title varchar(125) NOT NULL,
   price int(100) NOT NULL,
   description varchar(125) NOT NULL,
   image varchar(125) NOT NULL,
   PRIMARY KEY  (`id`)) 
ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;

INSERT INTO `#__accordion` (greeting, title, price, description, image) VALUES ('Hello', 'BookName', 40, 'this is description', 'image');