Hello Everyone,
Is there a reason why the Dynamic client libraries including 3.23.x
libraries (MySQL-shared-compat-4.0.20-0.i386.rpm) are only distributed as
RPM to the i386 architecture?
Updating to 4.0.20 on x86_64 is quite difficult at the moment if you want
to keep PHP working. Are there a
Background:
I have one master table A, and other supplementary tables B,C and D such that
for every row of A there can be one or more corresponding rows in B,C,D.
There is another supplementary table E with which A has a one-to-one
relationship.
Problem:
Given three search criteria resulting
I use SQLyog. It does allow you to create/delete FKs
with "ON UPDATE" criterias.
Yeah, it does not allow you to create Fks in graphical
manner like MS SQL Server but does my purpose. One
feature I really miss is Editing of FKs.
Karam
--- Jose_Miguel_Pérez <[EMAIL PROTECTED]> wrote:
> Hi All!
>
Hi,
I am trying to compile MySQL. I know that it is possible to install this
as a binary, that is not my goal.
My environment consists of the following: If there are other tools that
I need to specify please let me know.
gcc-3.2-7
libgcc-3.2-7
gcc-c++-3.2-7
I run configure as specified at the M
What's advantage of table's join?
I can't find out it.
Please guide me.
=
-DIGITAL SIGNATURE---
///Mohsen Pahlevanzadeh
Network administrator & programmer
My home phone is: +98213810146
My email address is
Robb:
http://dev.mysql.com/doc/mysql/en/JOIN.html
I am assuming all the information you need is student name + city
name. SELECT * FROM StudentTable AS s, CityTable AS c WHERE s.CityID =
c.CityID
Wes
On Wed, 8 Sep 2004 19:55:29 -0500, Robb Kerr
<[EMAIL PROTECTED]> wrote:
> Trying to get my mind
Trying to get my mind around JOINs. Please help.
Scenario...
StudentTable
Fields:
StudentID
StudentName
CityID
CityTable
Fields:
CityID
CityName
I will store personal information about the student in the first table. The
second table contains information about the city. I relate th
> Now, to complicate things further, suppose there is
> yet another table (grandparent, let's say) and there is
> a column in parent that is grandparent_id. I only want
> results where parent.grandparent_id = 'Fred'. How do
> I do that? Is it with a WHERE clause or some other
> SQL magic?
>
> Dean
Dean A. Hoover wrote:
Now, to complicate things further, suppose there is
yet another table (grandparent, let's say) and there is
a column in parent that is grandparent_id. I only want
results where parent.grandparent_id = 'Fred'. How do
I do that? Is it with a WHERE clause or some other
SQL magic?
Now, to complicate things further, suppose there is
yet another table (grandparent, let's say) and there is
a column in parent that is grandparent_id. I only want
results where parent.grandparent_id = 'Fred'. How do
I do that? Is it with a WHERE clause or some other
SQL magic?
Dean
Daniel Kasak wro
Hi all,
I have a Linux Database Server which runs MySQL 4.1 and a Windows Client machine which
runs MySQL 4.1 too. I have installed the latest version of MyODBC on both machines and
they have been installed successfully. Now, at the Administrative Tools in the Control
Panel on my Windows system
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; "leegold"
<[EMAIL PROTECTED]>
Sent: Wednesday, September 08, 2004 7:29 PM
Subject: Re: Rename a columkn
> At 18:02 -0400 9/8/04, Rhino wrote:
> >- Original Message
At 18:02 -0400 9/8/04, Rhino wrote:
- Original Message -
From: "leegold" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 08, 2004 5:31 PM
Subject: Rename a columkn
I sent a previous email w/the wrong subj. - sorry.
The example below renames a col. But can I rename
Jim Grill wrote:
Suppose I have two tables: parent and
child. I want to create an SQL statement
that will get the count of all children
belonging to parent. Is this possible in
one statement? The one I have works
if parent has children, but not if the
number of children is 0. Here's what
I have:
SE
- Original Message -
From: "Pahlevanzadeh Mohsen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 08, 2004 6:59 PM
Subject: varchar or
> Dears,I'm going to create a field what it not limited
> to a specefy size.
> Please guide me
>
Have you tried sear
> Suppose I have two tables: parent and
> child. I want to create an SQL statement
> that will get the count of all children
> belonging to parent. Is this possible in
> one statement? The one I have works
> if parent has children, but not if the
> number of children is 0. Here's what
> I have:
>
>
Dean A. Hoover wrote:
Suppose I have two tables: parent and
child. I want to create an SQL statement
that will get the count of all children
belonging to parent. Is this possible in
one statement? The one I have works
if parent has children, but not if the
number of children is 0. Here's what
I hav
Dears,I'm going to create a field what it not limited
to a specefy size.
Please guide me
=
-DIGITAL SIGNATURE---
///Mohsen Pahlevanzadeh
Network administrator & programmer
My home phone is: +98213810146
My email address is
Suppose I have two tables: parent and
child. I want to create an SQL statement
that will get the count of all children
belonging to parent. Is this possible in
one statement? The one I have works
if parent has children, but not if the
number of children is 0. Here's what
I have:
SELECT parent.id,pa
Hello:
I am trying to install Perl support with MySQL. After installing MySQL
(v4.0.20)I run the following commands:
% echo $PATH
% perl -MCPAN -e shell
Note: Answer no to auto-configure perl.
cpan> install Data::Dumper
(Upto this point. Following commands are n
- Original Message -
From: "leegold" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 08, 2004 5:31 PM
Subject: Rename a columkn
> I sent a previous email w/the wrong subj. - sorry.
>
> The example below renames a col. But can I rename a col. w/out giving
> all tha
I sent a previous email w/the wrong subj. - sorry.
The example below renames a col. But can I rename a col. w/out giving
all that type spec. at the end of the statement below. I just want to
rename, everything else stays the same. Thanks.
mysql> ALTER TABLE search CHANGE Description PageDescripti
The example below renames a col. But can I rename a col. w/out giving
all that type spec. at the end of the statement below. I just want to
rename everything else stays the same. Thanks.
mysql> ALTER TABLE search CHANGE Description PageDescription
VARCHAR(255) NOT NULL;
--
MySQL General Mailing
Hello All,
MySQL : Standar Binary 4.0.20
O/S : Red Hat Linux release 9 (Shrike)
Linux 2.4.20-31.9smp #1 SMP Tue Apr 13 17:40:10 EDT 2004 i686 i686 i386 GNU/Linux
I already have setup of Three Multiple MySQL servers listening on different ports and
sockets on same machine
Option File:
[mysqld
Christian:
Change your readme and hostname columns to BLOB and use the
LOAD_FILE() function to add your record.
INSERT INTO test NULL, LOAD_FILE( '/path/to/readme/file' ), LOAD_FILE(
'/path/to/hostname/file');
More on the LOAD_FILE() function:
http://dev.mysql.com/doc/mysql/en/String_functions.ht
C api mysql 4.1.4 ,select many select error!
free_root fail.
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priorit
> Bingo. Yeah, that works very well.
> Really appreciated.
>
> BTW, still curious about the reason of duplicate.:)
> Any thoughts?
>
> Monet
>
Several thoughts; one of which is "Thank my lucky stars! I have my data
back!" :-)
Other, less significant thoughts include the possibility that some eso
Monet wrote:
Hello there,
I tried “REPAIR TABLE” to recovery the crushed temp
table and that works. Thanks a lot.
But, after reparation, there are some duplicated
records generated. Is that because the temp table has
no primary key? Or is because the table was crushed in
the middle of query?
Anyw
Bingo. Yeah, that works very well.
Really appreciated.
BTW, still curious about the reason of duplicate.:)
Any thoughts?
Monet
--- Jim Grill <[EMAIL PROTECTED]> wrote:
> > Hello there,
> >
> > I tried "REPAIR TABLE" to recovery the crushed
> temp
> > table and that works. Thanks a lot.
> >
>
> Hello there,
>
> I tried "REPAIR TABLE" to recovery the crushed temp
> table and that works. Thanks a lot.
>
> But, after reparation, there are some duplicated
> records generated. Is that because the temp table has
> no primary key? Or is because the table was crushed in
> the middle of query?
Hello there,
I tried REPAIR TABLE to recovery the crushed temp
table and that works. Thanks a lot.
But, after reparation, there are some duplicated
records generated. Is that because the temp table has
no primary key? Or is because the table was crushed in
the middle of query?
Anyway, I tried
I agree with Peter. Hit the database only when necessary. You can even
eliminate some JOINS entirely if you cache the contents of **certain**
tables in application-side arrays However(!!) _*you*_ are now responsible
for searching those arrays efficiently. Here's an example:
create table states
Currently we have one way master to slave replication setup.
The master has 2 innodb data files, the second has now grown
to 50gb+. The slave's innodb data files are less than 2 gigs.
How is this possible? They are both storing the exact same
data. Is there some way to trim the 50gb+ file down ?
Hi Guys,
I'm having the same problem with SQL_CALC_FOUND_ROWS
Any query involving SQL_CALC_FOUND_ROWS takes ages!! All my tables are normalized,
indexed, and optimized and the query uses the indices correctly. Many people
responded to my previous thread (when I though it was a fulltext issue onl
I use foxpro to do similar loops
I've found that I get 10 queries per second on large tables, when
connecting once, and issuing individual select statements via odbc.
It is much faster if you can narrow the recordset into an array within
php, and spool through that, unfortunatly I deal with 250+
I never thought of the return only the query"ing"
part.
My predicament is I have a search form that queries a
table with about 7 joins. It returns it via a
Dreamweaver recordset aka SQL query. So based on what
you said below , regarding the number of users, this
is a bad way to go.
Stuart
-
The end result will be the same, it's just a matter of the structure
the data will have when handed to PHP for processing to display. It can
be retrieved bit by bit and broken up into multiple lists or joined and
summarized by MySQL into one list. One list will make the PHP loop
simpler, smalle
Hi,
I'm using MySql 4.1.4 Gamma and the following query returns
values containing N and Ñ instead of only those containing Ñ.
The query is as follows
Select Lastname from table1 where locate("Ñ",Lastname)>0
The result set includes values like this
HERNANDEZ
NUÑES
At 13:19 2004-09-08, you wrote:
I am going to amalgamate both Your messages.
Hi Tomasz
There are two MySQL servers - the one at the shared host and the new
one that I just set-up on the dedicated. We need to move the MySQL
database from the shared host to our dedicated. I am able to connect to th
Hi
Just my two pence worth. Its not tested or scientific, and is based on gut
feeling and experience.
Connecting to mysql is resource intensive, particularly if you make a fresh
connection for each query. A query will almost certainly involve disk acces
which is slow. Sending the result of the qu
I'm confused about this response and am facing a
similar situation.
First, regarding the subject, what is the difference
between a PHP or whatever loop and a SQL query. All
the app code is doing is collecting the request and
handing it back to the database. The DBMS still has
to retrieve the da
I would try not to query MySQL on each iteration of the loop. While a
dozen or so queries may not make a noticeable difference, hundreds or
thousands may. It's not a scalable technique, whether you need to scale
it or not. Even if it's only 100 iterations, what if you have 10 people
accessing t
You're talking about a difference of milliseconds, tops.
Use whatever solution gives you the cleaner, easiest-to-maintain code.
Don't worry about a couple milliseconds.
http://c2.com/cgi/wiki?PrematureOptimization
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
At 9:58 -0700 9/8/04, Patrick Campbell wrote:
I'm trying to get my key_buffer_size to 64m (default is 8m). I tried
putting it into my.cnf under [mysqld] with both key_buffer=64m and
key_buffer_size=64m seperately of course, and when that didn't work tried
putting it in from of the: /usr/bin/safe_m
I have two tables, call them Parent and Child, where the records in Child have
a foreign key relation to Parent, with a Cascade on Delete. If i delete
records from Parent, the corresponding records in Child will be deleted. Is
there any way that i can get a count of the records in Child that wer
At 12:42 2004-09-08, you wrote:
Greetings
We have installed MySQL 4.0 on a dedicated Windows Server 2003. I have
the MySQL server running
and it appears all is set to go minus one problem. We need to move a
MySQL database from the old
host to this server. To do that, I want to use a GUI - pref
I'm trying to get my key_buffer_size to 64m (default is 8m). I tried
putting it into my.cnf under [mysqld] with both key_buffer=64m and
key_buffer_size=64m seperately of course, and when that didn't work tried
putting it in from of the: /usr/bin/safe_mysqld --defaults-file=/etc/my.cnf
>/dev/null
Greetings
We have installed MySQL 4.0 on a dedicated Windows Server 2003. I have the MySQL
server running
and it appears all is set to go minus one problem. We need to move a MySQL database
from the old
host to this server. To do that, I want to use a GUI - preferably DBACentral.
However; I
Here's the scenario...
First, my HTTP Server (Apache), PHP Server and MySQL Server are on the same
machine - an Apple Xserve.
Second, I've got a page with a long repeat region reflecting a recordset
queried out of a MySQL table. The region also displays information obtained
from fields in a re
Hi folks, Im dying here slowly. Can anyone tell me what an =
SqlState 08000 (connection exception) REALLY MEANS Is it as obvious =
as I think it is, Im NOT CONNECTED to MySQL, and if so, why not =
08003 (connection does not exist)...
I have a major problem, Im running Windows 2000
Hi gurus,
can you pls. help a mysql newbee?
I need to load data into the following table
mysql> describe test;
+--++--+-+-++
| Field| Type | Null | Key | Default | Extra |
+--++--+-+-+-
I guess that would depend on what you consider a "last name" or a "middle
name"
A typical "western" name has 3 parts, like your example. However there are
many names like "van der Plaats" or "de la Hoya" that are not so easy to
detect based simply on what space to split the name at.
What about
Assuming there are no parts of a name that include more than one word
(e.g., "Mary Jo" being someone's first name), an easy way would be to
use SUBSTRING_INDEX.
First Name = SUBSTRING_INDEX( namefield, ' ', 1 );
Middle Name = SUBSTRING_INDEX( SUBSTRING_INDEX( namefield, ' ', 2 ), ' ', -1 );
Last N
Mr. Fisher,
Yes, that seems to be the problem... It is adding a
space before the path.
Also, the path should be static; however, it is using
../data which is wrong since I am compiling under
/data/Software/mysql and the OpenSSL directory is
directly under /data.
I did a grep for /data/OpenSSL
Miss Brasseur,
Sorry for the Mr... You are right. Id did not know.
The reason why I think it was SSL related is
because that error only comes up when I try to
compile with SSL support.
Also, on the includes where the compiler fails,
you can see:
-I.. /data/OpenSSL/include/openssl
Which poin
Hi,
I just wondering if anyone notice or can confirm this: I tried to load
11 million records using mysqlimport using both 4.1.3b and 4.0.20.
4.1.3b took 1.5 hours, but the 4.0.20 took over 10 hours. This
includes loading the data and then build the index.
Thanks
Haitao
--
MySQL General Maili
How can I extract a middle segment of text in mySQL. For example a column contains
this string: 'William Walker Jones'. I need to split this into the first, middle, and
last names. I can easily extract the first and last names but how do I extract the
Middle name?
Hi there,
Can MySQL can be used with BEA Tuxedo, has anybody tried this combination.
Can you tell me how the performance if anybody has tried this.
Waiting for your reply
Regs
Take care
Saseendran G.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsub
Hello Jose,
> Why are all MySQL GUI clients so bad with foreign keys? Sorry to seem
> annoyed, but I have used for quite some time a few GUI clients, notably
> MySQL-Front, which I were relatively confortable with. Anyway, all GUI
> clients I used (SQLyog, MySql-Front, MySQL-CC, you name it) s
Hi All!
Why are all MySQL GUI clients so bad with foreign keys? Sorry to seem
annoyed, but I have used for quite some time a few GUI clients, notably
MySQL-Front, which I were relatively confortable with. Anyway, all GUI
clients I used (SQLyog, MySql-Front, MySQL-CC, you name it) seemed to be
Remigiusz SokoÅowski wrote:
matt ryan wrote:
Tobias Asplund wrote:
<>On Tue, 7 Sep 2004, matt ryan wrote:
I forgot, did you have multiple slaves on multiple machines? If so,
do they
have identical hardware/drivers?
Multiple slaves on same machine, one works fine
Do You tried to distribute replic
61 matches
Mail list logo
