FAQ Database Discussion Community


How to install mysql 5.6 in ubuntu 12.04

mysql,ubuntu-12.04,upgrade,mysql-5.6,mysql-5.5
I was needed to upgrade mysql 5.5 to 5.6, to avoid some issues on importing sql files. ERROR 1293 (HY000) at line 231: Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause How do you upgrade it?...

query two tables where one row is like another row

mysql,select,like,mysql-5.6
I need to join two tables where one row value should be inside the other row. t1 f1,f2 t2 f11,f22 query select * from t1 join t2 on f1=f11 where f22 LIKE %f2% How do I write this?...

ORDER BY UPPER(column) is wrong in MySQL

mysql,sql,order,sql-order-by,mysql-5.6
With MySQL 5.6, given the following table structure: mysql> describe groups; +-------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | name | varchar(500) | YES | | NULL | |...

What does the MySQL 5.6 error “InnoDB presently supports one FULLTEXT index creation at a time. Try LOCK=SHARED” mean?

mysql,amazon-rds,mysql-5.6
In MySQL 5.6.22 (specifically running on Amazon RDS) I once had a fulltext index on a table. I have since dropped that index in favor of using sphinxsearch. There are no more fulltext indexes on any of the tables on the database. When I try to now perform an online...

Compiling MySQL 5.6 for Raspberry Pi - validation error

mysql,debian,raspberry-pi,gnupg,mysql-5.6
I am trying to compile MySQL 5.6 for install onto a Raspberry Pi (I need it for a geo module that wont work on 5.5, sigh...). I am attempting it like so, at someone else's recommendation: apt-get install build-essential debhelper devscripts debian-keyring dget http://ftp.de.debian.org/debian/pool/main/m/mysql-5.6/mysql-5.6_5.6.19-1~exp1.dsc cd mysql-5.6-5.6.19 dpkg-buildpackage -b (install any...

~150ms on a 2 million rows MySQL MyISAM table

mysql,performance,myisam,mysql-5.6
I'm learning about MySQL performance with a pet project consisting of ~2million rows + ~600k rows (two MyISAM tables). A range query using BETWEEN on two INT(10) indexed columns, LIMITed to 1 returned result takes about 160ms (including an INNER JOIN). I figure my configuration isn't optimised and am looking...

Using utf8mb4 in MySQL

mysql,utf-8,character-encoding,mysql-5.6,utf8mb4
In order to use 4-byte utf8mb4 in MySQL (5.6.11), I have set the following variables in the my.ini file (my.cnf is not found). This file is located in a hidden folder named Application Data (C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.6) on Windows XP. It is not available under the...

How to use one escaped argument with the Mysql Python connector

python,mysql,stored-procedures,python-3.3,mysql-5.6
I am using the official MySQL Python connector, but the example in the tutorial does not work for me with the specific query I am using. sql = "SHOW PROCEDURE STATUS WHERE Db = %s" cursor.execute(sql,('testdb')) # This throws an error, sql syntax error near %s The code cursor.execute("SHOW PROCEDURE...