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

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

Getting the first 3 highest value

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 qty1

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.

Re: ERROR: Lost Connection ### RESOLVED

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

Re: Deleting duplicating records

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

Innodb logfiles

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

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

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]

Mysqlimport 4.0 not working to mysql 3.23 server??

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

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

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

Need Help!!!

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