how to get only updated, deleted , inserted records after certain interval time in mysql with out using triggers...
2238write a c++ program to add a user to mysql.the user should be permitted to only "insert" into the given database
3 7045What is diff b/w MYISAM and INNODB storage engine. and also define the benifits and drawbacks of both storage engine
1 3765Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?
4679I'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.
3982when 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 3286I 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 5259
Can you tell the difference between mysql_fetch_object and mysql_fetch_array?
What are the disadvantages of mysql?
How do I find mysql database?
Is postgresql better than mysql?
What's new in mysql 8?
How do I completely remove mysql from windows?
Can foreign key have duplicate values?
What happens if you no create privilege in a database?
Explain triggers and stored procedures?
How many triggers are possible in mysql?
Is number a datatype in mysql?
What is the innodb in mysql?
What are views in mysql?
Is mysql better than oracle?
What is a csv table?