Question About Column

[tomyknoker]

I am going to import about 200 generated codes into a MySQL table... Just had a queation, the codes will look like this as an e.g. 7dYhsj8. So would I just make then 'Text' as the data type and Not Null?

[buntine]

Yes, definately an alphanumeric datatype as 'text' is needed. Set the field as mandatory if you are sure there will never be any NULL values inserted.

Andrew Buntine