What tools available for managing mysql server?
No Answer is Posted For this Question
Be the First to Post Answer
What does myisamchk do?
What is procedures in mysql?
What is heap table?
How to copy data from one server to another using php?
What are the different tables present in MySQL?
How many mysql connections can handle?
how to dump all databases for backup. Backup file is sql commands to recreate all db's.
what are the optimization techniques for Query optimization performance issues and faster execution of queries
2 Answers Infosys, Sierra Atlantica,
How do I change a procedure in mysql?
SQL: 1. Write a queryto retrieve the author who was published a book at the youngest age? 2. write a query to retrieve the no. of books published a each year in various languages? 3. write a query to retrieve no. of books published by them only those authors who have published more than 1 book? 4. write a query to retrieve who has not published any books during the year 2006? 5. write a query to retrieve the authors who has published any books during the birth date write this query in 2 ways 1)joins 2)sub query 6. write a query to retrieve all the books which was published during jan 2007 & title containing India or published in the language hindi? 1. table name is liberary managemnt and two column is there one is authors and another one is books . 2.four fields will comes under authours like nationality, birthdate ,first-language,second-language 3.four fields will comes under books like authour,title ,language,publish date to write query using this details
Explain about the architecture of MYSQL?
What is normalization and list the different types of normalization?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)