>Can anyone explain why LIKE queries do not use an index when the
>LIKE string contains a forward slash?
Follow-up to my own post:
The problem is with the '_' wildcard, but I still don't understand. My
previous examples were simplified, but here is the exact query:
SELECT * FROM words WHERE word
Hi,
I would like to extract the contents of a database to use it in a ASCII
format. It is a addresses database and I want to use it in Excel. I have
tried Mysqldump but it gives me the CREATE and INSERT statements all the
time.
Any ideas?
Gilles
__
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 sear
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.
-
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, Zora
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 direct
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
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:
MONTHNAME(last_logi
Sorry to post AGAIN, but I have new info. I was monitoring the Error Log,
and when I run the query that crashes MySQL, I get the following error:
mysqld got signal 11;
The manual section 'Debugging a MySQL server' tells you how to use a
stack trace and/or the core file to produce a readable back
Are temp tables the best way to handle a 'SUBSELECT'?
I can't see moving large amounts of data through pipes/sockets into an
PHP interpeter and it's array mechanism, sifting through that to get
what I need. It would be better to do that all in the memory of the
server with the MySQL daemon on it,
I have some further information about the problem I'm having. To refresh:
certain queries that used to work on my old server are now failing, giving
me the error:
ERROR 2013: Lost connection to MySQL server during query
TO test the problem, I enabled logging, and was keeping an eye on my log
fil
> -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
>
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 to
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 PROTECTE
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 why),
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 innobas
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
> /usr
>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 FreeBSD
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 union=
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 st
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 consisten
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 g
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 know
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
[EMAIL
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 Consulta
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 (
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 .
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 a
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'
CXX='/u
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)
> Kern
>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
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 Message
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
si
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 i
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 list
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
tbl
"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
> understan
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
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 o
"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
> Cr
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 retu
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.
Shankar,
MySQL now provides (3.23.34a Unix source distribution) transactions both
through BDB and Innobase tables. I will try to answer your questions
for Innobase.
>After the vitriolic debates I've seen between the PostgreSQL fanatics and
>the MySQL defenders, I thought I'd ask for clarificatio
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
concu
> Do you have an index on files that starts with dir_id and
> an index on dirs that stats with id and having date in the files
> index (after dir_id) might be helpful although I'm not sure.
Sorry, I don't understand exactly what you mean, but...
> you could provide the output of
> show keys from
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 func table
Creating tables_priv
> /* 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,
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.i
/* 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 dir_id(dir_
Hi Peter,
and sorry that this response to your Big Mail comes some 12 days late.
We have put together the release 3.23.34a and that has occupied
my mind.
>HT> In pure insertions, copying a table to another, I have measured that
>HT> Innobase is about as fast as MyISAM. In aggregate queries from
> 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;
>
>
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 were
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 modifica
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
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
LE
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 COM
This is NOT an RTFM reply.
Hve you read
http://www.mysql.com/documentation/mysql/bychapter/manual_Performance.html#L
EFT_JOIN_optimization
?
Cal
http://www.calevans.com
-Original Message-
From: Jordan Russell [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 12, 2001 2:05 PM
To: Gerald L
> 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
--
> 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 t
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
Dear All
I got very excited today when 3.23.34 worked (i.e now show tables bug) !
I then recomplied with optimisations and then with pgcc and bug
reappears.
I am now having a go with different CFLAGS and CXXFLAGS.
Not being a C / complier / libs expert I can not comment any further !
How weir
> -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 minu
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 tw
> >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 poss
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
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 po
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 Holmström wrote:
> Hi!
>
> just downloaded MySQL, and compiled the c-code example located in
>
> MySQL\exa
Sinisa Milivojevic wrote:
> I was not able to obtain the same effect on my 3.23.33.
BTW, the problem was for 3.22.*34* not 33.
> Please uploat
> your table to ftp://secret.mysql.com/pub/mysql/Incoming , so that I
> can test it.
Well... today I can't seem to reproduce the problem anymore. :/ I w
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
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 wo
> 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?
Have you tried installing the RPMs from the MySQL site? They installed just
fine on my RH 7.0 box on the first try. I do have all of the
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 < data
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 s
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 Smit
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
This is a permissions issue. Check the directories mysql is located in
and grant executable permissions. Also verify ownership requirements for
each of these directories.
Charles Hagen
On Mon, 12 Mar 2001, Russ Heaton wrote:
>
> I just installed RH 7.0 selecting the 'install everything' optio
> 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
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 y
"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.
>
http://www.mysql.com/doc/S/
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
Hi, can anybody help me with this query
mysql> SELECT
-> tblOperation.id,
-> tblRoom.fldRoomName,
-> tblPerson.fldPersonId AS History_Number,
-> tblOrderKind.fldOrderKindName,
-> tblOrderKind.fldOrderKindCode,
-> tblOperation.fldCalculatedEndTime AS operation_end_time
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 < mysql-3.23.34-sunsa
> 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 w
Shambhu Kumar singh wrote:
>
> 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.
>
"CREATRE table" using C API should be treated just
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
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
Hi,
Can anyboby help me.
I'm try to write a UDF which replace substring in string according regular
expression.
When I compile my program with -I ./../regex gcc switch I recive as result
"Segmentetion fault". But when I compile my program without -I ./../regex -
my program works fine. I think gc
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
Rick,
>I wasn't sure if I should email to the mysql list or directly to you. Here
maybe it is best both to post to the mailing list and send a carbon copy
directly to me, so that others can share the advice.
>are my questions about the Innobase tables:
>
>1) Do you have to start a transaction
On Monday 12 March 2001 17:17, Heikki Tuuri wrote:
> 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.
Great news!
Congratulations for a great addition to the (already) great MySQL software.
--
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
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 my
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 a
>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)
http://lists
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 so
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 come
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 wo
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
/*/ /*/ /*/ \*\_ |*|
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_table
1 - 100 of 121 matches
Mail list logo
