Hi,
you should have a list in the user table of mysql database :
mysql use mysql
Database changed
mysql show tables;
+---+
| Tables_in_mysql |
+---+
| columns_priv |
| db|
| func |
|
On 6/26/05, 2wsxdr5 wrote:
Can someone tell me why this query works...
SELECT UserKey
FROM(
SELECT UserKey, Count(GiftKey) Gifts
FROM Gift
Group BY UserKey
) GC
WHERE GC.Gifts = 3
Why this construction and not simply:
SELECT UserKey
FROM Gift
GROUP BY UserKey
HAVING Count(GiftKey) =
Hi,
your enum canbe NULL and is not indexed. So you can insert values not in enum,
replaced by NULL.
a solution is to UNIQUE index the enum column, and insert a unique bad value in
it.
Any value not in enum can not then be inseted :
mysql create table enum_test(id int, name enum('test1','test2')
Hey Mathias,
See the results below. I just have 1 database called test;
There is no user database.
mysql
mysql use mysql
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
mysql show tables
- ;
ERROR 1046: No Database Selected
mysql select database
- ;
ERROR 1064: You
You are not granted access to mysql.
So ask your root user to modify your password.
impossible else.
Mathias
Selon Yannick [EMAIL PROTECTED]:
Hey Mathias,
See the results below. I just have 1 database called test;
There is no user database.
mysql
mysql use mysql
ERROR 1044: Access
Zen Kishimoto [EMAIL PROTECTED] wrote:
Subject: [mysql 11629] 6月号のニュースレター
Date: Fri, 24 Jun 2005 17:40:50 -0700
From: Zen Kishimoto [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: [EMAIL PROTECTED], [EMAIL PROTECTED]
岸本@大阪です。6月号のニュースレターを
お届けします。
ー
Hi,
There is a lot a pain here.
I downloaded the rpm packages
MySQL-server-4.1.12-1.i386.rpm
MySQL-shared-4.1.12-1.i386.rpm
MySQL-bench-4.1.12-1.i386.rpm
MySQL-shared-compat-4.1.11-0.i386.rpm
MySQL-client-4.1.12-1.i386.rpm
MySQL-devel-4.1.12-1.i386.rpm
Selon mm [EMAIL PROTECTED]:
Hi,
There is a lot a pain here.
I downloaded the rpm packages
MySQL-server-4.1.12-1.i386.rpm
MySQL-shared-4.1.12-1.i386.rpm
MySQL-bench-4.1.12-1.i386.rpm
MySQL-shared-compat-4.1.11-0.i386.rpm
MySQL-client-4.1.12-1.i386.rpm
mm wrote:
There is a lot a pain here.
I downloaded the rpm packages
that's where the pain starts :-)
If you're trying to run multiple versions of MySQL for pre-migration
testing (or whatever), *don't use rpms* -- get the tar file of the
binary, and just untar it as /usr/local/mysql-4.1.12 or
Hi,
is there anyway that I can have more than 20 digits for integer (bigInt)? If
not, what I can use for database index?
-
Yahoo! Sports
Rekindle the Rivalries. Sign up for Fantasy Football
Hi,
I'm not sure you understand the issue. I have the root in linux but not in
mysql !
All I want is to install mysql on my linux suse 9.0. Of course, I have the
root access one the server !
As discussed below, I can not add any password on my sql.
All I want is to know how to do it ! I've
Hi!
I'm not sure you understand the issue. I have the root in linux
but not in mysql! All I want is to install mysql on my linux suse
9.0. Of course, I have the root access one the server! As
discussed below, I can not add any password on my sql.
All I want is to know how to do it ! I've
hi Yannick,
This is my ultimate help.
See this url, you have all in it :
http://dev.mysql.com/doc/mysql/en/unix-post-installation.html
And all you want is here :
http://www.mysql.com/search/?q=Installation
If you're root, install mysql as root. At the end, change the mysql root
password to a
Hey,
Thanks for your help till so far but I'm still with my issue ! Is there any
other support possible?
FYI, I just reinstalled it with a higher version and the same issue is
comming.
I can not access mysql as root ! Please have a close look below :
fujitsu:/home/yannick # mysql -u root
Try :
fujitsu:/home/yannick # mysql -u root -p
Then ENTER
fujitsu:/home/yannick # mysql -u root -h localhost -P 3306 -p
Then ENTER
Mathias
Selon Yannick [EMAIL PROTECTED]:
Hey,
Thanks for your help till so far but I'm still with my issue ! Is there any
other support possible?
FYI, I just
I have PERL DBI/DBD installed.
What SQL do I issue to obtain list of all tables with PK for a given database?
What SQL do I issue to obtain the SQL source to (re)create all indexes for a
given database?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
I'm using a query similar to the following to get an ordered list.
SELECT ORDER BY Subscriber ASC, Name ASC;
How do I change this so that if the 'Name' field begins with The that
the sort begins on the second word? In other words I'd like to be able
to return the word The but have it
You can use:
SELECT ..
order by case substring(Name,1,4) when 'The ' then
substring(Name,5,800) else Name end
Un saludo
Juan Pedro
Jack Lauman wrote:
I'm using a query similar to the following to get an ordered list.
SELECT ORDER BY Subscriber ASC, Name ASC;
How do I change this
You can use:
SELECT ..
order by case substring(Name,1,4) when 'The ' then
substring(Name,5,800) else Name end
Un saludo
Juan Pedro
Jack Lauman wrote:
I'm using a query similar to the following to get an ordered list.
SELECT ORDER BY Subscriber ASC, Name ASC;
How do I change
Jack Lauman wrote:
SELECT ORDER BY Subscriber ASC, Name ASC;
How do I change this so that if the 'Name' field begins with The that
the sort begins on the second word? In other words I'd like to be able
to return the word The but have it sort on whatever the second word is.
SELECT...
Is The your only problem word? What about A or An and other words that
are usually ignored when sorting things like book titles?
I'd be surprised if there was any way to ignore specific words in an ORDER
BY; I've been writing SQL for 20+ years and have never seen anything like
that.
I think what
I can see I'm going to have to review the manual pages on ORDER BY; sorry, I
didn't realize that MySQL's ORDER BY allowed these sorts of expressions.
I use DB2 most of the time and I was speaking on the assumption that MySQL's
capabilities in the ORDER BY were very close to those of DB2, which is
Selon Jack Lauman [EMAIL PROTECTED]:
I'm using a query similar to the following to get an ordered list.
SELECT ORDER BY Subscriber ASC, Name ASC;
How do I change this so that if the 'Name' field begins with The that
the sort begins on the second word? In other words I'd like to be
My thanks to all that responded. I used Mathias's suggestion to solve
the problem. You can see the results here.
http://www.tasteofwhatcom.com/restaurants-tow/filter.jsp?field=cityvalue=Blaine
Thanks again for your help.
Jack
Mathias wrote:
Selon Jack Lauman [EMAIL PROTECTED]:
I'm
I realise that this question may better be asked in a php list, but I
already did that and got *no* answers.
Does anyone know if there are some mysql dlls available for php-4.3.x (
I'm running 4.3.11) that are compiled against 4.1.x so I don't have to
use the ugly hacks to get the old client to
Selon Daniel Kasak [EMAIL PROTECTED]:
I realise that this question may better be asked in a php list, but I
already did that and got *no* answers.
Does anyone know if there are some mysql dlls available for php-4.3.x (
I'm running 4.3.11) that are compiled against 4.1.x so I don't have to
Mathias wrote:
haven't try WAMP5 ?
http://www.wampserver.com/en/
I didn't know of this site, no. I'm new to Windows, at least on the server.
Unfortunately they seem to be sticking with Apache-1.3, and I'd really
rather go with Apache-2, since all my experience has been with it. I've
read a
You have the choice between this :
http://dev.mysql.com/doc/mysql/en/application-password-use.html
and this :
The optimal solution when migrating to MySQL 4.1+ from a previous version is to
upgrade to PHP 5 (if you're not using it already) and rewrite any code
accessing MySQL using the mysqli
Mathias wrote:
The optimal solution when migrating to MySQL 4.1+ from a previous version is to
upgrade to PHP 5 (if you're not using it already) and rewrite any code
accessing MySQL using the mysqli extension, which is more secure and provides a
much better API.
'much better' API :)
Perhaps.
A couple of months ago these was a discussion about ZIP code plotting on
this list. Does anyone know how to calculate LONG/LAT coordinates from
ZIP+4?
Thanks,
Jack
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Greetings,
I am using MySQL 4.0.24 and all my tables use InnoDB as default
engine. I was interested in finding out the performance of my Buffer
space. How can i do it?. If I were to use MyISQM tables, I could have
looked at the parameters Key_read_request key_reads to find out the
hit rate
Jack Lauman [EMAIL PROTECTED] writes:
A couple of months ago these was a discussion about ZIP code plotting
on this list. Does anyone know how to calculate LONG/LAT coordinates
from ZIP+4?
In the U.S., you can use the census data:
http://www.census.gov/geo/www/gazetteer/places2k.html
Hi, everyone:
I had done a test on Linux2.6. I got the max connections of 1079 when I
complied the MySQL with static link. But I got the max connections of 7159
when I complied the MySQL with dynamic link. Why has so much difference
between the static link and dynamic link? Has anybody know
Hi,
Thank you very much for the reply.
$dbh-do(SET character_set_results=ujis');
This works! Is there any way I can set this value on MySQL config file,
so I don't need to change all my scripts?
Right now my my.cnf looks like:
[mysqld]
default-character-set=ujis
You have to purchase a database. ZIP codes are not geographic, you
can't calculate lat/lon from them. Here is one source:
http://www.zipwise.com
On Jun 26, 2005, at 6:43 PM, Scott Gifford wrote:
Jack Lauman [EMAIL PROTECTED] writes:
A couple of months ago these was a discussion about ZIP
I recomend the PHP Home Edition Project at http://phphome.sourceforge.net/.
It installs PHP, Apache and MySql, all configed to work together on a
Windows machine.
Version PHP Home 2.3.2 installs PHP v.4.3.3, Apache 2.0 and MySql 4.x (Note
the latest version is 2.3.4 and includes PHP 5). I have
Brian Dunning [EMAIL PROTECTED] writes:
You have to purchase a database. ZIP codes are not geographic, you
can't calculate lat/lon from them. Here is one source:
http://www.zipwise.com
As I said below, you can download a free database from the US Census
Bureau. Specifically, the data here:
Dude, that's more than 5 years old.
On Jun 26, 2005, at 8:27 PM, Scott Gifford wrote:
Brian Dunning [EMAIL PROTECTED] writes:
You have to purchase a database. ZIP codes are not geographic, you
can't calculate lat/lon from them. Here is one source:
http://www.zipwise.com
As I said below,
38 matches
Mail list logo