RE: GRANT TO SELECTED COLUMNS

[richardb]

Hi Chris/Lists,
Thanks, I'll take note of your comments.
As per Paul D, probably the error is by not naming the specific columns in 
the SELECT query. SELECT * will give an error since testuser has no access 
for the other columns...

Thanks Again, Richard



"Chris" <[EMAIL PROTECTED]>13/11/2003 11:35 AM


To: "Mysql List" <[EMAIL PROTECTED]>
cc: (bcc: BORNAY Richard/Engr/STATS/ST Group)
Subject: RE: GRANT TO SELECTED COLUMNS







You can't login as testuser and try to give yourself privileges, it just
doesn't work.

GRANT SELECT ON DATABASE.CHECK_SBIN TO testuser IDENTIFIED BY 'password'
   Put an entry into mysql.user, with the host set to '%' [Any host, are 
you
sure that's what you want?] and all privileges set to 'N'. It also put an
entry into mysql.tables_priv (testuser@'%') giving testuser Select
privileges on the table DATABASE.CHECK_SBIN [Note, this gives testuser
select privileges to the whole table, so it doesn't even check column 
level
Select privileges]

GRANT SELECT (id, jobid) ON DATABASE.CHECK_SBIN TO testuser
   Added the colum,n Select privilege to mysql.tables_priv.Column_priv and
add an entry into mysql.columns_priv for testuser@'%' giving access to the
specified fields.

Since the testuser has Select privileges on the whole table, you get all 
the
columns. So all your troubles came from running the first query, giving
testuser Full select privileges on the table.

running this query as root should fix your problem:
REVOKE SELECT ON DATABASE.CHECK_SBIN FROM testuser;

if that doesn't work you might try unsetting the Select privilege FROM
mysql.tables_priv.Table_priv WHERE User='testuser' AND Host='%'

Chris

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 6:56 PM
To: [EMAIL PROTECTED]
Subject: RE: GRANT TO SELECTED COLUMNS


Hi Chris/Lists,
In fact, I was able to login using both ways, here's what I did.
1. mysql -u testuser -ptestuser -hlocalhost DATABASE  >> OK
2. In the mysql prompt, I issue the query 'SELECT * FROM CHECK_SBIN'  >>
Access denied
** This is were I'm getting the error Access denied for user
'testuser'

Thanks, Richard



"Chris" <[EMAIL PROTECTED]>13/11/2003 10:34 AM


To: "Mysql List" <[EMAIL PROTECTED]>
cc: (bcc: BORNAY Richard/Engr/STATS/ST Group)
Subject: RE: GRANT TO SELECTED COLUMNS







That second query, byt itself, should have done it, were you logged in as
testuser when you tried to run it?

Chris

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 5:26 PM
To: [EMAIL PROTECTED]
Subject: GRANT TO SELECTED COLUMNS


Hello List,
I have a table named CHECK_SBIN with fields id,jobid,filename,sbin,count,
then I would like to create an account lets say testuser with SELECT
privileges only to a specific columns. In this case I would like to open
only id and jobid to 'testuser'.
I have already created an account to testuser in two ways using the
commands below.
1. Provide SELECT privileges first on the CHECK_SBIN table
 -  GRANT SELECT ON DATABASE.CHECK_SBIN TO testuser IDENTIFIED BY
'password'   >> OK
Then issue another GRANT statement for the specific columns
 - GRANT SELECT (id, jobid) ON DATABASE.CHECK_SBIN TO testuser   >> OK

Comments:
I was able to access mysql using the account and seeing only
CHECK_SBIN but when I do 'SELECT * FROM CHECK_SBIN' it shows
me all the columns in the table.

2.  Use only the second SQL
 - GRANT SELECT (id, jobid) ON DATABASE.CHECK_SBIN TO testuser   >> OK

 Comments:
An error occured 'Access denied for  testuser'.

Note: The grant tables are all checked correctly.

System:
MySQL 4.0.13
Solaris 8

I checked the manual and mailing list archive and was not successful in
finding any related matter to my problem. Any help would be appreciated.

Thanks, Richard


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: GRANT TO SELECTED COLUMNS

[richardb]

Hi Paul/Lists,
Thank you for your very clear explanations...
In my 1st option, I think I misunderstood p427 of your book(MySQL) by 
granting first a SELECT privileges on the table before issuing the UPDATE 
on specific columnsSo now I learned that It should not be the case for 
SELECTING specific columns.
In my 2nd option,
Yes, thats my expectation when issuing SELECT *  command will only give 
the privileged columns even  there are other columns in the table.

NOTE: I already tried to SELECT the specific columns (by naming it 
explicitly) and it worked now...

Thanks Again, Richard



Paul DuBois <[EMAIL PROTECTED]>13/11/2003 11:14 AM


To: BORNAY Richard/Engr/STATS/ST [EMAIL PROTECTED] Domain, [EMAIL PROTECTED]
cc: 
Subject: RE: GRANT TO SELECTED COLUMNS







At 10:55 AM +0800 11/13/03, [EMAIL PROTECTED] wrote:
>Hi Chris/Lists,
>In fact, I was able to login using both ways, here's what I did.
>1. mysql -u testuser -ptestuser -hlocalhost DATABASE  >> OK
>2. In the mysql prompt, I issue the query 'SELECT * FROM CHECK_SBIN'  >>
>Access denied
> ** This is were I'm getting the error Access denied for user
>'testuser'
>
>Thanks, Richard

That looks correct.

Your requirements are unclear:

In your first attempt, you grant access to the entire table with one
GRANT statement, then to just a couple of columns with the second GRANT
statement.  This gives you access to the entire table (because of the
first statement), which apparently is unsatisfactory -- you say you want
access granted only for the two columns.

In your second attempt, you grant access only to the two columns.
This should, I think, give you what you want -- but then above you
issue a SELECT * statement, which implies that you want access to the
entire table.  But you can't *have* access to the entire table, because
you've granted access only to two columns.

So I at least am unable to determine what you really want.

Perhaps you are thinking that SELECT * should retrieve only those columns
for which you have access.  But that's not what it means.  It means ALL
columns in the table.  To select only the columns for which you have 
granted
access, you must name them explicitly.

The exception would be if the table contains only those two columns.
In that case, SELECT * should work.  But my impression is that your
table has more than just the two columns.

>
>
>
>"Chris" <[EMAIL PROTECTED]>13/11/2003 10:34 AM
>
>
>To: "Mysql List" <[EMAIL PROTECTED]>
>cc: (bcc: BORNAY Richard/Engr/STATS/ST Group)
>Subject: RE: GRANT TO SELECTED COLUMNS
>
>
>
>
>
>
>
>That second query, byt itself, should have done it, were you logged in as
>testuser when you tried to run it?
>
>Chris
>
>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>Sent: Wednesday, November 12, 2003 5:26 PM
>To: [EMAIL PROTECTED]
>Subject: GRANT TO SELECTED COLUMNS
>
>
>Hello List,
>I have a table named CHECK_SBIN with fields id,jobid,filename,sbin,count,
>then I would like to create an account lets say testuser with SELECT
>privileges only to a specific columns. In this case I would like to open
>only id and jobid to 'testuser'.
>I have already created an account to testuser in two ways using the
>commands below.
>1. Provide SELECT privileges first on the CHECK_SBIN table
>  -  GRANT SELECT ON DATABASE.CHECK_SBIN TO testuser IDENTIFIED BY
>'password'   >> OK
> Then issue another GRANT statement for the specific columns
>  - GRANT SELECT (id, jobid) ON DATABASE.CHECK_SBIN TO testuser   >> 
OK
>
>Comments:
> I was able to access mysql using the account and seeing only
>CHECK_SBIN but when I do 'SELECT * FROM CHECK_SBIN' it shows
> me all the columns in the table.
>
>2.  Use only the second SQL
>  - GRANT SELECT (id, jobid) ON DATABASE.CHECK_SBIN TO testuser   >> 
OK
>
>  Comments:
> An error occured 'Access denied for  testuser'.
>
>Note: The grant tables are all checked correctly.
>
>System:
>MySQL 4.0.13
>Solaris 8
>
>I checked the manual and mailing list archive and was not successful in
>finding any related matter to my problem. Any help would be appreciated.
>
>Thanks, Richard


-- 
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

Are you MySQL certified?  http://www.mysql.com/certification/


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: GRANT TO SELECTED COLUMNS

[richardb]

Hi Chris/Lists,
In fact, I was able to login using both ways, here's what I did.
1. mysql -u testuser -ptestuser -hlocalhost DATABASE  >> OK
2. In the mysql prompt, I issue the query 'SELECT * FROM CHECK_SBIN'  >> 
Access denied
** This is were I'm getting the error Access denied for user 
'testuser'

Thanks, Richard



"Chris" <[EMAIL PROTECTED]>13/11/2003 10:34 AM


To: "Mysql List" <[EMAIL PROTECTED]>
cc: (bcc: BORNAY Richard/Engr/STATS/ST Group)
Subject: RE: GRANT TO SELECTED COLUMNS







That second query, byt itself, should have done it, were you logged in as
testuser when you tried to run it?

Chris

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 5:26 PM
To: [EMAIL PROTECTED]
Subject: GRANT TO SELECTED COLUMNS


Hello List,
I have a table named CHECK_SBIN with fields id,jobid,filename,sbin,count,
then I would like to create an account lets say testuser with SELECT
privileges only to a specific columns. In this case I would like to open
only id and jobid to 'testuser'.
I have already created an account to testuser in two ways using the
commands below.
1. Provide SELECT privileges first on the CHECK_SBIN table
 -  GRANT SELECT ON DATABASE.CHECK_SBIN TO testuser IDENTIFIED BY
'password'   >> OK
Then issue another GRANT statement for the specific columns
 - GRANT SELECT (id, jobid) ON DATABASE.CHECK_SBIN TO testuser   >> OK

Comments:
I was able to access mysql using the account and seeing only
CHECK_SBIN but when I do 'SELECT * FROM CHECK_SBIN' it shows
me all the columns in the table.

2.  Use only the second SQL
 - GRANT SELECT (id, jobid) ON DATABASE.CHECK_SBIN TO testuser   >> OK

 Comments:
An error occured 'Access denied for  testuser'.

Note: The grant tables are all checked correctly.

System:
MySQL 4.0.13
Solaris 8

I checked the manual and mailing list archive and was not successful in
finding any related matter to my problem. Any help would be appreciated.

Thanks, Richard


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

GRANT TO SELECTED COLUMNS

[richardb]

Hello List,
I have a table named CHECK_SBIN with fields id,jobid,filename,sbin,count, 
then I would like to create an account lets say testuser with SELECT 
privileges only to a specific columns. In this case I would like to open 
only id and jobid to 'testuser'.
I have already created an account to testuser in two ways using the 
commands below.
1. Provide SELECT privileges first on the CHECK_SBIN table
 -  GRANT SELECT ON DATABASE.CHECK_SBIN TO testuser IDENTIFIED BY 
'password'   >> OK
Then issue another GRANT statement for the specific columns
 - GRANT SELECT (id, jobid) ON DATABASE.CHECK_SBIN TO testuser   >> OK

Comments:
I was able to access mysql using the account and seeing only 
CHECK_SBIN but when I do 'SELECT * FROM CHECK_SBIN' it shows
me all the columns in the table.

2.  Use only the second SQL 
 - GRANT SELECT (id, jobid) ON DATABASE.CHECK_SBIN TO testuser   >> OK

 Comments:
An error occured 'Access denied for  testuser'.

Note: The grant tables are all checked correctly.

System:
MySQL 4.0.13
Solaris 8

I checked the manual and mailing list archive and was not successful in 
finding any related matter to my problem. Any help would be appreciated.

Thanks, Richard

Getting the first 3 highest value

[richardb]

Hi List,
I have a problem wherein I need to get the first 3 highest value in 
separate columns.
My tables were I actually retrieve the data looks like this, this is a 
child table that's
why the fk_id is the same, so the LIMIT clause would not be possible for 
the result:

fk_id   bin qty1qty2
1   3   2   6   -> 8
1   800 9   5   ->14
1   2   10  1   ->11
1   7   3   3   ->6
1   10  8   5   ->13
1   15  1   9   ->10
1   23  10  2   ->12

You will notice two qty value on the same bin, what I would like to do is 
add the 2 qty per bin
and get the first 3 highest values like:

fk_id   1st_highest_bin   1st_highest_qty   2nd_highest_bin 
2nd_highest_qty   3rd_highest_bin3rd_highest_qty 
1   800   1410 13  23   12

I did try to generate a query but only up to the highest value and was not 
able to get the 2nd and 3rd highest.
Is this possible using only a query or needed an API to generate?? I will 
really appreciate your help.

Thanks in advance.

--
Richard Bornay 
ST Assembly Test Services
Test Product Engineering
Test Data Management Group
6824-1367

Re: ERROR: Lost Connection ### RESOLVED

[richardb]

Hi Lists,
Just like to share what I found out in resolving my own problem.
Actually, my script is using the mysqlimport client in loading a file to 
mysql and did not noticed that I used the option '-r'(replace) when I 
first created the script.  When I upgrade to 4.0.13, I created an index to 
 the SUMMARY table to prevent record duplication.

I just removed the -r option then no more error displayed and my script 
runs smoothly..

Hope this will be a useful tip.

Thanks
--
Richard Bornay 
ST Assembly Test Services
Test Product Engineering
Test Data Management Group
6824-1367


BORNAY Richard/Engr/STATS/ST [EMAIL PROTECTED] Domain02/08/2003 03:39 PM


To: [EMAIL PROTECTED]
cc: (bcc: BORNAY Richard/Engr/STATS/ST Group)
Subject: ERROR: Lost Connection







Hi List,
Does anyone knows why this error message is displaying when I ran a cshell 

script which is using mysql and mysqlimport client commands? I encountered 

this after I upgrade from 4.0 gamma to 4.0.13.

Error: Lost connection to MySQL server during query, when using table: 
SUMMARY

Thanks.

--
Richard Bornay 
ST Assembly Test Services
Test Product Engineering
Test Data Management Group
6824-1367

ERROR: Lost Connection

[richardb]

Hi List,
Does anyone knows why this error message is displaying when I ran a cshell 
script which is using mysql and mysqlimport client commands? I encountered 
this after I upgrade from 4.0 gamma to 4.0.13.

Error: Lost connection to MySQL server during query, when using table: 
SUMMARY

Thanks.

--
Richard Bornay 
ST Assembly Test Services
Test Product Engineering
Test Data Management Group
6824-1367

Re: Deleting duplicating records

[richardb]

Hi Karam,
I would suggest to CREATE A TEMP TABLE with SELECT DISTINCT ... query in 
your table, then do TRUNCATE  TABLE to your existing table..
You can just add indexes before you insert back the records from the TEMP 
TABLE...




--
Richard Bornay 
ST Assembly Test Services
Test Product Engineering
Test Data Management Group
6824-1367


Karam Chand <[EMAIL PROTECTED]>29/07/2003 01:13 AM


To: Venelin Arnaoudov <[EMAIL PROTECTED]>, [EMAIL PROTECTED], 
[EMAIL PROTECTED]
cc: [EMAIL PROTECTED], (bcc: BORNAY Richard/Engr/STATS/ST Group)
Subject: Re: Deleting duplicating records







Great.

So in that case I need to create a new table with
similar structure with a additional UNIQUE index on
email.

Karam

--- Venelin Arnaoudov <[EMAIL PROTECTED]> wrote:
> I would copy all the records (_email_, max(version))
> to a new table, 
> drop the old one and then rename the new one
> 
> Regards,
> Venelin
> 
> Karam Chand wrote:
> 
> >Well that is OK if I have only one email.
> >
> >What if if I have thousands of users duplicated...
> >
> >Do I need to write SQL query 1000 times
> >
> >Karam
> >--- Jeff McKeon <[EMAIL PROTECTED]> wrote:
> > 
> >
> >>How bout
> >>
> >>Delete from tablename where email like
> >>[EMAIL PROTECTED] && ID <> 1
> >>
> >>Jeff
> >> 
> >>
> >>>-Original Message-
> >>>From: Karam Chand
> [mailto:[EMAIL PROTECTED]
> >>> 
> >>>
> >>>Sent: Monday, July 28, 2003 10:33 AM
> >>>To: [EMAIL PROTECTED]
> >>>Subject: Deleting duplicating records
> >>>
> >>>
> >>>Greetings
> >>>
> >>>I manage a website wherein i keep track of the
> >>> 
> >>>
> >>people
> >> 
> >>
> >>>email who have downloaded my software and the
> >>> 
> >>>
> >>version
> >> 
> >>
> >>>number.
> >>>
> >>>the structure is like -
> >>>
> >>>id int auto_increment primary key,
> >>>email char,
> >>>version 
> >>>
> >>>now the same person can download different
> version
> >>>therfore my table has data like this -
> >>>
> >>>1,[EMAIL PROTECTED],1.0
> >>>2,[EMAIL PROTECTED],2.0
> >>>3,[EMAIL PROTECTED],3.0
> >>>
> >>>Now I want to delete all the records wherein all
> >>> 
> >>>
> >>rows
> >> 
> >>
> >>>with duplicate email addresses are deleted so
> that
> >>> 
> >>>
> >>i
> >> 
> >>
> >>>have data like
> >>>
> >>>1,[EMAIL PROTECTED],1.0
> >>>...
> >>>
> >>>What should be the query? Thanks in advance.
> >>>
> >>>Karam
> >>>
> >>>__
> >>>Do you Yahoo!?
> >>>Yahoo! SiteBuilder - Free, easy-to-use web site
> >>> 
> >>>
> >>design 
> >> 
> >>
> >>>software http://sitebuilder.yahoo.com
> >>>
> >>>-- 
> >>>MySQL General Mailing List
> >>>For list archives: http://lists.mysql.com/mysql
> >>>To unsubscribe: 
> >>>http://lists.mysql.com/mysql?>
> >>> 
> >>>
> >>[EMAIL PROTECTED]
> >> 
> >>
> >>> 
> >>>
> >>--
> >>MySQL General Mailing List
> >>For list archives: http://lists.mysql.com/mysql
> >>To unsubscribe: 
> >>
> >> 
> >>
>
>http://lists.mysql.com/[EMAIL PROTECTED]
> > 
> >
> >
> >
> >__
> >Do you Yahoo!?
> >Yahoo! SiteBuilder - Free, easy-to-use web site
> design software
> >http://sitebuilder.yahoo.com
> >
> > 
> >
> 
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: 
>
http://lists.mysql.com/[EMAIL PROTECTED]
> 


__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Innodb logfiles

[richardb]

Is it possible to manually delete the logfiles created in innodb tables 
and then do a 'touch logfilename' to recreate it?
If this is not the proper way, can somebody help me on this; there's no 
specific explanations in the mysql manual..

Thanks.


BRgds,
--
Richard Bornay 
Test Product Engineering
Test Data Management Group
ST Assembly Test Services
6824-1367

Re: Exists anything like Oracle TO_DATE('31/12/2003','dd/mm/yyyy') ?

[richardb]

use DATE_FORMAT(date, format)
e.g:
DATE_FORMAT("1999-12-01", "%M %e, %Y") -> "December 1, 1999"
*taken from Paul Dubois MySQL book



BRgds,
--
Richard Bornay 
Test Data Managment
ST Assembly Test Services
6824-1367


"Marcos Pomar" <[EMAIL PROTECTED]>20/06/2003 05:36 PM


To: [EMAIL PROTECTED]
cc: (bcc: BORNAY Richard/Engr/STATS/ST Group)
Subject: Exists anything like Oracle TO_DATE('31/12/2003','dd/mm/') ?







Hi everybody,

Is there any function like Oracle TO_DATE in order to insert a date into a 

DATE type field according to a different format than -mm-dd? I wish to 

insert a date into a date field but my date format is "dd/mm/". If 
not, 
is there any workaround using mysql functions? AFAIK mysql reference does 
not mention this...


Thanks,

Marc Pomar

_
Dale rienda suelta a tu tiempo libre. Encuentra mil ideas para exprimir tu 

ocio con MSN Entretenimiento. http://entretenimiento.msn.es/


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SELECT ' ä'='\\' gives 1

[richardb]

mine is getting a 0 at solaris2.7

mysql> select 'a'='\';
+--+
| 'a'='\' |
+--+
|0 |
+--+
1 row in set (0.04 sec)

mysql> status
--
mysql  Ver 12.16 Distrib 4.0.9-gamma, for sun-solaris2.7 (sparc)

Connection id:  159
Current database:
Current user:   dbadmin
SSL:  Not in use
Current pager:  stdout
Using outfile:  ''
Server version: 4.0.9-gamma
Protocol version: 10
Connection:   10.83.67.88 via TCP/IP
Client characterset:latin1
Server characterset:latin1
TCP port: 3306
Uptime: 3 days 18 hours 14 min 26 sec

Threads: 1  Questions: 1847  Slow queries: 16  Opens: 406  Flush tables: 9
Open tables: 3  Queries per second avg: 0.006

WHY???


Stefan Hinz <[EMAIL PROTECTED]> 20/02/2003 10:58 PM
Please respond to Stefan Hinz
   

  To:  Christian Mattick <[EMAIL PROTECTED]>  

  cc:  [EMAIL PROTECTED], (bcc: BORNAY Richard/Engr/STATS/ST Group)

  Subject: Re: SELECT 'ä'='\\' gives 1 

   

   

   






Christian,

> SELECT 'ä' = '\\';
> gives 1 as result!

Not on my server, and with my character set (latin1_de):

mysql> STATUS
--
mysql  Ver 12.18 Distrib 4.0.10-gamma, for Win95/Win98 (i32)

Connection id:  6
Current database:   menagerie
Current user:   superuser@localhost
SSL:Not in use
Server version: 4.0.10-gamma-max-nt-log
Protocol version:   10
Connection: localhost via TCP/IP
Client characterset:latin1_de
Server characterset:latin1_de
TCP port:   3306
Uptime: 1 hour 8 min 5 sec

Threads: 2  Questions: 462  Slow queries: 4  Opens: 10  Flus
--

mysql> SELECT 'ä' = '\\';
++
| 'ä' = '\\' |
++
|  0 |
++
1 row in set (0.00 sec)

Regards,
--
  Stefan Hinz <[EMAIL PROTECTED]>
  iConnect GmbH 
  Heesestr. 6, 12169 Berlin (Germany)
  Telefon: +49 30 7970948-0  Fax: +49 30 7970948-3

[filter fodder: sql, mysql, query]


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




[This e-mail is confidential and may also be privileged. If you are not the
intended recipient, please delete it and notify us immediately; you should
not copy or use it for any purpose, nor disclose its contents to any other
person. Thank you.]



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Mysqlimport 4.0 not working to mysql 3.23 server??

[richardb]

Hi to All Mysql Gurus,

I have 2 existing workstations which has both Mysql 3.23 client and server,
then I upgrade one of them to Mysql 4.0. To check,  I use mysql client of
Mysql 4.0 to access the database of  Mysql 3.23 server(which was on the 2nd
workstation) and  worked perfectly. I was also able to create a new table
ACTL_MAT_VW  from database FPY_BRT on Mysql 3.23 but when I used the
mysqlimport from Mysql 4.0 to populate that table , I'm having an error.
The error looks like this:

  %> mysqlimport -u username -ppassword -h (ip addr of the other
workstation) - - delete - - fields-terminated-by=, FPY_BRT ACTL_MAT_VM
%> mysqlimport: Error: File ' ./FPY_BRT/ACTL_MAY_VW' not
found (Errcode: 2), when using table: ACTL_MAT_VW

I believe there's nothing wrong with the syntax since I'm using this with
3.23 version, how about the compatibility of Mysql 4.0 and Mysql 3.23?
Appreciate your advise on this matter.

Another question:
Is it possible to use a different version of client programs in accessing a
different version of server in one machine or diff machine? Let's say I'm
using Mysql 4.0 server but Mysql 3.23 client programs. Can you pls. quide
me or redirect me to proper installation in the mysql documentation.  I'm
asking this because I'm thinking that If I use Mysql 3.23 client programs
like mysqlimport to access the 2nd machine I will not encounter the same
error above.

I will greatly appreciate any help coming from the lists..

Thanks,
Richard







[This e-mail is confidential and may also be privileged. If you are not the
intended recipient, please delete it and notify us immediately; you should
not copy or use it for any purpose, nor disclose its contents to any other
person. Thank you.]



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Need Help!!!

[richardb]

Hi to All,

I've been a member of this mailing list for quite a long time and very
thankful that most of my difficulty in creating queries are being answered
by just reading responses to questions. Right now I have a problem in
creating a query (in fact I'm not sure if this is possible) that will get
data from two tables and display its row from one table followed by the
same row number of the other table.

Table1
col_1   col_2col_3col_4
AAAA
AAAA
AAAA
AAAA
AAAA
AAAA
AAAA
.
.
.

Table2
col_1   col_2col_3col_4
B   BBB
B   BBB
B   BBB
B   BBB
B   BBB
B   BBB
B   BBB
.
.
.

Query result
col_1   col_2col_3col_4
AAAA
B   BBB
AAAA
B   BBB
AAAA
B   BBB
AAAA
.
.
.

I will really appreciate any of your help in accomplishing this.

Thanks in advance,
Richard




[This e-mail is confidential and may also be privileged. If you are not the
intended recipient, please delete it and notify us immediately; you should
not copy or use it for any purpose, nor disclose its contents to any other
person. Thank you.]



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php