Top "Mysql" questions

Not unique table/alias

I get the error ERROR 1066 (42000): Not unique table/alias: I cant figure out whats wrong with it. SELECT Project_Assigned.…

mysql mysql-error-1066

MySQL Nested Select Query?

Ok, so I have the following query: SELECT MIN(`date`), `player_name` FROM `player_playtime` GROUP BY `player_name` I …

mysql sql select group-by nested

MySQL: What's the difference between float and double?

Checking in the new database structure I saw that someone changed a field from float to double. Wondering why, I …

mysql

What do column flags mean in MySQL Workbench?

In MySQL Workbench table editor there are 7 column flags available: PK, NN, UQ, BIN, UN, ZF, AI. PK obviously stands …

sql mysql mysql-workbench

How can I import a large (14 GB) MySQL dump file into a new MySQL database?

How can I import a large (14 GB) MySQL dump file into a new MySQL database?

mysql large-files

Where to change the value of lower_case_table_names=2 on windows xampp

I am using windows 7 and xampp i am trying to export my database and while in the process the table …

mysql xampp

Bulk insert with SQLAlchemy ORM

Is there any way to get SQLAlchemy to do a bulk insert rather than inserting each individual object. i.e., …

python mysql database orm sqlalchemy

MySQL WHERE: how to write "!=" or "not equals"?

I need to do this DELETE FROM konta WHERE taken != '' But != doesn't exist in mysql. Anyone know how to …

mysql sql-delete

What is the easiest way to clear a database from the CLI with manage.py in Django?

I am using Django to build a website with MySQL. Now as I am learning so I need to change …

python mysql django django-1.3

nodejs mysql Error: Connection lost The server closed the connection

when I use node mysql, an error is appear between 12:00 to 2:00 that the TCP connection is shutdown by the server. …

mysql node.js dbconnection