[EMAIL PROTECTED] schrieb:
>
> does the current version of 'phpMyAdmin 2.1.0 work with PHP 4.0.4?
>
> i downloaded 'phpMyAdmin 2.1.0 with php3 extensions' (from the php
> site) and my browser won't even open the file 'index.php3' as a file.
> and when i try to go to http://myhost/path_to/phpMyAd
I don't have internet access at home, also the mysqlbug script could not send
the mail automaticaly, but have edited the output and included it as
attachement.
and once again:
there is a problem with 'select distinct' in some case (distinct+join+order by)
the problem is to see in attached file
I am running mySQL 3.23.32 with ColdFusion 4.5 on a RedHat Linux 6.2
machine. MySQL continuously crashes. I've been told that it could be that
the ODBC driver is not up to date. Where can I get these drivers... or do
you have any suggestions as to what I should do?
Please help.
--
Greets All:
Deja just got purchased by google today, and, usenet search is gone. No answers
out there, anymore folks. >:(
I have my firewall redirected from the router to a FreeBSD box that can't do
sshd for a few days because of recent exploits. It won't build. Period. Spent
5 hours on it.
Hello,
I am creating a script which works offline from the mainstream of our system
and updates our databases.
These scripts includes INSERTING, UPDATING and DELETING records.
I am performing a updating operation using Python which takes really some time.
Something like,
update TABLE1 set col1=
Hi
I post once more this message, because I didn't receive any answer.
- Message d'origine -
De : Philippe MORIN
À : [EMAIL PROTECTED]
Envoyé : vendredi 9 février 2001 09:49
Objet : Concurrent insert/select with BDB
Hi
I'm using MySQL 3.23.32 on Linux.
I try to run concurrent inse
Hi all,
I've a bit of an issue with mysqld -- errr is it?
Here's the configuration
Dell PowerEdge 6300
- 1GB ram (actually 2GB but no bigmem support at the moment - I'll get to
that)
- RH linux 6.1 running 2.2.12-smp (needs updating, I know - but hard to find
good 'down time')
- 4 10gig UW-
While downloading phpMyAdmin you can choose whether to use .php or .php3
extensions ...
And if you don't want to then Just add .php3 to AddType in apache or through
.htaccesss
Cheers,
Maxim Maletsky
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday
or write a web page that queries the database directly with php, perl
dbi or whatever. then you don't have to set up separate accounts,
give people telnet access, etc.
MT
>Search for the information on grant tables on mysql.com.
>
>.. Atle
>
>On Mon, 12 Feb 2001, Mike Yuen wrote:
>
>> I and
Dear Sir,
We are trying to figure out if mySQL has XML support, say, in the way that
Oracle does. We were not able to locate any specs to this end.
Can you let me know if there are any XML tools built into mySQL, or if there
are any well-developed 3rd party tools for the same?
does the current version of 'phpMyAdmin 2.1.0 work with PHP 4.0.4?
i downloaded 'phpMyAdmin 2.1.0 with php3 extensions' (from the php
site) and my browser won't even open the file 'index.php3' as a file.
and when i try to go to http://myhost/path_to/phpMyAdmin/index.php3
i get 'the requested ur
I don't understand will someone please look at this code and see what is
wrong.
\n");
?>
All I want to do is display the results in HTML then I will be unstoppable
:)
But every time I execute this I get
Warning: Failed opening 'c:\inetpub\wwwroot\testmail.php' for inclusion
(include_path='') i
On Wed, Feb 14, 2001 at 09:03:16AM +0800, Rolf Hopkins wrote:
> Do you have a cron job that's cleaning up your socket file along with
> whatever other garbage it's cleaning up?
Nope. As I said in my original mail:
> I don't have a cronjob, or any other external process that scrubs /tmp.
I'm wa
Hi sara,
Try with:
Connection myConn =
DriverManager.getConnection("jdbc:mysql://localhost/test_db1,"user","passwor
d");
I can able to understand that you want to use mysql database using Jsp.
regards,
S.Chitra
I had the same problem just yesterday.
-> MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.33-1
benchmark uses Perls DBI modules, so U have to install them before installing
MySQL-bench.
Unless U R going to perform benchmarking U need not install MySQL-bench modules.
-> mysql = 3.23.22 is ne
"They're bccckkk!!!"
Try installing, using the skip dependency check flag.
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 14, 2001 11:13
Subject: installing mysql 3.23.33 rpm on RH7
> Hi,
>
> I'm trying to install the lastest versio
Hi,
I'm trying to install the lastest version of mysql 3.23.33 rpm
(downloaded from mysql.com) on RH7 using the command "rpm -Uvh MySQL*"
but encountered "failed dependencies error" as shown below:
error: failed dependencies:
MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.33-1
mysql = 3.23.2
The documentation puts me off going with BDB tables - since there is a big performance
hit.
There is a fair bit in the manual as to the preferred approach under MySQL ie atomic
updates.
At the moment for MyISAM tables - the fast ones I understand - it seems that all we
have
to play with is Lock
Hi,
Attached is a bug and a question.
Regards,
Jonathan
user id: jberall4691
__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
SELECT t.trans_id, t.trans_no, DATE_FORMAT(t.tra
I can't see anything wrong with your code? What exactly is the problem?
Aren't the values, from the select statement printing out on your web page
or something? Are you sure you provided the right code?
- Original Message -
From: "Stinsman, Scott" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECT
Won't a "Drop TABLE" work?
Brady...
Original Message Follows
From: "Crystal D. Silver" <[EMAIL PROTECTED]>
Reply-To: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: help please?
Date: Tue, 13 Feb 2001 14:01:48 -0800
Hi,
My host gives me a MySQL database, and I've had no trouble
Do you have a cron job that's cleaning up your socket file along with
whatever other garbage it's cleaning up?
- Original Message -
From: "Brian Reichert" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 14, 2001 4:42
Subject: Re: /tmp/mysql.sock disappearing?
> On
DELETE FROM tableName;
Jiang
- Original Message -
From: "Crystal D. Silver" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 13, 2001 3:01 PM
Subject: help please?
> Hi,
>
> My host gives me a MySQL database, and I've had no trouble getting
purchased
> cgi scripts to
Apparently I jumped the gun today when I posted my last message about
compiling on Solaris. I had inadvertantly extracted and compiled an older
version of MySQL.
Tonight I compiled the latest version, 3.23.33, and it does indeed fix all the
shortcomings of the previous compiles with Solaris. No
drop table...
On Tue, 13 Feb 2001, Crystal D. Silver wrote:
> Date: Tue, 13 Feb 2001 14:01:48 -0800
> From: Crystal D. Silver <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: help please?
>
> Hi,
>
> My host gives me a MySQL database, and I've had no trouble getting purchased
> cgi scri
Hi,
Is it possible to get the total from the results of SUM in the same SQL
statement?
I want to have this output:
NameAmount Percent
Name1 15 25
Name2 15 25
Name3 30 50
My database only have the first two columns and the Percent column is
calculated
Hi,
I've got a question about the use of indexes.
I've a site running quite good. I've such features
like polls and all that usual stuff.
I take the poll tables as example.
POLLS:
idpoll bigint unsigned not null auto_increment primary key,
I would like to see some 'bash-like' abilities for an alias command and a
.mysql file or something similar to store commonly used queries (to be
accessed by a single keyword). I find myself writing extremely long
queries from time to time and I have to store them in a text file and
worry about co
On Tue, 13 Feb 2001, Crystal D. Silver wrote:
> in the documentation about how to just plain DELETE everything in the
> database (i don't want to delete the installed database itself, just go back
> down to where there's nothing in it, so I can start over)...could somebody
> tell me what to do?
http://www.mysql.com/documentation/mysql/bychapter/manual_Compatibility.html#Missing_Transactions
http://www.mysql.com/documentation/mysql/bychapter/manual_Table_types.html#BDB
-tcl.
On Tue, 13 Feb 2001, Eric Kwong wrote:
> I'm wondering if MySQL supports transaction?
> Since I have an appli
>I had forgotton how much in love with it I once was, until Outlook
>refused to behave as the help files said it would, and the help files
>describe capabilities that were simply not available. I have moved to
>Outlook, because I needed to access several email accounts, and the
>older versions of
Search for the information on grant tables on mysql.com.
.. Atle
On Mon, 12 Feb 2001, Mike Yuen wrote:
> I and 2 others are working on a web site an occasionally. Each of us are
> in different locations and exchange info email. Some of them
> need to query the database to compare results wi
Hi there,
please check the oracle migration bench at the oracle technet.
http://technet.oracle.com
kind regards
denis mettler
-Urspr?ngliche Nachricht-
Von: Noor Dawod [mailto:[EMAIL PROTECTED]]
Gesendet: Dienstag, 13. Februar 2001 17:23
An: Cal Evans; MySQL List
Betreff: RE: Exportin
I'm wondering if MySQL supports transaction?
Since I have an application to use MySQL JDBC to perform several insert
statements and then do a rollback, all data saved to the database without
rolling back.
-Eric
-
Before posting
Try Pegasus Mail. It is a very well designed email client, without
some of Outlook's bugs. It very versital, and it is also free. If you
want to get the most out of it, you can buy the manual.
I had forgotton how much in love with it I once was, until Outlook
refused to behave as the help file
>Description:
Corrupted tables cause REPLACE to complain about Duplicate entries.
Or maybe REPLACE gets confused and causes table corruption.
It doesn't happen all of the time which is the frustrating part of this.
>How-To-Repeat:
DBD::mysql::db do failed: Duplicate entry '3098
I _used_ to be able to log to a FIFO as recently as mysql-3.22.32,
but now with mysql-3.23.33, I can't:
010213 17:03:11 Could not use /var/mysql/db/localhost.fifo for
logging (error 29)
where in /usr/include/sys/errno.h:
#define ESPIPE 29 /* Illegal seek */
I'm gue
Isn't it possible the virus itself was actually removed by the mailserver
antivirus software? Can anybody confirm this just for we could feel more
safe? My Outlook 2000 shows the message and the attachment, but the
attachment is a text file with mailing list footer information - just like
somethin
I know I'm using a really old version of mysql (3.22.4a-beta)
but upgrading means changing my application, and I'd rather
avoid that right now.
I'm trying to get it to build on RedHat 7.0
I have updated gcc to 2.96-69
When compiling sql/sql_yacc.cc
The compiler appears to hang in pass 1.
Aft
Hi,
My host gives me a MySQL database, and I've had no trouble getting purchased
cgi scripts to integrate with it...however, now I want to deleted everything
(all tables within the database) and start from scratch...I've wasted a lot
of space and have double-installed some things, etc. I don't s
On Tue, Feb 13, 2001 at 08:35:44PM +0100, Fred van Engen wrote:
> I've seen it after installing two versions of MySQL on one server.
> I forgot to set another location for the second MySQL process
> before starting it with /bin/safe_mysqld. The result was that the
> socket was removed by the secon
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello all,
I am new to the list and need assistance. I noticed this thread in the
archives, but I didn't see an answer. So, I'll ask it again.
I have tried several times to use BerkeleyDB with MySQL to provide
transaction support. It has failed
Warren schrieb:
>
> Hi! I just posted the following silly (in retrospect) question
> $next=MYSQL_QUERY("select ref from questions where ref < $ref[0] ORDER BY
> ref DESC LIMIT 1");
no reason to apologize - sometimes the best postings :-
--
http://it97.dyn.dhs.org/
IrmundThum
+49 179 699
How do you define backwards? By what sort order?
Cal
http://www.calevans.com
-Original Message-
From: Warren [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 13, 2001 1:28 PM
To: [EMAIL PROTECTED]
Subject: changing the direction of searches via Select
Hi!
I'd like very much to be
Thanks everybody for helping me out... I got the scripts loaded and am
talking to mySQL via DBI now.
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of
> G. Adam Stanislav
> Sent: Tuesday, February 13, 2001 6:36 AM
> To: John W Ford; Mysql
> Subject: R
From: "Jon Haworth" <[EMAIL PROTECTED]>
Sent: Tuesday, February 13, 2001 5:40 PM
> Oh no, not another one
Mike and James - you fell for the good ol' trick.
Bu hu for you - don't you just "love" it? :-)
Now whoever made the little bastard this time...?
Funny thing actually: My Outlook Expre
mv file file~ ; tr -d '\015' file ; rm file~
Or, in vim, :set fileformat=unix
Or, use PFE32.EXE on Windows as your editor (allows saving
as Unix text file).
-Tilghman
--
"There cannot be a crisis today. My schedule is already full."
--Henry Kissinger
> -Original Message-
> From
Hi! I just posted the following silly (in retrospect) question
>I'd like very much to be able to walk backwards
>through a list of my
>records. How might I indicate
>that mysql ought to position itself at the
>highest record number and then all selects
>will go backwards (say with LIMIT 1) ?
I
To add to this, I'm running 3.23.32 (on Solaris). I really like
the concept of merge tables, but without the ability to insert
new records in underlying tables, it's far less useful for my
needs.
Thanks.
Fred.
On Tue, Feb 13, 2001 at 12:44:25AM +0100, Fred van Engen wrote:
> Hi,
>
> Is it oka
On Tue, Feb 13, 2001 at 11:50:28AM -0500, Brian Reichert wrote:
> I couldn't fine this mentioned in the archives, so I hope someone has seen
> this before:
>
> I'm running into a situation wherein /tmp/mysql.sock keeps disspearing.
>
> There is still server process (sleeping), and there is still
I set up two MySQL servers to run in a failover configuration. Because
queries will only ever be submitted to one server at a time, I decided to
use a makeshift two-way replication scheme under MySQL as descibed in
the MySQL manual.
First server (wallace) has this:
--
Hi!
I'd like very much to be able to walk backwards through a list of my
records. How might I indicate that mysql ought to position itself at the
highest record number and then all selects will go backwards (say with LIMIT
1) ?
Thanks for your time!
Cheers!
-Warren
-
John
Here is another solution to removing those '^M'
chars. This is a lot simpler
than my last idea :-
sed 's/^M//g' YOUR_FILE > YOUR_NEW_FILE
Michael Thomas
www.abcXyz.com
>
-
> Before posting, please check:
>http://www.
Try this,
The code below will remove the last character from
each record in your file. On your Linux system
enter this line on the command line and the
results will appear in the NEW_FILE. Obviously you
can name the input and output files anything you
want.
awk '{print substr($0, 1, length-1)}'
On Tue, Feb 13, 2001 at 11:45:55AM +0700, Andrea wrote:
> Hi all
>
> I am interesting on password routine in mysql
>
> Could some body help about this routine ?
>
> I download the source code of MySql, but i am not yet found about this
> routine
>
Are you looking for the following code from s
> > Or a handy one-liner...
> >
> > perl -pi -e "s/[\012\015]//" *.sql
> >
> >
>
> Or alternatively edit the file with vi and do:
> :s///
>
> This inteprets to the following keystrokes:
> ':' colon
> 's' s for substitute
> ''Ctrl-v-m to create the annoying ^M as one character
> '//'
Michael, it would be very nice if you would mark security related bugs
so that admins who are not subscribed on Bugtraq see them, too.
This is at least the second time where I got information about security
bugs in MySQL *only* via 3rd party and not from the web page nor from the
changelog.
Disa
On Tue, 13 Feb 2001, Irmund Thum wrote:
> Rolf Hopkins schrieb:
> >
> > "^M"???
The ^M is the carriage return/line feed usually found in ms/dos text
files.
On my Linux system (on downloaded files) I removed them by
tr -d \r old file > new file.
tr = text replace; -d delete; \r = ^M
see 'info
On Tue, 13 Feb 2001, Peter Skipworth wrote:
> Or a handy one-liner...
>
> perl -pi -e "s/[\012\015]//" *.sql
>
>
Or alternatively edit the file with vi and do:
:s/
//
This inteprets to the following keystrokes:
':' colon
's' s for substitute
'
' Ctrl-v-m to create the annoying ^M
Hi,
The two selects in this script:
drop table if exists foo;
create table foo (id int not null);
insert into foo (id) values (0), (1);
drop table if exists joiner;
create table joiner (joinerid int not null);
insert into joiner (joinerid) values
"M" is the thirteenth letter of the alphabet. ASCII 13 (^M) is the
carriage return. If you are using binary transfer on ftp, then you
will get these and any other control characters imbedded in your
file. Set your ftp to ASCII and try again. Perl is particulary
sensitive to this. HTML doesn't
I couldn't fine this mentioned in the archives, so I hope someone has seen
this before:
I'm running into a situation wherein /tmp/mysql.sock keeps disspearing.
There is still server process (sleeping), and there is still a pidfile.
This can happen after ten or fifteen minutes of queries.
I don
Oh no, not another one
-Original Message-
From: Mike Hammonds [mailto:[EMAIL PROTECTED]]
Sent: 12 February 2001 18:30
To: [EMAIL PROTECTED]
Subject: Here you have, ;o)
Hi:
Check This!
-
Before posting, please ch
>From what someone on this (can't remember who or I would give credit) list told me,
>It ONLY uses the index if you have it in the WHE
RE clause... and apparently the SQL optimizer catches that the MATCH AGAINST is the
same in both places and only runs it once...
- Original Message -
Fr
I couldn't find such product on Oracle's website.
Noor
-Original Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 13, 2001 5:51 PM
To: Noor Dawod; MySQL List
Subject: RE: Exporting data from MySQL to Oracle
Didn't Oracle just release a MySQL to Oracle migrati
Hi
Hmm, this seems to me like redundant code.. if you're holding info in
Score, and not using it but only using the same operation that was used
to create it, then it's a redundant code..
Are you sure the second form works faster than the first one?
Noor
-Original Message-
From: Jason
A mistake I made for a long time with MATCH AGAINST is to not include it in the WHERE
clause
eg I did
SELECT ID,MATCH Q,A AGAINST ("This") AS Score FROM faq
instead of
SELECT ID,MATCH Q,A AGAINST ("This") AS Score FROM faq WHERE MATCH Q,A AGAINST ("This")
The latter will give much better perfo
I suppose that only way to reorganize unique field is to use another table.
- Original Message -
From: Irmund Thum <[EMAIL PROTECTED]>
To: Rus <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, February 13, 2001 8:53 AM
Subject: Re: mysqlimport - LOAD DATA LOCAL INFILE
> Rus sc
Hi Matt,
Think you will find: http://www.scibit.com/MySQL useful
> -Original Message-
> From: Matt Davis [mailto:[EMAIL PROTECTED]]
> Sent: 13 February 2001 14:47
> To: [EMAIL PROTECTED]
> Subject: ASP and MySQL
>
>
> I have MySQL running on a cobalt Raq 3 with linux operating system. I
THANK_YOU!
I was modifying entries for a joiner table without checking to see tif they
were already present!
> Subject: RE: Duplicate entry error??
>
>
> > Hi,
> >
> > You have a unique key defined which includes Ekey and another field (the
> key
> > 2 mentioned in the error message), and the
Didn't Oracle just release a MySQL to Oracle migration kit? Check the
Oracle website.
Cal
http://www.calevans.com
-Original Message-
From: Noor Dawod [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 13, 2001 8:41 AM
To: MySQL List
Subject: Exporting data from MySQL to Oracle
Hello,
Rolf Hopkins wrote:
>
> What you have just described means that database permissions have not been
> set up correctly and your ISP has left himself wide open for all kinds of
> attacks and I'm not just talking about attacks on the database itself but
> also attacks on the whole system. Ie access
Hi:
Check This!
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-ma
Hi:
Check This!
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-ma
Hello!
I think that one feature will be useful:
limits (like UNIX limit feature) on per-thread basis. On public-access site
(for instance, free hosting with mysql) poorly-written SQL can make quite a
load; limiting usage can forcedly kill such requests.
I could not subscribe to developers list
can anyone figure out why the following code works fine when both select
variables = "ALL" and also when only 1 of the 2 ="ALL" but NOT when BOTH
select variables equal something other than "ALL"?
here is the code:
What area of the city would you like to dine in?
\n";
$select.="ALL\n";
w
Hello everyone
Does anyone know why and when occurs the following error :
Cannot load connection class 'java.sql.SQLException
Thanks a lot !
Daniel Ducat
-
Before posting, please check:
http://www.mysql.com/manual.php (th
Hello,
We operate a forums website and use Phorum web application (PHP/MySQL
backend), more info: http://www.phorum.org
After operating for two years now, we are facing a serious problem.
Giving the fact that the forums are full of content, ONE (1) search
operation on a single forum is draining
Or a handy one-liner...
perl -pi -e "s/[\012\015]//" *.sql
On Tue, 13 Feb 2001, Pat Sherrill wrote:
> When ftp'ing the file use the ASCII mode instead of the BINARY mode. All
> CR/LF conversions will take place automagically. Alternatively some linux
> distributions have a utility to strip C
Hello,
I'm having a problem exporting MySQL BLOB's to Oracle, especially those
records that has "Carriage Return" or "Line Feed" characters in them.
Has anyone done this before, and how did they do it? I need an immediate
help in this subject. I'd appreciate you help very much.
Thanks
Noor
-
What you have just described means that database permissions have not been
set up correctly and your ISP has left himself wide open for all kinds of
attacks and I'm not just talking about attacks on the database itself but
also attacks on the whole system. Ie access to unix root. DOS, etc
Read t
At 23:04 12-02-2001 -0800, John W Ford wrote:
>I can't figure out why my windows machine leaves "^M" character at the end
>of each line of code. This causes the file to be messed up when I put it on
>the Linux server.
That's a carriage return. DOS/Windows ends a line with a carriage return
follow
When ftp'ing the file use the ASCII mode instead of the BINARY mode. All
CR/LF conversions will take place automagically. Alternatively some linux
distributions have a utility to strip CR's from ASCII files and there is
always old reliable vi .
I hope this helps...
Pat...
[EMAIL PROTECTED]
---
While the output you've shown could well be considered eroneous, surely
you shouldn't be relying on this sort of logic in a decent piece of code
? Or am I missing something ?
If you're trying to work out which row was inserted most recently,
shouldn't you be using your db handle lastinsert_id pa
Absolutely this is nothing short of bad adminingIbet you could scag in their
passwd file and has root access in short order...;( And of course the ISP will blame
mysql if anything happens to them though...lazy bad ISP
cheers,
mikel
Donald Korth wrote:
> Hello
>
> The hosting company
Problem is that most ISPs can't afford a competent DBA...;(
clay bond wrote:
> On Tue, 13 Feb 2001, Donald Korth wrote:
>
> > The hosting company has given me a user name and passwd . When i log into my own
>site thro' a telnet session i 'm able to view all the databases created in the server
I try to install Mysql-3.23.32 on INTEL/SOLARIS8
the command
./configure --prefix=/usr/local/mysql
returns following error :
checking if gcc supports -c -o file.o... yes
checking if gcc supports -c -o file.lo... yes
checking if gcc supports -fno-rtti -fno-exceptions ... yes
Hi,
> at the mysql prompt i can get the exact time taken to run each query.
> how can i display this time in an HTML page via PHP. is there a function
> which gives me this time
Unfortunately, no, there isn't a built-in function to do this. So, you'll
have to resort to some DIY. But, it's quite
>> [...]. Currently, in MySQL
>> you must call UNLOCK TABLES before issuing another LOCK TABLES, because
>> there is no deadlock detection in MySQL itself.
>I believe a LOCK TABLES does an automatic atomic UNLOCK TABLES of any
>that were locked before if it's able to get the requested locks.
>Ti
Guys,
I know it's off topic but this virus seems to be spreading quite violently,
I've had to remove from one of our clients machines this morning.
If you become infected with it, it's a simple remove procedure.
1. Remove the reference to OnTheFly in the registry, look for the text VBS
and WORM
I have MySQL running on a cobalt Raq 3 with linux operating system. I have
set up MyODBC and I can connect through MS Access I can also connect through
MS Frontpage and created a simple web interface to retrieve some results
from my db however when uploaded I recieve no results when I definatly
sh
Thomas Kaester writes:
> Hello Sinisa and everybody who can help me!
>
> I try to develop a UDF which returns a string! But I get only 256 characters of the
>string! I tried to change my alloc function, so that I only use my_malloc and
>my_free! But the result is the same! The necessary me
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Caching Bug with AUTO_INCREMENT columns
Description:
When i use a table with an AUTO_INCREMENT column and
insert Data in the Table with a NULL Value for the
AUTO_INCREMENT column, AUTO_INCREMENT sets an new value
can you please stop sending attachments through the list?
At 11:24 AM +0100 2/13/01, Irmund Thum wrote:
>Rolf Hopkins schrieb:
>>
>> "^M"??? You sure it is that? Anyway, it is most likely to do with carriage
>> returns. Windows uses CR and LF to indicate a new line, while Linux and
>> Macs
Bob, you may sound like a broken record, but at least it's stuck on a
particularly delightful song that I think everyone should listen to.
If everyone on this list had this book we'd see a 50% reduction in traffic
overnight :-)
Cheers
Jon
-Original Message-
From: Bob Hall [mailto:[EMAI
Hi All
I am going to have replication on mySQL database. I am just starting to
write a script to see if the slave can connect to the master. If not then do
one last check to see if the master is down by trying to connect to it. Then
connect to slave set slave as master. When that is sorted do some
On Tue, 13 Feb 2001, Irmund Thum wrote:
> Rolf Hopkins schrieb:
> >
> > "^M"??? You sure it is that? Anyway, it is most likely to do with carriage
> > returns. Windows uses CR and LF to indicate a new line, while Linux and
> > Macs only use LF. Hopefully this will help. Don't know what yo
>Say I have a bunch of records in a table with a bunch of fields. One of
>those fields is cluster_id. It is not unique. However, I want to make a
>unique set. I want one record for each cluster_id value. I don't care
>which record that is.
>
>Right now, I do:
>SELECT DISTINCT cluster_id FROM my_ta
>Hello,
>at the time I try to figure out what's the best way
>to get a kind of parent/child - hierarchy with unlimited
>subchild.
>My special attention is situated on really fast SELECT statements.
>
>Actually I'm using nested sets like:
>
>CREATE TABLE Personnel
>(emp CHAR(10) PRIMARY KEY,
>salar
>OK, is there an easy way to ADD a value to a set type without having
>to enumerate all that's there already? I've looked through
>http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SET
>
>but it doesn't say anything about adding values to the current set.
>It rather looks l
1 - 100 of 113 matches
Mail list logo
