Re: Unusual sort

On 24-nov-2007, at 0:29, Jim wrote: I have a table containing web site host names, most of them having both a "name.com" and "www.name.com" version, that I'd like sorted in the following manner: axxx.com www.axxx.com bxxx.com www.bxxx.com wxxx.com www.wxxx.com zxxx.com www.zxxx.com Any wa

query using connected username

, I'd be able to limit access by using views for example. Can this be done? Is it documented somewhere? Groet, Peter Teunissen --- mrwhite:~ oneman$ man woman No manual entry for woman -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscrib

restoring from sqldump with accented characters

e charset expicitly set to latin1 (ENGINE=InnoDB DEFAULT CHARSET=latin1) So I don't think I should need to add another charset. Still somehow the data was entered into the original database. Any hints on how I could solve this problem? Thanks, Peter Teunissen -- Never argue with id

acquire mysql knowledge in short time

Hi All, For an opensource project at work, I need to get to know mysql in a few days. I need some advise on what to read and what tutorials to work through. We are going to build a data warehouse using mysql 5.0. We will try to build the entire ETL stream using sql scripts and stored p

Re: Deleted Root Account

On 6-mei-2007, at 0:37, John Kebbel wrote: Fortunately, I'm learning MySQL on my home machine, so this MEGA-Mistake doesn't sink a Fortune 500 corporation. I was experimenting with a batch file that ... (1) Created a set of user accounts with tiered privileges, (2) Set password