Top "Mysql" questions

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

Can't connect to MySQL server error 111

I installed mysql server on linux box IP = 192.168.1.100 but when i try to connect to this IP it alway error(111). …

mysql linux mysql-error-2003
Alter a MySQL column to be AUTO_INCREMENT

I’m trying to modify a table to make its primary key column AUTO_INCREMENT after the fact. I have …

sql mysql alter-table
Create a new database with MySQL Workbench

Being new to MySQL, I have installed the latest version of the MySQL Workbench (5.2.33). I would like to know how …

mysql database mysql-workbench
Update a column value, replacing part of a string

I have a table with the following columns in a MySQL database [id, url] And the urls are like: http://…

mysql sql
MySQL DROP all tables, ignoring foreign keys

Is there a nice easy way to drop all tables from a MySQL database, ignoring any foreign key constraints that …

mysql foreign-keys innodb sql-drop
ERROR 2006 (HY000): MySQL server has gone away

I get this error when I try to source a large SQL file (a big INSERT query). mysql> source …

mysql
MYSQL import data from csv using LOAD DATA INFILE

I am importing some data of 20000 rows from a CSV file into Mysql. Columns in the CSV are in a …

mysql csv import load-data-infile
How do I modify a MySQL column to allow NULL?

MySQL 5.0.45 What is the syntax to alter a table to allow a column to be null, alternately what's wrong with …

mysql syntax
Rename a column in MySQL

I am trying to rename a column in MySQL community server 5.5.27 using this SQL expression: ALTER TABLE table_name RENAME …

mysql sql
Insert current date in datetime format mySQL

I'm having problems getting the date inserted properly into my database. $date = date('m/d/Y h:i:s', time()); …

php mysql