what if you really want to store the timestamp data, such as the publication date of the article?2 3523
What happens if a table has one column defined as TIMESTAMP?1 3837
If you specify the data type as DECIMAL (5,2), what?s the range of values that can go in this table?2 5057
Explain the difference between BOOL, TINYINT and BIT?1 4232
Explain MySQL architecture?1 11008
Explain MySQL locks?1 3219
Explain multi-version concurrency control in MySQL?2 6655
What are MySQL transactions?2 3139
What is ACID?2 3305
Which storage engines support transactions in MySQL?2 4529
How do you convert to a different table type?1 2287
How do you index just the first four bytes of the column?2 2888
1.how to fetch a value and Execute store procudure in mysql(INNODB) using phpMyAdmin? 2.can i wright a package in mysql database(INNODB)?
explain GROUPBY & HAVING clause with examples.
I've looked but can't find a MySQL equivalent for MS SQL's xp_cmdshell. I have 7z files that I want to unzip and load into MySQL. I'm trying to write a sp to do the unzip, but I can't find a way to do that. Can anyone provide an example of a similar process in Windows? TIA.
How to define numeric 9(3) in db2 table without decimal point??
1)for snapshot replication which agents used? 2)for Transcation replication which agents used? 3)for merge replciation which agents used?
How to set the time zone for MySQL to particular country time?
What is striped backup
How can you plan the logshipping before processing?
What are the method you will follow while sql installing
what is mysql optimization in brief?
What is RMS Migrations
Hi Team, This is kartik, I recently completed my B-tech. Importance of posting this question is for to know the best books on SQL(MYSQL/Oracle)? I like SQL concept's so much, at the same time i decided to choose SQL for my career purpose. So please suggest me the best books that are very helpful for a fresher to improve concepts like (SQL/PLSQL)Basics, programming concepts, architectures etc. Please consider my request as an important one. I am very thankful to you for providing this opportunity. If possible can you please send the names of books for my personal id also: email@example.com. Thanks, Kartik T
How internally data stores in MyISAM and INNODB table types?
What are the critical issues you have resolved in your company
Explain the architecture models of SQL Server?