Reply to thread

Message: <blockquote data-quote="picsms" data-source="post: 2099826" data-attributes="member: 99297">Try this Hey Bos I had Creadted in my local server and get the script for you. smal advice when ur creating Tables in any DBMS you should keep a Primarykeyi had created with primary key if u want keep other wise delet it here the MySql Query CREATE TABLE `Customer_Details` ( `Name` VARCHAR( 25 ) NOT NULL ,`Address` VARCHAR( 50 ) NOT NULL ,`Contact_No` INT( 10 ) NOT NULL ,`Total_Price` INT( 15 ) NOT NULL ,`Coustomer_Id` INT( 4 ) NOT NULL AUTO_INCREMENT ,PRIMARY KEY ( `Coustomer_Id` ) ) ENGINE = MYISAM  If you dont want with Primary Key Delet the line in Red in coming query CREATE TABLE `Customer_Details` ( `Name` VARCHAR( 25 ) NOT NULL ,`Address` VARCHAR( 50 ) NOT NULL ,`Contact_No` INT( 10 ) NOT NULL ,`Total_Price` INT( 15 ) NOT NULL ,`Coustomer_Id` INT( 4 ) NOT NULL AUTO_INCREMENT ,PRIMARY KEY ( `Coustomer_Id` ) ) ENGINE = MYISAM  Note:-Without Primary key creating a table is not profissional k. just my opinion K bos i think you got anser for ur question. Enjoy</blockquote>

Top Bottom