I am working on a MySQL PHP social networking application and I want to Fetch Recent Activity as Newsfeed with respect to post activity timings.
Here is my site database, i am writing only few columns which are required to show.
&...

Hello everyone,
Please help me regarding the use of slow queries in MySQL.
I want to know how can I find out slow queries in MySQL and What is optimal query time to query a single table of 3 Million records on Indexed column??
Thank you

i have this database which contain table for questions and other for answers
how can i display each questions with the answers that belong to this question
my problem is when i try to display the questions i get duplicated rows or all the answe...

needed version 5.7 of mysql server for a project. I upgraded from version 5.5 to 5.7 using this tutorial. The upgrade was successful and I am able to use the updated version via command line. However, mysql browsers (mysql-workbench as sqlyog as ...

Hello all, I am unable to access my SQL database as I forgot the login details. I have tried with some but getting error "ORA -12560: TNS : protocol adapter error."
Kindly suggest me the way to retrieve the details. Is there any comm...

Hello EveryOne,
I have 2 HTML Forms:
1. Register/Login
2. After User gets Login, He used to update details of him.
I used MySql database in order to save Login details of User. And also i have another table for updating details of him aft...

Hello EveryOne....
Here is the scenario.,
In MySql database, I have two tables.. User and UserDetails...
In 'User' table, i had generated userID made it as a primaryKey.
For Example, 101->user1.... 102->User2
Now I need...