Mysql create table int with unsigned int column example sql command to caeate table with
mysql create unsigned int column and mysql create table unsigned int primary key in below
mysql create unsigned int column and mysql create table unsigned int primary key in below
Mysql create unsigned int column
using key word UNSIGNED after datatype of field for example
CREATE TABLE test_table (
test_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
test_desc TEXT
);
Mysql create table unsigned int primary key
CREATE TABLE test_table (
test_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
test_desc TEXT
PRIMARY KEY ('test_id')
);
Note: using keyword
UNSIGNED
to tell the data type is UNSIGNED
and using keyword PRIMARY KEY (fieldname)
to tell this field is primary key