Top "Mysql" questions

make an ID in a mysql table auto_increment (after the fact)

I acquired a database from another developer. He didn't use auto_incrementers on any tables. They all have primary key …

mysql primary-key auto-increment

Auto Increment after delete in MySQL

I have a MySQL table with a primary key field that has AUTO_INCREMENT on. After reading other posts on …

sql mysql primary-key auto-increment

Syntax error due to using a reserved word as a table or column name in MySQL

I'm trying to execute a simple MySQL query as below: INSERT INTO user_details (username, location, key) VALUES ('Tim', 'Florida', 42) …

mysql reserved-words

MySQL 'create schema' and 'create database' - Is there any difference

Taking a peak into the information_schema database and peaking at the metadata for one of my pet projects, I'm …

sql mysql oracle jdbc database

MySQL INSERT INTO ... VALUES and SELECT

Is there a way to insert pre-set values and values I get from a select-query? For example: INSERT INTO table1 …

mysql sql select insert

MySQL DISTINCT on a GROUP_CONCAT()

I am doing SELECT GROUP_CONCAT(categories SEPARATOR ' ') FROM table. Sample data below: categories ---------- test1 test2 test3 …

mysql group-concat

UTF-8 all the way through

I'm setting up a new server and want to support UTF-8 fully in my web application. I have tried this …

php mysql linux apache utf-8

How to grant remote access to MySQL for a whole subnet?

I can easily grant access to one IP using this code: $ mysql -u root -p Enter password: mysql> use …

mysql grant

How do I escape reserved words used as column names? MySQL/Create Table

I am generating tables from classes in .NET and one problem is a class may have a field name key …

mysql escaping

PHP Fatal error: Class 'PDO' not found

PHP Fatal error: Class 'PDO' not found in /home/bd/public_html/app/webroot/Cake/Model/Datasource/Database/Mysql.php …

php mysql cakephp web-applications