Top "Mysql" questions

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

'0000-00-00 00:00:00' can not be represented as java.sql.Timestamp error

I have a database table containing dates (`date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'). I'm using MySQL. From …

java mysql jdbc timestamp
How to view query error in PDO PHP

try { $db = new PDO("mysql:host=".HOST.";dbname=".DB, USER, PW); $st = $db->prepare("SELECT * FROM c6ode"); } catch (…

php mysql pdo
MySQL - how many rows can I insert in one single INSERT statement?

Does it depend on the number of values sets? Does it depend on the number of bytes in the INSERT …

mysql multiple-insert
Good tool to visualise database schema?

Are there any good tools for visualising a pre-existing database schema? I'm using MySQL if it matters. I'm currently using …

mysql database database-design schema visualization
How to display a date as iso 8601 format with PHP

I'm trying to display a datetime from my MySQL database as an iso 8601 formated string with PHP but it's coming …

php mysql date date-format time-format
How to group by week in MySQL?

Oracle's table server offers a built-in function, TRUNC(timestamp,'DY'). This function converts any timestamp to midnight on the previous …

mysql datetime group-by data-migration dayofweek
How to form a correct MySQL connection string?

I am using C# and I am trying to connect to the MySQL database hosted by 00webhost. I am getting …

c# mysql database-connection
can't start MySql in Mac OS 10.6 Snow Leopard

I've googled this and could'nt find anything new and useful for Apple's new OS SnowLeopard. I wonder if this is …

mysql macos osx-snow-leopard
How can I directly view blobs in MySQL Workbench

I'm using MySQL Workbench CE 5.2.30 CE / Rev 6790 . When execute the following statement: SELECT OLD_PASSWORD("test") I only get back …

mysql mysql-workbench