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/1
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 specif
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
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 t
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 qty1q
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
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.
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 Engineer
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 Engineeri
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 PR
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 us
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 a
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
13 matches
Mail list logo
