AW: [PHP] How to argue with ASP people...
Tony, Check out ASP.NET and you will want to forget everything about PHP ;-) Freddie -Ursprüngliche Nachricht- Von: mail.pmpa [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 31. Dezember 2004 03:27 An: mysql@lists.mysql.com Betreff: RE: [PHP] How to argue with ASP people... Don't mean to start a discussion whatsoever, I love php, but one thing i can't do in php is Response.Redirect(page.asp) . Apart from that no complains so far :) * Happy New Year * Pedro Almeida. -Mensagem original- De: Tony Di Croce [mailto:[EMAIL PROTECTED] I am fairly new to PHP, but I am loving it... I have recently gotten involved in a business venture and I have been using PHP so far... Recently I have taken on a partner, and he is a big ASP guy... I am not totally against ASP, but it would have to be pretty good to get me to switch at this point (PHP seems to do everything I need)... But I will need to convince him of this... What points can I bring up in PHP's favor? In what areas does PHP trounce ASP? -- td -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: AW: [PHP] How to argue with ASP people...
FOAD Quoting Freddie Sorensen [EMAIL PROTECTED]: Tony, Check out ASP.NET and you will want to forget everything about PHP ;-) Freddie -Ursprüngliche Nachricht- Von: mail.pmpa [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 31. Dezember 2004 03:27 An: mysql@lists.mysql.com Betreff: RE: [PHP] How to argue with ASP people... Don't mean to start a discussion whatsoever, I love php, but one thing i can't do in php is Response.Redirect(page.asp) . Apart from that no complains so far :) * Happy New Year * Pedro Almeida. -Mensagem original- De: Tony Di Croce [mailto:[EMAIL PROTECTED] I am fairly new to PHP, but I am loving it... I have recently gotten involved in a business venture and I have been using PHP so far... Recently I have taken on a partner, and he is a big ASP guy... I am not totally against ASP, but it would have to be pretty good to get me to switch at this point (PHP seems to do everything I need)... But I will need to convince him of this... What points can I bring up in PHP's favor? In what areas does PHP trounce ASP? -- td -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] R. Whitney Transcend Development Producing the next phase of your internet presence http://xend.net Premium Quality Web Hosting http://hosting.xend.net rw AT xend.net Net Binder http://netbinder.net 310-943-6498 602-288-5340 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
auto commit
Hi All, I am using ODBC interface to access MySQL database. All DML oparations like insert, update and delete are performed using ODBC API's ( C program and ODBC API's). We start the transaction in the following order. 1.create savepoint a 2. do dml operation 3. commit if dml is success else rollback upto savepoint. In the above sequence we need to set autocommit= 0. This we executed in mysql prompt. How can we set autocommit = 0 feature in ODBC interface before doing any DML operation? Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments.
Re: export from older version
Eric Bergen wrote: If you can use mysqldump to export the data from 3.23 with the -Q switch to quote all db, table, and column names. Thanks for the input, that has worked for me in the past, but it's on a hosted db server and I don't think I have rights to run mysqldump on it. I was hoping to avoid contacting te host. Thanks, - dstefani -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Weird server timeout problem
On Thu, 2004-12-30 at 16:19 -0700, Sasha Pachev wrote: Dale Blount wrote: Hello, I've been fighting this problem for a while, and now it's time to ask the experts. Please also CC me on this, I'm only on the list as a digest. Dale: Enable the log-long-format and log-slow-queries on your server, and see if you have some hogs that lock your table for a long time once in a while. This would explain the results you are observing. Thanks for the tips Sasha. I had neglected to mention that I have these already turned on and very little shows up in them (i.e. nothing when I get a 5 second response, although every once in a while something is listed). I have checked that the packets are making it there on time using tcpdump, there's just that unknown 5 second wait before a response is returned. As far as I can tell it's not because of a slow query and turning on full query logging doesn't make anything stick out to me. Anything else I could try? Thanks and Happy New Year, Dale -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: auto commit
I haven't worked with ODBC in several years and I was never very fluent with it but I *think* you need to use a SQLSetConnectAttr call, passing the desired value to SQL_ATTR_AUTOCOMMIT. This article describes the SQLSetConnectAttr call: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/o dbcsqlsetconnectattr.asp Rhino - Original Message - From: [EMAIL PROTECTED] To: mysql@lists.mysql.com Cc: [EMAIL PROTECTED] Sent: Friday, December 31, 2004 8:01 AM Subject: auto commit Hi All, I am using ODBC interface to access MySQL database. All DML oparations like insert, update and delete are performed using ODBC API's ( C program and ODBC API's). We start the transaction in the following order. 1.create savepoint a 2. do dml operation 3. commit if dml is success else rollback upto savepoint. In the above sequence we need to set autocommit= 0. This we executed in mysql prompt. How can we set autocommit = 0 feature in ODBC interface before doing any DML operation? Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: AW: [PHP] How to argue with ASP people...
Have you actually LOOKED at the code (global.asp, *.asp, *.aspx, etc... ) that VS produces to make an ASP.NET application? Have you EVER had to be in the position to debug and modify that by hand (without the aid of VS)? I have. I ask that you try it before you continue your high praise for the product. I fully believe that M$ is so full of themselves for offering this as anything approaching efficient. It's designed in such a way that once you convert, you will have a very hard time getting away from it because it is SO convoluted in its execution. I feel that it's meant more to trap you into staying with their product than making life easier. I have tried (or assisted others) on more than one occasion to get ASP.NET functioning for full development support (server-side debugging, full VS integration, yadda yadda yadda) and have YET to see anyone get it right the first time. Usually we have to rip out and reinstall or update and upgrade which required us to compare and contrast several different explanations from MSDN about what may be wrong and how to fix it. Eventually, we made it work but it was never easy. IF you like it, fine. You may use it. I however recommend against it. Stick with PHP, ASP, PERL, or Python (whichever you prefer) but I personally don't think that ASP.NET is worth the effort for the few benefits it provides. Shawn Green Database Administrator Unimin Corporation - Spruce Pine Freddie Sorensen [EMAIL PROTECTED] wrote on 12/31/2004 04:01:14 AM: Tony, Check out ASP.NET and you will want to forget everything about PHP ;-) Freddie -Ursprüngliche Nachricht- Von: mail.pmpa [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 31. Dezember 2004 03:27 An: mysql@lists.mysql.com Betreff: RE: [PHP] How to argue with ASP people... Don't mean to start a discussion whatsoever, I love php, but one thing i can't do in php is Response.Redirect(page.asp) . Apart from that no complains so far :) * Happy New Year * Pedro Almeida. -Mensagem original- De: Tony Di Croce [mailto:[EMAIL PROTECTED] I am fairly new to PHP, but I am loving it... I have recently gotten involved in a business venture and I have been using PHP so far... Recently I have taken on a partner, and he is a big ASP guy... I am not totally against ASP, but it would have to be pretty good to get me to switch at this point (PHP seems to do everything I need)... But I will need to convince him of this... What points can I bring up in PHP's favor? In what areas does PHP trounce ASP? -- td -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AW: AW: [PHP] How to argue with ASP people...
Shawn, It is worth it for performance reasons ! And yes, I am LOOKING at the code and DEBUGGING it every single day, also without the use of VS, what's the problem ? And it is global.asax, not global.asp I and my colleagues have never had a project which we didn't get right the first time, I mean in terms of having to reinstall anything, it was always very easy And if you believe ASP.NET only provides a few benefits, then you are adequately informed, my friend Freddie _ Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 31. Dezember 2004 15:26 An: Freddie Sorensen Cc: 'mail.pmpa'; mysql@lists.mysql.com Betreff: Re: AW: [PHP] How to argue with ASP people... Have you actually LOOKED at the code (global.asp, *.asp, *.aspx, etc... ) that VS produces to make an ASP.NET application? Have you EVER had to be in the position to debug and modify that by hand (without the aid of VS)? I have. I ask that you try it before you continue your high praise for the product. I fully believe that M$ is so full of themselves for offering this as anything approaching efficient. It's designed in such a way that once you convert, you will have a very hard time getting away from it because it is SO convoluted in its execution. I feel that it's meant more to trap you into staying with their product than making life easier. I have tried (or assisted others) on more than one occasion to get ASP.NET functioning for full development support (server-side debugging, full VS integration, yadda yadda yadda) and have YET to see anyone get it right the first time. Usually we have to rip out and reinstall or update and upgrade which required us to compare and contrast several different explanations from MSDN about what may be wrong and how to fix it. Eventually, we made it work but it was never easy. IF you like it, fine. You may use it. I however recommend against it. Stick with PHP, ASP, PERL, or Python (whichever you prefer) but I personally don't think that ASP.NET is worth the effort for the few benefits it provides. Shawn Green Database Administrator Unimin Corporation - Spruce Pine Freddie Sorensen [EMAIL PROTECTED] wrote on 12/31/2004 04:01:14 AM: Tony, Check out ASP.NET and you will want to forget everything about PHP ;-) Freddie -Ursprüngliche Nachricht- Von: mail.pmpa [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 31. Dezember 2004 03:27 An: mysql@lists.mysql.com Betreff: RE: [PHP] How to argue with ASP people... Don't mean to start a discussion whatsoever, I love php, but one thing i can't do in php is Response.Redirect(page.asp) . Apart from that no complains so far :) * Happy New Year * Pedro Almeida. -Mensagem original- De: Tony Di Croce [mailto:[EMAIL PROTECTED] I am fairly new to PHP, but I am loving it... I have recently gotten involved in a business venture and I have been using PHP so far... Recently I have taken on a partner, and he is a big ASP guy... I am not totally against ASP, but it would have to be pretty good to get me to switch at this point (PHP seems to do everything I need)... But I will need to convince him of this... What points can I bring up in PHP's favor? In what areas does PHP trounce ASP? -- td -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: BIG InnoDB problems!
Greetings Heikki and Happy New Year! Here's what I got. I hope it's useful. beech:/home/jfreeman # resolve_stack_dump -s /tmp/mysqld.sym -n mysqld.stack 0x815f0cf handle_segfault + 575 0xe420 _end + -138916432 0x82e71d5 buf_read_page + 165 0x82e71d5 buf_read_page + 165 0x82db68f buf_page_get_gen + 175 0x830479f flst_insert_before + 239 0x8304cc8 flst_add_first + 152 0x82be800 trx_purge_add_update_undo_to_history + 624 0x82d14a6 trx_undo_update_cleanup + 38 0x82ccafb trx_commit_off_kernel + 363 0x82cd865 trx_sig_start_handle + 1109 0x826232b que_run_threads + 2299 0x827915a row_drop_table_for_mysql + 2314 0x81fe924 _ZN11ha_innobase12delete_tableEPKc + 404 0x81ef33c _Z15ha_delete_table7db_typePKc + 60 0x820aead _Z20mysql_rm_table_part2P3THDP13st_table_listbbb + 989 0x820b19d _Z30mysql_rm_table_part2_with_lockP3THDP13st_table_listbbb + 93 0x8201554 _Z20mysql_rm_known_filesP3THDP9st_my_dirPKcS4_j + 1428 0x8202739 _Z11mysql_rm_dbP3THDPcbb + 345 0x81796cb _Z21mysql_execute_commandP3THD + 19339 0x817c1b4 _Z11mysql_parseP3THDPcj + 484 0x817de5d _Z16dispatch_command19enum_server_commandP3THDPcj + 2685 0x817f137 handle_one_connection + 2391 0x401619ed _end + 936280957 0x403519ca _end + 938312538 p.s. the whole error file is only 301 lines long. If you wish I could send it to you... Here's a segment from lines 1 - 41: 041230 11:12:10 mysqld started 041230 11:12:10 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 041230 11:12:10 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 241342003. InnoDB: Doing recovery: scanned up to log sequence number 0 241342036 InnoDB: Last MySQL binlog file position 0 79, file name ./beech-bin.47 041230 11:12:10 InnoDB: Flushing modified pages from the buffer pool... 041230 11:12:10 InnoDB: Started; log sequence number 0 241342036 InnoDB: !!! innodb_force_recovery is set to 5 !!! 041230 11:12:10 [Warning] mysql.user table is not updated to new password format; Disabling new password usage until mysql_fix_privilege_tables is run 041230 11:12:10 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them /usr/local/libexec/mysqld: ready for connections. Version: '4.1.8a-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution InnoDB: A new raw disk partition was initialized or InnoDB: innodb_force_recovery is on: we do not allow InnoDB: database modifications by the user. Shut down InnoDB: mysqld and edit my.cnf so that newraw is replaced InnoDB: with raw, and innodb_force_... is removed. InnoDB: Error: trying to access page number 940269659 in space 0, InnoDB: space name ./ibdata1, InnoDB: which is outside the tablespace bounds. InnoDB: Byte offset 0, len 16384, i/o type 10 041230 16:42:57InnoDB: Assertion failure in thread 1124068272 in file fil0fil.c line 3729 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/mysql/en/Forcing_recovery.html InnoDB: about forcing recovery. mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. On Fri, 31 Dec 2004 07:46:01 +0200, Heikki Tuuri [EMAIL PROTECTED] wrote: Joshua, please show what the FIRST InnoDB error in the .err log was. The first error is always the important thing to report. Please follow these instructions: Please read http://dev.mysql.com/doc/mysql/en/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php Order MySQL technical support from https://order.mysql.com/ - Original Message - From: jsf [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Friday, December 31, 2004 12:26 AM Subject: BIG InnoDB problems! I've been struggling with this problem for the last few days. I've enlisted the help of some colleagues on the NYLUG (NY Linux User's Group) list but finally we figured this is the best place to look for
InnoDB: Error: tablespace size stored in header is 17024 pages, but ...
Dear MySQL people I have a question regarding the error: InnoDB: Error: tablespace size stored in header is 17024 pages, but InnoDB: the sum of data file sizes is only 16576 pages which appeared when I upgraded from 4.0.7 to 4.1.7. Somehow I am 448 pages (7M) short of table space. Can I fix this using the procedure outlined in http://archives.neohapsis.com/archives/mysql/2004-q3/3723.html or should I do a dump/restore? Here are the gory details: I was running MySQL Ver 12.22 Distrib 4.0.17 with the following /etc/my.cnf file: [mysqld] user=www datadir=/local/own-1/rt/mysql-data innodb_data_file_path = ibdata1:10M:autoextend Then I built a new MySQL Ver 14.7 Distrib 4.1.7 and decided to do binary logging so I changed /etc/my.cnf to read [mysqld] user=rt datadir=/local/own-1/rt/mysql-data innodb_data_file_path = ibdata1:10M:autoextend # Set buffer pool size to 50-80% of memory set-variable = innodb_buffer_pool_size=512M set-variable = innodb_additional_mem_pool_size=10M # Set the log file size to about 25% of the buffer pool size set-variable = innodb_log_file_size=64M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 # Turn on binary logging and sync set-variable = log_bin=1 set-variable = sync_binlog=1 Then I shut down the old database, copied the data files and deleted the ib_logfile* files and this is what I got in the logs on starting 4.1.7. I was a bit surprised at the 'not shut down normally' message, but hey. ... 041229 14:04:51 mysqld started 041229 14:04:51 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 64 MB InnoDB: Database physically writes the file full: wait... 041229 14:04:53 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 64 MB InnoDB: Database physically writes the file full: wait... 041229 14:04:55 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... InnoDB: Resetting space id's in the doublewrite buffer 041229 14:04:55 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 405584396. InnoDB: Doing recovery: scanned up to log sequence number 0 405584396 041229 14:04:55 InnoDB: Flushing modified pages from the buffer pool... 041229 14:04:55 InnoDB: Started; log sequence number 0 405584396 InnoDB: You are upgrading to an InnoDB version which allows multiple InnoDB: tablespaces. Wait that purge and insert buffer merge run to InnoDB: completion... InnoDB: Full purge and insert buffer merge completed. InnoDB: You have now successfully upgraded to the multiple tablespaces InnoDB: format. You should NOT DOWNGRADE to an earlier version of InnoDB: InnoDB! But if you absolutely need to downgrade, see InnoDB: http://dev.mysql.com/doc/mysql/en/Multiple_tablespaces.html InnoDB: for instructions. 041229 14:04:57 [Warning] mysql.user table is not updated to new password format ; Disabling new password usage until mysql_fix_privilege_tables is run 041229 14:04:57 [Warning] Can't open and lock time zone table: Table 'mysql.time _zone_leap_second' doesn't exist trying to live without them /local/own-1/rt/rt-3.2.2/libexec/mysqld: ready for connections. Version: '4.1.7-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution But now when I start the database I get: 041230 10:04:37 mysqld started InnoDB: Error: tablespace size stored in header is 17024 pages, but InnoDB: the sum of data file sizes is only 16576 pages 041230 10:04:39 InnoDB: Started; log sequence number 0 405783741 041230 10:04:39 [Warning] mysql.user table is not updated to new password format ; Disabling new password usage until mysql_fix_privilege_tables is run 041230 10:04:39 [Warning] Can't open and lock time zone table: Table 'mysql.time _zone_leap_second' doesn't exist trying to live without them /local/own-1/rt/rt-3.2.2/libexec/mysqld: ready for connections. Version: '4.1.7-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Multi table update
Jay Blanchard [EMAIL PROTECTED] wrote on 12/30/2004 05:20:49 PM: [snip] Anyhow, it has been a good discussion. No bugs were uprooted and everyone's understanding may have risen a notch. After a couple of decades using SQL I still find interesting topics to discuss. Yes, I too have enjoyed this conversation. Thank you for thinking out loud with me on such an important topic. I have one last pitch to make, though, so I don't think you are quite off the hook yet. ;-) I went looking and found a nearly finished copy of the SQL-2003 spec (but not the official one) at http://www.wiscorp.com/sql/sql_2003_standard.zip (subfile: 5WD-02-Foundation-2003-09.pdf). I can't imagine the final draft changing too much from what I quote below. [/snip] Most manufacturers are using ANSI SQL 99 IIRC (ymmv) which is available from ANSI (http://www.ansi.org) for a small fee. It generally takes a few years for standards to become implemented by mfgs. I think that you may be confusing search conditionals and equation operations too... WHERE foo = bar is a search condition IF(t1.foo=t2.bar, 2, 1) is an equation OK, here is the same section of SQL99 ( http://www.ncb.ernet.in/education/modules/dbms/SQL99/ansi-iso-9075-2-1999.pdf) ISO/IEC 9075-2:1999 (E) 14.10 update statement: searched (p 687) 9) The update source of each set clause is effectively evaluated for each row of T before any row of T is updated. 10) A set clause specifies one or more object columns and an update value. An object column is a column identified by an object column in the set clause. The update value is the value specified by the update source contained in the set clause. NOTE 314 The data values allowable in the object rows may be constrained by a WITH CHECK OPTION constraint. The effect of a WITH CHECK OPTION constraint is defined in the General Rules of Subclause 14.22, Effect of replacing some rows in a viewed table. I read 9) as saying that all of the source values, update source, to be used to calculate each term of each set clause shall be determined before any row updates occur. I read 10) as saying that all column changes computed by the terms of the set clause shall be based on the values stored in the update source Would a quote from SQL-92 do? (Sorry but I have lost it's source URL.) X3H2-92-154/DBL CBR-002 13.10 update statement: searched (p. 395) 6) The value expressions are effectively evaluated for each row of T before updating any row of T. 7) A set clause specifies an object column and an update value of that column. The object column is the column identified by the object column in the set clause. The update value is the value specified by the update source. Note: The data values allowable in the object row may be con- strained by a WITH CHECK OPTION constraint. The effect of a WITH CHECK OPTION constraint is defined in the General Rules of Subclause 11.19, view definition. I read 6) as saying that until you complete all of the calculations on a row, you don't change the data for the row. I could even interpret this as saying that you don't update ANY row on the table until you have completed the calculations for ALL of the rows. I read 7) as saying that you compute all new values based on a fixed set of initial values, the update source. Am I just totally confused? I do not believe that any of these specification allows the engine to see a change to a row value until after the row (or even the entire statement, depending on how you want to read the clauses dealing with value expressions or update source) completes it's processing. No, I do not believe I have confused search conditionals with assignment or equation operators. The term update statement: searched refers to updates that occur as part of a stand-alone statement (UPDATE ... SET ... WHERE ...) as compared to update statement: positioned which occurs within the processing of a cursor (WHERE = searched, CURSOR = positioned). Each type of update is handled distinctly in all three of the SQL specifications I have available to me. To me the MySQL implementation of UPDATE processing does not adhere to these standards. I can't wait for the holidays to end so that the developers can weigh in on this issue. Happy new year! Shawn Green Database Administrator Unimin Corporation - Spruce Pine
use of soundex in queries
Hi,
I need to compare names from different tables and therefore I need
to know the proper use of soundex. I googled for it, but could not find
anything useful. And select soundex('text') is no help for me.
The query should look like this:
select field from table where field like [soundexquery inserted]
As result there should be a list with the names. The comparison of
the table can also be done with php, so mainly it would be great to
know how to do resultqueries as described.
Thanks for help! Happy new year
Raphael
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: use of soundex in queries
Did you think to check the manual?
English:
http://dev.mysql.com/doc/mysql/en/String_functions.html
German
http://dev.mysql.com/doc/mysql/de/String_functions.html
French:
http://dev.mysql.com/doc/mysql/fr/String_functions.html
and your query would look like
SELECT ...
FROM ...
WHERE SOUNDEX(field1) = SOUNDEX(field2)
because you want to compare the sound of both fields to see if they are
nearly the same.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Raphael Matthias Krug [EMAIL PROTECTED] wrote on 12/31/2004 10:46:06
AM:
Hi,
I need to compare names from different tables and therefore I need
to know the proper use of soundex. I googled for it, but could not find
anything useful. And select soundex('text') is no help for me.
The query should look like this:
select field from table where field like [soundexquery inserted]
As result there should be a list with the names. The comparison of
the table can also be done with php, so mainly it would be great to
know how to do resultqueries as described.
Thanks for help! Happy new year
Raphael
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: AW: [PHP] How to argue with ASP people...
QUOTE And if you believe ASP.NET only provides a few benefits, then you are adequately informed, my friend Freddie /QUOTE I agree completely! Max Michaels Systems Engineer Right Media LLC -Original Message- From: Freddie Sorensen [mailto:[EMAIL PROTECTED] Sent: Friday, December 31, 2004 10:02 AM To: [EMAIL PROTECTED] Cc: 'mail.pmpa'; mysql@lists.mysql.com Subject: AW: AW: [PHP] How to argue with ASP people... Shawn, It is worth it for performance reasons ! And yes, I am LOOKING at the code and DEBUGGING it every single day, also without the use of VS, what's the problem ? And it is global.asax, not global.asp I and my colleagues have never had a project which we didn't get right the first time, I mean in terms of having to reinstall anything, it was always very easy And if you believe ASP.NET only provides a few benefits, then you are adequately informed, my friend Freddie _ Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 31. Dezember 2004 15:26 An: Freddie Sorensen Cc: 'mail.pmpa'; mysql@lists.mysql.com Betreff: Re: AW: [PHP] How to argue with ASP people... Have you actually LOOKED at the code (global.asp, *.asp, *.aspx, etc... ) that VS produces to make an ASP.NET application? Have you EVER had to be in the position to debug and modify that by hand (without the aid of VS)? I have. I ask that you try it before you continue your high praise for the product. I fully believe that M$ is so full of themselves for offering this as anything approaching efficient. It's designed in such a way that once you convert, you will have a very hard time getting away from it because it is SO convoluted in its execution. I feel that it's meant more to trap you into staying with their product than making life easier. I have tried (or assisted others) on more than one occasion to get ASP.NET functioning for full development support (server-side debugging, full VS integration, yadda yadda yadda) and have YET to see anyone get it right the first time. Usually we have to rip out and reinstall or update and upgrade which required us to compare and contrast several different explanations from MSDN about what may be wrong and how to fix it. Eventually, we made it work but it was never easy. IF you like it, fine. You may use it. I however recommend against it. Stick with PHP, ASP, PERL, or Python (whichever you prefer) but I personally don't think that ASP.NET is worth the effort for the few benefits it provides. Shawn Green Database Administrator Unimin Corporation - Spruce Pine Freddie Sorensen [EMAIL PROTECTED] wrote on 12/31/2004 04:01:14 AM: Tony, Check out ASP.NET and you will want to forget everything about PHP ;-) Freddie -Ursprüngliche Nachricht- Von: mail.pmpa [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 31. Dezember 2004 03:27 An: mysql@lists.mysql.com Betreff: RE: [PHP] How to argue with ASP people... Don't mean to start a discussion whatsoever, I love php, but one thing i can't do in php is Response.Redirect(page.asp) . Apart from that no complains so far :) * Happy New Year * Pedro Almeida. -Mensagem original- De: Tony Di Croce [mailto:[EMAIL PROTECTED] I am fairly new to PHP, but I am loving it... I have recently gotten involved in a business venture and I have been using PHP so far... Recently I have taken on a partner, and he is a big ASP guy... I am not totally against ASP, but it would have to be pretty good to get me to switch at this point (PHP seems to do everything I need)... But I will need to convince him of this... What points can I bring up in PHP's favor? In what areas does PHP trounce ASP? -- td -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
php mysql library and mysql 4.1.x
Hello all, I know the php manual warns that some functionality may not work if you use the regular mysql libraries with mysql versions greater than 4.1.x. I have found so far that MYSQL_ASSOC return types don't work, just wondering if anybody has found any other issues. I would just have the developers re-write the application using mysqli instead of mysql, but this is a very time sensitive issue. Any opinions/ideas appreciated? Regards, Max Max Michaels Right Media, LLC | 276 5th Avenue, Suite 605 | New York , NY 10001 xxx.xxx. | [EMAIL PROTECTED] | www.rightmedia.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: use of soundex in queries
Hi Shawn,
I printed the manual, but as I am not such a database guru I was not
able to transfer this knowlegde into an select-statement. Thanks for
your realtimehelp.
Is it possible to do an select-query with soundex like the following
examble?
select nn from table where nn !=''
my database has the field name (nn), I need to select every
namefield, which is not empty. So soundex should give me an result
with a list of names. How to do?
Thanks
Raphael
Am 31 Dec 2004 um 11:00 hat [EMAIL PROTECTED] geschrieben:
Did you think to check the manual?
English:
http://dev.mysql.com/doc/mysql/en/String_functions.html
German
http://dev.mysql.com/doc/mysql/de/String_functions.html
French:
http://dev.mysql.com/doc/mysql/fr/String_functions.html
and your query would look like
SELECT ...
FROM ...
WHERE SOUNDEX(field1) = SOUNDEX(field2)
because you want to compare the soundof both fields to see if they
are nearly the same.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Raphael Matthias Krug [EMAIL PROTECTED]wrote on 12/31/2004
10:46:06 AM:
Hi,
I need to compare names from different tables and therefore I need
to know the proper use of soundex. I googled for it, but could not
find
anything useful. And select soundex('text') is no help for me.
The query should look like this:
select field from table where field like [soundexquery inserted]
As result there should be a list with the names. The comparison of
the table can also be done with php, so mainly it would be great to
know how to do resultqueries as described.
Thanks for help! Happy new year
Raphael
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: use of soundex in queries
This will give you a list of names and their soundex values. Is this what
you want? What is it you are trying to do, there may be a better way to do
this than by getting a list and reprocessing it somehow.
SELECT nn, soundex(nn)
FROM table
WHERE nn ''
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Raphael Matthias Krug [EMAIL PROTECTED] wrote on 12/31/2004 12:42:30
PM:
Hi Shawn,
I printed the manual, but as I am not such a database guru I was not
able to transfer this knowlegde into an select-statement. Thanks for
your realtimehelp.
Is it possible to do an select-query with soundex like the following
examble?
select nn from table where nn !=''
my database has the field name (nn), I need to select every
namefield, which is not empty. So soundex should give me an result
with a list of names. How to do?
Thanks
Raphael
Am 31 Dec 2004 um 11:00 hat [EMAIL PROTECTED] geschrieben:
Did you think to check the manual?
English:
http://dev.mysql.com/doc/mysql/en/String_functions.html
German
http://dev.mysql.com/doc/mysql/de/String_functions.html
French:
http://dev.mysql.com/doc/mysql/fr/String_functions.html
and your query would look like
SELECT ...
FROM ...
WHERE SOUNDEX(field1) = SOUNDEX(field2)
because you want to compare the soundof both fields to see if they
are nearly the same.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Raphael Matthias Krug [EMAIL PROTECTED]wrote on 12/31/2004
10:46:06 AM:
Hi,
I need to compare names from different tables and therefore I need
to know the proper use of soundex. I googled for it, but could not
find
anything useful. And select soundex('text') is no help for me.
The query should look like this:
select field from table where field like [soundexquery inserted]
As result there should be a list with the names. The comparison of
the table can also be done with php, so mainly it would be great to
know how to do resultqueries as described.
Thanks for help! Happy new year
Raphael
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
Re: AW: [PHP] How to argue with ASP people...
-Ursprüngliche Nachricht- Von: mail.pmpa [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 31. Dezember 2004 03:27 An: mysql@lists.mysql.com Betreff: RE: [PHP] How to argue with ASP people... Don't mean to start a discussion whatsoever, I love php, but one thing i can't do in php is Response.Redirect(page.asp) . Apart from that no complains so far :) * Happy New Year * Pedro Almeida. I'm just a beginner-intermediate at PHP and have no experience with ASP, so take what I have to say with a grain of salt. However, isn't it usually more expensive AND more risky to work in a Microsoft environment? Sure, Microsoft fans will tell that one technology or another is free...but I think there are usually hidden price tags, somewhere along the line. After all, Microsoft is in business to make (or steal) money, right? I just think people are better off if they stay as far away from Microsoft as possible, using clean technology ahead. Apache/Linux servers are the standard, and the Mozilla Firefox/Thunderbird software are showing up Internet Explorer and Outlook Express. I believe PHP and MySQL are the standards in their field, are they not? Why get mixed up with Microsoft when you have to constantly look over your shoulder for a hidden price tag, a computer virus, security risk or some new technology devised by Bill Gates to steal your ideas or hard work? __ Do you Yahoo!? Send a seasonal email greeting and help others. Do good. http://celebrity.mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: AW: [PHP] How to argue with ASP people...
Don't mean to start a discussion whatsoever, I
love php, but
one thing i can't do in php is
Response.Redirect(page.asp) .
Apart from that no complains so far :)
Um, as I understand it this is simple to do in php. Just use:
header(Location: $somestring);
Here's the ASP code I found when I looked up what response.redirect does:
%
u_location=request.form(u_location)
if u_location then
response.redirect (u_location)
end if
%
form method=post action=redirect_varible.asp
select size=1 name=u_location
option value=http://www.goto.com;GoTo.com/option
option value=http://www.priceline.com;Priceline.com/option
option value=http://www.alladvantage.com;AllAdvantage.com/option
/select
input type=submit value=Submit
/form
Here's how I'd code the same thing is php:
?php
if isdefined($_POST[u_location]
{
$newpage = $_POST[u_location];
header(Location: $newpage);
}
form method=post action=redirect_varible.php
select size=1 name=u_location
option value=http://www.goto.com;GoTo.com/option
option value=http://www.priceline.com;Priceline.com/option
option value=http://www.alladvantage.com;AllAdvantage.com/option
/select
input type=submit value=Submit
/form
As I understand it, all response.redirect does is tell the browser to go
to another page. That's all the header function does too. I use this
all the time if people aren't authenticate to push them to the login
page or if they aren't using https to connect, to push them to the https
url.
Am I missing something here?
The only snage with the header function is that you must not print or
echo anything to the browser before you use it. In other words you
can't do this:
html
body
pI moved you to another page./p
?php header(Location: http://someotherpage.com;); ?
/body
/html
Whoops. Just realized that this was coming through the mysql lists, so
it's OT. Original poster can e-mail me off list with questions.
Bob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: AW: [PHP] How to argue with ASP people...
snip On Fri, Dec 31, 2004 at 05:17:27PM -0600, Bob Ramsey wrote: The only snage with the header function is that you must not print or echo anything to the browser before you use it. In other words you can't do this: html body pI moved you to another page./p ?php header(Location: http://someotherpage.com;); ? /body /html If you have output buffering turned on in your php.ini you can do it IMHO. -- -- Katoob Main Developer, Arabbix Maintainer. GNU/Linux registered user #224950 Proud Egyptian GNU/Linux User Group www.eglug.org Admin. Life powered by Debian, Homepage: www.foolab.org -- Don't send me any attachment in Micro$oft (.DOC, .PPT) format please Read http://www.fsf.org/philosophy/no-word-attachments.html Preferable attachments: .PDF, .HTML, .TXT Thanx for adding this text to Your signature signature.asc Description: Digital signature
please advise on mysql memory,users monitoring
First of all, thanks for the mailing list for giving details about myisamchk.we used them but we got some errors which I have reported in 'myisamchk errors' mail to mysql. At present we are working in mysql 3.23.32 ,windows xp os. Are there any system tables that store mysql related info.(like memory related issues etc). Are there any other ways to find memory used and free memory available by data tables,log files,temporary tables.We want the information so that we can use it in programs.Information available through commands could not be used in programming(For ex:myisamchk works with single table.we need to monitor entire datadirectory so we need write programs.) Thanking you, yours sincerely, sirisha. Yahoo! India Matrimony: Find your life partneronline.
phpMyAdmin w/ winXP - IIS w/PHP 4.3 w/mysql 4.1.8
Has anyone had any problems installing phpMyAdmin with the above configuration? I get an error about the mySql client and authentication methods? MySQL Error: 1251 : Client does not support authentication protocol requested by server Please assist Happy New Year Gary -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
