paolorossi07 Posted March 23, 2007 Share Posted March 23, 2007 Any one know how to put this data in to php myadmin using script? CUSTOMER Customer ID Customer Name Customer Address Customer Postcode Customer Contact Tele Number Customer E-Mail Application ID Inspection Request Inspection ID Inspection Address Inspection Stage Inspection Date Requested Area ID Customer ID Inspector ID Inspector/Inspections Inspector ID Inspections ID Inspector Inspector ID Inspector Name Inspector Mobile Number Inspector E-Mail Area ID Inspection ID Login Login ID Login Username Login Password Inspectors ID Area Area ID Area Name Inspector ID Quote Link to comment https://forums.phpfreaks.com/topic/43994-database-design-sql/ Share on other sites More sharing options...
cmgmyr Posted March 23, 2007 Share Posted March 23, 2007 you would need to put it into sql format, why don't u just make the tables with phpMyAdmin? Quote Link to comment https://forums.phpfreaks.com/topic/43994-database-design-sql/#findComment-213605 Share on other sites More sharing options...
paolorossi07 Posted March 23, 2007 Author Share Posted March 23, 2007 is it easy just to add code in to the sql? if so how would i add this table if i was to enter an sql statement? Customer ID (pk) Customer Name Customer Address Customer Postcode Customer Contact Tele Number Customer E-Mail Application ID (Fk) Quote Link to comment https://forums.phpfreaks.com/topic/43994-database-design-sql/#findComment-213803 Share on other sites More sharing options...
cmgmyr Posted March 23, 2007 Share Posted March 23, 2007 Well it would be just easier to make it in phpMyAdmin. All it is is text and dropdown input boxes. Once you make it in there then you can export it as sql. But if you want to know how to make tables by hand check this out: http://sql-info.de/mysql/examples/CREATE-TABLE-examples.html you can also search for "mysql create table" Quote Link to comment https://forums.phpfreaks.com/topic/43994-database-design-sql/#findComment-213817 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.