how to get only updated, deleted , inserted records after certain interval time in mysql with out using triggers...
1795write a c++ program to add a user to mysql.the user should be permitted to only "insert" into the given database
3 5703What is diff b/w MYISAM and INNODB storage engine. and also define the benifits and drawbacks of both storage engine
1 3060Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?
4200I'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.
3429when i declare date data type in sql ,i inserted the date 22-10-2012,but my result is in different date 1894-07-11 any one pls help me what's wrong in my query Create table orders(od_id int,od_name varchar(10),od_date date) insert into orders values(1,'sai',22-10-2012) and any one pls suggest what i can learn for 3 years real time experenice in sql because i am looking for database field
1 2673I want to make a query where I want to eliminate the duplicate rows from the table. For example : Input : Table : NAME Column1 Column2 India USA USA India UK India India UK The desired output that I want to eliminate the duplicates Output India USA UK India Thanks
2 4229
How is myisam table stored?
What is the usage of ENUMs in MySQL?
What is the query to display top 20 rows?
What is mysqli_result?
Why MySQL is used?
Write a query to create a database and a table?
Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with r.
Explain about reporting services of MYSQL?
How can I change database in mysql?
Does mysql use t sql?
How triggers can be used in mysql?
What is max connections in mysql?
How to determine the location of the data directory?
Is number a datatype in mysql?
What is flush privileges in mysql?