Like crashing, auto-rebooting, memory leaking, program cost, etc...
:)
Brian Duke
Level(3) Communication
==-=-=-=-=--==--==¬
-Original Message-
From: Pat Adams [mailto:[EMAIL PROTECTED]
Sent: Friday, August 12, 2005 9:21 AM
To: mysql@lists.mysql.com
Subject: RE: Linux vs
Hi
I have a problem with a query that has many joined tables. The query brings
back 80 records instead of just one. Any suggestions on how I can overcome
this?
Many thanks
Richard
Query below:-
SELECT *
FROM (main_data INNER JOIN main_data_facilities ON
main_data_facilities.RecNo =
I'm new so this may be whacked but here goes:
Isn't the grant statement tailed with the grant option?
i.e.
GRANT ALL ON table_or_database_name to 'somebody'@'localhost' WITH GRANT
OPTION;
Somebody verify that please.
-Original Message-
From: John R. Porter [mailto:[EMAIL PROTECTED]
I know that feeling. perhaps I can help.
do you have an /etc/rc.d/init.d/mysqld file?
-Original Message-
From: Kirti S. Bajwa [mailto:[EMAIL PROTECTED]
Sent: Sunday, May 09, 2004 3:29 PM
To: '[EMAIL PROTECTED]'
Subject: RE: MySQL does not automatically start at BOOT time??
Hello
PROTECTED] wrote:
Brian:
No. From where I copy this file from? Is it stright
copy or something else?
You might be my savior!!
Thanks.
Kirti
-Original Message-
From: Brian Duke [mailto:[EMAIL PROTECTED]
Sent: Sunday, May 09, 2004 5:44 PM
To: 'Kirti S. Bajwa'; [EMAIL
a 2.4.20-30.9 kernel
to be fair we installed the mysql-client after we got the first error
message. Before that we had no mysql-client and addes users via
mysqladmin. I don't think I can upgrade the php-mysql any higher yet.
Can someone let us know what we need to upgrade?
Brian Duke
I needed to do some subqueries. I had mysql-3.23. Somehow I thought
mysql4 included subqueries. Loaded mysql-4.0. Converted everything and
got it working except it doesn't do subqueries. Therefore we installed
mysql-4.1.1 6 hours of figuring out the permissions finally we got the
databases all
There has got to be a better way for me to query/subquery this data.
I have 4 tables.
Table1
-
Company_Name | Company_ID
-
Blue Shoe| 101
Fast Cow | 102
Table2
Hmmm, I dunno.
Perhaps the term: mysql -h 'server' -u root
Should be changed to: mysql -h your_hostname -u root
As your_hostname is the actual FQDN of your server.
Brian Duke
SS-TCAM//87797
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Saturday, February
Can someone explain a 1:n non identifying relation?
Brian Duke
I need a little help in constructing an order tracking database. We've
decided to use MySQL mostly because it's the best supported database out in
the wild. Does anyone have an example of an order tracking datamap? A link
to a site with the basic flowchart would be a great help. The application is
I need a little help in constructing an order tracking database. We've
decided to use MySQL mostly because it's the best supported database out in
the wild. Does anyone have an example of an order tracking datamap? A link
to a site with the basic flowchart would be a great help. The application is
try this:
grant ALL on abc.* to 'abc'@'localhost' identified by 'abc';
I have created database 'abc' .
mysql grant ALL on abc.table to 'abc' identified by 'abc';
Query OK, 0 rows affected (0.00 sec)
-Original Message-
From: ads mysql [mailto:[EMAIL PROTECTED]
Sent: Monday, December
On the windows machine I have Acess2003. I installed the MyODBC to push the
data into the FreeBSD MySQL server. The connection worked like a dream.
Kudos to the MyODBC team.
The table that the connection created included field names that have spaces
in the name. I'm trying to access the data
I can just alter table to rename the fields right?
-Original Message-
From: Patrick Sherrill [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 11, 2003 5:27 AM
To: Brian Duke; [EMAIL PROTECTED]
Subject: Re: Field Name whitespace via MyODBC
Brian,
I think you are going to need
.tcshrc is the config file for your settings on the environment variables
for your session of tcsh. When your looking for $SHELL your looking for the
command line interpretor. FreeBSD can use most any of them. bash, csh, ksh,,
sh, tcsh, etc. Usually the .rc file is found in your home directory
Have you flushed priv's recently?
-Original Message-
From: Schrodinger [mailto:[EMAIL PROTECTED]
Sent: Monday, December 08, 2003 1:02 PM
To: MySQL General Lists
Subject: Login Problems
Hello, I am experiencing a strange problem with a MySQL server on a
FreeBSD machine here in college.
I have a question about spaces in fieldnames.
locally running Access03 and using MyODBC3.51 to populate a MySQL40 database.
The Database name and table names are ok.
It's the field names I am having trouble with. The tables are huge and there are 26
tables.
The ODBC process completes but due to
?
-Original Message-
From: Daniel Kasak [mailto:[EMAIL PROTECTED]
Sent: Saturday, December 06, 2003 2:46 PM
To: Duke, Brian; [EMAIL PROTECTED]
Subject: Re: MySql40, MSAccess2003, MyODBC3.51, and white spaces.
can someone help me either fix my ODBC load or help me correctly syntax my php
Don't have a fix but look at the swap file size. May need to increase that.
A further note MS Access on NT run 100%,...100% of the time.
-Original Message-
From: John R. Diehl, Jr. [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 27, 2002 1:05 PM
To: Peter Zuidema; [EMAIL PROTECTED]
Redhat...Linux systems:
running Xwindows login at runlevel5
cd /etc/rc.d/init.d/rc5.d/
search for mysqld
mv ./K74mysqld ./S78mysqld
The K denotes Kill
The S denotes Start
If you run you system at a different run level like 3 then go to /rc5.d/
directory and change the file name there. The
Oops correction:
If you run you system at a different run level like 3 then go to /rc3.d/
directory and change the file name there.
-Original Message-
From: Duke, Brian
Sent: Friday, September 27, 2002 3:45 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Mysql and RedHat 7.3
whew, I found it. I looked at my installed rpm's ('rpm -q php')
found the install php 4.1.2-7.3.4. Tried to remove ('php -e php*.rpm')
got multiple dependent errors. That when I noticed I had about 6 rpm's
had installed 6 different flavors of php. I uninstalled all and reinstalled
just
stat-box201
-*message began on php mailing list...no answer. Forwarding to mysql list
13:55-9-24
I'm running apache-1.3.23-14 on a redhat 7.3 system.
I have installed the php-rpm and the php_mysql.rpm from Redhat.
installed php-4.1.2-7.3.4 and php-mysql-4.1.2-7.3.4.
Cannot connect to my
Is your win2k server networked? does it have multiple users? I would first
check the various profiles to ensure it was not moved to a different
profile. Next I would ask did the administrator install the server? if
another username installed the server even with admin rights that server is
now
and
populate data. when I try to log in as that user, mysql -u webley -p
icesql I get the prompt for a password but after entering I get access
denied. The icesql is in the db table and webley does have rights in the
db table for that database. Can someone tell me if I am missing the big
flick?
Brian Duke
NIGERIAN NATIONAL PETROLEUM CORPORATION
(DEPARTMENT OF PETROLEUM RESOURCES)
ENGR PUAL DUKE
ATTN: THE PRESIDENT,
REQUEST FOR URGENT BUSINESS RELATIONSHIP ALTHOUGH THIS PROPOSAL MIGHT
COME TO YOU AS A SURPRISE SINCE IT IS COMING FROM SOMEONE YOU DO NOT
KNOW OR EVER SEEN BEFORE, BUT AFTER
what are the basic differences in the CREATE TABLE command for the following
keywords?
I checked the MySQL manual but couldnt make much sense outa it.
KEY
INDEX
PRIMARY KEY
UNIQUE
plz. could anyone ellaborate more on UNIQUE AND PRIMARY KEY.? it seems that
both are doing the same job?...
duke
I would like to know how to write a SQL statement if i have a composite key
present in the table. eg. my table is
APPCODE EMAILID EMAIL
1 ML1 [EMAIL PROTECTED]
1 ML2 [EMAIL PROTECTED]
2 ML1 [EMAIL PROTECTED]
3 ML1 [EMAIL PROTECTED]
4 ML1 [EMAIL
In the CREATE TABLE command there is a create_defn. option called ...
CONSTRAINT symbol
what is that for?
and how does that work?
duke.
Website: http://www.ilug-bom.org.in/
Ftp site: ftp.ilug-bom.org.in
Chat: irc.ilug-bom.org.in
Linuxers mailing list: [EMAIL PROTECTED]
http://ilug-bom.org.in
be...
CONSTRAINT fk_authorsofdoc FOREIGN KEY(docid, authorid)
isnt it??? or am i wrong?
duke.
"Cal Evans" [EMAIL PROTECTED] wrote:
It's not implemented in MySQL. It's there for compatibility.
In other flavors of SQL, constraints can be placed on relationships to
enforce referential
31 matches
Mail list logo