MySQL 5.0 : MySQL's First Major 5.0 Release

learn more… | top users | synonyms

0
votes
0answers
9 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
55 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 ...