Sign up ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
create table employee6(FullName varchar(50),
DateOfBirth int,MobileNO int,
HigherQualification varchar(50),
ApplyingFor varchar(50),Regno int);
insert into employee6 
values('SRINIVASULU',1986,9908273648,'M.TECH','SOFTWARE DEVELOPER',369)

PLEASE DID U FOUND ANY ERROR..PLEASE CORRECT IT

share|improve this question

closed as off-topic by Phil, Kin, ypercube, RolandoMySQLDBA, marc_s Jun 16 '14 at 13:47

This question appears to be off-topic. The users who voted to close gave these specific reasons:

  • "Tip of the iceberg - the question or comments reveal an underlying issue that would need extensive investigation by a consultant or database vendor support team: issues like this do not fit the SE Q&A model well. For more information see this meta post." – Phil, RolandoMySQLDBA, marc_s
  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – Kin, ypercube
If this question can be reworded to fit the rules in the help center, please edit the question.

5  
Do you receive an error when you execute it? –  Shawn Melton Jun 16 '14 at 11:41

1 Answer 1

You have MobileNo defined as INT and then you try to insert a number that is higher than the maximum value of INT.

For a discussion on a good data type for phone numbers, see the discussion here.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.