this one really works, thank you so much to all who responded...
At 11:49 PM 2/4/01 -0700, Colin Faber wrote:
[EMAIL PROTECTED] wrote:
hi list,
im trying to write a perl srcipt that will connect to a mysql database
server, do some queries and print the output on the screen (or maybe append
the
Wolfgang Arendt
Vodafone TeleCommerce GmbH
SW Test Config. Management
Wolfgang Arendt
Daniel-Goldbach-Str. 17-19
40880 Ratingen
Tel. +49 (0) 21 02 / 97 2492
Fax +49 (0) 21 02 / 97 2453
mailto:[EMAIL PROTECTED]
www.vodafone-telecommerce.de
So how do I create /tmp/mysqld.sock???
A
Hi Rus,
I'm not sure I follow, but the DATE column represents
the dates at which I have a certain item in stock.
ie (. for from 2001-02-04 - 2001-02-06 I have Item1
in stock. However I only have Item2 in stock on
2001-02-04 AND 2001-02-06).
A typical application would be a car hire company:
Can MySQL make DB link connection to Oracle such that MySQL can directly
access tables in Oracle and vice versa?
Since I am doing a project with 2 databases: MySQL and Oracle, and have to
link them up.
Thank you very much.
-
Hi Bob,
Many thanks for that. I was hoping (through absolute
naiveity) not to have to go and calculate the number
of days with the specified range. Unless, of course
I could have mysql do this for me.
Can anyone tell me how I could generate such a list.
(ie something like:
SELECT BETWEEN
Hi,
Woh ! This is very strange. Any ideas ?
mysql SELECT * FROM Table2;
++-+---+
| date | no_of_items | table1_id |
++-+---+
| 2001-02-04 | 3 | 1 |
| 2001-02-05 | 2 | 1 |
| 2001-02-06 |
Hello
I wondered if there was a way to increase the speed of the query and
bring it to 2 or 3 seconds?
Have you tried optimization hints from the chapter 12 of the manual?
http://mysql.com/doc/P/e/Performance.html
cheers
--
TS
Hello
The error says: "Can't read indexpage from filepos: -1". [...]
Thank you for reporting this. This will be fixed in a next release.
But it was really not a big problem - the table was not really
corrupted. [...]
Thanks for the fix and the explanation!
cheers
--
TS
I have too this problem with cp1251 and write 3 time about this, but nobody
don't know correct answer :-(
BY
- Original Message -
From: "medianova" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, February 05, 2001 1:51 PM
Subject: Arabic character set
Hi,
we are setting up an
RENAULT Laurent a crit :
I don't have mySQL root password !
Is the solution do a backup of databases and cleanup mysql install and
re-install it ?
If you have Unix root access, you can edit the table where is stored the
encrypted password, and put a new one ...
You can too re-install
I'm confused.
Am I right in thinking that the Nusphere Gemini project and this announcment
are linked? Is the Innobase code going to provide the transactional support
for MySQL v.4? If not, whats the difference between this and Nuspheres
work?
My company will definitely need transactions
Hi all,
What's wrong with this
Updating makefiles
Considering target file 'Makefile'.
Considering target file 'Makefile.in'.
Considering target file 'Makefile.am'.
Looking for an explicit rule for 'Makefile.am'.
Trying pattern rule with stem 'Makefile.am'.
Trying implicit
Hello.
On Sat, Feb 03, 2001 at 01:54:14AM +0200, [EMAIL PROTECTED] wrote:
Dear Benjamin.
I firstly very very thanks for your interest.
This is my 3'rd mail with same question and you 're the first one who
reply.
Well, it might be due to the fact that you have a rather unusual use
pattern.
Patrick Vogel writes:
Hi all,
What's wrong with this
Updating makefiles
Considering target file 'Makefile'.
Considering target file 'Makefile.in'.
Considering target file 'Makefile.am'.
Looking for an explicit rule for 'Makefile.am'.
Trying pattern rule with
Dear All,
Sorry for bothering everyone.
I am just working with MySQL but I have faced a problem:
I have a table with following problems:
TableA with following columns:
NameCashincome transaction_income
I cannot change the form of table.
If i wanna to have
Thanks to everyone who replied. I got a lot of people who said I should
either use phpMyAdmin or webadmin. It turns out that neither will quite do
what I need it to, and I just wanted to try to get any other suggestions.
In particular, the former doesn't allow one to put any kind of
Huang-Ming writes:
Hi!
I just saw this question un-answered, so in case you already got
a private answer, please just ignore.
hi Tim,
thanks for the prompt response which is hard to be seen with Oracle
and Microsoft.
sorry, i should have had studied hard the manual a year
ago.
hi list,
i am new to mysql. i have read through the reference-manual but still
there are some things i could not answer myself. please help, many
thanks in advance.
---
mysql-reference-manual describes longblob as a blob column with a
maximum length of 4294967295 characters but also says that
Hi
we are having problem downloading MySQL 3.23.32 from your site. the error that we
constantly get when trying to open the file is unable to unzip does not appear to be a
valid archive. any suggestions.
Kind regards
Alan Ronald
At 7:39 PM -0700 2/4/01, Colin Faber wrote:
Paul I expect to see documentation append to the copy of your book I bought 8
months ago ;-)
Do you prefer tape or staples?
Paul DuBois wrote:
On Sun, Feb 04, 2001 at 11:32:42PM -0200, Fbio Ottolini wrote:
Paul,
Tomorrow they are going to
At 9:25 AM -0500 2/5/01, Ken Menzel wrote:
Hi Paul,
Will we see a new version of your VERY excellent book with MySQL
4.0?
Ken
I hope so, but I need to finish the projects I'm working on now, and
I'm also waiting until 4.0 becomes more mature. Right now it's still
in the very early stages.
I've some troubles with a competitor that says to my client that an
Apache/PHP4/MySQL solution on
Linux is unable to produce an e-commerce website. This person
proposal is ASP/M$ SQLServer on an NT 4 Server...
Can you send me some URLs that illustrate the ability to an
To whom it mat concern,
Because the address ([EMAIL PROTECTED]) has a problem, i had to send
this mail
to you. The message turning back to me with my mail is;
Subject:
Returned mail: Service unavailable
Date:
Tue, 30 Jan 2001 23:36:27 +0100
From:
Mail
dbshare is owned by mysql with group deamon
and I have run install_db
"Gerald L. Clark" wrote:
kentj wrote:
Platform Suse 7.0,
AMD 450 KIII+,
128MB Ram
Linux on 10 Gig system harddrive
with 45 Gig additional drive mounted as /dbshare.
I have created a symbolic link in
bozo writes:
To whom it mat concern,
Because the address ([EMAIL PROTECTED]) has a problem, i had to send
this mail
to you. The message turning back to me with my mail is;
Subject:
Returned mail: Service unavailable
Date:
Tue, 30 Jan 2001 23:36:27
dbshare is owned by mysql with group deamon
and I have run install_db
"Gerald L. Clark" wrote:
kentj wrote:
Platform Suse 7.0,
AMD 450 KIII+,
128MB Ram
Linux on 10 Gig system harddrive
with 45 Gig additional drive mounted as /dbshare.
I have created a symbolic link in
You should have run install_db --user=mysql
Is the mysql directory in /dbshare owned by mysql ?
Are the permissions 775 ?
Does mysql own the files in /dbshare/mysql ?
kentj wrote:
dbshare is owned by mysql with group deamon
and I have run install_db
"Gerald L. Clark" wrote:
kentj
I'm having a extremely hard time grasping the concept of multiple tables. So
far, I've been using just one table when designing a database. But now I
have to design a database for a trouble-ticket system for our department.
I've written out the design of the tables, but the part I don't
Hi,
am running Apache 1.3.14 on RedHat 6.2. I've also installed the most
recent Mod_Perl and I'm wokring on MySQL 3.23.29a.
For some reason, I can't create one stable connection between the Perl
session and the MySQL. I read it is possible, and tried following
instructions, but alas, nothing
I work under WinNT with MySQLODBC cilent, and the mySQL
server is installed to the linux server.
I receive an error message:
'can't initialize character set 21 (path: c:\mysql\\share\charsets)'.
I use the hungarian character set, and I try to put in the showed
location the hungarian.conf file
MySQl does not support FK relationship constraints. meaning that if you put
a value in a FK, it won't automatically check to make sure it's a valid
value in the related table. You can, however use FK's. That is how you
should related your tables. It is up to you, the developer, to make sure
that
Have you try GROUP BY?
- Original Message -
From: Marc Swanson [EMAIL PROTECTED]
To: mysql list [EMAIL PROTECTED]
Sent: Monday, February 05, 2001 9:32 AM
Subject: usage of "distinct" in a table join query?
Hello,
I am trying to craft a query that will allow me to retrieve truly
Hi. Ok, i get it. Here is one method, but i'm afraid it may not work in
mysql.
select t1.name,count(*) as nb from Table1 t1, Table2 t2 WHERE t2.date
BETWEEN "2001-02-04" AND "2001-02-06" AND t1.id=t2.table1_id AND
t2.no_of_Items =1 AND nb =
(DAYOFYEAR("2001-02-06")-DAYOFYEAR("2001-02-04"))
Hi,
I work under WinNT with MySQLODBC cilent, and the mySQL
server is installed to the linux server.
I receive an error message:
'can't initialize character set 21 (path: c:\mysql\\share\charsets)'.
I use the hungarian character set, and I try to put in the showed
location the hungarian.conf
What are the system requirements for installing mysql?
Anand Vangipuram
414-566-6701
This message has been scanned for viruses with Trend Micro's Interscan VirusWall.
select name,(Cashincome+transaction_income) as Income from TableA;
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, February 05, 2001 5:04 PM
Subject: Asking help about SQL(Select)
Dear All,
Sorry for bothering everyone.
I am just working with MySQL
I have been trying to install 1.3.23.29-solaris 2.6 binary distribution.
But as a neophyte to MySQL I cannot seem to start the client software.
I have varied from the standard procedure (By necessity) to install it to a
non-standard directory (/ss/mysql) so I have had to add the
On Mon, Feb 05, 2001 at 03:58:37PM +0100, Lukas Gruber wrote:
chapter 11: "replication" doesnt mention any way of scheduling
replication. it says after one configured and restarted the slave
server it will connect to the master and then start replication. is
there a way to schedule
Hi there
I use ASP and ADO 2.5 to access the data in my MySQL RDBMS.
I get an error "Multiple-step error" when I try to update a recordset like
the following:
with rs
.fields("date") = null 'timestamp datatype
.fields("nOnline") = .fields("nOnline") + 1 'int datatype
If you mean you link table techadress to table domains, and then billing admin
adress to techadress, then i think you'r odd..
You should learn some about 'normalization', look for it on the web or in a book.
I'd suggest something like this:
Customer
client_id
clientaddr_id
..details...
-Original Message-
From: NELSON, GLEN
Sent: Tuesday, January 30, 2001 2:10 PM
To: '[EMAIL PROTECTED]'
Subject: Install of mysql on AIX fails due to missing member shr.o in
module libz.a
From: t199k01
To: [EMAIL PROTECTED]
Subject: Install of mysql on AIX
Hi again
If I try the following on my MySQL DB, I get an error:
select user_id from tblUser where user_id in (select user_id from
tblUserLink where group_id = xx)
xx is an integer defining which group_id we want info on (mediumint(9))
user_id in tblUser and tblUserLink is also defined as
Ooops, I forgot to notice that you required consequetive days.
This query works for me:
select T1.*, T2.*, count(T2.id) as c, concat(T2.id,T2.d) as x from table1
as T1, table2 as T2, table 2 as T3 where T1.id=T2.id and T2.id=T3.id and
T2.d='2001-02-04' and T2.d='2001-02-06' and
If you mean you link table techadress to table domains, and then billing
admin adress to techadress, then i think you'r odd..
You should learn some about 'normalization', look for it on the web or in a
book.
No, I did not mean to link the tables like that. I simply wanted the Domain
table
go to www.codecity.com
mysql just does not support in :(((
it's good, but far for 'sql compliant'...
gl
rene
- Original Message -
From: "Henrik Lebtien Mohr" [EMAIL PROTECTED]
To: "MySQL List" [EMAIL PROTECTED]
Sent: Monday, February 05, 2001 7:46 PM
Subject: newbie: problem with
Chuck Carson [EMAIL PROTECTED] wrote:
Without a doubt SuSE linux.
I'd second that. 7.1 is either out or due out any day now with a choice
of kernels (I'd be inclined to put 2.4 on a development box).
I've found that the (free for 90 days) support simply gets better, as
does the
Description:
Trying to determine the default password(s) for user= root and user - mysql
this is a generic install i.e. following the instructions in the
mysql/INSTALL-BINARY...it states to be certain to change the root password using the
commands
./bin/mysqladmin -u root -p
Description:
Restarting doesn't connect to the master.
How-To-Repeat:
mysql restart. show slave status. Read server log.
Fix:
The master's file name still had a newline.
Index: noris.38/sql/slave.cc
--- noris.38/sql/slave.cc Thu, 25 Jan 2001 07:35:47 +0100 smurf
Henrik Lebtien Mohr wrote:
Hi there
I use ASP and ADO 2.5 to access the data in my MySQL RDBMS.
I get an error "Multiple-step error" when I try to update a recordset like
the following:
with rs
.fields("date") = null 'timestamp datatype
.fields("nOnline") =
this came up on the lists a while ago. Asked our sysadmin to answer it
so it took a while sorry.
Sincerely,
William Mussatto, Senior Systems Engineer
CyberStrategies, Inc
ph. 909-920-9154 ext. 27
-- Forwarded message --
Date: Mon, 5 Feb 2001 11:26:57 -0800
From: Michael J.
I'm new to MySQL, this may be a simple question;
How do I turn off listen on port 3306?, I don't want to serve MySQL on the
net, I only need it for local
(server side) access.
Can someone point to docs or notes dealing with this issue.
thanks,
Gus Constan
What OS? If Linux or *BSD, they have firewall software (ipchains on linux,
don't recall what it is on BSD)
I'm new to MySQL, this may be a simple question;
How do I turn off listen on port 3306?, I don't want to serve MySQL on the
net, I only need it for local
(server side) access.
Can
Is there a way to update a column of a table using values from other tables
something like
update table1 set table1.column1=table2.column1 where table1.column2=table2.column1
--
Laurent Oget, Ph.D. [EMAIL PROTECTED]
Senior Engineer Zvolve Systems Inc http://zvolve.com
Hi all,
I have a few questions about query structure.
1. COUNT(*) Is there anything wrong with using
SELECT COUNT(*)
FROM bleah
or should I be using
SELECT COUNT(someField)
FROM bleah
2. Is two queries a lot less efficient than one?
Background: I have a table with about 20
fwcmd=/sbin/ipfw... on BSD
usage like so
${FWCMD} add deny all from any to any via ${oif}
Have to make a new kernel to support ipfw though
cheers,
mikel
[EMAIL PROTECTED] wrote:
What OS? If Linux or *BSD, they have firewall software (ipchains on linux,
don't recall what it
Anyone know a good ipchains rule to close this port to the outside
world? I haven't dabbled in forewalling yet...
i use Immunix, a RedHat 6.2 derivative. I recommend it if you like
RedHat: www.immunix.org. Has stack overflow protection so those pesky
overflow bugs in wu-ftp no longer affect
I'm running mysql with --log-update=update_log with no
extension, so every time I flush the logs I get the next
sequential number appended as an extension to the new
update_log file. If I flush the logs regularly every
day, that sequence number will continue to grow - is
there any way to reset
Hello, I always wanted a gui interface to use on my win 98 pc to connect to mysql, and
create/edit tables. However, i always get an access denied error, saying I'm not
allowed to connect to the mysql server.
However, via telnet, I am fine.
The support for the software sucks, and all the
Steve Ruby wrote:
Does anybody know what is the fastest way to run a large multiple
AND type query on a many-many table and the least memory hungry.
For example if I have
create table test (id int, value int);
which has many-to-many on id, and value
I want to do a select like
Would be easier to play with the grant tables and allow access from localhost
only...
Best regards,
-Eran
"johnny p." wrote:
Anyone know a good ipchains rule to close this port to the outside
world? I haven't dabbled in forewalling yet...
i use Immunix, a RedHat 6.2 derivative. I
That log rotation script smells like the culprit to me. Exactly what is
it doing?
If it is clipping the file in a way that doesn't let MySQL reset the
file pointer
when you do the flush logs command, you could be max-ing the file out
to its ulimit.
Cheers,
Kent
Is there a way to define more than 16 btrees per table? Can this index
limit be increased to 32 or more? It's a static database that is
massively updated once or twice a year so update performance is not the
issue, rather speed of queries.
Please respond to [EMAIL PROTECTED] because I am not
Just my opinion, but I prefer numeric keys that the users *can't*
see, to alpha keys that the users can see:
1. numeric keys are faster
2. using numeric keys that the user can't see allows you
to open up(for UPDATE) ALL the fields that the user can see
including a field like School
Hi,
am having the exact same problem with Hebrew...
Best regards,
-Eran
medianova wrote:
Hi,
we are setting up an Arabic web site using PHP with MySQL 3.23.22.
Our problem is that we can not sort data correctly when retreiving it
from Arabic text fields. This seems to be a character set
Joel Holtzman wrote:
Hello, I always wanted a gui interface to use on my win 98 pc to connect to mysql,
and create/edit tables. However, i always get an access denied error, saying I'm not
allowed to connect to the mysql server.
However, via telnet, I am fine.
By default MySQL server
On Mon, Feb 05, 2001 at 01:36:50PM -0700, Steve Ruby wrote:
Henrik Lebtien Mohr wrote:
Hi there
I use ASP and ADO 2.5 to access the data in my MySQL RDBMS.
I get an error "Multiple-step error" when I try to update a recordset like
the following:
with rs
Hello, I have a table of 26 million rows that I need to query. The table
is a keywords database with the keyword and a pointer to what page it
came off of. (pageid|keyword) The problem is that when I use the
following query is the group by make the query take about 14 seconds to
do. However, if I
Hi,
Can MySQL do the queries on the databases stored in the CD-ROM?
For example, when switching data CD-ROMs, is it necessary to shutdown
mysql server, and restarting server after mounting another CD-ROM?
Thanks in advance.
Sincerely,
Kuokai
Kuokai Shyu wrote:
Hi,
Can MySQL do the queries on the databases stored in the CD-ROM?
For example, when switching data CD-ROMs, is it necessary to shutdown
mysql server, and restarting server after mounting another CD-ROM?
Thanks in advance.
Sincerely,
Kuokai
I assume if
Hi,
I am having some problems inserting data into a blob field, everything works
fine but if I use any HTML and try to insert it, it doesn`t work. So in short
is there something I should be doing to allow HTML to go into a text blob? I
am using PHP if that helps.
TIA
Ade
Hi,
unfortunately I can't set up a scenario that easily reproduces the problem. The
last lockups happened on saturday and today (monday). What I can confirm is:
1. It doesn't seem to be a slave related problem. During the last two lockups I
checked the master as well as the slave statuses, all
Description:
Replication master info seems to get corrupted when the database is restarted
after a shutdown
master.info after shutdown
master-bin.001
25699
master
username
password
3306
60
master.info after startup - note the blank line
any recommendations for jdbc drivers running red hat? which version of red
hat should i install - 6.2 or 7?
thx for advice
dan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
I have been using MySQL for ecommerce work for quite some time. One
problem that just recently arose was a duplicate key error during db
restoration. The culprit lies in a table which has an
auto_incremented, not null defined integer field called "id". There
is an entry which was adjusted,
Description:
Queries to a table with BLOBs are very slow. I query
select id,name,lator,lonor,latpp,lonpp,width,height from segments order by name
The table is defined as:
create table segments (
id int not null auto_increment primary key,
name char(100) unique,
scale int not null,
Hi.
Hey I have been using a query in a search with prioritized criteria.
In five different qualification fields, the first one filled in would produce
the specific search. Name, City, Zip, (C)enter or (I)ndividual... If name
city empty and zip filled in, all that zip would appear. No
No! Check out skip grants in the manual.
- Original Message -
From: "Nicolas GREGOIRE" [EMAIL PROTECTED]
To: "RENAULT Laurent" [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Monday, February 05, 2001 19:19
Subject: Re: mysql -u root WITHOUT password !
RENAULT Laurent a crit :
I
There's a function in php that allows you to escape strings before it is
submitted to mysql. Check it out in the PHP manual.
- Original Message -
From: "Rus" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, February 06, 2001 7:48
Subject: Re: Insert into blob
It will run on most computers of today. Question is what system have you
got/want, what are you going to use it for and what is the expected volume
of information?
- Original Message -
From: "Vangipuram, Anand" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, February 06, 2001
Hello,
I would just like to ask the list's members of this setup:
We have rented a Win2000 web server in the US with a 50GB transfer/month in
the internet. The server currently holds our site's asp web
files, SMTP/POP server and MS Access database files. The Access files
holds the list of
olivefan wrote:
why mysql eat my memory over 1G?Please help me!Thank you!!!
server1:DELL6300,4cpu,4G memory.solaris5.7 for X86 .
mysql start command:nohup /usr/local/bin/safe_mysqld -O key_buffer=128M -O
Description:
Sometimes, when you get a resync error, you need to skip
a particular update and restart with the next bit.
How-To-Repeat:
Insert conflicting records and try to re-sync without deleting one.
Fix:
Apply this patch.
Index: noris.38/sql/mysqlbinlog.cc
Hi,
I installed PHPMyAdmin to manage MySQL but when I try to run the script,
after insert user and password, the error message below displayed:
Warning: MySQL Connection Failed: Can't connect to local MySQL server
through socket '/tmp/mysql.sock' (111) in
83 matches
Mail list logo