Top "Mysql" questions

MySQL is a free, open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL).

Pagination using MySQL LIMIT, OFFSET

I have some code that LIMITs data to display only 4 items per page. The column I'm using has about 20-30 …

php mysql limit offset
Concatenate string with field value in MySQL

I have the need to concatenate a string with a field value in a MySQL query in order to LEFT …

php mysql sql concatenation
CodeIgniter: How to use WHERE clause and OR clause

I am using the following code to select from a MySQL database with a Code Igniter webapp: $query = $this->…

mysql select codeigniter where-clause
Select specific row from mysql table

Ideally I need a query that is equivalent to select * from customer where row_number() = 3 but that's illegal. I can't …

mysql select row-number
#1146 - Table 'phpmyadmin.pma_recent' doesn't exist

Solution Guys... FYI i am using xampp to use phpmyadmin. and this error happens during the process of creating a …

mysql database phpmyadmin
Join between tables in two different databases?

In MySQL, I have two different databases -- let's call them A and B. Is it possible to perform a …

mysql sql join
INSERT INTO ... SELECT FROM ... ON DUPLICATE KEY UPDATE

I'm doing an insert query where most of many columns would need to be updated to the new values if …

mysql insert-update
Calculating time difference between 2 dates in minutes

I have a field of time Timestamp in my MySQL database which is mapped to a DATE datatype in my …

mysql sql timestamp
What is the benefit of zerofill in MySQL?

I just want to know what is the benefit/usage of defining ZEROFILL for INT DataType in MySQL? `id` INT …

mysql types unsigned-integer
What value could I insert into a bit type column?

I am trying to insert or edit the bit value to "0" or "1", but either returns me a blank. Could someone …

mysql sql boolean bit