Hi,
I really don't know whether it is a bug in mysql 4.0.12.
I've downloaded 4.0.12 and installed succesfully on my PC(WIN2k with
SPack2). I've changed the bind-address to "localhost" in my.ini and
re-started mysql.
mysql -h localhost is working fine.
mysql -h (ip of my machine) or mysql -h (host
On Thu, Mar 27, 2003 at 12:04:06PM +0800, Trevor Luo [ITSD] wrote:
> Hi all,
>
> Do you have any information on the time and CPU resources required
> during the full sync / incremental sync between the master and slave
> mysql server?
CPU required on the master is nearly zero. It's just a matter
On Wed, Mar 26, 2003 at 09:03:35PM -0800, Nitin Nanivadekar wrote:
> Dear Friends,
>
> The last help I got was truly worth a zillion.
Such a bargin!
> 1. How can i have commit/rollback functions using
> MyIsam database which is default database engine for
> MySql? i am using vb
You cannot. MyIS
localhost is 127.0.0.1 in most systems unless you modify your hosts file,
since 172.16.3.106 is not localhost, connecting thru that localhost will
definitely not work for it's not localhost =)
it's not a bug i believe.
another thing, if you grant a user with a host localhost, and you place a
mysq
Hi all,
I am getting a replication failure on the slave when I run a dump import
of my database on the master. Both servers are running mysql 4.0.12
production release. The error displayed on the slave error log file is
as follows:
ERROR: 1005 Can't create table './cms/category.frm' (errno: 1
Hi Folks,
I've just signed on to the list, but no amount of searching in archives
or Google has helped me. Hopefully you all can.
I upgraded my OS X installation of MySQL to 4.0 today for the express
reason of taking advantage of the new UNION syntax. It seems to be
workingfor the most par
Hi Folks,
I've just signed on to the list, but no amount of searching in archives
or Google has helped me. Hopefully you all can.
I upgraded my OS X installation of MySQL to 4.0 today for the express
reason of taking advantage of the new UNION syntax. It seems to be
workingfor the most par
Hi all,
i am just new for MySql,can any body tell be from where i have to start
learn MySql for Unix or Linux.
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have been watching the discussions on backing up databases over the past few weeks,
and would like to ask if anyone has any experience of using Open File Manager
(www.stbernard.com). It claims to be able to provide the capability of backing up open
files and active databases, and seems to have
Hi,
On Wed, Mar 26, 2003 at 02:51:22PM -0500, Serge Paquin wrote:
> Do a print $testField; first. I think what might be happing is that you have
> register globals turned off (as you should it's a security problem).
>
> Try:
>
> $sql = "INSERT INTO testTable values ('', '${_REQUEST['testField'
Usually there's a little more administrative work to limiting
usage...but it's up to you.
Regards,
~KB
-Original Message-
From: Jennifer Goodie [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 26, 2003 2:38 PM
To: Black, Kelly W [PCS]; 'Dimitar Haralanov'; [EMAIL PROTECTED]
Subject: RE:
At 22:26 Uhr -0600 25.03.2003, mos wrote:
How many people out there are willing to pay $$$ to see it done??
Please reply to this thread to see if there is a general interest
and how much it is worth to you.
IIRC, last time I looked, fulltext was not very good for i.e. the
german language. If the
Hello
It looks like 'drop table' implicitely does a 'commit', at least when
issued by the mysql commandline utility with mysql 3.23.51. This
happens even if it was a temporary heap table as typically used to
emulate subselects.
I think this should be documented. (Or better yet, not do a commit
On 26-Mar-2003 Black, Kelly W [PCS] wrote:
> Thanks again Serge and Don,
>
> Don not to sound like an idiot but what would
> you recommend on adding a unique key. I understand
> the idea, but didn't want to corrupt tables trying to
> get it right.
>
> Serge, I knew DISTINCT operated on whole l
See www.mysql.org. There you can find a complete
documentation for mysql.
You have a good decision to use mysql on linux. I
don't believe mysql on MS. MySQL on MS is not optimal
in my opinion.
Sorry if I am wrong.
--- Hridyesh Pant <[EMAIL PROTECTED]> wrote:
> Hi all,
> i am just new for MySql,ca
Hello friends
I am using mysql on Suse linux 7.1
my mysql data partition is of on reiserfs filesystem.
Can anybody tell me, How i can resitrict database
size?
Is their any possibility that i can specify the
maximum size of database.
Thanx in advance
___
Hi all,
I have a question about mysql client. How can I use it in such a way that
it just executes a script on a specified database and then exists?
Thanks,
Dan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAI
Sunil-
Seems the easiest way to restrict the size of everything except
privilege tables is to use nothing but InnoDB tables. You can set the
default table type using --default-table-type=InnoDB when launching
mysqld.
If you're not keen on that, you may want to look into using a quota on
your mys
I've searched and searched, but I can't find anything that describes the
format of a custom stopword file for fulltext indexing in MySQL. Anybody
have a pointer or a description of the format?
Nick
--
Nick Arnett
Phone/fax: (408) 904-7198
[EMAIL PROTECTED]
--
MySQL General Mailing List
For l
Mr. Zawodny is right MyISAM natively does not support Transactions, but
Transactions can be done with a set of myISAM tables and a lot of code
specific to supporting transactions w/o a race condition. Basically it's
a long a tedious process of writing code to support a "ticket server" (a
unique id
ISAM tables are cut off at 4gb of data
MYISAM / INNODB /BDB have a filesystem limit.
I suggest to limit the maximum size of data file: find out if reiserfs
can set a limit on files sizes. I know that EXT3 a few revisions ago
could not go past 2GB per file. Or prune your data so it doesn't get to
bi
Christian,
- Original Message -
From: "Christian Jaeger" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, March 27, 2003 1:42 PM
Subject: Innodb transactions and drop table
> Hello
>
> It looks like 'drop table' implicitely does a 'commit', at least when
> issued by
It's also interesting to note that it's possible to split innodb data
between multiple files to have databases larger than the OS's max file
size.
-jeff
On Thu, 2003-03-27 at 14:17, Dathan Vance Pattishall wrote:
> ISAM tables are cut off at 4gb of data
> MYISAM / INNODB /BDB have a filesystem lim
On Thu, Mar 27, 2003 at 11:30:19AM -0800, Nick Arnett wrote:
> I've searched and searched, but I can't find anything that describes the
> format of a custom stopword file for fulltext indexing in MySQL. Anybody
> have a pointer or a description of the format?
I'm pretty sure it's just one word pe
On Thu, Mar 27, 2003 at 11:58:54AM +0500, Sohail Hasan wrote:
> Hi all,
>
> I am getting a replication failure on the slave when I run a dump import
> of my database on the master. Both servers are running mysql 4.0.12
> production release. The error displayed on the slave error log file is
> a
On Thu, Mar 27, 2003 at 12:17:45PM -0800, Dathan Vance Pattishall wrote:
> ISAM tables are cut off at 4gb of data
No, they aren't. I have a 9GB MyISAM table here. By using a MAX_ROWS
specifier, you can suggest that MySQL use larger row pointers (more
than 4 bytes).
> MYISAM / INNODB /BDB have a
Howdy,
Can anyone recommend a good reference book for using PHP with MySQL?
I've read and enjoyed Paul's 'DoorStop' and 'CookBook' and have a fairly good
grasp of MySQL. I've also written a bare bones database browser for Win32 using
Apache, MySQL, and PHP, so I'm not an absolute newbie. But a b
I have noticed on many occasions some extensive traffic on my internal
network that I cannot explain. Below you will see two sets of tcpdump
traces. I have a mysql server running on my internal host named
"herzegbol" and a windows 98 host named shelbyville
This trace is when the MySQL server i
Hello everyone,
I was wondering how could I make a mirror copy of a table to another server
in the easiest way? I browsed through the MySQL documentation but didn't
find any clue of a "COPY TABLE" command or a similar method. I know that I
can make a dump from a table and then run that dump file i
I've been having trouble with some large tables getting what seems to be
corrupted.
Here's the situation:
I have several tables that have 3 million to as much as 7 million records. I
have a process that I run against those tables that pulls out a record based
on specific criteria (select id,name f
Try reading your return codes.
You got a duplicate key error that you were ignoring.
C. Reeve wrote:
I got it - stupid me has a unique field that I wasn't using in the test
script I was using - so every I tried to add an entry this field was a
duplicate and as such did not add the record. Is there
Error 13 is a permissions denied problem.
Make sure the data directories and files are owned by mysql.
Bill Davies wrote:
I am having trouble getting MySQL 3.23.51 running on macOS X 10.1.5
(Darwin)
** First it won't let me assign a root password, I think because it's
not running.
Trying to ch
On 27-Mar-2003 C. Reeve wrote:
> I got it - stupid me has a unique field that I wasn't using in the test
> script I was using - so every I tried to add an entry this field was a
> duplicate and as such did not add the record. Is there a way to put
> something in so mysql would tell me this - 2 ho
We recently installed php and Mandrake 9. Php is no recognizing any of
the mysql statements. On a working php installation the two extensions
mysql.so and gd.so are in the /usr/lib/php/extensions directory. How does
php create this directory for mysql. By unchecking the two extensions in
On Thu, 27 Mar 2003 01:47:59 -0500
C. Reeve wrote:
> Nothing happens.
>
> mysql_query ("INSERT INTO userdata (email, passwd, firstname)
VALUES
> ('$entered_email','$entered_passwd','$name')");
mysql_query return a value. What is that value? Is the user that you
are conne
Read about replication in the manual.
This may be what you need.
Ville Mattila wrote:
Hello everyone,
I was wondering how could I make a mirror copy of a table to another server
in the easiest way? I browsed through the MySQL documentation but didn't
find any clue of a "COPY TABLE" command or a s
Hi friends,
I am using MySQL 4.0 (with Embedded Server) on a Mac OS X
(Darwin) machine. I am using the C API of MySQL in my programs. I have a
few questions regarding this.
1) When I compile my programs with the g++ 3.1 compiler, i get the
following warnings:
ld: warning multiple defini
http://www.mysql.com/downloads/mysql-4.1.html
"Binaries will be available soon."
"Soon" has in this context shown to be very relative... :-)
What milestones have yet to be reached before binaries for MySQL 4.1
are being made available?
Michael
Helloworld Media
Box 13085, 103 02 Stockholm, Swede
I've tried it both as fixed (char) and variable (varchar). Interestingly
when I set is as char when building the table, MySQL changes it to varchar
sometimes (but not always).
Here's a structure dump:
CREATE TABLE soldierMain (
id int(20) NOT NULL auto_increment,
timeadded varchar(14) NOT NULL
Hi all together!
Meanwhile I found out that what I am looking for is best known as
"negative testing", trying to break an application puckish, to make it
fail more or less serious by going bejond the borders. I am really
really in a hurry (and stuck at the moment) getting information on this
topic
Hi all together!
Meanwhile I found out that what I am looking for is best known as
"negative testing", trying to break an application puckish, to make it
fail more or less serious by going bejond the borders. I am really
really in a hurry (and stuck at the moment) getting information on this
t
On Thu, Mar 27, 2003 at 02:28:37PM -0500, Gary Huntress wrote:
> I have noticed on many occasions some extensive traffic on my internal
> network that I cannot explain. Below you will see two sets of tcpdump
> traces. I have a mysql server running on my internal host named
> "herzegbol" and a w
Hi!
> "Ralf" == Ralf Hupfer <[EMAIL PROTECTED]> writes:
Ralf> Hi,
Ralf> I do face problems building MySQL 3.22.32 with gcc 3.2.2 on an Alpha-
Ralf> DEC-OSF4 workstation.
MySQL 3.22 ?
Ralf> CC="cc -pthread" CXX="cxx -pthread -O" ./configure --with-named-t
Ralf> hread-libs="-lpthread -lmach
Hi!
> "Wynne" == Wynne Crisman <[EMAIL PROTECTED]> writes:
Wynne> I am trying to determine what would cause my needing to rebuild an
Wynne> MyISAM table in MySQL 4.0.x?
You should not have to rebuild any tables just to upgrade to MySQL 4.0
from 3.23. The MyISAM format has not changed in an
Would you care to elaborate on that - Using PHP there is no error or return
code - it just goes along happily saying the record was inserted. If there
is a way to do this, please explain.
TIA
- Original Message -
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "C. Reeve" <[EMAIL PROTECTED]>
ISAM tables have a 4GB limit myISAM tables do not have a filesize limit.
There is a big difference between ISAM and myISAM.
Yes you can have multiple InnoDB tablespace files across many
filesystems this is true. For ISAM OR myISAM tables the filesystem does
come into play so it's not an irrelevant
Hey...
what is my_getopt.h really?
when compiling mysqlcc i get loud errors (probably) originating from that
include, wich i don't have on my system...
Any ideas?
--
-BEGIN GEEK CODE BLOCK-
Version: 3.1 (2002 update)
GCM/GCS/GMU/ d+ s++:++ a-- C++() UBLAIS+() P+ L+(-) E--- W+++
> I've tried it both as fixed (char) and variable (varchar). Interestingly
> when I set is as char when building the table, MySQL changes it to
> varchar sometimes (but not always).
>
> Here's a structure dump:
> CREATE TABLE soldierMain (
> id int(20) NOT NULL auto_increment,
> timeadded varch
Somebody got control of mysql, or your rooted?
-Original Message-
From: Gary Huntress [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 27, 2003 1:29 PM
To: [EMAIL PROTECTED]
Subject: Confused about network traffic on mysql port
I have noticed on many occasions some extensive traffic on my
On Thu, Mar 27, 2003 at 12:54:49PM -0800, Dathan Vance Pattishall wrote:
> ISAM tables have a 4GB limit myISAM tables do not have a filesize limit.
> There is a big difference between ISAM and myISAM.
Ah, okay. I read ISAM as MyISAM. Sorry. :-(
Who's still using ISAM anyway? :-)
Jeremy
--
Jer
On Thu, Mar 27, 2003 at 10:41:32PM +0100, Michael Edlund wrote:
> http://www.mysql.com/downloads/mysql-4.1.html
> "Binaries will be available soon."
Yeah. I've got unsupported binaries on-line.
http://jeremy.zawodny.com/blog/archives/000605.html
Don't know if that helps you or not.
Jeremy
--
I've considered that. But there are no indications that is the case, I
sniff traffic to that box from my firewall (that could be compromised too of
course) and I see nothing suspicious. The only traffic on that box is on
the mysql port.
Since I see this traffic on the mysql port when the server
http://www.mysql.com/doc/en/String_functions.html
Your MySQL connection id is 14 to server version: 3.23.56-Max
mysql> SELECT HEX("abc");
++
| HEX("abc") |
++
| 0 | << this should return 616263 according to the docs.
++
mysql> SELECT HEX(255
Hej Michael-
In order to to see 4.1 mysqladmin working
I started to compiling the 4.1 source obtained from bitmaker
Originally I had 1000 errors with 1000 unresolved link errors..
I am down to about 50 on both counts
God Tur-
Martin
- Original Message -
From: "Michael Edlund" <[EMAIL P
At 16:21 +0100 3/27/03, lasse wrote:
Hey...
what is my_getopt.h really?
when compiling mysqlcc i get loud errors (probably) originating from that
include, wich i don't have on my system...
A system about which you supply no details, ahem. :-)
If you're on Linux, install the -devel RPM.
Otherwise,
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Gary Huntress" <[EMAIL PROTECTED]>
Sent: Thursday, March 27, 2003 4:33 PM
Subject: Re: Confused about network traffic on mysql port
> >I have noticed on many occasions some extensive traffic on my internal
> >network that
Has anyone used saga to connect to MySQL database? If so what tools did
they use?
Michael Johnson
Managing Director
Humphrey Consulting Limited BPEnet
Tel/Fax: 0870 922 0247
email: [EMAIL PROTECTED]
websites: www.humphreyconsulting.co.uk & www.bpenet.net
Dan, you can use:
mysql -e "YOUR SQL STATEMENT"
[]s
Anderson Pereira Ataides
Em Qui 27 Mar 2003 08:03, Daniel Kiss escreveu:
> Hi all,
>
> I have a question about mysql client. How can I use it in such a way that
> it just executes a script on a specified database and then exists?
>
> Thanks,
>
Hi,
On Thu, Mar 27, 2003 at 02:28:37PM -0500, Gary Huntress wrote:
> I have noticed on many occasions some extensive traffic on my internal
> network that I cannot explain. Below you will see two sets of tcpdump
> traces. I have a mysql server running on my internal host named
> "herzegbol" an
You could make the column a unique key...that would prevent duplicates from
being entered. Then if you want to be able to try inserting duplicates (like
if you don't want the query to fail on duplicate attempts), you could do
INSERT IGNORE INTO myTable ...
Check http://www.mysql.com/doc/en/CREATE_
Dear Alexander,
I am running mysql 4.0.12 on both the master and slave servers. I am
facing the same problem with a slight variation. When I am trying to
import my database dump on the master the replication fails and slave
thread exits with the following error in the hostname.err file on the s
Hi,
On Thu, Mar 27, 2003 at 05:35:22PM -0500, Gary Huntress wrote:
> > >I have noticed on many occasions some extensive traffic on my internal
> > >network that I cannot explain. Below you will see two sets of tcpdump
> > >traces. I have a mysql server running on my internal host named
> > >"h
What does the table DDL look like. Is the table a fixed or dynamic format?
-Original Message-
From: Dan Wright [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 27, 2003 11:08 AM
To: [EMAIL PROTECTED]
Subject: Slow Inserts
I've been having trouble with some large tables getting what seems
Also you can do
mysql -u userid -p -h hostname dbname < /path/to/your/script.sql
Regards,
Kelly Black
Linux was very clearly the answer, but what was the question again?
-Original Message-
From: Anderson Pereira Ataides [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 27, 2003 5:37 AM
At 16:45 -0800 3/26/03, Daevid Vincent wrote:
http://www.mysql.com/doc/en/String_functions.html
Your MySQL connection id is 14 to server version: 3.23.56-Max
mysql> SELECT HEX("abc");
++
| HEX("abc") |
++
| 0 | << this should return 616263 according to th
Paul,
???
I see Linux x86 RPM downloads under
http://www.mysql.com/downloads/mysql-4.0.html
Regards,
Thomas
On Wed, 26 Mar 2003, Paul wrote:
> This may indicate incredible ignorance but all I can find there are
> tar.gz files which untar into the complete distribution but no rpm's are
> prese
On Wed, Mar 26, 2003 at 04:45:01PM -0800, Daevid Vincent wrote:
> http://www.mysql.com/doc/en/String_functions.html
>
> Your MySQL connection id is 14 to server version: 3.23.56-Max
>
> mysql> SELECT HEX("abc");
>
> ++
> | HEX("abc") |
> ++
> | 0 | << thi
I have two tables.
tbl_reports and tbl_personnel
tbl_reports has these fields:
rep_id, person1, person2, person3, person 4
tbl_personnel has these fields:
per_id, fname, lname, mname
What is the way to get each report back once, and have the fname,
mname, and lname fields available to print
>I've tried it both as fixed (char) and variable (varchar). Interestingly
>when I set is as char when building the table, MySQL changes it to varchar
>sometimes (but not always).
It will change a char to varchar if there is another column of variable size
in the table.
--
MySQL General Mailing
Has anyone got a way to implement column type 'serial' in a innodb table?
-jpg
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I am trying to clear up our msyql by revoking privileges for users who no
longer exist on a particular server.
If I delete the users in the appropriate tables in the mysql database, will
that revoke their privileges?
I found in the user table in the mysql a few 'users' with no username or
passwo
I had a very similar problem a couple weeks ago, although in that instance I
was using MySQL 3.23. But in any case, I had a perl script that was
inserting thousands of records in chunks, looking up an id based on a name
for each record. It would get progressively slower and slower the longer it
ran
Hello list i have mysql under solaris 8
my mysql version is
Ver 11.18 Distrib 3.23.55, for sun-solaris2.8
the mysql startup with follow parameters
cd /export/home/sil/usr/local/mysql;/bin/sh
/export/home/sil/usr/local/mysql/bin/safe_mysqld --user=mysql
--port=3306 --chroot=/export/home/sil
Is creating a cronjob a feasible alternative?
-Original Message-
From: Ville Mattila [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 27, 2003 1:50 PM
To: MySQL Mailing List
Subject: Mirroring a table
Hello everyone,
I was wondering how could I make a mirror copy of a table to another se
It appears to me that fulltext phrase searches cannot include wildcards.
For example, I would expect "app* serv*" to match "application server,"
"application services," etc. But it returns no results, so I'm having to
run each variation separately. Can anyone confirm that wildcards, indeed,
can't
John Griffin wrote:
Has anyone got a way to implement column type 'serial' in a innodb table?
-jpg
int unsigned not null auto_increment
--
Daniel Kasak
IT Developer
* NUS Consulting Group*
Level 18, 168 Walker Street
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 79
Usually it's best to work with normalized tables, which would make this
trivial. tbl_reports isn't normalized, since it has a simulated array
of persons in it. Could it be split into two tables:
tbl_reports, with fields:
rep_id (primary key) and other report-specific information you didn't
menti
I believe that we have both already figured out that the index was at-least
part of the problem due to the fact that the MySQL needs to make more disk
writes in that instance. I do not need fast search capability, so I didn't
feel the need for the index, so dropping it helped.
I've heard a bit fro
I'd like to know about any potential issues of choosing a char(32) as
the column type of a primary key instead of BIGINT or some other numeric
type. A little background.
I would like to generate a unique identifier to use as a primary key for
our application instead of using an AUTOINCREMENT colu
If you want to mirror a single table and your DB's don't both have full
access to each other then you can "push" one table from the server on the
private IP address to the other with a cron jobby by using (in unix) the
"mysqldump --add-drop-table -h someserver_with_good_permissions dbname
tablename
Yes it will revoke those privileges, but only after you issue a "flush
privileges".
Generally speaking, It's a good idea to get rid of those "blank" entries
anyway... Just make sure your apps aren't connecting to the DB with those
"blank uname & passwd" privs first..
Cheers,
Andrew
-Origina
On Fri, 2003-03-28 at 01:39, Bruce Feist wrote:
> Usually it's best to work with normalized tables, which would make this
> trivial. tbl_reports isn't normalized, since it has a simulated array
> of persons in it. Could it be split into two tables:
i'm interested on how to normalize a table... c
I need some feedback on the capability of PF-Merge
from anyone who might share their experience. It seems
very solid from their testimonies at their web sites
though.
Merge databasesÂ’ data (including images) directly into
Acrobat-based Forms, without programming; optionally
auto-e
Hello
I use the mysql command line tool quite often and always wondered why
there's no feature that lets me quickly see the syntax of a "FOREIGN
KEY" or "GRANT" command. Now while browsing the source I found the
new "syntax" command in 4.0.12 and got the idea of implementing this
syntax help of my
I need some feedback on the capability of PF-Merge
from anyone who might share their experience. It seems
very solid from their testimonies at their web sites
though.
Merge databasesÂ’ data (including images) directly into
Acrobat-based Forms, without programming; optionally
auto-e
>Description:
Some options of the slave configuration are ignored when using the
option report-host before them.
The options I used where: replicate-do-db and replicate-ignore-table.
A configuration file should not depend on the order of the options if
it's not obvious...
>How-To-Repe
Christian,
> It looks like 'drop table' implicitely does a 'commit', at least when
> issued by the mysql commandline utility with mysql 3.23.51. This
> happens even if it was a temporary heap table as typically used to
> emulate subselects.
> I think this should be documented. (Or better yet, n
I need some feedback on the capability of PF-Merge
from anyone who might share their experience. It seems
very solid from their testimonies at their web sites
though.
Merge databasesÂ’ data (including images) directly into
Acrobat-based Forms, without programming; optionally
auto-e
Hi,
When querying a largish (370,000 rows) table, a unique compound index
on its three int columns performs slower (as slow as no index at all)
than when I use the same index created without the "unique" keyword.
I've repeated it dozens of times: Create the index unique, and it's
slow, create it
At 13:22 +0100 3/27/03, Stefan Hinz wrote:
Christian,
It looks like 'drop table' implicitely does a 'commit', at least when
issued by the mysql commandline utility with mysql 3.23.51. This
happens even if it was a temporary heap table as typically used to
emulate subselects.
I think this sho
-Would joins of tables with character based primary keys be slower than
-those with numeric based keys?
Yes a join on a character based key is generally slower then on an
integer key. Key lookups in general are faster on integer based keys.
Since your PRIMARY KEY storage requirement is 30 bytes
alx wrote:
On Fri, 2003-03-28 at 01:39, Bruce Feist wrote:
Usually it's best to work with normalized tables, which would make this
trivial. tbl_reports isn't normalized, since it has a simulated array
of persons in it. Could it be split into two tables:
i'm interested on how to normaliz
I use redhat8.0 and default install RPM Mysql,but I don't install php and
apache default.
After the linux setup,I compiler the php4.3.1 and apache1.3.27 tar.gz,but
the phpinfo() MYSQL_LIBS and MYSQL_LIBS "no value"!!! why? how do I fix
this problem???
thankx~~~
--
MySQL General Mailing Lis
hi guys is this possible ? order field1 and order by field 2 ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 13:34 +1100 3/28/03, Daniel Rossi wrote:
hi guys is this possible ? order field1 and order by field 2 ?
Perhaps, depending on what you mean. Did you try
... ORDER BY field1, field2
--
Paul DuBois
http://www.kitebird.com/
sql, query
--
MySQL General Mailing List
For list archives: http://lists
Would MyODBC do what you want? I'm using it to connect MS Access to MySQL,
and also to connect a Borland Delphi application to a MySQL database. It
works pretty well. Consult the FAQ for known glitches with specific
applications.
> -Original Message-
> From: LaBranche, Kevin [mailto:[EM
heh i've never tried it ?? all this bloody time
>= Original Message From Paul DuBois <[EMAIL PROTECTED]> =
>At 13:34 +1100 3/28/03, Daniel Rossi wrote:
>>hi guys is this possible ? order field1 and order by field 2 ?
>
>Perhaps, depending on what you mean. Did you try
>
>... ORDER BY field
Hello,
Are there any known issues using MySQL on Localhost with WinXP Pro and a
dual processor machine? The reason I ask is that I have a friend that is
trying to run MySQL with this configuration and he seems to have a lot
of problems keeping a connection to the database. Has anyone else seen
ooo thats sounds like something to avoid , if the compiling doesnt even work dont go
there, painful
>>> "Martin Gainty" <[EMAIL PROTECTED]> 03/28/03 09:38am >>>
Hej Michael-
In order to to see 4.1 mysqladmin working
I started to compiling the 4.1 source obtained from bitmaker
Originally I had
hi there i would like to find out how to get the table from a field if i am joining
three tables together for instance select a.id, b.id, c.id from a, b, c
when i get the results i need to be able to get the table name a if i get the result
from a.id , is it possible ?
--
MySQL General Mailin
1 - 100 of 116 matches
Mail list logo
