| Other MySQL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How many ways we can we find the current date using MySQL? | | 1 |
| which version of mysql can't support stored procedure?? | | 3 |
| What happens if a table has one column defined as TIMESTAMP? | | 1 |
| What does myisamchk do? | | 1 |
| How can we repair a MySQL table? | Infosys | 2 |
| in a master-master replication with two masters and
alternate slaves running on two systems.can i have a script
or any mysql command to know which one is right now acting
as master. | | 1 |
| What is the maximum length of a table name, database name,
and fieldname in MySQL? | TISL | 1 |
| what are the main differences between MyISAM and InnoDB
table storage structures ?
what are the advantages and disadvantages in usage of these ? | Tesco | 8 |
| I have two sql database at different PC.how can link b/w
database and database tables. | | 1 |
| if we want to load data from a text file into a mysql table,
but the columns in table are 1st: code(int) and 2nd:
city(varchar), but in text file the format is 1st cityname
and then code separeted by delimeters. how to load? | | 2 |
| What are MySQL transactions? | | 1 |
| how to repair a table in mysql? | | 1 |
| i made a table in sql server 2000 and in a column i want to
add image path of a picture present in my hardisk... so
using insert statement how will i insert the path of the
image in the table?? | WebTech | 1 |
| If you specify the data type as DECIMAL (5,2), what?s the
range of values that can go in this table? | | 1 |
| How do you prevent MySQL from caching a query? | | 1 |
| Fname Lname City Pin
ramesh kumar salem 365241
Query to generate a code having the firstletter of
Fname,Lname & 3letter of city Last 3letter of pin,all in
capital letters
| | 1 |
| How can we change the name and data type of a column of a
table? | Google | 3 |
| about foregine | | 2 |
| Explain the difference between BOOL, TINYINT and BIT? | | 1 |
| How many tables will create when we create table, what are they? | | 3 |
| |
| For more MySQL Interview Questions Click Here |
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
