You are just missing a step. The execute method does exactly what it says,
executes the prepared SQL statement. Once this is done, you must fetch data
from the handle with one of the fetch methods such as fetchrow_array or
fetchall_arrayref. Another alternative is to combine the prepare, execut
If you do not specify another location, then you should find it as
/tmp/mysql.sock. This file only exists, if the mysql-daemon is running.
Wolfgang Arendt
Vodafone TeleCommerce GmbH
SW Test & Config. Management
Wolfgang Arendt
Daniel-Goldbach-Str. 17-19
40880 Ratingen
Tel. +49 (0) 21 02 / 97 249
On Mon, Feb 05, 2001 at 02:44:35PM +0800, [EMAIL PROTECTED] wrote:
> hi list,
>
> im trying to write a perl srcipt that will connect to a mysql
> database server, do some queries and print the output on the screen
> (or maybe append the output to a file), that would look something
> like this.
>
>Description:
When the system is loaded down and using the max number of connections,
if you do a mysqladmin shutdown, it kills all the mysql processes except
a few. One of the mysqld processes uses 100% cpu and writes this out
to the log file continuously:
Can MySQL make a DB link connection to Oracle such that MySQL can access
tables in Oracle and vice versa?
Thank you very much
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql
> 1 $ le litre de Gaz en FRANCE
>
I got his kind of error since i upgrade my 3.22 to 3.23
010205 11:43:17 Aborted connection 3319 to db: 'radius' user: 'root' host:
`localhost' (Got an error reading c
ommunication packets)
what did it mean
Thanks
-
Befo
hi list,
im trying to write a perl srcipt that will connect to a mysql database
server, do some queries and print the output on the screen (or maybe append
the output to a file), that would look something like this.
+--+---+--+-+
| tnum | user | cust | area
I'm going to be setting up a development machine using linux (I'm currently doing work
with Win2K). My intent is to make sure I can do MySQL and PHP on a linux machine.
As a newbie to linux, what would be the best distribution of linux for me to use? I
don't mind paying a few bucks for the CD
Hello,
After trying an HPH-script MySQL started to slow down the whole computer.
The problems remained after a restart of the computer. I removed the MySQL
installation using the Control Panel Add/Remove Programs and reinstalled
MySQL. When I run "mysqld-nt --install" I got a message - failed t
Hello,
I am trying to craft a query that will allow me to retrieve truly unique
result elements. Here's my setup:
table_1
link_field varchar(20)
field1 varchar(20)
field2 varchar(20)
table_2
--
link_field varchar(20)
field3 varchar(20)
Here's what
Dear all.
it's a little hard to tell you what we encountered, but I would try it.
we invoke a script 'do_all' to do something, but after that, safe_mysqld
can't work. do you have any idea abou that ?
--
Dick <[EMAIL PROTECTED]>
Hi Folks,
I've been trying to debug Mysql server 3.23.32 under Irix 6.5.10f. While
it compiles and executes under light load, any significant load results in sigsegv.
(easily reproducible by running a python script to access a database. One instance
of the script, no problem, two instance
Hi all,
I'm using SQLBindParameters to bind the columns to variables of type integer, string
and binary. There was no error during binding and writing. However, the string data
are all NULL when I checked the database entries. I figured it could be a mistake in
the SQLBindParameter parameters.
After upgrading an 1000A from 4.0E to 4.0F and successfully running
3.23.29a-gamma for three days I thought I was out of the woods. This BTW
was an upgrade from 3.22.xx with the Binary release:
mysql-3.23.29a-gamma-dec-osf4.0f-alphaev6.tar.gz.
I did the OS and Database at the same time, living
Paul I expect to see documentation append to the copy of your book I bought 8
months ago ;-)
Paul DuBois wrote:
> On Sun, Feb 04, 2001 at 11:32:42PM -0200, Fábio Ottolini wrote:
> > Paul,
> >
> > Tomorrow they are going to add a new feature named "over the air select".
> > Why this is not on you
On Sun, Feb 04, 2001 at 11:32:42PM -0200, Fábio Ottolini wrote:
> Paul,
>
> Tomorrow they are going to add a new feature named "over the air select".
> Why this is not on your book? :)
Ag!
:-)
> BR,
>
> Fábio Ottolini
>
> - Original Message -
> From: "Paul DuBois" <[EMAIL PRO
How is it possible to compile mysql sources without the server and without socket
support? I am trying to connect a cygwin mysql client to a win32 mysql server on the
same PC, but the perl mysql mod test keeps looking for mysql.sock.
So I am thinking if I remove the socket client in the sources
>Hi,
>I've been trying for a while now and I can't figure
>out how to do the following:
>
>In regular English, I wish to show all items for which
>I have allocations greater than one for all days
>encapsulated between the user input range.
>
>User Input:
>---
>Date_from (ie. 2001-02-0
Paul,
Tomorrow they are going to add a new feature named "over the air select".
Why this is not on your book? :)
BR,
Fábio Ottolini
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Rick Pasotto" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, February 04, 2001 9
Hi,
Does anyone know of or have a problem that means that the
HTML server will not receive the message back from the MySQL
server to say close the connection.
The two servers are on two seperate machines.
The html server is Apache using the PHP scripting language.
The error messages I
Can you explain what difference between dates 2001-02-04 and 2001-02-06 for
item2 and 2001-02-04 and 2001-02-06 for item1?
- Original Message -
From: Web Depressed <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, February 04, 2001 11:41 PM
Subject: Can anyone do this ?
> Hi,
Maybe mysql_result description could help you.
int mysql_result(int result, int row, mixed [field] );
mysql_result() returns the contents of one cell from a MySQL result set. The
field argument can be the field's offset, or the field's name, or the
field's table dot field's name (fieldname.table
Try: select t1.*, t2* from table1 as t1, table2 as t2 where
t2.date>='2001-02-04' and t2.date<='2001-02-06' and t1.id=t2.id and
t2.no_of_items>=1
>>Here is where I'm at:
>>mysql> SELECT t1.*, t2.*
>> -> FROM Table1 t1, Table2 t2
>> -> WHERE t2.date BETWEEN "2001-02-04" AND
>>"2001-02-06"
I've looked for two hours on www.mysql.com and can't find how to do what would be the
following in Oracle:
Update tablea set (a,b,c) = (select d,e,f from tableb)
where a=y;
At 5:45 PM -0500 2/4/01, Rick Pasotto wrote:
>If reserved words are such a big deal why are they not even mentioned
>in the DuBois book? Or if they are I haven't come across it. Certainly
>'reserved' does not appear in the index.
Guilty as charged.
With reference to the use of `` to quote reserv
At 10:31 AM -0800 2/5/01, Daniel Kirk wrote:
>Does MySQL have any date/time functions -> can anyone give me a URL where I
>can find some documentation on it. I'm looking for SQLServer equivalents of
>DateAdd(), DateDiff(), Month(), Year() etc
The MySQL Reference Manual is a good source of inform
At 2:28 PM -0800 2/4/01, Heath Boutwell wrote:
>Evidently, one can use the ` to escape reserved words
>in mySQL.
>
>Why in the world this isn't mentioned in the manual is
>beyond me.
http://www.mysql.com/doc/L/e/Legal_names.html
http://www.mysql.com/doc/R/e/Reserved_words.html
>
>Why no one on t
Does MySQL have any date/time functions -> can anyone give me a URL where I
can find some documentation on it. I'm looking for SQLServer equivalents of
DateAdd(), DateDiff(), Month(), Year() etc
thx dan
-
Before posting, pleas
As for documentation, does this count?
http://www.mysql.com/doc/R/e/Reserved_words.html
Or, to quote from section 7.39 of the manual, which the above link will take you to:
"7.39 Is MySQL Picky About Reserved Words?
A common problem stems from trying to create a table with column names that us
Hello all I hope you can help.
I am using the line
$email = mysql_result($result,0,"email");
in php4
when i load the page I get
Warning: Supplied argument is not a valid MySQL result resource
in/var/www/dbase/index.php on line 10
This is the line i have written the code.
I have tried it several
If reserved words are such a big deal why are they not even mentioned
in the DuBois book? Or if they are I haven't come across it. Certainly
'reserved' does not appear in the index.
--
"Democracy extends the sphere of individual freedom; socialism
restricts it. Democracy attaches all possible v
Evidently, one can use the ` to escape reserved words
in mySQL.
Why in the world this isn't mentioned in the manual is
beyond me.
Why no one on the list ever mentions it when some poor
sap discovers that some random word has been made
reserved for no reason is beyond me
Why the mySQL developers
I recently asked for some help with join order and it's now fixed, kinda :)
On a web server running mySQL version 3.22.32 on a Linux box (cobalt RAQ) I get the
following output for this query:
EXPLAIN SELECT * FROM (LOG_LOG LEFT JOIN SAT_CMD ON LOG_LOG.LOG_ID=SAT_CMD.LOGID) LEFT
JOIN SAT_GEN O
Hi,
I've been trying for a while now and I can't figure
out how to do the following:
In regular English, I wish to show all items for which
I have allocations greater than one for all days
encapsulated between the user input range.
User Input:
---
Date_from (ie. 2001-02-04)
Date_to
MySQL 3.23.32 has been crashing on me quite frequently, as well as the past
several versions. At first I gave MySQL the benefit of the doubt and blamed
it on the compilation. I've since tried 6 different builds, ranging from
fully optimized with no debugging to bloated and slow, with full debugg
>Description:
If one doesn't provide a default pager to the monitor using --pager,
and gives the monitor a \P command with no pager specified, the default
pager is set to stdout, even if the PAGER environment variable is set.
To my thinking, a bare \P is the user sa
>Description:
The --pager option to the mysql monitor, if given no argument, doesn't
check to see if the PAGER environment variable is set before copying
it, permitting a read from address zero and subsequent segfault.
>How-To-Repeat:
grotum:/tmp$ mysql.orig --ver
Ruben I Safir - Brooklyn Linux Solutions CEO wrote:
>
> What exactly is now the relationship between NuShpere and MYSQL/TSX. Who is
> working on the Gemini COde and the documentation?
>
> Ruben
>
> --
> Brooklyn Linux Solutions
> http://www.mrbrklyn.com
> http://www.brooklynonline.com
>
> 1-7
Actually, I didn't correctly type in the example. In the second example,
one field from the table forum is also included in the query.
Apparently there are problems with match() if MySQL uses can't do the entire
query without creating its own temporary tables. I've just rewritten it
like this:
On Sun, Feb 04, 2001 at 01:03:47PM -, Phil Taylor wrote:
> Hi
>
> I can't find any documentation that explains how to activate page
> level locking on BDB tables - is page level locking the default when
> a CREATE TABLE is done?
Yes.
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo
Thank you very much -
This works fine now !
Clownfish
- Original Message -
From: "Pat Sherrill" <[EMAIL PROTECTED]>
To: "Clownfish Internet Services - www.clown-fish.com"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, February 04, 2001 6:00 PM
Subject: Re: timestamp(14) fails to
I get the same behavior, and parentheses don't make any difference.
As long as the min or max argument is a mathematical expression,
MySQL uses the second number in the expression as the argument, so
the BETWEEN clause below is the same as
BETWEEN (63000) AND (63000)
I tried this on 3.23.3
>I am trying to write a query using the fulltext and match and I've
>run into a problem. I'm new to MySQL, so this question might have
>already been asked, but I just can't seem to find it.
>
>I'm using the fulltext capabilities to do a query. The query
>requires joins with four different tab
>Background info: One main table with basic entry info joined to
>other tables with additional info about the entry. The additional
>info about the entry is based on the entry type and is located in
>single other table (which other table depends on the entry type).
>
> - table LOG_LOG (this i
Is there a way to copy select fields from one table and copy them into another table?
Thank you
William Robinson
When using a TIMESTAMP column with LOAD DATA INFILE, the TIMESTAMP must be
either set to NULL or an appropriate date within the import file or
specifically left out of the field list in the LOAD DATA INFILE statement as
follows:
LOAD DATA INFILE 'example.csv' replace into table example FIELDS
I am experiencing problems trying to dynamically link tables in Microsoft
Access 2000 using ODBC and MYSQL.
MYSQL Ver 11.12 Distrib 3.23.32, for pc-linux-gnu (i686)
ODBC myodbc-2.50.36-win95
MS Access2000 with MDAC 2.1
The error messages I am getting are "this record has been changed by anothe
Can someone give me the mysqladmin line to log debugging activity:
tried mysqladmin -debug /var/log/mylog
to no avail.
Also, how do you start mysql with logging on, not update, just to log
connections as they occur so I can identify problems.
I can log in such as mysql -u ^&( as localhost), bu
Hi
I don't understand the way mysql tries to jail itself with --chroot.
If I start
mysqld --chroot=/var/lib/mysql_jail
then it gives me an error saying that it wasn't able to initialize the
databases. When I copy the mysql database somewhere into the jail it works.
But - when I modify the my
What exactly is now the relationship between NuShpere and MYSQL/TSX. Who is
working on the Gemini COde and the documentation?
Ruben
--
Brooklyn Linux Solutions
http://www.mrbrklyn.com
http://www.brooklynonline.com
1-718-382-5752
-
I keep getting this error.
table products created: create table products (
sku VARCHAR(20) NOT NULL PRIMARY KEY,
description VARCHAR(255) NOT NULL,
price DECIMAL(12,2) NOT NULL, index(price),
author_editor VARCHAR(80),
isbn VARCHAR(20),
url VARCHAR(40),
title VARCHAR(128) DEFAULT '' NOT NULL, ind
i want to synchronize table A from database A with table B from database B..
i read somewhere that i can replicate with update or binlog but this would
update the whole database..
how can i use update log to update only certain tables and only the records
which was deleted/inserted/updated from
Ehm why would i need help spending 400$ in 14 days? I can spend them way
faster than that :-)
On Fri, 2 Feb 2001, Aaron Williams wrote:
> At 10:25 PM +0200 2/2/01, Siim Einfeldt aka Itpunk wrote:
> >I get an awful lot of spam to my private email as well, I could filter
> >them, but does anyone
Why you don't use GROUP BY?
- Original Message -
From: Siim Einfeldt aka Itpunk <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, February 04, 2001 1:59 PM
Subject: problems getting DISTINCT data
>
>
> SELECT DISTINCT estitle,id,lepingid FROM main WHERE litsents='something'
> OR
Hi
I can't find any documentation that explains how to activate page level locking on
BDB tables - is page level locking the default when a CREATE TABLE is done?
Cheers
Phil
I have some problems with the win32 interface dll libMySQL.dll.
Everything works out fine when only retrieving correct queries.
However, when executing an incorrect query, everything behaves normal until i
terminate the application (and thus unload the dll).
With other types of access (mysql co
Hi,
I'm handling a database which has about 2 million records.
When I execute a query such as: "select * from megasize where
idtxt='hello';"
It takes approximately 8 seconds to get the records...
I've got a quite fast computer and I wondered if there was a way to increase
the speed of the query
Daniel Kirk writes:
> Hi there,
>
> I am considering porting a MS-SQLServer database to MySQL. After reading
> some of the documentation, I am concerned about inserts.
>
> I run a sports prediction website, where players submit their predictions
> for a competition. When a player submit
Peter Zaitsev writes:
> Hello Andreas,
>
> Thursday, February 01, 2001, 7:42:31 PM, you wrote:
>
>
> I must confirm the problem with table locks. Mysql realy may deadlock
> sometimes, and the funny thing is the solution to this case is to kill
> the oldest locked thread waiting this con
Lee Jenkins wrote:
>
> Hello all.
>
> We are currently using MS Access for a multi-user application (4-5 clients).
> We sent out a system to a customer with NT Service enabled in anticipation
> of switching over to MySQL.
>
> We noticed that when activity on the MS database got heavy (if you ca
SELECT DISTINCT estitle,id,lepingid FROM main WHERE litsents='something'
ORDER BY lepingid
Now, lets suppose I have 20 entries with the exact same information (or at
least estitle and lepingid are the same). What if I wanted to get only one
entry with the same information? I could do it with LI
Hello, I noticed that while access databases use 'memo' mysql does not. It
uses blob. Anyway, I used it for a discussion board, and it stores messages,
but it won't display on my web page via asp.
It would work via access using 'memo' not 'text'.
So what conditions apply when inserting/displayin
Dear Benjamin.
I firstly very very thanks for your interest.
This is my 3'rd mail with same question and you 're the first one who
reply.
- Original Message -
From: Benjamin Pflugmann <[EMAIL PROTECTED]>
To: Yusuf Incekara <[EMAIL PROTECTED]>
Cc: Mysql Mailing list <[EMAIL PROTECTED]>
Sen
- Original Message -
From: Yusuf Incekara <[EMAIL PROTECTED]>
To: Benjamin Pflugmann <[EMAIL PROTECTED]>
Cc: Mysql Mailing list <[EMAIL PROTECTED]>
Sent: Saturday, February 03, 2001 1:54 AM
Subject: Re: Not Urgent . Please Don't care. (Can't Connect to Mysql Server
on 192.9.200.2 (10055))
I hate when I forget passwords, too. Especially when I didn't write them down and
safe-keep them somewhere.
Regards,
rmdirms
Jeff wrote:
> Never mind. Dumb mistake. I had an older version of mysql
> on this system set to a password which I forgot.
>
--
rmdirms...
seen on the internet
...w
66 matches
Mail list logo