Jump to content

First MYSQL Script - Basic Questions


Brandon_R

Recommended Posts

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

Link to comment
https://forums.phpfreaks.com/topic/169570-first-mysql-script-basic-questions/
Share on other sites

Archived

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

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.