Does anyone have any recommendations on a tool that can produce a
graphical representation of a database stored within MySQL?
(i.e., if pointed at a database, will produce a graphical
representation of each table contained therein, including links to
foreign keys, etc...)
I've looked at a
Alec,
Thanks for the info, however I'm struggling to understand how it applies to
my case. Following is the piece of code in question, and the error is due to
the SELECT following the INSERT (insert works fine; LIGHTBOX_ID is on
AUTO_INCREMENT) :
// add a LIGHTBOX row ...
rs =
Assuming you have table staff with an id and name,
and title with id and title,
You create a join table.
Staff_id Title_id
1 1
1 2
2 1
2 3
Then:
Select name,title
FROM staff s , title t, jointable j
WHERE s.id=j.staff_id AND j.title_id=t.id;
Mark Worsdall wrote:
Please address answer to [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL
you need a join table between the two tables. It would contain the primary
keys of both tables. This way for any given staffID, you could have 0-n
records that contain staffId subjectTitles_id.
To get all the subjectTitles for a given staff you would
Select * from staff_subjectTitles where
I am attempting to migrate data from a mysql database to a mssql7 database.
There seem to be some differences between the two. Can anyone help me in
determining what needs to be changed in my sql script (mysqldump) to allow
me to recreate my schema in mssql7. Or, can someone steer me to a good
I wondered the same thing (I didnt write the original query). But using
'or' will not select rows with null values as using the outer join (+) in
oracle does. Hence, incorrect rows.
Heres the original Oracle query:
select distinct subsnp_pk, chrom, chrompos, locus, locusid, source,
sourceid,
I have a query question I can't figure out on my own. Any help is
appreciated...
I have three tables:
create table courses (
rec_num int(5) not null default '0' auto_increment,
name varchar(255),
description varchar(255),
class_time varchar(255),
professor_id int(5),
mysql client is not running.
and there is a problem in database connectivity too.
it says acess denied using Password="YES".This was the error when mysql was
running.It's on Apache Web Server.
Please suggest me what changes are to be made in the configuration and
reflect on the point about
First of all, since you are not a programmer, it is going to be
difficut. I have done something similar but for a travels site using php
and mysql. I suggest you send me a private mail I will help you if I can
Adrian
I've got mysql and php installed on my server and i was wondering if
anyone
Hi,
I have a table called staff which currently has a column called
subjectTitles_id which is the type INTEGER.
I have another table called subjectTitles which contains 12 subject
titles.
So that is how a member of staff is assigned a subject.
Trouble is I need to be able to assign a
on 3/20/01 1:20 PM, Bryan Coon at [EMAIL PROTECTED] wrote:
Sorry for the ambiguity, I was trying to make a really generic select
statement. I just meant that if 'where a = A.a' has no matches, but 'where
b = B.b' or 'where c = C.c' does match, the query returns what did match,
and just
I went into my database today and noticed that there was 102,000 entries.
Somehow a whole pile of crap was added to the end of the database. I think
it can easily be fixed but am not sure. Is there a way that I can eliminate
all entries with a field that is blank? ie:
if the table
Well as soon as I sent that previous message, I figured out
how to accomplish what I needed.
Thanks anyways.
Jeff Jones
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Dear MySQL Sirs,
I have been trying to compile and build the GUI for MySQL (in Linux) and
apparently the last stage of the installation has been given me a very
hard time...I have followed the instructions from the website and the
last error ocurred when I tried to run "make" within
Hi Everyone,
This question may have been asked before, but i could not find it in the
archives, so i was wondering if someone could help me out.
Say i had the following table:
+++-+
| id | address| domainalias |
Hi.
On Mon, Mar 19, 2001 at 04:19:32PM +0800, [EMAIL PROTECTED] wrote:
I want to use mysql_affected_rows to determine whether the sql statement is
executed or not found.
If mysql_affected_rows return 0,I take it as not found.
But If I update a value to the value it already was,
(It means if
Hi.
On Mon, Mar 19, 2001 at 02:40:43PM -0500, [EMAIL PROTECTED] wrote:
Hi all,
I'm new to MySQL and am puzzled by a curious problem. This join syntax has
always worked fine for me on SQLServer but it seems to work like an inner
join on MySQL:
SELECT d.doccat_ID, d.doccatname
FROM
I just downloaded the latest version on MySQL as well as the MYSQLGUI
program. I have MySQL installed and I can access it from the mysql
command line but I just can't get MYSQLGUI to connect. It keeps giving
me - Can't connect to local MySQL server through socket " (111) -
Can you tell me
Hi.
On Mon, Mar 19, 2001 at 09:06:49PM -0700, [EMAIL PROTECTED] wrote:
hist.id will never be NULL and 5 at the same time. Your clauses conflict
with each other.
You need to re-write your query.
This is ture, except the query suceeds if there is records in 'hist'
Even if it is not a
I am using mysqld_multi to have several different mysql servers start. I have
finally gotten it to work with php when I connect to a non-standard socket,
such as /tmp/mysql.sock2. Does anyone know how to connect to a database with
perl through that socket? I have tried the following with no
Hi.
On Tue, Mar 20, 2001 at 12:22:19PM +0100, [EMAIL PROTECTED] wrote:
Hi!
On Mar 20, Basil Hussain wrote:
Hi all,
The original message below was posted to the BugTraq mailing list. Have the
developers seen this? I know it talks about version mysql-3.20.32a (which is
ancient), but
The query returns 2 different result sets depending on whether the table on
the right side of a LEFT JOIN has records or not. I just don't see how this
is acceptable behavior. Either it should always return the result set or it
should always return the empty set. The size of the right table
Hi.
Disk speed and memory is more relevant than CPU speed most times, so
you should include that info in your comparison. And how big is your
table in bytes (not rows).
I would start with comparing the output of
mysqladmin variables
of all installation. Maybe some simply have a bigger key
I'm trying to diagnose a segmentation fault we're getting in mysql so I can
send a slightly decent bug report about it, and would like to get a core dump.
I CANNOT get it to dump core. I'm using the --core-file option. I've made
sure my ulimit to coredump size is set big enough. It just won't
Hello,
Still trying to get jpegs into my database. I have a blob column setup, How do I get
the jpeg into the blob column?
Thanks for the help
Mike
It would be my guess that you're trying to store inet_aton()'s value
into a signed integer column, which is in the range of roughly -2G - 2G-1,
while inet_aton()'s result is unsigned, in the range 0 - 4G-1. Whenever
inet_aton() happens to return a value 2G-1, MySQL truncates it and stores
into
Hi.
Ah okay, I as thought, I misunderstood your objection.
The behaviour is how Standard SQL defines it and what is to be
expected. You may want consider to do some reading on relational
database theory (don't take this proposal wrong...).
Aside from that, I agree, that sometimes the behaviour
On Wed, Mar 21, 2001 at 05:07:59AM +0300, [EMAIL PROTECTED] wrote:
please tell me about this error:
Fatal error: Call to unsupported or undefined function mysql_pconnect() in
mainfile.php on line 17
or
Fatal error: Call to unsupported or undefined function mysql_pconnect() in
Hi.
On Tue, Mar 20, 2001 at 02:09:48PM -0800, [EMAIL PROTECTED] wrote:
ok... this is stumping me perhaps I'm doing something wring, but It
doesn't appear that I am
Am I doing, or not doing something that makes the INET_ATON function
default to 127.255.255.255 ?
No, as you should
Hello,
is there anyway to execute a mysqldump command via the web and have the dump
stored on a file on the server. do any of the webinterfaces offer that?
any scripting languages?
thanks
randy
-
Before posting, please
Fatal error: Call to unsupported or undefined function mysql_pconnect()
in ./db_mysql.php on line 73
Wrong list. Help can be found via several lists: http://www.php.net
Before posting you really should read the manual, also found at php.net
Or try at least a few examples from:
Hi,
I've just ported from SQLServer where this query ran fine, however MySQL
gives an "invalid use of group function" error.
Any ideas?
thx
dan
select us.username, us.id as userid, count(*) as tips from UserTippingInfo
u, Matches m, Users us WHERE round = 23 AND us.id = u.userid AND
My slave stopped getting data from the master. Every 60 seconds, I get
an entry like this in the log file:
010321 2:23:07 Error reading packet from server: bogus data in log
event (read_errno 0,server_errno=65535)
I believe this occurs when I run an insert with a a very large (100's of
I just downloaded the latest version on MySQL as well as the MYSQLGUI
program. I have MySQL installed and I can access it from the mysql
command line but I just can't get MYSQLGUI to connect. It keeps giving
me - Can't connect to local MySQL server through socket " (111) -
Can you tell me
I appreciate your explanation. You may be correct about Standard SQL,
however I do not believe that this can be explained as a simple
cross-product. If a LEFT JOIN were implemented starting with a cross product
then NO LEFT JOIN would EVER return NULL in the right table. A pure cross
product
On 20-Mar-01 Jason Bell wrote:
ok... this is stumping me perhaps I'm doing something wring, but It
doesn't appear that I am
Am I doing, or not doing something that makes the INET_ATON function
default to 127.255.255.255 ? why does it work for 24.18.10.5, but not
192.168.50.5 when
Sorry for the ambiguity, I was trying to make a really generic select
statement. I just meant that if 'where a = A.a' has no matches, but 'where
b = B.b' or 'where c = C.c' does match, the query returns what did match,
and just returns null where it didnt. I will look at the CASE WHEN...THEN.
On 21-Mar-01 [EMAIL PROTECTED] wrote:
please tell me about this error:
Fatal error: Call to unsupported or undefined function mysql_pconnect() in
mainfile.php on line 17
or
Fatal error: Call to unsupported or undefined function mysql_pconnect() in
./db_mysql.php on line 73
Thanks
You
Regarding to the manual there is no difference between blob and text fields,
except that searching on text fields is case-insensitive and searches on
blobs are binary safe.
However, i'm quite stunned if you say you cannot use mysql_query to query
binary data, i've never experienced this problem:
On Wed, Mar 21, 2001 at 01:32:11AM -0700, [EMAIL PROTECTED] wrote:
I appreciate your explanation. You may be correct about Standard SQL,
however I do not believe that this can be explained as a simple
cross-product. If a LEFT JOIN were implemented starting with a cross product
then NO LEFT
Hi i got a problem.. =P
Im doing some test programming using Delphi and the myODBC driver in windows 2000 and
i get some strange stuff..
Example table in these examples
PICAB (table)
IDCounter int
NamnCHAR 100
EPostCHAR 100
Example 1.
Dont optimize column width and
On 21-Mar-01 WCBaker wrote:
Hi,
I can store and retrieve binary data in the form of image or sound files.
However, I wanted to store up to say, 10,000 bytes of textual data. Since
varchar has a 255 byte ceiling I thought that mediumblob might be nice for
this. I can store the stuff as
You are building a "many to many" relationship.
How to do it:
* Each staff member should have an unique ID (eg StaffMember_ID) in the
Staff table;
* Each subject has an ID in the SubjectTitles table;
* and you need a third table, with two fields: StaffMember_ID and
SubjectTitle_ID, plus extra
Get your RH7 RPMS for 3.23.35!
http://www.moongroup.com/stories.php?story=01/03/20/4439095
--
Chuck Mead, csm -AT- moongroup.com, Owner, MoonGroup.com
(Note: html formatted email sent to me is filtered deleted unread)
GnuPG Public Key Available: http://wwwkeys.us.pgp.net
On Tue, Mar 20, 2001 at 03:44:44PM -0800, Marcus Ouimet wrote:
I went into my database today and noticed that there was 102,000 entries.
Somehow a whole pile of crap was added to the end of the database. I think
it can easily be fixed but am not sure. Is there a way that I can eliminate
On 20-Mar-01 John Nielsen wrote:
Hi Everyone,
This question may have been asked before, but i could not find it in the
archives, so i was wondering if someone could help me out.
Say i had the following table:
+++-+
| id | address
Thanks for the info, however I'm struggling to understand how it applies to
my case. Following is the piece of code in question, and the error is due
to
the SELECT following the INSERT (insert works fine; LIGHTBOX_ID is on
AUTO_INCREMENT) :
// add a LIGHTBOX row ...
rs =
Hi,
I've just ported from SQLServer where this query ran fine, however MySQL
gives an "invalid use of group function" error.
Any ideas?
thx
dan
select us.username, us.id as userid, count(*) as tips from UserTippingInfo
u, Matches m, Users us WHERE round = 23 AND us.id = u.userid AND
Hi,
We're are a little worried about the ratio of tmp_disk_tables to
tmp_tables. We are assuming the created_tmp_tables from `mysqladmin
extended-status` represents the total number of temporary tables created
and created_tmp_disk_tables from `mysqladmin extended-status` represents
the
Disk speed and memory is more relevant than CPU speed most times, so
you should include that info in your comparison.
This is the fun part :). Machine which is the fastest with old mysql
and Debian has IDE HDD and 128 MB RAM, RH7 machine (dual PIII and new
mysql) has SCSI RAID and 512 MB RAM,
On Tue, Mar 20, 2001 at 03:12:39PM -0600, Jeff Jones wrote:
I am using mysqld_multi to have several different mysql servers start. I have
finally gotten it to work with php when I connect to a non-standard socket,
such as /tmp/mysql.sock2. Does anyone know how to connect to a database with
Hi John,
On Wed, Mar 21, 2001 at 09:51:10AM +1000, John Nielsen wrote:
Hi Everyone,
This question may have been asked before, but i could not find it in the
archives, so i was wondering if someone could help me out.
Say i had the following table:
I have GNU GCC 2.96 and when I run configure, I get the following error:
configure: error: installation or configuration problem: C++ compiler cannot
create executables.
any solution to this? Is 2.96 incompatable? Should I have a different
compiler?
Thanks,
Jason
On 20-Mar-01 Mike Baerwolf wrote:
Hello,
Still trying to get jpegs into my database. I have a blob column setup, How
do I get the jpeg into the blob column?
localhost.dread$ grep LOAD_ $MANUAL
`LOAD_FILE(file_name)'
SET blob_column=LOAD_FILE("/tmp/picture")
*
On 21-Mar-01 Randy Johnson wrote:
Hello,
is there anyway to execute a mysqldump command via the web and have the dump
stored on a file on the server.
yes.
$cmd="/usr/local/bin/mysqldump -u user -ppasswd db
$cmd .=" /path/to/dump/db.dmp";
system($cmd);
do any of the webinterfaces
Hi.
Don mailed this only to me, but from the content it was obviously
intended for the list (or at least [EMAIL PROTECTED]).
- Forwarded message from Don Read [EMAIL PROTECTED] -
From: Don Read [EMAIL PROTECTED]
To: Benjamin Pflugmann [EMAIL PROTECTED]
Subject: Re: update
Date:
Hi.
On Wed, Mar 21, 2001 at 11:57:09AM +0200, [EMAIL PROTECTED] wrote:
Disk speed and memory is more relevant than CPU speed most times, so
you should include that info in your comparison.
This is the fun part :). Machine which is the fastest with old mysql
and Debian has IDE HDD and
David Reid writes:
I just downloaded the latest version on MySQL as well as the MYSQLGUI
program. I have MySQL installed and I can access it from the mysql
command line but I just can't get MYSQLGUI to connect. It keeps giving
me - Can't connect to local MySQL server through socket "
[EMAIL PROTECTED] writes:
On 20.03.2001 14:48:58 Sinisa Milivojevic wrote:
Also, do you have clients that do not call mysql_close at the end ,
like PHP programs ?
Huh? According to the PHP manual, I always thought that it is unnecessary to
explicitly call mysql_close() in
BAUMEISTER Alexandre writes:
Bonjour Sinisa,
SM The above could indicate some timeout problem.
SM Can you build mysql --with-debug and start it with --debug and see in
SM the trace file when are the above timeouts reported ??
SM Also, do you have clients that do not call
Nick Pasich writes:
After upgrading from 3.23.32 to 3.23.35 I stopped getting statistics
when using mysqlimport. (Records: Deleted: Skipped: Warnings:)
I took a quick look at 3.23.32 mysqlimport.c and it is the same code as
3.23.35.
The command
---
mysqlimport
Rafael Martinez writes:
Hei
If I send a SELECT sql-request to my DB and this request returns an
"Empty set" ...
mysql_num_rows(MYSQL_RES *result) returns 0 - This is OK
but mysql_num_fields(MYSQL_RES *result) returns 1 - This is not OK ;-)
Why? Am I missing anything?
On Tue, Mar 20, 2001 at 03:12:39PM -0600, Jeff Jones wrote:
I am using mysqld_multi to have several different mysql servers start. I have
finally gotten it to work with php when I connect to a non-standard socket,
such as /tmp/mysql.sock2. Does anyone know how to connect to a database with
Heikki Tuuri writes:
Alex,
I looked at the new debug log you sent and obviously some client is
making connections to your server. This cannot come from
Innobase, there must be some client process running on your machine.
From the debug log I find the following:
Michelle DeCurtis writes:
I am running linux 6.2 (2.4 kernel) with MySQL3.23 installed. This kernel
allows MySQL3.23 to support large file sizes, up to 4 Gigs.
It looks like the mysqldump utility is still bound by the 2 GB file size
limit. Does anyone know how to get mysqldump to
S Lemmon writes:
Hi,
My main experience is with Informix databases, but am trying MySQL on
our web server (ver 3.23.33 running on Linux 2.2.16-3). In general
it's working well, but being a MySQL newbie I'm a bit mystified by
some odd select behavior.
With Informix, doing a
On Wed, Mar 21, 2001 at 07:31:20PM +1100, Daniel Kirk wrote:
Hi,
I've just ported from SQLServer where this query ran fine, however MySQL
gives an "invalid use of group function" error.
Any ideas?
thx
dan
select us.username, us.id as userid, count(*) as tips from UserTippingInfo
thanks I worked it out. SQLServer requires SELECT Count(*) as fieldname ...
ORDER BY Count(*). MySQL requires SELECT count(*) as fieldname ... ORDER BY
fieldname
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Fred van Engen
Sent: Wednesday, 21 March
Voytek Lapinski writes:
I'm trying to diagnose a segmentation fault we're getting in mysql so I can
send a slightly decent bug report about it, and would like to get a core dump.
I CANNOT get it to dump core. I'm using the --core-file option. I've made
sure my ulimit to coredump size
Hi!
On Mar 21, Benjamin Pflugmann wrote:
Hi.
On Tue, Mar 20, 2001 at 12:22:19PM +0100, [EMAIL PROTECTED] wrote:
Hi!
On Mar 20, Basil Hussain wrote:
Hi all,
The original message below was posted to the BugTraq mailing list. Have the
developers seen this? I know it talks
Thalis A. Kalfigopoulos writes:
Dear Santa,
here is my wishlist:
I wish that the mysql utility had support for the shell's history functions. I catch
mysql so many time doing something like !show
regards,
thalis
Hi!
First of all, Christmas is far away.
Second, mysql
Benjamin Pflugmann writes:
Hi.
On Tue, Mar 20, 2001 at 12:22:19PM +0100, [EMAIL PROTECTED] wrote:
Hi!
On Mar 20, Basil Hussain wrote:
Hi all,
The original message below was posted to the BugTraq mailing list. Have the
developers seen this? I know it talks about
Sinisa,
SM Alex, you ran out of filedescriptors or out of anodes, depending on OS
SM that you are using.
I though filedescriptors could be the problem. I only had 256. I
modified the system in order to have 1024 :
BAUMEISTER Alexandre writes:
Sinisa,
SM Alex, you ran out of filedescriptors or out of anodes, depending on OS
SM that you are using.
I though filedescriptors could be the problem. I only had 256. I
modified the system in order to have 1024 :
Hello.
I am interested to know the structure of MySQL. My ref book "MySQL and mSQL" by
O'Reilly states that for a table named book under a database Test following is the
structure:
book.ISM
book.ISD and
book. frm
On my system MySQL 3.23.27 beta the structure is different.
book.MYI
Yes, I think this is the problem. But how can I make a read/write lock with
only one lock?
Best regards,
Fabio.
--
De: Gerald L. Clark[SMTP:[EMAIL PROTECTED]]
Enviado el: Martes, Marzo 20, 2001 04:33 PM
Para: Fabio Galarraga
CC: 'Mysql mailing list'
Asunto: Re:
Sinisa,
SM Do you use thread cacheing ??
SM Please turn it off temporarily and see if problem reccurs.
Currently I have :
my.cnf
Sinisa,
SM SM Alex, you ran out of filedescriptors or out of anodes, depending on OS
SM SM that you are using.
SM
SM I though filedescriptors could be the problem. I only had 256. I
SM modified the system in order to have 1024 :
SM
SM
BAUMEISTER Alexandre writes:
Sinisa,
SM Do you use thread cacheing ??
SM Please turn it off temporarily and see if problem reccurs.
Currently I have :
my.cnf
BAUMEISTER Alexandre writes:
Sinisa,
SM SM Alex, you ran out of filedescriptors or out of anodes, depending on OS
SM SM that you are using.
SM
SM I though filedescriptors could be the problem. I only had 256. I
SM modified the system in order to have 1024 :
SM
Sinisa,
SM SM Do you use thread cacheing ??
SM
SM SM Please turn it off temporarily and see if problem reccurs.
SM
SM Currently I have :
SM
SM
SM my.cnf
SM
BAUMEISTER Alexandre writes:
Sinisa,
SM SM Do you use thread cacheing ??
SM
SM SM Please turn it off temporarily and see if problem reccurs.
SM
SM Currently I have :
SM
SM
SM
Sinisa,
SM SM SM Alex, you ran out of filedescriptors or out of anodes, depending on
OS
SM SM SM that you are using.
SM SM
SM SM I though filedescriptors could be the problem. I only had 256. I
SM SM modified the system in order to have 1024 :
SM SM
SM SM
Sinisa,
SM Ok, do not erase your binary, save it and try our binary for 2.7.
SM If you still get TCP errors, rebuilding MySQL will be the sole
SM solution.
First, we don't know if it's TCP errors isn't it ?
Second, the binary I'm using now is one I built on my own from the
sources.
BAUMEISTER Alexandre writes:
Sinisa,
Yes, for now. But in the final application, there will be a lot of
connections from network.
This entire problem with signal 14 can be due to PHP not using
mysql_close.
Please try to explicitely close connection at the programs exits
Sinisa,
SM Ok, do not erase your binary, save it and try our binary for 2.7.
SM If you still get TCP errors, rebuilding MySQL will be the sole
SM solution.
Another thing to underscore, is that with Mysql-3.23.33 built on my
own from the sources, I never had these messages in the log.
BAUMEISTER Alexandre writes:
Sinisa,
SM Ok, do not erase your binary, save it and try our binary for 2.7.
SM If you still get TCP errors, rebuilding MySQL will be the sole
SM solution.
First, we don't know if it's TCP errors isn't it ?
Second, the binary I'm using
Bonjour Sinisa,
SM BAUMEISTER Alexandre writes:
SM Sinisa,
SM
SM Yes, for now. But in the final application, there will be a lot of
SM connections from network.
SM
SM
SM
SM This entire problem with signal 14 can be due to PHP not using
SM mysql_close.
SM Please try to
BAUMEISTER Alexandre writes:
Bonjour Sinisa,
I've no PHP scripts accessing Mysql for now.
Only some little programs written in C which are connecting to Mysql
and doing some UPDATE on a few tables.
Alex.
And you have mysql_close at the end of them ??
Also,
Sinisa,
SM I've no PHP scripts accessing Mysql for now.
SM
SM Only some little programs written in C which are connecting to Mysql
SM and doing some UPDATE on a few tables.
SM
SM Alex.
SM
SM
SM
SM And you have mysql_close at the end of them ??
These are
Hi.
All your arguments are irrelevant regarding my post: Sergei stated
that MySQL 3.23 would not be vulnerable to the posted exploit and I
proved it is (respecting the rules given in the exploit). I never
argued about the impact of the exploit.
To be true, I am worried about the answers we get.
Alonso Guarisma writes:
Dear MySQL Sirs,
I have been trying to compile and build the GUI for MySQL (in Linux) and
apparently the last stage of the installation has been given me a very
hard time...I have followed the instructions from the website and the
last error ocurred when I tried
Benjamin Pflugmann writes:
Hi.
cut
Of course, that why I was explicitly talking about the fact, that the
user needs CREATE privileges (FILE privileges are not needed, If I am
not mistaken).
First of all, it is easy to reproduce a test case.
Second, that FILE privilege I
Sinisa,
SM Bonjour Sinisa,
SM
SM
SM I've no PHP scripts accessing Mysql for now.
SM
SM Only some little programs written in C which are connecting to Mysql
SM and doing some UPDATE on a few tables.
SM
SM Alex.
SM
SM
SM
SM And you have mysql_close at the
BAUMEISTER Alexandre writes:
Sinisa,
SM Bonjour Sinisa,
SM
SM
SM I've no PHP scripts accessing Mysql for now.
SM
SM Only some little programs written in C which are connecting to Mysql
SM and doing some UPDATE on a few tables.
SM
SM Alex.
SM
Sinisa,
SM These are daemon programs ... not exiting. I've about 10 programs
SM initialising a connection and then looping, doing some updates on
SM table while receiving data from another input.
SM
SM The schema is :
SM
SM1. Connecting to Mysql
SM2.
Hi,
I have a database which has a text field (let's name it title). The field
is NULL initially. Now I have about a hundred thousand records in the db,
where the title field is NULL. I have to fill these NULL title fields with
the appropriate data, so I have to select them one-by-one, calculate
BAUMEISTER Alexandre writes:
Sinisa,
If I had a thread on my daemons which executes a mysql_ping() each
30 secondes and increase net_read_timeout to 60 will it be ok ? Does
a mysql_ping() reset net_read and net_write timer ?
Alex.
Alex mon ami,
This is all
Hi.
Unfortunatly, again you don't answer to my mail, but only to a side
comment I made. :-(
On Wed, Mar 21, 2001 at 03:37:45PM +0200, [EMAIL PROTECTED] wrote:
Benjamin Pflugmann writes:
Hi.
cut
Of course, that why I was explicitly talking about the fact, that the
user needs CREATE
1 - 100 of 241 matches
Mail list logo