Most answered questions under tag mysql

+1 vote

4 answers

What is the difference between char and varchar data types in PHP?

posted May 28, 2014 by Amanpreet Kaur

0 votes

4 answers

Foreign key on multiple columns

posted Mar 21, 2013 by Salil Agrawal

0 votes

3 answers

How to compare two tables in MYSQL?

posted Jun 13, 2017 by anonymous

+2 votes

3 answers

Can we have two primary keys in one table?

posted May 17, 2017 by Rohini Agarwal

0 votes

3 answers

How can I list all indexes in a table in MYSQL?

posted Mar 28, 2017 by Deepa

0 votes

3 answers

What is difference between the function Unlink() and Unset()?

posted Jun 2, 2014 by Amanpreet Kaur

+2 votes

3 answers

MySql: Performance boost by splitting up large table?

posted May 14, 2014 by Mandeep Sehgal

+2 votes

3 answers

What is the difference between Primary Key and Unique Key?

posted May 5, 2014 by Sachin Dahda

+2 votes

3 answers

MySQL Archive Engine

posted Sep 17, 2013 by Kumar Mitrasen

0 votes

3 answers

How to delete old records in my MySql database?

posted Aug 2, 2013 by Deepak Dasgupta

0 votes

3 answers

How to VIEW performance improvement using MySQL

posted Jul 30, 2013 by Luv Kumar

+1 vote

3 answers

Database backup and restoration in MYSQL

posted Jul 6, 2013 by anonymous

0 votes

3 answers

Reseting the auto-increment number in a MySQL database using PHP

posted Jun 26, 2013 by anonymous

+2 votes

3 answers

How to insert a column in a existing table in MySQL

posted May 11, 2013 by Salil Agrawal

0 votes

2 answers

DROP TABLE CRICKET what does it mean?

posted Jul 2, 2018 by anonymous

0 votes

2 answers

Is it possible to create a table in MYSQL where more then one fields can be defined as Primary key ?

posted Apr 17, 2017 by Ajay Shetty

0 votes

2 answers

How to display the last record of the field in a input box using PHP?

posted Apr 17, 2017 by Kavyashree

+1 vote

2 answers

What is the meaning of % and _ in the LIKE statement in MYSQL?

posted Mar 27, 2017 by Deepa

+1 vote

2 answers

What is SQLyog?

posted Mar 15, 2017 by Sahana

+1 vote

2 answers

What is heap table in Mysql?

posted Mar 10, 2017 by Kavyashree

+1 vote

2 answers

How is MongoDB better than other SQL databases?

posted Jan 20, 2017 by Dhaval Vaghela

+1 vote

2 answers

How to get distinct column values in MySql?

posted Dec 21, 2016 by Atindra Kumar Nath

+2 votes

2 answers

What is a stored procedure and how to create a stored procedure in MySQL?

posted Aug 4, 2016 by anonymous

+1 vote

2 answers

MYSQL: When to create a new user?

posted Aug 19, 2015 by Deepti Singh

+1 vote

2 answers

In SQL how to INSERT, UPDATE or DELETE record in one statement

posted Oct 7, 2014 by Amit Kumar Pandey

+2 votes

2 answers

How to insert more than one record using a single insert statement?

posted Oct 7, 2014 by Amit Kumar Pandey

+2 votes

2 answers

What are the different types of JOINS in SQL and MYSQL?

posted Sep 14, 2014 by Nimish

0 votes

2 answers

Is it possible to access MYSQL Database through C program?

posted Aug 3, 2014 by anonymous

0 votes

2 answers

How to Concatenate two fields in MySql?

posted Jul 16, 2014 by Amanpreet Kaur

0 votes

2 answers

How Does Full Join Work in SQL?

posted Jul 15, 2014 by Rahul Mahajan

0 votes

2 answers

What is the use of mysql_real_escape_string function?

posted Jul 8, 2014 by Amanpreet Kaur

0 votes

2 answers

How to change the name of a column of a table?

posted Jun 25, 2014 by Karamjeet Singh

0 votes

2 answers

What are the properties of cursors in MySQL?

posted Jun 24, 2014 by Amritpal Singh

0 votes

2 answers

What are ENUMs used for in MySQL?

posted Jun 24, 2014 by Karamjeet Singh

0 votes

2 answers

How mysql_connect and mysql_pconnect differ from each other?

posted Jun 20, 2014 by Amritpal Singh

0 votes

2 answers

How can I find the longest value in my mysql table?

posted Jun 18, 2014 by Sachin Dahda

+1 vote

2 answers

What is difference between MyISAM and InnoDB storage engines in MySQL?

posted Jun 9, 2014 by Rahul Mahajan

+2 votes

2 answers

How can we destroy a session in PHP?

posted May 29, 2014 by Karamjeet Singh

+1 vote

2 answers

How can we get the value of current session Id in PHP?

posted May 27, 2014 by Karamjeet Singh

+2 votes

2 answers

How I can get started working with PHP/MySQL inside of the WordPress app?

posted May 22, 2014 by Kumar Mitrasen

+1 vote

2 answers

How can the current date and time be calculated using MySQL?

posted May 20, 2014 by Sachin Dahda

+1 vote

2 answers

How many ways are there to retrieve the data in result set of MySQL using PHP?

posted May 16, 2014 by Mohit Sharma

+3 votes

2 answers

What is the difference between GROUP BY and ORDER BY in Sql/MySql?

posted May 7, 2014 by Sachin Dahda

+2 votes

2 answers

Data masking for mysql

posted Apr 15, 2014 by Deepti Singh

+2 votes

2 answers

How can I clear my session data from the browser?

posted Feb 26, 2014 by Sanketi Garg

+1 vote

2 answers

How to update null into a column type Date in MySQL ?

posted Oct 8, 2013 by Satyabrata Mahapatra

+1 vote

2 answers

How embedded SQL differ from dynamic SQL?

posted Sep 27, 2013 by Vivek Singh

+1 vote

2 answers

Java UTC Calendar and Mysql TimeStamp - Gets me every time!!!!!

posted Aug 21, 2013 by Abhay Kulkarni

+1 vote

2 answers

Unable to connect Mysql2 or Sqlite3 on windows

posted Aug 9, 2013 by Jagan Mishra

0 votes

2 answers

Python3 and SSH Tunnel

posted Aug 8, 2013 by Salil Agrawal