Content about Java ERP Solution for Reviews Best ERP Software for sale and Free Software with Java OpenSource for Free Download

Mysql create table int with unsigned int column example sql command

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
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