In the attribute of this post registry how to know the maximum number i must write?

Databases
1

(identification number(11) not null,

2
3

It’s quite unclear what you want. Could you elaborate please?

4

i mean the number that is to the right of the attribute ofthe registry below this emssage;how do i findout what is the maximum size it can have ?
create table counselor
identification int(11) not null
This is writing in C programming langauge

5
6

The maximum value an int can hold in MySQL (assuming that is what you’re using) is 2147483647.

See https://dev.mysql.com/doc/refman/8.0/en/integer-types.html

7

i am using l SQL Server Management Studio and SQL Server 2022 Express

8

Even if it is for MySQL I guess it’s the same in Mssql

9

the maximum and minimum numbers that can be stored in an INTEGER column are the same for all databases

but the link you posted (about the “display width”) is only for MySQL, and it’s a fairly good explanation of this feature, except for one problem – it says “If the column has ZEROFILL it will always store the number of characters for that column” but of course that’s not true, because integers are always stored in 4 bytes binary, and in particular the leading zeros are not actually stored as characters

1 Like
10

I am somewhat cautious here…

^ This one gives me pause.

Be careful to be precise about what you’re saying… INT is different from NUMERIC, which are both Transact-SQL types, but have different ranges.