Re: MySQL compile error, mysql-3.23.47, Mac OS X 10.1.2

[Ryan Walker]

Yes.

Dumb question. You did install the OS X developer tools, yes?

I just compiled 3.23.47 from source this morning on 10.1.2 with not a
problem at all.

--
John McCauley
CTGi
Oakton, VA
703-352-0590
http://www.ctgusa.com

 From: Ryan Walker [EMAIL PROTECTED]
 Date: Tue, 29 Jan 2002 18:40:12 -0800
 To: [EMAIL PROTECTED]
 Subject: MySQL compile error, mysql-3.23.47, Mac OS X 10.1.2

 I'm trying to compile MySQL on Mac OS X 10.1.2. Ideally, I'd like to
 compile it with:
 ./configure --with-mysqld-user=mysql \
 --enable-thread-safe-client \
 --with-pthread \
 --with-raid

 Unfortunately, I can't even get it to compile with just:
 ./configure

 Produces error:
 sql_show.cc
 c++ -DMYSQL_SERVER
 -DDEFAULT_MYSQL_HOME=\/usr/local\  -DDATADIR=\/usr/local/var\
 -DSHAREDIR=\/usr/local/share/mysql\
 -DHAVE_CONFIG_H -I./../include -I./../regex
 -I. -I../include -I.. -I.-O3 -DDBUG_OFF   -fno-implicit-templates
 -fno-exceptions -fno-rtti -traditional-cpp -DHAVE_DARWIN_THREADS
 -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ
 -c sql_udf.cc
 sql_udf.cc:57: dlfcn.h: No such file or directory
 make[3]: *** [sql_udf.o] Error 1
 make[2]: *** [all-recursive] Error 1
 make[1]: *** [all-recursive] Error 1
 make: *** [all-recursive-am] Error 2


 Any suggestions?

 Ryan

 -
 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 [EMAIL PROTECTED]
 To unsubscribe, e-mail
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

How to get connected with mysql using perl scripts

[Charitha]

Hi all,

Please guide me to get the connection with mysql through perl scripts and
through the scripts i have to insert some lot of data in the existing
tables.

Thank you.

Regards,
Charitha.


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

AW: MySQL 3.23.47 on MacOSX 10.1.2: Could someone help me getting started

[Lutz, Helmuth]

Paul,

Okay, then try adding the --user=mysql option to the command.

I killed the server (kill -9) and brought it back up with -Sg --user=mysql:

The result:
[localhost:/usr/local/mysql] root# /usr/local/mysql/bin/mysqld -Sg
--user=mysql
--- Here came some hints
Cannot initialize InnoDB as 'innidb_data_file_path' is not set.
If you do not want to use transactional InnoDB tables, add a line
skip-innodb
to the [mysqld] section of init parameters in your my.conf
or my.ini. If you want to use InnoDB tables, add for example,
innodb_data_file_path = /mysql/data/ibdata1:20M
But to get good performance  
---end hint and this line
/usr/local/mysql/bin/mysqld: ready for connections

This looks nice I think

but then I made this mistake:
I copy and pasted 2 lines to the terminal (instead of writing them)
and had the cursor in the 3rd line. I tried to escape without success.

--- My page looks like this:
/usr/local/mysql/bin/mysqld: ready for connections
UPDATE user SET Password=PASSWORD('new-password') 
WHERE User='root' AND Host='localhost';

exit
exit;
quit;
stop;
mysqld test;
  -- here is the cursor

--- end of my page

1)How can I escape? 
2) would it have been ok if I had used following line at this point?
UPDATE user SET Password=PASSWORD('myNewPassword') WHERE User='root' AND
Host='localhost';

Thanks, Helmuth

-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: renice -20 $$ in safe_mysqld

[Wouter de Jong]

On Mon, Jan 28, 2002 at 05:30:00PM +0200, Egor Egorov wrote:

Hi,

 In any place that is reached by the scope of execution of safe_mysqld. It must do 
fine right in the beginning of the script.

It doesn't, or I am making a mistake :

If I put renice -20 $$ (tried it on several places in safe_mysqld), I get the 
following:

32606: old priority 0, new priority -20
Starting mysqld daemon with databases from /opt/mysql/var
- NICE: nice ---15 nohup -- debug line i added
020130 11:16:20  mysqld ended

The .err shows:

020130 11:16:20  mysqld started
nice: unrecognized option `---15'
Try `nice --help' for more information.
020130 11:16:20  mysqld ended

-- 
Met vriendelijke groet/With kind regards,

Wouter de Jong

-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: How to get connected with mysql using perl scripts

[SubbaReddy M]

Hi,

Check the following links:

http://dbi.symbolstone.org/
http://www.saturn5.com/~jwb/dbi-examples.html
http://www.oreilly.com/catalog/perldbi/

Best of luck.


~ SubbaReddy .M
  E-mail: [EMAIL PROTECTED]
  W3Page:  http://www.geocities.com/msubbareddy/
  ICQ: 56093095


- Original Message -
From: Charitha [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, January 30, 2002 1:51 PM
Subject: How to get connected with mysql using perl scripts




 Hi all,

 Please guide me to get the connection with mysql through perl scripts and
 through the scripts i have to insert some lot of data in the existing
 tables.

 Thank you.

 Regards,
 Charitha.


 -
 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 [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Urgent Help needed

[SubbaReddy M]

Hi Srinivas,

Here is some info, may meet ur requirement.

ALTER TABLE syntax :-

ALTER [IGNORE] TABLE tbl_name alter_spec [, alter_spec ...]

alter_specification:
ADD [COLUMN] create_definition [FIRST | AFTER column_name ]
  orADD INDEX [index_name] (index_col_name,...)
  orADD PRIMARY KEY (index_col_name,...)
  orADD UNIQUE [index_name] (index_col_name,...)
  orALTER [COLUMN] col_name {SET DEFAULT literal | DROP DEFAULT}
  orCHANGE [COLUMN] old_col_name create_definition
  orMODIFY [COLUMN] create_definition
  orDROP [COLUMN] col_name
  orDROP PRIMARY KEY
  orDROP INDEX key_name
  orRENAME [AS] new_tbl_name
  ortable_option

ALTER TABLE allows you to change the structure of an existing table. For
example, you can add or delete columns, create or destroy indexes, change
the type of existing columns, or rename columns or the table itself. You can
also change the comment for the table and type of the table. See section 7.6
CREATE TABLE syntax.

If you use ALTER TABLE to change a column specification but DESCRIBE
tbl_name indicates that your column was not changed, it is possible that
MySQL ignored your modification for one of the reasons described in section
7.6.1 Silent column specification changes. For example, if you try to change
a VARCHAR column to CHAR, MySQL will still use VARCHAR if the table contains
other variable-length columns.

ALTER TABLE works by making a temporary copy of the original table. The
alteration is performed on the copy, then the original table is deleted and
the new one is renamed. This is done in such a way that all updates are
automatically redirected to the new table without any failed updates. While
ALTER TABLE is executing, the original table is readable by other clients.
Updates and writes to the table are stalled until the new table is ready.

To use ALTER TABLE, you need select, insert, delete, update, create and drop
privileges on the table.
IGNORE is a MySQL extension to ANSI SQL92. It controls how ALTER TABLE works
if there are duplicates on unique keys in the new table. If IGNORE isn't
specified, the copy is aborted and rolled back. If IGNORE is specified, then
for rows with duplicates on a unique key, only the first row is used; the
others are deleted.
You can issue multiple ADD, ALTER, DROP and CHANGE clauses in a single ALTER
TABLE statement. This is a MySQL extension to ANSI SQL92, which allows only
one of each clause per ALTER TABLE statement.
CHANGE col_name, DROP col_name and DROP INDEX are MySQL extensions to ANSI
SQL92.
MODIFY is an Oracle extension to ALTER TABLE.
The optional word COLUMN is a pure noise word and can be omitted.
If you use ALTER TABLE tbl_name RENAME AS new_name without any other
options, MySQL simply renames the files that correspond to the table
tbl_name. There is no need to create the temporary table.
create_definition clauses use the same syntax for ADD and CHANGE as for
CREATE TABLE. Note that this syntax includes the column name, not just the
column type. See section 7.6 CREATE TABLE syntax.
You can rename a column using a CHANGE old_col_name create_definition
clause. To do so, specify the old and new column names and the type that the
column currently has. For example, to rename an INTEGER column from a to b,
you can do this:
mysql ALTER TABLE t1 CHANGE a b INTEGER;

If you want to change a column's type but not the name, CHANGE syntax still
requires two column names even if they are the same. For example:
mysql ALTER TABLE t1 CHANGE b b BIGINT NOT NULL;

However, as of MySQL 3.22.16a, you can also use MODIFY to change a column's
type without renaming it:
mysql ALTER TABLE t1 MODIFY b BIGINT NOT NULL;

If you use CHANGE or MODIFY to shorten a column for which an index exists on
part of the column (for instance, if you have an index on the first 10
characters of a VARCHAR column), you cannot make the column shorter than the
number of characters that are indexed.
When you change a column type using CHANGE or MODIFY, MySQL tries to convert
data to the new type as well as possible.
In MySQL 3.22 or later, you can use FIRST or ADD ... AFTER col_name to add a
column at a specific position within a table row. The default is to add the
column last.
ALTER COLUMN specifies a new default value for a column or removes the old
default value. If the old default is removed and the column can be NULL, the
new default is NULL. If the column cannot be NULL, MySQL assigns a default
value. Default value assignment is described in section 7.6 CREATE TABLE
syntax.
DROP INDEX removes an index. This is a MySQL extension to ANSI SQL92.
If columns are dropped from a table, the columns are also removed from any
index of which they are a part. If all columns that make up an index are
dropped, the index is dropped as well.
DROP PRIMARY KEY drops the primary index. If no such index exists, it drops
the first UNIQUE index in the table. (MySQL marks the first UNIQUE key as
the PRIMARY KEY if no PRIMARY KEY was 

Re: FULLTEXT sintax.

[Diana Soares]

Hi, 

I don't know if you have already an answer to you problem but.. 
There is an explanation to this bisarre result:

-

++---+-+
| id | title| body |
++---+-+
|  1 | MySQL Tutorial   | DBMS stands for DataBase Manag   |
|  2 | How To Use MySQL Efficiently | After you went through a ... |
|  3 | Optimising MySQL | In this tutorial we will show .. |
|  4 | 1001 MySQL Trick | Never run mysqld as root.|
|  5 | MySQL vs. YourSQL| In this database comparison we.. |
++---+-+

Every correct word in the collection and in the query is weighted,
according to its significance in the query or collection. This way, a
word that is present in many documents will have lower weight (and may
even have a zero weight), because it has lower semantic value in this
particular collection. Otherwise, if the word is rare, it will receive a
higher weight. The weights of the words are then combined to compute the
relevance of the row.

Such a technique works best with large collections (in fact, it was
carefully tuned this way). For very small tables, word distribution does
not reflect adequately their semantical value, and this model may
sometimes produce bisarre results.

mysql SELECT * FROM articles WHERE MATCH (title,body) AGAINST
('MySQL');
Empty set (0.00 sec)

Search for the word MySQL produces no results in the above example. Word
MySQL is present in more than half of rows, and as such, is effectively
treated as a stopword (that is, with semantical value zero). It is,
really, the desired behavior - a natural language query should not
return every second row in 1GB table.
-

This was taken from:
http://mysql.com/doc/F/u/Fulltext_Search.html


On Thu, 2002-01-24 at 08:59, Victor Hugo Reus Valiente wrote:
 Hi there.
 
 Im having some troubles with mysql and FULLTEXT.
 I create one table like this:
 create table pets (id INT AUTO_INCREMENT NOT NULL PRIMARY KEY);
 alter table pets add name TEXT;
 alter table pets add kind TEXT;
 alter table pets add FULLTEXT name (name);
 alter table pets add FULLTEXT kind (kind);
 
 Now, I have the next rows:
 ID  NAME KIND
 1Boby   Asiatic and colored
 2Linda   American, non fustable
 3Boby   Spanish, colored and kindly
 
 ... etc
 
 When I do
 Select * from pets where MATCH (name) against ('boby');
 
 I´ts giving me 0 results as response...
 
 Whereis the problem, I have, boby twice and it return me 0 as result.
 ¿What I doing wrong?
 
 Thanks to everibody.
 Victor Reus.
 
 
 -
 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 [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 
-- 
Diana Soares
Websolut - Soluções Internet
Email: [EMAIL PROTECTED]


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

minimal SQL

[Håkan Elmqvist]

I am new to databases and SQL and find the language rich and interesting.
It seems to me, however, that there are quite a few redundant elements and 
that the language is the result of quite a few compromises. There are not 
less than 233 keywords in MySQL.
Is there any preferred way to write SQL-statements?
Is there any purist or minimalist view?

Håkan Elmqvist


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: How to get connected with mysql using perl scripts

[SubbaReddy M]

And here some more good links for DBI:

http://www.he.net/adm/mysql/chapter7.html
http://www.he.net/adm/mysql/chapter6.html

~ SubbaReddy .M
   Sr. Programmer, Frontlinesoft, Hyderabad  (
http://www.frontlinesoft.com )
   Ph: 91-40-3392147, 3391683
   w3doc: http://www.geocities.com/msubbareddy/
   ICQ: 56093095



From: SubbaReddy M [EMAIL PROTECTED]
To: Charitha [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, January 30, 2002 3:42 PM
Subject: Re: How to get connected with mysql using perl scripts


 Hi,

 Check the following links:

 http://dbi.symbolstone.org/
 http://www.saturn5.com/~jwb/dbi-examples.html
 http://www.oreilly.com/catalog/perldbi/

 Best of luck.


 ~ SubbaReddy .M
   E-mail: [EMAIL PROTECTED]
   W3Page:  http://www.geocities.com/msubbareddy/
   ICQ: 56093095


 - Original Message -
 From: Charitha [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Wednesday, January 30, 2002 1:51 PM
 Subject: How to get connected with mysql using perl scripts


 
 
  Hi all,
 
  Please guide me to get the connection with mysql through perl scripts
and
  through the scripts i have to insert some lot of data in the existing
  tables.
 
  Thank you.
 
  Regards,
  Charitha.
 
 
  -
  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 [EMAIL PROTECTED]
  To unsubscribe, e-mail
 [EMAIL PROTECTED]
  Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 
 


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: for You

[Marjolein Katsma]

At 01:13 2002-01-30, Engr Duke Paul [EMAIL PROTECTED] wrote:
NIGERIAN NATIONAL PETROLEUM CORPORATION
(DEPARTMENT OF PETROLEUM RESOURCES) 

And he subscribed to this list, right?


Grrr: database,sql,query,table

-- 
Marjolein Katsma
HomeSite Help - http://hshelp.com/ - Extensions, Tips and Tools
The Bookstore - http://books.hshelp.com/ - Books for webmasters and webrookies


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Urgent Business Assistance.

[Marjolein Katsma]

At 03:52 2002-01-30, Todd Williamsen wrote:
If its so urgent and private then why are you spamming a mail list?  I
smell scam, or is that Spam?

It's both.

And please do not quote the *whole* spam - the loss of bandwidth (it goes to every 
subscriber!) from the actual spam is already bad enough.

Replying to the spammer is useless, too - they do NOT subscribe. Spammers are lazy.

Grrr: database,sql,query,table

-- 
Marjolein Katsma
HomeSite Help - http://hshelp.com/ - Extensions, Tips and Tools
The Bookstore - http://books.hshelp.com/ - Books for webmasters and webrookies


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: for You

[Markus Lervik]

On Wednesday 30 January 2002 13:02, Marjolein Katsma wrote:
 At 01:13 2002-01-30, Engr Duke Paul [EMAIL PROTECTED] wrote:
 NIGERIAN NATIONAL PETROLEUM CORPORATION
 (DEPARTMENT OF PETROLEUM RESOURCES)

 And he subscribed to this list, right?
 Grrr: database,sql,query,table

Stop griping. I'm annoyed about it too, but every mail complaining
about spam becomes quite quickly spam itself.

You've got three options as I see it  (and this goes for all of you 
anti-spam-spammers, too):

a) Ignore the spam. It's about two-three mails per day. It's not that big a deal.
Just hit the delete-button, and it's been taken care of.

b) Set up mail-filtering. A filter that directs mails containing NIGERIAN PETROLEUM 
CORPORATION
straight to the waste bin. A few days, a few spam-mails and you'll have a working
anti-spam-filter right at home. (See? If you'd have that, you wouldn't even get this 
mail.)

c) Unsubscribe from the list if it bothers you that much. We've (unfortunately) seen 
at least one 
individual unsubscribing, not too long ago, because of the spam.


Cheers,
Markus

-- 
Markus Lervik
Linux-administrator with a kungfoo grip
Vaasa City Library - Regional Library
[EMAIL PROTECTED]
+358-6-325 3589 / +358-40-832 6709

-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Urgent Business Assistance.

[Engr.Martin Douglas.]

Urgent Business Asistance.

Engr.Martin Douglas.
No. 16 Kingsway road,
Ikoyi lagos
Nigeria.

Tel/Fax:: 234-1-7742913
  

30th,January 2002. 



Dear sir,
REQUEST FOR URGENT BUSINESS RELATIONSHIP.

First, I must solicit your confidence in this transaction. This is by virtue of 
its nature as being 
utterly confidential and top 
secret. You have been recommended by an associate who assured me in 
confidence of 
your ability and reliability to prosecute 
a transaction of great magnitude involving a pending business transaction 
requiring 
maximum confidence.

We are top officials of the Federal Government Contract Review Panel 
who are interested 
in importation of goods into our 
country with funds which are presently trapped in Nigeria. In order to 
commence this 
business we solicit your assistance to 
enable us RECIEVE the said trapped funds ABROAD.

The source of this fund is as follows : During the  regime of our late head 
of state, Gen. 
Sani Abacha, the government 
officials set up companies and awarded themselves contracts which were 
grossly over-
invoiced in various Ministries. The 
NEW CIVILIAN  Government set up a Contract Review Panel (C.R.P) and 
we have 
identified a lot of inflated contract funds 
which are presently floating in the Central Bank of Nigeria (C.B.N). 
However, due to our 
position as civil servants and 
members of this panel, we cannot acquire this money in our names. I have 
therefore, been 
delegated as a matter of trust by 
my colleagues of the panel to look for an Overseas partner INTO whose 
ACCOUNT the 
sum of US$31,000,000.00 (Thirty one 
Million United States Dollars) WILL BE PAID BY TELEGRAPHIC 
TRANSFER. Hence we 
are writing you this letter.

We have agreed to share the money thus:
1.  70% for us (the officials)
2.  20% for the FOREIGN PARTNER (you)
3.  10% to be used in settling taxation and all local and foreign 
expenses.

It is from this 70% that we wish to commence the importation business. 
Please note that this 
transaction is 100% safe and 
we hope THAT THE FUNDS CAN ARRIVE YOUR ACCOUNT in latest 
ten (10) banking 
days from the date of reciept of the 
following information  by TEL/FAX: 234-1-7742913: A SUITABLE NAME 
AND BANK 
ACCOUNT INTO WHICH THE FUNDS 
CAN BE PAID.

The above information will enable us write letters of claim and job 
description respectively. 
This way we will use your  
company's name to apply for payments and re-award the contract in your 
company name.

We are looking forward to doing business with you and solicit your 
confidentiality in this 
transaction.

Please acknowledge receipt of this letter using either Tel/Fax number  
234 1 7742913, I will 
bring you into the complete picture of this pending project when I have 
heard from you.

Yours Faithfully,
Engr.Martin Douglas.

-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: SELECT DISTINCT BINARY crashes mysql on null values

[Sinisa Milivojevic]

[EMAIL PROTECTED] writes:
 Description:
 
Executing a SELECT DISTINCT statement in conjunction
with the BINARY cast operator will crash MySQL server
when the column being cast contains one or more null
values.
 
 
 
 How-To-Repeat:
 
 Executing the following code from a mysql prompt will
 cause the MySQL server to crash and restart.
 
 create temporary table wassup (
rowid  int not null AUTO_INCREMENT PRIMARY KEY,
col1   varchar(10) null
 )
 ;
 
 insert into wassup
 (col1)
 values
 ('aaa'),
 ('AAA'),
 (NULL)
 ;
 
 select distinct binary col1 from wassup
 ;

Hi!

I tested your case and it worked just fine for me.

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   ___/   www.mysql.com


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Error 1006: Cant create database (errno:13)

[Victoria Reznichenko]

Gwen,

Wednesday, January 30, 2002, 7:57:55 AM, you wrote:

GT Hi All,

GT Forgive me if this question has been asked before. I'm new to the list 
GT and MySQL!

GT I'm getting the ERROR 1006: Can't create database 'tanner'. (errno: 13)
GT when signed on as root and as user.

GT I've also tried this command but my terminal had no idea what i was 
GT talking about.
GT  [localhost:~]UMASK=384 #=600 in octal(or something like that)

GT I was able to create tables a few days ago, now I'm not able to.  Today 
GT I did update user privileges.  Could that have some effect.

$ perror 13
Error code  13:  Permission denied

What are the file/directory permissions on mysql datadir directory? 
Does the user have permission to read/write/execute on those 
directories/files?

GT TIA,
GT Gwen





-- 
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Nested Queries

[Victoria Reznichenko]

Amit,

Wednesday, January 30, 2002, 7:45:13 AM, you wrote:

ADL Hi!!

ADL  I am trying to execute the following query. But it is giving 
ADL an error at select max(columnname). 

ADL select columname from tablename where columname1 = 
ADL select max(columnname) from tablename 

MySQL doesn't support subselects, look at: 
http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html
You can do it by another way, see at: 
http://www.mysql.com/doc/e/x/example-Maximum-row.html

ADL Thanks 
ADL Amit Lonkar 




-- 
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

How to get connected with mysql using perl scripts

[Victoria Reznichenko]

Charitha,

Wednesday, January 30, 2002, 10:21:11 AM, you wrote:

C Hi all,

C Please guide me to get the connection with mysql through perl scripts and
C through the scripts i have to insert some lot of data in the existing
C tables.

You can refer to: http://www.mysql.com/downloads/api-dbi.html

C Regards,
C Charitha.




-- 
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Is Triggers Possible in MySQL

[Victoria Reznichenko]

sreedhar,

Wednesday, January 30, 2002, 6:02:35 AM, you wrote:

s Hi All

s Is Triggers Possible in MySQL. If Yes, It is like in other RDBMS.

MySQL doesn't support triggers, look at: 
http://www.mysql.com/doc/A/N/ANSI_diff_Triggers.html

s regards,
s SREEDHAR




-- 
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Urgent Business Assistance.

[Duncan Hill]

On Wed, 30 Jan 2002, Engr.Martin Douglas. wrote:

 Urgent Business Asistance.
 
 Engr.Martin Douglas.

Ok.. I'm about to slamdunk a few phrases into my procmail filters.

However, is there any way mere mortals on this list can get the full 
headers?

(sql,mysql,database)


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

how to give a `root` mysql DB to each user ...

[Victoria Reznichenko]

Frederic,

Wednesday, January 30, 2002, 4:42:50 AM, you wrote:

FT I`ll make myself more clear here !

FT I work for a small ISP, we give a MySQL DB access to each of our corpo
FT users, if they request it. We just build new more performant machines, and
FT instead of giving them only a Database, in which they can create as many
FT tables as they want, we want to give them some sort `root` DB access, in
FT which they can create as many DB as they want, and so forth.

FT In a more graphical type of way to explain things, here is the structure
FT of the mysql data we have ...

FT in /var/lib/mysql ;

FT [root@kalx mysql]# l
FT total 32
FT drwxr-xr-x7 mysqlmysql4096 Jan 29 16:59 .
FT drwxr-xr-x   13 root root 4096 Jan 17 09:13 ..
FT drwx--2 mysqlmysql4096 Jan 29 16:43 mysql
FT drwx--2 mysqlmysql4096 Jan 29 12:55 test
FT drwx--2 mysqlmysql4096 Jan 29 16:59 user1
FT drwx--2 mysqlmysql4096 Jan 29 16:59 user2
FT drwx--2 mysqlmysql4096 Jan 29 16:59 user3

FT Now, each 'user*' is a DB, which is named after him, that can be accessed
FT only by this particular user. In a sense, they are 'locked' in their own
FT DB, and can create as many tables as they what, but they have to
FT contact us to create yet another DB, for which we have to create another
FT username + password ... We wish to grant them the priviledge of creating
FT as much DB as they want.

You can create user by using GRANT, something like this:
GRANT ALL ON *.* TO ''@localhost WITH GRANT OPTION;
or
GRANT ALL ON *.* TO ''@'%' WITH GRANT OPTION;

Get some more info at: http://www.mysql.com/doc/G/R/GRANT.html

FT There, I think I made myself clear enough =)
FT Thanks for any help...





-- 
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Urgent Business Assistance.

[Engr.Martin Douglas.]

Urgent Business Asistance.

Engr.Martin Douglas.
No. 16 Kingsway road,
Ikoyi lagos
Nigeria.

Tel/Fax:: 234-1-7742913
  

30th,January 2002. 



Dear sir,
REQUEST FOR URGENT BUSINESS RELATIONSHIP.

First, I must solicit your confidence in this transaction. This is by virtue of 
its nature as being 
utterly confidential and top 
secret. You have been recommended by an associate who assured me in 
confidence of 
your ability and reliability to prosecute 
a transaction of great magnitude involving a pending business transaction 
requiring 
maximum confidence.

We are top officials of the Federal Government Contract Review Panel 
who are interested 
in importation of goods into our 
country with funds which are presently trapped in Nigeria. In order to 
commence this 
business we solicit your assistance to 
enable us RECIEVE the said trapped funds ABROAD.

The source of this fund is as follows : During the  regime of our late head 
of state, Gen. 
Sani Abacha, the government 
officials set up companies and awarded themselves contracts which were 
grossly over-
invoiced in various Ministries. The 
NEW CIVILIAN  Government set up a Contract Review Panel (C.R.P) and 
we have 
identified a lot of inflated contract funds 
which are presently floating in the Central Bank of Nigeria (C.B.N). 
However, due to our 
position as civil servants and 
members of this panel, we cannot acquire this money in our names. I have 
therefore, been 
delegated as a matter of trust by 
my colleagues of the panel to look for an Overseas partner INTO whose 
ACCOUNT the 
sum of US$31,000,000.00 (Thirty one 
Million United States Dollars) WILL BE PAID BY TELEGRAPHIC 
TRANSFER. Hence we 
are writing you this letter.

We have agreed to share the money thus:
1.  70% for us (the officials)
2.  20% for the FOREIGN PARTNER (you)
3.  10% to be used in settling taxation and all local and foreign 
expenses.

It is from this 70% that we wish to commence the importation business. 
Please note that this 
transaction is 100% safe and 
we hope THAT THE FUNDS CAN ARRIVE YOUR ACCOUNT in latest 
ten (10) banking 
days from the date of reciept of the 
following information  by TEL/FAX: 234-1-7742913: A SUITABLE NAME 
AND BANK 
ACCOUNT INTO WHICH THE FUNDS 
CAN BE PAID.

The above information will enable us write letters of claim and job 
description respectively. 
This way we will use your  
company's name to apply for payments and re-award the contract in your 
company name.

We are looking forward to doing business with you and solicit your 
confidentiality in this 
transaction.

Please acknowledge receipt of this letter using either Tel/Fax number  
234 1 7742913, I will 
bring you into the complete picture of this pending project when I have 
heard from you.

Yours Faithfully,
Engr.Martin Douglas.

-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

mySql ODBC or API which one is FASTER

[Brandini Informatica Consultoria]

Which one is faster in mySql api ou odbc, why is it faster and how much
?


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL 4.0.1 crashes when updating a field with fulltext index

[Sinisa Milivojevic]

Mike Wexler writes:
 Description:
   mysql crashes with the following stack trace:
   0x807db7f handle_segfault__Fi + 383
   0x823d60a pthread_sighandler + 154
   0x8204407 _mi_compare_text + 71
   0x821bb96 _mi_ft_cmp + 158
   0x820bb01 mi_update + 721
   0x80d07ef update_row__9ha_myisamPCcPc + 67
   0x80b0439
   
mysql_update__FP3THDP13st_table_listRt4List1Z4ItemT2P4ItemP8st_orderUl15enum_duplicates13thr_lock_type
   + 2473
   0x8086da7 mysql_execute_command__Fv + 5723
   0x808a222 mysql_parse__FP3THDPcUi + 270
   0x8084e17 dispatch_command__F19enum_server_commandP3THDPcUi +
   1319
   0x808a654 do_command__FP3THD + 88
   0x8084256 handle_one_connection__FPv + 546
 
 When executing:
 
 UPDATE test.user SET realname='bar' WHERE userid='312362'
Hi!

I have tested your case and it worked just fine in 4.0.2.

This was a bug that was reported few weeks ago and fixed meanwhile.


-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   ___/   www.mysql.com


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

FW: Urgent Business Assistance.

[Anton]

Dear Sir

Unfortunatly too many people have already contacted me about this same
mater, maybe you could rather say that you are a insurance broker that
have to get rid of some policy money after this weeks miltary base
explosion in your country, and that you urgently need to get out of the
country with the money before the angry survivors get hold of you and
their money... That might work  Happy to help ...



-Original Message-
From: Engr.Martin Douglas. [mailto:[EMAIL PROTECTED]]
Sent: 30 January 2002 01:31
To: [EMAIL PROTECTED]
Subject: Urgent Business Assistance.


Urgent Business Asistance.

Engr.Martin Douglas.
No. 16 Kingsway road,
Ikoyi lagos
Nigeria.

Tel/Fax:: 234-1-7742913


30th,January 2002.



Dear sir,
REQUEST FOR URGENT BUSINESS RELATIONSHIP.

First, I must solicit your confidence in this transaction. This is by
virtue of
its nature as being
utterly confidential and top
secret. You have been recommended by an associate who assured me in
confidence of
your ability and reliability to prosecute
a transaction of great magnitude involving a pending business
transaction
requiring
maximum confidence.

We are top officials of the Federal Government Contract Review Panel
who are interested
in importation of goods into our
country with funds which are presently trapped in Nigeria. In order to
commence this
business we solicit your assistance to
enable us RECIEVE the said trapped funds ABROAD.

The source of this fund is as follows : During the  regime of our late
head
of state, Gen.
Sani Abacha, the government
officials set up companies and awarded themselves contracts which were
grossly over-
invoiced in various Ministries. The
NEW CIVILIAN  Government set up a Contract Review Panel (C.R.P) and
we have
identified a lot of inflated contract funds
which are presently floating in the Central Bank of Nigeria (C.B.N).
However, due to our
position as civil servants and
members of this panel, we cannot acquire this money in our names. I have

therefore, been
delegated as a matter of trust by
my colleagues of the panel to look for an Overseas partner INTO whose
ACCOUNT the
sum of US$31,000,000.00 (Thirty one
Million United States Dollars) WILL BE PAID BY TELEGRAPHIC
TRANSFER. Hence we
are writing you this letter.

We have agreed to share the money thus:
1.  70% for us (the officials)
2.  20% for the FOREIGN PARTNER (you)
3.  10% to be used in settling taxation and all local and foreign
expenses.

It is from this 70% that we wish to commence the importation business.
Please note that this
transaction is 100% safe and
we hope THAT THE FUNDS CAN ARRIVE YOUR ACCOUNT in latest
ten (10) banking
days from the date of reciept of the
following information  by TEL/FAX: 234-1-7742913: A SUITABLE NAME
AND BANK
ACCOUNT INTO WHICH THE FUNDS
CAN BE PAID.

The above information will enable us write letters of claim and job
description respectively.
This way we will use your
company's name to apply for payments and re-award the contract in your
company name.

We are looking forward to doing business with you and solicit your
confidentiality in this
transaction.

Please acknowledge receipt of this letter using either Tel/Fax number
234 1 7742913, I will
bring you into the complete picture of this pending project when I have
heard from you.

Yours Faithfully,
Engr.Martin Douglas.

-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Seeking Database/Scripts

[Will K.]

Greets Folks,

This is my first post here, so I'd just like to begin by saying hello.  It 
seems like a busy list, so I hope to learn a lot and make some good 
contributions myself. =)  But, right now, I have a question that I was 
wondering if someone could help me with...

I need a database and login script to password protect a members only area 
to a website.  I am wondering if there is any prefabbed stuff like that out 
there that I could either get for free or just buy?  Please know that I 
DON'T want to use .htaccess/.htpasswd because I would like to custom design 
the login pages.  I'd like to see if I could get a database that would also 
allow me to set cookies to keep users identified at login, timers as to 
when memberships expire, make easy updates as needed.

I am working with a Unix server that runs both PHP and Perl in conjunction 
with a MySQL database.

Please let me know if you have any scripts, tutorials or off-the-shelf 
software you could recommend.

Thanks!
=)

Will K.


P.S. Is the Paul DuBois on this list the same Paul DuBois who wrote MySQL 
and Perl for the Web?

Just wondering.




_
Send and receive Hotmail on your mobile device: http://mobile.msn.com


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

HEAP table size

[Mathias Johansson]

Hello,

I am using HEAP tables and would like to see how much memory
they use. I found this snipped of instruction in the MySQL-documentation:

--
The memory needed for one row in a HEAP table is:

SUM_OVER_ALL_KEYS(max_length_of_key + sizeof(char*) * 2)
+ ALIGN(length_of_row+1, sizeof(char*))

sizeof(char*) is 4 on 32-bit machines and 8 on 64-bit
machines.
--

But frankly, I don't get it. Could someone please explain this
to me? Lets say I have a heap-table that looks like this:

CREATE TABLE get_mem(
   idINT NOT NULL,
   name  CHAR(15) NOT NULL,
   nrMEDIUMINT NOT NULL,

   PRIMARY KEY(id)
) TYPE = HEAP;

How would I calculate the memory used for 1 row?

Thank you, Mathias



___
Spara filer på nätet. Lagra upp till 500 Mb på Passagen
http://webbdrive.passagen.se




-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: minimal SQL

[DL Neil]

Ah Håkan,

=A man(?) after my own heart! When I was at school (and bored out of my skull) I was 
always trying to figure out
where the 'Readers Digest Condensed Edition' of our text books was...

I am new to databases and SQL and find the language rich and interesting.
It seems to me, however, that there are quite a few redundant elements and
that the language is the result of quite a few compromises. There are not
less than 233 keywords in MySQL.
Is there any preferred way to write SQL-statements?
Is there any purist or minimalist view?

=I'm not sure if there is such a view, per-se, but greater minds might know...

=Typically text books will simplify a language and only cover a sub-set. Typically 
they will begin with the most
straight-forward/basic/easily understood commands, eg SELECT, INSERT, UPDATE, and 
leave the more 'dangerous'
ones until later, eg DELETE.

=BTW I've just laid out about half of SQL's commands - are you including all the 
clause keywords in that 233
count? The utter simplicity of the half-dozen DML (data manipulation language) 
commands are one of the most
attractive/mathematically-elegant features of the language.

=Next question: which book. Check out MySQL by Paul DuBois - you can even catch him, 
right here on the list!
Also the online manual features a tutorial section.

=Regards,
=dn



-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Fwd: failure notice

[Megan Melgaard]

Date: 29 Jan 2002 22:01:18 -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: failure notice



Hi. This is the qmail-send program at web.mysql.com.
I'm afraid I wasn't able to deliver your message to the following addresses.
This is a permanent error; I've given up. Sorry it didn't work out.

[EMAIL PROTECTED]:
ezmlm-reject: fatal: Sorry, I don't accept message with empty Subject (#5.7.0)

--- Enclosed is a copy of the message.

Return-Path: [EMAIL PROTECTED]
Received: (qmail 6394 invoked from network); 29 Jan 2002 22:01:17 -
Received: from edu15.coe.ufl.edu (HELO coe.ufl.edu) (128.227.102.15)
   by www.mysql.com with SMTP; 29 Jan 2002 22:01:17 -
Received: from [128.227.110.31] (128.227.110.31) by coe.ufl.edu with ESMTP
  (Eudora Internet Mail Server 3.1) for [EMAIL PROTECTED];
  Tue, 29 Jan 2002 17:08:30 -0500
Mime-Version: 1.0
Message-Id: a05100301b87ccca29a3d@[128.227.110.31]
Date: Tue, 29 Jan 2002 17:04:35 -0500
To: [EMAIL PROTECTED]
From: Megan Melgaard [EMAIL PROTECTED]
Content-Type: text/plain; charset=us-ascii ; format=flowed

To Whom It May Concern:

We are currently working on a MySQL database on a local Macintosh 
Computer.  We have OSX running.  Where do we store a text file to 
load data into our MySQL database?

Thank you.
--

--

Megan Melgaard
Graduate Assistant
College of Education, Office of the Dean
140 Norman Hall
P.O. Box 117040
Gainesville, FL 32611-7040
Tel: (352) 392-0728 ext. 285
Fax: (352) 392-6930
E-mail: [EMAIL PROTECTED]


-- 

--

Megan Melgaard
Graduate Assistant
College of Education, Office of the Dean
140 Norman Hall
P.O. Box 117040
Gainesville, FL 32611-7040
Tel: (352) 392-0728 ext. 285
Fax: (352) 392-6930
E-mail: [EMAIL PROTECTED]

-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Order By Query - Simple Help

[DL Neil]

Ok Jon,

 I am setting up a small bidding system.  I have a table with one column for
 BID and the other for MAX_BID with each row having a unique id number.
 Anyone have a simple query example where I can select ID, BID, MAX_BID and
 sort in descending order the BID and MAX_BID as if it were one column?

 Example_tbl
 id bid max_bid
 1 .2 .4
 2 .1 .2
 3 .4 .0
 4 .4 .7
 5 .7 .7

 Selecting the id and creating X_BID in the query result which is the
 combined bid columns, ordering by the BID and MAX_BID

 Result_Set
 ID X_BID
 5 .7
 4 .7
 3 .4
 1 .4
 2 .2

 Make any sense ?  Any thoughts on the AS and ORDER BY for this ?


=Yes it makes sense, except that you haven't defined the term combined for the bid 
columns. May I take it to
mean 'max_bid if it exists, or bid otherwise'?

=1 Code the SQL as if you were wanting to list Result_Set using only max_bid, and 
label (AS) the max_bid column
CombinedBid.

=2 Now get the resultset into the desired sequence using CombinedBid.

=3 Finally deal with the selection of either max_bid or bid in the CombinedBid column 
- if max_bid  0, use
max_bid, else use bid.
- check out the manual for IF()


=Let us know how you get on,
=dn



-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Seeking Database/Scripts

[mysql]

You could try php.resourceindex.com or freshmeat.net

-Original Message-
From: Will K. [mailto:[EMAIL PROTECTED]]
Sent: 30 January 2002 13:30
To: [EMAIL PROTECTED]
Subject: Seeking Database/Scripts


Greets Folks,

This is my first post here, so I'd just like to begin by saying hello.  It
seems like a busy list, so I hope to learn a lot and make some good
contributions myself. =)  But, right now, I have a question that I was
wondering if someone could help me with...

I need a database and login script to password protect a members only area
to a website.  I am wondering if there is any prefabbed stuff like that out
there that I could either get for free or just buy?  Please know that I
DON'T want to use .htaccess/.htpasswd because I would like to custom design
the login pages.  I'd like to see if I could get a database that would also
allow me to set cookies to keep users identified at login, timers as to
when memberships expire, make easy updates as needed.

I am working with a Unix server that runs both PHP and Perl in conjunction
with a MySQL database.

Please let me know if you have any scripts, tutorials or off-the-shelf
software you could recommend.

Thanks!
=)

Will K.


P.S. Is the Paul DuBois on this list the same Paul DuBois who wrote MySQL
and Perl for the Web?

Just wondering.




_
Send and receive Hotmail on your mobile device: http://mobile.msn.com


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Select with while loops

[DL Neil]

Rick,
Welcome to the list - we try not to byte, er, bite...

I am trying to do a select that will display events by category, but
will NOT display a category name if it is empty (has no events).

2 tables: categories and events

events contains a field called category_id that corresponds to the id of
a category in categories.

=a 'clean' structure, and you understand how to join the two tables - and your basic 
query appears below.

I am doing a 'while' loop for the events inside a 'while' loop for the
categories. It displays the category, then all events for that category.

=ouch! This is thinking in 'procedural logic', eg C, PHP, programming languages; not 
'relational logic/algebra'
suited to a SQL RDBMS - but we know what you mean...

=you will need to expand the query (below) to display information from the events 
table - currently the last
clause of your spec (above) is not implemented (below).

I am trying to find a simple way to NOT display the category if there
are no events in that category.

=check out the manual's discussion of IS [NOT] NULL, alternatively read up about 
different types of 'joins'.
However I wouldn't get into that complication until you deal with the central issue 
below (get the db to respond
with a superset of your data, then work on refining that result down to the level of 
precision/exclusion you
require!)

This seems logical, but does not produce any output:

SELECT category from categories WHERE categories.id =
events.category_id

=On the face of it, you should get some answers back, except that you need to name 
both of the tables involved
in the FROM clause.

=Are you using native MySQL at the command line, or a management tool? (or are you 
being more complicated, and
calling MySQL from a programming language) Keep things simple - use native SQL first 
(no interfacing issues),
then cut-and-paste into a more complicated 'vehicle', if that's what you want to do.

=If a problem persists at this level, could you come back to us the two table 
definitions and maybe some sample
data?

I can envision ways of getting this result that are more complicated
that they should be.  Is there a fairly simple way ?

BTW, I just joined this list and this is my first post.  Let me know if
I am being unclear.

=where there's a will, there's a way!
=dn



-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Manual references to safe_mysqld

[Ken Menzel]

Hi Jeremey!

 I think so.  I just did that recently in my book.  Imagine how many
 times I got it backwards and ended up second-guessing myself. :-(

Yes I have that confusion all the time, but it is good to have all
mysql tools begin with my or mysql.  Also because the installation of
MySQL does not remove or alter safe_mysqld, on ends up with two
scripts startin mysql.  This may not be a problem today however if in
the future the mysqld_safe script is altered for (saftey/features/some
important reason)  people may end up using the wrong startup script.
I know my servers use the wrong script!

My suggestiion would be to check if safe_mysqld exists during the 4.0
install and if it does remove it, then create a link to mysqld_safe
named safe_mysqld.  This maintains compatibility for anyone who has
existing scripts and uses only one!  Then in 4.1 perhaps deprecate the
safe_mysqld completely,  but  I don't think it's a big problem to
maintain the link if it exists.

Thoughts anyone?


 I'm not sure how they're generated (possibly from the manual), but
the
 INSTALL-SOURCE and INSTALL-BINARY files in 4.x also have references
to
 safe_mysqld rather than mysqld_safe.

I have noticed someone is looking because I see changes have been made
to the FreeBSD notes section.  I don't know how I could have missed
this as I always look at commits posted to the internals list!

 So,  maybe I should use the comments area of document on the web
site,  hopefully someone looks at that and will include my other
suggestions (Specifcally for BSDi and FreeBSD).  Seems much easier
just to make my comments on the mysql/docs web page!

One other thing,   I noticed that Multi-table update is mentioned in
the 4.0.2 release notes,  but the syntax is not yet in the manual and
I didn't see the commit!  Did I miss the commit?  I want to pull this
ASAP and test it.

Thanks everyone,

Ken

P.S. to Monty have been trying to recreate the  'row 0' error with
mysqldump unsuccesfully.  I am not sure what has changed.
Current stats:
| Questions| 345687 |
| Qcache_queries_in_cache  | 5007   |
| Qcache_inserts   | 26136  |
| Qcache_hits  | 205394 |
| Qcache_not_cached| 3670   |
| Qcache_free_memory   | 54115092   |
| Qcache_free_blocks   | 1038   |
| Qcache_total_blocks  | 11830  |

Maybe related to the current great cache hit ratio I am experiencing
59%!



 Jeremy
 --
 Jeremy D. Zawodny, [EMAIL PROTECTED]
 Technical Yahoo - Yahoo Finance
 Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936

 MySQL 3.23.41-max: up 26 days, processed 588,003,868 queries
(252/sec. avg)



-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

My OLEDB Problem/Bug

[luismiguelfreire]

With  VB6 
When I make an SELECT * FROM table when the tables as one of four 
type TEXT or BLOB
Give always this error Table does not exist
What is the problem?
If I use other column type don't give the error.

Create table example:
CREATE TABLE Notas ( ID_Cliente int NOT NULL , Obs text NULL) ;


Thanks

Luis Miguel Freire




-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Size Limitations

[Hashim Ismail]

Is there a database size limitation with MySQl in the Windows NT and Windows
2000 enviroment?  Like some databases have size limitation of 2GB.


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: how to give a `root` mysql DB to each user ...

[Frederic Trudeau]

Thanks Victoria, but will not this be very very insecure ? I mean, by
granting access to mysql DB, user could drop it, or grab a passwd from
another user in there. Am I missing something ?


Frederic Trudeau


[A]dvanced [S]upport [A]gent
Colocation/Customer Support Agent
CAM Internet - http://www.cam.org

My God ! It's full of stars

On Wed, 30 Jan 2002, Victoria Reznichenko wrote:

 Frederic,

 Wednesday, January 30, 2002, 4:42:50 AM, you wrote:

 FT I`ll make myself more clear here !

 FT I work for a small ISP, we give a MySQL DB access to each of our corpo
 FT users, if they request it. We just build new more performant machines, and
 FT instead of giving them only a Database, in which they can create as many
 FT tables as they want, we want to give them some sort `root` DB access, in
 FT which they can create as many DB as they want, and so forth.

 FT In a more graphical type of way to explain things, here is the structure
 FT of the mysql data we have ...

 FT in /var/lib/mysql ;

 FT [root@kalx mysql]# l
 FT total 32
 FT drwxr-xr-x7 mysqlmysql4096 Jan 29 16:59 .
 FT drwxr-xr-x   13 root root 4096 Jan 17 09:13 ..
 FT drwx--2 mysqlmysql4096 Jan 29 16:43 mysql
 FT drwx--2 mysqlmysql4096 Jan 29 12:55 test
 FT drwx--2 mysqlmysql4096 Jan 29 16:59 user1
 FT drwx--2 mysqlmysql4096 Jan 29 16:59 user2
 FT drwx--2 mysqlmysql4096 Jan 29 16:59 user3

 FT Now, each 'user*' is a DB, which is named after him, that can be accessed
 FT only by this particular user. In a sense, they are 'locked' in their own
 FT DB, and can create as many tables as they what, but they have to
 FT contact us to create yet another DB, for which we have to create another
 FT username + password ... We wish to grant them the priviledge of creating
 FT as much DB as they want.

 You can create user by using GRANT, something like this:
 GRANT ALL ON *.* TO ''@localhost WITH GRANT OPTION;
 or
 GRANT ALL ON *.* TO ''@'%' WITH GRANT OPTION;

 Get some more info at: http://www.mysql.com/doc/G/R/GRANT.html

 FT There, I think I made myself clear enough =)
 FT Thanks for any help...





 --
 For technical support contracts, goto https://order.mysql.com/
 This email is sponsored by Ensita.net http://www.ensita.net/
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
  / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
 /_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
___/   www.mysql.com




 -
 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 [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

triggers, stored procedures, and views

[jds]

I am building a database system and have been, like many before me, quite
surprised that MySQL doesn't support triggers, sp's, and views. I can see
how one can get around not having views with advanced permissions, as stated
in the manual, although as I understand it this is no substitue for views-
it is simply a workaround.

I want to be very clear in explicating my understanding that MysQL is an
open source technology, and putting it next to MS sQL Server 7 is not a fair
comparison, as MS has invested many millions in that product over the years
developing features...as has Oracle. It's kind of like putting AbiWord next
to MS Word...apples to oranges...

But not having triggers DOES make implementation of a transactional layer
very difficult. I'm wondering if anyone that has encountered this problem
and found a suitable solution would be so kind as to share his/her
experience with myself and the rest of the list? Or do the developers have
any suggestions?

Perhaps a collection of Perl scripts sending records to a transactional
table as well as the main data tables??? but then I would have to code this
for all the different operations that take place when one of the data
editors touches the database.

Thanks in advance to anyone willing to approach this subject and share their
experiences.

Regards,

jd

-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 30, 2002 6:26 AM
To: [EMAIL PROTECTED]
Subject: Is Triggers Possible in MySQL


sreedhar,

Wednesday, January 30, 2002, 6:02:35 AM, you wrote:

s Hi All

s Is Triggers Possible in MySQL. If Yes, It is like in other RDBMS.

MySQL doesn't support triggers, look at:
http://www.mysql.com/doc/A/N/ANSI_diff_Triggers.html

s regards,
s SREEDHAR




--
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL compile error, mysql-3.23.47, Mac OS X 10.1.2

[John McCauley]

Cool. And the file ./mysql-3.23.47/sql/sql_udf.cc is present?

Did you try a make clean? It shouldn't have any effect on configure but...


-- 
John McCauley
CTGi
Oakton, VA
703-352-0590
http://www.ctgusa.com

 From: Ryan Walker [EMAIL PROTECTED]
 Date: Wed, 30 Jan 2002 00:21:44 -0800
 To: [EMAIL PROTECTED]
 Subject: Re: MySQL compile error, mysql-3.23.47, Mac OS X 10.1.2
 
 Yes.
 
 Dumb question. You did install the OS X developer tools, yes?
 
 I just compiled 3.23.47 from source this morning on 10.1.2 with not a
 problem at all.
 
 --
 John McCauley
 CTGi
 Oakton, VA
 703-352-0590
 http://www.ctgusa.com
 
 From: Ryan Walker [EMAIL PROTECTED]
 Date: Tue, 29 Jan 2002 18:40:12 -0800
 To: [EMAIL PROTECTED]
 Subject: MySQL compile error, mysql-3.23.47, Mac OS X 10.1.2
 
 I'm trying to compile MySQL on Mac OS X 10.1.2. Ideally, I'd like to
 compile it with:
 ./configure --with-mysqld-user=mysql \
 --enable-thread-safe-client \
 --with-pthread \
 --with-raid
 
 Unfortunately, I can't even get it to compile with just:
 ./configure
 
 Produces error:
 sql_show.cc
 c++ -DMYSQL_SERVER
 -DDEFAULT_MYSQL_HOME=\/usr/local\  -DDATADIR=\/usr/local/var\
 -DSHAREDIR=\/usr/local/share/mysql\
 -DHAVE_CONFIG_H -I./../include -I./../regex
 -I. -I../include -I.. -I.-O3 -DDBUG_OFF   -fno-implicit-templates
 -fno-exceptions -fno-rtti -traditional-cpp -DHAVE_DARWIN_THREADS
 -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ
 -c sql_udf.cc
 sql_udf.cc:57: dlfcn.h: No such file or directory
 make[3]: *** [sql_udf.o] Error 1
 make[2]: *** [all-recursive] Error 1
 make[1]: *** [all-recursive] Error 1
 make: *** [all-recursive-am] Error 2
 
 
 Any suggestions?
 
 Ryan
 
 -
 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 [EMAIL PROTECTED]
 To unsubscribe, e-mail
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 
 
 
 
 -
 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 [EMAIL PROTECTED]
 To unsubscribe, e-mail
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 
 


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL 4.0.1 crashes when updating a field with fulltext index

[Mike Wexler]

Thanks. When is 4.0.2 due? I reported it (in less detail) 2 weeks ago, but 
didn't here anything back. So I created a test case, etc.


Sinisa Milivojevic wrote:

 Mike Wexler writes:
 
Description:

  mysql crashes with the following stack trace:
  0x807db7f handle_segfault__Fi + 383
  0x823d60a pthread_sighandler + 154
  0x8204407 _mi_compare_text + 71
  0x821bb96 _mi_ft_cmp + 158
  0x820bb01 mi_update + 721
  0x80d07ef update_row__9ha_myisamPCcPc + 67
  0x80b0439
  
mysql_update__FP3THDP13st_table_listRt4List1Z4ItemT2P4ItemP8st_orderUl15enum_duplicates13thr_lock_type
  + 2473
  0x8086da7 mysql_execute_command__Fv + 5723
  0x808a222 mysql_parse__FP3THDPcUi + 270
  0x8084e17 dispatch_command__F19enum_server_commandP3THDPcUi +
  1319
  0x808a654 do_command__FP3THD + 88
  0x8084256 handle_one_connection__FPv + 546

When executing:

UPDATE test.user SET realname='bar' WHERE userid='312362'

 Hi!
 
 I have tested your case and it worked just fine in 4.0.2.
 
 This was a bug that was reported few weeks ago and fixed meanwhile.
 
 
 



-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Workaround: Shutdown on OS X

[Steve Fox]

For anyone having trouble with shutting down mysqld on OS X
(especially if it times out waiting on the PID file):

I had been having trouble getting mysql (3.23.26) to shutdown on OS X
(10.1.1).
I had been using sudo to start safe_mysqld with user mysql

Now I su as user mysql to run safe_mysqld
To stop I su mysql and run mysqladmin.

I start and stop it frequently since its running on a laptop and
I haven't had a shutdown problem since I started doing it this way.

Steve Fox
UT CMHC



-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: next insert id

[DL Neil]

I'm not going to address these comments to anyone - in an attempt to avoid 
inter-personal conflict...

Herewith some psychology and philosophy:

- some people can't be bothered to read the manual
- writing a (good/complete) manual is even harder than reading it
- fully appreciating each fine detail as you read it amidst a myriad of ifs, buts, and 
maybes, in some language
feature/function's technical description can be challenging
- some people find it easier to ask others than to read/work it out for themselves
- some people think others are paid to be on the list to answer questions

- some people seem to think they will 'break' the computer/MySQL if they 'experiment'
- some people think that if they don't know/can't read something, asking others is 
preferable to/quicker than
experimentation

- some people think they know the answer to list questions and dash off a response 
without checking the
manual/really understanding the question/really knowing the answer

- the person who has provided the most consistently correct information in this thread 
has been most criticised
- the people who provided incorrect/out-of-date information/advice have yet to be 
castigated
- would you put incorrect advice on a par with Microsoft marketing blurb? (and you 
know how techies like to rage
against that!)

- technical manuals tend to lay out the facts this is how it works, and any 
rules/exceptions
- technical manuals do not tend to get into the design philosophy behind the code that 
implements the
commands/makes it all work
- many users find discussion of such philosophy 'incidental' and ask for the 'short 
version'

Why did the original post-er ask the question? Almost certainly because (s)he has read 
the manual where it says
that there is no native support for referential integrity in MySQL, and needs to set 
up a relationship between
two rows in different tables using a column that has its value set by AUTO_INCREMENT.

I first learned SQL as pure theory - before the standard was implemented. The earliest 
versions/implementations,
eg early DB2 and ORACLE, did not include native referential integrity, it was 
something we were taught to code
for ourselves. I'm fairly sure that the prevailing wisdom (now we're straying into the 
area of
transaction-processing) was that you worked out what the 'primary record' would be, 
and then coded up the
dependent record (including its foreign key) and stored it, and finally stored the 
'primary' record.

IIRC and if there are other (non-MySQL) implementations that follow that same 
approach, then this explains why
so many people ask the question what will be the NEXT key to be used by 
AUTO_INCREMENT.

Unfortunately respondents trying to tackle that question literally, disappear quickly 
into transactional
processing.

However MySQL offers a range of functions to 'display' AUTO_INCREMENT values, and 
report back on recent
activity. More so when you include interfacing languages' functions, eg PHP or Perl; 
and many of these occur
automatically as a result/by-product of an earlier call to MySQL (rather than 
requiring a
second/separate/additional call to be made across the interface).

NB this feature/characteristic nullifies some of the other comments made during this 
thread.

What should be understood is that MySQL's implementation of AUTO_INCREMENT requires a 
particular/different
philosophical view: that first the 'primary row' is to be stored, then the 
AUTO_INCREMENT data captured, and
finally the dependent row is stored (in the second table) - a reversal of the 
earlier-mentioned approach. As
soon as one understands how the whole job is to be done, the logic of the individual 
components becomes
'obvious'. (and the old dog has to remember his new tricks!)

Did I miss anything/get any part wrong?
Regards,
=dn




-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL compile error, mysql-3.23.47, Mac OS X 10.1.2

[Ryan Walker]

Yes, the file is present. Yes, I've made clean between each attempt.

At 10:11 AM -0500 1/30/02, John McCauley wrote:
Cool. And the file ./mysql-3.23.47/sql/sql_udf.cc is present?

Did you try a make clean? It shouldn't have any effect on configure but...


--
John McCauley
CTGi
Oakton, VA
703-352-0590
http://www.ctgusa.com

 From: Ryan Walker [EMAIL PROTECTED]
 Date: Wed, 30 Jan 2002 00:21:44 -0800
 To: [EMAIL PROTECTED]
 Subject: Re: MySQL compile error, mysql-3.23.47, Mac OS X 10.1.2

 Yes.

 Dumb question. You did install the OS X developer tools, yes?

 I just compiled 3.23.47 from source this morning on 10.1.2 with not a
 problem at all.

 --
 John McCauley
 CTGi
 Oakton, VA
 703-352-0590
 http://www.ctgusa.com

 From: Ryan Walker [EMAIL PROTECTED]
 Date: Tue, 29 Jan 2002 18:40:12 -0800
 To: [EMAIL PROTECTED]
 Subject: MySQL compile error, mysql-3.23.47, Mac OS X 10.1.2

 I'm trying to compile MySQL on Mac OS X 10.1.2. Ideally, I'd like to
 compile it with:
 ./configure --with-mysqld-user=mysql \
 --enable-thread-safe-client \
 --with-pthread \
 --with-raid

 Unfortunately, I can't even get it to compile with just:
 ./configure

 Produces error:
 sql_show.cc
 c++ -DMYSQL_SERVER
 -DDEFAULT_MYSQL_HOME=\/usr/local\  -DDATADIR=\/usr/local/var\
 -DSHAREDIR=\/usr/local/share/mysql\
 -DHAVE_CONFIG_H -I./../include -I./../regex
 -I. -I../include -I.. -I.-O3 -DDBUG_OFF   -fno-implicit-templates
 -fno-exceptions -fno-rtti -traditional-cpp -DHAVE_DARWIN_THREADS
 -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ
 -c sql_udf.cc
 sql_udf.cc:57: dlfcn.h: No such file or directory
 make[3]: *** [sql_udf.o] Error 1
 make[2]: *** [all-recursive] Error 1
 make[1]: *** [all-recursive] Error 1
 make: *** [all-recursive-am] Error 2


 Any suggestions?

 Ryan

 -
 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 [EMAIL PROTECTED]
 To unsubscribe, e-mail
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




 -
 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 [EMAIL PROTECTED]
 To unsubscribe, e-mail
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Table types

[Keith C. Ivey]

We're currently using MyISAM tables for everything.  Are there 
circumstances in which the InnoDB table type would be better even if 
we're not going to use commit/rollback, or are transactions the only 
advantage of InnoDB?  Would InnoDB's row-level locking improve speed 
over MyISAM for tables that have lots of updates and inserts, or does 
the transaction overhead cancel that out?

-- 
Keith C. Ivey [EMAIL PROTECTED]
Washington, DC

-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL 4.0.1 crashes when updating a field with fulltext index

[Sinisa Milivojevic]

Mike Wexler writes:
 Thanks. When is 4.0.2 due? I reported it (in less detail) 2 weeks ago, but 
 didn't here anything back. So I created a test case, etc.
 


Should be soon. We have few more features to finish and  test. 

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   ___/   www.mysql.com


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Workaround: Shutdown on OS X

[John McCauley]

No luck with that here. The daemon is unstoppable!

-- 
John McCauley
CTGi
Oakton, VA
703-352-0590
http://www.ctgusa.com

 From: Steve Fox [EMAIL PROTECTED]
 Date: Wed, 30 Jan 2002 09:33:44 -0600
 To: [EMAIL PROTECTED]
 Subject: Workaround: Shutdown on OS X
 
 For anyone having trouble with shutting down mysqld on OS X
 (especially if it times out waiting on the PID file):
 
 I had been having trouble getting mysql (3.23.26) to shutdown on OS X
 (10.1.1).
 I had been using sudo to start safe_mysqld with user mysql
 
 Now I su as user mysql to run safe_mysqld
 To stop I su mysql and run mysqladmin.
 
 I start and stop it frequently since its running on a laptop and
 I haven't had a shutdown problem since I started doing it this way.
 
 Steve Fox
 UT CMHC
 
 
 
 -
 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 [EMAIL PROTECTED]
 To unsubscribe, e-mail
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 
 


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

mysql trouble

[valentin]

Hello,
We are students in a french university and we have a trouble while
running mysql on our server.
After typing the command mysql, we have this message:

ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (111)

So we should know how resolve it.
Excuse me for my english and we wait your answer as soon as possible.




-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: mysql trouble

[Frederic Trudeau]

check your MySQL installation. I had the same problem on my machine, and
all I did is create a sym link to /var/lib/mysql/mysql.sock in /tmp.


Frederic Trudeau


[A]dvanced [S]upport [A]gent
Colocation/Customer Support Agent
CAM Internet - http://www.cam.org

My God ! It's full of stars

On Wed, 30 Jan 2002, valentin wrote:

 Hello,
 We are students in a french university and we have a trouble while
 running mysql on our server.
 After typing the command mysql, we have this message:

 ERROR 2002: Can't connect to local MySQL server through socket
 '/tmp/mysql.sock' (111)

 So we should know how resolve it.
 Excuse me for my english and we wait your answer as soon as possible.




 -
 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 [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Largest datatype

[Paul DuBois]

At 10:07 +0530 1/30/02, Charitha wrote:
I am not getting the requirement fulfilled from that manual page.

That page gets you to the places in the manual that describe the
storage size requirements for each of MySQL's data types.  That
tells you which of them are large enough to hold 10kb-sized or
larger values.

The manual is pretty explicit about the storage sizes, so it's not
clear what we could tell you that isn't already there.  (I'm assuming
you've read the parts of the the BLOB and TEXT column type families.)

When you say you want some other data type, do you mean you want to
use a data type that's not listed in the manual?  If not, what do you
mean?

I want some other data type as one of the field and with that i have to check
the replication in two servers.
that data type should have large size about 10kb.
Is there any data type like that.
Please let me know and its usage also.
Actually i want to check the performance of replication.

On Tue, 29 Jan 2002, Paul DuBois wrote:

  At 9:48 +0530 1/30/02, Charitha wrote:
  Hi all,
  
  I want to know data type which will have a size greater than or equal to
  10kb in mysql.  Just anybody response to this mail and let me know.

  You can check this for yourself in the MySQL manual:

  http://www.mysql.com/doc/S/t/Storage_requirements.html

  More than one type fits the bill, so you'll need to decide for yourself
  which you prefer.

  
   Thank u.


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: mysql trouble

[Andreas Schoelver]

30.01.02 16:57:00, valentin [EMAIL PROTECTED] wrote:

Hello,
We are students in a french university and we have a trouble while
running mysql on our server.
After typing the command mysql, we have this message:

ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (111)

did you build it on your own?
if so, did you use '--with-unix-socket-path=...' with configure ?
is the server really running?
is there any 'socket=...' line in /etc/my.cnf ?

Andreas



-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

AUTO_INCREMENT columns randomly restart counting from 1

[Andreas Schoelver]

Hi there

We have some table used as sequences.
They only have 2 columns (ID, PID), with the AUTO_INCREMENT flag set for one of them 
(ID).
By default the tables are empty!
The increment process is done by inserting a new record with a random 
value for the non-auto_increment column.
After that the new sequence value is fetched by selecting the random value.
In the next step the one and only new row will we deleted using a 
'delete from seq_xx WHERE PID = random_value'
statement, as described in the manual.

randomly the incrementation of any of the tables fails and the counter 
resets to 1, which breaks the whole application.
this appears long before any overflow might happen.

has anyone else ever noticed this?
any idea what might be wrong ?

the version of the server is 3.23.42 .

best regards
Andreas Schoelver



-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

MySQL and 3NF

[David S. Jackson]

Hi,

I came across a relationship between entities that I hadn't
counted on, and I'm trying to adjust my database tables to handle
this new relationship.  I need some help with visualizing and
implementing this relationship into the database design.

The database is for an inventory of contributions to be auctioned
off for a Montessori school.

Here are my tables:

mysql show tables;
+--+
| Tables in vmscatalog |
+--+
| Category |
| Contact  |
| Contributors |
| Delivery |
| Groups   |
| Item |
| Volunteer|
+--+

I've assumed that each contributor (business, individual,
whatever) would have only one volunteer from the Montessori
school that they would be dealing with.  so I've got the
following structure for the contributors table:

mysql describe Contributors;
++--+--+-+-++
| Field  | Type | Null | Key | Default | Extra
|
++--+--+-+-++
| Contributor_ID | tinyint(3)   |  | PRI | 0   |
auto_increment |
| Name   | varchar(100) |  | | |
|
| Street_Address | varchar(50)  | YES  | | NULL|
|
| City   | varchar(20)  | YES  | | NULL|
|
| State  | varchar(5)   | YES  | | NULL|
|
| Zip| mediumint(8) | YES  | | NULL|
|
| Contact_ID | tinyint(3)   | YES  | | NULL|
|
| Volunteer_ID   | tinyint(3)   | YES  | | NULL|
|
++--+--+-+-++
8 rows in set (0.01 sec)

Likewise, the Volunteer_ID ties in with a Volunteer table and a
unique row in the volunteer table.

Now I've got a situation where a large Museum actually has two
people from the school each talking to different departments in
the Museum, each donating a different set of gift certificates.
So I have to figure out some way to let the contributors' table
handle more than Contact_ID and more than one Volunteer_ID.

Don't I want each Contact_ID field for each record to be a single
discrete ID number?  How would you guys handle this?

TIA!

-- 
David S. Jackson[EMAIL PROTECTED]
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
It's hard to get ivory in Africa, but in Alabama
the Tuscaloosa.  -- Groucho Marx

-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: AW: MySQL 3.23.47 on MacOSX 10.1.2: Could someone help megetting started

[Paul DuBois]

At 9:57 +0100 1/30/02, Lutz, Helmuth wrote:
Paul,

Okay, then try adding the --user=mysql option to the command.

I killed the server (kill -9) and brought it back up with -Sg --user=mysql:

The result:
[localhost:/usr/local/mysql] root# /usr/local/mysql/bin/mysqld -Sg
--user=mysql

Okay, here I forgot something. You need a  on the end of the command
to start the server in the background.

To solve your problem below, open a new window and run mysql to connect
to the server *or* stop the server (control-Z) and resume it in the background
(Use bg), then run mysql to connect.

The UPDATE statement that you pasted in is being ignored.  You should issue
it from within the mysql program.

--- Here came some hints
Cannot initialize InnoDB as 'innidb_data_file_path' is not set.
If you do not want to use transactional InnoDB tables, add a line
skip-innodb
to the [mysqld] section of init parameters in your my.conf
or my.ini. If you want to use InnoDB tables, add for example,
innodb_data_file_path = /mysql/data/ibdata1:20M
But to get good performance 
---end hint and this line
/usr/local/mysql/bin/mysqld: ready for connections

This looks nice I think

but then I made this mistake:
I copy and pasted 2 lines to the terminal (instead of writing them)
and had the cursor in the 3rd line. I tried to escape without success.

--- My page looks like this:
/usr/local/mysql/bin/mysqld: ready for connections
UPDATE user SET Password=PASSWORD('new-password')
WHERE User='root' AND Host='localhost';

exit
exit;
quit;
stop;
mysqld test;
   -- here is the cursor

--- end of my page

1)How can I escape?
2) would it have been ok if I had used following line at this point?
UPDATE user SET Password=PASSWORD('myNewPassword') WHERE User='root' AND
Host='localhost';

Thanks, Helmuth

-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: how to give a `root` mysql DB to each user ...

[Victoria Reznichenko]

Frederic,

Wednesday, January 30, 2002, 4:56:11 PM, you wrote:


FT Thanks Victoria, but will not this be very very insecure ? FT I mean, by granting 
access to mysql DB, user could drop it, 
FT or grab a passwd from another user in there. Am I missing 
FT something ?

If you create user with privileges on all databases (*.*), you get access not only to 
user's databases but also to mysql db. It's impossible to create user with all 
privileges but exclude something you want.

You set privileges on global level and statement like the following works using table 
user mysql db:
GRANT ALL ON *.* TO ''@localhost


If you want to take off grants from user on mysql.*, it will work on database level 
with table db mysql db:
   REVOKE UPDATE ON mysql.* FROM ''@localhost



FT Frederic Trudeau


FT My God ! It's full of stars

FT On Wed, 30 Jan 2002, Victoria Reznichenko wrote:

 Frederic,

 Wednesday, January 30, 2002, 4:42:50 AM, you wrote:

 FT I`ll make myself more clear here !

 FT I work for a small ISP, we give a MySQL DB access to each of our corpo
 FT users, if they request it. We just build new more performant machines, and
 FT instead of giving them only a Database, in which they can create as many
 FT tables as they want, we want to give them some sort `root` DB access, in
 FT which they can create as many DB as they want, and so forth.

[skip]

 FT Now, each 'user*' is a DB, which is named after him, that can be accessed
 FT only by this particular user. In a sense, they are 'locked' in their own
 FT DB, and can create as many tables as they what, but they have to
 FT contact us to create yet another DB, for which we have to create another
 FT username + password ... We wish to grant them the priviledge of creating
 FT as much DB as they want.

You can create user by using GRANT, something like this:
GRANT ALL ON *.* TO ''@localhost WITH GRANT OPTION;
or
GRANT ALL ON *.* TO ''@'%' WITH GRANT OPTION;
Get some more info at: http://www.mysql.com/doc/G/R/GRANT.html





-- 
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: AUTO_INCREMENT columns randomly restart counting from 1

[Paul DuBois]

At 17:15 +0100 1/30/02, Andreas Schoelver wrote:
Hi there

We have some table used as sequences.
They only have 2 columns (ID, PID), with the AUTO_INCREMENT flag set 
for one of them (ID).

Is the ID column one of the integer types?

By default the tables are empty!
The increment process is done by inserting a new record with a random
value for the non-auto_increment column.
After that the new sequence value is fetched by selecting the random value.
In the next step the one and only new row will we deleted using a
'delete from seq_xx WHERE PID = random_value'
statement, as described in the manual.

randomly the incrementation of any of the tables fails and the counter
resets to 1, which breaks the whole application.
this appears long before any overflow might happen.

has anyone else ever noticed this?
any idea what might be wrong ?

What is the table type? (ISAM, MyISAM ... ?)


the version of the server is 3.23.42 .

best regards
Andreas Schoelver


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: [ale] MySQL and 3NF

[Tommie M. Jones]

From what I understand.  Move the volunteer_id from the contributor table.
put the contributor_id inside the volunteer table.

This way you can have a 1-to-many relationship between the two.

---
Get inside Atlanta's Tech Scene - http://www.atlantageek.com
'Business Intelligence' is not an Oxymoron - http://www.intelliforge.com


On Wed, 30 Jan 2002, David S. Jackson wrote:

 Hi,

 I came across a relationship between entities that I hadn't
 counted on, and I'm trying to adjust my database tables to handle
 this new relationship.  I need some help with visualizing and
 implementing this relationship into the database design.

 The database is for an inventory of contributions to be auctioned
 off for a Montessori school.

 Here are my tables:

 mysql show tables;
 +--+
 | Tables in vmscatalog |
 +--+
 | Category |
 | Contact  |
 | Contributors |
 | Delivery |
 | Groups   |
 | Item |
 | Volunteer|
 +--+

 I've assumed that each contributor (business, individual,
 whatever) would have only one volunteer from the Montessori
 school that they would be dealing with.  so I've got the
 following structure for the contributors table:

 mysql describe Contributors;
 ++--+--+-+-++
 | Field  | Type | Null | Key | Default | Extra
 |
 ++--+--+-+-++
 | Contributor_ID | tinyint(3)   |  | PRI | 0   |
 auto_increment |
 | Name   | varchar(100) |  | | |
 |
 | Street_Address | varchar(50)  | YES  | | NULL|
 |
 | City   | varchar(20)  | YES  | | NULL|
 |
 | State  | varchar(5)   | YES  | | NULL|
 |
 | Zip| mediumint(8) | YES  | | NULL|
 |
 | Contact_ID | tinyint(3)   | YES  | | NULL|
 |
 | Volunteer_ID   | tinyint(3)   | YES  | | NULL|
 |
 ++--+--+-+-++
 8 rows in set (0.01 sec)

 Likewise, the Volunteer_ID ties in with a Volunteer table and a
 unique row in the volunteer table.

 Now I've got a situation where a large Museum actually has two
 people from the school each talking to different departments in
 the Museum, each donating a different set of gift certificates.
 So I have to figure out some way to let the contributors' table
 handle more than Contact_ID and more than one Volunteer_ID.

 Don't I want each Contact_ID field for each record to be a single
 discrete ID number?  How would you guys handle this?

 TIA!

 --
 David S. Jackson[EMAIL PROTECTED]
 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
 It's hard to get ivory in Africa, but in Alabama
 the Tuscaloosa.  -- Groucho Marx

 ---
 This message has been sent through the ALE general discussion list.
 See http://www.ale.org/mailing-lists.shtml for more info. Problems should be
 sent to listmaster at ale dot org.




-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL and 3NF

[admin]

Hi.

I would type museum: department or likewise in name field
if its not so many it would work nicely.

But thats just me:)

/PM\

David S. Jackson wrote:
 
 Hi,
 
 I came across a relationship between entities that I hadn't
 counted on, and I'm trying to adjust my database tables to handle
 this new relationship.  I need some help with visualizing and
 implementing this relationship into the database design.
 
 The database is for an inventory of contributions to be auctioned
 off for a Montessori school.
 
 Here are my tables:
 
 mysql show tables;
 +--+
 | Tables in vmscatalog |
 +--+
 | Category |
 | Contact  |
 | Contributors |
 | Delivery |
 | Groups   |
 | Item |
 | Volunteer|
 +--+
 
 I've assumed that each contributor (business, individual,
 whatever) would have only one volunteer from the Montessori
 school that they would be dealing with.  so I've got the
 following structure for the contributors table:
 
 mysql describe Contributors;
 ++--+--+-+-++
 | Field  | Type | Null | Key | Default | Extra
 |
 ++--+--+-+-++
 | Contributor_ID | tinyint(3)   |  | PRI | 0   |
 auto_increment |
 | Name   | varchar(100) |  | | |
 |
 | Street_Address | varchar(50)  | YES  | | NULL|
 |
 | City   | varchar(20)  | YES  | | NULL|
 |
 | State  | varchar(5)   | YES  | | NULL|
 |
 | Zip| mediumint(8) | YES  | | NULL|
 |
 | Contact_ID | tinyint(3)   | YES  | | NULL|
 |
 | Volunteer_ID   | tinyint(3)   | YES  | | NULL|
 |
 ++--+--+-+-++
 8 rows in set (0.01 sec)
 
 Likewise, the Volunteer_ID ties in with a Volunteer table and a
 unique row in the volunteer table.
 
 Now I've got a situation where a large Museum actually has two
 people from the school each talking to different departments in
 the Museum, each donating a different set of gift certificates.
 So I have to figure out some way to let the contributors' table
 handle more than Contact_ID and more than one Volunteer_ID.
 
 Don't I want each Contact_ID field for each record to be a single
 discrete ID number?  How would you guys handle this?
 
 TIA!
 
 --
 David S. Jackson[EMAIL PROTECTED]
 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
 It's hard to get ivory in Africa, but in Alabama
 the Tuscaloosa.  -- Groucho Marx
 
 -
 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 [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Structure copy...

[Vasoczki Ferenc]

Hi, i want to copy a table structure.
I saw on the archive, there is a syntax like:
create [newtable] select * from [sourcetable] where 1=2;

This is not work on my MySQL server v.3.22
Is it a 3.23 feature, or am i do something wrong ?

If you know the solution please tell me that.
Thx

Vaso

-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: AUTO_INCREMENT columns randomly restart counting from 1

[Richard Bolen]

I think AUTO_INCREMENT is on a per-connection basis.  So if you're doing
this across different database connections, it will reset to 0.

Rich  


Hi there

We have some table used as sequences.
They only have 2 columns (ID, PID), with the AUTO_INCREMENT flag set for one
of them (ID).
By default the tables are empty!
The increment process is done by inserting a new record with a random 
value for the non-auto_increment column.
After that the new sequence value is fetched by selecting the random value.
In the next step the one and only new row will we deleted using a 
'delete from seq_xx WHERE PID = random_value'
statement, as described in the manual.

randomly the incrementation of any of the tables fails and the counter 
resets to 1, which breaks the whole application.
this appears long before any overflow might happen.

has anyone else ever noticed this?
any idea what might be wrong ?

the version of the server is 3.23.42 .

best regards
Andreas Schoelver



-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: next insert id (slightly OT)

[William R. Mussatto]

On Thu, 31 Jan 2002, DL Neil wrote:
...
 
 What should be understood is that MySQL's implementation of AUTO_INCREMENT requires 
a particular/different
 philosophical view: that first the 'primary row' is to be stored, then the 
AUTO_INCREMENT data captured, and
 finally the dependent row is stored (in the second table) - a reversal of the 
earlier-mentioned approach. As
 soon as one understands how the whole job is to be done, the logic of the individual 
components becomes
 'obvious'. (and the old dog has to remember his new tricks!)
...
I've run into one case where knowing the next ID would be useful was 
where file names, being stored in the record contained the ID (for 
performance reasons or maybe my bad design) since I was storing graphics 
separately (for web work it makes great sense since the name needs to go 
on the page not the data).  I had to do an insert, get the 
LAST-INSERTED-ID, and then update the record.  I suspect that this is 
really faster if there are multiple updated going on than locking the 
table.  Also, it enables me to use fixed length records. 

Didn't even think of locking the tables.  

BTW: an earlier poster mentioned DB2.  You have to have a separate Key 
table and use an Update with a Sub Select and lock that table to get the 
next key since DB2 still (as of the version I was using) have 
auto-increment fields.  

Don't know if its true, but a DBA I worked with insisted that MicroSoft's 
SQL's auto-increment was flawed so we had to do the same thing there, 
even though it did have auto-increment.  Perhaps a hold over from the 
doing it by hand days..

Sincerely,

William Mussatto, Senior Systems Engineer
CyberStrategies, Inc
ph. 909-920-9154 ext. 27


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Urgent Business Assistance.

[William R. Mussatto]

On Wed, 30 Jan 2002, Marjolein Katsma wrote:

 Date: Wed, 30 Jan 2002 12:33:29 +0100
 From: Marjolein Katsma [EMAIL PROTECTED]
 To: MySQL [EMAIL PROTECTED]
 Subject: RE: Urgent Business Assistance.
 
 
 At 03:52 2002-01-30, Todd Williamsen wrote:
 If its so urgent and private then why are you spamming a mail list?  I
 smell scam, or is that Spam?
 
 It's both.
 
 And please do not quote the *whole* spam - the loss of bandwidth (it goes to every 
subscriber!) from the actual spam is already bad enough.
 
 Replying to the spammer is useless, too - they do NOT subscribe. Spammers are lazy.
 
 Grrr: database,sql,query,table
 
Just my $0.02..
Look for the web site or email they push, not the originating we address. 
Do a traceroute to it and send to abuse@... their ISP and their ISP's ISP 
and complain.  They have to be real addresses because they want you to 
respond.  Works more effectively than unsubscibing.  Also, it a LOT of 
people do it, the ISP usually will notice.

Sincerely,

William Mussatto, Senior Systems Engineer
CyberStrategies, Inc
ph. 909-920-9154 ext. 27


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Size Limitations

[Christopher Thompson]

At 09:49 AM 1/30/2002 -0500, Hashim Ismail wrote:
Is there a database size limitation with MySQl in the Windows NT and Windows
2000 enviroment?  Like some databases have size limitation of 2GB.

Yes.  Read the manual.  In a Windows environment, table sizes are limited 
to 2 gigabytes if memory serves, it is all in the manual, though.  You can, 
of course, have more than one table in your database.



-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

select woes

[George M. Ellenburg]

Hello.

If anyone has a quick moment, I would appreciate some suggestions with
regards to the following select statement:

SELECT widget_src FROM widgets WHERE items.foo='abc123' and
item_details.item_type='I' and items.item_detail_id=foo.item_detail_id;

Upon execution, I'm getting ERROR 1109: Unknown table 'items' in where
clause.  However, widgets, items and item_details all exist, in
the same database.

In looking at the MySQL manual, section 6.4.1 (SELECT syntaxt), the
following is written: You can refer to a column as col_name,
tbl_name.col_name, or db_name.tbl_name.col_name. which I'm doing, and
all tables referenced are in the same database.  Here's the following
output from mysql status:

mysql status
--
mysql  Ver 11.15 Distrib 3.23.44, for -freebsd4.4 (i386)

Connection id:  295
Current database:   test_database
Current user:   root@localhost
Current pager:  stdout
Using outfile:  ''
Server version: 3.23.44
Protocol version:   10
Connection: Localhost via UNIX socket
Client characterset:latin1
Server characterset:latin1
UNIX socket:/tmp/mysql.sock
Uptime: 5 days 20 hours 55 min 10 sec

Threads: 1  Questions: 13038  Slow queries: 0  Opens: 200  Flush tables:

1  Open tables: 7 Queries per second avg: 0.026
--

mysql

If anyone has any suggestions or pointers to nudge me in the right
direction, I'd be most appreciative.

--George Ellenburg


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL 4.0.1 crashes when updating a field with fulltext index

[Mike Wexler]

Which features are planned, but not implemented for 4.0.2?

I assume they are featured either listed at 
http://www.mysql.com/doc/N/u/Nutshell_Future_features.html or are very small 
features, right?

When are the new, text .frm files going to be introduced?


Sinisa Milivojevic wrote:

 Mike Wexler writes:
 
Thanks. When is 4.0.2 due? I reported it (in less detail) 2 weeks ago, but 
didn't here anything back. So I created a test case, etc.


 
 
 Should be soon. We have few more features to finish and  test. 
 
 



-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Can't untar mysql on Solaris 8

[Eurico de Sousa]

Hi.

I've downloaded the .tar.gz files for MySQL 3.23.48, 3.23.47 and 3.23.46 for 
Sparc-Solaris 8 and all
of them complain of a checksum error on the tar-extract. Here's the output of tar xvf 
of the
gunzip'd-tar file:

x
mysql-3.23.46-sun-solaris2.8-sparc/sql-bench/Results/ATIS-Adabas-Linux_2.0.35_i686-cmp-adabas,mysql,
691 bytes, 2 tape blocks
tar: directory checksum error

All 3 versions give this error at the same spot. I've downloaded these versions off 
several mirror
sites using both HTTP and FTP through my browser and also using FTP without using the 
browser and
every one gives the same problem.

Can anyone please tell me what's going on? Is this a known bug? I'm using Sun's 
/usr/sbin/tar
program. The tar tvf lists out all the contents properly but the extract doesn't work. 
I've run the
tar xf as root and as a normal id - same problem.

I am running Solaris 8 on an Ultra-1 workstation.

Thanks,

Eurico


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: select woes

[John Cichy]

You must also define the tables you want to 'look' at in the 'FROM' clause

On Wednesday 30 January 2002 12:08, George M. Ellenburg wrote:
 Hello.

 If anyone has a quick moment, I would appreciate some suggestions with
 regards to the following select statement:

 SELECT widget_src FROM widgets WHERE items.foo='abc123' and
 item_details.item_type='I' and items.item_detail_id=foo.item_detail_id;

 Upon execution, I'm getting ERROR 1109: Unknown table 'items' in where
 clause.  However, widgets, items and item_details all exist, in
 the same database.

 In looking at the MySQL manual, section 6.4.1 (SELECT syntaxt), the
 following is written: You can refer to a column as col_name,
 tbl_name.col_name, or db_name.tbl_name.col_name. which I'm doing, and
 all tables referenced are in the same database.  Here's the following
 output from mysql status:

 mysql status
 --
 mysql  Ver 11.15 Distrib 3.23.44, for -freebsd4.4 (i386)

 Connection id:  295
 Current database:   test_database
 Current user:   root@localhost
 Current pager:  stdout
 Using outfile:  ''
 Server version: 3.23.44
 Protocol version:   10
 Connection: Localhost via UNIX socket
 Client characterset:latin1
 Server characterset:latin1
 UNIX socket:/tmp/mysql.sock
 Uptime: 5 days 20 hours 55 min 10 sec

 Threads: 1  Questions: 13038  Slow queries: 0  Opens: 200  Flush tables:

 1  Open tables: 7 Queries per second avg: 0.026
 --

 mysql

 If anyone has any suggestions or pointers to nudge me in the right
 direction, I'd be most appreciative.

 --George Ellenburg


 -
 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 [EMAIL PROTECTED]
 To unsubscribe, e-mail
 [EMAIL PROTECTED] Trouble
 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Size Limitations

[Steve Kramer]

The manual doesn't specify the Windows limit - only the Linux value of 2 gb.

-Original Message-
From: Christopher Thompson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 30, 2002 9:57 AM
To: Hashim Ismail; [EMAIL PROTECTED]
Subject: Re: Size Limitations


At 09:49 AM 1/30/2002 -0500, Hashim Ismail wrote:
Is there a database size limitation with MySQl in the Windows NT and
Windows
2000 enviroment?  Like some databases have size limitation of 2GB.

Yes.  Read the manual.  In a Windows environment, table sizes are limited
to 2 gigabytes if memory serves, it is all in the manual, though.  You can,
of course, have more than one table in your database.



-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: MySQL and 3NF

[Johnson, Gregert]

Create two association tables:

Contributor
++--+--+-+-++
| Field  | Type | Null | Key | Default | Extra
|
++--+--+-+-++
| Contributor_ID | tinyint(3)   |  | PRI | 0   | auto_increment |
| Name   | varchar(100) |  | | |
|
| Street_Address | varchar(50)  | YES  | | NULL|
|
| City   | varchar(20)  | YES  | | NULL|
|
| State  | varchar(5)   | YES  | | NULL|
|
| Zip| mediumint(8) | YES  | | NULL|
|
++--+--+-+-++

New tables:

Contributor_Contact
++--+--+-+-++
| Field  | Type | Null | Key | Default | Extra
|
++--+--+-+-++
| Contributor_ID | tinyint(3)   |  | PRI | 0   |
| Contact_ID | tinyint(3)   |  | PRI | 0   |
++--+--+-+-++

Contributor_Volunteer
++--+--+-+-++
| Field  | Type | Null | Key | Default | Extra
|
++--+--+-+-++
| Contributor_ID | tinyint(3)   |  | PRI | 0   |
| Volunteer_ID   | tinyint(3)   |  | PRI | 0   |
++--+--+-+-++

-- Greg Johnson

-Original Message-
From: David S. Jackson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 30, 2002 11:15 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: MySQL and 3NF


Hi,

I came across a relationship between entities that I hadn't
counted on, and I'm trying to adjust my database tables to handle
this new relationship.  I need some help with visualizing and
implementing this relationship into the database design.

The database is for an inventory of contributions to be auctioned
off for a Montessori school.

Here are my tables:

mysql show tables;
+--+
| Tables in vmscatalog |
+--+
| Category |
| Contact  |
| Contributors |
| Delivery |
| Groups   |
| Item |
| Volunteer|
+--+

I've assumed that each contributor (business, individual,
whatever) would have only one volunteer from the Montessori
school that they would be dealing with.  so I've got the
following structure for the contributors table:

mysql describe Contributors;
++--+--+-+-++
| Field  | Type | Null | Key | Default | Extra
|
++--+--+-+-++
| Contributor_ID | tinyint(3)   |  | PRI | 0   |
auto_increment |
| Name   | varchar(100) |  | | |
|
| Street_Address | varchar(50)  | YES  | | NULL|
|
| City   | varchar(20)  | YES  | | NULL|
|
| State  | varchar(5)   | YES  | | NULL|
|
| Zip| mediumint(8) | YES  | | NULL|
|
| Contact_ID | tinyint(3)   | YES  | | NULL|
|
| Volunteer_ID   | tinyint(3)   | YES  | | NULL|
|
++--+--+-+-++
8 rows in set (0.01 sec)

Likewise, the Volunteer_ID ties in with a Volunteer table and a
unique row in the volunteer table.

Now I've got a situation where a large Museum actually has two
people from the school each talking to different departments in
the Museum, each donating a different set of gift certificates.
So I have to figure out some way to let the contributors' table
handle more than Contact_ID and more than one Volunteer_ID.

Don't I want each Contact_ID field for each record to be a single
discrete ID number?  How would you guys handle this?

TIA!

-- 
David S. Jackson[EMAIL PROTECTED]
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
It's hard to get ivory in Africa, but in Alabama
the Tuscaloosa.  -- Groucho Marx

-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Can't untar mysql on Solaris 8

[Paul DuBois]

Yes, it's a bug.  In Solaris.  You must use GNU tar, not Solaris tar.

http://www.mysql.com/doc/S/o/Solaris.html


At 12:15 -0500 1/30/02, Eurico de Sousa wrote:
Hi.

I've downloaded the .tar.gz files for MySQL 3.23.48, 3.23.47 and 
3.23.46 for Sparc-Solaris 8 and all
of them complain of a checksum error on the tar-extract. Here's the 
output of tar xvf of the
gunzip'd-tar file:

x
mysql-3.23.46-sun-solaris2.8-sparc/sql-bench/Results/ATIS-Adabas-Linux_2.0.35_i686-cmp-adabas,mysql,
691 bytes, 2 tape blocks
tar: directory checksum error

All 3 versions give this error at the same spot. I've downloaded 
these versions off several mirror
sites using both HTTP and FTP through my browser and also using FTP 
without using the browser and
every one gives the same problem.

Can anyone please tell me what's going on? Is this a known bug? I'm 
using Sun's /usr/sbin/tar
program. The tar tvf lists out all the contents properly but the 
extract doesn't work. I've run the
tar xf as root and as a normal id - same problem.

I am running Solaris 8 on an Ultra-1 workstation.

Thanks,

Eurico


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: triggers, stored procedures, and views

[Land, Christopher]

Sounds like we just need a table to keep track of LAST_INSERT_ID per table.

C:heers

-Original Message-
From: jds [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 30, 2002 7:05 AM
To: [EMAIL PROTECTED]
Cc: David T. Anderson
Subject: triggers, stored procedures, and views


I am building a database system and have been, like many before me, quite
surprised that MySQL doesn't support triggers, sp's, and views. I can see
how one can get around not having views with advanced permissions, as stated
in the manual, although as I understand it this is no substitue for views-
it is simply a workaround.

I want to be very clear in explicating my understanding that MysQL is an
open source technology, and putting it next to MS sQL Server 7 is not a fair
comparison, as MS has invested many millions in that product over the years
developing features...as has Oracle. It's kind of like putting AbiWord next
to MS Word...apples to oranges...

But not having triggers DOES make implementation of a transactional layer
very difficult. I'm wondering if anyone that has encountered this problem
and found a suitable solution would be so kind as to share his/her
experience with myself and the rest of the list? Or do the developers have
any suggestions?

Perhaps a collection of Perl scripts sending records to a transactional
table as well as the main data tables??? but then I would have to code this
for all the different operations that take place when one of the data
editors touches the database.

Thanks in advance to anyone willing to approach this subject and share their
experiences.

Regards,

jd

-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 30, 2002 6:26 AM
To: [EMAIL PROTECTED]
Subject: Is Triggers Possible in MySQL


sreedhar,

Wednesday, January 30, 2002, 6:02:35 AM, you wrote:

s Hi All

s Is Triggers Possible in MySQL. If Yes, It is like in other RDBMS.

MySQL doesn't support triggers, look at:
http://www.mysql.com/doc/A/N/ANSI_diff_Triggers.html

s regards,
s SREEDHAR




--
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: select woes

[Gerald Clark]

But you are only selecting FROM 'widgets'.


I think you need to buy an introductory book on SQL.

I would also suggest 'MySQL' by Paul DuBois ( published by  New Riders ).


George M. Ellenburg wrote:

Hello.

If anyone has a quick moment, I would appreciate some suggestions with
regards to the following select statement:

SELECT widget_src FROM widgets WHERE items.foo='abc123' and
item_details.item_type='I' and items.item_detail_id=foo.item_detail_id;

Upon execution, I'm getting ERROR 1109: Unknown table 'items' in where
clause.  However, widgets, items and item_details all exist, in
the same database.




-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Can't untar mysql on Solaris 8

[Gerald Clark]

Use gtar.

Eurico de Sousa wrote:

Hi.

I've downloaded the .tar.gz files for MySQL 3.23.48, 3.23.47 and 3.23.46 for 
Sparc-Solaris 8 and all
of them complain of a checksum error on the tar-extract. Here's the output of tar xvf 
of the
gunzip'd-tar file:

x
mysql-3.23.46-sun-solaris2.8-sparc/sql-bench/Results/ATIS-Adabas-Linux_2.0.35_i686-cmp-adabas,mysql,
691 bytes, 2 tape blocks
tar: directory checksum error

All 3 versions give this error at the same spot. I've downloaded these versions off 
several mirror
sites using both HTTP and FTP through my browser and also using FTP without using the 
browser and
every one gives the same problem.

Can anyone please tell me what's going on? Is this a known bug? I'm using Sun's 
/usr/sbin/tar
program. The tar tvf lists out all the contents properly but the extract doesn't 
work. I've run the
tar xf as root and as a normal id - same problem.

I am running Solaris 8 on an Ultra-1 workstation.

Thanks,

Eurico


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail 
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php





-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Size Limitations

[Rick Emery]

The Linux version no longer has 2 GB limit.  It is now whatever your disk
capacity is.

-Original Message-
From: Steve Kramer [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 30, 2002 11:34 AM
To: Christopher Thompson
Cc: MySQL
Subject: RE: Size Limitations


The manual doesn't specify the Windows limit - only the Linux value of 2 gb.

-Original Message-
From: Christopher Thompson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 30, 2002 9:57 AM
To: Hashim Ismail; [EMAIL PROTECTED]
Subject: Re: Size Limitations


At 09:49 AM 1/30/2002 -0500, Hashim Ismail wrote:
Is there a database size limitation with MySQl in the Windows NT and
Windows
2000 enviroment?  Like some databases have size limitation of 2GB.

Yes.  Read the manual.  In a Windows environment, table sizes are limited
to 2 gigabytes if memory serves, it is all in the manual, though.  You can,
of course, have more than one table in your database.



-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Can't untar mysql on Solaris 8

[Michael Stassen]

Solaris tar is broken (can't handle long file names).  You need to use GNU
tar.  See

http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Solaris

Michael

On Wed, 30 Jan 2002, Eurico de Sousa wrote:

 Hi.
 
 I've downloaded the .tar.gz files for MySQL 3.23.48, 3.23.47 and 3.23.46 for 
Sparc-Solaris 8 and all
 of them complain of a checksum error on the tar-extract. Here's the output of tar 
xvf of the
 gunzip'd-tar file:
 
 x
 
mysql-3.23.46-sun-solaris2.8-sparc/sql-bench/Results/ATIS-Adabas-Linux_2.0.35_i686-cmp-adabas,mysql,
 691 bytes, 2 tape blocks
 tar: directory checksum error
 
 All 3 versions give this error at the same spot. I've downloaded these versions off 
several mirror
 sites using both HTTP and FTP through my browser and also using FTP without using 
the browser and
 every one gives the same problem.
 
 Can anyone please tell me what's going on? Is this a known bug? I'm using Sun's 
/usr/sbin/tar
 program. The tar tvf lists out all the contents properly but the extract doesn't 
work. I've run the
 tar xf as root and as a normal id - same problem.
 
 I am running Solaris 8 on an Ultra-1 workstation.
 
 Thanks,
 
 Eurico
 
 
 -
 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 [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Once more: MS Word MyODBC !?!?!

[Felix Schepmann]

Hello Folks,

oncemore I post this question:
Is it possible to update data from Microsoft Word useing MyODBC?
Is there any other way to update data from MS Word?
Is here a VB Scripting Guru who can help me?

cheers,

Felix.

(keywords: database, table, sql) :-)


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Really good idea on Performance Tuning???

[BD]

I sent a reply back to JW about his problem on performance tuning and came 
up with I thought a really good idea. But there weren't any bites so I 
thought I start it on a new thread.

There are a lot of threads about setting up MySQL for the best 
performance.  This might help to solve the problem.

What I'd like to see is a web page that has a MySQL/InnoDb configuration 
calculator where you simply enter the specifics of your hardware (like 
amount of RAM, # processors), # of connections, operating system, and 
database size, and it would tell you how best to configure the cnf 
file.  In fact, it could also generate the lines for the .cnf file so you 
can just copy and paste it into your own file (this avoids typing mistakes 
too). The web page could be hosted on MySQL or InnoDb web site. That way it 
would also be accessible from the client's office too.

This would at least provide the novice user with a setup configuration that 
is more accurate than he could achieve by pen and paper the first time out. 
The web page could be written in PHP and is easy enough to implement and 
the benefits would be enormous when you consider the # of MySQL sites out 
there that could use it.

Ok, what do you think. Will this idea fly?

Brent

Heikki, are you listening? :-)



-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

mutiple-column index and sorting (DESC)

[peaw peaw]

Hello.
I'm new to this mailing list :+)

I created a mutilple-column index, say 

create index col1_col2 on table_name (col1,col2)  

Both col1 and col2 are mediumint unsigned. 

explain select * from table_name where col1='value'
order by col1 DESC,col2 DESC  

shows that the query is still using filesort ! 
This is not supposed the be the case. Mysql manual
says it should read the index backward. 

what is happening here? anyone know? 
It's MySql version 3.23.23. Not including DESC
doesn't use any filesort. 

many thanks
Peaw

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com

-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Structure copy...

[Paul DuBois]

At 17:29 +0100 1/30/02, Vasoczki Ferenc wrote:
Hi, i want to copy a table structure.
I saw on the archive, there is a syntax like:
create [newtable] select * from [sourcetable] where 1=2;

This is not work on my MySQL server v.3.22
Is it a 3.23 feature, or am i do something wrong ?

It's a 3.23 feature.


If you know the solution please tell me that.
Thx

Vaso

You may be able to use the output from mysqldump --no-data db_name tbl_name,
which will produce the CREATE TABLE statement for the table.  Do a substitution
to change the name in the statement, then execute it.

-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Structure copy...

[Vasoczki Ferenc]

Yes, just i need to make it from code, and from a windows machine, so i cant
use shell() or something like that...
So i need to upgrade...

Vaso

-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: 2002. janur 30. 19:31
To: Vasoczki Ferenc; '[EMAIL PROTECTED]'
Subject: Re: Structure copy...


At 17:29 +0100 1/30/02, Vasoczki Ferenc wrote:
Hi, i want to copy a table structure.
I saw on the archive, there is a syntax like:
create [newtable] select * from [sourcetable] where 1=2;

This is not work on my MySQL server v.3.22
Is it a 3.23 feature, or am i do something wrong ?

It's a 3.23 feature.


If you know the solution please tell me that.
Thx

Vaso

You may be able to use the output from mysqldump --no-data db_name tbl_name,
which will produce the CREATE TABLE statement for the table.  Do a
substitution
to change the name in the statement, then execute it.

-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Once more: MS Word MyODBC !?!?!

[Butch Bean]

Yes, using MS Query which comes with Office

ODBC must be installed and working with a DSN set to you MySQL database
then...

See if you have MSQuery installed... if you do the file name is MSQRY32.EXE
in your Office directory.

If MSQuery is not installed, find your Office 2k CD and run setup.  You
should be able to click add/change installed options. In Office tools find
MS Query and pick Run from My Computer and then click Update Now.


Butch

-Original Message-
From: Felix Schepmann [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 30, 2002 1:06 PM
To: [EMAIL PROTECTED]
Subject: Re: Once more: MS Word  MyODBC !?!?!


Hello Folks,

oncemore I post this question:
Is it possible to update data from Microsoft Word useing MyODBC?
Is there any other way to update data from MS Word?
Is here a VB Scripting Guru who can help me?

cheers,

Felix.

(keywords: database, table, sql) :-)


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: How to get connected with mysql using perl scripts

[Colin Faber]

Hi,

see the DBI perldoc

here is a quick example:
  my $dbh = DBI-connect(DBI:mysql:mydb, $user, $password)
 or die Can't connect to $data_source: $DBI::errstr;

Charitha wrote:
 
 Hi all,
 
 Please guide me to get the connection with mysql through perl scripts and
 through the scripts i have to insert some lot of data in the existing
 tables.
 
 Thank you.
 
 Regards,
 Charitha.
 
 -
 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 [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-- 
Colin Faber
(303) 859-1491
fpsn.net, Inc.

-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Size Limitations

[James Montebello]

On Wed, 30 Jan 2002, Rick Emery wrote:
 The Linux version no longer has 2 GB limit.  It is now whatever your disk
 capacity is.

The no longer, however, is a function of later Linux kernels and
filesystems.  Linux 2.2 kernels with the ext2 filesystem (probably still
the most common setup) have a 2GB file size limitation, which is the cause
of the MySQL table size limitation.  MyISAM tables, at least on 3.23,
have a 4GB limitation unless you specifially configure it otherwise,
even if the OS allows larger files.

Given all of the possible combinations, if you're going to be pushing the
limits of table sizes, it's best to simply test and find out what your
particular config will allow you do to.

james montebello


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Can't install mysql on Solaris-2.5.1.

[Somsak RAKTHAI]

Dear sir,
  I used mysql-4.0.1 running on Solaris-2.5.1 and
compile with Gcc-2.95.3. (package from www.sunfreeware.com)
  I used command below.

CC=gcc CFLAGS=-O3 \
CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti \
./configure --prefix=/usr/local/mysql --with-low-memory --enable-assembler \
--with-charset=tis620

  And then when I used command make, it has error messages below.

ft_dump.o: In function `main':
ft_dump.o(.text+0x26c): undefined reference to `snprintf'
collect2: ld returned 1 exit status
*** Error code 1
make: Fatal error: Command failed for target `ft_dump'
Current working directory /misc/mysql/mysql-4.0.1-alpha/myisam
*** Error code 1
make: Fatal error: Command failed for target `all-recursive'
Current working directory /misc/mysql/mysql-4.0.1-alpha
*** Error code 1
make: Fatal error: Command failed for target `all-recursive-am'

  Please let me know how to solve this problem.

   thank you very much.
regards,
Somsak.


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

renaming a database

[JC]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

I'm kind of interested to find if there is a way to rename a database
with something like the alter command. 
Looking in the index of the New Riders MySQL book I don't see
anything other than renaming tables 
Looking through the Manual for  version 3 Nothing shows up
Looking at the mailing list archieve I don't see anything either 

I'm running 3.23.46-nt running on windows 2000 advanced server as a
service. 

I'm thinking that the only way around this would be to do a mysqldump
for that database and then creating a new database with the desired
name and importing the contents of the dump file. 

I'd like to be able to just rename the database from the command line
just like you would a table.

Thanks in advance,

JC

-BEGIN PGP SIGNATURE-
Version: PGPfreeware 6.5.8 for non-commercial use http://www.pgp.com

iQA/AwUBPFhE+XX+hJvt5DtWEQLSDQCgozPP+RqD56w4BQa8V+d/EviLH3EAnjN0
1TJ0ZkSsYXT0wiGWDarMwNRb
=zrmt
-END PGP SIGNATURE-


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: float/decimal ?

[Vasoczki Ferenc]

I need to store data like 12,213142124
where the decimal places can be 12.
What column type should i use ?
I tried float(4) but that is use only 2 decimal places, and i also tried
decimal(12,12) but that is give me back 9. for 10,704704 ?

vaso

database,sql,query,table just to post :)

-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: urgent respnse

[Michael Stassen]

On Tue, 29 Jan 2002, Sasha Pachev wrote:

 On Tuesday 29 January 2002 06:20 pm, Michael Widenius wrote:
  I think we can avoid things like this by adding some extra 'not-
  allowed-on-the-list' words, that a non-subscribe can't use, without
  including an extra keyword in the email.
  
  Sasha, what do you think about this?
 
 The point is that we block MOST spams, not EVERY spam that can be invented. 
 Yes, if the spammer happens to say , his message will make it 
[ filter word hidden to prove a point ]
 through. So what? This is just one message. If the current filter system 
 proves inadequate we will consider adjusting it. But for now, requiring the 
 sender to use one of the good words is sufficient to maintain a good signal 
 to noise ratio in my opinion.

This begs the question, what is a good signal to noise ratio?  How much
spam must escape the filter before you consider it inadequate?  Can you
see that this threshold is subjective, and that we've already crossed it
for some (many?).  

I joined this list several months ago.  My subjective impression (I
haven't been counting) is that the amount of spam making it through the
filter is increasing.  Perhaps this is cyclical and I just happened to
join at a low point, but it doesn't *feel* that way.  The number of
complaints about the spam is also increasing.  

Your customers are telling you something.  It is easy to read the above
response as It works well enough for me, quit whining.  I doubt that's
the professional impression you want to give.  

You say, This is just one message.  It is not.  Six of these have
escaped the filter already today.  None of them use any of the 4 filter
words.  At the very least, I'd suggest you fix the filter to actually do
what you say it does, *require* one of the good *words*.

Personally, I'm not that bothered by the spam.  I find deleting the spam
just as easy as deleting the 70-100 on-topic messages per day that don't
interest me.  On the other hand, I also don't see the big deal with
requiring a subscription to post.  Seems like a reasonable cost to get
otherwise free help.  (A little cost might just encourage a little more
manual reading.)

Finally, I'll just add that I've never been on a list where suggestions
that complaining about spam to the list only adds to the problem has had
any positive effect (despite it's apparent truth).

Michael

For the filter: charitable stableboy's vegetable grotesquery



-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: mysqld with daemontools

[Brian Reichert]

On Wed, Jan 30, 2002 at 01:31:53PM +0900, Tatsuhiko Miyagawa wrote:
 Has anybody out there experienced with mysqld running on
 daemontools?

Yes.

 We're now testing this combination on our staging server without
 any problem, but if you can suggest any problem for it  or
 anything, it would be appreciated.
 
 * Environment
 mysql 3.23.47 FreeBSD 4.4R

I've done it under FreeBSD 4.2.

   % cat /service/mysqld/run
   #!/bin/sh
   
   PATH=/usr/local/bin:/usr/bin:/bin
   export PATH
   
   exec env - PATH=$PATH /usr/local/mysql/libexec/mysqld 21

I have a whole pile of scripts for mysqld itself, logging, and a
control script for starting/stopping mysql.  What do you need?

 --
 Tatsuhiko Miyagawa [EMAIL PROTECTED]

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Storing word doc... 1000th..

[Vasoczki Ferenc]

I know this was in the list just i really can't found in the archive.
I have about 20 tables, and every tables have a questionary in .doc format.
I want to archive theese docs.
How can i store theese doc files in table, and how can i get back in the
same format what i stored ?

Thx
/replys can be sent only to me to not disturb the list../

Vaso

-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: renaming a database

[Paul DuBois]

At 11:10 -0800 1/30/02, JC wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

I'm kind of interested to find if there is a way to rename a database
with something like the alter command.
Looking in the index of the New Riders MySQL book I don't see
anything other than renaming tables
Looking through the Manual for  version 3 Nothing shows up
Looking at the mailing list archieve I don't see anything either

I'm running 3.23.46-nt running on windows 2000 advanced server as a
service.

I'm thinking that the only way around this would be to do a mysqldump
for that database and then creating a new database with the desired
name and importing the contents of the dump file.

I'd like to be able to just rename the database from the command line
just like you would a table.

If your database doesn't contain InnoDB tables, you can try this:

- Shut down the MySQL server
- Rename the database directory
- Restart the MySQL server

But remember that if you have entries in the grant tables that pertain
specifically to that database, you'll need to update them to use the
new database name.


Thanks in advance,

JC


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

SQL help plz

[P.Agenbag]

Hi
I need help with an sql string:

have a table similar to this:

idkeynamedate
1 123name1  date1
2 123name1  date2
3 111name2  date1
4 111name2  date2
5 123name1  date3
Now, I need sql to report the following result:

name1   date3
name2   date2


thus, report all the names in the table but only the ones with the 
latest date.

The sql MUST use the key to compare the different rows with each other 
and NOT the name, as the name is prone to spelling errors (ok, the key 
as well, but it's easier to make a typo with letters than with digits 
and I already have a couple of entries where the names of the entries 
are different.
 


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: float/decimal ?

[Paul DuBois]

At 20:10 +0100 1/30/02, Vasoczki Ferenc wrote:
I need to store data like 12,213142124
where the decimal places can be 12.
What column type should i use ?
I tried float(4) but that is use only 2 decimal places, and i also tried
decimal(12,12) but that is give me back 9. for 10,704704 ?

You can't store commas in numeric column types.


vaso

database,sql,query,table just to post :)

-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Batch load of data

[Eurico de Sousa]

Hi.

I have a question regarding loading data from text files into tables using the LOAD 
DATA statement.
I tried this under Win98 without success. Basically, I have a file called create.tbl 
which has
CREATE TABLE statements. The last statements in this file are of the form:

LOAD DATA INFILE file.dat REPLACE INTO TABLE tbl_name;

Then I ran, mysql create.tbl at the DOS prompt. Although it gave no errors, the 
tables were filled
with NULL values (other than the NOT NULL AUTO_INCREMENT fields). I tried this with 
just one simple
table to start with - it is defined as:

CREATE TABLE tbl_name (pid MEDIUMINT NOT NULL AUTO_INCREMENT, name VARCHAR(50), 
PRIMARY KEY (pid));

In the file.dat data file, I only put in 2 rows with one column (the name). I didn't 
put a column
with numbers because it's defined as AUTO_INCREMENT, so I figure the DBMS will take 
care of creating
it properly. The result is that I do have two pids (1 and 2) but the name field in the 
table is
NULL.

I tried putting the name values in the file.dat file without quotes and also with 
single and double
quotes, but to no avail. I also put the data file in my current directory, in the data 
directory and
in the database directory, but all gave the same result. In addition, everytime I ran 
mysql 
create.tbl, the table kept growing - so, instead of only having 2 entries in it, I now 
have about 20
or so, where the first id field numbers from 1 to 20 and the other field is all null.

Any ideas? Must I put a consecutive number field in the data file anyway as the first 
column?

Thanks,

Eurico


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: renaming a database

[Nathan]

This may already be implemented, but the MySQL Technical Reference for Version 3.23.41 
states:

1.6.2 Things that must be done in the real near future:
- Implement RENAME DATABASE. To make this safe for all table handlers, it should work 
as follows:
  - Create the new database.
  - For every table do a rename of the table to another database, as we do with the 
RENAME command.
  - Drop the old database.


Of course, you should be able to simply rename the folder that contains your 
tables you could
script it if you had to, either in Perl or a Win32 batch file, depending on your 
system.

# Nathan


- Original Message -
From: JC [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, January 30, 2002 12:10 PM
Subject: renaming a database


-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

I'm kind of interested to find if there is a way to rename a database
with something like the alter command.
Looking in the index of the New Riders MySQL book I don't see
anything other than renaming tables
Looking through the Manual for  version 3 Nothing shows up
Looking at the mailing list archieve I don't see anything either

I'm running 3.23.46-nt running on windows 2000 advanced server as a
service.

I'm thinking that the only way around this would be to do a mysqldump
for that database and then creating a new database with the desired
name and importing the contents of the dump file.

I'd like to be able to just rename the database from the command line
just like you would a table.

Thanks in advance,

JC

-BEGIN PGP SIGNATURE-
Version: PGPfreeware 6.5.8 for non-commercial use http://www.pgp.com

iQA/AwUBPFhE+XX+hJvt5DtWEQLSDQCgozPP+RqD56w4BQa8V+d/EviLH3EAnjN0
1TJ0ZkSsYXT0wiGWDarMwNRb
=zrmt
-END PGP SIGNATURE-


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Really good idea on Performance Tuning???

[Mike Wexler]

I don't think this will work. The setting depend on a lot more variables then 
you list. For example the mix of queries to updates. Although what you are 
suggesting might make a first approximation.
Maybe a field where you could copy and paste the output of show status would 
help to alleviate the problems and get us to at least a second approximation.

I agree that some kind of automation here would be desirable.


BD wrote:

 I sent a reply back to JW about his problem on performance tuning and 
 came up with I thought a really good idea. But there weren't any bites 
 so I thought I start it on a new thread.
 
 There are a lot of threads about setting up MySQL for the best 
 performance.  This might help to solve the problem.
 
 What I'd like to see is a web page that has a MySQL/InnoDb configuration 
 calculator where you simply enter the specifics of your hardware (like 
 amount of RAM, # processors), # of connections, operating system, and 
 database size, and it would tell you how best to configure the cnf 
 file.  In fact, it could also generate the lines for the .cnf file so 
 you can just copy and paste it into your own file (this avoids typing 
 mistakes too). The web page could be hosted on MySQL or InnoDb web site. 
 That way it would also be accessible from the client's office too.
 
 This would at least provide the novice user with a setup configuration 
 that is more accurate than he could achieve by pen and paper the first 
 time out. The web page could be written in PHP and is easy enough to 
 implement and the benefits would be enormous when you consider the # of 
 MySQL sites out there that could use it.
 
 Ok, what do you think. Will this idea fly?
 
 Brent
 
 Heikki, are you listening? :-)
 
 
 
 -
 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 [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Can't untar mysql on Solaris 8

[Eurico de Sousa]

Appreciate those of you referring me to GNU tar - it did untar mysql properly whereas 
SUN's tar
couldn't.

Eurico


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: SQL help plz

[Paul DuBois]

At 21:36 +0200 1/30/02, P.Agenbag wrote:
Hi
I need help with an sql string:

have a table similar to this:

idkeynamedate
1 123name1  date1
2 123name1  date2
3 111name2  date1
4 111name2  date2
5 123name1  date3
Now, I need sql to report the following result:

name1   date3
name2   date2


thus, report all the names in the table but only the ones with the 
latest date.

The sql MUST use the key to compare the different rows with each 
other and NOT the name, as the name is prone to spelling errors (ok, 
the key as well, but it's easier to make a typo with letters than 
with digits and I already have a couple of entries where the names 
of the entries are different.

Create another table to hold the maximum date associated with each key value
(which I'm calling k rather than key because key is a reserved word):

CREATE TABLE t2 SELECT k, MAX(date) AS date FROM t GROUP BY k;

Then join this table with the original to get the rows with the appropriate
k and date values, printing out the name and date values:

SELECT t.name, t.date FROM t, t2
WHERE t.k = t2.k and t.date = t2.date
ORDER BY name;

-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

mysql trouble

[Victoria Reznichenko]

valentin,

Wednesday, January 30, 2002, 5:57:00 PM, you wrote:

v Hello,
v We are students in a french university and we have a trouble while
v running mysql on our server.
v After typing the command mysql, we have this message:

v ERROR 2002: Can't connect to local MySQL server through socket
v '/tmp/mysql.sock' (111)

v So we should know how resolve it.
v Excuse me for my english and we wait your answer as soon as possible.

It means that you are using wrong socket file or TCP/IP port, or MySQL server is not 
running.

Look at: http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html




-- 
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: SQL help plz

[Rick Emery]

mysql describe mytable;
+---+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-+---+
| id| int(11)  | YES  | | NULL|   |
| keyq  | int(11)  | YES  | | NULL|   |
| name  | char(20) | YES  | | NULL|   |
| dateq | date | YES  | | NULL|   |
+---+--+--+-+-+---+
4 rows in set (0.00 sec)

select name,max(dateq) from mytable group by name;

-Original Message-
From: P.Agenbag [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 30, 2002 1:36 PM
To: mysql
Subject: SQL help plz


Hi
I need help with an sql string:

have a table similar to this:

idkeynamedate
1 123name1  date1
2 123name1  date2
3 111name2  date1
4 111name2  date2
5 123name1  date3
Now, I need sql to report the following result:

name1   date3
name2   date2


thus, report all the names in the table but only the ones with the 
latest date.

The sql MUST use the key to compare the different rows with each other 
and NOT the name, as the name is prone to spelling errors (ok, the key 
as well, but it's easier to make a typo with letters than with digits 
and I already have a couple of entries where the names of the entries 
are different.
 


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: SQL help plz

[Rick Emery]

Sorry, I meant:

mysql select name,max(dateq) from mytable group by keyq;

-Original Message-
From: Rick Emery 
Sent: Wednesday, January 30, 2002 2:14 PM
To: 'P.Agenbag'; mysql
Subject: RE: SQL help plz


mysql describe mytable;
+---+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-+---+
| id| int(11)  | YES  | | NULL|   |
| keyq  | int(11)  | YES  | | NULL|   |
| name  | char(20) | YES  | | NULL|   |
| dateq | date | YES  | | NULL|   |
+---+--+--+-+-+---+
4 rows in set (0.00 sec)

select name,max(dateq) from mytable group by name;

-Original Message-
From: P.Agenbag [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 30, 2002 1:36 PM
To: mysql
Subject: SQL help plz


Hi
I need help with an sql string:

have a table similar to this:

idkeynamedate
1 123name1  date1
2 123name1  date2
3 111name2  date1
4 111name2  date2
5 123name1  date3
Now, I need sql to report the following result:

name1   date3
name2   date2


thus, report all the names in the table but only the ones with the 
latest date.

The sql MUST use the key to compare the different rows with each other 
and NOT the name, as the name is prone to spelling errors (ok, the key 
as well, but it's easier to make a typo with letters than with digits 
and I already have a couple of entries where the names of the entries 
are different.
 


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: SQL help plz

[Rick Emery]

Further, I'd advise NOT using field names like date and key.  Using
eserved words is never a good prcatice.

-Original Message-
From: Rick Emery 
Sent: Wednesday, January 30, 2002 2:16 PM
To: 'P.Agenbag'; 'mysql'
Subject: RE: SQL help plz


Sorry, I meant:

mysql select name,max(dateq) from mytable group by keyq;

-Original Message-
From: Rick Emery 
Sent: Wednesday, January 30, 2002 2:14 PM
To: 'P.Agenbag'; mysql
Subject: RE: SQL help plz


mysql describe mytable;
+---+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-+---+
| id| int(11)  | YES  | | NULL|   |
| keyq  | int(11)  | YES  | | NULL|   |
| name  | char(20) | YES  | | NULL|   |
| dateq | date | YES  | | NULL|   |
+---+--+--+-+-+---+
4 rows in set (0.00 sec)

select name,max(dateq) from mytable group by name;

-Original Message-
From: P.Agenbag [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 30, 2002 1:36 PM
To: mysql
Subject: SQL help plz


Hi
I need help with an sql string:

have a table similar to this:

idkeynamedate
1 123name1  date1
2 123name1  date2
3 111name2  date1
4 111name2  date2
5 123name1  date3
Now, I need sql to report the following result:

name1   date3
name2   date2


thus, report all the names in the table but only the ones with the 
latest date.

The sql MUST use the key to compare the different rows with each other 
and NOT the name, as the name is prone to spelling errors (ok, the key 
as well, but it's easier to make a typo with letters than with digits 
and I already have a couple of entries where the names of the entries 
are different.
 


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Combining and sorting large tables

[Brendan Pirie]

Hi,

I have two tables I wish to combine into a single table.  Both tables use
the same format and include a unique key (ID) auto-increment field.  Each
row also contains a date field.  Whoever managed this database in the past
at some point set up a new server, and initially had new data sent to
whichever server was less busy, but the two databases were not mirrored, so
each contains entirely unique data, and there is a date overlap from when
both servers were collecting data.  I want to combine them into a single
table now and get rid of the old server, but, because of 3rd-party software
that interacts with the database, I need for the entire table to be sorted
by the date field and assign all new auto-increment IDs based on that
sorting (ie. the oldest dated record should have the lowest unique ID,
etc..).  There are approx 2.5 million records in each table (give or take),
and, of course, I need to minimize downtime on the live database.

I'm no database expert, but I have read through a good part of O Reilly's
MySQL book and scanned the FAQ and mail list, but this is a pretty specific
case and I haven't turned up a lot of meaningful results thus far.  My
biggest concern is downtime.  If not for that, I could probably muddle
through it and get it done using my own crude methods.

FYI  The server is running RedHat 7.2 and MySQL 3.23.41 on Intel-based
hardware.


Thanks for any and all suggestions.

Brendan


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

question re: field size

[Emily Kelley]

In the process of searching for a dynamic database solution for a work
project I have just begun reading about MySQL. So far this looks like a
very promising choice for us but I have one extremely basic question that I
hope someone will kindly answer for me. 

Is there a character limit for text fields? Our current database info has
been constructed in MS-Access 97 and we have a real problem with the fact
that a text field is limited to 255 characters. We frequently have
descriptive text and citations that can run over this length so it is a
crucial that we find a system that will allow us to include all the related
information for  the documented event.

Thank you,

Emily Kelley
Research Assoc. / Historical Cartographer
Atlas of Historical County Boundaries
Newberry Library
Chicago, IL


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php