Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Proper sql syntax


khaaliq

Recommended Posts

Could someone give me a hand with this? I get syntax errors when I insert it into phpmyadmin.

 

CREATE TABLE products_groups( customers_group_id (int) 11, customers_group_price (decimal) 15, 4, products_id (int) 11, products_price (decimal) 15,4, ) TYPE=MyISAM

 

Thanks

Link to comment
Share on other sites

I'd start by trying a semi-colon (;) after MyISAM...

... if you want to REALLY see something that doesn't set up right out of the box without some tweaking,

try being a Foster Parent!

Link to comment
Share on other sites

Which contribution is this for?

... if you want to REALLY see something that doesn't set up right out of the box without some tweaking,

try being a Foster Parent!

Link to comment
Share on other sites

Richard;

 

Try it this way...

 

CREATE TABLE products_groups(

customers_group_id int( 11 ) ,

customers_group_price decimal( 15, 4 ) ,

products_id int( 11 ) ,

products_price decimal( 15, 4 )

) TYPE = MyISAM;

... if you want to REALLY see something that doesn't set up right out of the box without some tweaking,

try being a Foster Parent!

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...