If we create a column with data type VARCHAR(3), what would we expect to see i

If we create a column with data type VARCHAR(3), what would
we expect to see in MySQL table?

Question Posted / amith

2 Answers
6403 Views
ABC, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

If we create a column with data type VARCHAR(3), what would we expect to see in MySQL table?..

Answer / amith

CHAR(3), since MySQL automatically adjusted the data type.

Is This Answer Correct ?

3 Yes

5 No

If we create a column with data type VARCHAR(3), what would we expect to see in MySQL table?..

Answer / sivateja

through check command in mysql

Is This Answer Correct ?

0 Yes

2 No

Post New Answer

More MySQL Interview Questions

Query to select passwords from a table having a column "Password" Whose length is b/w 8 &15 and having 'A' as the first character in the password irrespective of case.

3 Answers

What is a trigger? How you can create a trigger in mysql?

0 Answers

What is the use of mysqli_connect in php?

0 Answers

How do I rename a mysql database?

0 Answers

How to display top 50 rows?

0 Answers

What is mysql enterprise edition?

0 Answers

date funciton

2 Answers

How to display nth highest salary from a table in a mysql query?

0 Answers

What is the default password for mysql?

0 Answers

How can a user get the current SQL version?

2 Answers

What is pdo in php mysql?

0 Answers

I have a table like this tblData (month int,Qty int) and i am inserting three rows in this table 1.tblData Values (1,100) 2.tblData Values (2,200) 3.tblData Values (3,300) The Result I want is the Running total of the field Qty that is 1 100 100 2 200 300 3 300 600 What is the Query for that ?

4 Answers

For more MySQL Interview Questions Click Here