it wuld be nice if mysql supported sub queries
ie.
select A.MESSAGEID from MESSAGEDATA as A where A.MESSAGEID
in (select B.MESSAGEID from MESSAGES as B where
B.SUBJECT='Invitation to join the hanky panky group')
_
Do You Yahoo!?
Get you
You're new to computers and MySQL, aren't you?
Please do something to stop them. I hope you aren't going to let them
continue this.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://
Dear Sir or Madam,
I am currently trying to connect an Oracle 8.1.7 database running on
Windows NT 4.0 to a MySQL database running on Linux (not sure of the MySQL
or Linux versions). When I try to select from a table I am getting the
following error...
ORA-28500: connection from ORACLE t
Dear MySQL,
Hi, My Name is Eric Martin. I would like to tell you that you are
supporting a web site that is trying to hack other servers. This web site
consists of hackers. They openly admit to cheating and hacking servers. I
don't know how you all would allow this to happen. I Believe th
(The following was done in mysql_4.0 alpha)
I am having difficulties with entering binary data from a c program.
I have passed the string through mysql_real_escape_string.
What I am seeing is that if the binary data contains an ascii 0, then
mysql_real_escape_string, correctly, translates it t
on WinNT I am trying to do a datadump using mysqldump
c:\mysql\data\ --user= -p and I get back error 1045 Access denied
using ODBC@localhost password=NO. What is the dump syntax? where is the
odbc bit getting in - it is nowhere in the field data - what gives?
Peter Richards
checkout MSP
Hi
I am retrieving data from a mysql table and displaying the contents in a
text box for editing.
Some of the data contains double quotes eg '15" screen'. Using php4 the data
is backslashed and stores without any problem, but when it is displayed in
the text box it stops at the ", because that c
Robert,
>-Original Message-
>From: Robert Sundstrvm [mailto:[EMAIL PROTECTED]]
>Sent: quinta-feira, 13 de Dezembro de 2001 11:55To: [EMAIL PROTECTED]
>Subject: RE: MySQL v.s. Oracle
>At 04:23 2001-12-02 , you wrote:
>>Not sure that total users is a good metric; queries per second may be>b
Would YOU like £10,000/month for life?
For a limited period we're offering the
opportunity of a lifetime.
Make "tens of £1000's" without selling,
experience, administration, stock, investment
or having to answer the phone EVER again.
Take advantage, get involved with the $35
JK: What I really want it to return however, is an array of hashes. According
JK: to the Perl DBI API, this method does exactly that if you pass it a hash
JK: slice reference argument. Can anyone provide some sample code for doing
JK: this?
my $rows = $dbh->selectall_hashref("S
Hi all,
I want to retrieve multiple rows from a table in one shot. I can find
plenty of documentation on how to do this with the fetchall_arrayref()
method where it returns an array of arrays.
What I really want it to return however, is an array of hashes. According
to the Perl DBI API, this m
Hi,
It should be really soon, Monty wrote me today he was building a
distribution with the current 4.0.1 code...
Best Regards,
Jocelyn Fournier
Presence-PC
- Original Message -
From: "Franklin Schmidt" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, December 14, 2001 1:41 AM
Does anyone know when 4.0.1 will be released?
dear mail filter, use SQL to QUERY DATABASE TABLEs
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the li
Hi,
We have just started out using Innodb tables to get maximum performance
when we have a large number of users fairly simultaneously accessing
some of our large tables. Row-locking is a good thing for us. That's why
we like Innodb. But... there's a problem. One of our tables contains a
uniq
If you have PHP installed, you could simply download PHPMyAdmin.
Otherwise, visit mysql contributed software section and choose the
admin tools of your choice.
Thanks
ST Ooi
Malaysia
- Original Message -
From: "j.urban" <[EMAIL PROTECTED]>
To: "Alex Shi" <[EMAIL PROTECTED]>
Cc: <[EMAIL
At 11:14 AM +1300 12/14/01, Alan Shum wrote:
>Hi
>
>Does mysql work on WIN NT servers? The technician from our web site
>provider told me that mysql is a linux product and will only work on linux
>servers. Is that true?
>
>At the moment I'm using a personal web server on Windows 2000 and I can w
When working with normal connections i.e. non-persistent months ago, using
what must've been PHP 4.0.1 or .2, I had some similar experiences.
In a number of my more lengthy scripts I was seeing MySQL connections
closing on me before the script was done executing. Thus PHP would spit out
errors a
On Fri, 2001-12-14 at 00:29, Fournier Jocelyn [Presence-PC] wrote:
> Yes, If you have a submit button or if you reload the page, the link is
> closed, excepted if you are using mysql_pconnect. (be aware of the timeout
> with mysql_pconnect - wait_timeout parameter in the my.cnf file - )
>
> Jocel
Yes, If you have a submit button or if you reload the page, the link is
closed, excepted if you are using mysql_pconnect. (be aware of the timeout
with mysql_pconnect - wait_timeout parameter in the my.cnf file - )
Jocelyn
- Original Message -
From: "markus|lervik" <[EMAIL PROTECTED]>
To
On Thu, 2001-12-13 at 23:56, Fournier Jocelyn [Presence-PC] wrote:
> Hi,
>
> You absolutely don't have to reconnect to the database each time a PHP-block
> ends ! (it would be completely awfull !!).
> Don't you forget to specify the mysql link in you 'mysql_query' ??
Nope, I always specify the
Hi
Does mysql work on WIN NT servers? The technician from our web site
provider told me that mysql is a linux product and will only work on linux
servers. Is that true?
At the moment I'm using a personal web server on Windows 2000 and I can work
with the mysql database with no trouble... this
Hi all,
I've just changed over to Linux instead of running on windows and I'm
looking for the configuration file so I can change the default location of
the databases and I can't find the file. Can anyone tell me where it is
please?
The installation was a straight install from the rpms.
TIA
Al
Hi,
You absolutely don't have to reconnect to the database each time a PHP-block
ends ! (it would be completely awfull !!).
Don't you forget to specify the mysql link in you 'mysql_query' ??
Regards,
Jocelyn Fournier
Presence-PC
- Original Message -
From: "markus|lervik" <[EMAIL PROTECT
database,sql,query and table. there. now we ought to have gotten
by the spam-filter.
Hello all,
What's wrong with the list? Am I the only one getting lots and lots
of dupes? And no, I don't mean messages sent to me and CCd to the list
;) A bit annoying getting 100+ messages/day where perhaps 10
You might want to have a look at a client like urSQL
(http://www.urbanresearch.com/ursql)...
> At 14:51 13/12/2001 -0500, Alex Shi wrote:
>
> >Hello,
> >
> >I installed MySQL 3.23.46 on Windows2000. The mysql-nt started
> >on Windows startup, and MysqlAdmin is also running well. I tried to
> >cr
It must be a joke. I program in PHP day in and day out - PHP and MySQL
literally make up about 80% of my day, and I KNOW that PHP does NOT drop the
MySQL connection at the end of every PHP block, unless you specifically tell
it to close the connection each time. Instead, it normally will shut down
At 15:23 13/12/2001 -0500, Alex Shi wrote:
>Okay, I will try MySQL GUI later
>BTW, do I have to use ODBC if I use PHP? I'm told PHP has its
>own very API for MySQL...
No you don't need. I only mentioned it for you know other
client option.
Regards,
Miguel
>Alex
>
>
>- Original Message -
>Description:
>From the MySQL on-line manual (Section 7.22):
REPLACE works exactly like INSERT, except that if an old record in the table
has the same value as a new record on a unique index, the old record is
deleted before the new record is inserted.
>From the MySQL on-line manual (F.2.3 Ch
At 15:50 13/12/2001 -0500, Etienne Marcotte wrote:
>I never used any kind of ODBC and can connect to mySQL with the
>mysql.exe from c:/mysql/bin/
>also with perl/apache locally installed I can make perl script to play
>intop the DB without even thinking about ODBC
Good. However is useful for a ne
I wouldn't recommend this because the binary log
can get very large and have a lot of data being
put into it.
However, if you absolutly need this, you could
simply setup a NetFS share across the network
and mount the share on the MySQL server then store
the bin.log on that mount.
---
I would simply make one connection to the db at the
top of your script befor your first DB call:
...output some php stuffs...
...output some more php stuffs...
//You really don't need the mysql_close(), but it is
//good practice, I suppose.
//Your ISP shouldn't close the mysql connectio
Hi Markus,
I've only seen the last couple messages from this thread, but to my
knowledge PHP doesn't close the MySQL connection at the end of each block.
It will close the connection automatically once the entire PHP script has
finished processing, though, if you haven't.
I prefer not to interm
Hi.
use mysql_pconnect.
the manual page has a ton of info on using it to avoid the problem you're
describing.
http://ca.php.net/manual/en/function.mysql-pconnect.php
hth.
-ravi
-Original Message-
From: markus|lervik [mailto:[EMAIL PROTECTED]]
Sent: December 13, 2001 3:30 PM
To: [EMAIL PR
> If running mod_perl does this stay true???
>
> Isn't mod_perl using an already opened connection to do subsequent
> manipulations?
>
Well, I assume you're not going to call last_insert_id()
unless you have just inserted something into a table,
thus updating the value for that particular conne
what??
that is a joke?
I mean disconnectiong at every single little block ending?
I just can't beleive it, probably you can put that in an inc file for
connection, call the connect at the beginning of the script, and call
disconnection at the end.
It's impossible that you have to reconnect eac
I don't think theres a MySQL function to return the number of times a phrase
appears inside a field.
Another way you could achieve the same goal:
SELECT field FROM table WHERE field LIKE '%word%word%word%'
^-- would match on three occurences of 'word'
If you need a count of the number of times
- Original Message -
From: "Alex Shi" <[EMAIL PROTECTED]>
> Okay, I will try MySQL GUI later
> BTW, do I have to use ODBC if I use PHP? I'm told PHP has its
> own very API for MySQL...
You can access MySQL from PHP using
PHP's ODBC functions (http://www.php.net/manual/en/ref.odbc.php
At 14:51 -0500 2001/12/13, Trond Eivind Glomsrød wrote:
>I know that, but I'm pretty sure sourceforge is one of their mirrors.
>
>--
>Trond Eivind Glomsrød
>Red Hat, Inc.
At 12:04 -0800 2001/12/13, Ron Jamison wrote:
>SourceForge is indeed one of their mirrors. Robert if you look you'll see
>Mo
Greetings:
http://www.mysql.com/doc/B/i/Binary_log.html
Is it possible to place this and the error log file generated by mySQLd on
the hard drive on another server?
If so, how?
Thank you.
Peter M. Perchansky, President/CEO
Dynamic Net, Inc.
He
I never used any kind of ODBC and can connect to mySQL with the
mysql.exe from c:/mysql/bin/
also with perl/apache locally installed I can make perl script to play
intop the DB without even thinking about ODBC
my 2 cents
Etienne
Miguel Angel Solórzano wrote:
>
> At 14:51 13/12/2001 -0500, Alex
Hi!
At 12:24 PM 12/13/01 -0800, you wrote:
>Heikki Tuuri wrote:
>
>> Foreign keys do not work if you do an ALTER TABLE. I have to add a note to
>> the manual that they do not work even if you do an ALTER TABLE to the
>> referenced table.
>
>
>Are you saying that you can't add columns to a table (
Yes you can use phpmyadmin for windows2000, I always have.
Here's a little bonus for you even though you didn't ask for it.
Save this to a batch file:
@echo off
set zdate=%date%
set zdate=%zdate: =%
set zdate=%zdate:/=-%
C:\mysql\bin\mysqldump -A > E:\mysqlDataBackup\%zdate%.txt
(replace the
On Thu, 2001-12-13 at 22:16, Ron Jamison wrote:
> I'm fairly sure there's no difference in performance when using PHP
tags
> mixed with HTML blocks as you are doing.
>
> Think of it as PHP knowing that it should send everything not in
tags
> directly to the browser. Like an echo or a print, but
Heikki Tuuri wrote:
> Foreign keys do not work if you do an ALTER TABLE. I have to add a note to
> the manual that they do not work even if you do an ALTER TABLE to the
> referenced table.
Are you saying that you can't add columns to a table (to grow the schema
incrementally between software v
Okay, I will try MySQL GUI later
BTW, do I have to use ODBC if I use PHP? I'm told PHP has its
own very API for MySQL...
Alex
- Original Message -
From: "Miguel Angel Solórzano" <[EMAIL PROTECTED]>
To: "Alex Shi" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, December 13,
How can I most efficiently return just the count of some word in a
large text field in a MySQL db, without returning the actual text
field contents. I am looking for the number of times the word appears
with a specific column, not count() of all columns that have that
word.
--
Michael
__
|||
I'm fairly sure there's no difference in performance when using PHP tags
mixed with HTML blocks as you are doing.
Think of it as PHP knowing that it should send everything not in tags
directly to the browser. Like an echo or a print, but without needing to
specify calls to those functions.
At 14:51 13/12/2001 -0500, Alex Shi wrote:
Hi!
The development of WinMySQLAdmin was stopped since other client
cross platform is in the works. However you can use MySQLGUI that
provides you with a complete set of features (you can download it
from our site).
Also you can use clients programs like
If you are using perl/DBI you can usee my @row = $dbh->fetchrow_array()
instead of the usual while()...
it will only take the first row returned.
Etienne
Ron Jamison wrote:
>
> Tack on a "LIMIT 1" on the end of your query to limit the returned rows to
> 1.
>
> Reference:
> http://www.mysql.c
use the mysql.exe file in c:/mysql/bin
double click it and it opens a dos shell where youcan do all commands!
mysql> use test;
Database changed
mysql> create table firsttable(
-> ID int unsigned auto_increment,
-> primary key(ID));
Query OK, # rows affected (0.00 sec)
mysql>
so on..
SELECT * FORM table_name WHERE ID IS NULL LIMIT 1;
Steve Osborne wrote:
SO: Date: Thu, 13 Dec 2001 12:47:26 -0800
SO: From: Steve Osborne <[EMAIL PROTECTED]>
SO: To: "MySQL (E-mail)" <[EMAIL PROTECTED]>
SO: Subject: SELECT'ing only 1st matching row
SO:
SO: Is there a way
I knew I had to be over thinking it thanks for the reminder about the
LIMIT.
Problem solved.
Thanks,
Steve.
- Original Message -
From: "Ron Jamison" <[EMAIL PROTECTED]>
To: "Steve Osborne" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, December 13, 2001 11:58 AM
Subject
SourceForge is indeed one of their mirrors. Robert if you look you'll see
Monty listed as a project admin.
I find it easier to download direct from the sourceforge mirror than to
navigate through the new download system on mysql.com. I hate it when I
wget an html file instead of the tarball I'm
i am creating a database in linux redhat 7.2. i cannot figure out how to
print my tables..or anything in mysql for that matter...i did not find
anything in the documentation..have i overlooked something..
-
Before posting, plea
Would you not want to display the last preferences they submitted? In
this case, if you have a timestamp field for each record you could select
last(timestamp) where userid = idvaluefromform.
On Thu, 13 Dec 2001, Steve Osborne wrote:
> Is there a way to SELECT only the first matching row
I believe what you want is to put a limit clause at the end of your sql
query.
ie Select Limit 1
That will only return one record that matches your query.
hope this helps...
--shak
Steve Osborne wrote:
>Is there a way to SELECT only the first matching row of a query? I would
>like to
Tack on a "LIMIT 1" on the end of your query to limit the returned rows to
1.
Reference:
http://www.mysql.com/doc/S/E/SELECT.html
-Original Message-
From: Steve Osborne [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 13, 2001 12:47 PM
To: MySQL (E-mail)
Subject: SELECT'ing only 1st
On Thu, 2001-12-13 at 19:18, Prottoss wrote:
> Actually unless this has been changed, when your php script terminates php
> automatically closes any mysql connections opened with mysql_connect().
I've noticed that, and up 'till now I haven't had a clue as to where
the problem w
After doing some more research I found out that the chip in the AS 1200 is
an EV56, and made the connection between that and the EV6 binary dumping on
me.
Following the advice of "2.6.1.4 Linux Alpha Notes" at:
http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Li
nux-Alph
Hello,
I installed MySQL 3.23.46 on Windows2000. The mysql-nt started
on Windows startup, and MysqlAdmin is also running well. I tried to
create a database with it and it works! Everything looks perfect
except I want to do something more than this admin tool can.
What I need is to create/drop
Robert Alexander <[EMAIL PROTECTED]> writes:
> >Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
> >
> >> Ron Jamison writes:
> >> > Using MySQL 3.23.46 from:
> >> >
> >> > http://prdownloads.sourceforge.net/mysql/mysql-3.23.46-unknown-linux-gnu-alp
> >>
> >> Try a binary from our site.
> >
> >Th
Is there a way to SELECT only the first matching row of a query? I would
like to allow the registration of identical products (unique serial numbers
/ owned by one user), without the user having to re-enter all their data.
I've set up a page that allows them to just enter their login info (userna
perl scripts running under mod_perl environment ( with the help of
Apache::Registry) will be using new database handler ($dbh) at each
connection, unless you install Apache::DBI, which keeps the database
handle open throughout the Apache process.
Etienne Marcotte wrote:
EM: Date: Thu, 13
Hi,
> -Original Message-
> From: Juan Majorel [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, December 13, 2001 8:56 AM
> To: [EMAIL PROTECTED]
> Subject: Error ODBC
>
>
> Hello !
>
> I can't connect to MySQL 2.23.64 under linux redhat
> 7.1
> The ODBC client is version 2.50.39 for NT ve
Try sequences.
Dave
On Thu, Dec 13, 2001 at 06:18:32PM -, Matthew Smith wrote:
> the SELECT LAST_INSERT_ID() gets the last autoincremented number for the
> current connection.
>
> See http://www.mysql.com/doc/G/e/Getting_unique_ID.html
>
> The auto_incremenet field is sadly lacking in Orac
At 11:45 AM 12/12/2001 -0500, Christopher Schreiber wrote:
>Actually I setup a vBulletin forum for MySQL over at www.mysqlforums.com
>and I am the moderator of the MySQL and Server Configuration forums over
>at www.vbulletin.com/forum/
Would it be too much to suggest that mysql.com host its own n
Hi!
At 04:10 PM 12/13/01 -0200, you wrote:
>Heikki Tuuri wrote:
>>
>> Hi!
>>
>> Foreign keys do not work if you do an ALTER TABLE. I have to add a note to
>> the manual that they do not work even if you do an ALTER TABLE to the
>> referenced table.
>>
>> Workaround: use DROP TABLE + CREATE TAB
>Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
>
>> Ron Jamison writes:
>> > Using MySQL 3.23.46 from:
>> >
>> > http://prdownloads.sourceforge.net/mysql/mysql-3.23.46-unknown-linux-gnu-alp
>>
>> Try a binary from our site.
>
>The above one _is_ your site, isn't it?
>
>--
>Trond Eivind Glomsr
If running mod_perl does this stay true???
Isn't mod_perl using an already opened connection to do subsequent
manipulations?
Or when one perl script is using a connection is creates a new
connection for each perl script that starts running and if a perl script
finishes, it keeps that same db han
> Hello !
>
> I can't connect to MySQL 2.23.64 under linux redhat
> 7.1
> The ODBC client is version 2.50.39 for NT version 4.
>
> I think that the problem is ODBC Driver.
>
> Please help me and Thank You !!!
>
> Juan
>
> the error text is :
> [TCX][MYODBC]Can't connect to MySQL server on
> 1
the SELECT LAST_INSERT_ID() gets the last autoincremented number for the
current connection.
See http://www.mysql.com/doc/G/e/Getting_unique_ID.html
The auto_incremenet field is sadly lacking in Oracle (IMHO).
M
-Original Message-
From: Henrik Erlandsson [mailto:[EMAIL PROTECTED]]
Sen
Hi,
I'm wondering what are those informations in the mysql .err file which
sometimes appear :
Status information:
Current dir: /home/mysql/
Current locks:
lock: 868e93c: read
read : 868f0b8 (79951:1);
lock: 8615e94:
lock: 85ba4bc:
lock: 856b104:
lock: 8521ad4:
lock: 84d84a4:
lock: 84
Heikki Tuuri wrote:
>
> Hi!
>
> Foreign keys do not work if you do an ALTER TABLE. I have to add a note to
> the manual that they do not work even if you do an ALTER TABLE to the
> referenced table.
>
> Workaround: use DROP TABLE + CREATE TABLE to alter your table, whether it is
> the referring
On Thu, Dec 13, 2001 at 12:37:59PM -0500, [EMAIL PROTECTED] wrote:
> ello Paul,
>
> can you try this and let see if it is going to work !
>
> UNLOAD DATA FROM TABLE fred INTO LOCAL OUTFILE "file.txt";
>
> And if it fails, i am sure somebody their will correct it!
Sorry, why would you expect i
On Thu, 13 Dec 2001 09:33:10 -0800, Michael Migal <[EMAIL PROTECTED]> wrote:
>>Opening and closing connections on any database is very expensive operation
>>in terms of time. It is better to keep a connection open, if possible,
>>until you have completed displaying the page.
>>
>>mike
With Pe
On Thu, Dec 13, 2001 at 12:34:59PM -0500, [EMAIL PROTECTED] wrote:
> Hi,
>
> I just discovered that I have to move the data text file I want to store in
> my table into bin directory of mysql directory (c:\mysql\bin\) before
> the LOAD DATA local infile "text.txt" INTO TABLE tabname can work.
Hi!
Foreign keys do not work if you do an ALTER TABLE. I have to add a note to
the manual that they do not work even if you do an ALTER TABLE to the
referenced table.
Workaround: use DROP TABLE + CREATE TABLE to alter your table, whether it is
the referring table or the referenced table.
If you
Jonathan Duncan wrote:
> 1 1/16"
> 3/8"
> 3/16"
> 1 5/32"
> 45º
> 10º
> 2 7/16"
>
> These aren't pretty numbers to enter into a database. The simple way would
> be to enter them as CHAR's and forget about them, but then searching on that
> could cause problems.
If you're not going to be doing a
You can lock the table when you insert.
mike
-Original Message-
From: Henrik Erlandsson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 13, 2001 9:25 AM
To: [EMAIL PROTECTED]
Subject: SV: sequence and nextval
Thanks, but how secure is this. Is it possible for two computers to do
th
> Thanks, but how secure is this. Is it possible for two computers to do
> the "select" at the same time, i.e. get the new incremented value?
> Computer one insert, computer two insert, computer one select, computer
> two select?
>
> If this is possible how can I solve this? To make the column th
Hi.
On Thu, Dec 13, 2001 at 10:50:30AM +, [EMAIL PROTECTED] wrote:
> Hi
>
> I'm using the partial MySQL query:
>
> FIND_IN_SET('Specific Locations',res_places)>0; AND
> FIND_IN_SET('Wales',res_places_sl)>0;
>
> And I was just wondering why use the ">0;". Why are they needed? What does
>
Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
> Ron Jamison writes:
> > Hi,
> >
> > I'm trying to use the available MySQL Linux Alpha binary distribution on
> > this AlphaServer:
> >
> > Linux jive.shadowtrance.com 2.4.9-12smp #1 SMP Tue Oct 30 17:54:45 EST
> > 2001 alpha unknown
> >
> > Ru
On Tuesday 13 Nov 2001 17:05, René Fournier wrote:
> And concerning database connections, my ISP asks that I always close a
> MySQL connection with a mysql_close()--which I can understand.
They probably use persistent database connections for Apache. If that is the
case, if you keep opening con
Hi.
On Thu, Dec 13, 2001 at 12:14:27AM -0800, [EMAIL PROTECTED] wrote:
> The manual states:
>
> "Normally, you don't have to lock tables, as all single UPDATE
> statements are atomic; no other thread can interfere with any other
> currently executing SQL statement."
>
> Does this hold true for
ello Paul,
can you try this and let see if it is going to work !
UNLOAD DATA FROM TABLE fred INTO LOCAL OUTFILE "file.txt";
And if it fails, i am sure somebody their will correct it!
Regards.
kamal
>Hi,
>
>Is there a reason why, if I can
>
>LOAD DATA LOCAL INFILE 'file' INTO TABLE fred;
>
>w
Bon apràs-midi René,
Well keeping a connection alive is way better on performance.. that is
why, under mod_perl, it keeps the connections alive.
You should connect at the beginning of the script, and always use that
same database handle for the script run. Then close it.
Etienne
René Fournier
Hi,
I just discovered that I have to move the data text file I want to store in
my table into bin directory of mysql directory (c:\mysql\bin\) before
the LOAD DATA local infile "text.txt" INTO TABLE tabname can work.
The problem here is that how do I then transfer this kind of file from my
l
Opening and closing connections on any database is very expensive operation
in terms of time. It is better to keep a connection open, if possible,
until you have completed displaying the page.
mike
-Original Message-
From: René Fournier [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November
Thanks, but how secure is this. Is it possible for two computers to do
the "select" at the same time, i.e. get the new incremented value?
Computer one insert, computer two insert, computer one select, computer
two select?
If this is possible how can I solve this? To make the column that insert
th
Hi!
> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> Philip Molter writes:
>>
>> Yeah, let me amend this. It's not happening with MyISAM tables,
>> only with InnoDB tables, and it is happening with the pre-compiled
>> binaries from the web site.
>>
>> It's definitely
On November 13, 2001 12:05 pm, René Fournier wrote:
> Is it true that mixing HTML and PHP--switching back and forth with
> tags--slows down performance? (I'm using PHP4.) Is it better
> to echo output than to drop out of PHP mode?
>
> And concerning database connections, my ISP asks that I alway
It depends what you need to do. For unique keys, I usually use
AUTO_INCREMENT feature.
mike
-Original Message-
From: Henrik Erlandsson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 13, 2001 7:41 AM
To: [EMAIL PROTECTED]
Subject: sequence and nextval
Does the above functions exis
Is it true that mixing HTML and PHP--switching back and forth with
tags--slows down performance? (I'm using PHP4.) Is it better
to echo output than to drop out of PHP mode?
And concerning database connections, my ISP asks that I always close a
MySQL connection with a mysql_close()--which I c
If you want to be able to store information encrypted and then decrypt it
later and you use perl see Crypt::CBC and pick an algorythim. The only
trick is that, with blowfish at least, you need a larger field than the
original. Also you must figure out how to hide the key...
On Wed, 12 Dec 20
Hi,
Your socket is probably set wrong in mysql.
It should be in the lib/mysql dir (mysql.sock)
but probably is somewhere in a tmp dir.
You can check if that's the problem by creating a sym link to the correct
dir.
(Note: this is not a good solution, as the sym link will go away, a soon as
mysql
Ok let's say I have a table for artists informations.
Some artists have two names, let's use know ones, "Prince" and "The
Artist"
I made a table artists that host different info for that artist, then
made a table with artistnames where i have artistID and artistName.
SELECT artistCity from arti
Hi there.
I'm using MySQL-Max version 3.23.46 for Linux-i386 and I just found a
problem.
It seems that every once in a while MySQL changes the references of a
foreign key when it's using temporary table. A show table status would
give us the following:
InnoDB free: 21504 kB; (usr_id) REFER conl
Hello !
I can't connect to MySQL 2.23.64 under linux redhat
7.1
The ODBC client is version 2.50.39 for NT version 4.
I think that the problem is ODBC Driver.
Please help me and Thank You !!!
Juan
the error text is :
[TCX][MYODBC]Can't connect to MySQL server on
192.168.1.20 (10071)(#2003)
http://www.gossamer-threads.com/scripts/mysqlman/index.htm
I think they have what you are looking for
Etienne
David Jourard wrote:
>
> Hi,
>
> Could someone recommend the best perl web panel to maintain the databases
> and tables for mysql.
>
> Something similar to phpMyAdmin but in perl.
>
I'm sure that this is a very simple situation, but I get an error trying to
connect to the DB. It told me that it couldn't connect with "socket '' ".
I am fairly new to Linux and definitely new to mySQL and mySQLGUI. But I
can get into mySQL via the command line. Can you lend a hand?
-
1 - 100 of 149 matches
Mail list logo
