Please Help Members By Posting Answers For Below Questions
explain GROUPBY & HAVING clause with examples.
HOW TO FIND display the total number of weeks in the year
of 1998 IN EMP TABLE
1)for snapshot replication which agents used?
2)for Transcation replication which agents used?
3)for merge replciation which agents used?
How internally data stores in MyISAM and INNODB table types?
What are the critical issues you have resolved in your company
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.
What is striped backup
Can u give the example by taking an unnormalized table and
make that 1nf and then 25nf, and then 3 nf?
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)?
Have you ever used MySQL Administrator and MySQL Query
Browser? Describe the tasks you accomplished with these
what is mysql optimization in brief?
How can you get your MySQL root password, if you lost it?
I want to insert userid of a customer,order time,etc in a
table called ordermaster with orderid as primary key.Same
time the product codes and required quantities (a1,2 and a2
4 and so on)inserted in another table orderdetails with same
orderid reference.How the code will be in JSP using MySQL?
How can you plan the logshipping before processing?
This is kartik, I recently completed my B-tech. Importance
of posting this question is for to know the best books on
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
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: firstname.lastname@example.org.