Hi all.
When is supposed the 3.23.42 mysql version released?
Iago.
__
mensaje enviado desde http://www.iespana.es
emails (pop)-paginas web (espacio illimitado)-agenda-favoris (bookmarks)-foros
Here is what we have found while working on the 0.2.1 version of Escapade:
Because Escapade is not open source, and is in the following sense similar to
prepackaged Perl and PHP systems, Escapade is distributed as a static binary (because
of library incompatibility issues among various Linux
Gary Huntress ([EMAIL PROTECTED]) writes:
In the past few days 3 different people have asked me about xml support in
mysql. I was unsure what to tell them actually, beyond saying you can
easily export recordsets to xml documents.Obviously you can store
entire XML documents in a TEXT
Everything works great, except that I can't access a database created
by root as another user. When I grant privileges, from the command
line or phpmyadmin, things seem to work fine (no error message), but
access is still denied. I did restart MySQL after granting rights.
You can also check
muttaqin ([EMAIL PROTECTED]) writes:
Description:
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)
Fix:
how to correct or work around the problem, if known (multiple
lines)
ln -s /tmp/mysql.sock
Ed Carp ([EMAIL PROTECTED]) writes:
The obvious solution is to force, in the client library, for my.cnf to exist,
correctly configured, in a published place. Any other ideas on how to solve this
problem? I've already mentioned why relinking as a dynamic binary isn't feasible.
This won't
I used the binary with Red Hat 6.2.All the functions except table related functions
(specially table create functions) are working
Do let me know what i should do to make the table create function work
regards
venkatesh
e mail [EMAIL PROTECTED]
jason bailey ([EMAIL PROTECTED]) writes:
I'm consistently getting the error (2002)
: Can't connect to local MySQL server through socket
'/var/mysql/mysql.sock' (111)
You mean /var/lib/mysql/mysql.sock? Details are IMPORANT.
I've deleted it and running something above has brought it
Matthew S. Hamrick ([EMAIL PROTECTED]) writes:
Interfacing MySQL with standard crypto libraries: BSAFE, BDANGEROUS,
CRYPTIX, CRYPTLIB, CRYPTO++, or even PAM?
Why? What's the purpose? Export laws being what they are, it's probably not a good
idea, anyway...
Using any crypto
HI
This is srikanth, and i am persuing my final semester of Masters in Computers
Applications in India,
I have been recently to you site on advice of one of my friend, and i have downloaded
your setup file from the net and installed the database and the odbc setup file both
in my c:\mysql
Dear.
I have questions About Replicatation Features.
There is next sentence as follows (In Manual '11.4 Replication Features and known
problems')
MySQL only supports one master and many slaves. We will in 4.x add a voting algorithm
to automatically change master if something
goes wrong with
Even my mysql is compile with Big5, I couldn't use Chinese charaters (big 5)
as column name. Is that normal?
==
Best Regards
Jason Kwok
==
---
Virus Free
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.274 / Virus Database: 144 - Release Date:
Gary Huntress wrote:
In the past few days 3 different people have asked me about xml support in
mysql. I was unsure what to tell them actually, beyond saying you can
easily export recordsets to xml documents.Obviously you can store
entire XML documents in a TEXT field, but I'm not sure
Jason Kwok writes:
Even my mysql is compile with Big5, I couldn't use Chinese charaters (big 5)
as column name. Is that normal?
Did you quote the names? And did they contain any of the illegal
characters discused in
http://www.mysql.com/doc/L/e/Legal_names.html ?
I wonder why ÿ is not
Hi,
I have Windows NT 4.0 (build 1381/SP6a) running IIS4 Webserver (
http://www.abadon.net or 212.30.85.173 ) connected via CableModem/LAN to
Internet. I have also PHP ( Version 4.0.6 )scripting engine and MySQL server
( Client API version 3.23.32 said PHP info page, but in WinMySQL admin Ver
Ed,
Thanks for the email. I was a bit tired last night and was a little frustrated (4
nights getting nowhere), so apologies if I was little rude (I've just reread my email)
and
sarcastic, but thanks for the 'Details' pun. I've dug myself into a hole offering to
set up a Linux/Apache Webserver
In a SQL like : SELECT table1.f1,table2.f1 FROM table1,table2
you get a listing like this.
+++
| f1 | f1 |
+++
| 1 | 1 |
| 1 | 2 |
| 1 | 3 |
+++
When using the DBI function fetchrow_hashref() you get only one value since
the key is not unique.
Is there a way to get
At 10:33 05/09/2001 +0200, abadon wrote:
Hi,
Hi,
I have Windows NT 4.0 (build 1381/SP6a) running IIS4 Webserver (
http://www.abadon.net or 212.30.85.173 ) connected via CableModem/LAN to
Internet. I have also PHP ( Version 4.0.6 )scripting engine and MySQL server
( Client API version 3.23.32
)-Original Message-
)From: Deryck Henson [mailto:[EMAIL PROTECTED]]
)Sent: Tuesday, September 04, 2001 10:10 PM
)To: [EMAIL PROTECTED]
)Cc: MySQL
)Subject: Re: What does this error mean??!!
)
)
)Would you be so kind as to do that step by step? I'm very new to this and
)don't know half
Description:
Mysql doesn't allow to alias locked tables. See how to repeat
for details. This problem make impossible to use more complex
select queries on locked tables.
How-To-Repeat:
-- let's suppose there's a MyISAM table testtable
lock tables testtable
Hi,
Ive just started playing about with MySQL. I created a database called
haworth, no problem there, then created a table called list.
I put 3 entries in it, and checked it using
SELECT * FROM list;
It showed all the records fine. The MySQL server is running on NT, and I can
connect
[EMAIL PROTECTED] writes:
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
database,sql,query,table
If you just reply to this message, and include the
Hi folks!
I need to search a mysql database using wildcards. I know about the * and
the _ wildcards (any number of any character and 1 character of any kind,
respectively) but I need to match any number, any letter and thing like
that.
An SQL book claimed it could be done using brackets and
Iago Sineiro writes:
Hi all.
When is supposed the 3.23.42 mysql version released?
Iago.
Very soon.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_,
I need to search a mysql database using wildcards. I know about the * and
the _ wildcards (any number of any character and 1 character of any kind,
respectively) but I need to match any number, any letter and thing like
that.
An SQL book claimed it could be done using brackets and ranges
Carlos Augusto Perez Lima writes:
Hi,
I'm trying to install the mysql for Compaq Tru64 Unix 4.0f. I did the
download of file mysql-3.23.41.tar
# ./configure.
# make
...
...
+ rm -f ./typelib.c
+ /sbin/ln -s ../libmysql/typelib.c ./typelib.c
+ rm -f ./violite.c
+ /sbin/ln -s
I used MySQLGUI 1.7.5 binary with Red Hat 6.2. and MySql 3.22 All the functions
except table related functions (specially table create functions) are working
Do let me know what i should do to make the table create function work
regards
venkatesh
e mail - [EMAIL PROTECTED]
Peter Duffy writes:
Hi Sinisa,
My problems are within the mysqlclient and MyODBC libraries, both used
directly by the application (and therefore all on the client side of
the socket.) Both the mysqlclient and MyODBC libraries do (or in my case
did) contain calls to the DBUG functions.
BSD/OS 4.0.1, MySQL source 3.23.41, gcc 2.7.2.1, gmake 3.75,
latest m4, autoconf, aclocal and automake:
../configure --prefix=/home/[u]/[user]/mysql --disable-shared \
--with-unix-socket-path=/home/[u]/[user]/mysql/run/mysqld.sock \
--with-tcp-port=[port] --with-mysqld-user=[user] \
Brad Stockdale writes:
Hello all,
I'm new to the list... Been using MySQL for various things for a year
now, but have never ran into the following situation...
I have a flat text file that I have exported from FileMaker Pro. I want
to import that into MySQL, but there's a
Since the crash happens in the client directory, I tried even
configuring --without-client in pure desperation. It didn't
help; the compiler went into the client directory even then
and crashed just the same way.
Does anyone know how to fix this?
After you run the
I want to build a VB application that connects to mysql (over the internet)
running on linux. i have mysql currently running on LAMP system fine, but do
i just need to install MyODBC for linux on the mysql server or what?
also, are there any major security issues to this i should know about? any
IS their and ISP tracking list for MySQL adopters?
--
contact:
Dave Yadallee NetLine 2000 The Edmonton Internet Service Company
[EMAIL PROTECTED] http://www.nl2k.ab.ca
990-3244
-
Before posting, please check:
Ken Menzel writes:
Hello Sir,
cut
Your return of Poll 1 seems to indicated that there is a descriptor
ready to be serviced (hence the going in continuosly) but that the
daemon does not seem to be able to complete the servicing of that
descriptor. I am not sure why your daemon skips
[EMAIL PROTECTED] writes:
Hi People,
I'm trying to connect to Mysql server using Access2k, VBA and DSN less
connection, and mysql v3.23.36.
All queries sent to the server exceute or returns records just fine except
one simple query.
cut
show datbases ... is OK
describe database
Neil Zanella writes:
On Tue, 4 Sep 2001, Sinisa Milivojevic wrote:
Red Hat 7.1 has a very nice apache + mysql + php installation and invoking
mysql function calls from the php interface works very well. The only
aspect that puzzles me a little bit is that when I look at the output of
On Wed, 5 Sep 2001, Sinisa Milivojevic wrote:
Red Hat 7.1 has a very nice apache + mysql + php installation and invoking
mysql function calls from the php interface works very well. The only
aspect that puzzles me a little bit is that when I look at the output of
phpinfo(); I see a
Hi Russell,
have you applied patches M410-008, M410-012 and most important
M410-014? Even after applying the patches there are major thread
problems (althought MySQL should 'run' ). My advice to you is to
update to 4.2 which seems to fix the threads problems, and apply
current patches as
Hi guys,
I've a question using the c-api.
I sent a query to the server with
mysql_query( pConnHandleArr[iDbHnd], pcQuery )
and stores the result on the client locally with
pResSetArr[iDbHnd] = mysql_store_result( pConnHandleArr[iDbHnd] );
What happens if I do not free the
[EMAIL PROTECTED] writes:
I used MySQLGUI 1.7.5 binary with Red Hat 6.2. and MySql 3.22 All the functions
except table related functions (specially table create functions) are working
Do let me know what i should do to make the table create function work
regards
venkatesh
e mail -
De-install gcc 2.7.2.1 and install 2.95.2 or gcc 3.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
___/
Is that the correct location for mysql.sock?
If yes, is it world readable and writeable?
If no, is the socket location defined in /etc/my.cnf?
If it is, this file must be world readable.
½ÉÃ溸 wrote:
I installed linux and mysql 3.23.40.
Root installed and started mysql and user (charley)
Read the manual, especially the section on the GRANT command.
Roland Thompson wrote:
Hi,
I've just started playing about with MySQL. I created a database called
'haworth', no problem there, then created a table called 'list'.
I put 3 entries in it, and checked it using
SELECT * FROM
Jason Bailey ([EMAIL PROTECTED]) writes:
You mean /var/lib/mysql/mysql.sock? Details are IMPORANT.
Yes, thanks for the pun. It was the above /var/lib/mysql/mysql.sock and I noted
that deleting it and then running mysql_install_db or possible safe_mysqld
recreated.
Well, it wasn't a pun
Terje Kristensen ([EMAIL PROTECTED]) writes:
In a SQL like : SELECT table1.f1,table2.f1 FROM table1,table2
you get a listing like this.
+++
| f1 | f1 |
+++
| 1 | 1 |
| 1 | 2 |
| 1 | 3 |
+++
When using the DBI function fetchrow_hashref() you get only
The slave does not have a server-id.
Duc Chau wrote:
Hi, this is my first time posting to the list. I've followed mysql
replications how-tos to a tee...and I am still not able to get it to work.
the master mysql is running on a sun sparc station (SunOS 2.8) with mysql
3.23.41
the file
Hi John,
I've noticed rare occasions (about 1% of the time) when poll()
returns 0
-- these are always preceeded in the trace output by a signal
handler,
like this:
45689 mysqld 0.08 CALL sigreturn(0x826ae7c)
45689 mysqld 0.10 RET sigreturn JUSTRETURN
45689 mysqld
)-Original Message-
)From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
)Sent: Wednesday, September 05, 2001 5:35 AM
)To: [EMAIL PROTECTED]
)Cc: [EMAIL PROTECTED]
)Subject: Re: DSN-Less connection Strange error!
)
)
)[EMAIL PROTECTED] writes:
) Hi People,
)
) I'm trying to connect to
I have to insert a file wav into a blob field of a
table. Is that possible?And how can I do it?
Thanks in advance.
__
Do You Yahoo!?
Il tuo indirizzo gratis e per sempre @yahoo.it su http://mail.yahoo.it
Hi,
I'm using MM JDBC driver version 2.0.4 to access a MySQL database
3.23.40 on Solaris 2.8.
When I do the following query SELECT NOW(), I always get String data
and not Date data when fetching the data.
Is it normal that Date functions returns a String? Is this a MySQL bug?
Hi Srikanth
)-Original Message-
)From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
)Sent: Wednesday, September 05, 2001 12:56 AM
)To: [EMAIL PROTECTED]
)Subject: I am facing problems in creating tables
)
)
)HI
)
)This is srikanth, and i am persuing my final semester of Masters
)in
Hi !!!
)-Original Message-
)From: Ghislain Gadbois [mailto:[EMAIL PROTECTED]]
)Sent: Wednesday, September 05, 2001 7:37 AM
)To: MySQL List (E-mail)
)Subject: Date functions returning Strings
)
)
)Hi,
)
)I'm using MM JDBC driver version 2.0.4 to access a MySQL database
)3.23.40 on
Hi everyone,
I just installed MySQL on my linux box. But when I tried to connect to my
own box with jdbc (jdbc:mysql://localhost/red), it gave me SQLException:
server configuration denies access to data source. I have already added
root in the mysql.user and mysql.db, why is this
On Wed, Sep 05, 2001 at 04:44:01PM +0300, Sinisa Milivojevic wrote:
De-install gcc 2.7.2.1 and install 2.95.2 or gcc 3.
Stay with gcc 2.95.X until 3 is fixed!
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
/ /|_/ / // /\
Ed,
Once again, thanks for the email response. I'm going to try all the suggestions I've
received.
A colleague has suggested as I'm new to Linux to select the 'Install Everything'
option in red hat 7.1. He suggests that it's probably easier (for me) to get everything
installed and work
This may not be the best workaround, but I changed the 'localhost' to my
actual server url, and then it worked.
Someone else mentioned this as a means of fixing privileges:
http://sourceforge.net/forum/forum.php?thread_id=123272forum_id=50480
cheers,
Brett
-Original Message-
From:
During my attempt to configure the 3.23.41 source, I encountered the error:
configure: error: no acceptable cc found in $PATH. As I'm using gcc on
this box, where/how do I identify gcc for configure to use properly?
Thanks,
Brian
=?iso-8859-1?q?Cinzia=20Rubattino?= ([EMAIL PROTECTED]) writes:
I have to insert a file wav into a blob field of a
table. Is that possible?And how can I do it?
Bad, bad, BAD IDEA!
Read: http://www.bitbybit.dk/mysqlfaq/faq.html#storing_images
--
Ed Carp, N7EKG - [EMAIL PROTECTED] -
I am new to MySQL. I've installed the package under SuSe Linux 7.1
(kernel 2.4). When I try to start the database using commands from the
manual I get the following message.
Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock'. I'm pretty much lost at this point as I
If i put a server-id in the slave my.cnf file and start up the database with
safe-mysqld, it starts and dies with this error in the log file.
unrecognized option `--server-id=2'
-Original Message-
From: Gerald Clark [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 05, 2001 7:25 AM
subnet writes:
Hi,
I'm running OpenBSD 2.8 and MySQL 3.22.32 (recent cvs port).
After time ( 1day) the cpu load for the mysqld process goes up to
98%..
Is this a known problem? any ideas?
Thanks,
Stu
Hi! There is a known problem in 2.8 thread library. I do not know
when
Hi,
I'm using :
- Win NT 4.0 SP6
- Apache 1.3
- PHP 4.05
- MySQL 3.23
When I try to upload JPG files, the temporay files on the server are OK.
But when I store them into a BLOB field into mySQL, some images (not all)
are truncated after some lines.
It's like an EOF byte found ...
The SQL is:
hi.
assuming you're using a bash-type shell and gcc is in /some/directory/gcc
PATH=$PATH:/some/directory
export PATH
echo $PATH
otherwise:
setenv PATH /some/directory:${PATH}
if more errors crop up, copy and paste the error message into google and see
if any relevant results are returned.
hth.
Hi,
I'm using :
- Win NT 4.0 SP6
- Apache 1.3
- PHP 4.05
- MySQL 3.23
When I try to upload JPG files, the temporay files on the server are OK.
But when I store them into a BLOB field into mySQL, some images (not all)
are truncated after some lines.
It's like an EOF byte found ...
The SQL is:
Hi,
I'm using :
- Win NT 4.0 SP6
- Apache 1.3
- PHP 4.05
- MySQL 3.23
When I try to upload JPG files, the temporay files on the server are OK.
But when I store them into a BLOB field into mySQL, some images (not all)
are truncated after some lines.
It's like an EOF byte found ...
The
I'm running OpenBSD 2.8 and MySQL 3.22.32 (recent cvs port).
After time ( 1day) the cpu load for the mysqld process goes up to 98%..
There is a known problem in 2.8 thread library. I do not know
when will they fix it. You can ask them , though ..
I've seen that this has been addressed in the
At 6:35 PM +0200 9/5/01, Carsten H. Pedersen wrote:
Hi,
I'm using :
- Win NT 4.0 SP6
- Apache 1.3
- PHP 4.05
- MySQL 3.23
When I try to upload JPG files, the temporay files on the server are OK.
But when I store them into a BLOB field into mySQL, some images (not all)
are
Hi Derek,
- Original Message -
From: Derek Sivers [EMAIL PROTECTED]
much cut
But with LOTS of MySQL traffic (20,000 unique users a day on a 100%
MySQL-driven website) - yes the mysqld process goes up to 99% and
freezes
the server until I reboot.
Have you tried capturing
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
At 6:35 PM +0200 9/5/01, Carsten H. Pedersen wrote:
Hi,
I'm using :
- Win NT 4.0 SP6
- Apache 1.3
- PHP 4.05
- MySQL 3.23
When I try to upload JPG files, the temporay files on the
server are OK.
Hello!
It seems that with a wrong command:
mysql delete from user where host='%';
I have casually deleted all data in user table :(((
It works for now but after reload all data in the table will be lost ...
Can I recover the user table in such a situation ???
Thank you !
--
Piter
At 7:34 PM +0200 9/5/01, Carsten H. Pedersen wrote:
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
At 6:35 PM +0200 9/5/01, Carsten H. Pedersen wrote:
Hi,
I'm using :
- Win NT 4.0 SP6
- Apache 1.3
- PHP 4.05
- MySQL 3.23
When I try to
I'm trying to use a socket besides the standard /tmp/mysql.sock one. I've
tried specifying socket=/path/to/socket in both [client] and [mysqld]
sections of my.cnf, and I've tried to edit safe_mysqld directly with this
path. In all cases, the mysql server appears to start (no error messages
are
Hello again !
Sorry I made some mistakes.
The the wrong command was - DELETE FROM user WHERE Host LIKE %;
and got this:
mysql select * from user;
Empty set (0.00 sec)
Can I recover the user table in such a situation ???
Thanks agin.
It seems that with a wrong command:
mysql delete from
I'm trying to use a socket besides the standard /tmp/mysql.sock one. I've
tried specifying socket=/path/to/socket in both [client] and [mysqld]
sections of my.cnf, and I've tried to edit safe_mysqld directly with this
path. In all cases, the mysql server appears to start (no error messages
Yes, I gave it 644 permissions.
- Original Message -
From: Carsten H. Pedersen [EMAIL PROTECTED]
To: BW (ST) [EMAIL PROTECTED]; MySQL List [EMAIL PROTECTED]
Sent: Wednesday, September 05, 2001 10:58 AM
Subject: RE: 'tmp/mysql.sock' (2) error
I'm trying to use a socket besides the
Hi!
Since I heard Monty is in Sweden, which will probably delay
the release of 3.23.42 still a couple of days, I decided to
release the InnoDB-3.23.41b source at my website
http://www.innodb.com right now.
The release fixes the bad BLOB bug where any update of
the primary key of a 8000-byte
I am New at this Mailing List, `cause of it first of all lemme say Hi to
everybody...
I`m facing a problem with my Web Server, it`s a Conectiva Linux, running
Apache
We had a problem with it last night, all configuration files were lost and
were forced to recover the backup. After this, trying to
Hi all
Is there a document available somewhere outlining
some guidelines regarding what parameters should be
set in the my.cnf files for the MySQL database and to
what values?
thanks
=
__
Do You Yahoo!?
Get email alerts NEW webcam
Hello all,
I am trying to integrate the mysql with php. As I am using the Red Hat
7.0, I know that they come pre-installed and pre-configured. When i
created test.php with the ?php phpinfo() ? line, the page shows that
the php is able to recognize the presense of mysql. I created a small
table
Chakravarthy K Sannedhi wrote:
$db=mysql_connect (localhost,myname,mypassword);
mysql_select_db (newone,$db);
$result = mysql_query (select * from namelist);
[snip]
Warning: MySQL Connection Failed: Can't connect to local MySQL server
through socket
hmm. Are you sure that MySQL is running? Conversely, does the file
/var/lib/mysql/mysql.sock exist?
Steve
At 11:52 AM 9/5/01 -0700, Chakravarthy K Sannedhi wrote:
Hello all,
I am trying to integrate the mysql with php. As I am using the Red Hat
7.0, I know that they come pre-installed and
Hi,
I' have installed mysql on linux 7.1 and
when a web application open a new session of mysql it remain
opened in memory, so my server goes in memory overload.
please help me.
thanks
P.S.: Sorry for my english !!!
-
Before
Well, this is a client error, not a server error.
What client is this?
Maybe you have another my.cnf in the data directory,
or possibly a .my.cnf file in your home directory.
BW (ST) wrote:
I'm trying to use a socket besides the standard /tmp/mysql.sock one. I've
tried specifying
Is it possible to modify the following query:
SELECT COUNT(*) AS pass WHERE test=x AND value BETWEEN low AND high;
to also count the total number of records where 'test=x'
and hence return the percentage pass mark all within one statement, or am I
stuck using 2 statements 1 as above to count
I think your slave version is too old.
Duc Chau wrote:
If i put a server-id in the slave my.cnf file and start up the database with
safe-mysqld, it starts and dies with this error in the log file.
unrecognized option `--server-id=2'
-Original Message-
From: Gerald Clark
I need to read the fields of a table dynamically using
DBI.pm
The resulting cgi script should be a form that has a
checkbox for each field...the user will then create a
temporary table based on which fields are checked in
the form.
=
--
Anthony Ettinger
[EMAIL PROTECTED]
415-504-8048
SELECT SUM( test=x ) AS total, COUNT(*) AS pass FROM table WHERE text=x AND
value BETWEEN low AND high;
b.
Chris Thorpe wrote:
Is it possible to modify the following query:
SELECT COUNT(*) AS pass WHERE test=x AND value BETWEEN low AND high;
to also count the total number of records
Apologies for the off topic, but I'm collecting some information, and I
figured the lists that I'm on would provide a good feedback mechanism.
Replies to me off-list if you would please. My apologies for the very
short notice, but I just heard that I need this by ~8 AM EST Thu 6th
Sept :(
A
my $dbh = DBI-connect( ... );
my $sth = $dbh-prepare( SHOW COLUMNS FROM $table ) or die;
$sth-execute( ) or die;
my @columns;
while( my( $column_name ) = $sth-fetchrow_array( )){
push @columns, $column_name;
}
$sth-finish( );
b.
Anthony E. wrote:
I need to read the fields of a table
On Wed, Sep 05, 2001 at 08:30:53PM +0100, Chris Thorpe wrote:
Is it possible to modify the following query:
SELECT COUNT(*) AS pass WHERE test=x AND value BETWEEN low AND high;
to also count the total number of records where 'test=x'
and hence return the percentage pass mark all within
Hello,
I keep getting this:
insert into tmp select * from ascend_log_2001_08_25;
ERROR 1114: The table 'tmp' is full
tmp is a heap table
I've looked through the docs and mailing list archives and can't find anything
that matches my problem. I'm using 3.23.41 so it should switch to disk if it
On Wed, Sep 05, 2001 at 07:59:15AM +0800, Steve Doig wrote:
Hi Folks,
I'm running a batch command in win2K: cmd mysql batch-file output.txt
In the batch file, can I specify that values are separated by commas instead
of tabs?
Cheers,
Steve
not using that syntax but with somethinig
I've been running a master/slave MySQL database system for about four months now and
I've got nearly 360mb of binary logs. I want to archive anything over about a month
old, but I've heard that there is a procedure that you have to go through to do that.
Hi folks, just signed up to the list so I hope this is the correct place to
send such a question:
I have recently upgraded to Red Hat Linux 7.1 from Red Hat 6.x
I had successfully run MySQL under that distribution but am having problems
with it under Red Hat 7.1
I have installed mysql-3.23.36
On Wed, Sep 05, 2001 at 03:46:03PM -0400, Duncan Hill wrote:
A college graduate, with only an Associate's Degree and a CCNE
approaches you/your company, with a resume that indicates no experience
whatsoever, just the schooling from an associate's degree, a CCNE and
knowledge of layers 1 - 3
Adams, Bill TQO wrote:
SELECT SUM( test=x ) AS total, COUNT(*) AS pass FROM table WHERE text=x AND
value BETWEEN low AND high;
b.
Ugh, brain fart.
SELECT COUNT(*) AS total, SUM( value BETWEEN low AND high ) AS pass FROM table
WHERE text=x;
--Bill
FVFM (thats: From the Very Fine Manual )
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Databa
se_Administration.html#SHOW_VARIABLES
You may have the above line split by your mail reader, just cut and
paste the two havles in or go to:
[EMAIL PROTECTED] wrote:
Hello,
I keep getting this:
insert into tmp select * from ascend_log_2001_08_25;
ERROR 1114: The table 'tmp' is full
tmp is a heap table
There is a size limit to temp tables. See:
http://www.mysql.com/doc/F/u/Full_table.html about increasing the allowed size
for
Greetings,
This morning we sucessfully inserted a new record on our master MySQL
machine. 4 1/2 hours later, the change showed up on the slaves. I was
under the impression that MySQl replication would occur in a more timely
fashion.
We have a single master with 4 slaves replicating only one
[EMAIL PROTECTED] (Jason Bailey) writes:
If the server is creating mysql.sock in and something else is looking
for it in /tmp, this is the easiest way to get it to work, besides
checking to make sure that the permissions are such that anyone who
needs to can read and write to mysql.sock. --
1 - 100 of 142 matches
Mail list logo