i'd try something like
select t.name, d.domain
from domain_types t, domains d
where t.type_id = d.type_id
group by t.name
order by t.type_id
or something with a 'join on t.type_id = d.type_id'
-yves
-Ursprüngliche Nachricht-
Von: Alec Smith [EMAIL PROTECTED]
An: [EMAIL PROTECTED]
Hi!
On Jul 25, Charles Cantrell wrote:
I am attempting to set up an administrative user, that has the same
privileges as root. I have been able to set up a user that appears to have
all privileges, with the exception of GRANT privileges to other users. This
user can create new database
That does exactly what I needed. Thanks much for the tip, it'll save me a
weekend digging through the web trying to finish a project for work.
Alec
On Sat, 26 Jul 2003, Yves Goergen wrote:
i'd try something like
select t.name, d.domain
from domain_types t, domains d
where t.type_id =
Building MySQL-4.0.14-0.src.rpm (downloaded today) I get this:
Executing(%install): /bin/sh -e /var/tmp/rpm-tmp.97684
+ umask 022
+ cd /usr/src/redhat/BUILD
+ cd mysql-4.0.14
+ LANG=C
+ export LANG
+ -n mysql-4.0.14
/var/tmp/rpm-tmp.97684: line 25: -n: command not found
error: Bad exit status
X-Original-To: [EMAIL PROTECTED]
X-Original-To: [EMAIL PROTECTED]
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
From: Dathan Vance Pattishall [EMAIL PROTECTED]
Date: Thu, 24 Jul 2003 10:42:31 -0700
RAID-5 is cool, RAID-1+0 (10) is better for writes.
Raid5 is slow and
- Original Message -
From: Mysql List [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, July 24, 2003 11:15 AM
Subject: Re: Huge Server configuration
I have RAID 5 with 5 hardisks, so usuable number of spindle will only be 4.
Unless you've designated one drive as a spare,
I wrote:
Can I safely comment out everything after %install on
that line, or will something else break?
The %install section finished successfully that way, but then
the next problem popped up:
RPM build errors:
Installed (but unpackaged) file(s) found:
/shared-libs.tar
I've been searching the mailing list for a solution to my problem with
mysqld got signal 11; and I haven't seen any answers that might help me.
This is the situation.
I have a db that is being accessed intensively about 400 connections during
the wee at a time. I noticed the problem at first
Hi
I have a database supplied to me that was excel but now uploaded to mysql.
(the data is out of my hands.)
i need to search for 1 of 2 categories against 3 fields with user inputted
data.
example Categories=Lessor , searchtype = BusinessCity searchdata = (user
input)
$sql = SELECT * FROM
Hi.
First, you will be happy to know that I am migrating a client to
PHP/MySQL from ASP/MSSQL. This is for reasons of future preservation,
cost, security, efficiency, et cetera. The problem is, I don't
currently have a PC and $$ to run Windows 2000 server on. I have been
sent the MDF and
At 05:43 PM 7/26/2003 -0500, kumar mcmillan wrote:
Hi.
First, you will be happy to know that I am migrating a client to PHP/MySQL
from ASP/MSSQL. This is for reasons of future preservation, cost,
security, efficiency, et cetera. The problem is, I don't currently have a
PC and $$ to run
Hi list,
I got me a copy of mysqlcc 0.9.2-beta and installed it on my win 2000 box.
No complaints so far.
There is an icon on the desktop.
I click it and for a really short moment there is a sandclock and then
nothing happens. Mysqlcc just dosn't bother to appear.
I went to the
http://hotwired.lycos.com/webmonkey/99/21/index2a_page6.html?tw=programming
An example of PHP reading MySQL DB
Hth,
Martin
- Original Message -
From: kumar mcmillan [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, July 26, 2003 3:43 PM
Subject: how to convert SQL Server 2000
Hi Mark,
2003 7 27 06:09Obantec Support :
Hi
I have a database supplied to me that was excel but now uploaded to mysql.
(the data is out of my hands.)
i need to search for 1 of 2 categories against 3 fields with user inputted
data.
example Categories=Lessor , searchtype = BusinessCity
Hi,
I'm new to mySql. I've got a table with an integer field defined like
this:
l_start_wait int(9) not null
I inserted a value into the table using mysql command line client with:
Insert into tbl_wait_list values(12345678);
When I use mysql_fetch_row() to retrieve the column values I am
Hello,
I'm using InnoDB table types to enforce referential integrity. Is there any way to use
free text search with it ?
Thanks
Shahid M. Syed
Karachi, Pakistan
http://members.tripod.com/shahid_syed
At 6:53 +0500 7/27/03, Shahid M. Syed wrote:
Hello,
I'm using InnoDB table types to enforce referential integrity. Is
there any way to use free text search with it ?
If you mean full-text searching with FULLTEXT indexes, no.
Thanks
Shahid M. Syed
Karachi, Pakistan
Hello :)
I have an development/test server on a windows 2000 box running.
AFAIK mysql needs 127.0.0.1 to connect to the localhost, if I use it on
the db-server's machine.
Usually I'd connect via LAN so I need mysqld listen on 2 IPs.
1) 127.0.0.1
2) 192.168.1.42-- LAN-IP
This box has a
At 08:53 PM 7/26/2003, you wrote:
Hello,
I'm using InnoDB table types to enforce referential integrity. Is there
any way to use free text search with it ?
Thanks
Shahid M. Syed
Karachi, Pakistan
http://members.tripod.com/shahid_syed
Shahid,
Last I heard Heikki Turri would create full
Hi Andreas,
Good question. I saw this topic discussed many times in books. Please allow me
to add my $0.02.
First for the localhost entry. You will define a grant command like
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD
'mypassword' WITH GRANT OPTION
Then for the
I have a MySQL query running inside a CGI script on my site that, at random
intervals, seems to take 10-20 seconds to complete instead of less than 1
second. I spent so much time trying to track this down that I wrote a
script which runs once a minute on the site, which (a) captures the output
Greetings
What you need is a tool called SQLyog ( it has the
best ODBC import utility in the market ). A very good
tutorial can be found at http://www.devshed.com in the
MySQL section.
Do tell me how was your experience?
Karam ( A satisfied user of SQLyog )
--- kumar mcmillan [EMAIL PROTECTED]
Hello Nils,
thanks for your answer. :)
First for the localhost entry. You will define a grant command like [...]
Then for the remote connection you use [...]
Right, that is somewhere in the online docu in the area of adding a user
I prefer just to have the needed ports open rather than to
This could be caused by table locking. If another Mysql process ha a lock on
the table then other processes start to queue up. Maybe this query is
getting stuck behind other queries or a single slow query.
Just a thought.
-Jackson
On Saturday 26 July 2003 11:00, Bennett Haselton wrote:
I
Boris Villazon wrote:
Step 1
The secondary pc copies only the new incoming data from primary pc database.
Step 2
When the secondary pc copies the data, the primary pc has to delete all these copied records (in the local database).
Could I use replication technique to achieve this process? If
Jackson,
Thanks for your help. Two follow-ups:
a) Is there a command to show all the table locks, or locks on a particular
table? I searched http://www.mysql.com/doc/en/index.html for locking and
locks, but I couldn't find anything.
b) I'm reading
I am trying to get MySQL to start up at boot. I have
my script on rc3 and link in init.d, but something is
going wrong.
I tried the script manually and I can only run it when
I am root. When I am another user, calling up
mysqld_safe fails because it is looking for some
directory /usr/bin/libexec
Greetings
I have a table with the following table structure -
FieldType Collation NullKey
Default Extra
--- - - --
-- --- --
emailchar(75) latin1_swedish_ci
is_sent
28 matches
Mail list logo