Top "Mysql" questions

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

Unable to convert MySQL date/time value to System.DateTime

I get this error: Unable to convert MySQL date/time value to System.DateTime while I am trying to fetch …

.net asp.net mysql asp.net-3.5
MySQL server has gone away - in exactly 60 seconds

I recently discovered that a sql query that was running fine earlier is now timing out after 60 seconds and throwing …

php mysql timeout
MySQL: #126 - Incorrect key file for table

I got the following error from a MySQL query. #126 - Incorrect key file for table I have not even declared …

mysql mysql-error-126
How to remove new line characters from data rows in mysql?

I can loop through all of the rows in a php script and do UPDATE mytable SET title = "'.trim($…

mysql trim
MySQL VARCHAR size?

I'm wondering, if I have a VARCHAR of 200 characters and that I put a string of 100 characters, will it use 200 …

mysql varchar
MAMP mysql server won't start. No mysql processes are running

My MAMP mysql server won't start. All of the suggestions I've seen on the web say to check for other …

mysql mamp
How to change the default charset of a MySQL table?

There is a MySQL table which has this definition taken from SQLYog Enterprise : Table Create Table ----------------- --------------------------------------------------------- etape_prospection …

mysql sqlyog
How can I add comments in MySQL?

I want to add comment in SQL code. How can I do this? I'm using MySQL.

mysql database comments
Group by with union mysql select query

(SELECT COUNT(motorbike.`owner_id`) as count,owner.`name`,transport.`type` FROM transport,owner,motorbike WHERE transport.type='motobike' AND …

mysql sql group-by union
Update MySQL version from 5.1 to 5.5 in CentOS 6.2

I tried to update MySQL from 5.1 to 5.5 in CentOS 6.2. The following is the process I did: 1. rpm -Uvh http://repo.…

mysql database centos