Top "Mysql" questions

PDO::PARAM for dates?

Does some PDO::PARAM_??? exist which can be used for dates or timestamps? Sample code: $sql = "UPDATE my_table SET …

php mysql date types pdo

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in ubuntu 14.04

I have installed LAMP on my Ubuntu machine. Where Apache2 and PHP5 have been installed properly as when I run …

mysql sockets ubuntu-14.04 lamp

How to search JSON array in MySQL?

Let's say I have a JSON column named data in some MySQL table, and this column is a single array. …

mysql mysql-json

Get affected rows on ExecuteNonQuery

I am currently working on a C# project and I am running an insert query which also does a select …

c# mysql .net sql executenonquery

ALTER TABLE without locking the table?

When doing an ALTER TABLE statement in MySQL, the whole table is read-locked (allowing concurrent reads, but prohibiting concurrent writes) …

sql mysql ddl alter-table

When should I use UNSIGNED and SIGNED INT in MySQL?

When should I use UNSIGNED and SIGNED INT in MySQL ? What is better to use or this is just personal …

mysql

Getting timestamp using MySQL

How can I get the current timestamp using a mysql query?

mysql timestamp

MySQL pivot row into dynamic number of columns

Lets say I have three different MySQL tables: Table products: id | name 1 Product A 2 Product B Table partners: id | name 1 …

mysql sql pivot

Using Mysqli bind_param with date and time columns?

How do you insert data into a MySQL date or time column using PHP mysqli and bind_param?

php mysql mysqli

Running MySQL *.sql files in PHP

I have two *.sql files that I use when creating a new web site database. The first file creates all …

php mysql zend-framework scripting