Sure, the directory exists. :)
Rgds
--Jerry
-Original Message-
From: Matthew Smith [mailto:[EMAIL PROTECTED]]
Sent: 2002Äê11ÔÂ19ÈÕ 15:51
To: Yu, Jerry; [EMAIL PROTECTED]
Subject: RE: one mysql-test issue
Does the directory /usr/local/mysql/var/run exist?
If not, try creating it!
Hi All,
Here are my two main security issues.
1) (valid) user does a sudo to root and runs strings db name.MYD - out
drops all the sensitive text
2) (clever) user gets hold of the application user/password for MySQL (it's
in the app config somewhere) - they run mysql --user=foo --password=bar
Does it have write permissions for the user running the tests?
M
-Original Message-
From: Yu, Jerry [mailto:[EMAIL PROTECTED]]
Sent: 19 November 2002 08:03
To: Matthew Smith; Yu, Jerry; [EMAIL PROTECTED]
Subject: RE: one mysql-test issue
Sure, the directory exists. :)
Rgds
--Jerry
Jeremy Zawodny wrote:
On Mon, Nov 18, 2002 at 05:41:51PM +0100, Stefan Bohm wrote:
when upgrading the master in a master slave setup from 3.23.x to
4.0.x or downgrading back to 3.23.x the binlog seems to be corrupt
for the slaves. I get error messages like binlog truncated or
'unexpected
On Mon, 2002-11-18 at 17:01, OYNot wrote:
[snip]
//The following was supposed to create a count, by day, of the unique ip
addresses.
You can use the date_format() to convert timestamps and dates into
whatever format you want.
I think you only need a single query like:
select ip,
I run the mysql-test as root.
-Original Message-
From: Matthew Smith [mailto:[EMAIL PROTECTED]]
Sent: 2002Äê11ÔÂ19ÈÕ 16:25
To: Yu, Jerry; [EMAIL PROTECTED]
Subject: RE: one mysql-test issue
Does it have write permissions for the user running the tests?
M
-Original Message-
Hi all,
Not sure if I should be using distinct, or some sort of complex WHERE query,
so here goes:
I have two related tables:
threads
id,udi,message,stamp
replies
id,thread_id,uid,message,stamp
(the stamps are unix timestamps)
What I'd like to do select * from the table threads, selecting
vvM HI
vvM still not working :-(
vvM I didn't do the installation , Do we need to set any option
vvM specifically during the installation for foreign key to work??
The InnoDB is loaded ?
please run
show variables like '%innodb%';
and put here.
tnks.
sql,query
I have a problem with key creation :
Server version: 4.0.4-beta-max-nt Binary version
PC : DELL OPTIPLEX GX100
OS : Windows 2000 Professional
RAM: 256 Mb
C:\mysql\binmysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8 to server version:
In the 4.0.5 version the problem is still alive. Have some notice about this
problem will be solved ?
Tks in advance.
Massimo
- Original Message -
From: miguel solórzano [EMAIL PROTECTED]
To: Massimo Petrini [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: Heikki Tuuri [EMAIL PROTECTED]
Sent:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 18 November 2002 19:52, Steven Roussey wrote:
:( Sadly, 4.0.5 does _not_ fix this issue. I just tried it and our load
went from 1 to 145 in 20 seconds...
Thanks for the info! I don't get it. We will investigate, why this problem has
The log put this error :
InnoDB: Error: table ./wnotas25/ITEMREC has no primary key in InnoDB
InnoDB: data dictionary, but has one in MySQL!
This error is normal ? if not , what is the command to *fix* this ?
Tnks ;)
sql,query
FYI:
I experience a memoryleak with winmysqladmin.exe on win2000 with the latest updates.
Sometimes i shutdown the server through the trayicon - after short time the system
runs out of memory. Killing the winmysqladmin.exe
process makes things work as normal again
i use mysql 3.23.53-max-nt
Description:
Mysqld has some trouble with hostname resolution.
My server has several IP and I want to bind on one of them :
--bind-addresse=servername
But it doesn't work. Mysqld always bind on the IP which
is given by `hostname -i`.
Fix:
By
Hello !
I recent migrate from 3.23 to 4.0.5 version and
in my server , i set the Default table type to InnoDB. it works as
well, but my temporary tables crashes mysqlserver on truncate command, the logdump is:
- start here
mysqld got signal 11;
This could be because you hit a bug. It is
On Mon, 18 Nov 2002, Kevin Lewandowski wrote:
I'm using mysql fulltext indexes and want them to see words of 2 or
more characters, and no stopwords. I've edited the appropriate files
(ftdefs.h, ft_static.c), then recompile, install, restart mysql,
rebuild indexes, and there is no change. It
* Fraser Stuart
Here are my two main security issues.
1) (valid) user does a sudo to root and runs strings db name.MYD - out
drops all the sensitive text
2) (clever) user gets hold of the application user/password for
MySQL (it's
in the app config somewhere) - they run mysql --user=foo
Dyego,
- Original Message -
From: Dyego Souza do Carmo [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Tuesday, November 19, 2002 1:35 PM
Subject: The Error in InnoDB upgrading from 3.23.53 to 4.0.5
The log put this error :
InnoDB: Error: table ./wnotas25/ITEMREC has no
If it makes you feel better, your not the only one with this problem. I ran
into it as well and still have the problem from time to time. Any clues as
to why?
-Original Message-
From: Jon Finanger [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 19, 2002 5:56 AM
To: Dyego Souza do
Hello ,
I need help with heap tables and calculating memory usage. I checked
in the Manual and found a formula, but I need help
deciphering it ;)
The memory needed for one row in a HEAP table is:
SUM_OVER_ALL_KEYS(max_length_of_key + sizeof(char*) * 2)
+ ALIGN(length_of_row+1, sizeof(char*))
/*
$var=some long text
or
$var='some long text'
*/
if (!mysql_query(INSERT INTO table(field) VALUES($var))) die(Always
die);
/*
1. MySQL doesn't insert the content of the variable $var into the field
table wich is a VARCHAR type or TEXT type
2. table contains other fields - type
The actual query is :
SELECT * FROM PROFILES WHERE fname=scott ORDER BY lastused;
The lastused field is of type date, and I want the returned result set to be
ordered by that date.
Thanks - Scott Carter
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Monday,
Hi All,
(sorry if this is a duplicate -- I don't think the original made it)
Running mysql 3.23.53-max binary on a RedHat 7.2 based server. Replication
is working fine, but I'm running into errors with the replicate-rewrite-db
directive. Here's a snippet from my my.cnf file on the slave:
* Erumba Gotha Henri
/*
$var=some long text
or
$var='some long text'
*/
The kind of quoting used within PHP does not matter to mysql.
if (!mysql_query(INSERT INTO table(field) VALUES($var))) die(Always
die);
/*
1. MySQL doesn't insert the content of the variable $var into
Wouldn't you need if
(!mysql_query(INSERT INTO table(field) VALUES('$var'))) die(Always die);
?? (Put the $var in single quotes, as it's a text field)
Nick Elliott
- Original Message -
From: Erumba Gotha Henri [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, November 19, 2002
At 9:06 -0600 11/19/02, Carter, Scott wrote:
The actual query is :
SELECT * FROM PROFILES WHERE fname=scott ORDER BY lastused;
The lastused field is of type date, and I want the returned result set to be
ordered by that date.
Still need more info. What dates are in the records with scott and
Dyego,
- Original Message -
From: Dyego Souza do Carmo [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, November 19, 2002 2:33 PM
Subject: Bug on MySQL4.0.5 with InnoDB+TEMPORARY TABLES ?
Hello !
I recent migrate from 3.23 to 4.0.5 version and
in my
wow!
that's known as above and beyond the call of
duty. hope the newbies appreciate your work.
Here's a mini-tutorial on left join that should solve your problem.
First, let's make a smaller example. (It would have been helpful if
you had done that and formatted your select so it
Hi.
On Mon 2002-11-18 at 17:05:23 -0800, [EMAIL PROTECTED] wrote:
Hello ,
I need help with heap tables and calculating memory usage. I checked
in the Manual and found a formula, but I need help
deciphering it ;)
The memory needed for one row in a HEAP table is:
sizeof(char*) is 4 on
At 16:22 +0100 11/19/02, Thomas Spahni wrote:
On Mon, 18 Nov 2002, Kevin Lewandowski wrote:
I'm using mysql fulltext indexes and want them to see words of 2 or
more characters, and no stopwords. I've edited the appropriate files
(ftdefs.h, ft_static.c), then recompile, install, restart
Thanks, Jeremy.
At 03:14 PM 11/18/2002 -0800, Jeremy Zawodny wrote:
mytop -- http://jeremy.zawodny.com/mysql/mytop/
That's what I wrote it for.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hi,
I'm trying to delete from a table where col = null, but it doesn't
seem to work. I don't see anything in the manual that says that =
can't be used in the where clause of a delete statment, but:
mysql select * from t;
++--+
| id | num |
++--+
| 1 | NULL |
| 1 | NULL |
Jan,
- Original Message -
From: Jan Steinman [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Tuesday, November 19, 2002 4:37 AM
Subject: InnoDB != FULLTEXT?
I'm interested in using InnoDB, but am loathe to give up FULLTEXT
indexing.
Anyone (Heikki?) know why this is so,
David,
I get the same behaviour with mysql 3.23.47 (not max) and with mysql v
4.0.4-beta
Without the index it works fine. Must be a bug
Cheers,
Andrew
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 19 November 2002 16:45
To: [EMAIL PROTECTED]
You should use IS NULL or IS NOT NULL query.
--
Chung Ha-nyung alita@[neowiz.com|kldp.org]
SayClub http://www.sayclub.com
NeoWiz http://www.neowiz.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 20, 2002 1:45 AM
To: [EMAIL
In the meantime, Jan, you don't have to commit your whole database to one
table type. Consider using MyISAM tables where you need fulltext search and
InnoDB for your other data.
Arthur
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 19, 2002 12:02
Nothing can be compared to null, not even null, which implies that MySQL is
wrong in returning two rows in the SELECT. Your query needs to say IS NULL:
delete from t where id = 1 and num is null;
Arthur
-Original Message-
From: Andrew Braithwaite [mailto:[EMAIL PROTECTED]]
Sent:
There might be ten different records with a fname of scott and the dates
might be 2002-11-18, and 2002-11-10 and 2002-10-15. When the query results
are returned the ORDER BY clause seems to have no effect on the results. I
would want the record with the most current date to be returned first,
Nothing can be compared to null, not even null
This is not so...
mysql select NULL = NULL;
+---+
| NULL = NULL |
+---+
| 1 |
+---+
1 row in set (0.00 sec)
As explained in the manual
http://www.mysql.com/doc/en/Comparison_Operators.html
= is a NULL
At 11:37 -0600 11/19/02, Carter, Scott wrote:
There might be ten different records with a fname of scott and the dates
might be 2002-11-18, and 2002-11-10 and 2002-10-15. When the query results
are returned the ORDER BY clause seems to have no effect on the results. I
would want the record with
At 12:38 -0500 11/19/02, Arthur Fuller wrote:
Nothing can be compared to null, not even null, which implies that MySQL is
wrong in returning two rows in the SELECT. Your query needs to say IS NULL:
delete from t where id = 1 and num is null;
Arthur
That is false. The = operator is like =
Hi!
I wrote in a little while ago about getting unique visits to a website
listed by day. Martin Waite came up with a very nice formulation, which
does wonders!
However, I have done something that is now yielding inconsistent results.
The screen shot is basically like this:
Day by Day Summary
Hi.
On Tue 2002-11-19 at 12:38:33 -0500, [EMAIL PROTECTED] wrote:
Nothing can be compared to null, not even null, which implies that MySQL is
wrong in returning two rows in the SELECT.
I have to disagree. The = operator is explicitly defined to allow
that. = is the same as =, except that it
The manual calls '=', which was added in 3.23.0, the 'null safe
operator', and says...
- If one or both arguments are `NULL', the result of the comparison is
`NULL', except for the `=' operator.
- indexes can use = and =
but the = operator is not in SQL92, and AFAIK no other major db supports
Thanks, John (and Mark), for your comments.
I was inspired to write something, because it seems to be hard to find any
explanation of LEFT JOIN. I looked through the half dozen SQL books on my
shelf and at the reference manuals for MySQL and DB2. All of them had a
brief example of the
David,
Monday, November 18, 2002, 2:53:33 AM, you wrote:
DW I am trying to install mysql-3.23.53a-pc-linux-gnu-i686 to my linux kernel
DW 2.2.14(Caldera OpenLinux 2.4). I follow throught the installation porcess
DW in the documentation in the mysql.com web site.
DW I am using bash shell, here is
Zabel,
Monday, November 18, 2002, 6:35:06 PM, you wrote:
ZI I've having trouble figuring out the SQL to do this.
ZI I have two tables, user, and group_map, and I want to insert a row into
ZI group_map for every row in user.
ZI user
ZI
ZI user_id
ZI group_map
ZI
ZI
krisbekkers,
Monday, November 18, 2002, 11:55:37 PM, you wrote:
katdb I have a 'simple' question regarding the mysql privileges.
katdb The database at home:
katdb version 4.04 beta max
katdb all of my tables are innodb tables. (except the mysql privileges table)
katdb As of version 4.02 of
vinita,
Tuesday, November 19, 2002, 2:06:01 AM, you wrote:
vvM still not working :-(
vvM I didn't do the installation , Do we need to set any option
vvM specifically during the installation for foreign key to work??
Check that your both tables are InnoDB:
SHOW TABLE STATUS LIKE
Siomara,
Sunday, November 17, 2002, 5:16:06 PM, you wrote:
SP Can someone help on this question?
SP I have downloaded and intalled succesfully mysql-max 4.0.4. However, when I
SP checked the information I stored via insert statements, I noticed weird
SP characters placed in the positions of
Stefan,
Sunday, November 17, 2002, 5:12:52 PM, you wrote:
SH yesterday I imported some tables from MS Access via ODBC into my brand
SH new MySQL 4.0.4 server. Everything went fine, but the tables did not
SH have a primary key, so I did the following:
SH mysql ALTER TABLE auftrag CHANGE Nummer
Á¤,
Tuesday, November 19, 2002, 6:10:44 AM, you wrote:
ÁÇ I'm setting up two servers as one master and one slave, and the slave will
take over
ÁÇ master's role when the original master fails.
ÁÇ I'd like to turn off log_bin in slave and turn on it only when the slave
becomes a master.
Roger,
Monday, November 18, 2002, 9:56:05 PM, you wrote:
RW I'm running MySQL 323 under Win 2000 SP2. I'm using Apache 2.0.43 and Cold Fusion
MX. I have this Cold Fusion
RW application that has worked well under MS-Access but when i ported it to MySQL the
Swedish characters ÅÖÄ åöä
RW in the
J.,
Monday, November 18, 2002, 12:32:35 PM, you wrote:
JCO Try this:
JCO mysql CREATE TABLE a (
JCO id int NOT NULL PRIMARY KEY,
JCO des varchar(20) default NULL
JCO );
JCO Query OK, 0 rows affected (0.00 sec)
JCO mysql INSERT INTO a VALUES (1,'pepe'),(2,'juan'),(3,'mariano');
JCO Query OK,
Massimo,
Tuesday, November 19, 2002, 12:35:46 PM, you wrote:
MP In the 4.0.5 version the problem is still alive. Have some notice about this
MP problem will be solved ?
This bug is not fixed yet, we gonna fix it later.
--
For technical support contracts, goto
Angeloluca,
Tuesday, November 19, 2002, 12:21:58 PM, you wrote:
AdBamdc I have a problem with key creation :
AdBamdc Server version: 4.0.4-beta-max-nt Binary version
AdBamdc PC : DELL OPTIPLEX GX100
AdBamdc OS : Windows 2000 Professional
AdBamdc RAM: 256 Mb
[skip]
AdBamdc 236 Is the maximum
Yeah, I've experienced the same thing -- if I leave my computer
unattended it just saps memory until I start getting complaints from
Windows about VM usage. Same deal -- W2K with all the updates.
-JF
-Original Message-
From: Jon Finanger [mailto:[EMAIL PROTECTED]]
Sent: Tuesday,
insert into group_map (user_id, group_id)
select distinct user_id , some algorithm for group_id
from user ;
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 19, 2002 10:52 AM
To: [EMAIL PROTECTED]
Subject: re: Insert row in x for every row in y
The problem is the command is not ordering in either direction. The ORDER
BY clause does not seem to have any effect at all. Maybe ORDER BY is not
the right solution.
If I want to return records sorted by a column of date type, how do I do
this?
Thanks - Scott Carter
-Original
order by date_format(mydate,'-mm-dd') desc
-Original Message-
From: Carter, Scott [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 19, 2002 11:30 AM
To: 'Doug Durham'; '[EMAIL PROTECTED]'
Subject: RE: simple question
The problem is the command is not ordering in either direction.
Hi,
Does the MySQL C API function mysql_real connect allocate memory or do I
need to do it? This is what my code currently does:
MYSQL *mysql;
mysql = new MYSQL
mysql_init(mysql);
mysql_real_connect(mysql, host, user, password, dbase, 0, 0, 0);
Thanks,
Anna
Egor Egorov wrote:
Roger,
Monday, November 18, 2002, 9:56:05 PM, you wrote:
RW I'm running MySQL 323 under Win 2000 SP2. I'm using Apache 2.0.43
and Cold Fusion MX. I have this Cold Fusion
RW application that has worked well under MS-Access but when i ported
it to MySQL the Swedish characters
Ah ha.
Discovered the problem, hosts.allow/hosts.deny was configured to only allow
connections from one host. The thing that
was confusing was that it allowed the initial connection, but then closed it. But I
guess that makes sense in a way.
But it still a small stupid thing, so look out for
Daniel Griggs wrote:
Ah ha.
Discovered the problem, hosts.allow/hosts.deny was configured to only
allow connections from one host. The thing that
was confusing was that it allowed the initial connection, but then
closed it. But I guess that makes sense in a way.
But it still a small stupid
Hi, all,
sql, query.
I am scheduling a cronjob to backup mysql database using mysqldump.
mysql@/usr/local/mysql/output /usr/local/mysql/bin/mysqldump -umysql
-pmysqlpw --opt nondb bkp1.sql 2 err.log
Ambiguous output redirect.
I thought that option was only available on version 4.0 and above? I'm
using 3.23.52-max.
thanks
On Tuesday, November 19, 2002, at 07:22 AM, Thomas Spahni wrote:
On Mon, 18 Nov 2002, Kevin Lewandowski wrote:
I'm using mysql fulltext indexes and want them to see words of 2 or
more characters,
Greetings
You dont have to do mysql = new mysql;
it is dont automatically.
Rgds
Insane
SQLyog - The Definitive Win32 MySQL Front End
http://www.webyog.com/sqlyog/download.html
- Original Message -
From: Anna Fowles-Winkler [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday,
Greetings
MySQL-Front has problems with User Manager module. It does not creates
permission correctly.
Try SQLyog at http://www.webyog.com/sqlyog/download.html
Rgds
Insane
- Original Message -
From: Victoria Reznichenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, November
Ok, so it seems to be a bug. What's the procedure for reporting it (or
do the developers read this list?)
-David
A minimal test case that demonstrates the bug:
create table t (
id integer,
index id_idx(id)
);
insert into t(id) values(null);
select * from t;
delete from t where id = 1;
I have tried 4 mirrors in USA to download mysql source for 4.0.5
seems like
the file is missing. Is anyone else having the same problem?
Ken
-
Ken Menzel ICQ# 9325188
www.icarz.com [EMAIL PROTECTED]
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 19 November 2002 12:19, Lenz Grimmer wrote:
On Monday 18 November 2002 19:52, Steven Roussey wrote:
:( Sadly, 4.0.5 does _not_ fix this issue. I just tried it and our load
went from 1 to 145 in 20 seconds...
Thanks for the info! I
At 15:58 -0500 11/19/02, David Mechner wrote:
Ok, so it seems to be a bug. What's the procedure for reporting it
Check the manual:
http://www.mysql.com/doc/en/Bug_reports.html
-
Before posting, please check:
At 20:45 + 11/19/02, Jannie Qu wrote:
Hi, all,
sql, query.
I am scheduling a cronjob to backup mysql database using mysqldump.
mysql@/usr/local/mysql/output /usr/local/mysql/bin/mysqldump
-umysql -pmysqlpw --opt nondb bkp1.sql 2 err.log
Ambiguous output
Hi there,
My MySQL LEFT JOIN Syntax as following is wrong? I
cannot get the right result.
SELECT name, email form T1 LEFT JOIN T2 ON
T1.Snum=T2.Bnum
T1(Snum,name,email,address)
T2(Bnum, notes, time)
I wnat ot get the result(name, email, notes).
Any suggestion, comments?
HI Victoria, Harald, Dyego
you all were right, the database is not supporting the InnoDb tables;
I configure it with --with --innodb option add innodb_data_file_path
to the my.cnf. Now it's working!!
Thank you so much
Vinita
sql
Dyego Souza do Carmo wrote:
vvM HI
vvM still not working
In the last episode (Nov 19), Ken Menzel said:
I have tried 4 mirrors in USA to download mysql source for 4.0.5
seems like the file is missing. Is anyone else having the same
problem?
ftp://mirror.mcs.anl.gov/pub/mysql/Downloads/MySQL-4.0/mysql-4.0.5-beta.tar.gz
worked for me this morning.
Hi Warren,
I wrote in a little while ago about getting unique visits to a website
listed by day. Martin Waite came up with a very nice formulation, which
does wonders!
However, I have done something that is now yielding inconsistent results.
The screen shot is basically like this:
Day by
Hi, paul,
I got why, the first time I run the command is under tcsh, after I change
to bash the command works.
===
mysql@/usr/local/mysql /usr/local/bin/mysql -ujqu -pjqu1234@ --opt nondb
bkp_nondb.sql 2 err.log
Ambiguous output redirect.
I been tring to read the docs on the website, and tried looking it up, but
i'm getting confused. I am trying to make a database and a user.
to make the database i use
mysql create database dbname;
that seems to work. but how do i make a user for it?
OK, it seems to be working. The load is not spiraling out of control. :)
Sincerely,
Steven Roussey
http://Network54.com/
-Original Message-
From: Lenz Grimmer [mailto:[EMAIL PROTECTED]]
Before I make a 4.0.5a release of the Linux binaries (and finally
announce
4.0.5), could
There is a mysql database with a user table in it.
Add a new user, then reload the database! Remember to password the password.
And it will work!
I been tring to read the docs on the website, and tried looking it up, but
i'm getting confused. I am trying to make a database and a user.
to
problem solved! Thanks Mark for the message offlist.
I used something like:
select threads.*
from threads
left join replies
on threads.id = replies.tid
and (threads.stamp {$weekago} and replies.stamp {$weekago})
order by threads.id DESC
Thanks,
Justin
on 19/11/02 9:22 PM, Justin
Actually there is a slightly better way to add a user.
Read the following entry in the mysql docs:
http://www.mysql.com/doc/en/GRANT.html
In fact you might want to read this whole section:
http://www.mysql.com/doc/en/User_Account_Management.html
Example:
grant select, insert on *.* to
FYI, MySQL is featured in Out-of-the-Box 1.0, a distribution of Open
Source projects.
Free Community Edition for Linux documentation on basic MySQL
installation and configuration can be found here:
http://www.ejbsolutions.com/products/obox/community/ch11.html
At 12:53 PM 11/19/2002, you wrote:
Yeah, I've experienced the same thing -- if I leave my computer
unattended it just saps memory until I start getting complaints from
Windows about VM usage. Same deal -- W2K with all the updates.
-JF
You can try a resident memory manager that will
I hope someone can help. I have written a PHP script which adds a row to a
MySQL table. The columns are all of type 'char'. The script works fine
when only numerical values are passed, but when I try to pass values a-z A-Z
the script fails. When I attempt to add the same values straight
- Original Message -
From: Damien Buttler [EMAIL PROTECTED]
I hope someone can help. I have written a PHP script which adds a row to
a
MySQL table. The columns are all of type 'char'. The script works fine
when only numerical values are passed, but when I try to pass values a-z
A-Z
Damien Buttler wrote:
I hope someone can help. I have written a PHP script which adds a row
to a MySQL table. The columns are all of type 'char'. The script
works fine when only numerical values are passed, but when I try to
pass values a-z A-Z the script fails. When I attempt to add the
Try closing them in single quotes.
?
$v1 = 'foo';
$v2 = {$v1} bah;
$sql = INSERT INTO table_name (colname1, colname2) VALUES ('$v1', '$v2');
$result = mysql_query($sql)
...
?
If that doesn't work, perhaps you need to add_slashes() to each value before
inserting, or read up on magic quote in the
suggestion:
if you have a windows machine that you can use as
a front end, download a copy of corereader.
http://corereader.com
it lets you create joins by clicking on objects
in your database. you can quickly experiment
with the logic instead of worrying about syntax.
let corereader take
just what the world needs: more non-standard sql
syntax.
Ok, so it seems to be a bug. What's the procedure for reporting it (or
do the developers read this list?)
-David
A minimal test case that demonstrates the bug:
create table t (
id integer,
index id_idx(id)
);
insert into
Look at GRANT
Peter
---
Excellence in internet and open source software
---
Sunmaia
Birmingham
UK
www.sunmaia.net
tel. 0121-242-1473
International +44-121-242-1473
I'm using PHP 4.22, MySQL 3.23.53a on a RedHat Apache web
server.
I have a join that 99.9% of the time works fine but there have been
3 occasions in the last few weeks where extra records have found
their way into the resulting dataset. This has happened during high
load times.
The join is
Hi all,
Does anyone with experience with MySQL with over 3000 queries per second
willing to shed some light for me? By my guess, full duplex Fast
Ethernet can only handle 8000-1 packets per second. Doing 3000+
queries per second then ought to be saturating the network, right?
Reason is that
Hi,
I like to know if you can help me. I installed mysql-3.23.53-win.zip
which should have the Innodb feature as part of MySQL. However, I am
unable to create an Innodb database. The problem may be that one of my
variables which says have_innodb states that it is Disabled. Do you
know how I
W am looking for some expert assistance using MySQL PHP on a Linux/Apache
based internet site development project.
The project shouldn't take a knowledgeable experienced professional long
so you should be able to work it in your schedule without stopping
everything forever.
Interested parties
At 20:10 -0500 11/19/02, Peter Boivin wrote:
Hi,
I like to know if you can help me. I installed mysql-3.23.53-win.zip
which should have the Innodb feature as part of MySQL. However, I am
unable to create an Innodb database. The problem may be that one of my
variables which says have_innodb
Dear Victoria n Bruce,
thanks a lot, it is work better now :-)
cheers...
Ivan Paul
SQL, Query
- Original Message -
From: Bruce Lee [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, November 19, 2002 6:13 PM
Subject: Re: another field type bigger then varchar
Hi,
text is
$strQuery = SELECT
users.UserID,UserAIM,FLOOR(PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM
NOW()),EXTRACT(YEAR_MONTH FROM UserDOB))/ 12) as
Age,UserFName,UserLName,UserDOB,UserCity,UserState,UserEmail,UserSchoolName,UserSchoolType
FROM users, user_interest where users.UserID=user_interest.UserID and
Never mind, I figured it out. Busted link sending me to the wrong file.
Guess that's what you get when you don't check the most obvious thing, like
the address file.
At 07:42 PM 11/19/2002 -0700, JohnMeyer wrote:
$strQuery = SELECT
users.UserID,UserAIM,FLOOR(PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM
1 - 100 of 113 matches
Mail list logo