Dear Sir,
I am trying to connect to the MYSQL server running on web server say A, thru my
scripts which are hosted on web server say B.
I am not able to connect to the mysql server. I am using PHP for connecting to the
MYSQL server running on web server A.
Please let me know how can I connect
Is there any way I can delete in one table with information from another
table without doing as the following example?
SELECT column_name FROM table_1
"result = 1,2,3"
DELETE FROM table_2 WHERE column_name = 1
DELETE FROM table_2 WHERE column_name = 2
DELETE FROM table_2 WHERE column_name = 3
Re
MySQL doesn't support foreign keys. Did you bother checking the manual?
http://www.mysql.com/doc/M/i/Missing_Foreign_Keys.html
> Hello
>
> Does mysql support creating and dropping of foreign key constraints?
> i tried it.While creating foreign key constraints it doesn't dive
> any error
> but wh
>
> grant all privileges on *.* to jbrunk@"%"
>
> and it goes into the user table of the database mysql, and shows that the
> host that jbrunk is allowed to connect from is "%" but it won't let me
> connect from mysqlfront
did you "FLUSH PRIVILEGES" ?
Greetings,
Ansgar
-
Hi,
What version of MySQL are you using ?
How is price defined ? .. In the below example, I defined price as
float(9,2).
mysql> SELECT *
-> FROM a;
+---+
| price |
+---+
| 19.95 |
| 10.99 |
| 3.99 |
| 3.45 |
| 1.69 |
| 1.45 |
| 1.25 |
+---+
7 rows in set (0.01 sec)
mysql>
Jorge
When I issue your suggested commands here are the resulted rows..
mysql> SELECT price
->FROM shop
->HAVING price=MAX(price);
Empty set (0.01 sec)
But when I issue...
mysql> select price from shop order by price desc;
+---+
| price |
+---+
| 19.95 |
| 10.99 |
| 3.9
Hello
Does mysql support creating and dropping of foreign key constraints?
i tried it.While creating foreign key constraints it doesn't dive any error
but while dropping i do get some syntax errors.
what is the reason?
any suggetions?
regards
Div
--
At 9:19 AM +0530 6/28/01, Divakar wrote:
>Hi list
>
> I am a beginner in the field of mysql
>I would like to know whether it is possible to run sql scripts(a .sql file)
>in mysql.
>if yes please some body tell me how do we do that,.
The MySQL Reference Manual is your friend:
http://www.mysql.c
Hi list
I am a beginner in the field of mysql
I would like to know whether it is possible to run sql scripts(a .sql file)
in mysql.
if yes please some body tell me how do we do that,.
regards
Div
-
Before posting, please che
>> I get Duplicate entry errors quite frequently. As a rule in these
Well, as it turns out I found the solution right now myself. I am
testing locally (so nobody touches the tables but me) and delete
entries before I insert them again.
Here I have that strange error! The table is ok. What's
happ
A bit bizarre:
When I connect to MySQL through the localhost I have no problems; however
when I connect from a remote server I get the error "Can't initialize
character set 13 (path:default) in
The localhost and the remote host both have versions of MySQL installed (the
remote host doesn't
> I only want this INSERT INTO php sql script to run when the input button is
> pressed. How do I stop the script running when the page is loaded?
You have to make the query dependend on the action of the user.
So you put a condition into it:
if ($Submit) {
//do your thing
}
Your form calls
Re: large replaces truncating...
I'm still trying to figure out what's going on here.. I've now tried it in
PHP and am getting the same response... Ie, given this simple script:
The data field in the table truncates like this:
|
12750 12751 12752 12753 12754 12755 12756 12757
> Try to design your tables so, that it would be impossible to enter
> dublicate primary keys. And don't let users (if it's CGi application) to
> set or play with your primary keys (well, we could talk more about this
> one).
> If you used AUTO_INCREMENT, or UNIQUE, I bet you wouldn't have such
On Thu, 28 Jun 2001 10:36, Stephen Reynolds wrote:
> I only want this INSERT INTO php sql script to run when the input
> button is pressed. How do I stop the script running when the page is
> loaded?
>
> +++ Begin HTML Page +++
>
> //create database connection
> include("d:\bin\Apache\include\dbc
Hi there,
I'm using MaxSQL 3.23.39 and have set up an innodb table but when I run an
update statement the timestamp field does not update automatically. Is
anyone else experiencing this, or is it an expected behaviour of innodb
tables? I couldn't find anything in the manual saying that this
It is a binary colum
-
-sherzodR
phone: (517) 774-2702
email: [EMAIL PROTECTED]
On Wed, 27 Jun 2001, Tobias Eggendorfer wrote:
> Hi,
>
> I suppose I found a bug :-)
> According to LIKE in a SELECT-query is case-insensitive. In fact,
> it is, when using it on varcha
I only want this INSERT INTO php sql script to run when the input button is
pressed. How do I stop the script running when the page is loaded?
+++ Begin HTML Page +++
Test Script
First Name
Last Name
+++ End HTML Page +++
Regards, Steve
==
Stephen Reynolds
[EMAIL PROTECTED]
h
Try to design your tables so, that it would be impossible to enter
dublicate primary keys. And don't let users (if it's CGi application) to
set or play with your primary keys (well, we could talk more about this
one).
If you used AUTO_INCREMENT, or UNIQUE, I bet you wouldn't have such
problem.
Please, go through the manual found at http://www.mysql.com
-
-sherzodR
phone: (517) 774-2702
email: [EMAIL PROTECTED]
On Wed, 27 Jun 2001, Richard Bergeron wrote:
> Hi,
>
> I'm new to this flavor of SQL, I've downloaded WinMySQLadmin version 1.1 for Win98,
> I seem
>- Original Message -
>From: "phil" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Wednesday, June 27, 2001 6:06 PM
>Subject: Does MYODBC not support Lotus Approach
>I can't get it to work... does MYODBC not support Lotus Approach
Hi Phil,
I can confirm u that Approach can wor
Trond Eivind Glomsrød wrote:
> "wkd" <[EMAIL PROTECTED]> writes:
>
> > 1. (*) text/plain
> >
> > I'm setting up mysql for redhat 7.1 to be used with php and apache. However, in
>the past I've had problems with the setup. I had a person come in and setup mysql on
>redhat 6.0 ( 2 1/2 days later
(mysqlbug died because it couldn't find rmail. So, I'm sending this
manually.)
>Description:
I have a join pulling two columns (both named 'id') from two different
tables. When these results are returned, in the result set, they are both
called 'id', with no way to refer to them expli
At 11:56 PM +0200 6/27/01, Tobias Eggendorfer wrote:
>Hi,
>
>I suppose I found a bug :-)
>According to LIKE in a SELECT-query is case-insensitive. In fact,
>it is, when using it on varchars. But with a longblod, it is not.
>So if the table has column "test longblob" and there is a colum
>where te
> I suppose I found a bug :-)
> According to LIKE in a SELECT-query is case-insensitive. In fact,
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#BLOB
The only difference between BLOB and
Title: Blank
Can you use a raw partition with MySQL much
like you can with Oracle or Sybase?
Wyly Wade
Forefront Inc
1413 S. Howard Ave
Suit 104
Tampa Fl, 33606
813-253-2267
a blob is by definition case sensitive hence 'Binary Large Object' This
is not a bug but by design, If you want a non-Binary field to store
large text objects then you should be using the 'TEXT' data type not the
'BLOB' data type.
Tobias Eggendorfer wrote:
>
> Hi,
>
> I suppose I found a bug
At 5:46 PM -0500 6/27/01, Pete Kuczynski wrote:
>Thanks Paul!
>ps works great!
>I modified the database with a UNIQUE column like you recommended
>earlier, this will now help in the PHP script to trap the duplicate
>entry and advise the user of the dup.
But if hostname now has a UNIQUE index on i
Thanks Paul!
ps works great!
I modified the database with a UNIQUE column like you recommended
earlier, this will now help in the PHP script to trap the duplicate
entry and advise the user of the dup.
1
$result = mysql_query($query);
// check if row is returned, if yes error, if
>Hi,
>How would a word a select statment, to search a database for duplicate
>entries in one field.
>
>For example, the fields: device, hostname, IP, comments
>
>I want to find all instances where there my be two devices with the same
>hostname.
>
>Thanks!
>
>Pete
Sir, try the following.
SELECT
Are you using PHPBB? There might be better answeres at http://www.nukeforums.com/
I use the and my Filters seem to be fine but that is an interesting question you have.
Cheers
Mike
-Original Message-
FROM: Mark Wakim
TO: [EMAIL PROTECTED]
DATE: Wed 6/27/01 15:35
SUBJECT: deletin
Peter,
That comes pretty close to the distinct -thread in this mailinglist.
You might want to try:
SELECT device, count(hostname)
FROM your_table
GROUP BY device
HAVING count(hostname)>1;
This would display all devices with at least 2 (or more) hostnames.
If you always have the same IP address,
Werner Stuerenburg wrote:
>
> > I just updated MySQL 2.22 to 2.23 and when I went to restart the server,
> > I got this error message in the /var/lib/mysql/err.log file:
> > 010627 11:19:22 /usr/sbin/mysqld: Can't open file: 'host.ISM'. (errno:
> > -1)
> > mysqld ended on Wed Jun 27 11:19:22 PD
At 3:13 PM -0500 6/27/01, Pete Kuczynski wrote:
>Hi,
>How would a word a select statment, to search a database for duplicate
>entries in one field.
>
>For example, the fields: device, hostname, IP, comments
>
>I want to find all instances where there my be two devices with the same
>hostname.
SEL
Hi,
I suppose I found a bug :-)
According to LIKE in a SELECT-query is case-insensitive. In fact,
it is, when using it on varchars. But with a longblod, it is not.
So if the table has column "test longblob" and there is a colum
where test is set to "xxAbcdx", the query SELECT *
FROM
I get Duplicate entry errors quite frequently. As a rule in these
cases, I check whether a record with this key exists, and in case
it does not, take action and insert the record. So there is a
minimal time lag, where by chance someone else may have inserted
exactly that record. Am I right?
Anoth
On Wed, 27 Jun 2001 16:06:36 -0500, "Mark Wakim" <[EMAIL PROTECTED]> wrote:
Well depending how your tracking this person, and message related to him, I
would image some sort of an ID value assigned to the poster would be the easiest
means. something like:
DELETE FROM table_posts WHERE userid =
"wkd" <[EMAIL PROTECTED]> writes:
> 1. (*) text/plain
>
> I'm setting up mysql for redhat 7.1 to be used with php and apache. However, in the
>past I've had problems with the setup. I had a person come in and setup mysql on
>redhat 6.0 ( 2 1/2 days later he had it running) the progr
Hi,
I'm new to this flavor of SQL, I've downloaded WinMySQLadmin version 1.1 for Win98,
I seem to be missing components?
1. I can only create Databases not Tables?
2. I'm don't know which source editor/compiler I can use?
Can anyone help?
Thanks.Get more from the Web. FREE MSN Explore
> I just updated MySQL 2.22 to 2.23 and when I went to restart the server,
> I got this error message in the /var/lib/mysql/err.log file:
> 010627 11:19:22 /usr/sbin/mysqld: Can't open file: 'host.ISM'. (errno:
> -1)
> mysqld ended on Wed Jun 27 11:19:22 PDT 2001
See http://www.mysql.com/doc/R/
> Heikki> Well, mystery solved :). Except that why MySQL uses hours to
> Heikki> sieve away the extraneous rows in the first query.
>
> To be able to answer the question why:
>
> SELECT COUNT(*) FROM table1 WHERE col1=0 and col2=0
>
> Is slow, I would need to get an EXPLAIN for this query.
mysq
Hi,
How would a word a select statment, to search a database for duplicate
entries in one field.
For example, the fields: device, hostname, IP, comments
I want to find all instances where there my be two devices with the same
hostname.
Thanks!
Pete
--
___
P
At 9:23 PM +0200 6/27/01, Oscar E. Salninch wrote:
>I guess if you are updating user columns directly, you need to restart
>mysqld in order for changes to take effect... I think, that was a case
>with me...
Or issue a FLUSH PRIVILEGES query.
>
>- Original Message -
>From: "Juan" <[EMAIL
Hi everyone I know its very simple to delete or modify table's but what if someone is
swearing in your message board and your filters still let him in and its being
displayed in your board and you want to delete his post how do you do that?
Mark
([EMAIL PROTECTED])
At 11:25 AM -0500 6/27/01, Pete Kuczynski wrote:
>Hi,
>Can I connect to multiple databases on a 4.0 NT box? I created a test
>database on the same box that has the pre-production ddb, and I can not
>connect to it using the same PHP scripts [I redirected the scripts to
>look to the new test ddb] an
Hi,
I have problem running MySQL on RedHat 6.2 machine. After few hours of work I get
message: fork: resource
temporary unavailable and only rebooting helps. CPU utilisation is very low (more than
90% idle), so
I think there is something wrong with the memory usage. I have about 120 connection
Short answer: yes, there is a way to set it up programatically. Also, by
specify the driver, server, connect paramters, etc, you ca sometimes do a
DSN-less connection. I do that with an ODBCDirect connection under Access.
It doesn't work, however, when I try to attach tables.
Look on http:/
>
> I guess if you are updating user columns directly, you need to restart
> mysqld in order for changes to take effect... I think, that was a case
> with me...
>
I find a "mysqladmin flush-hosts" fixes it for me. WHY, no one
ever has figured out why. When one or more of the systems deci
I'm setting up mysql for redhat 7.1 to be used with php and apache. However, in the
past I've had problems with the setup. I had a person come in and setup mysql on
redhat 6.0 ( 2 1/2 days later he had it running) the program has been riddle with
bugs. The questions are: ( note: mysql is not in
Only the first timestamp is updated by MYSQL. Create two timestamp
fields. MySQL will maintain the first one. Set timestamp2 to null when
the record is created.
Regards,
Rich
At 10:54 AM 6/27/01 -0500, Pete Harlan wrote:
>TIMESTAMP is not the solution to his problem; he wants the date to
>
Hi!
> "Heikki" == Heikki Tuuri <[EMAIL PROTECTED]> writes:
Heikki> Monty,
Heikki> there is an SQL optimizer deficiency if a two-column index is used.
Heikki> (Added later: actually not, see the end of this email.)
Heikki> Ryan does the following query, for which there is a very good
Heikki>
How many people would be interested in this feature?
On Wed, Jun 27, 2001 at 01:46:05PM +0300, [EMAIL PROTECTED] wrote:
> Brannon King wrote:
>
> >Any plans for a natural sort? A query to the effect of
> >
> >ORDER BY [~] NATURAL ASC
> >
> >or
> >
> >ORDER BY [~] NATASC
> >
> >etc
Thanks, ravi. Have I missed that in the documentation? If it is not there,
could you guys include it please. I think It's a good one
-sherzodR
On Wed, 27 Jun 2001, Ravi Raman wrote:
> hi.
>
> assuming all inserts and updates never specify a value for UpdatedDate or
> CreationDate, on the init
Hello,
I just updated MySQL 2.22 to 2.23 and when I went to restart the server,
I got this error message in the /var/lib/mysql/err.log file:
010627 11:19:22 /usr/sbin/mysqld: Can't open file: 'host.ISM'. (errno:
-1)
mysqld ended on Wed Jun 27 11:19:22 PDT 2001
I've never seen this and can't fi
hi.
assuming all inserts and updates never specify a value for UpdatedDate or
CreationDate, on the initial insert:
mysql> insert into table (Info) values ('blahblahblah');
they will both be set to '20010627125429' or something.
any subsequent updates:
mysql> update table set Info='somethingelse'
I guess if you are updating user columns directly, you need to restart
mysqld in order for changes to take effect... I think, that was a case
with me...
- Original Message -
From: "Juan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 27, 2001 5:24 PM
Subject: Host "" is
i originally tried to do it with the /stand/sysinstall on bsd, and it
installs it fine, but i am using the program MySQLFront to try and access
it, and it keeps coming up "Host perm202-202.ij.net is not allowed to
connect to this mysql server" the host name perm202-202.ij.net is host of
my workst
Wait, I didn't get the following:
> an alternate solution is to have a table like this:
> Create table(
> UpdatedDatetimestamp(14),
> CreationDatetimestamp(14),
> Infovarchar(100)
> );
> as mysql only automatically updates the _first_ timestamp column in a ta
Thomas
You might want to consider to post a sample select from the table, some
things become apparent just then.
Hannes
On 6/27/01 3:35 AM, "Thomas Michael Koch" <[EMAIL PROTECTED]> wrote:
> Hey Hans - it didn't work (damn) but thank you for your reply and sorry
> about the accidental mail you
hi.
an alternate solution is to have a table like this:
Create table(
UpdatedDatetimestamp(14),
CreationDatetimestamp(14),
Infovarchar(100)
);
as mysql only automatically updates the _first_ timestamp column in a table.
hth.
-ravi.
-Original Message-
Well, almost true.
On insert, all timestamp fields are updated.
On update, only the first timestamp field is updated.
So, If you have two timestamp fields, you can get the result you want.
Pete Harlan wrote:
> TIMESTAMP is not the solution to his problem; he wants the date to
> default to now()
On 6/27/01 8:48 AM, "Sherzod Ruzmetov" <[EMAIL PROTECTED]> wrote:
That should work without errors and was one of my suggested ways (can still
be seen down below). The group by query works for me the same way like the
distinct query, given that all selected fields give you a unique combination
(so
I, c. Then you just have to INSERT INTO it NOW() manually, that works
On Wed, 27 Jun 2001, Pete Harlan wrote:
> TIMESTAMP is not the solution to his problem; he wants the date to
> default to now() when the record is created, not updated.
>
> There's currently no way to do this in MySQL; def
Sorry, for quoting the manual but this might be just another example where
it could have the answer right away:
Hannes
http://www.mysql.com/doc/D/A/DATETIME.html
> The TIMESTAMP column type provides a type that you can use to automatically
> mark INSERT or UPDATE operations with the current date
I can't get it to work... does MYODBC not support Lotus Approach
Regards
Phil
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To r
> *
> NAMEEMAIL AGE
> tom tom@mail23
> dicktom@mail76
> petepete@email 54
> davecool@mail 21
> steve steve@mail 17
> marycool@mail 89
> thomas tom@
> I'm very new to mysql and adminstration of database software in
Have you tried phpMyAdmin to manage your db? Recommended:
http://www.phpwizard.net/projects/phpMyAdmin/
--
Herzlich
Werner Stuerenburg
_
ISIS Verlag, Teut 3, D-32683
Hi!
downloaded mysql++-1.7.9 tar ball from www.mysql.com and attempted to
set it up..this is th eoutput when doing automake in the mysql++-1.7.9
directory, as said in the README
[root@171 mysql++-1.7.9]# automake
automake: Makefile.am: required file `./INSTALL' not found
automake: Makefile.am:
is there anyone who icq and who has a few minutes that might be willing to
help me out with the mysql install? i have been having some trouble, so i
figured i would check and see if there was anyone who could help a newbie
out.
Jason
Yup tons of tutorials! http://www.devshed.com/Server_Side/PHP/ has alot as well.
Including the Apache, MySQL , PHP setup step by step for newbies
Have fun
Massey
-Original Message-
FROM: Werner Stuerenburg
TO: loiseau
CC: [EMAIL PROTECTED]
DATE: Wed 6/27/01 10:19
SUBJECT: Re[2]: que
Hi,
Can I connect to multiple databases on a 4.0 NT box? I created a test
database on the same box that has the pre-production ddb, and I can not
connect to it using the same PHP scripts [I redirected the scripts to
look to the new test ddb] and all I had is my PHP trap statment "Unable
to connect
When i install php3 module in apache server i see this:
/usr/www/bin > ./apachectl configtest
Syntax error on line 22 of /usr/www/conf/httpd.conf:
Cannot load /usr/www/libexec/libphp3.so into server: Undefined symbol
"_uncompress" in httpd:/usr/local/mysql/lib/mysql/libmysqlclient.so.10.0
OS: Fr
When i install php3 module in apache server i see this:
/usr/www/bin > ./apachectl configtest
Syntax error on line 22 of /usr/www/conf/httpd.conf:
Cannot load /usr/www/libexec/libphp3.so into server: Undefined symbol
"_uncompress" in
httpd:/usr/local/mysql/lib/mysql/libmysqlclient.so.10.0
OS: Fr
TIMESTAMP is not the solution to his problem; he wants the date to
default to now() when the record is created, not updated.
There's currently no way to do this in MySQL; default values must be
constants.
--Pete
> hi.
>
> check out the TIMESTAMP column type...maybe TIMESTAMP(14) as the colum
Try this:
CEATE TABLE new_table
SELECT DISTINCT NAME, EMAIL, AGE
FROM whatever_table
On Wed, 27 Jun 2001, tom harrow wrote:
> Actually I now realise that im solving the wrong proplem.
>
> here is a simplified version of my dilema
>
> *
> NAME EM
Well, I can say that the problem is becasue of GROUP BY clause.
I'd say its use in that query is void isn't it?
Correct me if I'm wrong, but as far as I know, there should be summary
functions in your select, which I cannot see in yours. So it should give
you an error
-sherzdoR
On Wed, 27 Jun
Hi,
When I try to connect from another machine (using MySQL Front) I'm getting
the following error message:
==
Error
Connection failed
1130 - Host "" is not allowed to connect to this MySQL Server
==
I chang
Hello Matthew,
I posted this earlier today but maybe you didnt get the message.
This definitely works for me, and its definitely an AND search (example):
SELECT author, title, year, recommend, copy, publ_desc, publ_loc,
CEILING(IF(MATCH author AGAINST ( 'Adams') > 0, IF(MATCH title AGAINST
('P
Your inner loop usage of $sth overwrites the result set of the outer loop.
Use a different variable.
Hannes Niedner wrote:
> I am having trouble with DBI. I wrote a little script that should update
> fields in one table (uid_test) based on values in another table (merge). I
> updates one row and
mysql fans,
I'm very new to mysql and adminstration of database software in
general. I'm not clear as to how the permissions of mysql work,
specifically, there is a root user (on the database, not the system) which
has special privileges to perform certain tasks. If I understand
correctly, othe
> Suppose a user can add a new row to a database in a PHP page with a form,
> and after submit, the next page he will see is a page displaying part of
> the same database, hopefully with his new row on top. Questions: A) will he
> always see the new data which he entered just a second before?
Y
> What is the best way to deal with both single and double quotation marks
> ' "
> when using php and mysql? I seem to be generating a lot of errors due to
> these special characters.
use functions addslashes and stripslashes when inserting and
retrieving, resp.
See http://php.net/manual/en/fun
What exactly is the problem? There are some tutorials out there,
for example
http://sourceforge.net/projects/phptriad/
>>any advice on setting up PHP4 in collabaration with MySQL on Win98?
>>thanx...
--
Herzlich
Werner Stuerenburg
_
Tengo una base de datos en Mysql pero programando en visual foxpro no me regresa la
informacion
no se, si hay que hacer algo en especial ??
el codigo en que hace la conexion es el sig.
STORE SQLCONNECT('Sipaae') TO db_conec
IF db_conec <= 0
= MESSAGEBOX('Falla al Conectarse al
> You'll find mysqldumpslow (in the mysql distribution) does all that and
> much much more
Sorry, not on my server (MySQL 3.22.32).
> It's a pity that it's not mentioned in the online documentation
> since it's a _very_ useful tool.
http://www.mysql.com/udmsearch/search.php?q=mysqldumpslow
sho
Perhaps the tmp directory used by MySQL was full.
Dawn H wrote:
> Occasionally, MySQL seems to lock up on the Linux box and just sit there. It
> did it today for three hours before we realized it. When this happens, the
> only thing we know of to do is restart it, and this time it wouldn't shut
Actually I now realise that im solving the wrong proplem.
here is a simplified version of my dilema
*
NAMEEMAIL AGE
tom tom@mail23
dicktom@mail76
petepete@email 54
davecool@mail 2
Hannes...
The last scenario is exactly the problem i have... when i try to use your
example i get an error with the sql
when creating the table do i have to specify the data type or anything like
that or should it be as simple as
CREATE table distinct_records
SELECT field_1, field_2, field_3
FR
Monty,
there is an SQL optimizer deficiency if a two-column index is used.
(Added later: actually not, see the end of this email.)
Ryan does the following query, for which there is a very good
index on (parentmsgid, clean). But from the printout below we
see that though MySQL uses the right key,
any idea where any sort of documentation/tutorial can be found?
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 27, 2001 1:45 PM
To: Nathanial Hendler
Cc: Mysql; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Perl Script: MySQL Slow Query Log Parser
i've never had any problem...
Le Wed, 27 Jun 2001, stompbot :
>greetings,
>
>any advice on setting up PHP4 in collabaration with MySQL on Win98?
>thanx...
>
>
>-
>Before posting, please check:
> http://www.mysql.com/man
Cristian Paslaru writes:
>
> The case for this patch is that you can do sql queries with 1.1e+1 to say,
> or 1.1e01, but if you try 1.1e1 will give you an error.
>
> I try it on MySQL 3.23.39 and 3.23.33. I think this is a very old and not
> seen bug.
>
> Regards.
>
> --
> Cristian Paslaru
>
Use a backup powersupply and shutdown software to gracefully shutdown
after a power fail.
Yaw Ofori-Adjei wrote:
> I have used MySQL for about 2 years nowand I love it.
> My only problem is that I am in africa were power
> fluctuations are rampant. I usally get table handelr
> error 127 after ev
[No David, the result set that suddenly goes to 0 is, or should not be
empty, it is the result of a SELECT with no WHERE - and there were no
deletes yet]
For the first time developing a PHP-MySQL system, I am experiencing strange
things. Perhaps it is the off-line mode (Localhost) I am running
At 19:33 27/06/2001 +0100, Maria Aurora VT de la Vega wrote:
Hola,
Verifica primero si en el SCM ya existe el servicio llamado
mysql instalado.
Si existe, entra en el prompt del DOS, y remueválo con el
comando: d:\mysql\bin\mysqld-nt --remove
Después de eso, edita el archivo my.cnf de la siguien
> In any case, the problem is not with Mysql - perhaps if you were to
> enquire on the PHP list with a code sample?
Also, it is a good idea to shut down mysql and restart it to see
changes written to disk, which is fine to recover memory leaks
unde Win, too. I wrote a batch
cd c:\mysql\bin
mysql
Running Unix, Apache, MySQL and PHP, should I worry about delay times, and
will the server always present the user with the latest database update
(after a possible delay)?
Suppose a user can add a new row to a database in a PHP page with a form,
and after submit, the next page he will see is
You'll find mysqldumpslow (in the mysql distribution) does all that and
much much more
It's a pity that it's not mentioned in the online documentation
since it's a _very_ useful tool.
Tim.
On Mon, Jun 25, 2001 at 11:59:59PM -0700, Nathanial Hendler wrote:
> I wrote a perl script that will parse
Tiago Luchini writes:
> On MySQL manual one reads:
>
> "Here are some open issues for anyone who might want to help us with the
> Windows release:
>
>* Make a single-user `MYSQL.DLL' server. This should include
> everything in a standard *MySQL* server, except thread creation.
> T
Why do you think that this patch is necessary ??
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.
1 - 100 of 128 matches
Mail list logo
