What are some good ideas regarding user security in MySQL?2 2869
Explain the difference between MyISAM Static and MyISAM Dynamic?1 7143
What does myisamchk do?1 2518
Explain advantages of InnoDB over MyISAM?1 6439
Explain advantages of MyISAM over InnoDB?1 4434
What are HEAP tables in MySQL?1 10195
How do you control the max size of a HEAP table?1 5921
What are CSV tables?1 4239
What happens when the column is set to AUTO INCREMENT and you reach the maximum value for that table?2 8777
If we create a column with data type VARCHAR(3), what would we expect to see in MySQL table?
Explain TIMESTAMP DEFAULT ?2006:09:02 17:38:44′ ON UPDATE CURRENT_TIMESTAMP.1 1929
What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type do?1 3295
why not null is not allowed at table level
In a property booking section want a query to check that property is booked from StartDate to EndDate.Booking Table field are given id proerty_id start_date checkout_date no_of_visitor booking date status Waiting yours answer.. Thanks In Advance...
How to set the time zone for MySQL to particular country time?
all the queries used in sql
what is mysql optimization in brief?
suppose data is copie to oracle to sql by using DTS. Actully it taken 2 hours. suppose some day distribute the server in the middle of 2 hours. after how can i get the data ?
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
what is mySQL. Is there any specific qualification required to do this course ? What is the scope in India after doing mySQL
HOW TO FIND display the total number of weeks in the year of 1998 IN EMP TABLE
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.
Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products
1)for snapshot replication which agents used? 2)for Transcation replication which agents used? 3)for merge replciation which agents used?
How can you move the master database
How to enable or disable a row of a table using MySQL in struts?
how to get only updated, deleted , inserted records after certain interval time in mysql with out using triggers...