Brandon_R Posted August 10, 2009 Share Posted August 10, 2009 Hey guys im trying to learn a bit of mysql and whats better than making a simple script I already have my table, colums already made in my database but just incase can u guys tell me what would be the install code for this, format is (column name - values it should contain) id - this should autoincrement PRIMARY KEY ensuring no 2 entries are alike such as 1,2,3,4,5 etc name - basic letters and numbers - TEXT name_id - value should be 10 chars long consisting or numbers, dashes and letters name_region - value should be either a 1A, 2A or 3A Ofcourse no entey should be blank so NOT NULL for all colums would be nice and also for the name_region could you have the command to insert those values (1A, 2A and 3A) as soon as the column is created Thank You Brandon_r Quote Link to comment Share on other sites More sharing options...
DaiLaughing Posted August 10, 2009 Share Posted August 10, 2009 http://www.tizag.com/mysqlTutorial/mysqltables.php Quote Link to comment 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.