looks like it's using the correct indicesI don't know what else
to do...
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 27, 2003 12:23 AM
To: Twibell, Cory L
Cc: [EMAIL PROTECTED]
Subject: Re: Table Query taking WAY TO LONG...HELP PLEA
All,
I have a query that is inner joined with another table based on country codes
Select distinct Name.* from Name inner join Location on Location.key =
Name.key and Location.cc in ('');
The problem is when I have more than 2 country codes, the query takes forever...
When I show processlist, it
Hi,
I am trying select field / 1 as Number from table1 where id = 1;
I don't want any rounding taking place, but MySQL is currently doing it.
How can I ask for a specific number of digits with division?
The field contains 1234.5678, MySQL returns 1234.57, don't want that!
Thanks,
Cory Twibe
IL PROTECTED]
Subject: Re: Help with privilege tables - IMPORTANT
"Twibell, Cory L" <[EMAIL PROTECTED]> wrote:
>
> I have the user table which contains user record
> | Host | User| Pass | Select...|
> ---
> |% |
Did you flush the privileges after you gave root a password?
The error you get is a result of not using a password to login.
-Original Message-
From: Ola Ogunneye [mailto:[EMAIL PROTECTED]
Sent: Monday, June 30, 2003 6:05 PM
To: [EMAIL PROTECTED]
Subject: Access Denied for User: [EMAIL PRO
Yes, I have the UPDATE for table B. I belive this is a bug.
-Original Message-
From: Mike Hillyer [mailto:[EMAIL PROTECTED]
Sent: Monday, June 30, 2003 4:47 PM
To: Twibell, Cory L; [EMAIL PROTECTED]
Subject: RE: Help with privilege tables - IMPORTANT
Hmm, if you have UPDATE privilege on
003 4:22 PM
To: Twibell, Cory L; [EMAIL PROTECTED]
Subject: RE: Help with privilege tables - IMPORTANT
Well, with that in mind, does the user have the appropriate INSERT
privileges?
Regards,
Mike Hillyer
www.vbmysql.com
> -Original Message-
> From: Twibell, Cory L [mailto:[EMAI
My user in the user table has NO privileges. All privileges for that user
are done in the db table. Using MySQL 4.1.0-alpha
-Original Message-
From: Mike Hillyer [mailto:[EMAIL PROTECTED]
Sent: Monday, June 30, 2003 3:41 PM
To: Twibell, Cory L; [EMAIL PROTECTED]
Subject: RE: Help with
All,
I have the user table which contains user record
| Host | User| Pass | Select...|
---
|% || | N... |
The db record is
| Host | Db| User | Select...|
--
| %| Test1 || 'Y'
After I use mysql_free_result(), I immediately set the resultset to NULL.
-Original Message-
From: Adam Lawrence [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 19, 2003 11:36 AM
To: [EMAIL PROTECTED]
Subject: C API - mysql_free_result
Stats: MySQL 4.0.13, under Windows98, using the C API
The below query is not good, due to the fact that if name and age aren't
unique, I'll be returning multiple ids with it. One should always use the
LAST_INSERT_ID() or after an insert, select max(id) from myTable.
-Original Message-
From: Carter, Scott [mailto:[EMAIL PROTECTED]
Sent: Wednes
Check out LAST_INSERT_ID() in the manual
-Original Message-
From: Jonas Geiregat [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 18, 2003 12:26 PM
To: 'Mysql'
Subject: probably a stupid question
Hey,
Here is what I want to do
I have 2tables
let's say table A and B for simplicity.
in tab
Hello,
I don't know if this has been answered, but here goes. I am using MySQL
4.1.0-alpha with the C api. Using the C api because not yet using the STL.
Anyway, is this true, If I make a call to mysql_options and give it a new
options file, does that fill in the database handle with options from
13 matches
Mail list logo
