mysql with pth lib compilation
Hi all, I am trying to compile mysql-3.23.49 on OpenBSD 3.1-stable with pth lib. Note: since OpenBSD 3.1 mysql is compiling with native OpenBSD threads. And I found it is very unstable. I meant ports collection. I am running mysql with pth lib on OpenBSd 2.9 without problems. Once I get mysql compiled on 3.1 with pth 1.4.1 I experience kind of 'one thread at a time' behaviour. I.e. first connection is fine. Making second connection while first is sactive will block right after I supplied password for mysql command. Once first connection closed, second become alive. And so on. I know it should work fine and seems for me like configure script issue. Any hint ? -- Deem0N** [EMAIL PROTECTED] ** Natural born YASPer http://www.yasp.com/ Just Another Perl Monger http://spb.pm.org/ R U X Y founder http://www.ruxy.org.ru/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Bothway Replication - Fail Back - Hold Master while Slave is Synchronizing.
MySQL Bothway Replication - Fail Back - Hold Master while Slave is Synchronizing. I have the following question: Is it possible to have a slave on machine M1 synchronizing with a master on another machine M2 while the master on the first machine M1 does not accept requests yet (i.e. it is not available to a client yet)? Background info: Why do I want this? Well, I have a configuration where two machines run MySQL. They are configured to replicate each others updates. Although two masters are effectively running, only one is used at a time. This is taken care of by the client. When the first machine fails, the client detects this and goes to the other machine. So for so good. When machine M1 comes on-line again then our client immediately starts to use it (fail-back) (it has - let's say - a preferred machine and I can't disable this). The database, however, is not correct yet. The slave needs to synchronize with M2 still. So we read old data. This situation could be avoided if we can let the master on M1 wait until the salve on M1 has completed its synchronization, and the databases are in sync again. Thanks, Johan. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 gcc 3
When will testing be finished of compiling mysql with gcc 3? -- Roos IT webmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 share a MyISAM table among different databases
Benjamin, thanks for the answer! There are at least two reasons to have such a common table shared between databases, and having it explicitly appear as a regular table in each of the DBs: 1. to make such a table accessible for users, which suppose to live entirely in their DBs. 2. to make such a table visible for DBA tools, which cannot jump from one DB to another. Best, Dmitry - Original Message - From: Benjamin Pflugmann [EMAIL PROTECTED] To: Dmitry Kuznetsov [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, August 19, 2002 8:03 PM Subject: Re: How to share a MyISAM table among different databases Hi. On Mon 2002-08-19 at 17:29:49 +0200, [EMAIL PROTECTED] wrote: Hi, folks! I would apreciate your opinion on my question: How to make a MyISAM table (or several tables) to be shared among different databases served by one MySQL server on Unix (Solaris)? It is OK if this table appears as a read/write table in one database only, other DBs access it read-only. My experience with tables, being hardlinked to the different directories (i.e. databases), is bad, as these tables soon become corrupted. However, I did not experiment with softlinks (ln -s). Any ideas? I think there is no reasonable way to do this. But what is your reason to try this? Usually I would put the common table within its own database and simply use this database in queries, like this: SELECT * FROM table1 as one, common.table2 as two WHERE one.whatever = two.whatever If that does not fit your case, please elaborate. Bye, Benjamin. -- [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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
temp tables
Hi, MySQL is creating about 50% of temp tables on disk and this is with 10Meg of temp table cache. Is this normal? and sould I up temp table cache further. Below is the output from SHOW STATUS Cheers John Wards SportNetwork.net Var Name Value Aborted_clients 19559 Aborted_connects 12 Bytes_received 144045478 Bytes_sent 657420475 Connections 116006 Created_tmp_disk_tables 28024 Created_tmp_tables 55934 Created_tmp_files 0 Delayed_insert_threads 0 Delayed_writes 0 Delayed_errors 0 Flush_commands 1 Handler_delete 5720 Handler_read_first 78755 Handler_read_key 100387564 Handler_read_next 146147564 Handler_read_prev 486 Handler_read_rnd 11027161 Handler_read_rnd_next 87804710 Handler_update 83081194 Handler_write 39761449 Key_blocks_used 15029 Key_read_requests 24357959 Key_reads 12428 Key_write_requests 521710 Key_writes 490850 Max_used_connections 61 Not_flushed_key_blocks 0 Not_flushed_delayed_rows 0 Open_tables 647 Open_files 88184 Open_streams 0 Opened_tables 813 Questions 1449450 Select_full_join 4551 Select_full_range_join 0 Select_range 117053 Select_range_check 0 Select_scan 57218 Slave_running OFF Slave_open_temp_tables 0 Slow_launch_threads 0 Slow_queries 39 Sort_merge_passes 0 Sort_range 203689 Sort_rows 16225004 Sort_scan 2 Table_locks_immediate 1361074 Table_locks_waited 1841 Threads_cached 43 Threads_created 62 Threads_connected 19 Threads_running 1 Uptime 61862 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 share a MyISAM table among different databases
Hi, Sergey! As stated in description: A MERGE table is a collection of identical MyISAM tables that can be used as one. , i.e. content of these tables, being merged, is merged also. I need the opposite - one physical table being represented in multiple DBs as if these replicas are regular tables. Although, one may have one master table (with master contents), and empty tables with the same structure in other DBs. Such an empty table might be merged over the master table. Yes. Thanks for the hint! Dmitry. - Original Message - From: Sergei Golubchik [EMAIL PROTECTED] To: Benjamin Pflugmann [EMAIL PROTECTED]; Dmitry Kuznetsov [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, August 19, 2002 8:36 PM Subject: Re: How to share a MyISAM table among different databases Hi! On Aug 19, Benjamin Pflugmann wrote: Hi. On Mon 2002-08-19 at 17:29:49 +0200, [EMAIL PROTECTED] wrote: Hi, folks! I would apreciate your opinion on my question: How to make a MyISAM table (or several tables) to be shared among different databases served by one MySQL server on Unix (Solaris)? It is OK if this table appears as a read/write table in one database only, other DBs access it read-only. Any ideas? I think there is no reasonable way to do this. But what is your reason to try this? Benjamin, it is possible with MERGE tables. And as MERGE tables support INSERTs ;)) may be this aliasing can even work with read/write access. One can edit .MRG file to add a proper path there. Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: LOAD DATA, \N, and auto_increment
Hi! Benjamin == Benjamin Pflugmann [EMAIL PROTECTED] writes: cut Benjamin How-to-repeat: shell cat /tmp/in EOF Benjamin 1 Benjamin 2 Benjamin \N Benjamin \N Benjamin 10 Benjamin \N Benjamin EOF shell chmod a+r /tmp/in mysql CREATE TABLE ntest2 ( a INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ); mysql LOAD DATA INFILE '/tmp/in' INTO TABLE ntest2; Benjamin Query OK, 6 rows affected (0.00 sec) Benjamin Records: 6 Deleted: 0 Skipped: 0 Warnings: 3 mysql SELECT * FROM ntest2; Benjamin ++ Benjamin | a | Benjamin ++ Benjamin | 1 | Benjamin | 2 | Benjamin | 3 | Benjamin | 4 | Benjamin | 10 | Benjamin | 11 | Benjamin ++ Benjamin 6 rows in set (0.00 sec) Benjamin As said above, the shown output differs from the expected in the Benjamin Warnings: 3 message. There should be 0 warnings. Here is a patch for this (will be in 4.0.3) ((/my/mysql-4.0)) bk diffs -c sql/sql_load.cc = sql/sql_load.cc 1.36 vs edited = *** /tmp/sql_load.cc-1.36-13800 Tue Jul 23 18:31:17 2002 --- edited/sql/sql_load.cc Tue Aug 20 11:50:37 2002 *** *** 430,436 { if (field-type() == FIELD_TYPE_TIMESTAMP) ((Field_timestamp*) field)-set_time(); ! else thd-cuted_fields++; } continue; --- 430,436 { if (field-type() == FIELD_TYPE_TIMESTAMP) ((Field_timestamp*) field)-set_time(); ! else if (field != table-next_number_field) thd-cuted_fields++; } continue; Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 gcc 3
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tuesday 20 August 2002 10:33, Marc Roos wrote: When will testing be finished of compiling mysql with gcc 3? We already successfully compiled MySQL with gcc 3.1 and have just started some tests with gcc 3.2 - so far it looks good... Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE9YggBSVDhKrJykfIRAvTRAJ4sknmPVT48PzfCq2RrATKcPo9XDACfWTCU UyAnbQPSh1gqjheIfdK8UMI= =5dnD -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
No reply from partner@mysql.com
Hi All, i've sent a letter to [EMAIL PROTECTED] but until now it still no answer. Actually it's an active email address or not ? Please give me better suggestion, because i love this MySQL products and i want to make a partnership with them - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Utility for importing Paradox tables to MYSQL
Hi, I wonder if there is a utility for transferring Paradox tables to MySQL. Nickos - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 share a MyISAM table among different databases
Hi! On Aug 20, Dmitry Kuznetsov wrote: Hi, Sergey! As stated in description: A MERGE table is a collection of identical MyISAM tables that can be used as one. , i.e. content of these tables, being merged, is merged also. I need the opposite - one physical table being represented in multiple DBs as if these replicas are regular tables. Well, a collection can consist of only one table :) So, you create a MERGE table that merges the table you want to alias, and put this MERGE table in whatever database you want. Then, edit .MRG file to add a proper path there. Voila. Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 over NFS
Hi... I've got the folowing question, our servers are running pretty busy these days and our main DB server is taking high load peaks (memory is OK but the cpu has almost no idle time). We have another spare server and I'm thinking about mounting the database over NFS (100mb LAN) to the spare server and using both as frontends to the DB. Both servers are supposed to do reads and updates to the DB, but i'm concerned with the updates of the server using NFS. Are NFS locks safe enough to run this kind of setup? Is this going to be an advantage or will suffer from other kinds of problems? Both boxes are PIII dual 1Ghz / 1Gb ram, Linux 2.4.16, MySQL 3.23.52 Thanx -- L - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 command from the shell
hi list Can I also execute mysql commands from the shell. Something like this: % mysql -u root -pmypass --execute=use mydb; select * from mytable; Thanks.. ilyas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 command from the shell
IK hi list IK Can I also execute mysql commands from the shell. IK Something like this: IK % mysql -u root -pmypass --execute=use mydb; select * from mytable; You can do something like this i think : % mysql -u root -pmypass mydb --execute='select * from mytable' David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Constraint Hell
sql, Query Hark ye experts! Here I stand an expert grunt. Trying to understand, The syntax of constraint. I was directed to the constraint doc. And found the constraint doc doth suck. Here's my ploy, renewed, refined. Please see if you can help. To create my Foreign table I used the following script CREATE TABLE IIM_InventoryItemMaster( IIM_InventoryItemMaster_ID MEDIUMINT(8) NOT NULL, IIM_ItemNm VARCHAR(64), IIM_ItemDescCD VARCHAR(1) DEFAULT 'U', IIM_GenderCD VARCHAR(1), IIM_ItemPN VARCHAR(36), IIM_Spec1Nm VARCHAR(48), IIM_Spec2Nm VARCHAR(48), IIM_RecordCreatedBY VARCHAR(24), IIM_RecordCreatedDT DATETIME, IIM_LastEditBY VARCHAR(24), IIM_LastEditDT DATETIME, PRIMARY KEY(IIM_InventoryItemMaster_ID), KEY(IIM_GenderCD), KEY(IIM_ITEMNm), KEY(IIM_ItemDescCD), key(IIM_ItemPN) ) Type = INNoDB; Then SHOW CREATE TABLE Told me the table type is MyISAM. Don't I need InnoDB to use Constraints? Does INNoDB cause it woe? === Now for some clear and Poignant questions about MySQL hell? === From the following URL:http://www.mysql.com/doc/en/CREATE_TABLE.html I found Constraint docs === [CONSTRAINT symbol] FOREIGN KEY [index_name] (index_col_name,...) [reference_definition: REFERENCES tbl_name [(index_col_name,...)] [MATCH FULL | MATCH PARTIAL] [ON DELETE reference_option] [ON UPDATE reference_option] === Question I. If there is a Foreign Key in a Foreign Table, then there must be a Native key in a Native Table. What is the correct technical name of the {Native} Field? Question II I understand CONSTRAINT symbol to be the name of the constraint. true or false? Then there is FOREIGN KEY [index_name] What Index_name, The name of the Foreign Key field's Index (located in the Foreign Table?) So this is the name of an index in the Foreign Table? Question III. Then comes (index_col_name,...) I guess this means the name of the Foreign Key Field(s)? true or false; Question IV. Next comes REFERENCES tbl_name. [(index_col_name,...)] The name of the Native Table or he Fireign Table? [(index_col_name)], This must mean the name of the Foreign Key Field(s) AGAIN? true or false Question V. I suppose I should include the Constraint syntax in the SQL that creates the Native Table and not in the SQL that creats the Foreign Table? True or false? Thanks for your help Jim Bailey _ 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
Running two instances from one my.ini?
Hello, I have mysqld-max (3.23.51) running on a Windows 2000 machine. Is it possible to run another MySQL server alongside it, using the same my.ini file but set on a different port, e.g. with mysqld-max --standalone --console --port=3307 The reason I want to do this is to check changes to the my.ini file (adding binary logging) before I shutdown and restart the main MySQL server; I'd rather know it's going to work, than have to shut down and restart the main server multiple times if there are problems. I've tried this with a server on my localhost (it seems to work fine), but don't this is obviously running under different conditions, and the process might not be so smooth on a large, running server. Could you Cc any replies to [EMAIL PROTECTED], as our mail filter has prevented me from subscribing to this very useful list! Thanks in advance. Elliot Smith -- Web Development Engineer Corporate Web Team Information Services University of Birmingham email: [EMAIL PROTECTED] telephone: 0121 414 7108 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
max_allowed_packet (was: Re: 4.0.x bug with LONGTEXT?)
* Harald Fuchs In article [EMAIL PROTECTED], Victoria Reznichenko [EMAIL PROTECTED] writes: As you can see txt1 and txt2 contain text file ~ 8M UPDATE tbl1 SET total=CONCAT(txt1,txt2) WHERE id=1; SELECT id, LENGTH(txt1), LENGTH(txt2), LENGTH(total) FROM tbl1; ++--+--+---+ | id | LENGTH(txt1) | LENGTH(txt2) | LENGTH(total) | ++--+--+---+ | 1 | 8390060 | 8390060 | 0 | ++--+--+---+ The same result. MySQL inserts NULL in the total, because you can't store data more than max_allowed_packet. Thanks for the clarification, Victoria. I'm sorry, but this is not very clear to me... The manual describes max_allowed_packet as Max packetlength to send/receive from to server. Why are the columns transferred between server/client in the above statement? Shouldn't the entire UPDATE happen on the server side? -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
segfault in error.c with unixodbc since MyODBC 3.51.03
Hello, I get a nasty segmentation fault as soon as a SQLconnect fails using unixodbc, e.g. the isql coming with! The ddd output is quoted below. Let me tell you how I build the Drivers etc., maybe the error is related to this. I used gcc version 2.95.3 20010315 (SuSE), to compile: unixODBC-2.2.2.tar.gz from www.unixodbc.com MyODBC-3.51.03.tar.gz from www.mysql.com HOWEVER, when building the driver from MyODBC 3.51.02 which came with unixodbc, this seg fault doesn't occur The server in binary distribution mysql-3.23.52-pc-linux-gnu-i686.tar.gz und the shared lib and devel and stuff MySQL-shared-3.23.52-1.i386.rpm MySQL-devel-3.23.52-1.i386.rpm Here, I am wondering, whether these have been build for thread-safe-clients, as this has been required somewhere. I tried to follow the build instruction in INSTALL best I could, for unixODBC and especially for MyODBC, I didn't rebuild the mySQL binaries, and the shared client libs, though. So, ddd gives to following output, where === indicates the SEGFAULT in error.c SQLRETURN SQL_API SQLError(SQLHENV henv, SQLHDBC hdbc, SQLHSTMT hstmt, SQLCHAR FAR*szSqlState, SQLINTEGER FAR *pfNativeError, SQLCHAR FAR*szErrorMsg, SQLSMALLINTcbErrorMsgMax, SQLSMALLINT FAR *pcbErrorMsg) { SQLRETURN error=SQL_INVALID_HANDLE; DBUG_ENTER(SQLError); if (hstmt){ error = my_SQLGetDiagRec(SQL_HANDLE_STMT,hstmt,1,szSqlState, pfNativeError, szErrorMsg, cbErrorMsgMax,pcbErrorMsg); if(error == SQL_SUCCESS) CLEAR_STMT_ERROR(((STMT FAR*)hstmt)); } else if (hdbc){ error = my_SQLGetDiagRec(SQL_HANDLE_DBC,hdbc,1,szSqlState, pfNativeError, szErrorMsg, cbErrorMsgMax,pcbErrorMsg); if(error == SQL_SUCCESS) CLEAR_STMT_ERROR(((STMT FAR*)hstmt)); } else if (henv){ error = my_SQLGetDiagRec(SQL_HANDLE_ENV,henv,1,szSqlState, pfNativeError, szErrorMsg, cbErrorMsgMax,pcbErrorMsg); if(error == SQL_SUCCESS) === CLEAR_STMT_ERROR(((STMT FAR*)hstmt)); } DBUG_RETURN(error); } Program received signal SIGSEGV, Segmentation fault. [Switching to Thread 1024 (LWP 14777)] 0x40cd56e7 in SQLError (henv=0x0, hdbc=0x80bf090, hstmt=0x0, szSqlState=0xbfffcefc S1000, pfNativeError=0xbfffc8ec, szErrorMsg=0xbfffccf8 [MySQL][ODBC 3.51 Driver]Access denied for user: 'X' (Using password: YES), cbErrorMsgMax=513, pcbErrorMsg=0xbfffc8f2) at error.c:616 /XXX/X//mysql/MyODBC-3.51.03/error.c:616:20083:beg :0x40cd56e7 Current language: auto; currently c (gdb) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Too many connections
Dear Sir, We are facing a problem related to mysql connections. The error saying that:- TOO MANY CONECTONS OPEN: Mysql server max_connections variable is currently set to 100, please tell me how i can change the max_connections value. Thank you, Mansoor Alam. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Constraint Hell
On Tuesday 20 August 2002 08:00 am, Jim Bailey wrote: http://www.mysql.com/doc/en/SEC447.html RTFM, couldn't be more clear, the columns in both master and slave which are constrained need to be indexed, and yes the FOREIGN KEY and REFERENCES sections name the INDEXES, not the columns. Its FOREIGN KEY (index_in_this_table) REFERENCES (index_in_other_table) This is I believe entirely standard SQL anyhow, works the same way in other databases. sql, Query Hark ye experts! Here I stand an expert grunt. Trying to understand, The syntax of constraint. I was directed to the constraint doc. And found the constraint doc doth suck. Here's my ploy, renewed, refined. Please see if you can help. To create my Foreign table I used the following script CREATE TABLE IIM_InventoryItemMaster( IIM_InventoryItemMaster_ID MEDIUMINT(8) NOT NULL, IIM_ItemNm VARCHAR(64), IIM_ItemDescCD VARCHAR(1) DEFAULT 'U', IIM_GenderCD VARCHAR(1), IIM_ItemPN VARCHAR(36), IIM_Spec1Nm VARCHAR(48), IIM_Spec2Nm VARCHAR(48), IIM_RecordCreatedBY VARCHAR(24), IIM_RecordCreatedDT DATETIME, IIM_LastEditBY VARCHAR(24), IIM_LastEditDT DATETIME, PRIMARY KEY(IIM_InventoryItemMaster_ID), KEY(IIM_GenderCD), KEY(IIM_ITEMNm), KEY(IIM_ItemDescCD), key(IIM_ItemPN) ) Type = INNoDB; Then SHOW CREATE TABLE Told me the table type is MyISAM. Don't I need InnoDB to use Constraints? Does INNoDB cause it woe? === Now for some clear and Poignant questions about MySQL hell? === From the following URL:http://www.mysql.com/doc/en/CREATE_TABLE.html I found Constraint docs === [CONSTRAINT symbol] FOREIGN KEY [index_name] (index_col_name,...) [reference_definition: REFERENCES tbl_name [(index_col_name,...)] [MATCH FULL | MATCH PARTIAL] [ON DELETE reference_option] [ON UPDATE reference_option] === Question I. If there is a Foreign Key in a Foreign Table, then there must be a Native key in a Native Table. What is the correct technical name of the {Native} Field? Question II I understand CONSTRAINT symbol to be the name of the constraint. true or false? Then there is FOREIGN KEY [index_name] What Index_name, The name of the Foreign Key field's Index (located in the Foreign Table?) So this is the name of an index in the Foreign Table? Question III. Then comes (index_col_name,...) I guess this means the name of the Foreign Key Field(s)? true or false; Question IV. Next comes REFERENCES tbl_name. [(index_col_name,...)] The name of the Native Table or he Fireign Table? [(index_col_name)], This must mean the name of the Foreign Key Field(s) AGAIN? true or false Question V. I suppose I should include the Constraint syntax in the SQL that creates the Native Table and not in the SQL that creats the Foreign Table? True or false? Thanks for your help Jim Bailey _ 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: MySQL over NFS
On Tuesday 20 August 2002 06:39 am, Luis Calero wrote: NFS locking is ALWAYS problematical. You might have no problems, you might also be instantly in hell. Its really hard actually to answer your question. NFS implementations vary greatly in their quality. In addition it depends on the NICs you have. Some NICs create a lot more CPU load than others. 1st thing to do would be to test with a dummy database and see if the setup will work at all. Then you'd need to load test your NFS server, tune it, and see what you can get out of it for throughput. Finally you'd have to test the actual setup and find out if it really works better. Needless to say most sysadmins find this sort of thing to be too much trouble and just upgrade their hardware! Hi... I've got the folowing question, our servers are running pretty busy these days and our main DB server is taking high load peaks (memory is OK but the cpu has almost no idle time). We have another spare server and I'm thinking about mounting the database over NFS (100mb LAN) to the spare server and using both as frontends to the DB. Both servers are supposed to do reads and updates to the DB, but i'm concerned with the updates of the server using NFS. Are NFS locks safe enough to run this kind of setup? Is this going to be an advantage or will suffer from other kinds of problems? Both boxes are PIII dual 1Ghz / 1Gb ram, Linux 2.4.16, MySQL 3.23.52 Thanx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 share a MyISAM table among different databases
On Tuesday 20 August 2002 06:27 am, Sergei Golubchik wrote: The key quote from the manual is... All used tables must be in the same database as the MERGE table itself. which makes sense. Fundamentally a database is an independent unit of data storage. You can't share data between two seperate databases. I know some systems approach this differently, but that seems to be the philosophy in MySQL, and getting away from that would pretty much throw the grant system out the window. Hi! On Aug 20, Dmitry Kuznetsov wrote: Hi, Sergey! As stated in description: A MERGE table is a collection of identical MyISAM tables that can be used as one. , i.e. content of these tables, being merged, is merged also. I need the opposite - one physical table being represented in multiple DBs as if these replicas are regular tables. Well, a collection can consist of only one table :) So, you create a MERGE table that merges the table you want to alias, and put this MERGE table in whatever database you want. Then, edit .MRG file to add a proper path there. Voila. Regards, Sergei - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 over NFS
This is an interesting idea. I would be a happy man if it would actually work. My experiences with NFS would lead me to believe that this would not help and could hurt the performance of existing MySQL server even more. My use has been limited to a file server for our web nodes, so, this is a bit different. Let us know if you try it and how it turns out. - Original Message - From: Luis Calero [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 20, 2002 5:39 AM Subject: MySQL over NFS | | Hi... I've got the folowing question, our servers are running pretty | busy these days and our main DB server is taking high load peaks (memory | is OK but the cpu has almost no idle time). We have another spare server | and I'm thinking about mounting the database over NFS (100mb LAN) to the | spare server and using both as frontends to the DB. Both servers are | supposed to do reads and updates to the DB, but i'm concerned with the | updates of the server using NFS. | | Are NFS locks safe enough to run this kind of setup? Is this going to be | an advantage or will suffer from other kinds of problems? Both boxes are | PIII dual 1Ghz / 1Gb ram, Linux 2.4.16, MySQL 3.23.52 | | Thanx | | -- | L | | | - | Before posting, please check: |http://www.mysql.com/manual.php (the manual) |http://lists.mysql.com/ (the list archive) | | 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 over NFS
Also, what we have done is used a replicating box as a select only server. This requires you to write your code in such a way that only selects get sent to the slave. A simple function wrapper in PHP is all we needed. Brian. - Original Message - From: Brian Moon [EMAIL PROTECTED] To: Luis Calero [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, August 20, 2002 8:07 AM Subject: Re: MySQL over NFS | This is an interesting idea. I would be a happy man if it would actually | work. My experiences with NFS would lead me to believe that this would not | help and could hurt the performance of existing MySQL server even more. My | use has been limited to a file server for our web nodes, so, this is a bit | different. | | Let us know if you try it and how it turns out. | | - Original Message - | From: Luis Calero [EMAIL PROTECTED] | To: [EMAIL PROTECTED] | Sent: Tuesday, August 20, 2002 5:39 AM | Subject: MySQL over NFS | | | | | | Hi... I've got the folowing question, our servers are running pretty | | busy these days and our main DB server is taking high load peaks (memory | | is OK but the cpu has almost no idle time). We have another spare server | | and I'm thinking about mounting the database over NFS (100mb LAN) to the | | spare server and using both as frontends to the DB. Both servers are | | supposed to do reads and updates to the DB, but i'm concerned with the | | updates of the server using NFS. | | | | Are NFS locks safe enough to run this kind of setup? Is this going to be | | an advantage or will suffer from other kinds of problems? Both boxes are | | PIII dual 1Ghz / 1Gb ram, Linux 2.4.16, MySQL 3.23.52 | | | | Thanx | | | | -- | | L | | | | | | - | | Before posting, please check: | |http://www.mysql.com/manual.php (the manual) | |http://lists.mysql.com/ (the list archive) | | | | 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: Utility for importing Paradox tables to MYSQL
On Tuesday 20 August 2002 05:52 am, Nick Lazidis wrote: Its relatively straightforward to do it with a perl script. Just set up an ODBC data source to the Paradox database and install perl DBI and the DBD::ODBC and DBD::MySQL drivers. Then you can simply read records from Paradox via ODBC and write them to your MySQL database. Naturally you can also do some conversions along the way if you like. There are other ways of course, but I've always found this to be one of the easiest ways. Hi, I wonder if there is a utility for transferring Paradox tables to MySQL. Nickos - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: max_allowed_packet (was: Re: 4.0.x bug with LONGTEXT?)
-Original Message- From: Roger Baklund [mailto:[EMAIL PROTECTED]] * Harald Fuchs In article [EMAIL PROTECTED], Victoria Reznichenko [EMAIL PROTECTED] writes: As you can see txt1 and txt2 contain text file ~ 8M UPDATE tbl1 SET total=CONCAT(txt1,txt2) WHERE id=1; SELECT id, LENGTH(txt1), LENGTH(txt2), LENGTH(total) FROM tbl1; ++--+--+---+ | id | LENGTH(txt1) | LENGTH(txt2) | LENGTH(total) | ++--+--+---+ | 1 | 8390060 | 8390060 | 0 | ++--+--+---+ The same result. MySQL inserts NULL in the total, because you can't store data more than max_allowed_packet. Thanks for the clarification, Victoria. I'm sorry, but this is not very clear to me... The manual describes max_allowed_packet as Max packetlength to send/receive from to server. Why are the columns transferred between server/client in the above statement? Shouldn't the entire UPDATE happen on the server side? It probably does happen on the server side. But wouldn't it be smart to limit itself to something it knows it can't transfer later? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 over NFS
Isn't that what the MySQL-Replication is for? Thomas On Tue, 20 Aug 2002 08:07:24 -0500 Brian Moon [EMAIL PROTECTED] wrote: This is an interesting idea. I would be a happy man if it would actually work. My experiences with NFS would lead me to believe that this would not help and could hurt the performance of existing MySQL server even more. My use has been limited to a file server for our web nodes, so, this is a bit different. Let us know if you try it and how it turns out. - Original Message - From: Luis Calero [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 20, 2002 5:39 AM Subject: MySQL over NFS | | Hi... I've got the folowing question, our servers are running pretty | busy these days and our main DB server is taking high load peaks (memory | is OK but the cpu has almost no idle time). We have another spare server | and I'm thinking about mounting the database over NFS (100mb LAN) to the | spare server and using both as frontends to the DB. Both servers are | supposed to do reads and updates to the DB, but i'm concerned with the | updates of the server using NFS. | | Are NFS locks safe enough to run this kind of setup? Is this going to be | an advantage or will suffer from other kinds of problems? Both boxes are | PIII dual 1Ghz / 1Gb ram, Linux 2.4.16, MySQL 3.23.52 | | Thanx | | -- | L | | | - | Before posting, please check: |http://www.mysql.com/manual.php (the manual) |http://lists.mysql.com/ (the list archive) | | 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: Utility for importing Paradox tables to MYSQL
Hi Nick, If you don't mind about the OS, yes there is. DBTools can handle Access, ODBC, Excel, Paradox, FoxPro, ClipperDBase. You can get it from http://www.dbtools.com.br. []s Crercio - Original Message - From: Nick Lazidis [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 20, 2002 6:52 AM Subject: Utility for importing Paradox tables to MYSQL Hi, I wonder if there is a utility for transferring Paradox tables to MySQL. Nickos - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Count(*) using a join?
On Monday 19 August 2002 09:12 pm, Jocelyn Fournier wrote: except, leave off the 'f.' on 'f.count(*)'. Remember there is only one count of records, the count of returned rows from the join, there is no need to qualify that with a table identifier... (and I think it would be a syntax error if you do). Also, about the GROUP BY. If you have the group by, then you will have only one record in your result set for each unique s.name, and your count(*) will return the number of times each s.name appears in table s. Table f won't really do much, except that any row in s that doesn't have a match of its id column with a row in table f will simply not appear at all. My suspicion is that you're wanting to know how many times there is an f with a given id for each unique value of s.name. That is a tough one Really you will have to group on some other value in f which is unique to each row in f. So you could then have something like. SELECT COUNT(*) AS fcount, s.name, f.unique, WHERE f.id = s.id GROUP BY s.name, f.unique and I believe that would accomplish what you want (though you will end up with a row in your result you don't really care about, but at least the count is there). Hi, Try: SELECT f.count(*), s.name FROM first f,second s WHERE f.id = s.id GROUP BY s.name; Regards, Jocelyn - Original Message - From: Mark S Lowe [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 20, 2002 3:02 AM Subject: Count(*) using a join? I need to do a join with a count...but for some reason I can¹t figure out how to do it using MySQL. I¹m hoping that this pseudo code can help you give me an answer: select f.count(*), s.name from first f, second s where f.id = s.id How do I get a sql result like: CountName --- 12343Test I¹ve attempting adding the group by function as documented, but MySQL has some demands I don¹t understand. Thank you in advance! Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 over NFS
Also, what we have done is used a replicating box as a select only server. This requires you to write your code in such a way that only selects get sent to the slave. A simple function wrapper in PHP is all we needed. I've been thinking of this idea too but it's a bit of a problem because we open one connection for every page request and it makes from 10 to 100 querys (selects and updates). So it would be either opening and closing the connection for each query (not good I guess) or opening two connections, one to each server, at the beginning and then randomly serving them to both boxes if they're selects or to one of them if they're updates. Anyway if anyone has more insights about this I'd love to hear them. Cheers. -- L - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 share a MyISAM table among different databases
Tod, thanks for your input, I cannot find this requirement in my help-file for MySQL 3.23.45. I think, it appears in MySQL 4 Anyway, in MySQL 4, one can symlink tables, as described in chapter 5.6.1.2 Using Symbolic Links for Tables Well, well, probably old-fasionated way to acces through DB prefix is the only choice... Thanks again, Dmitry. - Original Message - From: Tod Harter [EMAIL PROTECTED] To: Sergei Golubchik [EMAIL PROTECTED]; Dmitry Kuznetsov [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, August 20, 2002 3:19 PM Subject: Re: How to share a MyISAM table among different databases On Tuesday 20 August 2002 06:27 am, Sergei Golubchik wrote: The key quote from the manual is... All used tables must be in the same database as the MERGE table itself. which makes sense. Fundamentally a database is an independent unit of data storage. You can't share data between two seperate databases. I know some systems approach this differently, but that seems to be the philosophy in MySQL, and getting away from that would pretty much throw the grant system out the window. Hi! On Aug 20, Dmitry Kuznetsov wrote: Hi, Sergey! As stated in description: A MERGE table is a collection of identical MyISAM tables that can be used as one. , i.e. content of these tables, being merged, is merged also. I need the opposite - one physical table being represented in multiple DBs as if these replicas are regular tables. Well, a collection can consist of only one table :) So, you create a MERGE table that merges the table you want to alias, and put this MERGE table in whatever database you want. Then, edit .MRG file to add a proper path there. Voila. Regards, Sergei - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 create a sequence for an id field
Brian, Monday, August 19, 2002, 11:48:16 PM, you wrote: BJ I have a SQL statement to create a PostgreSQL table that include a line 'id serial' BJ This line creates a integer field with a sequence atached to it to create an autonumber In MySQL you can use AUTO_INCREMENT: http://www.mysql.com/doc/en/example-AUTO_INCREMENT.html BJ Is there a way to create a SQL statement to accomplish this that would work with BJ both MySQL and PostgreSQL I don't know PostgreSQL, but you can retrieve maximum value with MAX() function and and then insert MAX()+1 value. Don't forget to lock table. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [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: Transaction Question
Randy, Tuesday, August 20, 2002, 8:51:36 AM, you wrote: RJ Here is an insert from the innodb reference manual [skip] RJ The solution is to perform the SELECT in a locking mode, LOCK IN SHARE MODE. RJ SELECT * FROM PARENT WHERE NAME = 'Jones' LOCK IN SHARE MODE; [skip] RJ This means that if we update a record and have not committed it and another RJ user uses the above select statement, it will wait until the first update RJ statement is committed before reading Yes. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita 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: Too many connections
Mansoor, Tuesday, August 20, 2002, 4:55:28 PM, you wrote: MA We are facing a problem related to mysql connections. MA The error saying that:- MA TOO MANY CONECTONS OPEN: MA Mysql server max_connections variable is currently set to 100, MA please tell me how i can change the max_connections value. You can specify value in the my.cnf file [mysqld] set-variable=max_connections=# or run mysqld with -O max_connections=# -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [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: Re: Transaction Question
Randy, Monday, August 19, 2002, 7:29:43 PM, you wrote: RJ Thanks for your reply, is it documented somewhere? That COMMIT and ROLLBACK release locks? Of course, look at: http://www.mysql.com/doc/en/InnoDB_transaction_model.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita 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: Problem with mysql making my server extremly slow
Magnet, Monday, August 19, 2002, 11:11:38 PM, you wrote: M I manage a web server having a lot of http connections, using M Apache/PHP/MySQL. When there are too many simultaneous connections (so, many M MySQL requests), MySQL stops working efficiently and makes my load average M increase a LOT (already seen it at 100 !). The only way to make it decrease M is to stop MySQL (I am forced to killall -9 mysqld, since it's the faster M way and I hardly can do much on the shell while the load is so high). M I am using MySQL server 3.53.52 (last stable), and it's working perfectly M when there is not too many SQL requests... but since it's a large website, M the problem happens each day at 9pm and we just cannot go on like this. M As the dedicated server (Linux Red Hat 7.2) is provided by a webhosting M company, MySQL was already installed when I got root access (although it was M 3.53.51), and I didn't change the my.cnf file (well, I tried but it wasn't M working anymore...). Here is my my.cnf file : M [magnet@ns3286 dev]$ cat /etc/my.cnf M [mysqld] M set-variable = connect_timeout=20 M set-variable = max_connections=100 M [magnet@ns3286 dev]$ M (yes I know it's short, tried to put a basic one but my tables weren't M read anymore...). M Well, I guess my problem is quite common, even if I didn't find any way to M fix it on the MySQL website! I'm sure there are some MySQL experts around M there able to help me without telling me to RTFM, since I did so (or tried, M since IMHO this manual is far from ergonomic). If someone is willing to help M me, and needs some information not listed there, just ask me, I will answer M asap... Can you send a list of processes? (mysqladmin processlist) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita 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: Too many connections
Hello, Edit your my.cnf and add the following line in the [mysqld] section: set-variable = max_connections=500 or set it to anything you need. Regards, Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** On Tue, 20 Aug 2002, Mansoor Alam wrote: Dear Sir, We are facing a problem related to mysql connections. The error saying that:- TOO MANY CONECTONS OPEN: Mysql server max_connections variable is currently set to 100, please tell me how i can change the max_connections value. Thank you, Mansoor Alam. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Utility for importing Paradox tables to MYSQL
Hi Not sure if this is simpler or not but.. install MyODBC, set up a Paradox alias for your MySql database Using Paradox, copy the paradox tables to the MySql database. This converts all the field types and copies the data over. I am not sure if it will do memo fields it may depend on the version of MyODBC and Paradox. HTH Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net tel. 0121-242-1473 --- -Original Message- From: Crercio O. Silva [mailto:[EMAIL PROTECTED]] Sent: 20 August 2002 13:17 To: [EMAIL PROTECTED] Subject: Re: Utility for importing Paradox tables to MYSQL Hi Nick, If you don't mind about the OS, yes there is. DBTools can handle Access, ODBC, Excel, Paradox, FoxPro, ClipperDBase. You can get it from http://www.dbtools.com.br. []s Crercio - Original Message - From: Nick Lazidis [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 20, 2002 6:52 AM Subject: Utility for importing Paradox tables to MYSQL Hi, I wonder if there is a utility for transferring Paradox tables to MySQL. Nickos - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
BDE Error
hi, i use delphi, myodbc and mysql(myisam tables) when i select large query ( approximately 2000 records) then my program alert BDE Error $000F , it is memory error ok, but i could not its solutions - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: temp tables
Ta, But is it normal to have Temp table bigger than 10meg? And a lot of them? Here is my latest data from STATUS Created_tmp_disk_tables 46598 Created_tmp_tables 87839 Uptime 81773 And I have set tmp_table_cache to 10M I know I could just up the tmp_table_size but I am more concerned about the size of the tmp tables and the number of them. I am running an in house build CMS and running phorum. I get about 100,000 page views an hour. John - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 20, 2002 3:06 PM Subject: Re: temp tables John, Tuesday, August 20, 2002, 11:55:55 AM, you wrote: JW MySQL is creating about 50% of temp tables on disk and this is with 10Meg of JW temp table cache. Is this normal? and sould I up temp table cache further. Yes it's normal. Since 3.23 MySQL autommatically converts temporary tables to disk-based when size of temporarty table is bigger than tmp_table_size: http://www.mysql.com/doc/en/Full_table.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [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 over NFS
We use a class for all our MySQL stuff that has some error stuff and commonly used function combinations (like do a query then do a numrows). In that we create a connection only when the query method is called. So, until a query is run, no connection is made. If the update server name does not equal the select server name we make two connections. The load saved on the main server is well worth the connection. MySQL is pretty fast with connections compared to other DBMS I have used. Brian. - Original Message - From: [EMAIL PROTECTED] To: Brian Moon [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, August 20, 2002 8:57 AM Subject: Re: MySQL over NFS | | Also, what we have done is used a replicating box as a select only server. | This requires you to write your code in such a way that only selects get | sent to the slave. A simple function wrapper in PHP is all we needed. | | I've been thinking of this idea too but it's a bit of a problem because | we open one connection for every page request and it makes from 10 to 100 | querys (selects and updates). So it would be either opening and closing | the connection for each query (not good I guess) or opening two | connections, one to each server, at the beginning and then randomly | serving them to both boxes if they're selects or to one of them if they're | updates. | | Anyway if anyone has more insights about this I'd love to hear them. | | Cheers. | | -- | L | | | | - | Before posting, please check: |http://www.mysql.com/manual.php (the manual) |http://lists.mysql.com/ (the list archive) | | 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: max_allowed_packet (was: Re: 4.0.x bug with LONGTEXT?)
* Luc Foisy -Original Message- From: Roger Baklund [mailto:[EMAIL PROTECTED]] * Harald Fuchs In article [EMAIL PROTECTED], Victoria Reznichenko [EMAIL PROTECTED] writes: As you can see txt1 and txt2 contain text file ~ 8M UPDATE tbl1 SET total=CONCAT(txt1,txt2) WHERE id=1; SELECT id, LENGTH(txt1), LENGTH(txt2), LENGTH(total) FROM tbl1; ++--+--+---+ | id | LENGTH(txt1) | LENGTH(txt2) | LENGTH(total) | ++--+--+---+ | 1 | 8390060 | 8390060 | 0 | ++--+--+---+ The same result. MySQL inserts NULL in the total, because you can't store data more than max_allowed_packet. Thanks for the clarification, Victoria. I'm sorry, but this is not very clear to me... The manual describes max_allowed_packet as Max packetlength to send/receive from to server. Why are the columns transferred between server/client in the above statement? Shouldn't the entire UPDATE happen on the server side? It probably does happen on the server side. But wouldn't it be smart to limit itself to something it knows it can't transfer later? Maybe... :) On the other hand: 1) The documentation on max_allowed_packet talks only about transferring data, not storing. (This should be easy to fix.) 2) The mere existence of LONGBLOB and LONGTEXT suggests that fields of this size could be inserted in a table. Again, a warning in the docs could be very helpfull, but imo the types should not even be there, if they can not be utilized. 3) How can the server know that the max_allowed_packet for _this_ connection (the UPDATE'ing connection) isn't smaller than the max_allowed_packet value for a future SELECT connection? (I could do the UPDATE ... CONCAT(... with max_allowed_packet=1M, and later do selects with max_allowed_packet=16M) 4) We can of course insert more rows in a table than would be allowed to receive with a single select statement, this is not an argument to prohibit many _rows_ in a table. It's not the exact same thing, but I think it is similar. I would prefer if mysql was not 'baby-sitting' for me... :) 5) It could be usefull in some cases, for instance when you store large xml documents, you can extract relevant parts of the column, so that the packet transferred to the client is smaller than max_allowed_packet. The upper limit for max_allowed_packet has been lifted in 4.0.x, so this will probably not be a problem in the future, but the docs should mention this limitation for 3.23. -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 tutorials, users passwords, interface.
Actually... Jay Greenspan's MYSQL Weekend Crash Course is a very quick read and has NT instructions in it. It is limited in its functionality, but if you are used to MS SQL Enterprise Manager, MyCC will be a quick learn for you. The Windows version installs quickly and work reasonably well. John Gruber -Original Message- From: Gavin Alexander [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 6:03 PM To: [EMAIL PROTECTED] Subject: MySQL tutorials, users passwords, interface. HI, I am just starting out with MySQL, using Tomcat as standalone on a Win2000 machine and java servlets. Could anybody: 1) Recomend a good book which covers the basics of MySQL, /or any good tutorials on the web? 2) Tell me how to set up usernames and passwords for MySQL. 3) Recomend an easy to use interface for MySQL (can I use phpMyAdmin if I'm not using PHP?). Many thanks, Gavin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: No reply from partner@mysql.com
Ady, Tuesday, August 20, 2002, 12:11:03 PM, you wrote: AW Hi All, i've sent a letter to [EMAIL PROTECTED] but until now it still no answer. AW Actually it's an active email address or not ? AW Please give me better suggestion, because i love this MySQL products and i want to make a partnership with them You can also write to [EMAIL PROTECTED] -- For technical support contracts, goto https://order.mysql.com/?ref=ensita 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
strange error in InnoDB on raw disk
I created 4096M raw InnoDB space -- all was fine. Right after this I tried to create some type=InnoDB table. It fails with the message can't create table './db/tbl.frm' (errno=133). After I change newraw to raw in my.cnf and restart MySQL it works fine. Not a big problem for me but maybe it indicates some internal problem? I think it should have worked fine on the first run. FreeBSD-5.0-CURRENT, MySQL 3.23.51. Yuri. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
encrypted data ?
Hi, all I need help on this. I'm testing mysql. I did a very simple table and I'm writing a C++ application to read data from it. The connection/authentication/query part of the application seems to work fine. However, the text data I'm getting from the database seems encrypted by some simple algorithm. If I see the data from mysql console, I get it right. But if I read from my application and place it to the console, I get it encrypted, like shown below. (in mysql) = (read from application) Rio = 53722e Rio2 = 53722e32 Rio3 = 53722e33 I suspect that there's some kind of command that if placed at mysql console should solve the problem. Any help will be appreciated (to me or to this list). - +--+ Sergio Barbosa Villas-Boas /--/| [EMAIL PROTECTED] | sbVB |/ http://www.del.ufrj.br/~villas +--+ ICQ: 15360729 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: strange error in InnoDB on raw disk
in a innodb table type using mysql max is a begin statement the same as set autocommitt = 0?? Randy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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.2 problems
Heh...ya I knew I fogot to do something. You would think that would be an install step. Next task is recompilling the apache httpd as it doesnt like not having the libmysqlcleint.so.10 file which is now libmysqlcleint.so.11 thx for the tip. =D -Nick louie miranda said: Add the mysql lib path on /etc/ld.so.conf and type ldconfig. :) = Thanks, Louie Miranda... WebUrl: http://axis0.endofinternet.org Email: [EMAIL PROTECTED] - [EMAIL PROTECTED] - Original Message - From: Nick Stuart [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 20, 2002 12:23 PM Subject: mysql 4.0.2 problems Ok I got mysql 4.0.2 installed on Mandrake and its up and running. My problem is that when I go to connect to it I get the error: error while loading shared libraries: libmysqlclient.so.11: cannot open shared object file: No such file or directory Actually (just fixed it). All I had to do was and a soft link the the /lib directory. Anyone know if this is normal or not? -Nick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: strange error in InnoDB on raw disk
is a begin statement the same as set autocommitt = 0?? Nope, I didn't change autocommit. Yuri. FOR FILTER: sql, connect - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 tutorials, users passwords, interface.
Filter fodder: mysql, query Hi, I think the O'Reilly books - Managing and Using MySQL - MySQL and mSQL and _very_ good. and if you want a real tome, then try - Mastering SQL, by Martin Gruber, pub. by SYBEX Donna On Tuesday 20 August 2002 3:40 pm, John Gruber wrote: Actually... Jay Greenspan's MYSQL Weekend Crash Course is a very quick read and has NT instructions in it. It is limited in its functionality, but if you are used to MS SQL Enterprise Manager, MyCC will be a quick learn for you. The Windows version installs quickly and work reasonably well. John Gruber -Original Message- From: Gavin Alexander [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 6:03 PM To: [EMAIL PROTECTED] Subject: MySQL tutorials, users passwords, interface. HI, I am just starting out with MySQL, using Tomcat as standalone on a Win2000 machine and java servlets. Could anybody: 1) Recomend a good book which covers the basics of MySQL, /or any good tutorials on the web? 2) Tell me how to set up usernames and passwords for MySQL. 3) Recomend an easy to use interface for MySQL (can I use phpMyAdmin if I'm not using PHP?). Many thanks, Gavin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
using MYSQL++ API problem
hello i have just insalled mysql++ API and I am trying to run Example Program I am gettin error : undefined reference to MysqlConnection::~MysqlConnection(void) -I am a newbie in C stuff particularly on linux platform,please help me to solve this problem I am using Redhat7,2 and gcc version 2.9.x the command line which I am using is gcc -L /usr/lib/mysql mysql.cpp thanx for any help -Adnan _ Play the Elvis® Scratch Win for your chance to instantly win $10,000 Cash - a 2003 Harley Davidson® Sportster® - 1 of 25,000 CD's - and more! http://r.lycos.com/r/sagel_mail/_scratch_tl/http://win.ipromotions.com/lycos_020801/index.asp?tc=7087 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
replication problem
Hello, I have two machines that I am trying to use replication on. Here are their configurations: master (my.cnf) log-bin serveri-d = 1 slave: server-id = 2 master-host=master.domain.com master-user=replicate master-password=replicatedb log-bin I followed the steps in the manual but found this error on my slave logs: 020820 13:24:52 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'FIRST' at position 4 020820 13:24:52 Error updating slave list: 020820 13:24:52 Slave I/O thread exiting, read up to log 'FIRST', position 4 What does this mean? Whenever I make changes to the master, the Position changes: mysql show master status; ++--+--+--+ | File | Position | Binlog_do_db | Binlog_ignore_db | ++--+--+--+ | master-bin.002 | 208 | | | ++--+--+--+ but doesn't reflect on the slave: mysql show master status; ++--+--+--+ | File | Position | Binlog_do_db | Binlog_ignore_db | ++--+--+--+ | slave-bin.002 | 79 | | | ++--+--+--+ Should the files be the same for both master and slave? Here are other things that might help: (slave) mysql show processlist; | 2 | system user | none | NULL | Connect | 1945 | Slave: waiting for binlog update | NULL | mysql show slave status; | master.domain.com | replicate | 3306| 60| | 4 | slave-relay-bin.002 | 4 | | No | Yes | | | 0 || 0| 0 | 4 | Any tips/advice? TIA! Froilan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 creating views......
I am new to this group. I am part of a small website dev shop and we just started using MySQL. I was tasked with the following: Write a perl script(did this part) to open up the MySQL database and create a View (a temp table) from 3 different tables. I thought no problem I know how to do this I do this in Oracle all the time. BEEP! wrong thought. The docs say, no can do especially with TEXT or BLOB datatypes. Does anyone have any ideas on what I can do? The client needs a temp table to be created with data from 3 different tables for info purposes. They just want to do a select on the table to see what they want to see. All help will be welcome. Thank you all in advanceLupita __ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.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
innob question
in a innodb table type using mysql max is a begin statement the same as set autocommitt = 0?? Randy sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: encrypted data ?
You are displaying your strings in hexadecimal format. Sergio Barbosa Villas-Boas wrote: Hi, all I need help on this. I'm testing mysql. I did a very simple table and I'm writing a C++ application to read data from it. The connection/authentication/query part of the application seems to work fine. However, the text data I'm getting from the database seems encrypted by some simple algorithm. If I see the data from mysql console, I get it right. But if I read from my application and place it to the console, I get it encrypted, like shown below. (in mysql) = (read from application) Rio = 53722e Rio2 = 53722e32 Rio3 = 53722e33 I suspect that there's some kind of command that if placed at mysql console should solve the problem. Any help will be appreciated (to me or to this list). - +--+ Sergio Barbosa Villas-Boas /--/| [EMAIL PROTECTED] | sbVB |/ http://www.del.ufrj.br/~villas +--+ ICQ: 15360729 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
ordering by frequency
I have a simple query that I must have framed incorrectly, because MySQL returns an error: SELECT c.customerID,CONCAT(...) as Cust FROM customers c,invoice i WHERE c.customerID = i.customerID ORDER BY COUNT(i.customerID) LIMIT 0,10; This tells me ERROR : Invalid use of group function How can I get the ordering that I want? My goal is to select my ten most frequent customers. I tried adding the COUNT() clause into the column list, but then MySQL wanted a GROUP BY clause. When I added a group by clause, I couldn't keep the ORDER BY clause... Can anyone help? Thanks, this is much appreciated, since I know I have a pretty simple problem. Quinten - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
web application test tool
Hi, I have completed a web-based application using java servlet with mysql as the backend database and tomcat as the server. I try to test my application performance using a free test tool. i found one called Microsoft Web Application Stress tool) it is free. but it's test script is used by AsP. I am not quite sure if there is any web test tool using java servlet? Thank you bin __ Post your ad for free now! http://personals.yahoo.ca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 creating views......
Do you need to create a temp table or a heap table? Temp tables support those columns fine. Heap tables do not. Brian. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 20, 2002 11:44 AM Subject: MySQL and creating views.. | I am new to this group. I am part of a small website dev shop and we just started using MySQL. I was tasked with the following: | Write a perl script(did this part) to open up the MySQL database and create a View (a temp table) from 3 different tables. I thought no problem I know how to do this I do this in Oracle all the time. BEEP! wrong thought. The docs say, no can do especially with TEXT or BLOB datatypes. Does anyone have any ideas on what I can do? The client needs a temp table to be created with data from 3 different tables for info purposes. They just want to do a select on the table to see what they want to see. | All help will be welcome. Thank you all in advanceLupita | | | __ | Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ | | Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.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: replication problem
Froilan Mendoza wrote: Hello, I have two machines that I am trying to use replication on. Here are their configurations: master (my.cnf) log-bin serveri-d = 1 slave: server-id = 2 master-host=master.domain.com master-user=replicate master-password=replicatedb log-bin I followed the steps in the manual but found this error on my slave logs: 020820 13:24:52 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'FIRST' at position 4 020820 13:24:52 Error updating slave list: 020820 13:24:52 Slave I/O thread exiting, read up to log 'FIRST', position 4 What does this mean? Whenever I make changes to the master, the Position changes: mysql show master status; ++--+--+--+ | File | Position | Binlog_do_db | Binlog_ignore_db | ++--+--+--+ | master-bin.002 | 208 | | | ++--+--+--+ but doesn't reflect on the slave: mysql show master status; ++--+--+--+ | File | Position | Binlog_do_db | Binlog_ignore_db | ++--+--+--+ | slave-bin.002 | 79 | | | ++--+--+--+ Should the files be the same for both master and slave? Here are other things that might help: (slave) mysql show processlist; | 2 | system user | none | NULL | Connect | 1945 | Slave: waiting for binlog update | NULL | mysql show slave status; | master.domain.com | replicate | 3306| 60| | 4 | slave-relay-bin.002 | 4 | | No | Yes | | | 0 || 0| 0 | 4 | Any tips/advice? TIA! Froilan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php on the slave you should run show slave status also on the slave check /path/to/mysql/master.info this file gives you good info and I had to change it manually when I changed master server names in the my.cnf file also, add set-variable = slave_net_timeout=3600 set-variable = net_read_timeout=3600 in the my.cnf on the slave to keep it from fillng the log with junk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: ordering by frequency
SELECT c.customerID,CONCAT(...) ,COUNT(i.customerID) as Num FROM customers c,invoice i WHERE c.customerID = i.customerID GROUP BY c.customerID ORDER BY Num DESC LIMIT 0,10 ; Sorry, solved my own difficulty. On Tue, 20 Aug 2002, Quinten Steenhuis wrote: Date: Tue, 20 Aug 2002 13:01:17 -0400 (EDT) From: Quinten Steenhuis [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: ordering by frequency I have a simple query that I must have framed incorrectly, because MySQL returns an error: SELECT c.customerID,CONCAT(...) as Cust FROM customers c,invoice i WHERE c.customerID = i.customerID ORDER BY COUNT(i.customerID) LIMIT 0,10; This tells me ERROR : Invalid use of group function How can I get the ordering that I want? My goal is to select my ten most frequent customers. I tried adding the COUNT() clause into the column list, but then MySQL wanted a GROUP BY clause. When I added a group by clause, I couldn't keep the ORDER BY clause... Can anyone help? Thanks, this is much appreciated, since I know I have a pretty simple problem. Quinten - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Transaction Question CONFUSED
I am confused. (innodb table type) Client 1. starts transaction selects balance from table where id=1 for update update table set balance=100 #At this point from what i have read the balance could be selected by anther user. committ I have read that a select balance from table where id=1 lock in share mode will wait for the committ statement, but client 2 would be wanting to update the balance the same way client 1 does sO i do not see how client 2 could use the lock in share mode because the script is the same for client 2 as it is in client one. so how would i ensure that client 2 waits for client 1 to committ before processing their select and update? Randy sql,quary - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 creating views......
Thanks Brian. But another question is, I looked up CREATE TEMPORARY TABLE What I want to know is can I do the following: create temporary table (select [distinct] jump.name, jump.address, bike.city, bike.state, skate.zipcode, skate.car, skate.name, skate.city from jump, bike inner join skate on jump.name=skate.name where bike.city=skate.city and jump.name=skate.name and (skate.car0) order by skate.name; ? This is the type of query that I have to excute to create the temp table. The client wants much info combined into one table. Thanks. If anyone has any other ideas I'm listening!! THANKS for all your help and suggestions. --Lupita Brian Moon [EMAIL PROTECTED] wrote: Do you need to create a temp table or a heap table? Temp tables support those columns fine. Heap tables do not. Brian. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 20, 2002 11:44 AM Subject: MySQL and creating views.. | I am new to this group. I am part of a small website dev shop and we just started using MySQL. I was tasked with the following: | Write a perl script(did this part) to open up the MySQL database and create a View (a temp table) from 3 different tables. I thought no problem I know how to do this I do this in Oracle all the time. BEEP! wrong thought. The docs say, no can do especially with TEXT or BLOB datatypes. Does anyone have any ideas on what I can do? The client needs a temp table to be created with data from 3 different tables for info purposes. They just want to do a select on the table to see what they want to see. | All help will be welcome. Thank you all in advanceLupita | | | __ | Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ | | Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.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 | | __ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.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: MySQL and creating views......
That should work just fine. Brian. - Original Message - From: [EMAIL PROTECTED] To: Brian Moon [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, August 20, 2002 12:51 PM Subject: Re: MySQL and creating views.. | Thanks Brian. But another question is, I looked up CREATE TEMPORARY TABLE | What I want to know is can I do the following: | | create temporary table (select [distinct] jump.name, jump.address, |bike.city, bike.state, skate.zipcode, skate.car, skate.name, skate.city |from jump, bike inner join skate on jump.name=skate.name where | bike.city=skate.city and jump.name=skate.name and (skate.car0) | order by skate.name; | ? | This is the type of query that I have to excute to create the temp table. The client wants much info combined into one table. Thanks. | If anyone has any other ideas I'm listening!! | | THANKS for all your help and suggestions. | --Lupita | | Brian Moon [EMAIL PROTECTED] wrote: | | Do you need to create a temp table or a heap table? Temp tables support | those columns fine. Heap tables do not. | | Brian. | | - Original Message - | From: [EMAIL PROTECTED] | To: [EMAIL PROTECTED] | Sent: Tuesday, August 20, 2002 11:44 AM | Subject: MySQL and creating views.. | | | | I am new to this group. I am part of a small website dev shop and we just | started using MySQL. I was tasked with the following: | | Write a perl script(did this part) to open up the MySQL database and | create a View (a temp table) from 3 different tables. I thought no problem I | know how to do this I do this in Oracle all the time. BEEP! wrong thought. | The docs say, no can do especially with TEXT or BLOB datatypes. Does anyone | have any ideas on what I can do? The client needs a temp table to be created | with data from 3 different tables for info purposes. They just want to do a | select on the table to see what they want to see. | | All help will be welcome. Thank you all in advanceLupita | | | | | | __ | | Your favorite stores, helpful shopping tools and great gift ideas. | Experience the convenience of buying online with Shop@Netscape! | http://shopnow.netscape.com/ | | | | Get your own FREE, personal Netscape Mail account today at | http://webmail.netscape.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 | | | | | | | | | __ | Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ | | Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.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: MySQL and creating views......
Oh, but the caveat for this is that the table will be destoyed when the connection is closed. So, if you need this to hang around, you will just need to create another table with this data, or just use that join in your query. Brian. - Original Message - From: [EMAIL PROTECTED] To: Brian Moon [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, August 20, 2002 12:51 PM Subject: Re: MySQL and creating views.. | Thanks Brian. But another question is, I looked up CREATE TEMPORARY TABLE | What I want to know is can I do the following: | | create temporary table (select [distinct] jump.name, jump.address, |bike.city, bike.state, skate.zipcode, skate.car, skate.name, skate.city |from jump, bike inner join skate on jump.name=skate.name where | bike.city=skate.city and jump.name=skate.name and (skate.car0) | order by skate.name; | ? | This is the type of query that I have to excute to create the temp table. The client wants much info combined into one table. Thanks. | If anyone has any other ideas I'm listening!! | | THANKS for all your help and suggestions. | --Lupita | | Brian Moon [EMAIL PROTECTED] wrote: | | Do you need to create a temp table or a heap table? Temp tables support | those columns fine. Heap tables do not. | | Brian. | | - Original Message - | From: [EMAIL PROTECTED] | To: [EMAIL PROTECTED] | Sent: Tuesday, August 20, 2002 11:44 AM | Subject: MySQL and creating views.. | | | | I am new to this group. I am part of a small website dev shop and we just | started using MySQL. I was tasked with the following: | | Write a perl script(did this part) to open up the MySQL database and | create a View (a temp table) from 3 different tables. I thought no problem I | know how to do this I do this in Oracle all the time. BEEP! wrong thought. | The docs say, no can do especially with TEXT or BLOB datatypes. Does anyone | have any ideas on what I can do? The client needs a temp table to be created | with data from 3 different tables for info purposes. They just want to do a | select on the table to see what they want to see. | | All help will be welcome. Thank you all in advanceLupita | | | | | | __ | | Your favorite stores, helpful shopping tools and great gift ideas. | Experience the convenience of buying online with Shop@Netscape! | http://shopnow.netscape.com/ | | | | Get your own FREE, personal Netscape Mail account today at | http://webmail.netscape.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 | | | | | | | | | __ | Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ | | Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.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: MIN/MAX( IF( ...) ) problems: min bigger than max
Is it fixed only in MySQL 4.x, or will it be in the next point release of 3.x as well? Cheers, Rich -Original Message- Thanks for bug report! If NULL is present (t_calllog_calls.call_end - t_calllog_calls.call_start 5) the result_type is changed from int to char. It was fixed. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Suggestion on New MySQL Function
Through your MySQL documentation, I wasn't able to find a function that I think could be useful. If you DELETE a row with an INT AUTO_INCREMENT field, it will still be able to add the next highest value to this column on an INSERT (ex. If after INSERTing rows, you DELETE a row with a value of five in its INT AUTO_INCREMENT column and the highest value for this particular INT column is currently six, your next INSERTed row will have a value of seven). This is very troubling for me, since at some point this INT will reach it's limit with 'holes' within the table. I think a function to find the lowest hole in a specified table would be a useful addition to further upgrades. Thank you for your time and patience. Sincerely, Trash Phantom - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 share a MyISAM table among different databases
Hi. On Tue 2002-08-20 at 10:58:53 +0200, [EMAIL PROTECTED] wrote: As stated in description: A MERGE table is a collection of identical MyISAM tables that can be used as one. , i.e. content of these tables, being merged, is merged also. I need the opposite - one physical table being represented in multiple DBs as if these replicas are regular tables. But you can have that with MERGE tables: Make them merge only one table, e.g. create the real table in a separate database, and in each other database, create a merge table over it, so you effectively get a live copy. Although, one may have one master table (with master contents), and empty tables with the same structure in other DBs. Such an empty table might be merged over the master table. Yes. Hm. I am not sure if I can follow... I do not see the need or use of empty tables in the context. Regards, Benjamin. -- [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
Error compiling mysql-3.23.51 on Solaris 9 sparc
I am trying to install MYSQL on Solaris 9 sparc edition. I am using the following options: CFLAGS=-O3 -mcpu=v8 -Wa,-xarch=v8plusa CXX=gcc CXXFLAGS=-O3 -mcpu=v8 -Wa,-xarch=v8plusa -felide-constructors -fno-exceptio ns -fno-rtti ./configure --prefix=/usr/local/mysql --localstatedir=/www_data/mysql/data - -enable-assembler --with-innodb --with-low-memory --with-berkeley-db --with- libwrap --with-named-z-lib=no --with-debug=full configure runs fine but when I run make I get the following: gcc -g -DSAFE_MUTEX -DSAFEMALLOC -O3 -mcpu=v8 -Wa,-xarch=v8plusa -felide-con structors -fno-exceptions -fno-rtti -fno-implicit-templates -fno-exceptions -fno-rtti -DUSE_MYSYS_NEW -DHAVE_RWLOCK_T -o .libs/mysql mysql.o readline.o sql_string.o completion_hash.o ../readline/libreadline.a -lcurses ../libmysql/.libs/libmysqlclient.so -lz -lcrypt -lgen -lsocket -lnsl -lm -Wl ,--defsym -Wl,__cxa_pure_virtual=0 -lz -lcrypt -lgen -lsocket -lnsl -lm -R/u sr/local/mysql/lib/mysql /usr/ccs/bin/ld: illegal option -- - ld: fatal: option -d has illegal argument `efsym' usage: ld [-6:abc:d:e:f:h:il:mo:p:rstu:z:B:CD:F:GI:L:M:N:P:Q:R:S:VY:?] file(s) [-64] enforce a 64-bit link-edit [-a]create an absolute file [-b]do not do special PIC relocations in a.out [-B direct] specify `direct' bindings for executable when run [-B dynamic | static] search for shared libraries|archives [-B eliminate] eliminate unqualified global symbols from the symbol table [-B group] relocate object from within group [-B local] reduce unqualified global symbols to local [-B reduce] process symbol reductions [-B symbolic] bind external references to definitions when creating shared objects [-c name] record configuration file `name' [-C]demangle C++ symbol name diagnostics [-d y | n] operate in dynamic|static mode [-D token,...] print diagnostic messages [-e epsym] use `epsym' as entry point address [-f name] specify library for which this file is an auxiliary filter [-F name] specify library for which this file is a filter [-G]create a shared object [-h name] use `name' as internal shared object identifier [-i]ignore LD_LIBRARY_PATH setting [-I name] use `name' as path of interpreter [-l x] search for libx.so or libx.a [-L path] search for libraries in directory `path' [-m]print memory map [-M mapfile]use processing directives contained in `mapfile' [-N string] create a dynamic dependency for `string' [-o outfile]name the output file `outfile' [-p auditlib] identify audit library to accompany this object [-P auditlib] identify audit library for processing the dependencies of this object [-Q y | n] do|do not place version information in output file [-r]create a relocatable object [-R path] specify a library search path to be used at run time [-s]strip any symbol and debugging information [-S supportlib] specify a link-edit support library [-t]do not warn of multiply-defined symbols that have different sizes or alignments [-u symname]create an undefined symbol `symname' [-V]print version information [-Y P,dirlist] use `dirlist' as a default path when searching for libraries [-z absexec]when building an executable absolute symbols referenced in dynamic objects are promoted to the executable [-z allextract | defaultextract | weakextract] extract all member files, only members that resolve undefined tor tentative symbols, or allow extraction of archive members to resolvetweak references from archive files [-z combreloc] combine multiple relocation sections [-z defs] tdisallow undefined symbol references [-z endfiltee] marks a filtee such that it will terminate a filters search [-z finiarray=function] name of function to be appended to the .finiarray [-z groupperm | nogroupperm] enable|disable setting of group permissions on dynamic dependencies [-z ignore | record] ignore|record unused dynamic dependencies [-z initarray=function] name of function to be appended to the .initarray
Re: Suggestion on New MySQL Function
Hello. On Tue 2002-08-20 at 13:18:04 -0500, [EMAIL PROTECTED] wrote: Through your MySQL documentation, I wasn't able to find a function that I think could be useful. If you DELETE a row with an INT AUTO_INCREMENT field, it will still be able to add the next highest value to this column on an INSERT (ex. If after INSERTing rows, you DELETE a row with a value of five in its INT AUTO_INCREMENT column and the highest value for this particular INT column is currently six, your next INSERTed row will have a value of seven). This is very troubling for me, since at some point this INT will reach it's limit with 'holes' within the table. Simply change to a bigger column type. With BIGINT and e.g. 100.000 INSERTs per second, you run out of numbers in roughly 3 million years. Should not become a problem. ;-) I think a function to find the lowest hole in a specified table would be a useful addition to further upgrades. Thank you for your time and patience. No separate function needed: SELECT used.id+1 FROM mytable AS used LEFT JOIN mytable AS cmp ON cmp.id=used.id+1 WHERE ISNULL(cmp.id) LIMIT 1 Did not test it for speed, though. Regards, Benjamin. -- [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
NULL values in a JOIN
Sql, query Hi, I have a field that I need to do a join on. Unfortunately, the column is allowed to be null (and it should be). My plan is to return the literal string 'None' if the column is null, and otherwise to return the joined value. How can I do this, when the inner join that I want will exclude the rows where the column in question is null? eg: SELECT ... as 'Motion Ref.', title as Title, IF(IFNULL(o.name,10),CONCAT('None'),o.name) as Organization, ... as Date FROM m,o WHERE (o.ID = m.organization) Quinten - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Suggestion on New MySQL Function
It used to do what you are saying. That was very bad. For example, we stored click data for articles. Whe the articles were archived for speed reasons, MySQL started filling in the holes. When we got back around to archiving those rows, we could not do so as the archive table already had rows matching that id. so, you have to pick your poison. an unsigned it is 4,294,967,295. You can safely go to 9,223,372,036,854,775,807 with a big int. I know I won't hit a wall anytime soon. Brian. - Original Message - From: Scott Munday [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 20, 2002 1:18 PM Subject: Suggestion on New MySQL Function | Through your MySQL documentation, I wasn't able to find a function that I | think could be useful. If you DELETE a row with an INT AUTO_INCREMENT field, | it will still be able to add the next highest value to this column on an | INSERT (ex. If after INSERTing rows, you DELETE a row with a value of five | in its INT AUTO_INCREMENT column and the highest value for this particular | INT column is currently six, your next INSERTed row will have a value of | seven). This is very troubling for me, since at some point this INT will | reach it's limit with 'holes' within the table. I think a function to find | the lowest hole in a specified table would be a useful addition to further | upgrades. Thank you for your time and patience. | Sincerely, | Trash Phantom | | | - | Before posting, please check: |http://www.mysql.com/manual.php (the manual) |http://lists.mysql.com/ (the list archive) | | 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: web application test tool
On Tuesday 20 August 2002 01:06 pm, bin cai wrote: check out www.owasp.org, there are some good links there for various tools, mostly for correctness and security testing, but it should give you some good starting points. Check out www.freshmeat.net as well, I am pretty sure some stuff has shown up there at some point. Hi, I have completed a web-based application using java servlet with mysql as the backend database and tomcat as the server. I try to test my application performance using a free test tool. i found one called Microsoft Web Application Stress tool) it is free. but it's test script is used by AsP. I am not quite sure if there is any web test tool using java servlet? Thank you bin __ Post your ad for free now! http://personals.yahoo.ca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 fulltext search
Hi all, I will appreciate if someone could give me some advice. I am going to make a 6.5 mill. phone directory database, and after some previous advice I am able to make a search in a fraction of a second. However there should only be a single search line, not different fields for First, Last - name, street address, Zip code and City name. The last name field in the database could also contain a company name. So here is some examples 1) First Last 2) First Last City 3) First Last Street_addr city 4) First Middle Last Street_addr city 5) First Middle 6) Company 7) Company City .. Well, there is a lot of alternatives, so the best might be a freetext. The database looks like this: create table subscriber ( id bigint unsigned not null auto_increment primary key, subscr_id bigint unsigned, telco_idint unsigned, typeid int unsigned, first varchar (40), middle varchar (40), lastvarchar (40), address varchar (40), postcode int unsigned, postnamevarchar (40), phone varchar (12) ); My plan was to do the thing below, but the query was very slow: create table subscriber ( id bigint unsigned not null auto_increment primary key, subscr_id bigint unsigned, telco_idint unsigned, typeid int unsigned, first varchar (40), middle varchar (40), lastvarchar (40), address varchar (40), postcode int unsigned, postnamevarchar (40), phone varchar (12), FULLTEXT(first, middle, last, address, postname, phone) ); All suggestions are appreciated, thanks in advance. Rgs Steinar Kolnes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Transaction Question CONFUSED
On Tuesday 20 August 2002 01:26 pm, Randy Johnson wrote: I am confused. (innodb table type) I'm really not so sure about the 'lock in share mode' thing, but to the best of my knowledge if you do a SET TRANSACTION_ISOLATION_LEVEL=SERIALIZABLE and then start a transaction where you read data from a row and then update it, there is an absolute guarantee (if the database properly honors the isolation level) that no two transactions can act in such a fashion that either one interferes with the other. In practical terms that means that the same code run from client 2 will block as soon as it attempts the read until transaction started in client 1 is 100% complete. Now, there may be more efficient ways to get this result. InnoDB uses multi-versioning and that has some subtle effects on transactions and concurrency. A larger question however is this, why do you care about reading the old balance? If you aren't going to use it to calculate the new one, then its irrelevant... In other words the scenario you outline reduces (as far as the db is concerned) to just update table set balance=100 and since that is an atomic operation it requires no transaction. In fact in theory ACID never requires a transaction for any operation involving only one single row. For instance if you were incrementing the balance by 100 it would STILL be an atomic operation update table set balance=balance+100 It is in fact only when you get to multi-row or multi-table situations where transactions are required. Consider again your example, since no matter what order the 2 operations are performed in the resut is the same (balance is 100) there is no point in caring what sequence occurs, esp since script 1 cannot care if script 2 ever runs or not, and vice versa (or else they'd be one script...). You can satisfy yourself that the same is true for increment, decrement, or ANY other single-row scenario that can possibly be invented. This is in fact a theorem of transactions... Why then were transactions invented? Suppose you had THREE rows you needed to update with a single update statement update table set balance = balance=1 where id =1 or id = 2 or id = 3 NOW you might need a transaction, because it might be a really bad idea for script 2 to come along and do select balance from table where id =1 or id = 2 or id = 3 and end up with the incremented balance for row 1, and the unincremented balances for rows 2 and 3, which is quite possible. In that case running the 1st query in a transaction would in fact be quite necessary. Now you know what keeps db design guys up late at night Client 1. starts transaction selects balance from table where id=1 for update update table set balance=100 #At this point from what i have read the balance could be selected by anther user. committ I have read that a select balance from table where id=1 lock in share mode will wait for the committ statement, but client 2 would be wanting to update the balance the same way client 1 does sO i do not see how client 2 could use the lock in share mode because the script is the same for client 2 as it is in client one. so how would i ensure that client 2 waits for client 1 to committ before processing their select and update? Randy sql,quary - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: web application test tool
you grab the balance , manipulate it by adding or subtracting an amount then updating it. Randy - Original Message - From: Tod Harter [EMAIL PROTECTED] To: bin cai [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, August 20, 2002 3:35 PM Subject: Re: web application test tool On Tuesday 20 August 2002 01:06 pm, bin cai wrote: check out www.owasp.org, there are some good links there for various tools, mostly for correctness and security testing, but it should give you some good starting points. Check out www.freshmeat.net as well, I am pretty sure some stuff has shown up there at some point. Hi, I have completed a web-based application using java servlet with mysql as the backend database and tomcat as the server. I try to test my application performance using a free test tool. i found one called Microsoft Web Application Stress tool) it is free. but it's test script is used by AsP. I am not quite sure if there is any web test tool using java servlet? Thank you bin __ Post your ad for free now! http://personals.yahoo.ca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Problem Loading Header Files
I get the following error when loading the mysql.h header file. [C++ Error] mysql_com.h(118): E2303 Type name expected [C++ Error] mysql_com.h(118): E2139 Declaration missing ; The error is occuring in teh mysql_com.h header file when the my_socket data member in the structure st_net. Frank Meads Confidential This e-mail and any files transmitted with it are the property of Belkin Components and/or its affiliates, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipients or otherwise have reason to believe that you have received this e-mail in error, please notify the sender and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 equiv for syscolumns?
I have a web based ad hoc query builder I built for running against SQL Server databases. I am trying to port it to mysql. I need a way to return table info through a query. Is there a way to return syscolumns type info in standard column and row format? __ Lon Lentz Applications Developer EXImpact.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: NULL values in a JOIN
Quinten Steenhuis wrote: Sql, query Hi, I have a field that I need to do a join on. Unfortunately, the column is allowed to be null (and it should be). My plan is to return the literal string 'None' if the column is null, and otherwise to return the joined value. How can I do this, when the inner join that I want will exclude the rows where the column in question is null? eg: SELECT ... as 'Motion Ref.', title as Title, IF(IFNULL(o.name,10),CONCAT('None'),o.name) as Organization, ... as Date FROM m,o WHERE (o.ID = m.organization) Quinten - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Quinten, ]Look at outer joins. It might help. http://www.mysql.com/doc/en/JOIN.html walt - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: strange error in InnoDB on raw disk
Hi! Like the manual states, CREATE TABLE, INSERT etc. database operations are blocked when 'newraw' is specified. That is a safety measure. You must not forget 'newraw' to my.cnf, as that will wipe over the partition at the next startup. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com - Original Message - From: Yuri [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, August 20, 2002 7:31 PM Subject: Re: strange error in InnoDB on raw disk is a begin statement the same as set autocommitt = 0?? Nope, I didn't change autocommit. Yuri. FOR FILTER: sql, connect - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Load Data Infile
Hello, I am having troubles with Load Data Infile and cannot figure out the problem. I have a date field but the format is 'Jan 1 1986' rather than mysql's default. So when I import I only get '-00-00' rather than the date. How can I tell MySQL what the format is? I have read through the manual and couldn't find anything. Spent about an hour now looking and now hoping someone here has the answer. Thanks, Serge. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
insert command
I need to know if there is a way to do a simple insert from a .txt file, using insert and only populate one column. Its a streamline db and I want to enter only a few of the columns. I have exported all data into txt files at this point. I can not find any mention on mysql's site other than doing all rows or leaving /n spots with 3000 records and 35 columns can take a bit of time Thank you Joseph. -- __ Sign-up for your own FREE Personalized E-mail at Mail.com http://www.mail.com/?sr=signup - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Load Data Infile
Hello Serge, I am having troubles with Load Data Infile and cannot figure out the problem. I have a date field but the format is 'Jan 1 1986' rather than mysql's default. So when I import I only get '-00-00' rather than the date. How can I tell MySQL what the format is? I have read through the manual and couldn't find anything. Spent about an hour now looking and now hoping someone here has the answer. Alter the table by replacing the date field with a temporary replacement formatted as text (for example). Load the data. Alter the table to add the date field back into the table. Use SQL functions to format the date according to ISO. Alter the table to remove the temporary field. or Go back to the original source and have the date formatted correctly (ISO standard). 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: Load Data Infile
This is the only option? That's not a very automated process and I must import this data once a day. I also will not be able to get them to reformate their data since I'm only one of many many people downloading everyday. Is their no way for load data to do this automaticaly? Serge. On Tue, 20 Aug 2002 21:31:45 +0100 DL Neil [EMAIL PROTECTED] wrote: Hello Serge, I am having troubles with Load Data Infile and cannot figure out the problem. I have a date field but the format is 'Jan 1 1986' rather than mysql's default. So when I import I only get '-00-00' rather than the date. How can I tell MySQL what the format is? I have read through the manual and couldn't find anything. Spent about an hour now looking and now hoping someone here has the answer. Alter the table by replacing the date field with a temporary replacement formatted as text (for example). Load the data. Alter the table to add the date field back into the table. Use SQL functions to format the date according to ISO. Alter the table to remove the temporary field. or Go back to the original source and have the date formatted correctly (ISO standard). 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: Suggestion on New MySQL Function
Hi, Maybe can be useful.MySQL suport and UDF. But you can solve this problem in the next way: @a:=0;-initialize variable a select @a:MAX(YOUR_COLUMN_FROM TABLE) from YOUR_TABLE; select @a:=@a+1; insert into YOUR_TABLE SET YOUR_COLUMN_FROM TABLE= @a,bla,bla...; Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Scott Munday [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 20, 2002 9:18 PM Subject: Suggestion on New MySQL Function Through your MySQL documentation, I wasn't able to find a function that I think could be useful. If you DELETE a row with an INT AUTO_INCREMENT field, it will still be able to add the next highest value to this column on an INSERT (ex. If after INSERTing rows, you DELETE a row with a value of five in its INT AUTO_INCREMENT column and the highest value for this particular INT column is currently six, your next INSERTed row will have a value of seven). This is very troubling for me, since at some point this INT will reach it's limit with 'holes' within the table. I think a function to find the lowest hole in a specified table would be a useful addition to further upgrades. Thank you for your time and patience. Sincerely, Trash Phantom - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 equiv for syscolumns?
On Tue, Aug 20, 2002 at 04:03:03PM -0400, Lon Lentz wrote: I have a web based ad hoc query builder I built for running against SQL Server databases. I am trying to port it to mysql. I need a way to return table info through a query. Is there a way to return syscolumns type info in standard column and row format? It might be helpful to describe what you need without using SQL Server terminology. A lot of folks here have never used the product but could probably help you anyway. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 14 days, processed 287,167,474 queries (228/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
Re: insert command
Joseph, I need to know if there is a way to do a simple insert from a .txt file, using insert and only populate one column. Its a streamline db and I want to enter only a few of the columns. I have exported all data into txt files at this point. I can not find any mention on mysql's site other than doing all rows or leaving /n spots with 3000 records and 35 columns can take a bit of time Are you trying to limit: - columns (first para) - rows (second para), or - both. The manual (6.4.9 LOAD DATA INFILE) says If you wish to load only some of a table's columns, specify a field list Alternatively, load the lot into a table, then ALTER the table to drop unneeded columns - the 'extra' loading time will be unlikely to be noticeable. 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: Load Data Infile
On Tue, Aug 20, 2002 at 04:40:25PM -0400, Serge Paquin wrote: This is the only option? That's not a very automated process and I must import this data once a day. I also will not be able to get them to reformate their data since I'm only one of many many people downloading everyday. Is their no way for load data to do this automaticaly? Paul DuBois has some useful scripts to convert dates in the Early release software section of the page for his forthcoming _MySQL Cookbook_ at http://www.kitebird.com/mysql-cookbook/ I think you'll find it pretty useful for this. Jesse Sheidlower - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: replication problem
Walt, At 01:09 PM 8/20/2002 -0400, walt wrote: on the slave you should run show slave status on slave: mysql show slave status; +-+-+-+---+-+-+--+---+---+--+---+-+-+++--+-+-+ | Master_Host | Master_User | Master_Port | Connect_retry | Master_Log_File | Read_Master_Log_Pos | Relay_Log_File | Relay_Log_Pos | Relay_Master_Log_File | Slave_IO_Running | Slave_SQL_Running | Replicate_do_db | Replicate_ignore_db | Last_errno | Last_error | Skip_counter | Exec_master_log_pos | Relay_log_space | +-+-+-+---+-+-+--+---+---+--+---+-+-+++--+-+-+ | master.idsk.com | replicate | 3306| 60| | 4 | slave-relay-bin.001 | 4 | | No | Yes | | | 0 || 0| 0 | 4 | +-+-+-+---+-+-+--+---+---+--+---+-+-+++--+-+-+ 1 row in set (0.00 sec) What in particular should I be looking at here? I can see Slave_SQL_Running: Yes. When i insert info into one of the master's table, slave's show master status is: ++--+--+--+ | File | Position | Binlog_do_db | Binlog_ignore_db | ++--+--+--+ | slave-bin.001 | 79 | | | ++--+--+--+ master's show master status is: ++--+--+--+ | File | Position | Binlog_do_db | Binlog_ignore_db | ++--+--+--+ | master-bin.002 | 162 | | | ++--+--+--+ I re installed everything and still got the same error: 020820 18:05:20 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'FIRST' at position 4 020820 18:05:20 Error updating slave list: 020820 18:05:20 Slave I/O thread exiting, read up to log 'FIRST', position 4 also on the slave check /path/to/mysql/master.info this file gives you good info and I had to change it manually when I changed master server names in the my.cnf file my slave's master.info looks like: 4 master.idsk.com replicate replicatedb 3306 60 138206092 Anything wrong with it? also, add set-variable = slave_net_timeout=3600 set-variable = net_read_timeout=3600 I have added this one, thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: insert command
- Original Message - From: Keith C. Ivey [EMAIL PROTECTED] Date: Tue, 20 Aug 2002 16:50:39 -0400 To: [EMAIL PROTECTED] Subject: Re: insert command On 21 Aug 2002, at 4:27, Joseph Grundy wrote: I need to know if there is a way to do a simple insert from a .txt file, using insert and only populate one column. Its a streamline db and I want to enter only a few of the columns. I have exported all data into txt files at this point. I can not find any mention on mysql's site other than doing all rows or leaving /n spots with 3000 records and 35 columns can take a bit of time If I'm understanding what you want correctly, you need to either (1) preprocess your text file (with a line or two of Perl or whatever you use for manipulating text files) to remove the columns you don't want or (2) import all the columns and just drop the ones you don't want. In the special case where the columns you do want happen to be the ones at the start of each line, then you should be able to import them with LOAD DATA without modifying the text file. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org I have the text files created. Example I have a table created lets say prices, in table prices there are 15 columns named 1 through 15. I want to be able to populate one column say 8 with data I exported from a column in a different database, using the txt file. Instead of populating by row. I was seeing if there was a way other than nulling all columns but that one I wanted the data to go into. To put 2000 records directly into column 8 as above. Thanks Joseph. -- __ Sign-up for your own FREE Personalized E-mail at Mail.com http://www.mail.com/?sr=signup - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Load Data Infile
Serge Paquin wrote: This is the only option? That's not a very automated process and I must import this data once a day. I also will not be able to get them to reformate their data since I'm only one of many many people downloading everyday. Is their no way for load data to do this automaticaly? Serge. On Tue, 20 Aug 2002 21:31:45 +0100 DL Neil [EMAIL PROTECTED] wrote: Hello Serge, I am having troubles with Load Data Infile and cannot figure out the problem. I have a date field but the format is 'Jan 1 1986' rather than mysql's default. So when I import I only get '-00-00' rather than the date. How can I tell MySQL what the format is? I have read through the manual and couldn't find anything. Spent about an hour now looking and now hoping someone here has the answer. Alter the table by replacing the date field with a temporary replacement formatted as text (for example). Load the data. Alter the table to add the date field back into the table. Use SQL functions to format the date according to ISO. Alter the table to remove the temporary field. or Go back to the original source and have the date formatted correctly (ISO standard). 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 can you load the data from a perl script? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Load Data Infile
Serge, Why didn't you give this information/constraint in the first place? Why now complain that it is not a very automated solution? Why narrow your mind to assume that the problem is with MySQL? Them are going to be a problem to many of their 'clients' then, because CCYY-MM-DD is the international informatique standard. Practically all db users are going to have to fight this - assuming that's what 'them' are expecting will happen to their data. So the problem does not seem to lie with MySQL (or name other RDBMSes)! I don't think it can be done within a single SQL LOAD DATA command. You could do as I suggest, but load the data into a temporary table, handle the reformatting there, and then copy those results into the 'permanent' table. You could pre-process the incoming data file to change the date format, before handing it to the LOAD DATA operation. You could use some 'middleware' to do the whole thing, eg a PHP script, to read in the data file as-is, reformat and perform db INSERT operations. Other ideas? =dn This is the only option? That's not a very automated process and I must import this data once a day. I also will not be able to get them to reformate their data since I'm only one of many many people downloading everyday. Is their no way for load data to do this automaticaly? Serge. On Tue, 20 Aug 2002 21:31:45 +0100 DL Neil [EMAIL PROTECTED] wrote: Hello Serge, I am having troubles with Load Data Infile and cannot figure out the problem. I have a date field but the format is 'Jan 1 1986' rather than mysql's default. So when I import I only get '-00-00' rather than the date. How can I tell MySQL what the format is? I have read through the manual and couldn't find anything. Spent about an hour now looking and now hoping someone here has the answer. Alter the table by replacing the date field with a temporary replacement formatted as text (for example). Load the data. Alter the table to add the date field back into the table. Use SQL functions to format the date according to ISO. Alter the table to remove the temporary field. or Go back to the original source and have the date formatted correctly (ISO standard). 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 equiv for syscolumns?
What I need to obtain is the table information. Column names, type, length, etc. Someone suggested using the EXPLAIN or DESCRIBE commands, but ColdFusion is not returning it as a valid queryset. Are the result sets of these commands ODBCable? I am using MyODBC on Linux. -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 4:53 PM To: Lon Lentz Cc: [EMAIL PROTECTED] Subject: Re: mysql equiv for syscolumns? On Tue, Aug 20, 2002 at 04:03:03PM -0400, Lon Lentz wrote: I have a web based ad hoc query builder I built for running against SQL Server databases. I am trying to port it to mysql. I need a way to return table info through a query. Is there a way to return syscolumns type info in standard column and row format? It might be helpful to describe what you need without using SQL Server terminology. A lot of folks here have never used the product but could probably help you anyway. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 14 days, processed 287,167,474 queries (228/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
Re: insert command
- Original Message - From: DL Neil [EMAIL PROTECTED] Date: Tue, 20 Aug 2002 21:51:24 +0100 To: Joseph Grundy [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: insert command Joseph, I need to know if there is a way to do a simple insert from a .txt file, using insert and only populate one column. Its a streamline db and I want to enter only a few of the columns. I have exported all data into txt files at this point. I can not find any mention on mysql's site other than doing all rows or leaving /n spots with 3000 records and 35 columns can take a bit of time Are you trying to limit: - columns (first para) - rows (second para), or - both. The manual (6.4.9 LOAD DATA INFILE) says If you wish to load only some of a table's columns, specify a field list Alternatively, load the lot into a table, then ALTER the table to drop unneeded columns - the 'extra' loading time will be unlikely to be noticeable. 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 Another way to say it I have an old DB with 30 columns in it. I want to remove a few columns of data from that one and insert it into the new db. I have exported the columns needed into txt files The question is populating the new db with to the proper columns, the empty colums will be taken care of at a later time and info is updated. Only a few is needed at the moment. Thanks Joseph -- __ Sign-up for your own FREE Personalized E-mail at Mail.com http://www.mail.com/?sr=signup - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
phpMyAdmin is this possible
I am new to MySQL and PHP. Having looked at PHPMyAdmin the GUI I was wondering if it's possible to create a new database within the system? If so what are the commands? I ask because I only have one database on my server and don't want to populate it with different tables, I'd rather have seperate ones for seperate functions.. Ideas or advice? is the way I am suggesting better or worse than the way my hosting company expects me to work? Thanks in advance. Steve. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: [PHP] phpMyAdmin is this possible
Do you have phpMyAdmin running yet? If so you create new databases with the click of a button. The first page you see should say Welcome to phpMyAdmin ...ver etc. If you have set phpMyAdmin to run on an existing MySQL install, the drop down boxes should contain your existing databases if configured correctly. To create a new database just type the name in the box on the home page and click create, from there you can create new tables etc. hth Steve. -Original Message- From: Steve Jackson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 3:12 PM To: MYSQL; Php-General Subject: [PHP] phpMyAdmin is this possible I am new to MySQL and PHP. Having looked at PHPMyAdmin the GUI I was wondering if it's possible to create a new database within the system? If so what are the commands? I ask because I only have one database on my server and don't want to populate it with different tables, I'd rather have seperate ones for seperate functions.. Ideas or advice? is the way I am suggesting better or worse than the way my hosting company expects me to work? Thanks in advance. Steve. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.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: insert command
- Original Message - From: Keith C. Ivey [EMAIL PROTECTED] Date: Tue, 20 Aug 2002 16:50:39 -0400 To: [EMAIL PROTECTED] Subject: Re: insert command On 21 Aug 2002, at 4:27, Joseph Grundy wrote: I need to know if there is a way to do a simple insert from a .txt file, using insert and only populate one column. Its a streamline db and I want to enter only a few of the columns. I have exported all data into txt files at this point. I can not find any mention on mysql's site other than doing all rows or leaving /n spots with 3000 records and 35 columns can take a bit of time If I'm understanding what you want correctly, you need to either (1) preprocess your text file (with a line or two of Perl or whatever you use for manipulating text files) to remove the columns you don't want or (2) import all the columns and just drop the ones you don't want. In the special case where the columns you do want happen to be the ones at the start of each line, then you should be able to import them with LOAD DATA without modifying the text file. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org I have the text files created. Example I have a table created lets say prices, in table prices there are 15 columns named 1 through 15. I want to be able to populate one column say 8 with data I exported from a column in a different database, using the txt file. Instead of populating by row. I was seeing if there was a way other than nulling all columns but that one I wanted the data to go into. To put 2000 records directly into column 8 as above. Thanks Joseph. -- __ Sign-up for your own FREE Personalized E-mail at Mail.com http://www.mail.com/?sr=signup - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: insert command
- Original Message - From: DL Neil [EMAIL PROTECTED] Date: Tue, 20 Aug 2002 21:51:24 +0100 To: Joseph Grundy [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: insert command Joseph, I need to know if there is a way to do a simple insert from a .txt file, using insert and only populate one column. Its a streamline db and I want to enter only a few of the columns. I have exported all data into txt files at this point. I can not find any mention on mysql's site other than doing all rows or leaving /n spots with 3000 records and 35 columns can take a bit of time Are you trying to limit: - columns (first para) - rows (second para), or - both. The manual (6.4.9 LOAD DATA INFILE) says If you wish to load only some of a table's columns, specify a field list Alternatively, load the lot into a table, then ALTER the table to drop unneeded columns - the 'extra' loading time will be unlikely to be noticeable. 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 Another way to say it I have an old DB with 30 columns in it. I want to remove a few columns of data from that one and insert it into the new db. I have exported the columns needed into txt files The question is populating the new db with to the proper columns, the empty colums will be taken care of at a later time and info is updated. Only a few is needed at the moment. Thanks Joseph -- __ Sign-up for your own FREE Personalized E-mail at Mail.com http://www.mail.com/?sr=signup - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: replication problem
On Tuesday 20 August 2002 09:02 pm, Froilan Mendoza wrote: Walt, At 01:09 PM 8/20/2002 -0400, walt wrote: on the slave you should run show slave status on slave: mysql show slave status; +-+-+-+---+ -+-+--+---+- --+--+---+-+ -+++--+- +-+ | Master_Host | Master_User | Master_Port | Connect_retry | Master_Log_File | Read_Master_Log_Pos | Relay_Log_File | Relay_Log_Pos | Relay_Master_Log_File | Slave_IO_Running | Slave_SQL_Running | Replicate_do_db | Replicate_ignore_db | Last_errno | Last_error | Skip_counter | Exec_master_log_pos | Relay_log_space | +-+-+-+---+ -+-+--+---+- --+--+---+-+ -+++--+- +-+ | master.idsk.com | replicate | 3306| 60| | 4 | slave-relay-bin.001 | 4 | | No | Yes | | | 0 || 0| 0 | 4 | +-+-+-+---+ -+-+--+---+- --+--+---+-+ -+++--+- +-+ 1 row in set (0.00 sec) What in particular should I be looking at here? I can see Slave_SQL_Running: Yes. When i insert info into one of the master's table, slave's show master status is: ++--+--+--+ | File | Position | Binlog_do_db | Binlog_ignore_db | ++--+--+--+ | slave-bin.001 | 79 | | | ++--+--+--+ master's show master status is: ++--+--+--+ | File | Position | Binlog_do_db | Binlog_ignore_db | ++--+--+--+ | master-bin.002 | 162 | | | ++--+--+--+ I re installed everything and still got the same error: 020820 18:05:20 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'FIRST' at position 4 020820 18:05:20 Error updating slave list: 020820 18:05:20 Slave I/O thread exiting, read up to log 'FIRST', position 4 also on the slave check /path/to/mysql/master.info this file gives you good info and I had to change it manually when I changed master server names in the my.cnf file my slave's master.info looks like: 4 master.idsk.com replicate replicatedb 3306 60 138206092 Anything wrong with it? also, add set-variable = slave_net_timeout=3600 set-variable = net_read_timeout=3600 I have added this one, thanks. Hmmm... When you set up the master database, did you copy all the *.frm, *.MYD, *.MYI to the slave database? I also noticed in your email the my.cnf file on the master had serveri-d instead of server-id Try removing bin-log from the my.cnf on the slave. If I remember correctly, there is a way to set up the slave to keep archives of the updates. The master.info file on the slave should look something like this Ignor stuff in quotes, I added that. walt-bin.950 log file on the master 73 position of the log file on the master walt.nea-fast.com master server name repl replication user name passwd replication password 3306 port 60 6 60 Let me know if any of this helps! -- Walter Anthony System Administrator National Electronic Attachment Atlanta, Georgia 1-800-782-5150 ext. 1608 If it's not broketweak 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: insert command
On 21 Aug 2002, at 5:01, Joseph Grundy wrote: Example I have a table created lets say prices, in table prices there are 15 columns named 1 through 15. I want to be able to populate one column say 8 with data I exported from a column in a different database, using the txt file. So you have an already existing table and you want to update one column of it from a text file that contains only one column? Is that correct? How do you know which row in the text file goes with which row in the table? In any case, LOAD DATA won't be able to do that, because it's for doing inserts, not updates. In order to do anything useful with the text file, it seems to me that you'll first have to add at least one more column to it, containing the primary key from the table that the data is going into. You'll need something to join on. [Filter fodder: SQL] -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.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: Load Data Infile
I would use some sort of scripting language (PHP for example) to format the date, and have that script import the data into your table, rather than using LOAD DATA INFILE. If you post a sample of how your data file is formatted, someone will gladly help you out. You might want to post this to the PHP mailing list instead, as this solution is somewhat off-topic from MySQL. --- Serge Paquin [EMAIL PROTECTED] wrote: This is the only option? That's not a very automated process and I must import this data once a day. I also will not be able to get them to reformate their data since I'm only one of many many people downloading everyday. Is their no way for load data to do this automaticaly? Serge. On Tue, 20 Aug 2002 21:31:45 +0100 DL Neil [EMAIL PROTECTED] wrote: Hello Serge, I am having troubles with Load Data Infile and cannot figure out the problem. I have a date field but the format is 'Jan 1 1986' rather than mysql's default. So when I import I only get '-00-00' rather than the date. How can I tell MySQL what the format is? I have read through the manual and couldn't find anything. Spent about an hour now looking and now hoping someone here has the answer. Alter the table by replacing the date field with a temporary replacement formatted as text (for example). Load the data. Alter the table to add the date field back into the table. Use SQL functions to format the date according to ISO. Alter the table to remove the temporary field. or Go back to the original source and have the date formatted correctly (ISO standard). 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 __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.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