Top "Mysql" questions

PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused

I am trying to use a PHP connection to connect MySQL Database which is on phpmyadmin. Nothing fancy about the …

php mysql pdo

What is the ideal data type to use when storing latitude / longitude in a MySQL database?

Bearing in mind that I'll be performing calculations on lat / long pairs, what datatype is best suited for use with …

mysql database-design maps mapping latitude-longitude

MySQL connection not working: 2002 No such file or directory

I'm trying to set up WordPress. I have Apache and MySQL running, and the accounts and database are all set …

php mysql connection

How to import a single table in to mysql database using command line

I had successfully imported a database using command line, but now my pain area is how to import a single …

mysql import

Invalid default value for 'create_date' timestamp field

I have the following sql create statement mysql> CREATE TABLE IF NOT EXISTS `erp`.`je_menus` ( -> `id` …

mysql

MySQL Insert into multiple tables? (Database normalization?)

I tried searching a way to insert information in multiple tables in the same query, but found out it's impossible? …

mysql

Change auto increment starting number?

In MySQL, I have a table, and I want to set the auto_increment value to 5 instead of 1. Is this …

mysql

Delete with Join in MySQL

Here is the script to create my tables: CREATE TABLE clients ( client_i INT(11), PRIMARY KEY (client_id) ); CREATE TABLE …

mysql

Setting Django up to use MySQL

I want to move away from PHP a little and learn Python. In order to do web development with Python …

python mysql django debian

1030 Got error 28 from storage engine

I am working on a project where i need to create a database with 300 tables for each user who wants …

mysql