Hi,
We are doing a project with combination of ASP MYSQL (backend).
We are having some problem for setting relationship between the tables.
We have to know whether foreign key will be supported in MySQL and we came to know
that there is no use for foreign key(as per your documentation: The
MS office professional 2000 FULL version for $140 !!! NEW !!
If interested email at [EMAIL PROTECTED]
Verified Business Paypal owner so purchases FULLY protected
Verified Aol subscriber
Verified Address
Not burns,oem,accademic,charity,demo or otherwisebut FULLY hologrammed
authentic ms
As of version 3.23.33 MySQL became attractive to deploy in our project
because it now includes (preliminary, though) support for full text
indeces. That is a GREAT advantage to prior versions. So,
congratulations for that feature, with that MySQL is definititly moving
on the right path and
Keneth wrote:
"When I try to dump sql database it gives me some errors 1.Error 1045
mysqldump --opt database backup-accp.sql mysqldump: Got error: 1045:
Access denied for user: 'accp@localhost' (Using pass word: NO) "
can you help?
Please read the manual and list archive!
Before
Hi!
On Mar 12, Martin Rode wrote:
Now, unfortunately the FULLTEXT support as it stands right now has a few
drawbacks (all my tests where done with 3.23.33 and ~ 20 rows (~
60MB) in my test table.:
- searches for words with hits 100 are reasonably fast (1 sec.)
- searches with hits
Sorry, it appears to be _not_ a bug in mysql 3.23.34 but a conflict with the
apache module mod_auth_mysql.
It's still weird since i only noticed after installing 3.23.34, and had no
problems herefore.
Downgrading to a earlier version however did not solve the problem!
My collegue installed the
Description:
I`ve compiled the source package 3.23.32.
CFLAGS="-DHPUX -I/opt/dce/include" CXXFLAGS="-DHPUX -I/opt/dce/include
-felide-constructors -fno-exceptions -fno-rtti" CXX=gcc ./configure --with-pthread
--with-named-thread-libs='-ldce' --prefix=/usr/local/mysql
Perl DBI with the Mysql and the Informix drivers installed.
Curtis
- Original Message -
From: "MArk Williams" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, March 12, 2001 7:21 AM
Subject: Can mysql read from Informix
I have a mysql server running.
I would like to be able to
Hi!
just downloaded MySQL, and compiled the c-code example located in
MySQL\examples\libmysqltest
It works fine for the default database called mysql ... but not for any
of the other databases.
Any clue?
Best Regards,
Christer
Sergei Golubchik wrote:
Hi!
On Mar 12, Martin Rode wrote:
Now, unfortunately the FULLTEXT support as it stands right now has a few
drawbacks (all my tests where done with 3.23.33 and ~ 20 rows (~
60MB) in my test table.:
- searches for words with hits 100 are
Can someone point me to a comparison of the three different transaction-based table
types in MySQL? It is unclear from the on-line documentation what the
benefits/features/limitations are for each of these types.
Thanks
Ray
--
Justin writes:
Thank you Sinisa,
I actually did try the upgade, but rapidly reverted due to errors
such as these:
mysqld got signal 11;
stack range sanity check, ok, backtrace follows
0x812cfea
0x809f541
0x809da87
:
:
etc
AND...
read_const: Got error 127 when
Gary Shea writes:
cut
Sorry, this is my fault for not describing the problem better.
Here's the result I get with DISTINCT (I've given the columns
names to make the table smaller, but not changed the SQL from what
I sent in the bug report):
+---+
| i |
+---+
| 1 |
| 2 |
Jordan Russell writes:
Seems like MySQL 3.23.34a has a problem (?). I'm using the RPMs from the
MySQL web site on RH 7.0.
CREATE TABLE files (
id int(11) NOT NULL auto_increment,
folderid int(11) NOT NULL default '0',
name varchar(100) NOT NULL default '',
date datetime
[EMAIL PROTECTED] writes:
Description:
I`ve compiled the source package 3.23.32.
CFLAGS="-DHPUX -I/opt/dce/include" CXXFLAGS="-DHPUX -I/opt/dce/include
-felide-constructors -fno-exceptions -fno-rtti" CXX=gcc ./configure --with-pthread
--with-named-thread-libs='-ldce'
Greetings and salutations,
EverybodySingAlong
MySQL Supports FKs. A FK is a table's PK value, stored in another table in
order to relate the records together. It does NOT support FK CONSTRAINTS.
(Cascading deletes, restricts, etc.)
/EverybodySingAlong
...and now for the opinion portion of our
Do't be offended by the title:
http://www1.fatbrain.com/asp/bookinfo/bookinfo.asp?theisbn=0764504150vm=
GREAT Primer on SQL. Very M$ SQL oriented but you will get enough grounding
in SQL to make the leap to MySQL.
Cal
http://www.calevans.com
-Original Message-
From: hanan khader
Hi,
first,
from c:\mysql\bin run mysql then you can create a database named as you like
with command "create database;"
after you can view it, "show database;".
When you had created your database, you can create your first table.
Regards,
Carlos
-Original Message-
From: hanan khader
Description:
I just upgraded from Mysql 3.23.28 to 3.23.34 and I'm now seeing mysql
errors from my scripts that say "mysqld has gone away". The
/var/lib/mysql/host.err log says this repeatedly:
mysqld got signal 11;
The manual section 'Debugging a MySQL server' tells you how to use a
stack
Here it is in perl/DBI using hashes of arrays:
my $database =
DBI-connect("DBI:mysql:database=$DATABASENAME;host=$HOSTNAME
ST",$MYSQLUSER,$MYSQLPASS,{RaiseError=0,PrintError=0});
my $tablea = $database-prepare("SHOW TABLES FROM DATABASENAME");
$tablea-execute();
my @active_tables;
HI!
Please try to make a repeatable test case if possible.
This means a set of commands that would always lead to MySQL crashing.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*|
I couldn't connect to mysql server, beacuse it said
that user root@localhost couldn't connect (?!)
but before that I did something with the grant tables,
I don't remeber what? But I made one cgi that used
tables, but it coonected to the mysql server as root
user and a password, and it perfectly
Hi,
Can anyboby help me out. I am in a fix over how to carry out CREATE TABLE using C
APIs. The manual is of no help in this matter.
So anybody I please help me out.
Thanks in advance.
Shambhu.
_
Chat with your friends as soon as they
At 05:14 PM 3/12/2001 +0200, Sinisa Milivojevic wrote:
Please try to make a repeatable test case if possible.
This means a set of commands that would always lead to MySQL crashing.
The problem does seem caused by a sequential set of operations. The script
that I've seen cause the problem
The problem does seem caused by a sequential set of operations. The script
oops, I'm meant to say "doesn't seem caused"
-bill
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hi!
I am currently trying to compile 3.23.34a coming with BDB support.
I have zlib installed in the /usr/local (not normally searched for
libraries), so that until now I have
[CFLAGS etc ] LDFLAGS=-L/usr/local/lib ./configure
When enabling --with-berkeley-db, compilation fails, because I have
On Saturday 10 March 2001 22:16, Justin wrote:
Well thats good to know.. although this is sustained 24x7x365
linux 2.2.14-5.0smp, uptime 170 days but e2fsk ok's the
the database partition, which is a mirror.
in an attempt to get stability, I've been running on the official
3.22.32 mysql
Hi, readers of the mailing list!
the Innobase table handler has finally been released as a part of
the MySQL-3.23.34a source distribution Tarball. Note that the Windows
source distribution or the binary distributions do not contain yet
Innobase.
I have copied below the release note. I will post
I was wondering what others are thinking with respect to transaction table
type (BDB, Innobase, or Gemini) choices.
It seems to me that if you want transaction support in MySQL, then you must
pick one of the available transaction table types. And I would also assume
that row level locking would
Hi,
This is the first time I have ever used or attempted to install my sql. I am
using a Sun Ultra 5 with Salaris 5.8. I have downloaded
mysql-3.23.34-sunsalaris2.7-sparc.tar.gz and have attempted to unzip this
with the command:
gunzip mysql-3.23.34-sunsalaris2.7-sparc.tar.gz | tar xvf -
All
TranceMaster wrote:
I couldn't connect to mysql server, beacuse it said
that user root@localhost couldn't connect (?!)
but before that I did something with the grant tables,
I don't remeber what? But I made one cgi that used
tables, but it coonected to the mysql server as root
user and a
From: hanan khader [mailto:[EMAIL PROTECTED]]
Sent: lunes, 12 de marzo de 2001 11:02
To: [EMAIL PROTECTED]
Subject: from where shall I start ?
Hello ,
to build a database using SQL Server, from where shall I start ? I mean,
what shall I install on my Server, and how can I work with
Phillip Vamplew wrote:
Hi,
This is the first time I have ever used or attempted to install my sql. I am
using a Sun Ultra 5 with Salaris 5.8. I have downloaded
mysql-3.23.34-sunsalaris2.7-sparc.tar.gz and have attempted to unzip this
with the command:
gunzip
Hi,
I have tried to create a table with two fields. One is type CHAR and other
is VARCHAR and it convert the CHAR to VARCHAR automatically. IS it a bug or
i need to do some setting to work properly.
I am working on WINNT machine.
Sanjeev Gupta
Programmer Analyst
Indus Consultancy Services
[EMAIL
"Gupta, Sanjeev" wrote:
Hi,
I have tried to create a table with two fields. One is type CHAR and other
is VARCHAR and it convert the CHAR to VARCHAR automatically. IS it a bug or
i need to do some setting to work properly.
I am working on WINNT machine.
I just installed RH 7.0 selecting the 'install everything' option. Now
when I use safe_mysqld, it starts then ends immediately with the
following message in the log.
010310 12:43:30 mysqld started
010310 12:43:30 Can't start server : Bind on unix socket: Permission
denied
010310 12:43:30 Do
All appears to be working but after 10 seconds the process stops with the
error:
691 bytes, 2 tape blocks
tar: directory check sum error.
Fro reading the documentation, it does state that there could be problems
with Sun Salaris but what is the work around?
The work-around is to use
As the RPMs available on the MySQL site are built against RH6.x libraries,
is there someplace where I can get versions linked against RedHat 7
libraries? RedHat themselves don't seem to have anything newer than 3.23.32
whereas I'd like to use 3.23.34.
Yeah yeah, I know I should have installed
As the RPMs available on the MySQL site are built against RH6.x libraries,
is there someplace where I can get versions linked against RedHat 7
libraries? RedHat themselves don't seem to have anything newer than 3.23.32
whereas I'd like to use 3.23.34.
Yeah yeah, I know I should have installed
Well you need to look for updates on the RedHat site. There are conflicts
with the new version, I believe, as I was never able to achieve a
successful loading on my release 7.0 Linux box. I would say this may be a
good time to contact them directly.
Charles Hagen
On Tue, 13 Mar 2001, Alec
Hi Rick,
In my C code, I use SQL statements, but I use the mySQL C API to pass on the
SQL statements, check for errors, number of rows returned, and access the
results. I would assume that this will still work; they still work with BDB
tables.
ok, it should work like for BDB. There may be
Well,
My best method has been to do the following:
1. Dumb the existing database to a file: mysqldump databasename
database.txt.
2. On the new machine, create the new database. create databasename
3. Copy the file (database.txt) to the new machine.
4. Type.. mysql databasename
After the vitriolic debates I've seen between the PostgreSQL fanatics and
the MySQL defenders, I thought I'd ask for clarification on the support for
transactions that's supposedly provided by the use of BDB tables:
Having used Oracle for a while (and given my understanding of how
transactions
Hi,
Got some tips and trix from some users about big tables,
-Using mysql 3.23.33
-ReadHat Linux 6.0 Kernel: 2.2.5
What I seem to must do is to get the "with-raid" to work
if a going to solve my problem, MERGE will be to complicated
to do when I have 11 diffrent Client prg working towards the DB
I'm using Microsoft Visual C++ version 6.0 and Windows 2000 Professional.
The manual samples works ... e.g. to run mysql and enter commandes manually
Anyone ... ?
/Christer
Christer Holmstrm wrote:
Hi!
just downloaded MySQL, and compiled the c-code example located in
Hi Jordan,
Well... today I can't seem to reproduce the problem anymore. :/ I was
getting it very frequently yesterday (on almost every try). I'm not sure
what has changed since then. I'll let you know if the problem happens again
and try to narrow down the exact steps to reproduce.
Is it
Rick,
Everything you wrote sounds good, except for one thing. I use the result
count from a select or delete for logical branching within my code. I.e. I
perform a select and if rowcount is zero, then I can do an update. That is
a problem.
Any thoughts?
The basic rowcount functionality
Well... today I can't seem to reproduce the problem anymore. :/ I was
getting it very frequently yesterday (on almost every try). I'm not sure
what has changed since then. I'll let you know if the problem happens
again
and try to narrow down the exact steps to reproduce.
Is it possible that
Hi everyone,
I'm stuck on one issue which is preventing me from using MySQL in production
on one particular database. (This is similar to my last post but this time
I'll explain better what I'm attempting to do.)
I'm trying to create a database of filenames and directories using MySQL. I
have
-Original Message-
From: Nemholt, Jesper Frank
Sent: viernes, 09 de marzo de 2001 19:52
To: '[EMAIL PROTECTED]'
Subject: Memory problems/bug ?
Hej!
Using MySQL 3.22.32 on Tru64 4.0F patchkit 4. Compiled with Compaq CC.
Ran optimize on a table, and after 10 minutes :
A .03 sec left join PREVENTS you from using MySQL.
This must be a troll.
You have no where clause, so no index is used.
Jordan Russell wrote:
Hi everyone,
I'm stuck on one issue which is preventing me from using MySQL in production
on one particular database. (This is similar to my last
A .03 sec left join PREVENTS you from using MySQL.
This must be a troll.
Sigh...
I guess I failed to mention this was a deliberately simplified example in
order to pose my question in a easy-to-understand manner. In reality, there
are much more records, and a more complex query, where the
You have no where clause, so no index is used.
Oops, missed this part.
Where exactly do I need a WHERE clause, and for what? The first query
doesn't have a WHERE clause and yet it appears to be using the "date" index.
Jordan Russell
Hello,
I have updated my mysql server from version 3.22.25 to
3.23.33. I've noticed that the same query's output I've run
in the old version differs from the new version's.
Eg.
I've got a film database:
SELECT COUNT(*) FROM FILM;
returns me a number of 53.
The same select with a WHERE
Hi,
Thanks for the reply.
Hve you read
http://www.mysql.com/documentation/mysql/bychapter/manual_Performance.html#L
EFT_JOIN_optimization
?
Yes, many times, as well as just about everything else in the Performance
chapter. Am I missing something totally obvious? Should I even be using a
LEFT
And
SELECT COUNT(*) FROM FILM WHERE COMMENT IS NULL:
returns what?
"P.Peti" wrote:
Hello,
I have updated my mysql server from version 3.22.25 to
3.23.33. I've noticed that the same query's output I've run
in the old version differs from the new version's.
Eg.
I've got a film
I don't know if this list still gets read by the staff TcX or not, but I
have this suggestion:
1/ For those of us willing to code the glue logic to make triggers,
constraints, and foreign keys work, it would be VERY helpful if ALL the
commands that are exercised on a table at creation or
Everything I've seen on this list indicates that using LEFT JOIN negates
using an index. (WARNING: This is 3rd hand info and as such should be viewed
skeptically!)
Have you tried:
SELECT files.id, dirs.name FROM files where files.dir_id=dirs.id
ORDER BY files.date DESC LIMIT 1;
If so, what
Everything I've seen on this list indicates that using LEFT JOIN negates
using an index. (WARNING: This is 3rd hand info and as such should be
viewed
skeptically!)
Have you tried:
SELECT files.id, dirs.name FROM files where files.dir_id=dirs.id
ORDER BY files.date DESC LIMIT 1;
If so,
/* This table has 5000 rows */
CREATE TABLE files (
id int(11) NOT NULL auto_increment,
dir_id int(11) NOT NULL default '0',
name varchar(100) NOT NULL default '',
date datetime default NULL,
PRIMARY KEY (id),
KEY date (date)
) TYPE=MyISAM;
for grins and giggles, add:
key
Jordan Russell wrote:
Everything I've seen on this list indicates that using LEFT JOIN negates
using an index. (WARNING: This is 3rd hand info and as such should be
viewed
skeptically!)
Have you tried:
SELECT files.id, dirs.name FROM files where files.dir_id=dirs.id
ORDER BY
/* This table has 5000 rows */
CREATE TABLE files (
id int(11) NOT NULL auto_increment,
dir_id int(11) NOT NULL default '0',
name varchar(100) NOT NULL default '',
date datetime default NULL,
PRIMARY KEY (id),
KEY date (date)
) TYPE=MyISAM;
for grins and giggles, add:
key
Has anyone contemplated using MySQL for DTP through a cluster of
machines where the transactions are related to critical financial
transactions.
For example, in a commerce situation where a customer withdraws from one
account and deposits into another, DTP ensures that all computers commit
FYI,
This problem got worse as more users began using the system. I had to
revert back to 3.23.28, which did solve the problem.
I'm sorry that I didn't come up with a reproducible test case. As near as
I could tell it seemed to be intermittent in nature. Things would work,
then not work.
Hello,
And
SELECT COUNT(*) FROM FILM WHERE COMMENT IS NULL:
returns what?
Sure, I forgot to mention that I know it's all about the
NULL values, i can correct the "problem" (maybe not a
problem but I think it's a weird behavior) i just don't
understand why?
The query you mentioned returns
"Weber, Jeff" wrote:
Mysql is hanging when started on my Linux box (Red Hat Linux release 6.2
(Zoot)
Kernel 2.2.14-5.0 on an i686 -- mysqld, Version: 3.23.21), so I thought I
would reinstall mysql_install_db. This hangs too, see below...
[root@myserver mysql]# mysql_install_db
Creating
I recently moved to a new server, and successfully copied the database over
to the new server. However, at least half of my queries are returning the
error:
ERROR 2013: Lost connection to MySQL server during query
The error seems to be random, and only with longer queries. I'm guessing
this is
Hi,
What would be the workaround for migration from linux redhat 6.2 with mysql 3.23 to
windows 2000 with mysql. I have a database dump in mysql 3.23 for linux.
Merci,
Jean-Francois Duckett
[EMAIL PROTECTED]
514.281.0905
- See the world, Set the price - www.thedailyauction.com
"P.Peti" wrote:
Hello,
And
SELECT COUNT(*) FROM FILM WHERE COMMENT IS NULL:
returns what?
Sure, I forgot to mention that I know it's all about the
NULL values, i can correct the "problem" (maybe not a
problem but I think it's a weird behavior) i just don't
understand why?
The
This join works perfectly in Access but if I use the same query in MySQL it
shits it's pants.
SELECT tbl_medien.titel, tbl_medien.ausgabe, tbl_medien.URL,
tbl_medien.medientypID, tbl_autor.name, tbl_autor.vorname
FROM tbl_medien INNER JOIN (tbl_autor INNER JOIN
tbl_zuordnung_autoren_medien ON
Sanjeev Gupta
Programmer Analyst
Indus Consultancy Services
[EMAIL PROTECTED]
201-261-3100 x 264
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
Hello P.Peti,
Monday, March 12, 2001, 11:17:16 PM, you wrote:
PP It just seems to be weird that a subset and its complement
PP does not equal the whole table. So the thing is:
PP #"!deleted" doesn't include "#NULL" as the set filtered by
PP the clause 'WHERE comment!="deleted"' doesn't
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: mysql_install_db hanging with three mysqld processes
Description:
I sent a mail last week with a problem with mysql_install_db hanging. I have
followed all of the advice from previous posts with no luck. I have noticed that my
Jordan,
Ok, I'm out of ideas. The additional index should have sped things up, not
slowed them down. I've got some tables with 26,000 rows in it and I do 4
joins (using a WHERE clause) with smaller tables without a hitch.
Sorry I can't help.
Cal
http://www.calevans.com
-Original
Description:
The code that checks for cc may pick the "first" cc it finds in its path,
which may not be the same cc used for compling, eg it may choose /usr/bin/gcc over
/usr/local/bin/gcc
How-To-Repeat:
Look in the code for mysqlbug
Fix:
Ah this depends on finding the
What is your swap size? What is your drive space? It sounds like you
need to upgrade to their latest. Did you load all the updates on your 6.2
box?
Charles Hagen
On Mon, 12 Mar 2001, Weber, Jeff wrote:
Mysql is hanging when started on my Linux box (Red Hat Linux release 6.2
(Zoot)
Kernel
Dear All
The following C and CXX flags will work (/usr/local/bin/gcc is actually
pgcc).
Reading specs from
/usr/local/lib/gcc-lib/i686-pc-linux-gnu/pgcc-2.95.2.1/specs
gcc version pgcc-2.95.2.1 20001224 (release).
CC='/usr/local/bin/gcc' CFLAGS='-O6 -mpentiumpro -mstack-align-double'
Platform: SunOS 5.8
MySQL Version: 3.23.33 Source distribution not binaries.
gcc version: 2.95.2
Problem: Getting some fatal compiler errors when I run configure. Not sure what to do
about it.
Any and all help is appreciated. I've tried using this lists archived email for an
answer, but all
Lutz,
what compiler are you using? GCC? HP:s own commercial compiler, I assume.
I am currently trying to compile 3.23.34a coming with BDB support.
I have zlib installed in the /usr/local (not normally searched for
libraries), so that until now I have
[CFLAGS etc ] LDFLAGS=-L/usr/local/lib
I hope you can also use MySQL dump, in which case, you don't have to shut
down, right?
j- k-
2) Can you perform backups as with other tables?
You have to shut down the database, make sure that it shuts down without
errors, and then copy the Innobase data files to a safe place (it
The answer you seek is clearly explained in the manual.
- Original Message -
From: "Gupta, Sanjeev" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, March 12, 2001 3:34 PM
Subject: how to create stroed procedure in mysql
Sanjeev Gupta
Programmer Analyst
Indus Consultancy
You can't.
Cal
http://www.calevans.com
-Original Message-
From: Gupta, Sanjeev [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 12, 2001 3:34 PM
To: '[EMAIL PROTECTED]'
Subject: how to create stroed procedure in mysql
Sanjeev Gupta
Programmer Analyst
Indus Consultancy Services
I wish to:
GRANT SELECT ON mediabankmaster.clients TO [EMAIL PROTECTED]
GRANT SELECT,INSERT ON mediabankmaster.publicdocs TO [EMAIL PROTECTED]
however, this does not work.
'cemail' can SELECT from clients.
'cemail' can INSERT into publicdocs.
'cemail' CAN NOT SELECT from publiccocs.
I don't
so does the mysql have to be installed under
/usr/local/mysql ?
I made a symbolic link named mysql that points to the
/usr/local/mysql-3.23.32-pc-linux-gnu-i686 directory
is that ok ?
__
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at
Joshua,
I hope you can also use MySQL dump, in which case, you don't have to shut
down, right?
yes, you can use mysqldump without shutting down. It did not come to my
mind that actually mysqldump is a kind of online backup mechanism :).
Since Innobase is multiversioned, you will get consistent
Zoran Raskovic wrote:
so does the mysql have to be installed under
/usr/local/mysql ?
I made a symbolic link named mysql that points to the
/usr/local/mysql-3.23.32-pc-linux-gnu-i686 directory
is that ok ?
yup
I go further and seperate data from binaries.
This helps with partion
Seems like it would be relatively easy to implement inserting into merge
tables. I'd like to be able to at an absolute minimum round-robin
insert, but even better would be something like you can do with
partitioning in oracle.
Baically, something like this:
create table x (...) type=merge
Description:
When I try and run scripts/mysql_install_db I get the error
'/usr/libexec/ld-elf.so.1:
/usr/lib/libstdc++.so.3: Undefined symbol "__ti9exception"' I also got the same error
when I tried to run mysql using
/usr/local/mysql/bin/mysql as stated in the Subject I have
In the last episode (Mar 12), [EMAIL PROTECTED] said:
Description:
When I try and run scripts/mysql_install_db I get the error
'/usr/libexec/ld-elf.so.1:
/usr/lib/libstdc++.so.3: Undefined symbol "__ti9exception"' I also got the same
error when I tried to run mysql using
On Tue, Mar 13, 2001 at 12:00:57AM +0200, Heikki Tuuri wrote:
what compiler are you using? GCC? HP:s own commercial compiler, I assume.
I tend to prefer HPs commercial compiler (the code tends to be smaller
and faster when running at high optimization levels).
BTW, the compilation of innobase
I've posted a few times about problems with index corruption,
problems with inconsistent select results using indexes, and
problems with hanging count(*) and distinct(*) on indexes.
No good suggestions were provided other than upgrade to 3.23.34,
(which I am loath to do unless I understand
See Section 4.12.1 (Solaris Notes)of documentation.
Use gnu version of tar rather than Sun tar.
Copy available at:
http://www.mysql.com/Downloads/
John Fiegel
-- Original Message --
From: "Phillip Vamplew" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Hi Silver
I've never tried changing character sets myself but you did download the
right version and I mean source not binaries of 3.23.32?
You know you can also get away with using the default charset as Chinese
chars are sorted in ASCII anyway. Only problem is, you need a Chinese front
end
-Original Message-
From: John Runnels
Sent: Friday, March 09, 2001 10:47 AM
To: Mysql (E-mail)
Subject: FW: status report
-Original Message-
From: Bob Vastine-Parker
Sent: Friday, March 09, 2001 10:32 AM
To: John Runnels
Subject:
Since I posted so many times about my problem, I feel obligated to notify
everyone I have resolved it, and exactly what was wrong.
I have two fields: last_update, and last_login. Both fields are timestamps,
with defaults of "000". My queries were doing things like:
I have just been able to repeat a bug in a rather simple ORDER BY queries
that was introduced in 3.23.34. I wonder how in the world our test suite
managed to miss it. We should have a fix shortly and as soon as it is
available, will post a patch and will also release 3.23.35. Which reminds us
When I install mysql rpm , he puts it in
/var/lib/mysql directory
then, when I try to start mysql, he says that he can't
find mysql.sock in /tmp/mysql.sock
I donno why he is looking for it there, probably
because I had binary version of mysql in
/usr/local/mysql dir before.
mysql.sock is in
the server creates the mysql.sock directory wherever you tell
it to .. check /etc/my.cnf
Once that is setup properly, server and client should agree.
If you leave it in /tmp, then set the /tmp sticky bit to stop
it getting accidently rm'd
-Justin
On Mon, Mar 12, 2001 at 07:57:49PM -0800,
Hello,
Thanx for the answers, I think I've got the point now. I
have one more doubt though. You described me that this
whole thing with the comparison not working with NULL
values is obvious. Why did it work in 3.22.25 then?
Thank you for the answers so far.
Bye:
PP.
Can anyone explain why LIKE queries do not use an index when the LIKE string contains
a forward slash?
Example:
CREATE TABLE words ( word varchar(250) PRIMARY KEY );
Populate table with 200,000+ rows
EXPLAIN SELECT * FROM words WHERE word LIKE 'abcdef';
This query uses the Primary key to
1 - 100 of 102 matches
Mail list logo