how to get only updated, deleted , inserted records after certain interval time in mysql with out using triggers...
1 2292write a c++ program to add a user to mysql.the user should be permitted to only "insert" into the given database
3 7199What is diff b/w MYISAM and INNODB storage engine. and also define the benifits and drawbacks of both storage engine
1 3845Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?
1 4726I'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.
1 4053when 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 3368I 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 5369