Hi there,
I have just upgraded my Win98SE to Win2K and ever since, I could not start Mysqld or
Mysqld-nt (with or without the --install option). I am using Mysql 3.23.30-gamma-win
version.
I am new to Mysql and would appreciate any help from you.
Thank you and regards,
CT Chang
On 06.02.2001 18:09:36 russ wrote:
Im new to the list, apologies if this has been asked before.
Im developing a backend for a personal site (www.russd.com) using mySQL.
The site is hosted on NT4 and has myODBC installed, I have some database
access
working, but I'm looking for a way to
Many thanks to all for the help on this issue.
I've come to the conclusion the simplest way for me to implement this is to use the
ENUM type with two possible values 'True' and 'False'.
I will convert the VB BOOLEAN type to a string before I enter it.
Thankfully when returning a value from
Hi all,
I have been playing with perl and mysql on debian linux and its now
cooking on gas and I love it thanks to all of you for your help
Well off topic I know, but whilst on this list last time I met some perl
Guru's and once again I need their "Your" help.
I want to write a cgi
Hello,
I have two tables:
CREATE TABLE categories (
CategoryNumber int(11) NOT NULL,
ItemNumber int(11) NOT NULL,
KEY CategoryNumber (CategoryNumber),
KEY ItemNumber (ItemNumber)
);
CREATE TABLE items (
ItemNumber int(11) NOT NULL auto_increment,
Description varchar(100)
On Tue, Feb 06, 2001 at 12:47:20PM -0800, John Jung wrote:
Hi All,
I'm trying to port MySQL 3.22.32 to HPUX 10.20 and am encountering some
problems. I'm on an HPUX 10.20 box with GCC 2.95.2, the configure script
works fine when I build I get:
mysqld.cc: In function `void
I use a short (0 unchecked, 1 checked).
Pat...
- Original Message -
From: "John Halladay" [EMAIL PROTECTED]
To: "MySQL List (E-mail)" [EMAIL PROTECTED]
Sent: Tuesday, February 06, 2001 4:57 PM
Subject: MS Access Checkbox equivalent format in MySQL
If I am using MS Access and linking
Hi there,
suppose I have table table1 with columns col1,col2,col3,col4
I would like to set up a query that omits eg. col1 from the output even
though col1 must satisfy some condition:
SELECT col2,col3,col4 from table where col1=condition
Any suggestions ?
Thanks in advance
A.Hannemann
Bob Hall wrote:
I want to do a select like
select id from test
where id in (select id from test where value in (1,2,3)
and id in (select id from test where value in (4,6,7)
and id in (select id from test where value in (1,6,25)
Even if MySQL supported subqueries, this
Thanks for the help
Typing errors occured
Sorry for the inconvenience
A.Hannemann
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
Hi!
"ch" == ch [EMAIL PROTECTED] writes:
Description:
ch My udf function and an equal udf function I found in the internet
ch seem to work well as does substring_index. Only when I call them
ch together I get a bug. As my function (quotet below) is so simple
ch that it
Hello,
I've develop the software in Rapid-Q (under Win), It's a bank of data for a medical
ambulance. The main data store will be MySQL. It'll run localy so server will run on
the same machine as my program. The program is free (binary) , not free is the source
code. Only what i'll sell are
I just installed mysql 3.23.32 on my server and it
went without a hitch. I ran mysql_install_db, changed
the root password, started the server. I used GRANT
statements to create another user, then connected
as that user to the mysql client--no problem at all,
ran queries, etc.
But I wrote a PHP
on a related but slightly different example, what would happen if you had a
Primary Key consisting of 2 columns a b (so the pkey enforces a unique
combination of a b) and then created an index on one of the columns eg b.
Would the index on b have any effect, or does a primary key on 2
I just tried connecting to the db from kmysql on
the same box--no way, no how. Same can't connect
error message, though I can connect remotely.
--
/"\
\ /ASCII RIBBON CAMPAIGN
X AGAINST HTML EMAIL
/ \AND POSTINGS
Binary is an option on the varchar type
I pulled the following quote from the mysql website.
It just does not seem to be working anymore.
[NATIONAL] VARCHAR(M) [BINARY]
A variable-length string. NOTE: Trailing spaces are removed when the
value is stored (this differs from the ANSI SQL
Yes, I should have been more clear, I know that you can join a table to itself but I
am trying to find out:
1) What is the max number of joins (unique tables/mixture of same table joins)
2) What is the max number of same-table joins
So I guess I had two questions :)
Bill
On Wed, 7 Feb 2001,
Hi,
first of all: the deadlock happened again today, this time with no slave
running so it isn't a replication issue. It seems we're getting closer as when
I did run 'show processlist', the pending query was (excerpt from output):
1666logreader 10.1.1.4syslog Query 114
Dear friends,
as an appendix I have included the bug report generated
from the system. After unzipping and taring the
new issue (3.23.32) of mysqlbinary for hpux-10.20
the mysql_install_db script crashed with a coredump.
The was the first try to install mysql on this machine.
Do You have any
In a SELECT I have to convert a string into a number.
I used to use something like 'string'+0, where 'string' is a string
rapresentation of an integer.
Now I noticed that in many cases it returns a rounded floating point!!!
For example:
mysql select '11'+0;
+-+
| '11'+0
Binary is an option on the varchar type
I pulled the following quote from the mysql website.
It just does not seem to be working anymore.
A guess:
It seems to me that the problem is not in
your colmn definition, but the silent type
conversions MySQL performs. In the log you
show below,
I just installed mysql 3.23.32 on my server and it
went without a hitch. I ran mysql_install_db, changed
the root password, started the server. I used GRANT
statements to create another user, then connected
as that user to the mysql client--no problem at all,
ran queries, etc.
But I
On 07.02.2001 10:30:15 russ wrote:
Many thanks to all for the help on this issue.
I've come to the conclusion the simplest way for me to implement this is to
use
the ENUM type with two possible values 'True' and 'False'.
I will convert the VB BOOLEAN type to a string before I enter it.
Good Morning,
Recently, on an otherwise functioning system, I began getting the following
message
ERROR 1130: Host '' is not allowed to connect to this MySQL server
I am running both the client and server from Solaris 7 machines. MySQL
version is 3.22.32
This started happening about two
It's a bug either in your processor or in your distribution
libraries. Your SELECT returns correctly on my Linux and FreeBSD
servers.
-Tilghman
--
"There cannot be a crisis today. My schedule is already full."
--Henry Kissinger
-Original Message-
From: Federico Giannici
Here you go...
http://www.zeos.dn.ua/eng/index.html
Paulo Serra wrote:
I am a DELPHI developer and I need to know if exists
a MySQL driver for DELPHI.
Does MySQL have a driver for DELPHI???
If it does, please send me it...
My e-mails: [EMAIL PROTECTED]
clay bond wrote:
I just installed mysql 3.23.32 on my server and it
went without a hitch. I ran mysql_install_db, changed
the root password, started the server. I used GRANT
statements to create another user, then connected
as that user to the mysql client--no problem at all,
ran queries,
I ran rpm -Uhv MySql*3.23.32-1.i386.rpm against the sever, the client and the
shared rpms.
It ran without error and created the appropriate files on the 10 gig
/var/lib/mysql.
I moved the contents of mysql to /dbshare and created a symbolic link in /var/lib
called mysql which pointed to
Is there an idea in having a PRIMARY KEY and UNIQUE key for the same table
column ?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
Run the winmysqladmin.exe in the bin directory. Then do the right click
"install service", right click "start service".
I had to do this the first time. Thereafter it does it on install.
[EMAIL PROTECTED]
National Aeronautics and Space Administration
-- S c i e n c e @ N A S A
Web Depressed wrote:
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.
Question: why are you using reserved words for your column names?
On Wed, 7 Feb 2001, CT Chang wrote:
Date: Wed, 7 Feb 2001 17:14:28 +0800
From: CT Chang [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Mysql in Win2K
Hi there,
I have just upgraded my Win98SE to Win2K and ever since, I could not =
start Mysqld or Mysqld-nt (with or without the
No. A primary key is a unique key, by definition.
--
"There cannot be a crisis today. My schedule is already full."
--Henry Kissinger
-Original Message-
From: Jacob Friis Larsen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 07, 2001 09:58
To: [EMAIL PROTECTED]
010207 12:47:42 Error reading packet from server: Contratulations! You have hit the
magic number and can win sweepstakes if you report the bug (0).
I got the magic number, but I prefer a solution instead my prize!
I have a lot of "COOL BUGS".
I'am a MYSQL FAN.
At 07:14 07/02/2001, CT Chang wrote:
Hi!
Notice that the command mysqld-nt --install only install the
service on the SCM and for start it you do:
net start mysql
Also you need to know that in the next boot the service is
started automatic.
Regards,
Miguel
Hi there,
I have just upgraded my
In a SELECT I have to convert a string into a number.
I used to use something like 'string'+0, where 'string' is a string
rapresentation of an integer.
Now I noticed that in many cases it returns a rounded floating point!!!
For example:
mysql select '11'+0;
+-+
|
I guess my command of the english language isn't too
great.
I never realized that this quote from the manual:
"You're allowed to do it (for example, ABS is an
allowed column name), but whitespace is not allowed
between a function name and the `(' when using
functions whose names are also column
Working anymore? You mean that it used to work? Now I'm confused!!
The quote from the manual is correct. Using BINARY means that 'A' 'a' not
'A' = 'a' which is the case without the keyword BINARY.
What is it you are trying to achieve by inserting 0x1 into a CHAR field?
- Original
Firstly, I'm curious as to why you need --skip-locking in the first place.
Now that I know what you are trying to achieve, I can honestly say I'm not
sure. I'd have to read the manual for more detail on how flush-logs
interact with table locking etc.
I presume your daemon, that's accessing the
Yes, you can but you probably need a real good reason to. As Tilghman
pointed out a PK is a unique key. If you have another unique key (a
candidate key) then you need revisit your datamodel and make sure you have a
good reason. Candidate keys to exist in the real world but they are rare.
Cal
It's gives me correct result (integer value 11) on my FreeBSD 3.5, FreeBSD
4.2 and Debian Linux 2.2 Machine
- Original Message -
From: "Carsten H. Pedersen" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; "MySQL mailinglist" [EMAIL PROTECTED]
Sent: Thursday, February 08, 2001 1:15 AM
Subject:
Hi,
You don't connect to mysql server using telnet, you use the mysql command
line client 'mysql'.
Regards
Quentin
-Original Message-
From: @ndYD [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 8 February 2001 07:13
To: [EMAIL PROTECTED]
Subject: problems running mySQL via Telnet
Hello,
This works... however it does not fix my problem.
I did a little more research...
Instead of varchar(M) BINARY I can do a tinyblob.
This allows me to do the inserts and selects that I previously
mentioned.
Also the documentation says that you can consider blob as a varchar
binary.
So My
Rolf Hopkins [[EMAIL PROTECTED]] wrote:
Firstly, I'm curious as to why you need --skip-locking in the first place.
I'm not sure that I do - I just thought that if I instead
used --enable-locking that this problem of update logs
getting confused with flush-logs might(?) go away. But I
haven't
You're trying to use a Telnet client with a MySQL server. Instead,
use a MySQL client with a MySQL server and a Telnet client with a
Telnet server. Mixing protocols doesn't really work for anybody.
-Tilghman
--
"There cannot be a crisis today. My schedule is already full."
--Henry
'varchar(16) binary' works in 3.22 and tinyblob works in 3.23.
by work I mean I can insert hexidecimal numbers into the field.
I am basically treating it as an integer field. I can store 16 byte
numbers in the field and in the case of varchar(16) binary on mysql 3.22
I could store a 32
I have a select I'd like to do...I have 2 kinds of people -- those
needing interviews, and those doing interviews. Among other things,
each person has their home address/phone in the tables. I want to
generate lists of interviewers in close geographical proximity to the
interviewees. I can do
How can I get the log-bin initial position?
Like: trevas-bin.001
trevas-bin.002
I want to know in which position trevas-bin.002 began.
-
Before posting, please check:
http://www.mysql.com/manual.php (the
Maybe we're doing something really wrong in the way we do each look up.
We have one table with all the defintions on it's own row.
Then we have built off of that table another table that is only the distinct
words, no definitions.
This is because if a word has 10 definitions, it makes it hard
When we increase the number of connections our 3.22.25 server 'hangs':
mysql show status;
No connection. Trying to reconnect...
ERROR 1129: Host 'xxx is blocked because of many connection er
rors. Unblock with 'mysqladmin flush-hosts'
ERROR: Can't connect to the server
This happens when we
i agree .. the mysql server _should_ accept telnet sessions. Maybe in a
future release ? it'd really be very handy
- Original Message -
From: "Quentin Bennett" [EMAIL PROTECTED]
To: "'@ndYD'" [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, February 07, 2001 7:56 PM
Subject: RE:
"TT" == The Tilghman [EMAIL PROTECTED] writes:
TT You're trying to use a Telnet client with a MySQL server. Instead,
TT use a MySQL client with a MySQL server and a Telnet client with a
TT Telnet server. Mixing protocols doesn't really work for anybody.
well, you can use the telnet client to
Hi!
Last night, one of tables broke. For some reason, I cannot access the table
anymore, trying to do so gives me this error message:
ERROR 1016: Can't open file: 'DownloadCounter.MYD'. (errno: 145)
DownloadCounter is the table that is broken.
How can something like this happen? Is it more
The problem I'd like to report is when there's an insert with now() in a
datetime field.
The problem is that, when both servers doesn't have their clocks
synchronized, the value of the now() in the Master will be different
from that in the Slave.
I've tried it with MySQL 3.23.32 in both
Check out SUBSTRING in the manual.
On the zip codes, you're better off not trying to do any
comparisons in SQL -- the way they work is extremely
complicated. I would suggest that you purchase distance
measurements between two arbitrary zip codes from the
Postal Service, if you intend to be
I think 12 tables is not a large number by any means.
If they _logically_ form one database, I'd not bother about the number.
Only if performance problems pop up, and are positively recognized as being caused
by too many files in the database directory, I'd start looking for a solution.
Which
Can I implement some sort of exception handling when using the mySQL
client library? I'm running an application and when I issue a query with
an error in it, I catch the error and print output, but the software
throws a general exception. Should this code be in a
try
{
}
catch
{}
routine? If
Couldn't find it on usps.com, but a quick search of google turned
up the following url: http://www.tpsnet.com/html/zipmenu.html
--
"There cannot be a crisis today. My schedule is already full."
--Henry Kissinger
-Original Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]]
I apologize if this has been discussed already, but I quick poke
at the archives didn't reveal anything.
We have a table that iamchk says is fine. We are trying to get an
SQL dump of this table. But, we keep getting out-of-memory errors.
I've tried several things, all to no avail, and I'm
mysql (the monitor) seems not to read the option character-sets-dir out of
any configuration files (at least not /etc/my.cnf on Linux resp. c:my.ini
and windows/my.ini on Windows) if it is started with option -p or
with --password, i.e. if it shows a password prompt
everything works fine if
Two things:
1) Read the manual to see the correct syntax for the CREATE TABLE.
2) Constraints don't actually do anything in MySQL. Again, read the
manual.
-Tilghman
--
"There cannot be a crisis today. My schedule is already full."
--Henry Kissinger
-Original Message-
Two things:
1) Read the manual to see the correct syntax for the CREATE TABLE.
I did, and that's where I don't understand why this is happening. The
furthest I was able to get in the manual and/or any of the archives from
MySQL is:
(straight out of the manual)
CREATE [TEMPORARY] TABLE [IF
In the last episode (Feb 07), Cal Evans said:
Does the post office offer this info? There used to be a service (Melissa)
that had Lat. and Long. for the center of each zip code. You could use that
to computer "all addresses in a 50 mile radius". but from what I understand,
it's gone now. I
Hi!
"Peter" == Peter Zaitsev [EMAIL PROTECTED] writes:
Peter Hello mysql,
Peter mysql 3.23.32 + BDB 3.2.3h
mysql select * from layers_la00.g03last_hit;
Peter +++-+++
Peter | updated| counter_id | stat_id | lasthit_ts
On Wed, Feb 07, 2001 at 05:00:12PM -0500, Brian Reichert wrote:
When I try to do a mysqldump on the localhost, I get an out-of-memory
error:
# mysqldump -uroot -proot customer audit_trail_271
mysqldump: Out of memory (Needed 8164 bytes)
mysqldump: Got error: 2008: MySQL client run
Hi all
I am running mysql on linux (redhat 6.2) using a regular 18Gb
EIDI hard drive. Does anyone know how much (ball park figure) a
SCSI hard drive would speed up selects and inserts?
Thanks everyone!
Michael Thomas
abcXyz.com
[EMAIL PROTECTED]
Brian Reichert wrote:
On Wed, Feb 07, 2001 at 05:00:12PM -0500, Brian Reichert wrote:
When I try to do a mysqldump on the localhost, I get an out-of-memory
error:
# mysqldump -uroot -proot customer audit_trail_271
mysqldump: Out of memory (Needed 8164 bytes)
mysqldump: Got
On Wed, Feb 07, 2001 at 06:24:58PM -0800, mike thomas wrote:
Hi all
I am running mysql on linux (redhat 6.2) using a regular 18Gb EIDI
hard drive. Does anyone know how much (ball park figure) a SCSI hard
drive would speed up selects and inserts?
That depends. Are your queryes CPU or disk
Jeremy,
My queries are disk bound (I think) from watching the Redhat
system monitor when running a query.
Mike
-Original Message-
From: Jeremy D. Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 07, 2001 4:07 PM
To: mike thomas
Cc: Mysql@Lists. Mysql. Com; [EMAIL
Hello,
I tried to send this using the 'scripts/mysqlbug' script but sendmail
barfed
Description: configure problem finding size of char type on Sparc 20
How-To-Repeat: I was doing a fully-standard configure script run
Fix: unsure at this stage
Submitter-Id: Craig Dewick "[EMAIL
Greg,
Well, I'm doing like "%stuff%" selects on a single column table
with 20 million records, so any speed gain would be great. Would
I be correct in saying that a select of this type will always do
a table scan?
I think I'll go with SCSI and increase the RAM so I can use a
heap table.
Thanks
One thing to keep in mind is IDE tends to eat up processor power where as off board
scsi doesn't.
Greg Cope wrote:
mike thomas wrote:
Hi all
I am running mysql on linux (redhat 6.2) using a regular 18Gb
EIDI hard drive. Does anyone know how much (ball park figure) a
SCSI hard
In the last episode (Feb 07), SF said:
I did, and that's where I don't understand why this is happening.
The furthest I was able to get in the manual and/or any of the
archives from MySQL is:
(straight out of the manual)
CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name
Title said it all.
How can I set up an asp page to allow me to insert a BLOB into MySQL?
Are there any file type/size restrictions to a large BLOB that could cause database
problems?
Any help would be greatly apreciated.
-Waldo B.
hi there. i've just joined the list. I took a look through the archives
and I think I've got the whole concept of JOIN wrong, but here goes.
Here's the task: I've got three tables, each with the same number of
records (8077, fwiw). they have 149, 149, and 80 columns.
There are a few columns
I am trying to copy data from one database to another using output from
mysqldump version 8.11 distributed with 3.23.28-gamma. The problem is that
part way through importing the data into the target database, mysql just
hangs. When I show the process list, there is only one query, and it's stuck
I want to SELECT on one term have the SELECT return as quickly as possible on the
first TRUE instance.
Ideally I'd like it to after the first matching case stop looking for other matches (
for speed ) and return 1. If there's no matches at all I want it to return 0.
This works OK but
Hi,
You are a bit on the wrong track - a join is a purely temporary thing, and
it would be an error for it to modify the database.
Perhaps what you are thinking of is a 'View', where the results of a select
appear like a table to the user. MySQL doesn't support them (yet).
Your command was
Greetings Miguel,
Step 1:
Identify all the information you want to track. Since you already have a
form, you probably have done that already.
Step 2:
Create your database. I recommend that if you are as new to this as you
sound that you install webmin www.webmin.com or phpMyAdmin
In the last episode (Feb 07), Brian Reichert said:
I apologize if this has been discussed already, but I quick poke
at the archives didn't reveal anything.
We have a table that iamchk says is fine. We are trying to get an
SQL dump of this table. But, we keep getting out-of-memory errors.
what is the simplest command to view data from a table?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
SELECT * FROM table_name;
This is explained in the manual, unless you want to use a GUI, then someone
else on the list may be able to help you.
- Original Message -
From: "Marc Bragg" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, February 08, 2001 10:26
Subject: table data
Hello,
I am a Linux-Mandrake installer of MySQL and have read no less
than 4 complete
installation guides:
-2 of included with the binary each different,
-1 online tutorial and
-1 from a published book)
and none of them work completely
I have unzipped, installed and tested.
-MySQL server
look in the scripts directory and use one of the db_install (or install_db) scripts.
It is failing because you do not have a mysql database defined...
On Wed, Feb 07, 2001 at 10:56:04PM -0500, root wrote:
Hello,
I am a Linux-Mandrake installer of MySQL and have read no less
than 4 complete
Hello,
Is it possible to interconnect two different Database Servers like Mysql
on Linux and MS-SQL 6.5 on Windows NT.
I am mean to say,Can we access both work on the data in above Database
Servers simultaneously.
Thanks in advance.
From,
Sangeeta.
([EMAIL
Please search the documents before posting (if you already haven't)
http://www.mysql.com/doc/R/e/Regexp.html
-- Atle
On Thu, 8 Feb 2001, wangzhw wrote:
hi:
whether mysql is supported by regular expressison? if it is supported,how to
express it by select query.
thank you!
Hi,
I have two tables city and country
+---+-+--+-+-++
| Field | Type| Null | Key | Default | Extra |
+---+-+--+-+-++
| id| int(5) | | PRI | 0 |
Hi all,
I use replication on MySQL. One of my ideas is to generate HTML pages
using PHP.
Will I have any troubles using PHP and connecting simultaneously to both
servers?
Thanks in advance for any comments.
Mariusz Brzezinski
WBK SA
tel. +48 61 856 53 57
mobile +48 501 623 123
88 matches
Mail list logo