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 bo
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!
---
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 acc
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://www.mysql.com/manua
> 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 --hel
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 docume
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:
>> W
On Sat, 23 Jun 2001 16:40:04 -0500, Chris Petersen <[EMAIL PROTECTED]> wrote:
Chris,
2 of the best, Paul Dubois's "New Riders MySQL", which covers MySQL, SQL very
well, and Perl w/DBI, and PHP and C. The Perl w/DBI is a bit outdated now tho.
Programming with Perl DBI is an excellent resource
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 necessary,
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
-
Be
>
> 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 serve
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 ge
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
> 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
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;
##
T
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 possi
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
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 downloa
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 successf
- 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:
>
> ./confi
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.
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 w
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 retriev
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 tab
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\bin>mysqldInnobase:
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/
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
> q
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
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 e
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
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 t
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 have
> >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()"
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
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: No
35 matches
Mail list logo
