| Other MySQL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| what if you really want to store the timestamp data, such
as the publication date of the article? | | 2 |
| how to display only 4 records from a table based on a
condition
for ex
i have a table called products
in that nid,prodname are fields
i want to display only any 4 records of perticular product
plz tell me | | 4 |
| For the database from the previous question, please give an
SQL query which returns the invoice number of all invoices
which contain the article with the number ?1234?. The query
should be able to run under a MySQL 4.0 database. | | 1 |
| How many ways we can we find the current date using MySQL? | | 4 |
| Use mysqldump to create a copy of the database? | | 1 |
| How do you start and stop MySQL on Windows? | | 2 |
| how to repair a table in mysql? | | 1 |
| Explain the difference between MyISAM Static and MyISAM
Dynamic? | | 1 |
| What are HEAP tables in MySQL? | | 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 |
| 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 difference between mysql_fetch_array and
mysql_fetch_object? | CTS | 2 |
| Explain TIMESTAMP DEFAULT ?2006:09:02 17:38:44′ ON UPDATE
CURRENT_TIMESTAMP. | | 1 |
| about join | | 2 |
| how we can use more then one primary key in Single Table | Systematix | 8 |
| A company wants to store their invoices in a database. They
already have their customers and articles in that database.
Both customer and article are each identified by an unique
integer value. Please create the SQL statements for
creating the necessary table(s) for storing the invoices in
a MySQL database. An invoice should hold information like
invoice number, customer, date, article(s) and quantity
etc. | | 1 |
| What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type
do? | | 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 |
| SELECT country,city
FROM customers
GROUP BY country
ORDER BY city DESC
| HCL | 3 |
| How we can copy one table data into another table whose name
same as table but in differ database | | 4 |
| |
| For more MySQL Interview Questions Click Here |
Site Map
