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
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
AW: MySQL 3.23.47 on MacOSX 10.1.2: Could someone help me getting started
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
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
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
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.
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
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
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
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.
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
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.
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
[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)
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
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
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
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.
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 ...
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.
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
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
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.
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
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
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
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
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
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
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
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
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
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
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 ...
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 ...
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
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
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
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...
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
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)
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.
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
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
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
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
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
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
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
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
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
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
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
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
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
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 !?!?!
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???
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)
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...
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...
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 !?!?!
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
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
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.
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
-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 ?
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
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
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..
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
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
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 ?
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
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
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???
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
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
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
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
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
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
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
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
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