Top "Mysql" questions

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

How to avoid mysql 'Deadlock found when trying to get lock; try restarting transaction'

I have a innoDB table which records online users. It gets updated on every page refresh by a user to …

mysql deadlock
Can't connect to MySQL server on 'localhost' (10061) after Installation

I installed MySQL using mysql-installer-5.5.20.0.msi on Windows 7. From the cmd window, I run "mysqlshow -u root -p". It asked …

mysql windows windows-7
The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead

When I attempt to connect to a MySQL server from PHP, I see the following error: Deprecated: The mysql extension …

mysql deprecated php
"Incorrect string value" when trying to insert UTF-8 into MySQL via JDBC?

This is how my connection is set: Connection conn = DriverManager.getConnection(url + dbName + "?useUnicode=true&characterEncoding=utf-8", userName, password); …

mysql jdbc utf-8 utf8mb4
Run MySQLDump without Locking Tables

I want to copy a live production database into my local development database. Is there a way to do this …

mysql database
How to SUM and SUBTRACT using SQL?

I am using MySQL and I have two tables: master_table ORDERNO ITEM QTY stock_bal ITEM BAL_QTY Master …

mysql sql aggregate-functions
MySql export schema without data

I'm using a MySql database with a Java program, now I want to give the program to somebody else. How …

mysql sql
Error Code: 1062. Duplicate entry '1' for key 'PRIMARY'

I have a problem on this error message, when i try this: INSERT INTO `PROGETTO`.`UFFICIO-INFORMAZIONI` (`ID`, `viale`, `num_civico`, `…

mysql mysql-workbench error-code mysql-error-1062
MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET

What is main difference between INSERT INTO table VALUES .. and INSERT INTO table SET? Example: INSERT INTO table (a, b, …

sql mysql performance
What is the MySQL JDBC driver connection string?

I am new to JDBC and I am trying to make a connection to a MySQL database. I am using …

mysql jdbc connection-string