I dont' seem to be able to create a MySQL table using the following:
CREATE table $create_tablename (order_num TEXT NOT NULL PRIMARY KEY, fname TEXT, lname TEXT, email TEXT, ups_num TEXT, ship_date TEXT, ship_method TEXT, survey_sent TEXT, sent_by TEXT)
I assume that's because the primary key is TEXT and not an INT? Is there a way to have both letters and numbers in the PRIMARY KEY?
CREATE table $create_tablename (order_num TEXT NOT NULL PRIMARY KEY, fname TEXT, lname TEXT, email TEXT, ups_num TEXT, ship_date TEXT, ship_method TEXT, survey_sent TEXT, sent_by TEXT)
I assume that's because the primary key is TEXT and not an INT? Is there a way to have both letters and numbers in the PRIMARY KEY?
Facebook
Twitter