Join the social network of Tech Nerds, increase skill rank, get work, manage projects...

How to Summarise Leave Time Proportionally and Correctly in MySql

In mysql database i created "leave" table:   CREATE TABLE `leave` ( `ID_LEAVE` int(11) NOT NULL, `ID_WORKER` int(11) NOT NULL, `BEGIN_DATE` datetime DEFAULT NULL, `END_DATE` datetime DEFAULT NULL ) INSERT INTO `lea...

How to find out slow queries in MySQL?

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

MySQL query to retrieve data of past two months

 I have a table with name and createDate, please tell me the query to retrieve the user data of past two months. Thanks in Advance

how to avoid duplicate data in php mysql ?

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...

How to access the database with SQL PLUS?

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...

Insert Data into MySQL database from HTML SubForms

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...

Entering Values in Second table with help of Primary Key of First Table

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...
Sign In

Sign up using

Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: