Re: REPOST: MySQL 3.23.54 is a buggy, crashing piece of crap.

2003-02-17 Thread Zak Greant
On Mon, Feb 17, 2003 at 01:37:59AM -0600, Jason Maskell wrote: Perhaps the subject will get someone to actually read this and offer even one reply with a suggestion? I admit that the topic got my attention - perhaps not in the best way though. I can offer a few suggestions: Provide

Re: CREATE INDEX is sooo slow! any ideas?

2003-02-17 Thread Sergei Golubchik
Hi! On Feb 16, Dan Nelson wrote: In the last episode (Feb 16), Michael T. Babcock said: At 06:27 PM 2/16/2003 -0500, Peter Grigor wrote: Well, MySql stores all its index information in one index file, so when you add another index it has to rebuild the WHOLE file. :) Anyone

Re: REPOST: MySQL 3.23.54 is a buggy, crashing piece of crap.

2003-02-17 Thread Jason Maskell
The tables I am querying the most are quite small. I just query them a lot. The system processes about 500k requests a day, and each request involves multiple queries. I have just enabled a bunch of logging to try and puzzle out what is going on, but I can't see it being a help.. The same queries

Re: CREATE INDEX is sooo slow! any ideas?

2003-02-17 Thread Sergei Golubchik
Hi! On Feb 16, david wrote: Hi I have one table with 12 million records. I'm trying to create an index on one of the fields and it's taking hours ( over 6 so far)! Am I doing something wrong? The command I issued was create index title on article ( title); The table files are

Re: Extreme frustration with cryptic error messages

2003-02-17 Thread Sergei Golubchik
Hi! On Feb 17, Brandon Young wrote: Hello, all. I have been staring at this problem for an entire day. Googling turns up very little in the way of helpful information for solving my problem. I started a new tutorial, and ran into a problem. When I attempt to add a new database, I get

Mysql Table locking

2003-02-17 Thread Rob
Hi all, Can I just check, does MySql v.3.23.52 do table locking or row locking? If it only does table locking, are there any versions of mysql that do row locking? Thanks --- Rob ** Rob Cherry mailto:[EMAIL PROTECTED] +27 21 447 7440 Jam Warehouse RSA Smart Business

Mysql Table locking

2003-02-17 Thread Rob
Hi all, Can I just check, does MySql v.3.23.52 do table locking or row locking? If it only does table locking, are there any versions of mysql that do row locking? Thanks --- Rob ** Rob Cherry mailto:[EMAIL PROTECTED] +27 21 447 7440 Jam Warehouse RSA Smart Business

Re: Mysql Table locking

2003-02-17 Thread Zak Greant
On Mon, Feb 17, 2003 at 11:00:37AM +0200, Rob wrote: Hi all, Can I just check, does MySql v.3.23.52 do table locking or row locking? If it only does table locking, are there any versions of mysql that do row locking? Detailed in the fine manual:

Re: Mysql Table locking

2003-02-17 Thread Alec . Cawley
Can I just check, does MySql v.3.23.52 do table locking or row locking? If it only does table locking, are there any versions of mysql that do row locking? Always Read The Fine Manual: From http://www.mysql.com/doc/en/Locking_methods.html: Currently MySQL only supports table locking for

RE: Mysql Table locking

2003-02-17 Thread Rob
Thanks It would appear that MySql does table locking. Then I would like to ask the following: We have a documents table in our Document Management System, which obviously gets used quite a lot :-). We're running stress tests on our application (which is a PHP, Apache, MySql combo) and we're

Re: Mysql Table locking

2003-02-17 Thread Zak Greant
On Mon, Feb 17, 2003 at 11:22:27AM +0200, Rob wrote: Thanks It would appear that MySql does table locking. Then I would like to ask the following: Hi Rob, I think that you missed some important details. Taken from the manual: MySQL only supports table locking for ISAM/MyISAM and

È«ÃæÖ§³ÖJSP/ASP/PHP/ASP.NETÆóÒµ½¨Õ¾¿Õ¼ä³ÏÑû´úÀí.

2003-02-17 Thread grace
È«ÃæÖ§³ÖJSP/ASP/PHP/ASP.NETÆóÒµ½¨Õ¾¿Õ¼ä³ÏÑû´úÀí. ÎÒ˾ÍƳöÆóÒµ½¨Õ¾×¨Óÿռ䣬ȫÃæÖ§³ÖJSP¡¢ASP¡¢PHP¡¢ASP.NET£¬ÏÖÕýÃæÏòÈ«¹ú¸÷µØ³ÏÑû´úÀí£¬ÀûÈó¿É´ï40%£¡ *ÉêÇëʱ´´ÍøÂçµÄ´úÀí£¬³ýÁË¿ÉÒÔÏíÊÜÈ«·½Î»µÄ»¥ÁªÍø²úÆ··þÎñ£¬»¹¿ÉÒÔÃâ·Ñ»ñµÃÓòÃû¡¢¿Õ¼ä¡¢ÖÇÄܽ¨Õ¾¡¢¶¯Ì¬IPµÈµÄÔÚÏß×¢²á´úÂ룬·½±ãÄú¼°Ê±¿ªÕ¹ÒµÎñ¡£

RE: Mysql Table locking

2003-02-17 Thread Alec . Cawley
It would appear that MySql does table locking. Then I would like to ask the following: From what I've read, it would seem that SELECTS get a lower priority than INSERTS and UPDATES, meaning that if all 30 users insert into that table at the same time (given the way the stress test is

Bug? Update on 3 tables crashes in InnoDB

2003-02-17 Thread Martin Thoma
Can somebody confirm this please? Martin Subject: UPDATE over 3 tables crashes in InnoDB Description: I have 3 InnoDB-tables with about 6000 records each: customer 1:n orders 1:n invoices When trying to make the following update: update customer, orders,

Re: How to move database from one directory to another

2003-02-17 Thread Diana Soares
Hi, If you only want to move database Protein (and not all your databses) you can use symbolic links to do that. You can move your database to the desired path (external drive) and create a symbolic link in /var/lib/mysql/ to it like: localhost:/var/lib/mysql# ln -s /desired_path/Protein Protein

Re: Need Distinct and Min...

2003-02-17 Thread Roger Baklund
* Lewis Watson I have a table with three fields. In the first field I have a range of numbers 1-20; all repeated more than once. In the third field I have a number ranging from 1 to 20 in each row. I need to choose the lowest amount in the third column for each distinct value in the

Re: REPOST: MySQL 3.23.54 is a buggy, crashing piece of crap.

2003-02-17 Thread Benjamin Pflugmann
On Mon 2003-02-17 at 03:38:07 -0600, [EMAIL PROTECTED] wrote: Reply when you have a job, dumbass. I have a system that makes more in a week than you make in a year crashing because of this buggy piece of shit. If a system supposedly making millions a year is unstable you are a fool that you

Re: CREATE INDEX is sooo slow! any ideas?

2003-02-17 Thread Michael T. Babcock
Sergei Golubchik wrote: Which decision, putting all the indexes in one file, or rebuilding all indexes whenever you ALTER TABLE or add an index? If the latter, I agree with you. Modifying unrelated indexes or columns should not force a rebuild of every index. Of course not. And it won't

Re: auto_increment every year

2003-02-17 Thread alx
On Mon, 2003-02-17 at 12:57, [EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query,queries,smallint If you just reply to

Re: Query relational tables

2003-02-17 Thread Roger Baklund
* Dee I have a table that contains ids for several other tables. Setup is as followed: +--+--+--+-+-+ + | Field| Type | Null | Key | Default | Extra |

Re: mysql shutdown hangs-solaris

2003-02-17 Thread Sunil Gavaskar
Anybody can help this??? thanks regards sunil Hi, I am facing mysql shutdown process hanging problem on Solaris 5.8, mysql 3.23.40 I am running our product Web NMS which uses MySQL DB, on solaris machine. While shutting down the application, except MySQL process, all other process are

SSL connection from client

2003-02-17 Thread Maciej Bobrowski
Hi, I have installed the 4.0.10-gamma with support from the openssl v. 0.9.7 on the Debian Woody: mysqlstatus ... SSL:Cipher in use is DHE-RSA-AES256-SHA ... mysqlshow variables like '%openssl%'; +---+---+ | Variable_name | Value | +---+---+

Re: mysql shutdown hangs-solaris

2003-02-17 Thread Jerry
On Solaris I always use : /etc/rc3.d/S99mysqld stop /etc/rc3.d/S99mysqld start Jerry - Original Message - From: Sunil Gavaskar [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Sinisa Milivojevic [EMAIL PROTECTED] Sent: Monday, February 17, 2003 2:50 PM Subject: Re: mysql shutdown

Re: REPOST: MySQL 3.23.54 is a buggy, crashing piece of crap.

2003-02-17 Thread Benjamin Pflugmann
On Mon 2003-02-17 at 12:14:12 +0100, [EMAIL PROTECTED] wrote: [...] Please disregard this mail. It was not supposed to go to the list. (forgot to remove the CC that my mailer is set up to automatically append for mails going to my -mysql address). My apologies about that, Jason. Bye,

RE: How to write delete query??

2003-02-17 Thread Joe Stump
What you have there is a subselect, which are not supported in mysql 3.2x, but I *believe* are supported in 4.0+ (gamma and 4.1alpha). Don't take my word for it and check the docs first. --Joe -- Joe Stump [EMAIL PROTECTED] http://www.joestump.net Label makers are proof God wants Sys Admins to

RE: How to write delete query??

2003-02-17 Thread Inandjo Taurel
thanx joe, i checked. I just thought that there could be a way around this problem! From: Joe Stump [EMAIL PROTECTED] To: Inandjo Taurel [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: How to write delete query?? Date: Mon, 17 Feb 2003 09:46:53 -0800 MIME-Version: 1.0 Received: from

Re: How to write delete query??

2003-02-17 Thread Stefan Hinz
Inandjo, - delete from table1 where table1.field1 in (select distinct field2 from table2). Subselects (or nested queries) like that are supported as of MySQL 4.1. At this moment, you will have to compile 4.1 yourself; it's expected to be out as a binary version in the next couple of weeks. The

RE: How to write delete query??

2003-02-17 Thread Bill Kratochvil
Inandjo - delete from table1 where table1.field1 in (select distinct field2 from table2) From what I've read subqueries are not yet supported. We worked around this by converting the distinct list to a comma delimited list of values. E.g.,

How to delete from only one side of a join?

2003-02-17 Thread Mayo, Chuck
Hi all, Just jumped on the list, hoping someone can give me a hand. The query below uses a join, I guess, to select records from table stat_1_1 based on information in table stat. I'd like to be able to turn this query into a delete query but only want records removed from stat_1_1. Can anyone

mysql@lists.mysql.com

2003-02-17 Thread cf
mysql:ÄúºÃ! Èç¹ûÄãÏÖÔÚÏëÕõÇ®µÄ»°£¬http://platinum-mails.ebiz-enterprises.com/?r=chenggong´ò¿ªºó×¢²á£¬×¢²áÓÐ$50£¬Ã¿½éÉÜһλÓÐ$15,$200Æ𸶠[×¢Òâ]Ҫ׬Ǯ¾Í¿´°¡~ºÃ¶«Î÷~ ׬ǮµÄºÃ·½·¨£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡ ²»ÂÛÄãÐŲ»ÐŶ¼²»·ÁÊÔÊÔ°É

Checking existence of a table.

2003-02-17 Thread ed
What query would I use to check for an existence of a table within a database? I'm currently writting a set of scripts in php. Is this possible with MySQL or do I need to create a condition within PHP? Thanks, Ed mysql -

RE: Checking existence of a table.

2003-02-17 Thread Simon Green
show tables from databasename; Simon -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 17 February 2003 16:11 To: [EMAIL PROTECTED] Subject: Checking existence of a table. What query would I use to check for an existence of a table within a database? I'm

Re: Checking existence of a table.

2003-02-17 Thread Paul DuBois
At 11:10 -0500 2/17/03, [EMAIL PROTECTED] wrote: What query would I use to check for an existence of a table within a database? I'm currently writting a set of scripts in php. Is this possible with MySQL or do I need to create a condition within PHP? You can check the output of SHOW TABLES or

Re: How to delete from only one side of a join?

2003-02-17 Thread Paul DuBois
At 9:32 -0600 2/17/03, Mayo, Chuck wrote: Hi all, Just jumped on the list, hoping someone can give me a hand. The query below uses a join, I guess, to select records from table stat_1_1 based on information in table stat. I'd like to be able to turn this query into a delete query but only want

Re: How to delete from only one side of a join?

2003-02-17 Thread Paul DuBois
At 9:32 -0600 2/17/03, Mayo, Chuck wrote: Hi all, Just jumped on the list, hoping someone can give me a hand. The query below uses a join, I guess, to select records from table stat_1_1 based on information in table stat. I'd like to be able to turn this query into a delete query but only want

Re: Checking existence of a table. (finished)

2003-02-17 Thread ed
Thanks for all the replies. I've got a hnadle on it now. Ed On Mon, 17 Feb 2003, Paul DuBois wrote: At 11:10 -0500 2/17/03, [EMAIL PROTECTED] wrote: What query would I use to check for an existence of a table within a database? I'm currently writting a set of scripts in php. Is this

very slow count

2003-02-17 Thread Israel Yulzary
Hello, When using the following on MySQL: select count(xFld) from aTbl group by xFld; I get twice the time it takes to process: select xFld from aTbl group by xFld; Can any one explain this and maybe help find a solution? I'm using MySQL version 3.23.54 on NT and 3.23.41 on Linux, both

RE: Checking existence of a table.

2003-02-17 Thread Don Read
On 17-Feb-2003 [EMAIL PROTECTED] wrote: What query would I use to check for an existence of a table within a database? I'm currently writting a set of scripts in php. Is this possible with MySQL or do I need to create a condition within PHP? Thanks, function tableexists($tbl) {

RE: renaming temporary table

2003-02-17 Thread Arne . Muller
Hello, I've tried to rename a temporary table, and I got an error ERROR 1017: Can't find file: './GOdevel/xgp.frm'). I guess it does not make too much sense to rename a temp table ... . However, I thought this might be worth mentioning. regards, Arne not to be bounced:

Re: Re: auto_increment every year

2003-02-17 Thread Paul DuBois
sql,query,queries,smallint HI all I'm searching in how to generate a auto_increment number starting form 1 every year I mean ID DATE 1 2003 2 2003 1 2004 2 2004 etc maybe possible or I've to use some c code to make it possible ? Yes, this is possible.

Re: Checking existence of a table.

2003-02-17 Thread Stefan Hinz
Ed, What query would I use to check for an existence of a table within a database? I'm currently writting a set of scripts in php. Is this possible with MySQL or do I need to create a condition within PHP? In MySQL, you can issue: SHOW TABLES [FROM your_database] LIKE 'your_pattern' Where

Re: Bug? Update on 3 tables crashes in InnoDB

2003-02-17 Thread Heikki Tuuri
Martin, this bug in multi-table UPDATE on InnoDB tables was reported 3 weeks ago and Sinisa has fixed it to upcoming 4.0.11. Regards, Heikki Innobase Oy sql query .. Subject: Bug? Update on 3 tables crashes in InnoDB From: Martin Thoma Date: Mon, 17 Feb 2003 11:57:12 +0100

Re: Red Hat 8.0 compile problems with 4.0.10

2003-02-17 Thread Heikki Tuuri
Hi! I have the same problem in my new Red Hat 8.0 / Athlon 1.8 GHz laptop. If I build MySQL-4.0.10 from source with ./BUILD/compile-pentium-debug it crashes in installing MySQL system tables. If I use a MySQL binary distro to install the system tables, then the mysqld I built may crash in

Re: List

2003-02-17 Thread David T-G
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jerry, et al -- ...and then Jerry said... % % Is it just me or is everyone on the list getting junk/spam from naver.com ? Haven't seen any, assuming you spelled it right. I just checked through my entire mysql folder and have only your and

mysql 3.23.55 broken if compiled with -all-static

2003-02-17 Thread Carlos
Hi, Compilation of mysql 3.23.55 fails ONLY when using --with-mysqld-ldflags=-all-static results in broken mysqld. Segmentation fault? Resolving stack trace: 0x808f4d4 _Z15handle_segfaulti + 404 0x81bc67a __pthread_sighandler + 122 0x81ceb4d __strtol_internal + 1421 0x8096cf6

Bug in ORDER BY

2003-02-17 Thread Ken Goff
I have encountered what appears to be a bug in MySQL regarding ORDER BY related to a date field when also used in conjunction with DATE_FORMAT() or UNIX_TIMESTAMP(). When these functions are applied to my date field, MySQL ignores any included ORDER BY within the query. I first noticed this

re: Need Distinct and Min...

2003-02-17 Thread Egor Egorov
On Monday 17 February 2003 04:20, Lewis Watson wrote: I have a table with three fields. In the first field I have a range of numbers 1-20; all repeated more than once. In the third field I have a number ranging from 1 to 20 in each row. I need to choose the lowest amount in the third

max_user_connections

2003-02-17 Thread Michael T. Babcock
It would be nice to extend the user permissions table to have per-user limits like max_user_connections and the various timeouts applying directly to specific user/host combinations. Just a thought / suggestion. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. SQL

Invalid domain names

2003-02-17 Thread Bob Balsover
6@74 is obviously not a real email address but this is happening on a fairly regular basis from this mailing list. I can't see the message so I can't tell if it is spam or not but if you are not seeing your messages on the group then you might want to see if your email client is confused about who

C API metadata bug

2003-02-17 Thread matt neuburg
Server version 3.23.55-entropy.ch Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Apple PowerBook G3 running Mac OS X 10.2.4 I'm using the distribution provided at Marc Liyanage's site:

Re: max_user_connections

2003-02-17 Thread Jeremy Zawodny
On Mon, Feb 17, 2003 at 02:33:05PM -0500, Michael T. Babcock wrote: It would be nice to extend the user permissions table to have per-user limits like max_user_connections and the various timeouts applying directly to specific user/host combinations. Agreed. We've had a few circumstances

Re: MySQL DB structure for scrolling list

2003-02-17 Thread Frank Peavy
At 04:58 PM 2/17/03 +0100, you wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query,queries,smallint If you just reply to this message, and include

Re: MySQL DB structure for scrolling list

2003-02-17 Thread Paul DuBois
sql,query,queries,smallint I am in the process of designing a form and I am a little confused. I would like to have a scrolling window, in which the user can select multiple items. For example, the scrolling window may contain operating systems, and the user has the ability to select multiple

Re: max_user_connections

2003-02-17 Thread Stefan Hinz
Michael, It would be nice to extend the user permissions table to have per-user limits like max_user_connections and the various timeouts applying directly to specific user/host combinations. As of MySQL 4.0.2, you can set some limits per user. Here's an excerpt from my mysql.user table:

Re: max_user_connections

2003-02-17 Thread Michael T. Babcock
Stefan Hinz wrote: It would be nice to extend the user permissions table to have per-user limits like max_user_connections and the various timeouts applying directly to specific user/host combinations. As of MySQL 4.0.2, you can set some limits per user. Here's an excerpt from my

Inserting '#' char as part of a field

2003-02-17 Thread Robby Tanner
Hello, I tried to insert a # as part of a field and got an error from the server saying that I had an error in my SQL statement at line 1 F:\\BL. The error number is (8000) and the value is supposed to be F:\\BL#. I understand that MySQL is interpretting that as a comment identifier. I

MySQL and Apache

2003-02-17 Thread Barry Fawthrop
Greetings, In trying the MySQL and Apache links found on the page doc/en/Apache.html I was trying the second option Why when I tried the CustomLog |mysql -host... option above it didn't work ? I like the second option over the first because the SQL database is updated instantly a log entry

received 0 length packet from server

2003-02-17 Thread Jeremy Tinley
Howdy, Running MySQL 3.23.54 on master, 3.23.55 on all slaves, I'm experiencing the following situation: slave1 slave4 both receive 0 length packets from the server. slave2 slave3 both work fine. slave1 2 are identical machines both in hardware and configuration slave3 4 are different from

Re: Inserting '#' char as part of a field

2003-02-17 Thread Stefan Hinz
Robby, How can I get MySQL (via ZeosDBO in Delphi 5) to accept the # sign? Add extra quotes or a backslash before the character? Use double quotes? Some other method? I know about nothing of Delphi and Zeos, but I'd try a backslash before the # character. Here's what I get with the mysql

RE: Inserting '#' char as part of a field

2003-02-17 Thread Robby Tanner
I solved the issue (eventually) by using a different control. It seems the batch component interprets #'s differently than regular table and query components. I'll use query components in the future. Thanks anywaym, Rob -Original Message- From: Stefan Hinz [mailto:[EMAIL

Oh GAWD somone HELP :)

2003-02-17 Thread Poodle
Just installed mysql nice one i though set it all up read the nessasary docs nice one i thought tried to connect remotly [root@tasha root]# mysqladmin -h 192.168.0.2 version -uroot -ppassword mysqladmin: connect to server at '192.168.0.2' failed error: 'Lost connection to MySQL server during

Finding an available index

2003-02-17 Thread Craig Woodford
Hi, This is my first post to this mailing list, so please forgive me if my message is not structured in the correct format. My query is this. Where a column used as a unique identifier for a record contains the values 1,2,3,5. Is a mysql query possible that will retrieve 4 as an available

Database Backup Question

2003-02-17 Thread Loren McDonald
This is actually more a PHP question but since it refers to a MySQL database I thought I would ask here. I may not be looking in the right places but, I can't seem to find a way to do a database backup through PHP (other than BACKUP TABLE, which I don't want to use if possible) What I mean is

Re: Database Backup Question

2003-02-17 Thread KH Chiu
Sorry I am in a bit hurry and just post some hints on your question. It is more than one way to do your job. One of the trival way is to use php function 'exec'. This function can execute shell programs. It means that you can execute mysqldump etc. and create dump file. From my experience, you

Re: Oh GAWD somone HELP :)

2003-02-17 Thread KH Chiu
You should add a user who allow to connect from 192.168.0.2 before you can connect to MySQL remotely. Further more, make sure that your host can reverse lookup 192.168.0.2. This can be done by add an entry in the /etc/hosts or create a DNS entry. Regards, Just installed mysql nice one i

Locked Threads

2003-02-17 Thread Peter Bryant
First, an update. After waiting a few days for a FULLTEXT index to build on a 3.23.5* database, I updated the database server to MySQL 4.0.10 on advice from Sergei Golubchik on this list: http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:132146:200302:cdpckkcecgnggcboabda The index rebuild took

Is this possible with Linux

2003-02-17 Thread kk
Hello folks (BIs it possible to install a MySQL server into the /home/*username* (Bdirectory in a typical Linux Installation. If so (B1. where to put those my.cnf files and set the global options for a (Bparticular user. (B2. How to connect to that database from a remote machine, knowing

Slow Fulltext Search on Large Table

2003-02-17 Thread Peter Bryant
My problem is that my fulltext searches run quite slowly. I have a 2300MB table with 4.3M rows and an index (primarily a fulltext index) of 1300M. My hardware is a dual Athlon MP1500+ with 2GB of memory. I am running MySQL 4.0.10. My my.cnf includes: set-variable = key_buffer=16M

AW: Checking existence of a table. query

2003-02-17 Thread Franz, Fa. PostDirekt MA
Hi Ed, What query would I use to check for an existence of a table within a database? SHOW TABLES LIKE 'table_name'; might help. prosit Klaus - Before posting, please check: http://www.mysql.com/manual.php (the

RE: Database Backup Question

2003-02-17 Thread Loren McDonald
That's exactly what I was looking for and the way I hoped it could be done, only I hadn't seen anything about this 'exec' function. Thanks. I should be able to figure it out myself but I will get back with you if I need further help. -- Loren McDonald AKA MisterrMac Gods Of Music

RE: Bug in ORDER BY

2003-02-17 Thread Steven Roussey
SELECT * FROM EventList ORDER BY 'EventDate', 'EventOrder' LIMIT 50; I'm surprised you happened to get anything in order. Maybe the message got simplified by the list manager, but did you really mean to order by a constant string? Why not: SELECT * FROM EventList ORDER BY `EventDate`,

rownum

2003-02-17 Thread geeta varu
does mySQL have rowid or rownum if yes please give an exampl __ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com - Before posting,

Re: Oh GAWD somone HELP :)

2003-02-17 Thread Poodle
i can coneect from localhost and all machines can see all machines i made users with access from hosts i made users with database access from hosts still the same - Original Message - From: Bryan Lipscy [EMAIL PROTECTED] To: 'Poodle' [EMAIL PROTECTED] Sent: Tuesday, February 18, 2003

Re: Oh GAWD somone HELP :)

2003-02-17 Thread Poodle
Well thats the thing, I did an more than one user that was allowed to connect TO 192.168.0.2 from various hosts on my network and all hosts can reverse lookup from my dns server. no good - Original Message - From: KH Chiu [EMAIL PROTECTED] To: Poodle [EMAIL PROTECTED]; [EMAIL PROTECTED]