Error on database
sir how to solve
Error
SQL query:
-- --------------------------------------------------------
--
-- Table structure for table `products`
--
ALTER TABLE table_name ADD CONSTRAINT fk_wew FOREIGN KEY ( fld ) reference tbl_name(
fld_name
) CREATE TABLE IF NOT EXISTS `products` (
`product_id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`product_name` VARCHAR( 100 ) DEFAULT NULL ,
`bar_code` VARCHAR( 50 ) DEFAULT NULL ,
`product_price` DOUBLE DEFAULT NULL ,
`number_of_stocks` DOUBLE DEFAULT NULL ,
`stock_unit` VARCHAR( 20 ) DEFAULT NULL ,
`product_genre` VARCHAR( 100 ) DEFAULT NULL ,
PRIMARY KEY ( `product_id` ) showDialogForTransaction
) ENGINE = INNODB DEFAULT CHARSET = latin1 AUTO_INCREMENT =75;
MySQL said:
#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 'reference tbl_name(fld_name)
CREATE TABLE IF NOT EXISTS `products` (
`product' at line 7