Please Send me a link from where i can download MySql
Database for windows and MySqlGui for windows i have
been trying to download from the site (MySql.com) but
was unable to do so please send me at earliest
Awaiting for ur mail
Asif
__
Do you
Hi,
I am a new user (hardly a month old) to mysql.
My configuration:
P4 with Windows 2000 prof, apache, PHP4.3, Mysql
4.0.11-gamma, phpmyadmin
2.4.0.
Now my problem is, a user with no privilege is able to
run
SQL command TRUNCATE table to empty any table!
First I reported it to phpmyadmin team
Hi,
This patch fixes errno usage. Often in mysql there is assumption
that errno is simple int variable while it is not in glibc (=2.3.1).
It's a macro.
See
http://lists.debian.org/debian-glibc/2002/debian-glibc-200212/msg00364.html
Patch by Artur Frysiak [EMAIL PROTECTED] that fixes that (and
Raghu,
- Original Message -
From: [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Wednesday, March 05, 2003 7:03 AM
Subject: Peculiar Problem During Transactions
Placed At : MAATDLN
Hi,
I have a database with a
Hello everyone
I have a question. In a MySQL 3.23 server running on Linux (RH 7.x), can I
symlink the data files and index files of MyISAM tables to different disks
for better performance? After RTFM, it seems that commands alter, repair and
optimize will migrate the files back to the same disk
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Wed, 5 Mar 2003, Arkadiusz Miskiewicz wrote:
This patch fixes errno usage. Often in mysql there is assumption that
errno is simple int variable while it is not in glibc (=2.3.1). It's a
macro.
Thanks! We've fixed this differently in the
Hi!
I'm having this main table with references to files in it:
kod:
+-+-+
| id | filnamn |
+-+-+
|168 |v008-12.jpg|
+-+-+
Then I have this table to relate one file to one or several categories:
+-++--+
|id | fromid
Hello mysql,
I have 2 tables :
Table1:
col1
col2
col3
DataSource
Table2:
col1
col2
col3
DataDestination
How to update Table2.DataDestination with value of Table1.DataSourse
where table1.col1=table2.col2 and table1.col2=table2.col2 and
table1.col3=table2.col3
--
Hi!
On Mar 05, Dr. R. Rajaraman wrote:
Hi,
I am a new user (hardly a month old) to mysql.
My configuration:
P4 with Windows 2000 prof, apache, PHP4.3, Mysql
4.0.11-gamma, phpmyadmin
2.4.0.
Now my problem is, a user with no privilege is able to run SQL command
TRUNCATE table to empty
http://www.richmails.com/cgi-bin/[EMAIL PROTECTED]
2
,1002520500
http://www.richmails.com/cgi-bin/[EMAIL PROTECTED]
1002561101025534435261
$0.05-$0.204
http://www.richmails.com/cgi-bin/[EMAIL PROTECTED]
SIGN-UPCONTINUE
Firstname
Last Name
Street Address
to whom it may concern,
I need some help regarding transactions using innodb tables.
I am running MySQL 3.23.51-Max as database server and developing a web
front-end using ASP. Many of the tables used are of innodb format since it
is imperative for me to use transactions in most of my scripts.
Hi
I am having problems setting up an ODBC client on Windows XP for a Redhat server
running MySQL 3.23-54.
I have seen some references to other people having this problem. Does anyone know
about this, and a fix? I don't want to rebuild the server with Debian/Suse (where I
have done this
Hi!
On Mar 05, Arkadiusz Miskiewicz wrote:
Hi,
This patch fixes errno usage. Often in mysql there is assumption
that errno is simple int variable while it is not in glibc (=2.3.1).
It's a macro.
Thank you.
It was fixed since 4.0.11
(though, somehwhat simplified way - #include errno.h was
Hi,
We had a similar problem and we have taken a different approach:
Instead of having dedicated slave servers, we configure a slave mysql
server on each webserver. Each webserver connects only to 'localhost'
slave mysql server. Each slave server only deals with local connections
(200 in your
This should do what you want:
UPDATE Table2, Table1 SET
Table2.DataDestination=Table1.DataSource WHERE
Table1.col1=Table2.col1 AND Table1.col2=Table2.col2
AND Table1.col3=Table2.col3;
--- PandaCoop-Krasimir_Slaveykov [EMAIL PROTECTED]
wrote: Hello mysql,
I have 2 tables :
Table1:
On Tue, 4 Mar 2003, Fabian Schmidt wrote:
Description:
A select returns uncomplete results, when querying an indexed
varchar row with latin1_de character set and strings containing umlauts
or 'ß'.
How-To-Repeat:
start MySQL 4.0 with character set latin1_de.
create table test (word
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
...I have a quite critical problem and didn't find anything on mysql.com or
via google :-( Maybe someone here has some hints for me?
The data file .MYD of a certain table has a size of 7.3 Gig and the
corresponding index file .MYI has a size
sorry for only half-using mysqlbug,
Martin
Description:
When using more than one alias on a temporary table I get the error
message:
ERROR 1137: Can't reopen table: 'first_alias_name'
The only thing I found about this error is a fix in version 3.23.36
which seems to cope with the
Hiya,
Any help would be appreciated!
Due to various hardware requirements, on our exiting server space is a
problem not speed. I store a lot of details of members, and have worked out
that I will save space by storing lastname's, firstname's etc in a seperate
table.
e.g.
lastname
Is your temp directory running out of disk space?
Seth Brundle wrote:
I attempted to optimize a table last night, which usually takes about 5
minutes but I expected to take longer as I had done a slew of deletes.
Well, it took over an hour, and from the last modified dates on the table
and temp
Band members should probably be in a separate table.
One person may be a member of several bands, and
the membership in a band changes over time.
This will make modeling difficult.
[EMAIL PROTECTED] wrote:
Hello,
I`m doing a database in MySQL to catalog cds, and i`m not sure if my table
I want to replace part of a string with something else. I have a table
called favorites. This can be done by someone who logs in on the browser
with email and password. I'm using php in a web page. Do I use the
following syntax:
$query_del = UPDATE favorites
i would use following
$query_del = UPDATE favorites set
favorites='.REPLACE(favorites,'BitOfStringToReplace','NewBitOfString').'
WHERE
email='$email' AND password = '$pw';
eva
-Original Message-
From: Dillon, John [mailto:[EMAIL PROTECTED]
Sent: 5. marca 2003 15:53
To: '[EMAIL
Two solutions to your problem:
table full errors: check the 'AVG_ROW_LENGTH' and 'MAX_ROWS' option
for create and alter table. You can change these on the fly using 'alter
table', but it will take quite a time for a table your size (few hours-1 day
depending on machine).
The exact values for
on mysql 4.0.10-gamma (rpm install, Redhat advanced server), I
am running into 'too many open files' issues ( error 24 ).
I am using a rather large merge table (30 distinct tables merged),
which is likely the culprit. The error shows up as I have about a
dozen of connections.
I did
hi everybody,
i'm trying to add a udf to mysql that itself accesses the database.
anybody ever tried that?
i want a function to dynamically create a database, symbolic links and tables.
i thought it could be as easy as just mix up a normal udf with my
table-creating thing.
but when i try to
Just wanted to let y'all know this worked awesome!
Thanks so much!
Renee :)
-Original Message-
From: Sqlcoders.com Programming Dept [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 04, 2003 11:20 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Count (*) function results needed in
hi,
There is an example (udf_example.cc) in 'sql' sub-directory of
mysql sources.
You can code your functions in C++ but you must declare your UDF entry
points as 'extern C'
Regards,
Joseph Bueno
Maurizio Oristanio wrote:
hi everybody,
i'm trying to add a udf to mysql that itself accesses the
On Wednesday 05 March 2003 16:08, correll at gmx dot de wrote:
Description:
When using more than one alias on a temporary table I get the error
message:
ERROR 1137: Can't reopen table: 'first_alias_name'
The only thing I found about this error is a fix in version 3.23.36
which
On Tuesday 04 March 2003 22:38, François Roussel wrote:
I want to add transaction support to an
existing database running
on mysql 3.23.49-3 distributed with Red Hat 7.3.
After browsing through the Mysql and the Innodb documentation, it appears
that
I have the following options:
1)
On Tuesday 04 March 2003 19:35, Jamie Jennings wrote:
Yes that must be it. Both columns are unsigned. Is
there any way to accomplish this with one query with
unsigned columns?
Take a look at cast functions:
http://www.mysql.com/doc/en/Cast_Functions.html
Otherwise I will have to
In the MySQL reference, it warns against using HAVING for items
that should be in a WHERE clause. I'm not sure what items
should be in a WHERE clause.
My exact problem is I want to select some records that have a
dotted IP address as one of the fields. And I want to filter out
the multicast
go to
http://www.mysql.com/doc/en/Miscellaneous_functions.html
and take a look at
inet_ntoa and inet_aton
you may store IP addresses as integers and the query will be
SELECT inet_aton(inetAdr), * FROM Client WHERE inetAdr
inet_aton('240.0.0.0') OR inetAdrinet_aton('239.255.255.255')
the
At 11:17 -0500 3/5/03, Jonathan Arnold wrote:
In the MySQL reference, it warns against using HAVING for items
that should be in a WHERE clause. I'm not sure what items
should be in a WHERE clause.
If a test can be in either clause, put it in the WHERE clause. The principle
is that the sooner you
HAVING is for qualifying result rows based on the value of aggregate
functions, WHERE is for qualifying result rows based on individual (column)
values. So in you case you should use WHERE. Although useful in the right
situation, HAVING is used much less than a WHERE clause.
One example of how
On Wed 2003-03-05 at 11:17:37 -0500, [EMAIL PROTECTED] wrote:
In the MySQL reference, it warns against using HAVING for items
that should be in a WHERE clause. I'm not sure what items
should be in a WHERE clause.
Everything except stuff that only works when it's in the HAVING
clause. The
In the last episode (Mar 05), Jonathan Arnold said:
In the MySQL reference, it warns against using HAVING for items that
should be in a WHERE clause. I'm not sure what items should be in
a WHERE clause.
The WHERE clause is used to restrict records, and is also used by the
query optimizer to
I'm having trouble getting MySQL running on a RedHat Linux 7.1 machine.
The log file complains that host.MYD is missing; I don't see mention
of this file in the documentation, and it's not on my computer anywhere.
Also, the mysql.sock file is not present, and I don't know how to
create it -- I
Does anyone know how to view uncommited transactions for a session?
This is more of a problem when using MySQL Manager when it asks whether
or not to commit the transaction list. Is there a definitive way to
know what queries have yet to be committed/rolled back?
Hi, I havent received any response on this so i'll send this again.
I did check again with 4.0.11-gamma and the problem is still there.
Regards,
Scott
Version: Mysql 4.0.10-gamma
Description: Mysql hangs and possibly can not recover from a query on an innodb
table.
How to Repeat
I need a little help querying 2 tables in MySQL;
Table User
User_Id // Id = 2
User_Name // John
Table History
User_Id // 2
User_History // John has born in 58
SELECT User_History FROM History WHERE User_Id = 2; // return John has
born in 58
But what my SELECT should look if i don't know
Renne
I did a similar thing with asp, my query was like
SELECT COUNT(*) AS countresult, uniqueref FROM global WHERE
PROPOSEDRELEASE = 2002 and SURNAME = ' globsurname ' group by
uniqueref
Im my asp code I referenced countresult
Hope this helps
John B
-Original Message-
From:
Scott Wong writes:
Hi, I havent received any response on this so i'll send this again.
I did check again with 4.0.11-gamma and the problem is still there.
Regards,
Scott
Hi!
This will require a major re-write in multi table update's and will
not come up very soon. But should come up
Ok, lessee...
SELECT user.user_id, user_name, user_history FROM user, history
WHERE user_history LIKE %58% AND user.user_id = history.user_id;
That should do what you need, lemme know.
Mike Hillyer
http://www.dynamergy.com/mike
-Original Message-
From: [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
I need a little help querying 2 tables in MySQL;
Table User
User_Id // Id = 2
User_Name // John
Table History
User_Id // 2
User_History // John has born in 58
SELECT User_History FROM History WHERE User_Id = 2; // return John has
born in 58
But what my SELECT
--- [EMAIL PROTECTED] wrote:
I need a little help querying 2 tables in MySQL;
Table User
User_Id // Id = 2
User_Name // John
Table History
User_Id // 2
User_History // John has born in 58
SELECT User_History FROM History WHERE User_Id = 2; // return John has
born in 58
But
I'm trying to use a INSERT INTO table1 (column1,
column2, column3) SELECT 'value', 'value2',
table2.value3 FROM table2 WHERE table2.value4='name';
This query fails from C, but if I copy and paste it
exactly to the mysql client, it works.
If I run mysql_info(), it tells me:
Records: 0
Hi Lenz - thanks for your response.
Please define not compatible. What exactly happens when you try to
use
them? Is there an error? Which version of MySQL/Code Warrior do you
use?
I am using the most up-to-date version of CodeWarrior, v8.3, and I have
tried with several different versions of
If you have that many files in a directory, I would try a filesystem
that indexes directories. Reiserfs does, and there's a patch
somewhere for ext2 (and probably for ext3). I don't know about the
other filesystems.
Otherwise the application has to do a linear search through the
directory every
Hi, I'm running 4.0.11a-gamma. I have replication working and I have SSL
working. I can't seem to get them to work together. Based on mysql.com's
documentation, it seems that this version of MySQL does in fact support
secure replication.
Unfortunately, when I add REQUIRE SSL to the slave
At 15:48 -0500 3/5/03, Russell D. Weiss wrote:
Hi, I'm running 4.0.11a-gamma. I have replication working and I have SSL
working. I can't seem to get them to work together. Based on mysql.com's
documentation, it seems that this version of MySQL does in fact support
secure replication.
What
Thanks!
Mamatha
From: Paul DuBois [EMAIL PROTECTED]
To: Mamatha Balasubramanian
[EMAIL PROTECTED],[EMAIL PROTECTED]
Subject: Re: Temporary Tables
Date: Tue, 4 Mar 2003 17:31:36 -0600
At 23:19 + 3/4/03, Mamatha Balasubramanian wrote:
Thank you once again.
I have a web-interface that
Oops, I guess I assumed that support for it was there since options are
documented, and it even says:
Available after 4.0.0. Turn SSL on for replication. Be warned that is this
is a relatively new feature. Example: master-ssl
Instead, I guess it should say be warned, this is just a stub and
Oops, I guess I assumed that support for it was there since options are
documented, and it even says:
Available after 4.0.0. Turn SSL on for replication. Be warned that is this
is a relatively new feature. Example: master-ssl
Instead, I guess it should say be warned, this is just a stub and
Is there a webpage or something I can read about creating a script that can be ran
from mysql prompt with the ./ . My script doesn't seem to work, even though
it looks like legal sql to me. I am running this under win98.
Terry
At 16:16 -0600 3/5/03, Terry Cheryl Haimann wrote:
Is there a webpage or something I can read about creating a script
that can be ran from mysql prompt with the ./ . My script doesn't
seem to work, even though
it looks like legal sql to me. I am running this under win98.
The command is \. and
On Wed, Mar 05, 2003 at 05:12:13PM -0500, Russell D. Weiss wrote:
I guess I'll be doing replication over an SSH tunnel. Anyone seen
any caveats with doing it that way?
That will work just fine.
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED] |
Hi, perform the following query
SELECT BA_ID, BA_DATE
FROM BA
WHERE SUBSTRING(BA_ID,1,3) = 'TSV'
and get
'TSV12345-1','2003-02-25 00:00:00'
'TSV12345-2','2003-02-25 00:00:00'
'TSV14818-3','2003-02-19 00:00:00'
'TSV14836-00015','2003-02-27 00:00:00'
'TSV14841-9','2003-02-28
Description:
I'm using Mysql 4.0.10-gamma with query caching:
set-variable = query_cache_limit=10M
set-variable = query_cache_size=10M
set-variable = query_cache_startup_type=1
The Command:
Select *
At 8:40 +1000 3/6/03, Jeff wrote:
Hi, perform the following query
SELECT BA_ID, BA_DATE
FROM BA
WHERE SUBSTRING(BA_ID,1,3) = 'TSV'
and get
'TSV12345-1','2003-02-25 00:00:00'
'TSV12345-2','2003-02-25 00:00:00'
'TSV14818-3','2003-02-19 00:00:00'
'TSV14836-00015','2003-02-27 00:00:00'
Description:
I'm using Mysql 4.0.10-gamma with query caching:
set-variable = query_cache_limit=10M
set-variable = query_cache_size=10M
set-variable = query_cache_startup_type=1
The Command:
Select *
Working on a routine to export a Filemaker data to mySQL for php
application.
Using scripts I build a calculated field below:
INSERT INTO abctable (JobNumber, JobTitle, AE, Client, StartDate) VALUES
(9997, ' ABC ' , 'jrt' ,1234, '')
or
UPDATE abctable SET
Yes Paul, that's what I meant.
See, even confusing myself now ;-)
The field is datetime as the time is used in other functions...
Would I be better using 2 separate fields?
Jeff
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Jeff [EMAIL PROTECTED]; MySQL List [EMAIL
At 9:05 +1000 3/6/03, Jeff wrote:
Yes Paul, that's what I meant.
See, even confusing myself now ;-)
The field is datetime as the time is used in other functions...
Would I be better using 2 separate fields?
Not necessarily, but if you want to match all times within a given
date, you'll need to do
On Wed 2003-03-05 at 17:12:23 -0600, [EMAIL PROTECTED] wrote:
[...]
BA_DATE = '2003-02-25 00:00:00' AND BA_DATE = '2003-02-25 23:59:59'
or
TO_DAYS(FROM_DAYS(BA_DATE)) = '2003-02-25'
Hm. You mean FROM_DAYS(TO_DAYS(BA_DATE)), don't you? BA_DATE is a
timestamp, not a number of days.
Aside
Well, if this is a one-time batch transfer then a simple
UPDATE abctable SET SomethingDate IS NULL when SomethingDate = '-00-00';
should null all the fields in question. Of course, you have to have a
NULLable date field.
Regards,
Mike Hillyer
http://www.dynamergy.com/mike
-Original
At 0:23 +0100 3/6/03, Benjamin Pflugmann wrote:
On Wed 2003-03-05 at 17:12:23 -0600, [EMAIL PROTECTED] wrote:
[...]
BA_DATE = '2003-02-25 00:00:00' AND BA_DATE = '2003-02-25 23:59:59'
or
TO_DAYS(FROM_DAYS(BA_DATE)) = '2003-02-25'
Hm. You mean FROM_DAYS(TO_DAYS(BA_DATE)), don't you? BA_DATE is
Thanks guys,
Appreciate the help. Kinda makes sense now ;-)
Jeff
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Benjamin Pflugmann [EMAIL PROTECTED]; Jeff
[EMAIL PROTECTED]; MySQL List [EMAIL PROTECTED]
Sent: Thursday, March 06, 2003 9:32 AM
Subject: Re: Syntax confusion
Hi All;
I recieved an e-mail as part of a PHP user group mailing list, does anyone
know the answer?
cut here
Ok, I know that you can do a ( ) in a query for working stuff but can you do
another query there? ie
select * from Activity
join
(
select License Number, max(Activity Date)
I just built a P4 3.06 1GB DDR 333 15k U160 SCSI MySQL Linux server.
I was dissapointed because I couldnt get the dual-channel DDR 400 MB I tried
first to run stable :(
dual-channel memory controllers definitely made a slight difference on the
benchmarks with the same ram.
alter-table 2
http://www.mysql.com/doc/en/CREATE_TABLE.html states Default values must be
constants. This means, for example, that you cannot set the default for a
date column to be the value of a function such as NOW() or CURRENT_DATE.
Is this ever going to be fixed? I often find myself using this when
http://www.mysql.com/doc/en/SEC457.html states that there must be an index
where the foreign key and the referenced key are listed as the FIRST
columns. Will this restriction be lifted soon? It is incredibly
frustrating. I don't see why they have to be indexes, and more importantly,
I don't see
Hi All:
I have three web server (DUAL 1.4 G MHZ, 1G RAM) connect to one mysql
database server (DUAL 2.2 G MHZ, 2 G RAM), SSL accelerator and a load
balancer. All those servers are FreeBSD. For some reason, mysql server can
be easily max out without many users. Also there are many processes in
In the last episode (Mar 05), Daevid Vincent said:
http://www.mysql.com/doc/en/SEC457.html states that there must be an
index where the foreign key and the referenced key are listed as the
FIRST columns. Will this restriction be lifted soon? It is
incredibly frustrating. I don't see why they
Hi All:
I have three web server (DUAL 1.4 G MHZ, 1G RAM) connect to one mysql
database server (DUAL 2.2 G MHZ, 2 G RAM), SSL accelerator and a load
balancer. All those servers are FreeBSD. For some reason, mysql server can
be easily max out without many users. Also there are many processes in
In the last episode (Mar 05), Daevid Vincent said:
http://www.mysql.com/doc/en/SEC457.html states that there
must be an
index where the foreign key and the referenced key are listed as the
FIRST columns. Will this restriction be lifted soon? It is
incredibly frustrating. I don't see why
Bug report -- MySQL Embedded Server v4.0.10, binary distribution for
Windows
Hi All,
Can MySQL give some indication of how many questions are being asked to each
database?
Using the show variables, I can get the total questions, but was wondering
if it's possible to get
it broken down on a per database view?
Rgds
Terence
query sql
At 11:59 +0800 3/6/03, Terence wrote:
Hi All,
Can MySQL give some indication of how many questions are being asked to each
database?
Using the show variables, I can get the total questions, but was wondering
if it's possible to get
it broken down on a per database view?
No.
Rgds
Terence
query
At 17:56 -0800 3/5/03, Daevid Vincent wrote:
http://www.mysql.com/doc/en/CREATE_TABLE.html states Default values must be
constants. This means, for example, that you cannot set the default for a
date column to be the value of a function such as NOW() or CURRENT_DATE.
Is this ever going to be
Dear Mr. Venu Tech Group,
We are facing few problem in mysql database.
Take an eg.
we have table called bb_usersession0
user A is trying to delete a record which is having the billingstatus B .
User A
delete from bb_usersession0 where ui_sessionid='cs_venkatesh0006A46C' AND
I hope I can get some help here, I'm installing mySQL on OpenBSD and i
cannot find the mysql_install_db file, all the documentation that I've read
is saying its the first step after doing make and make install from the
ports tree.
FYI: Its not in /usr/local/bin, and there was no
In the last episode (Mar 05), Daevid Vincent said:
I'm not sure that sentence means what you think it does. What
they're saying is you need to index both fields, and if you decide
to make that index a compound one with multiple keyparts, the
foreign/referenced field must be the first.
=
http://www.chinamysql.com
100M1010M20318/
http://3long.sayba.com
5881800
http://shop.sayba.com
http://www.lovexin.com;
-
Before posting, please check:
Hello,
mysqladmin reports 'unknown settiing --default-char-set' if i set client
default charset in my.cnf on suse linux. If I comment this line, there
are no errors, even if if server has win1250 as default charset.
But myOLEDB quit working, if i use charset other than latin1.
Can this be fixed?
At 4:41 + 3/6/03, Donna Robinson wrote:
Filter-fodder: mysql, query
Hi,
Is this a very hard question or an absurdly simple one? I posted it days ago,
and no-one has responded! Please can someone help?
How can I avoid Using temporary, Using filesort
when creating indices when my selects
At 7:21 +0100 3/6/03, marjan mrak wrote:
Hello,
mysqladmin reports 'unknown settiing --default-char-set' if i set client
default charset in my.cnf on suse linux. If I comment this line, there
are no errors, even if if server has win1250 as default charset.
There is no such option. I assume you
87 matches
Mail list logo