On Fri, 6 Apr 2001, Kenneth wrote:
> Date: Fri, 6 Apr 2001 10:22:29 +0800
> From: Kenneth <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: rpm with php
>
> Hello All,
>
> I'm trying to install MySQL RPM with php.
> Should I use:
>
> --with-mysql or
>
> --with-mysql=/usr/bin or
>
> -
On Fri, 6 Apr 2001, Vigile wrote:
> Date: Fri, 6 Apr 2001 01:26:05 -0400
> From: Vigile <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: Duplicate of Everything in Table
>
> I have a table, that DOES NOT have a primary key, but is setup like this:
>
> Field Type Attributes Null Defa
On Thu, 5 Apr 2001, Dennis Gearon wrote:
> Date: Thu, 05 Apr 2001 14:24:25 -0700
> From: Dennis Gearon <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: Foreign Keys
>
> Are people using Mysql using foreign keys and how are they using them?
> It seems that the way to use them is with the sc
In a message dated 07/04/2001 05:13:18 GMT Daylight Time,
[EMAIL PROTECTED] writes:
<< This a mail from a new established software company. We are developing a
software using vb6.0 as front-end and want to use MYSQL as back-end. We have
already downloaded it from your site. It was the latest v
Dear Sir,
This a mail from a new established software company. We are developing a software
using vb6.0 as front-end and want to use MYSQL as back-end. We have already downloaded
it from your site. It was the latest version MYSQL 3.23 for win95/98. But now we don't
know how to install it on o
Do you want to double the number of visitors to your homepage everyday? The
perfect solution is PopUp Window Exchange!
It's a brand new concept from LinkExchange. It will pop up websites instead
of traditional banners. As a result, it can bring you REAL web traffic
instea
On 6 Apr 2001, at 15:03, Kristopher Briscoe wrote:
> Does anyone know of a good list(s) relating to PERL and MySQL? Also,
> any good repositories of example code?
As you are using the DBI you should be on the DBI list:
http://lists.perl.org/showlist.cgi?name=dbi-users
but you might be interes
Hello All,
Just to add some additional info to our problem. If I do a simple query:
select * from bus_search where match(title,keywords) against('Best Car Deals')
I get nothing! and its there! Is it possible the table is not set up properly??
Or I'm I wishing something here??
Table Info:
CRE
I'm trying to set up a database system for the first time. I installed
mysql-3.23.32-1.7.i386.rpm
on my RedHat Linux version 7.0, but it doesn't seem to have set up correctly. Is
anyone familiar
with how to proceed from the point of installing this RPM to getting the server
configured and the
Gerald -
My rpm was hosed. I downloaded from a rh ftp site and got it installed.
Now back to installing zlib - see command below:
/linuxrpms>rpm -ivh zlib-1.1.3-6.i386.rpm
failed dependencies:
/sbin/ldconfig is needed by zlib-1.1.3-6
I'm not having any luck figuring this out...
Agai
I posted a question regarding a search query we are trying to get to work, and
was hoping someone can tell why this query doesn't work. It should return
results as all the search criteria is there in the tables( for test purposes)
QUERY:
SELECT bi.bus_name,bi.address,bl.city,bl.state,
bl.zipcode,
I'm trying to write a simple windows client to monitor my MySQL server. I'm
using ADO and I can connect to the server fine from a remote host and issue
queries using the ADO connection object like:
set rs = conn.execute ("show databases")
conn.execute("use " & strDBName )
set rs = co
On Sat, Apr 07, 2001 at 02:14:42AM +0300, Michael Widenius wrote:
>
> The reason singly queries are slower are of course that the
> initialization phase (reading the data from a socket, parsing,
> locking, checking which keys to use) is about half of the query time.
>
> Peter> Heikki made test
Hi!
>
> mysql> SELECT *,MATCH a,b AGAINST ('collections support') as x FROM t;
> +--++--+
> | a| b | x|
> +--++
When doing a backup of tables using BACKUP TABLE blabla TO '/tmp';
the permissions are RW for root (both user and group).
But since I only have 'root' access to the mysql-server and not the machine its
running on I cant really use the backup to anything.
I was going to make a script that could a
On Fri, Apr 06, 2001 at 03:03:40PM -0700, Kristopher Briscoe wrote:
> Does anyone know of a good list(s) relating to PERL and MySQL? Also, any
> good repositories of example code?
>
> Thanks,
> Kris-
I dunno if it's _good_ or not, but it's a repository:
http://www.kitebird.com/mysql-perl/
--
I'm Trying to install the Binary Installation of Mysql 3.23.36
on HPUX 10.2. I receive the following
error when I run the
"scripts/mysql_install_db" Command.
Warning: setrlimit couldn't increase number of open files to more
than 60 .
Warning: Changed limits: max_connections 50 table_cached:64
Does anyone know of a good list(s) relating to PERL and MySQL? Also, any
good repositories of example code?
Thanks,
Kris-
_
Get your FREE download of MSN Explorer at http://explorer.msn.com
---
I'm very new to mysql. I wonder how good is mysql, and comparing it to
MS Access. I know mysql is supposed to be way faster than Access,
however, to my surprise, it's not necessary the case.
I have a table with 700K records. I issued these 2 queries:
Access:
select top 30 * from rawdata
mysq
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
>From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [Can't run Mysql on HPUX 10.2 have CC Compiler, Debug report]
>Description:
Hi!
> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:
Peter> Hello mysql,
Peter> I made one more test of mysql perfomance.
Peter> PIII-700/768Mb/Linux 2.4.2 glbc 2.1.3
Peter> I had the followings table with 12.000.000 rows (well I checked
Peter> this with 1 rows as w
Since MySQL does not have a scripting language, you will have to use
something else.
You could use bourne shell scripts with variable substitution for batch
processes.
You could write scripts in perl, PHP, or python.
They all support variables and parameters.
Sandy Lewis wrote:
>
> I'm hoping
On Fri, Apr 06, 2001 at 07:26:14PM +0300, Heikki Tuuri wrote:
> Hi!
>
> The MySQL manual says that INSERT DELAYED only works for MyISAM
> and ISAM tables, but the parser does not check that the table type
> is correct. We have to block this in the parser.
>
> If you use it on Innobase tables, th
Hi!
I've run into a problem with a replication setup.
I have a 4 CPU EV5.6 AS4100 running a master database.
MySQL is 3.23.36, OS is Tru64 4.0F patchkit 4.
MySQL is compiled with Compaq CC & C++ with the recommended compiler options
mentioned in INSTALL-SOURCE.
This master database runs without
"lkeeton" <[EMAIL PROTECTED]> wrote:
> from here is where i need a solution that gets me the difference of these
two
> times in a decimal format. Of course once I get that I may need to convert
> back in english to say there are 30 minutes and 44 seconds.
You didn't state whether you're using a w
Steve Werby wrote:
>
> "lkeeton" <[EMAIL PROTECTED]> wrote:
> > I need a way in sql or simple programming to take a timpestamp(end time)
> and a
> > timestamp(beginning time)
> >
> > for instance 12:00:00 is the end time
> > 11:30:44 is the start time
>
set @start = curtime();
SEL
I'm hoping someone can answer my question. I'm trying to pass variables
into
my sql script using mySQL and I can't seem to find how to do this.
What I'm looking for is the mySQL eqivalent to ORACLE's
myscript.sql date time
where in the myscript.sql date and time are set as &1 and &2
Can th
Hello All -
Help Help Help! I am having problems installing
Msql-Mysql-modules-1.2215.tar.gz and have been struggling with this for
days. Arghh! I am running Red Hat Linux 7.0, Perl 5.6.0, and MySQL
3.23.32. I read about an issue similar to mine in
http://lists.omnipotent.net/mysql/200012/msg0
I like to work with times as follows:
if
1 second = 1 / 86400 or 0.12
then
12 hours = 0.5
24 hours = 1.0
36 hours = 1.5
48 hours and 1 second = 2.12
and so on.
Regards,
Doug
> -Original Message-
> From: lkeeton [mailto:[EMAIL PROTECTE
I am working on a project that needs to get
This particular format 1000.25
1000 representing hours and 25 represent minutes
1000 means a full 1000 minutes
.25 means a quarter of an hour
so essentially in english language we could say a thousand hours and about 15
minutes
I need a way in sql
"lkeeton" <[EMAIL PROTECTED]> wrote:
> I need a way in sql or simple programming to take a timpestamp(end time)
and a
> timestamp(beginning time)
>
> for instance 12:00:00 is the end time
> 11:30:44 is the start time
See the TIME_TO_SEC() function. The rest is straightforward.
--
S
"Khan, Moin" <[EMAIL PROTECTED]> wrote:
> Please tell me the web archive of this mailing list , so i not bother you
> for some already answered questions.
Well, you can use the URL listed at the bottom of every email sent to this
list (the 2nd URL below):
> ---
lists.mysql.com
It is printed at the bottom of every message posted to list.
On 4/6/01 10:54 AM, "Khan, Moin" <[EMAIL PROTECTED]> wrote:
> Please tell me the web archive of this mailing list , so i not bother you
> for some already answered questions.
>
> Thanks,
> Moin
>
>
Yes, but in his case there is a full duplicate of every row for every column, so just
specifying one of the columns will do the job.
regards,
thalis
On Fri, 6 Apr 2001, Gerald Clark wrote:
> You need to specify those columns that need to form a unique
> combination,
>
>
> "Thalis A. Kalfigop
sorry for this message i find out the location :)) (its in the signature of
every message )
thanks anyway,
-Original Message-
From: Khan, Moin [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 06, 2001 10:54 AM
To: 'MySQL-list'
Subject: Mysql List Web Archive ?
Please tell me the web arch
I am working on a project that needs to get
This particular format 1000.25
1000 representing hours and 25 represent minutes
1000 means a full 1000 minutes
.25 means a quarter of an hour
so essentially in english language we could say a thousand hours and about 15
minutes
I need a way in sql
>Description:
The included log
>How-To-Repeat:
>Fix:
>Submitter-Id: Devan Goodwin
>Originator: Devan Goodwin
>Organization:
National Research Council Canada
>MySQL support: none
>Synopsis: Problems with MySQL full text search
>Severity: serious
>Priority:
Hi,
http://tlowery.hypermart.net/perl_dbi_dbd_faq.html
This contains the info on how to setup the dbi proxy solution.
I tried the sybase method today, but had no luck (all the
test-* scripts just core, v annoying). Ive also come to the
conclusion that the entire odbc thing should just be
You need to specify those columns that need to form a unique
combination,
"Thalis A. Kalfigopoulos" wrote:
>
> Actually you don't have to specify all columns in the UNIQUE index. Just one of
>them, and the entire row will be dropped for all redundant copies.
>
> So just do:
> ALTER IGNORE TAB
Please tell me the web archive of this mailing list , so i not bother you
for some already answered questions.
Thanks,
Moin
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.
I had problems with the DBD as well...the problem was the mysql version
I was using from my redhat cd had some bugs. I would grab the latest
version and re-install mysql, at least this way you know it's not a
version problem
e
-Original Message-
From: Chris Becker [mailto:[EMAIL P
Actually you don't have to specify all columns in the UNIQUE index. Just one of them,
and the entire row will be dropped for all redundant copies.
So just do:
ALTER IGNORE TABLE lala ADD UNIQUE (PageID);
I didn't remember the IGNORE thing. Nice idea...
regards,
thalis
On Fri, 6 Apr 2001, Gera
> "PD" == Paul DuBois <[EMAIL PROTECTED]> writes:
PD> But why does it matter? MySQL will convert the strings to numbers
PD> anyway.
But according to earlier threads here, it will mess up with BIGINTs
Also it may screw up with LIMIT:
$sth = $dbh->prepare("SELECT foo FROM bar LIMIT ?,?") or
Good Day All,
I seem to be stuck in a fog. I know the answer is probably easy
Let's say I have a query:
SELECT * FROM myTable;
and it's stored in a file:
getData
Then I can do something like this...
% mysql -A -uuserID -ppassword databaseName < getData
and I'll see output. That's fine
B
source getData
"Oson, Chris M." wrote:
>
> Good Day All,
>
> I seem to be stuck in a fog. I know the answer is probably easy
>
> Let's say I have a query:
>
> SELECT * FROM myTable;
>
> and it's stored in a file:
>
> getData
>
> Then I can do something like this...
>
> % mysql -A -uuserI
Looks like you may have trashed rpmrc.
Does it exist?
If not, you have a problem. Check with Red Hat.
Chris Becker wrote:
>
> yes.
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Gerald Clark
> Sent: Friday, April 06, 2001 5:59 AM
> To: Chris B
yes.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Gerald Clark
Sent: Friday, April 06, 2001 5:59 AM
To: Chris Becker
Cc: [EMAIL PROTECTED]
Subject: Re: Perl - DBD:DBI Errors
You are logged in as root, are you not?
Chris Becker wrote:
>
> Gerald,
>
>
On Fri, 6 Apr 2001, Tim Bunce wrote:
> Date: Fri, 6 Apr 2001 17:25:27 +0100
> From: Tim Bunce <[EMAIL PROTECTED]>
> To: "William R. Mussatto" <[EMAIL PROTECTED]>
> Cc: Tim Bunce <[EMAIL PROTECTED]>,
> Heikki Tuuri <[EMAIL PROTECTED]>, [EMAIL PROTECTED],
> [EMAIL PROTECTED]
> Subject: Re:
I've gone through the mailing list archives on the subject of persistent
connections, trying to figure out how to end the threads that mysqld
creates, once I'm done.
How would I set a program to have NON-persistent connections?
I was planning to get the thread id, and use mysql_kill in the follo
It should work fine as printed...but you'll need mysql 3.23.xx
On Fri, 6
Apr 2001, Temeschinko, Michael wrote:
>
> hi,
>
> I need to make a select like above in the subject count distinct (I need the
> count of the different values of a coloumn)
>
> Hope you guys won't let me die silly!
> :-)
Hi!
The MySQL manual says that INSERT DELAYED only works for MyISAM
and ISAM tables, but the parser does not check that the table type
is correct. We have to block this in the parser.
If you use it on Innobase tables, that can cause severe database
corruption!
Regards,
Heikki Tuuri
Innobase Oy
>when i try to run phpmyadmin i got an error message and the log from mysql
>says:
>ERROR 2002: Can't connect to local MySQL server through socket
>'/var/lib/mysql/mysql.sock' (111)
AAARG if you would have taken the time to check the archive you would
have know it has to do with the locatio
On Fri, Apr 06, 2001 at 10:16:46AM -0400, Johnson, Gregert wrote:
> What would really help would be to use multiple row inserts, i.e.
>
> INSERT INTO speed1 VALUES (a,b,c),(d,e,f),(g,h,I),...
>
> So, prepare a series of inserts, each with a few hundred (or even thousand) row
>value sets.
Hi!
The MySQL manual says that INSERT DELAYED only works for MyISAM
and ISAM tables, but the parser does not check that the table type
is correct. We have to block this in the parser.
If you use it on Innobase tables, that can cause several database
corruption!
Regards,
Heikki Tuuri
Innobase O
On Fri, Apr 06, 2001 at 08:41:32AM -0700, William R. Mussatto wrote:
> How do you get it not to try an quote numbers? I realize this should be
> obvious, but I can't find an exampl in the msql/mysql book.
It's magic. Or specifically it relies on Perl's internal magic.
Plus, of course, it wouldn
On Fri, Apr 06, 2001 at 08:41:32AM -0700, William R. Mussatto wrote:
> How do you get it not to try an quote numbers? I realize this should be
> obvious, but I can't find an exampl in the msql/mysql book.
Wrong book. Tim's book says how to do this on p. 124. :-)
But why does it matter? MySQL
On Fri, Apr 06, 2001 at 04:48:52PM +0100, David Thomas wrote:
> I am quite a newbie on using MySQL so any help would be appreciated.
>
> I have managed to install MySQL smoothly (or so I thought) and the mysqld
> starts without any problems. However, on trying to use the
> mysql_setpermission scr
hi,
I need to make a select like above in the subject count distinct (I need the
count of the different values of a coloumn)
Hope you guys won't let me die silly!
:-)
greetings from germany
Micha
--
A train station is a station where a train stops
But what the hell is a workstation?
i recommend dbtools 1.0.8 for windows
available for download on mysql download pages.
- Original Message -
From: Spirit <[EMAIL PROTECTED]>
To: Kevin Xin Lin <[EMAIL PROTECTED]>
Cc: mysql <[EMAIL PROTECTED]>
Sent: Friday, April 06, 2001 9:01 AM
Subject: Re: free admin/client gui for win
Hi
1, I got packages from mysql site (3.23.33).
2, The mysqlGUI is 100% statical.
3, It crashes after I try to create database and then going to admin
panel.
4, I've found something that I've not seen. It end crashes with segfoult.
Malmo
Hi
I think this relates to mysql++. If so VC++ is not fully ANSI compliant
therefore it will not compile with VC++ nor will apps that use the libs
At 16:30 06/04/2001 +0100, Peter Skipworth wrote:
>Nicholas,
>
>Is this anything to do with mysql ?
>
>P
>
>On Fri, 6 Apr 2001
>[EMAIL PROTECTED] wro
System: BSDI BSD/OS 4.0
I downloaded he source code from www.mysql.com version 3.23.36, when i tried to run
./configure --prefix=/usr/local i got the error below:
checking size of char... 0
configure: error: No size for char type.
A likely cause for this could be that there isn't any
static libr
I am quite a newbie on using MySQL so any help would be appreciated.
I have managed to install MySQL smoothly (or so I thought) and the mysqld
starts without any problems. However, on trying to use the
mysql_setpermission script I get errors of:
Cant locate DBI.pm in @inc <@inc contains: /usr/lib
>Description:
I have BSDI BSD/OS 4.0 system and i got mysql 3.23.36 source code. when i
tried to run ./configure --prefix=/usr/local i got "No size for char type"
>How-To-Repeat:
just run ./configure --prefix-/usr/local
>Fix:
I dont know
>Submitter-Id: Mirian
>Originato
when i try to run phpmyadmin i got an error message and the log from mysql
says:
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)
any idéa?
i'm a total newbie :o)
--
D.
-
Befor
How do you get it not to try an quote numbers? I realize this should be
obvious, but I can't find an exampl in the msql/mysql book.
On Fri, 6 Apr 2001, Tim Bunce wrote:
> Date: Fri, 6 Apr 2001 11:00:57 +0100
> From: Tim Bunce <[EMAIL PROTECTED]>
> To: Heikki Tuuri <[EMAIL PROTECTED]>
> Cc: [EM
Nicholas,
Is this anything to do with mysql ?
P
On Fri, 6 Apr 2001
[EMAIL PROTECTED] wrote:
>
> Hi,
>
> I am getting an error
>
> c:\development\microsoft visual studio\vc98\include\excpt.h(37) : error
> C2146: syntax error : missing ';' before identifier '_STDAFX_H'
> c:\development\micr
Hi,
I am getting an error
c:\development\microsoft visual studio\vc98\include\excpt.h(37) : error
C2146: syntax error : missing ';' before identifier '_STDAFX_H'
c:\development\microsoft visual studio\vc98\include\excpt.h(37) : error
C2501: 'ifndef' : missing storage-class or type specifiers
c
On Fri, Apr 06, 2001 at 06:51:39AM -0700, Martin Hubert wrote:
> But does that really change anything on the database server side ?
> In other words is MySQL doing anything with respect to using prepared
> statements ?
No. (Sadly MySQL doesn't support prepared statements. Pity.)
But if you're me
What would really help would be to use multiple row inserts, i.e.
INSERT INTO speed1 VALUES (a,b,c),(d,e,f),(g,h,I),...
So, prepare a series of inserts, each with a few hundred (or even thousand) row value
sets.
--Greg Johnson
-Original Message-
>Description:
I have launched mysql_install_db and I had an error, grant tables failed, I
have a core in
my /usr/local/mysql/var/ dir and in my hostname.err I have only :
010406 16:35:33 mysqld started
010406 16:35:33 mysqld ended
You can see that my deamon start and
Are you checking the manual and following along, or just plugging in my
hints?
You have to specify a length for the text fields.
Your total key length must be less than 256 if I remember correctly.
Choose values that are long enough to be unique.
EX:
ALTER IGNORE TABLE Pages ADD UNIQUE ( PageID,
That gave me:
SQL-query:
ALTER IGNORE TABLE Pages ADD UNIQUE ( PageID, ArticleID, PageTitle, Text
)
MySQL said: BLOB column 'PageTitle' used in key specification without a key
length
I guess because PageTitle and Text are [text] fields I can't do that.
Ryan Shrout
Production Manager
Athlonmb.c
Honza Pazdziora writes:
> On Fri, Apr 06, 2001 at 04:52:21PM +0300, Sinisa Milivojevic wrote:
> >
> > To solve the above you have also to malloc a pointer in _init function
> > and free it in _end function.
>
> Great, works like a charm. Just to make sure: is it OK to use
> my_malloc to a
On Fri, Apr 06, 2001 at 04:52:21PM +0300, Sinisa Milivojevic wrote:
>
> To solve the above you have also to malloc a pointer in _init function
> and free it in _end function.
Great, works like a charm. Just to make sure: is it OK to use
my_malloc to allocate and free to free, or should I use som
Sorry:
ALTER IGNORE TABLE Pages ADD UNIQUE ( PageID, ArticleID, PageTitle, Text
)
Vigile wrote:
>
> That syntax didn't work for me:
>
> SQL-query:
>
> ALTER IGNORE Pages ADD UNIQUE ( PageID, ArticleID, PageTitle, Text )
> MySQL said: You have an error in your SQL syntax near 'Pages ADD UNIQUE
But does that really change anything on the database server side ?
In other words is MySQL doing anything with respect to using prepared
statements ?
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 06, 2001 3:01 AM
To: Heikki Tuuri
Cc: [EMAIL PROTECTED];
That syntax didn't work for me:
SQL-query:
ALTER IGNORE Pages ADD UNIQUE ( PageID, ArticleID, PageTitle, Text )
MySQL said: You have an error in your SQL syntax near 'Pages ADD UNIQUE (
PageID, ArticleID, PageTitle, Text )' at line 1
Ryan Shrout
Production Manager
Athlonmb.com
http://www.athl
[EMAIL PROTECTED] writes:
> >Description:
>
> UDF working with strings longer than (I believe) 255 bytes kills
> the server. Even if the initid->max_length is set to the length of
> the string that will be returned, as the manual suggests.
>
> Please not that in this case, no additional m
It is in the Problems and Common Errors section of the manual.
Petio Tonev wrote:
>
> Hi,
>
> I have problem with left join on two table.
> Version on MySQL is 3.22.25 and it started under linux.
>
> The table is:
>
> tb_a:
> id (int)
> name_sid (int)
>
> tb_b:
> id (int)
> type_id (int)
>
[EMAIL PROTECTED] writes:
> Hello Sir ,
> I have RedHat Linux7.0 . I install MySql-3.23.36 . By using C++ I am trying to
>coonect to database . I use C++ wrapper classes for the same which in build uses the
>Mysql++ API.I can compile and also link the programe.
> And when I run th
Do an:
alter ignore table add unique ( firstcol, nextcol, ... lastcol )
This will create a unique index on all fields, and delete the
duplicates.
You might want to leave this index there to avoid this problem in the
future.
Vigile wrote:
>
> > You're right. Is there anyway around this hassle
Old Style ISAM type files are NOT archecture independent.
"Thalis A. Kalfigopoulos" wrote:
>
> On Thu, 5 Apr 2001, Gerald Clark wrote:
>
> > Another thought.
> > These are isam tables, not myisam tables.
> > Unless the two machines are the same hardware type and operating system,
> > you
> > ca
Dear Y'all -
Joshua Chamas writes:
> I believe that perl's DBD::Sybase can be used to connect to
> MS SQL server. I've never done it myself mind you, but heard
> it to be true.
Vivek Khera writes:
> Except that perl/DBI requires an underlying C library for the DBMS in
> question. I un
On 06.04.2001 11:46:53 vblkuer wrote:
> Rückmeldung bitte an
> [EMAIL PROTECTED]
Nein, hier gefragt - hier die Antwort!! Zumal so eine Antwort bestimmt auch
andere interessiert - mich zum Beispiel!
-
Before posting, please
>Description:
when installing the MySQL Binary Distribution
the script scripts/mysql_install_db produced the following output:
scripts/mysql_install_db
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Install
You are logged in as root, are you not?
Chris Becker wrote:
>
> Gerald,
>
> I grabbed the correct rpm for zlib under RedHat/RPMS - but I still get the
> error message:
> >rpm -ivh zlib-1.1.3-6.rpm
> Unable to open /usr/lib/rpm/rpmrc for reading: No such file or directory.
>
> I'm logged in a
Dear Y'all -
Gary Huntress writes:
> I've looked around at basic security sites (sans.org, whitehats.com)
This is slightly off topic but another security site I'm finding
useful is http://icat.nist.gov/icat.cfm.
Yours - Billy
--
Vivek Khera wrote:
>
> > "GC" == Gerald Clark <[EMAIL PROTECTED]> writes:
>
> GC> Perl/DBI, or any mysql client on Linux should connect to mysql on NT
> GC> with no problem. Why would you need ODBC?
>
> Except that perl/DBI requires an underlying C library for the DBMS in
> question. I un
Thanks for your answers,
Sorry for not being clearly...i mean like select into temporary/select into another
temp/select the result from these in just one "sql-string". I tried separating with
both ; and \n but it complains about syntax error near this. I thought that doing 5+
or something sep
I have installed MySQL for win95 in d:\mysql on my Intel Pentium-S,24MB RAM PC.
On running Winmysqladmin.exe utility I get "ACCESS VIOLATION AT ADDRESS 004026C1 IN
MODULE WINMYSQLADMIN.EXE READ OF ADDRESS ."
I tried fiddling with d:\w95\my.ini file and tried reducing the memory parameters
Tomas Eriksson writes:
> Hi.
>
> I guess we all are waiting for subselects in Mysql...but can you do many
> sql-commands in a single execution, with a nice finally-result-select at
> the end? Many roundtrips feels bad...
>
> kind regards
> Tomas
I truly do not understand what feature
Richard Ellerbrock writes:
> Are the Mysql supplied statically linked binaries built using these optimised glibc
>2.2 libraries, or are they just the stock standard 2.1.3 libraries?
>
> --
> Richard Ellerbrock
> [EMAIL PROTECTED]
Hi!
Our binaries are based on our patched glibc and not
Heikki Tuuri writes:
> Hi!
>
> I tried a test similar to Peter. There is a table with 3 integer
> columns. There is a primary key on the first column and a non-unique
> key on the second column. I wrote a Perl program which inserts rows
> one at a time, and also selects rows one at a time.
>Description:
UDF working with strings longer than (I believe) 255 bytes kills
the server. Even if the initid->max_length is set to the length of
the string that will be returned, as the manual suggests.
Please not that in this case, no additional memory is needed -- the
function just copies the
>please : give me the solution!
Just a few thoughts.. you connect via PHP.. your php.ini is not pointing to
the right location mysql.sock would normally live in /tmp Normally..
other location could be..
Do a ps -ax and see if mysqld shows up.. If not, it's not running at all..
otherw
HN> How can I set a datasource name (DSN) for a database in MySQL?
Get MyODBC for the platform where you want the DSN available, then
enter the MySQL server & database details for a "machine DSN" using
your ODBC administration facilities on the platform where you want the
DSN to be available.
Ho
On Thu, Apr 05, 2001 at 07:50:24PM +0300, Heikki Tuuri wrote:
>
> for ($j = 0; $j < 10; $j = $j + 1) {
>
>$dbh->do("insert into speed1 values ($j, $j, $j)");
> }
That would run faster if you do a prepare with placeholders outside
the loop and then just use $sth->execute($j, $j, $j)
Agreed - I'd love to be able to turn it on/off on demand.
regards,
P
On Fri, 6 Apr
2001, Tim Bunce wrote:
> On Fri, Apr 06, 2001 at 12:13:22AM -0400, Thalis A. Kalfigopoulos wrote:
> > On Thu, 5 Apr 2001, Roel Vanhout wrote:
> >
> > > Hi all,
> > >
> > > Is there a way to turn the query logg
On Fri, Apr 06, 2001 at 12:13:22AM -0400, Thalis A. Kalfigopoulos wrote:
> On Thu, 5 Apr 2001, Roel Vanhout wrote:
>
> > Hi all,
> >
> > Is there a way to turn the query logging on and off while the database
> > server is running? Right now I have a script that stops and restarts the
> > databas
1 - 100 of 112 matches
Mail list logo
