MySQL 5.0 : MySQL's First Major 5.0 Release

learn more… | top users | synonyms

0
votes
1answer
39 views

Large query with subquery runs indefinitely after mysql update

We recently did a big server update, in the process migrating from mysql-5.0 to 5.5.40 Several of the queries, which had been running well on the old server, now grind everything to a screeching halt. ...
0
votes
0answers
33 views

Enable general_log in Mysql 5.0.96

I want to enable general_log in MySql 5.0.96. I have set log variable but it isn't working. [mysqld] log=/var/log/mysql.log and restart mysql with following command /etc/init.d/mysql restart But ...
0
votes
0answers
13 views

I have a row which has 10 columns in which many column have 'a' as a character in it

How to write a query for searching the pattern if there is 'any' single character in the row or rows in the table.
0
votes
0answers
77 views

CREATE VIEW joining two tables, only displaying rows from the first table with the most recent date in the second table

I have multiple tables. My main table has a composite key consisting of a phone number and an order number. I want to create a VIEW where only the subscriptions with the most recent order date are ...