RE: Does MySql support Synchronous/asynchronous I/O

2001-09-18 Thread The Tilghman
doesn't support raw disk devices. I stand corrected. -Tilghman -- A computer without Windows is like a chocolate cake without mustard. -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 18, 2001 11:52 On Tue, Sep 18, 2001 at 07:53:23AM -0500

RE: get_lock()

2001-02-14 Thread The Tilghman
It's purely advisory locking. You aren't locking anything other than a certain value within the server itself. The benefit comes only if all clients agree to use the same advisory locking schema. -Tilghman -- "There cannot be a crisis today. My schedule is already full."

RE: special characters messing me up

2001-02-13 Thread The Tilghman
mv file file~ ; tr -d '\015' file~ file ; rm file~ Or, in vim, :set fileformat=unix Or, use PFE32.EXE on Windows as your editor (allows saving as Unix text file). -Tilghman -- "There cannot be a crisis today. My schedule is already full." --Henry Kissinger -Origin

RE: problems running mySQL via Telnet

2001-02-08 Thread The Tilghman
of an overall security strategy, and you should invest some time in developing a complete security solution, if you haven't already. However, this is now almost completely off-topic. -Tilghman -- "There cannot be a crisis today. My schedule is already full." --Henry Kissinger ---

RE: Finding Duplicates and Deleteing

2001-02-08 Thread The Tilghman
Depending upon the function of the table, you might consider designing your table such that duplicates aren't possible (e.g. putting a UNIQUE index on a column or set of columns). Other than that, try dumping your table, removing the rows you don't want, and reloading the table. -Tilghman

RE: Bug converting string into integer

2001-02-07 Thread The Tilghman
It's a bug either in your processor or in your distribution libraries. Your SELECT returns correctly on my Linux and FreeBSD servers. -Tilghman -- "There cannot be a crisis today. My schedule is already full." --Henry Kissinger -Original Message- From: Federic

RE: PRIMARY KEY (userid), UNIQUE (userid)

2001-02-07 Thread The Tilghman
No. A primary key is a unique key, by definition. -- "There cannot be a crisis today. My schedule is already full." --Henry Kissinger -Original Message- From: Jacob Friis Larsen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 09:58 To: [EMAIL PROTECTED]

RE: problems running mySQL via Telnet

2001-02-07 Thread The Tilghman
You're trying to use a Telnet client with a MySQL server. Instead, use a MySQL client with a MySQL server and a Telnet client with a Telnet server. Mixing protocols doesn't really work for anybody. -Tilghman -- "There cannot be a crisis today. My schedule is already full."

RE: slicing strings for comparison?

2001-02-07 Thread The Tilghman
to be accurate. -Tilghman -- "There cannot be a crisis today. My schedule is already full." --Henry Kissinger -Original Message- From: Cindy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 13:33 To: [EMAIL PROTECTED] Subject: slicing strings for comparison?

RE: slicing strings for comparison?

2001-02-07 Thread The Tilghman
PROTECTED]] Sent: Wednesday, February 07, 2001 15:32 To: The Tilghman; 'Cindy'; [EMAIL PROTECTED] Subject: RE: slicing strings for comparison? Does the post office offer this info? There used to be a service (Melissa) that had Lat. and Long. for the center of each zip code. You

RE: CHECK variable incorrect?

2001-02-07 Thread The Tilghman
Two things: 1) Read the manual to see the correct syntax for the CREATE TABLE. 2) Constraints don't actually do anything in MySQL. Again, read the manual. -Tilghman -- "There cannot be a crisis today. My schedule is already full." --Henry Kissinger -Original Message-

RE: Select a range from 0-9 or A-z

2001-02-06 Thread The Tilghman
Check out REGEXP in the manual. -- "There cannot be a crisis today. My schedule is already full." --Henry Kissinger -Original Message- From: Ung, Seng [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 06, 2001 11:03 To: [EMAIL PROTECTED] Subject: Select a range from 0-9 or

RE: problems migrating from mysql 3.22.22 to 3.23.32

2001-02-02 Thread The Tilghman
'when' is a reserved word in 3.23 -- "There cannot be a crisis today. My schedule is already full." --Henry Kissinger -Original Message- From: Noah Romer [mailto:[EMAIL PROTECTED]] Sent: Friday, February 02, 2001 14:38 In the process of moving a database to a new server, I

RE: How to select the 10 last items from a table?

2001-01-31 Thread The Tilghman
Try sorting in DESCending order. SELECT * FROM item ORDER BY id DESC LIMIT 10; -Tilghman -- "There cannot be a crisis today. My schedule is already full." --Henry Kissinger -Original Message- From: Remco van den Berg [mailto:[EMAIL PROTECTED]] Sent: Tuesday, Januar

RE: Auto-Increment - how can I avoid repeating IDs?

2001-01-30 Thread The Tilghman
Upgrade to 3.23. -- "There cannot be a crisis today. My schedule is already full." --Henry Kissinger -Original Message- From: Viken Nokhoudian [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 30, 2001 14:58 I am using MySQL ver. 3.22.32 When a table has an

RE: Browser-based client UI design question

2001-01-26 Thread The Tilghman
One approach might be to use a hierarchal menu -- first level is first letter of the company, second level is all of the companies whose names begin with that letter. Or, set a search to pull up the list of companies which contain a certain phrase. -Tilghman -- "There cannot be a crisis

RE: sql problem - it may be a version problem ??

2001-01-24 Thread The Tilghman
That feature is only available in 3.23, while you're running 3.22. Upgrade your server and you'll get it. -- "There cannot be a crisis today. My schedule is already full." --Henry Kissinger -Original Message- From: lrado [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24,

RE: mysqld crashes on FreeBSD 4.2

2001-01-23 Thread The Tilghman
Typically, processes which die with either a signal 10 or 11 are due to hardware problems, such as bad memory or an overheating CPU. You might consider trying a memory tester or simply do a 'make world' in /usr/src (to heavily tax the CPU and memory). -Tilghman -- "There cannot be a c

RE: Syntax error in my Update staement

2001-01-23 Thread The Tilghman
Kill the final comma, i.e. ... SET SailPort = ?, SailDate = ?, Deleted = ? WHERE ... -- "There cannot be a crisis today. My schedule is already full." --Henry Kissinger -Original Message- From: Don [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 23, 2001 13:24 To:

RE: Selecting a random record

2001-01-15 Thread The Tilghman
See section 7.39 of the manual. 'when' is a reserved word in 3.23. -- "There cannot be a crisis today. My schedule is already full." --Henry Kissinger -Original Message- From: Alan Halls [mailto:[EMAIL PROTECTED]] Sent: Monday, January 15, 2001 15:15 To: [EMAIL PROTECTED]