Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Proper sql syntax


khaaliq

Recommended Posts

Posted

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

Posted

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!

Posted

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!

Posted

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!

Archived

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

×
×
  • Create New...