Peter Brawley wrote:
Steve,
Look for 'FIELD(' at
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html.
PB
Thanks, Pete!
For posterity, this is how I solved the problem:
To create an abitrary for the ORDER BY clause, create a field like this:
SELECT
FIELD( field,
"arbitrary sor
Hey folks -
I have a project where I need to sort rows by an arbitrary order. I seem
to recall at some point where I was able to do some SQL like:
ORDER BY
type = "the first type",
type = "another type",
type = "yes another arbitrary type" ...
However, my arbitrary ORD
Actually, it came from Mysql 4.1.1 (not 4.1.3 as I mentioned earlier).
When I do select queries, the data displays just fine, but when I dump,
I get this garbage.
Jeremy Cole wrote:
Hi Steve,
I'm trying to export data from mysql 4.1.3 with mysqldump.
I'm getting weird characters from the system.
Hey folks --
I'm trying to export data from mysql 4.1.3 with mysqldump.
I'm getting weird characters from the system. Here's what I've discovered
so far:
' becomes ^À^Ù, e.g. didn't becomes didnâ^À^Ùt
- becomes â^À^Ó, e.g. 1-2 becomes 1â^À^Ó2
è becomes è, e.g. Entrèe becomes Entrèe
What giv
only want to have parent rows delete their children. When
would I use these other key restraint types?
Steve Lefevre
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
First of, thanks to all who replied to my questions earlier!
Now I have another problem. I have a table of Classes and Workshops. Each
Class has a number of workshops. Each workshop has a date.
I have a query that gives me the date range of a class - the min and max
dates of its workshops.
"sele
I'm designing a user database for PHP 4 and MySQL 3.32 or whatever.
Users enter a class and it's workshops for their students.
The 'Class' table has fields 'Name' and 'ID'.
ID is the primary key and its an auto-incremented integer
The 'Workshop' table has a field ID, Number, ClassID, Date, etc.
