Top "Mysql" questions

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

mysql error 'TYPE=MyISAM'

Below query I'm executing in Ubuntu 12, MySQL 5.1 version and receiving error as mentioned: CREATE TABLE mantis_config_table ( config_id …

php mysql syntax-error myisam
Mysql: execute command denied to user ''@'localhost' for routine error

i got some problem during open my old website. My dataTable show: DataTables warning: JSON data from server could not …

mysql mysql-error-1064 privileges grant
MySQL indexes - what are the best practices?

I've been using indexes on my MySQL databases for a while now but never properly learnt about them. Generally I …

mysql indexing query-optimization
Counting number of grouped rows in mysql

In a table xyz I have a row called components and a labref row which has labref number as shown …

mysql sql count
mysqlworkbench giving version error on exporting database

When I try to export my database through MySQL Workbench remotely from localserver, I am getting some below version error: …

php mysql export mysql-workbench
How do you version your database schema?

How do you prepare your SQL deltas? do you manually save each schema-changing SQL to a delta folder, or do …

sql mysql schema versioning
How do I get a raw, compiled SQL query from a SQLAlchemy expression?

I have a SQLAlchemy query object and want to get the text of the compiled SQL statement, with all its …

python sql mysql sqlalchemy
PDO::fetchAll vs. PDO::fetch in a loop

Just a quick question. Is there any performance difference between using PDO::fetchAll() and PDO::fetch() in a loop (for …

php mysql pdo fetch
Getting MYSQL Error: "Error Code: 2006 - MySQL server has gone away"

I am getting following error, when I try to import MYSQL database: Error Code: 2013 - Lost connection to MySQL server …

mysql sql mysql-error-2006 mysql-error-2013
MYSQL, Copy selected fields from one table to another

In MySQL, How do I copy a FIELD with all RECORDS from TABLE1 to TABLE2 which corresponds to a primary …

mysql mysql-workbench