mysql command in command prompt something wrong

[xcoderx]

hi friends what is it that im doing wrong that im unable to create table inside the company database?

 

 

create database company;

 

use company;

 

create table employee(first_name text(30), last_name text(30), address text(500), phone int(13), designation text(50);

 

 

[Mchl]

Count parentheses.

[xcoderx]

erm dd i miss the parenthesis at the end?

[xcoderx]

actually i did lol thanks.

[PFMaBiSmAd]

You will also find that int(13) won't work for a couple of reasons. INT(11) is the biggest normal integer and that includes a +/- sign as the 11th character. For the signed integer you are trying to make, the highest area code would be 214 and if you make it unsigned, 429 would be the highest area code you could store.

 

Phone numbers are not actually numbers, they are formatted strings consisting of numeric digits.

[xcoderx]

what must i use then?

[xcoderx]

is char the right thing to use

?

[Mchl]

CHAR or VARCHAR. Phone numbers are not numbers in mathematical sense, so they should be stored as strings.

[xcoderx]

thanls bro got it explained by my teacher today. int is something we use only when it has something to do with mathemetics right?

[Mchl]

When you need to store a number in mathematical sense of this word.

Phone numbers, zip codes, social security numbers are not numbers in mathematical sense. They're strings composed of digits. You do not add/compare/divide them. You do not need a mean of telephone numbers or maximum of zip codes