heh, my ($id) = $dbh-selectrow_array(SELECT MAX(id) FROM tbl;);
xris wrote:
Woops sorry about that last message.
Try using the following:
my $id = $sth-{insertid};
That is what I had to change it to, to get it working.. despite what the
documentation says.
Actually, I can't use
Try
net start mysql
at a command prompt
Hi Team,
Pls help, I'm new to mysql.
I got the latest ver installed on NT2000 workstation. Upon I
tried the activate the daemon, under c:\mysql\bin\mysqld,
it won't work. Any advise.
Thanks Regards
KA
Hello.. Friends
I have just installed my OpenBSD 2.9 with mysql 3.23.37 and when i wanted to
startet i can do it first time, but if i have to restart the server. I
cannot start it again, why?
i come with this error.
w3# safe_mysqld
/usr/libexec/ld.so: my_print_defaults: libpthread.so.14.20:
At 0:36 -0600 2001-06-23, Colin Faber wrote:
heh, my ($id) = $dbh-selectrow_array(SELECT MAX(id) FROM tbl;);
You're in for a VERY nasty surprise as soon as two of these happen to
run in parallel.
Our code uses $sth-{mysql_insertid}. We don't have any 3.22 servers,
though -- they can't do
heh, my ($id) = $dbh-selectrow_array(SELECT MAX(id) FROM tbl;);
You're in for a VERY nasty surprise as soon as two of these happen to
run in parallel.
I agree, you may get another insert before that select occurs and end up
getting the wrong id. You should use SELECT LAST_INSERTID() or
Hello;
Is there some way to create a collumn, where the only possible values are
enumerated in other table? I'm looking for something like this:
ENUM(SELECT xy FROM tab;)
I'm able to do it with perl+CGI. But is there some easier way?
Maybe it's a stupid or already discused question, but I
personally I don't care what select you guys feel the need to call, so
long as the dbi call is correct, rather it doesn't matter though because
selectrow_array() simply calls prepare() execute() any ways.
I'd normally use LAST_INSERT_ID() my self (only if i had to) other wise
find a better way
TEG Batara Kesuma [EMAIL PROTECTED] writes:
Hello,
I think it might not be a right mailing list for this question, but I
don't know where else should I post it.
If I run Perl DBI's $dbh-connect() without $dbh-disconnect(), MySQL (or
is it the Perl DBI module) will run rollback() with
Hi @all,
I'm a newbee at MySQL and tried to install my first MySQL-Database. Everything worked
good until i tried to start the MySQL-Daemon. I typed ./safe_mysqld --log to start
the daemon but i get the message:
Starting the mysql-daemon with database from /usr/local/mysql/var
mysql-daemon
Arnor Sigfusson writes:
Hi
I was trying MySQL on a RedHat 7.0 for the first time using MySQLGUI. But
when I try to connect I get:
Can't connect to local MySQL server through socket '' (111)
Arnor Sigfusson
Arnor Sigfusson Tel:+354 5574488
FutureMedTecMobile:
Hannes Niedner writes:
Hi Folks,
I just started a create table ... select from ...left-join query from my
laptop. It seems to take a while?
What happens if disconnect my client from the mysql daemon running on
another machine. Will the interupted mysqld-client crosstalk abrupt the
query,
D. S. Sandmann writes:
Win running winzip on the mysqlgui download I am receiving errors. I have already
tried downloading it two times and both times I get the following errors:
Errors were detected -- see below for details
Testing ...
testing: mysqlgui-win32-static-1.7.4-2/ OK
Hi!
On Win 9x and ME you should run mysqld-max.exe.
mysqld.exe was in 3.23.38 accidentally compiled with __NT__
defined.
Regards,
Heikki Tuuri
Innobase Oy
Copied message:
LS.This is the text i sent you, the text you have seen was a attachment
C:\mysql\binmysqldInnobase:
Hello.
On Sat, Jun 23, 2001 at 01:01:41AM +0020, [EMAIL PROTECTED] wrote:
I understand that indexes work so fast because they are usually smaller than the
original table, since they contain on average just 1 column, or at least less
information than the complete table. But how about a table
An index is not just putting the data in a separate file. It's about storing
information in more high-tech data structures like B-trees, R-trees and
hashes. MySQL only support B-Trees, which is the most commonly used. B-Trees
are about storing data in a tree-like structure for very fast
Ryan,
what does
EXPLAIN select * from tablename WHERE col1=0 and col2=0 limit 100;
show?
What about
EXPLAIN select * from tablename WHERE col1=0 and col2=0;
Have you run
CHECK TABLE tablename;
You have compiled your own mysqld. I can send you a new
mysql/innobase/row/row0sel.c
which
Hello, does InnoDB fully supports multiple transactions ? ie transactions over several
tables with multiple connexions.
My problem is that I do not get a consistent view of the tables after the inserts or
delete : records are missing, or seem to be still present.
- Original Message -
From: Shane Peacock [EMAIL PROTECTED]
To: Simon K. Chan [EMAIL PROTECTED]
Sent: Saturday, June 23, 2001 6:18 PM
Subject: Re: can't connect to local MySQL-Server
Hi Simon,
Yes, i did all did all the commands recommended for running MySQL:
./configure
As a long time DB2.. Sybase.. Postgresql user upon turning to MySQL
I find only some functionalities not intuitive.
1. What command syntax to use and connect to a database on another
host.
( where I have granted permissions in mysql tables User..Host..and
..DB )
( have been
Trond Eivind Glomsrød wrote:
William Clifford [EMAIL PROTECTED] writes:
Hi all. I recently downloaded the source distribution of MySQL version 3.23.39
and am trying to compile it so that it installs it's files in the same manner
as the binary RPM version does.
Just download the
CK Raju [EMAIL PROTECTED] writes:
Trond Eivind Glomsrød wrote:
William Clifford [EMAIL PROTECTED] writes:
Hi all. I recently downloaded the source distribution of MySQL version 3.23.39
and am trying to compile it so that it installs it's files in the same manner
as the binary RPM
We would need to know what operating system you are using, that would be
helpful in telling you what steps to take to fix it.
Make sure that you put a space and a after that command so that you don't
get your terminal stuck.
As for your problem of starting the darn thing, there are two
Two things you might want to try... first download and install the newest
Msql-Mysql DBD drivers.. check what the documentation says in there.. and
second, keep changing what variable you are trying to access and maybe you
will find one works that isnt documented.
My problem with this is
Daniel Åkerud wrote:
In MySQL having a table that looks like this:
idint primary key
namechar(200)
and making an index on name, will get you a 0.1 * original_retrieval_time
when searching, but 1.5*original_insertion_time when inserting. It roughly
means that (on my system that
They most certainly do depend on the table design and especially on the
system which runs the test.
They are my own figures...
Daniel Åkerud wrote:
In MySQL having a table that looks like this:
idint primary key
namechar(200)
and making an index on name, will get you a 0.1
Hi!
First of all, it is unlikely that you will see some status bar as
operations in RDBMS server are quite complicated and time table can
not be predicted except in some extremely simple cases.
Regarding aborting a client, server operation will continue until OS
on which server runs
Does anyone have any recommendations for a good book on MySQL SQL? What
about PerlDBI (I noticed that the O'Reilly one is over a year old)?
Just realizing that there's so much out there that I haven't been told...
-Chris
-
Hello All,
I'm current working on project, converting a flatfile system, to use MySQL,
which supports transactions w/Innobase tables. My questions is, as I'm sure many
have coded using transaction w/Perl and DBI. I understand that there as some
draw backs to using transactions when not
Sorry, never heard of it. I thouth OpenBSD was just one of those web
development packages that they throw MySQL into. Some of what I said still
applies, except I don't know whether or not you can use RPMs.
--On Saturday, June 23, 2001 21:06 +0100 Tomas Norre [EMAIL PROTECTED]
wrote:
We
I use:
$Gdata{'custid'} = $dbh-{'mysql_insertid'};
on 3.23.38 with perl 5.6.1 and DBI-1.15
Works like a champ!
On Sat, Jun 23, 2001 at 01:07:07PM -0500, xris wrote:
Two things you might want to try... first download and install the newest
Msql-Mysql DBD drivers.. check what the
As a long time DB2.. Sybase.. Postgresql user upon turning to MySQL
I find only some functionalities not intuitive.
1. What command syntax to use and connect to a database on another
host.
You've got to be kidding me, it's exactly the same as Postgresql:
chris@phantasm:~$ mysql --help
...
I have been trying to access www.mysql.com but can not seem to access it.
Does anyone know a mirror site I could go to to download mysql for Windows
2000?
Thank you!
-
Before posting, please check:
http://mysql.ht.net.tw/mirrors.html
- Original Message -
From: The Majestic Moined Mogul [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, June 24, 2001 1:33 PM
Subject: Re: Download of mysql for Windows 2000
I have been trying to access www.mysql.com but can not seem to access
USA: http://mysql.he.net/
UK: http://mysql.omnipotent.net/
I have been trying to access www.mysql.com but can not seem to access it.
Does anyone know a mirror site I could go to to download mysql for Windows
2000?
Thank you!
Mysql by Paul Dubois, New Riders publisher, is strongly recommended.
Get the perldoc on dbi and dbd. terse, but up to date.
other reading are:
cgi programming 101 by jacqueline hamilton. basic information. well
presented. with examples that work. very broad, very shallow.
of course the camel
Hi,
Why cant I get to make this simple statement to work?
I have this perl script that would not resolve properly.
##
my $sth = $DBH-prepare( qq!select start,stop FROM dialup WHERE sessionid =
$sessionid! );
$sth-execute;
my ($start,$stop) = $sth-fetchrow;
##
36 matches
Mail list logo