RE: Downsides of MySQL?

2001-08-16 Thread Tyrone Mills
In my previous job supporting MSSQL at hospitals all across North America, Europe and Australia, Critical Incident support from M$, ranged from 36 hours to 4 days for a resolution. Often we solved it ourselves long before we had an answer from M$... Sad really... MySQL support is far superior,

Re: ACCESS DB, and MySQL which one better to handle database driv en webpage

2001-06-22 Thread Tyrone Mills
Sounds like you could be a reference site for Microsoft!! Only 2 corruptions using Access multi-user. That's incredibly good. I've supported systems with only 3 concurrent users who suffered corruption on a nearly daily basis. - Original Message - From: John Meyer [EMAIL PROTECTED] To:

Re: phpMyAdmin newbie problem

2001-06-19 Thread Tyrone Mills
Drop the semi-colon off the end of the SQL Statement you wish to run. You don't need them in the phpMyAdmin SQL Window. Enjoy, Tyrone - Original Message - From: Tommy Beavitt [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 19, 2001 8:31 AM Subject: Re: phpMyAdmin newbie

RE: Collapsing queries

2001-06-15 Thread Tyrone Mills
Try this: SELECT * FROM content, address WHERE content.msg_id = address.msg_id If I understand what your asking for, you want a JOIN. If I don't understand, forgive me, it's late... :) Tyrone -Original Message- From: matteo [mailto:matt@web]On Behalf Of Matthieu Paindavoine Sent:

RE: Mysql SELECT command

2001-06-14 Thread Tyrone Mills
On the internet specifically I'd say try http://www.mysql.com/manual.php , it's one of the better manuals I've come across (Free Software or Commercial). If you want an excellent book, get MySQL by Paul DuBois. Also 'The Practical SQL Handbook' is good, although not MySQL specific. Best of

Autoincrement Column reverting to zero...

2001-06-06 Thread Tyrone Mills
SQL, QUERY I posted a little while back with a problem on several tables where the autoincrement column reverted to zero for no apparent reason. Now I know the reason, I just don't understand it, or know what to do differently. I find myself in the all too common situation where I can

Re: Newbie with PHP

2001-06-05 Thread Tyrone Mills
Can you post some code? - Original Message - From: Harry Bakken [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 05, 2001 8:09 AM Subject: Newbie with PHP I apologize if this seems simple, or stupid, or if there is an answer in the archives. I am under an extreme deadline

RE: Duplicate entry '0' for key 1

2001-05-13 Thread Tyrone Mills
PROTECTED]] Sent: Sunday, May 13, 2001 9:06 AM To: Tyrone Mills; Mysql@Lists. Mysql. Com Subject: RE: Duplicate entry '0' for key 1 What's your datatype? Cal http://www.calevans.com -Original Message- From: Tyrone Mills [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 13, 2001 10:59 AM

RE: Duplicate entry '0' for key 1

2001-05-13 Thread Tyrone Mills
: Tyrone Mills [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 13, 2001 11:24 AM To: Mysql@Lists. Mysql. Com Subject: RE: Duplicate entry '0' for key 1 Here's the CREATE TABLE syntax I used on the latest table to do this to me... CREATE TABLE site_users ( user_id INTEGER UNSIGNED DEFAULT '0

Help please!!!

2001-05-12 Thread Tyrone Mills
I think I have a corrupt table and my most recent backup is too old to use. Here's the scenario: I started getting duplicate key errors for no apparent reason. The column is a medium int, the highest value was 260 (or there abouts) and it was trying to insert a 0. So I whipped out my MySQL

RE: MySQL HA

2001-05-09 Thread Tyrone Mills
High Availabilty -Original Message- From: Billy Passauer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 1:00 PM To: carlos ospina; [EMAIL PROTECTED] Subject: RE: MySQL HA -Original Message- From: carlos ospina [mailto:[EMAIL PROTECTED]] I wanna know if someone has

RE: installing on linux

2001-02-22 Thread Tyrone Mills
The .sh designates that the file is a shell script. Linux doesn't do file associations like windows does. You could call it anything, and as long as it's an executable file, it'll run. CHMOD the files you need to run. -Original Message- From: Mac Martine [mailto:[EMAIL PROTECTED]] Sent: