Dear Members

I have read this Numeric Types


about BIGINT

Well I am very interesting with Unsigned since I want only positive number for my PK auto_increment

I have the doubt about how create explicitly like Unsigned when I define my table creation.

Because when I do the backup, I can see

but How I can know that bigint is Signed/Unsigned explicitly ???

In MySQL query browser if I execute the describe articulo query
I get

but not appear if is Signed/Unsigned

The only way that I can see is doing right click in the table and select
Edit Table where I can see the column flags with the values for such field (PK) UNSIGNED and ZEROFILL

Some guidance going to be appreciate

Thanks in advanced

Try creating it as follows:

DROP TABLE IF EXISTS `articulo`;
CREATE TABLE `articulo` (
`idArticulo` bigint(20) unsigned NOT NULL auto_increment,
`codigoArticulo` varchar(70) NOT NULL,

Hello it-iss.com

Thank you!, work