Donna Robinson wrote
I am using OpenBSD 2.8
Why 2.8?
and spent a frustrating evening last night trying to
make MySql come to heel. Installed just fine - the first sign of
something
not right was inability to complete the run-all-tests scripts - just
hung
there gobbling up 95% CPU.
TT Is it possible to add new 8-bit character encoding to compiled
TT mysql (version 3.23.49-win) without recompiling?
No, you should re-configure and re-compile after adding new character
set. You can read instruction how to add new character set at:
On Saturday, April 06, 2002 at 5:32 PM,
Aravind NagaVenkata Gorthy asked:
Could any one tell me what all the chages I have to make in order
to make my existing (english version) of MySQL database compatable
to the Japanese language.
It's a little hard to read your mind. Have you read section
Hi,
I've got 2 tables in mysql, table 1 which contains records with fields like
+ADSM
in table 2, I got records like:
+ADSM anr2343E
+ADSM anr4523E
+ADSM anr7823E
now, i'd like to change each record in table1 where a field contains a +ADSM
entry, lookup the
Hello all,
I have setup a replication between two MySQL v4.01a servers on FreeBSD,
which works really fine. The only problem is that since we have MANY
updates on the master database, the bin-logs grow very fast. We need to
do a manual clean-up at least once every other day, otherwise the
Hi everyone,
I've been reading up about InnoDB tables and they seem to have lots of
advantages. I'm particularly interested in using the foreign keys as this
will save me some much need time. In the benchmark tests on the InnoDB
website they show up faster than MyISAM tables but will foreign
Taavi Tiirik asked:
Thanks. Let me put it this way then... There are character set
configuration
files in mysql/share/charsets directory of binary distribution of mysql.
If
these
files cannot be used for defining new character sets then what is their
purpose?
These files are used for
Hi,
i'd like to alter a table which have a date and time field so 3 Bytes for
date and 3 Bytes for time.
I'd table to add a new field to store date like this : MMDDHHMMSS.
In fact, I can't use indexes on sql query like select with order by with 2
fields date + time and with
one unique field
Would you not be better of just runing myisamchk from crontab?
Simon
./myisamchk Ver 1.52 for unknown-freebsdelf4.1 at i386
By Monty, for your professional use
This software comes with NO WARRANTY: see the PUBLIC for details.
Description, check and repair of ISAM tables.
Used without options
I don't know what this (below) is, but gee, it seems good :-)
Best wishes
--
Pierre du Parté
Final Filer Software
349 Worrigee Road
Worrigee, NSW, Australia 2540
http://www.finalfiler.com
Phone 61 2 44216374
Mobile 0413 483 066
If it feels good, do it!
J Williamson wrote:
Would you not
hye all ,
What is the SQL syntax for inserting records in child table ( i am
using foreign keys and
innodb table types ) .
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Yes you are right
We lock tables to run this but only when we have problems.
One more thing I would do is run 'show processlist' and mail it to my self
to see how thing are going.
Simon
PS have you tried mytop?
No, I did not try mytop, but I'll give it a try now :)
Another question:
MM.MySQL-2.0.12, a JDBC driver for MySQL was released yesterday. It can be
found at http://sourceforge.net/mmmysql/
Changes include:
- General code cleanup.
- Added getIdleFor() method to Connection and
MysqlLogicalHandle.
- Relaxed synchronization in all classes,
Luke,
How exactly will the foreign keys save you time? Please explain.
Ric.
- Original Message -
From: Luke van Blerk [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, April 09, 2002 9:17 AM
Subject: InnoDB tables
Hi everyone,
I've been reading up about InnoDB tables and
Hi Richard
I'm writing a web application in PHP with a MySQL backend. I'm a novice at
both PHP and MySQL having started with both about November last year and I'm
also new to programming at large so please excuse any question which may
seem obvious.
The foreign keys are to be used to enforce
Hi,
I use all this in the same order and i don't have any problems:
CHECK TABLE
IF (CHECK TABLE!=OK)
{
REPAIR TABLE
}
// i don't use analyze tables
OPTIMIZE TABLE
Before to perform this commands, you must be sure is not any users connected
(show full
Sent: Tuesday, April 09, 2002 2:14 PM
Subject: Re: TIMESTAMP(14) or Bigint ??
David,
I could be wrong but since bigint isn't a date or time oriented data
type I imagine this would be completely useless to you unless you are
storing unix timestamps.
In fact i'm looking to a way to store
Sent: Tuesday, April 09, 2002 2:14 PM
Subject: Re: TIMESTAMP(14) or Bigint ??
David,
I could be wrong but since bigint isn't a date or time oriented data
type I imagine this would be completely useless to you unless you are
storing unix timestamps.
In fact i'm looking to a way to store
Kannan,
Tuesday, April 09, 2002, 7:54:07 AM, you wrote:
K You need to create a user mysql and also create a group mysql and add the user
K to the group..You will find this in the installation docs..
Using commands of your OS ...
It is described in the MySQL manual in the section 2.2.7
Kathy,
Monday, April 08, 2002, 10:10:04 PM, you wrote:
KR Can anyone tell me how can I uninstall mysql. I have done it again. I have
KR messed up my permission.
KR I dont know what is is that i'm doing that makes me loose my previleges.
KR I keep getting the access denied error
Before
LeTortorec,
Tuesday, April 09, 2002, 12:17:06 AM, you wrote:
Leoen I have a table with the following fields:
Leoen id=autoincrement, int (11)
Leoen ts_h=decimal
Leoen ts_pid=int (11)
Leoen ts_day=text
Leoen There is a unique record where ts_pid=60 and ts_day=2002032800
Chris,
Tuesday, April 09, 2002, 3:22:00 PM, you wrote:
CL Still having this trouble with mysql.. Running the mysql_install_db renders
CL this...
CL Preparing db table
CL Preparing host table
CL Preparing user table
CL Preparing func table
CL Preparing tables_priv table
CL Preparing
Barry,
Monday, April 08, 2002, 8:33:02 PM, you wrote:
BB I have a system here based on Red Hat's 7.2 distribution and I am wanting to
BB get MySQL up and running. After browsing your web page it seems that I will
BB have go to a different version of gcc. Would I be safe to go to the latest
BB
GOLDEN,
Monday, April 08, 2002, 11:09:36 PM, you wrote:
GS Would you help me, how to install, setup, and configure MySQL in my server
GS with O/S windows 2000 server and IIS v. 5
Installation on Windows is covered in the manual, please check
following links:
Heiki,
I have a question concerning the new auto-extending function (which sounds
really cool by the way!). How does it handle the case where it runs out of
disk space while expanding? Will it gracefully handle this scenerio or will
some sort of recovery be necessary?
Carl McNamee
Systems
From my limited experience. I believe your gonna have to split that one
field of alpha and numeric into two fields one for the alpha info and one
for the numeric info. Then you can sort the information the way you want.
Mike
- Original Message -
From: Luc Foisy [EMAIL PROTECTED]
To:
Hello everyone
I want to alter 50 tables, and for each the names start with the string
'mak'
Is there an SQL query, so that I can do the change in one command.
I have tried using wildcards - they don't seem to work in SQL.
Thanks in advance.
Aman
Is there a way to store files in MySQL? Looking to store somthing like a
zip file in the databaseand be able to retrieve/download it from something like ASP.
Thanks
-Nick
-
Before posting, please check:
Hello everyone
I want to alter 50 tables, and for each the names start with the string
'mak'
Is there an SQL query, so that I can do the change in one command.
I have tried using wildcards - they don't seem to work in SQL.
Thanks in advance.
Aman
I am using Linux 7.2 OS.
I think reseting the root password fixed it. Because I was no able to log
in.
I'm not really running any queries to the mysql database that why i'm not
sure whats causing this problem.
I also cant figure out why when I type mysql it doesnt doesnt use the
password and I
On Monday 08 April 2002 10:09 pm, Daniel Jarrett wrote:
i'm building a table in MYSQL that has about 30 fields..
is this inefficient to have a large number of columns?
Not necessarily, no. Often, it is more efficient.
if anyone can direct me to some good info on efficient design tips/
Hi,
I been using mysqlimport for a long time with no problems.
But today when I try (as root)
mysqlimport admin /usr/local/systems/admin/data/person.txt -p
I get
mysqlimport: Error: Can't get stat of
'/usr/local/systems/admin/data/person.txt' (Errcode: 13), when using
table:
person
even
I am playing around with portable sql queries (mysql, oracle and
postgres). When executing:
ipplan= BEGIN;
BEGIN
ipplan= INSERT INTO area (areaaddr, descrip, customer) VALUES
(16777216, 'kjshdf', 1) ;
ERROR: Cannot insert a duplicate key into unique index
area_areaaddr_key
ipplan= SELECT
The server does not shutdown. It just stops responding.
Best Regards
Tommy Jensen
http://www.sc-resources.net
- Original Message -
From: Miguel Angel Solorzano [EMAIL PROTECTED]
To: ServiceCenter resources [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, April 09, 2002 7:11 AM
Hi all,
I am pretty new to mySQL actually I started yesterday.
mySQL with innoDB handles integrity constraints.
I tried :
create table a (
id varchar(3) not null,
primary key(id) )
TYPE=INNODB;
insert into a values ('aaa');
create table b (
id varchar(3) not null,
a_id varchar(3),
The insert into b values ('BBB', NULL) statement should fail under the conditions
you describe, BBB was not inserted into the A table, and therefore the foreign key
constraint fails as it should.
Rance Hall
308.238.2455
Internal Office Extensions: 2455 or 6655
PC Programmer, The Buckle, Inc.
On 4/8/2002 7:25 PM, Paul DuBois [EMAIL PROTECTED] wrote:
At 17:52 -0700 4/8/02, Jim Dickenson wrote:
I am having problems getting the load data local infile working.
I am running Mac OS X 10.1.3 build 5Q110 with all available updates
installed.
I had installed version 3.23.49 from
Nope
insert into b values ('BBB',null);
here:
BBB is PK of table b
null is FK of table b referencing table a
for example
insert into b values ('BBB','aaa');
works well
Alain
- Original Message -
From: Rance Hall [EMAIL PROTECTED]
To: Alain Del Giust [EMAIL PROTECTED]; [EMAIL
At 9:31 -0700 4/9/02, Jim Dickenson wrote:
On 4/8/2002 7:25 PM, Paul DuBois [EMAIL PROTECTED] wrote:
At 17:52 -0700 4/8/02, Jim Dickenson wrote:
I am having problems getting the load data local infile working.
I am running Mac OS X 10.1.3 build 5Q110 with all available updates
well, your right about one thing, I did misread the order of your SQL statement, but
if you have a foreign key constraint, that field must be one of the values of the
referenced column, and that column, being an index, is never NULL
so inserting NULL into a properly configured foreign key
... but the key NULL does not exist on the table a, but it should!!!
Adib.
Alain Del Giust wrote:
Nope
insert into b values ('BBB',null);
here:
BBB is PK of table b
null is FK of table b referencing table a
for example
insert into b values ('BBB','aaa');
works well
Alain
if you have a foreign key constraint, that field must be one of the values
of the referenced column and that column, being an index, is never NULL
OK so my understanding is that it is impossible with mySQL to do such things
wich are basic with at least:
Oracle
Sybase Adaptive Server Enterprise
On Tuesday 09 April 2002 11:07 am, Alain Del Giust wrote:
if you have a foreign key constraint, that field must be one of the values
of the referenced column and that column, being an index, is never NULL
OK so my understanding is that it is impossible with mySQL to do such
things wich are
On 4/9/2002 9:41 AM, Paul DuBois [EMAIL PROTECTED] wrote:
At 9:31 -0700 4/9/02, Jim Dickenson wrote:
On 4/8/2002 7:25 PM, Paul DuBois [EMAIL PROTECTED] wrote:
At 17:52 -0700 4/8/02, Jim Dickenson wrote:
I am having problems getting the load data local infile working.
I am running Mac
At 10:14 -0700 4/9/02, Jim Dickenson wrote:
This still leaves the question as to when version 3.23.49a will
be compiled
for Mac OS X, instead of version 3.23.47.
I always compile my own. Is there some reason you don't do that?
There are many messages on this list that say use the
On Tuesday 09 April 2002 11:47 am, Alain Del Giust wrote:
I am just testing mySQL so I will be able to use it instead of Oracle
Sybase ...
I am not saying a PK can be NULL wich is impossible
But a FK can be NULL and I'd like to know how to do that with mySQL
I do not see this as being
Carl,
when it runs out of disk space the auto-extend feature prints to the MySQL
error log a complaint that disk space has run out, and stops extending the
file.
If you do not give it more free disk space, InnoDB behaves as if it would
have a fixed size data file. That is, you will get the
I have a redhat 7.1 server, I want to get rid of the installed mysql
server. How can check which version is installed and how to get rid of it?
Thanks
Jianping Zhu
Department of Computer Science
Univerity of Georgia
Athens, GA 30602
Tel 706 5423900
Hi,
Try with SELECT VEERSION() from mysql client.
- Original Message -
From: Jianping Zhu [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, April 09, 2002 9:55 AM
Subject: How to check which version of mysql is installed
I have a redhat
-Original Message-
From: Alain Del Giust [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 12:48 PM
To: Christopher Thompson; [EMAIL PROTECTED]
Cc: Rance Hall
Subject: Re: mySQL and innoDB
I am just testing mySQL so I will be able to use it instead
of Oracle Sybase
FOREIGN KEYs by themselves make it faster and easier to validate that your
code is correctly maintaining referrential integrity.
They also let O/R mappers do more of the work in generating code for
accessing your data (Blatant Plug: http://freshmeat.net/projects/easyorm/ --
EasyORM is an O/R
Hi!
From the changelog of 3.23.50:
* We suppress the FOREIGN KEY check if any of the column values in the
foreign key or referenced key to be checked is the SQL NULL. This is
compatible with Oracle, for example.
It is conceptually a bit strange that we first declare a FOREIGN KEY
constraint,
hi,
i'd like to know which ODBC driver is most suitable, fast and reliable for
win98.
I tried myodbc 2.50.39, but the dll was faulty, i had to replace it by the
2.50.36(on win2k!).
On win98 now am using the latest 3.51.01, but it has slown down the machine
so much, it's incredible.
So now am
References: [EMAIL PROTECTED]
From: Scott Gifford [EMAIL PROTECTED]
Date: 09 Apr 2002 15:40:38 -0400
In-Reply-To: [EMAIL PROTECTED]'s message of Tue, 9 Apr 2002 21:28:35 +0200
Message-ID: [EMAIL PROTECTED]
Lines: 33
User-Agent: Gnus/5.0807 (Gnus v5.8.7) Emacs/20.7
MIME-Version: 1.0
Content-Type:
hi,
if i try to download the latest odbc driver i get a file with 43k. what
is wrong ? the original file on
http://www.mysql.com/downloads/api-myodbc-3.51.html is over 602K...
what have i to do?
-
Before posting, please
Sorry, this came out ugly. I misinterpreted the list filter's
comments, and thought it would post my original message if I replied
to it, but instead it posted my reply including its warning.
Here's my original question, which is indeed about MySQL, although it
does not contain the words SQL or
Kathy,
Tuesday, April 09, 2002, 5:43:23 PM, you wrote:
KR I am using Linux 7.2 OS.
KR I think reseting the root password fixed it. Because I was no able to log
KR in.
Ok, try to reset root password according to step-by-step instruction
in the manual. Don't forget execute FLUSH PRIVILEGES
Hi,
Can I use the MD5 function in the where clause, as in:
Select * from table where md5(column)=value
spam filter: mysql
Andrew Hazen
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
On Tuesday 09 April 2002 2:13 pm, Andrew Hazen wrote:
Hi,
Can I use the MD5 function in the where clause, as in:
Select * from table where md5(column)=value
I see no reason why not but note that you are likely MUCH better off storing
column as an MD5 hash, computing the MD5 of value,
Hi !!
-Original Message-
From: Ralph Walther [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 12:43 PM
To: [EMAIL PROTECTED]
Subject: download latest odbc-driver
hi,
if i try to download the latest odbc driver i get a file with 43k. what
is wrong ? the original file
Hi !!
-Original Message-
From: Christopher Thompson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 1:39 PM
To: Guy-Maurice Lepoutre; [EMAIL PROTECTED]
Subject: Re: Creating a mysql database usinc VC++
On Tuesday 09 April 2002 2:30 pm, Guy-Maurice Lepoutre wrote:
I have one query, that basically reads from one table of 13 million rows,
groups it by two fields, and inserts into a rollup table. The result set
ends up being about 31,000 rows. This runs in about 2 minutes which is
acceptable. However, I add an additional group by field, which will probably
On Mon, Apr 08, 2002 at 01:32:59PM +0200, ddd wrote:
HI,
I want to insert into db 200.000.000 records of type (int6,int6)..
the structure is:
CREATE TABLE word_page (
IDword mediumint(6) NOT NULL default '0',
IDpage mediumint(6) NOT NULL default '0',
KEY IDword (IDword)
Hi.
Is there a chance that you make this behaviour dependend on the --ansi
switch? I never used foreign keys until now, but from the theory I
would expect that a missing not null declaration on a FK declaration
should either be implicitly assumed or result in an error - at least
on insert.
I
Hi.
For what I know, MySQL always reads a whole row if it has to read the
row at all. So, no, column order should not matter at all.
With MyISAM tables, indexes are in a seperate file, build their own
way. So no, also no influence. I don't know enough about InnoDB to say
something for sure, but
Hello.
First, key_buffer=16M seems a bit low for me with 13 million rows
(well, depends on the indexes, and how much free memory you have, of
course).
If I am not mistaken, sort_buffer/tmp_table_size are the one mostly
needed for this query, I think. Btw, you can get more info about the
query
On Tue, Apr 09, 2002 at 05:30:06PM -0700, David Turner wrote:
I would like to make install to my home directory but can't seem to get it to
work.
make install prefix=/home/turner/mysql/test
It keeps wanting to install to /usr/local even though I pass the
prefix parm.
./configure
Thanks, but what I need to do is have
make install install everything into /home/turner/mysql/test then I'll
check everything out to make sure it is how I want it and last I'll copy it all
to /usr/local.
Any way to do this
./configure --prefix=/usr/local (default)
make
make install
Hey Guys,
What is the command to add up the amount of rows in a total?
I need to know how many total reviews are in my table for each category
name, im using this query and it doesn't work:
SELECT SUM(name) AS articletotal WHERE category = 'Processors'
mysql
Thanks!
Benjamin Pflugmann [EMAIL PROTECTED] writes:
Hello.
First, key_buffer=16M seems a bit low for me with 13 million rows
(well, depends on the indexes, and how much free memory you have, of
course).
1 gig, plenty free.
If I am not mistaken, sort_buffer/tmp_table_size are the one mostly
Do anybody knows the range of MEDIUMINT, and BIGINT type to use
when I do the create table in mySQL ?
Son Nguyen
__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
Do anybody knows the range of MEDIUMINT, and BIGINT type to use
when I do the create table in mySQL ?
Son Nguyen
sql, query
__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
I have two mysql servers in a machine. OS is linux and system is dell.
I ran the servers in a separate datadir, socket and port yesterday. But
after six hours from the start two of them corrupted accidently.
I ran two servers from remote terminal. And there was no problem until
I exited from
G'day Son Nguyen
Do anybody knows the range of MEDIUMINT, and BIGINT type to use
when I do the create table in mySQL ?
From the manual at http://www.mysql.com/doc/C/o/Column_types.html
MEDIUMINT[(M)] [UNSIGNED] [ZEROFILL]
A medium-size integer. The signed range is -8388608 to 8388607.
It seems that an internet connection from a browser to my unix/apache hosted
mysql database presents itself as some user to whom I haven't yet given
permissions because the calling web page gives up without a whimper. I have
generous permissions for 'root', 'nobody' and 'localhost'. The perl
When a slave crashes or reboots, it should start replicating from where it
left off--at least ours do work that way. The current replication state
is saved in master.info on the slave and when it starts up again, it
should read that file and resume reading the binlog on the master where it
left
i got a MySQL database that my supervisor wats me to do an ER diagram
for. The problem is that there is no/not much documentation on this
database. Also one cannot draw an ER-Diagram by looking at the mySQL-
Database, since there is no way (i know of) i can defining logical
relationships
I need to know how many total reviews are in my table for each category
name, im using this query and it doesn't work:
SELECT SUM(name) AS articletotal WHERE category = 'Processors'
Try
SELECT count(name) AS articletotal FROM tablename WHERE category =
'Processors'
Sincerely,
Craig
I use MySQL server replication last month, but currently I stopped using
it...coz for some reason
1. my master server is running on windows 98 platform, I cant prevent
it from hanging-up
2. my slave server is running on windows 98 also, I cant prevent it
also from hanging-up
3. if
hi everybody,
i have problem with storing chinese word to databaseall the chinese
automatic change to code like this #31639;#30424;#12290; its not only
waste the space, also i have problem to display it...sometime, some of the
word not complete and also display symbols.is there anybody
The web application is running in an environment *outside* of the server,
compared to your context, which may be 'root@localhost', for instance.
The browser's context, then, might be '[EMAIL PROTECTED]'; thus, you will
need to add an entry to m,ysql.user table.
C:~
-Original Message-
Check the documentation:
6.2.6.1 Storage requirements for numeric types
http://www.mysql.com/doc/n/o/node_365.html
C:~
-Original Message-
From: Son Nguyen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 6:30 PM
To: [EMAIL PROTECTED]
Subject: Range of MEDIUMINT,
On Wed, 10 Apr 2002 03:59:22 +
saraswathy saras [EMAIL PROTECTED] wrote:
hi everybody,
i have problem with storing chinese word to databaseall the chinese
automatic change to code like this #31639;#30424;#12290; its not only
waste the space, also i have problem to display
To start MySQL, are you using, minimum, the following?
./safe_mysqld
2.4.2 Problems Starting the MySQL Server
http://www.mysql.com/doc/S/t/Starting_server.html
2.4.3 Starting and Stopping MySQL Automatically
http://www.mysql.com/doc/A/u/Automatic_start.html
C:~
Check the Contributed Software page:
Contributed software - http://www.mysql.com/downloads/contrib.html
APIs
Clients
Web Tools
Performance Benchmarking Tools
Authentication Tools
Converters
Using MySQL with Other
Hi,
I am geeting an error Unexpected
Exception: java.io.IOException message given: Unexpected end of input stream
Is there any limitation on the length of the query string (In mm.mysql
driver?)? Can any one help me out to avoid this error.
LOG:
SELECT
86 matches
Mail list logo