RE: [jp] Unions in mysql 3.22

2003-11-18 Thread Barry Byrne
-Original Message- From: Jorge Paiva (f2) [mailto:[EMAIL PROTECTED] Sent: 18 November 2003 15:14 To: [EMAIL PROTECTED] Subject: [jp] Unions in mysql 3.22 CAN I USE UNION cluse in mysql 3.22?? No! UNION is implemented in MySQL 4.0.0 and later. - Barry -- MySQL General

RE: Last 75 entries from a table

2003-11-06 Thread Barry Byrne
-Original Message- From: Mark [mailto:[EMAIL PROTECTED] Sent: 06 November 2003 13:40 To: [EMAIL PROTECTED] Using MySQL 3.23.58, what I want is to select the last 75 entries from a table. Like so: SELECT article_num FROM $table LIMIT 75 Except, of course, that this gives me the

RE: Mysql on panther

2003-11-06 Thread Barry Byrne
-Original Message- From: Nestor Florez [mailto:[EMAIL PROTECTED] Sent: 06 November 2003 15:28 My OS X does not have my.cnf anywhere on the machine. :-) Copy/edit on of the my-*.cnf files from the support-files directory in the mysql distribution directory to /etc/my.cnf I

RE: User-Level Access

2003-11-03 Thread Barry Byrne
-Original Message- From: Fernando Melo [mailto:[EMAIL PROTECTED] Inside my program (PHP) I want to provide a field where the user can select a database. Since I don't want clients accessing into other clients' databases, I need to do user-level access control within MySQL whereby

RE: Unable to Retrieve HTML Form Values(test1.html) from a PHP Page(test1.php)

2003-10-28 Thread Barry Byrne
-Original Message- From: Prashant A [mailto:[EMAIL PROTECTED] Our Site is running on Linux/Apache/PHP/MySQL Combination. I am unable to retrieve the Values passed from HTML FORM(test1.html) in a PHP Page(test1.php) Is it something to do with the Web Server Settings or any thing

RE: Change of root password

2003-10-28 Thread Barry Byrne
-Original Message- From: Parminder Singh Chauhan [mailto:[EMAIL PROTECTED] After long struggle I (A newbee to linux) was able to setup mysql4.0.16 and I don't know what I have done, I set the root password which I don't know. Now I can't access the mysql. Is there anyway of

RE: SELECT Question

2003-10-22 Thread Barry Byrne
-Original Message- From: Jean-Pierre Schwickerath [mailto:[EMAIL PROTECTED] Hello Mumba, Hello Barry, How do I select out and filter only rows that match both 16 and 62 in the KEYW_ID col? IE. The query would return only 119 and 108? I'm sure this could be done more

RE: SELECT Question

2003-10-20 Thread Barry Byrne
-Original Message- From: Mumba Chucks [mailto:[EMAIL PROTECTED] I've been given a table to work with, and I'm not meant to change it: - | TABLE_NAME | TBL_IDX | KEYW_ID | - | PROPERTIES | 108 | 16