MySQL 5.0 : MySQL's First Major 5.0 Release

learn more… | top users | synonyms

0
votes
1answer
20 views

Trying to combine one row from one table with mulitple rows from another table but not sure if I'm doing it right?

The Situation I have two tables unit and unit_translations defined as: CREATE TABLE `unit` ( `id` int(11) NOT NULL auto_increment, `title` varchar(255) NOT NULL COMMENT 'Title of unit', ...
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
47 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 ...