MySQL on NT
I've been scouting around for hosts that offer both W2k/NT support as well as mySQL, but I haven't been able round up one! is there a good reason for this? It seems to me that the hosting public is just not educated that mySQL even can run on NT. Thoughts? Dave Carter Chief Web Architect Accelerated Business Technologies, Inc. http://www.abti.net 717.464.2970 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: ASP MySQL
I use ASP and mySQL. I love it! Dave Carter Chief Web Architect Accelerated Business Technologies, Inc. http://www.abti.net 717.464.2970 -Original Message- From: L_U_I_Z [mailto:[EMAIL PROTECTED]] Sent: Monday, September 10, 2001 4:08 PM To: [EMAIL PROTECTED] Subject: ASP MySQL I'm developing an application and I have to choose a good database server. I'm considering MS SQL Server and MySQL. I haven't heard very much about MySQL, but from I've read on the web I think MySQL is Unix/Linux orientated and works well with PHP. I'm going to use a NT platform, with the IIS as web server, and I wanted to use ASP. Does MySQL fit good with IIS and ASP? Thaks. ___ Consigue tu e-mail gratuito TERRA.ES Haz clic en http://www.terra.es/correo/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Last Inserted Record Question
Access and MS-SQL Server have a method called @@IDENTITY used in retrieving the last inserted ID of a recordset. Is mySQL ok with that command. I suppose I could try it, but I'm interested in views etc. also. Dave Carter Chief Web Architect Accelerated Business Technologies, Inc. http://www.abti.net 717.464.2970 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
The Best Platform
The Best: By Dave Carter SELECT * FROM tbl_experience WHERE knowledge like '%SQL%' ORDER BY least_expense GROUP BY by no_equal; Result: MySQL Ok so it's a little hokey, but it was the best I could after the conversion project I just got out of, thank god for MySQL. Dave Carter Chief Web Architect ABT, Inc. http://www.abti.cc - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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] Email Software
LOL!!! -Original Message- From: Dan Harrington [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 18, 2001 11:47 AM To: Wee Chua; PHP (E-mail); MySQL (E-mail) Subject: RE: [PHP] Email Software try http://www.spamcop.net, they are experts in it. -Original Message- From: Wee Chua [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 18, 2001 6:50 AM To: PHP (E-mail); MySQL (E-mail) Subject: [PHP] Email Software Hi all, I need a little help from you guys. Can anyone tell what is the best software for sending million emails at a time or something like that? Where can I buy email addresses from? Thank you! Sincerely Calvin Chua -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
BLOB Resources question
Are there any online resources out there for uploading files and storing them as BLOB objects in mySQL? I'm using VBScript. Thanks, Dave - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Type Mismatch issue when Deleting from table
Platform: W2k/Advanced Server DB: mySQL 3.23.33 Language: ASP/VBScript Issue: I'm creating a backend administration program that will allow updates, deletes, additions, etc. All is well expect for in one table in particular when I choose to delete a record it gives me a type mismatch Error. I've written this code before on other pages without trouble, but this one table in particular is causing trouble. Here is the SQL statement on the ASP page: DELETE FROM tbl_headline WHERE head_id = + Replace(deleteheadline, ', '') + Now head_id is an Integer, and so is deleteheadline, but it gives me a type mismatch error everytime. I've even modded the code in several ways trying to get around it, like instead of matching the head_id I will match up the headline_name field with the same results or making it a text string by putting apostrophe's in etc.. I know the deleteheadline variable has a numerical value because I response.write the variable before the error occurs. Any help you be greatly appreciated. Thanks, Dave Carter Chief Web Architect Accelerated Business Technologies, Inc. http://www.abti.cc 717.464.2970 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Does not match
Can I show records from my SQL statement where records both have a match and do NOT have a match. I'm having trouble with the syntax for no matching records in a related table, my current SQL statment looks like this: SELECT fid,Family_Last_Name,Phone FROM familytable,playertable WHERE playertable.Family_ID = familytable.fid AND playertable.SportRegistered = '0' GROUP BY fid ORDER BY Family_Last_Name ASC; This works fine, but I also want to show Families with NO matching records in the player field, which the above statement does not do. TIA, Dave Carter Chief Web Architect Accelerated Business Technologies, Inc. http://www.abti.cc 717.464.2970 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
LAST_INSERT_ID Issues
This does not return any results SELECT LAST_INSERT_ID() FROM tablename; there is an indexed, auto-incrementing field in the table, but it refuses to show any results. I don't understand the manual's text, so any help would be appreciated. Dave Carter Chief Web Architect Accelerated Business Technologies, Inc. http://www.abti.cc 717.464.2970 g sql,database - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: LAST_INSERT_ID Issues
So in my insert into select, I would just add another Select Like this: INSERT INTO tablename (field1,field2,field3) SELECT table2.field1, table2.field2, table2.field3 FROM table2 SELECT LAST_INSERT_ID(); Dave Carter Chief Web Architect Accelerated Business Technologies, Inc. http://www.abti.cc 717.464.2970 Filter Lovin: sql, database, query -Original Message- From: Billy Passauer [mailto:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 10:18 AM To: Dave Carter Subject: RE: LAST_INSERT_ID Issues -Original Message- From: Dave Carter [mailto:[EMAIL PROTECTED]] This does not return any results SELECT LAST_INSERT_ID() FROM tablename; What did you do prior to executing the statement? If you didn't do an INSERT into a table that has an autoincrement field (while using the same connection), you won't see any results. Well, actually I just tried that and it returned 0 (zero) - is that what you mean when you say it doesn't return any results? If I do what you said, I get a zero returned for each row that is in the table. BTW, drop the FROM tablename, the syntax is just: SELECT LAST_INSERT_ID(); ... Billy ... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: LAST_INSERT_ID Issues
No results not even a zero. So what I did was something like this: INSERT INTO table1 (field1,field2,field3) SELECT table2.field1, table2.field2, table2.field2 FROM table2 WHERE table2.UID = SomeVariable; SELECT MAX(table1.UID) FROM table1; --- Now this assumes that UID is the unique ID number. Can you see a flaw in this logic? Dave Carter Chief Web Architect Accelerated Business Technologies, Inc. http://www.abti.cc 717.464.2970 -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 4:25 PM To: Dave Carter; [EMAIL PROTECTED] Subject: Re: LAST_INSERT_ID Issues At 9:48 AM -0400 5/25/01, Dave Carter wrote: This does not return any results SELECT LAST_INSERT_ID() FROM tablename; It doesn't return *any* results? Or do you mean it returns 0? FROM tablename is superfluous here; the most recent AUTO_INCREMENT value is maintained on a per-connection basis. This means that if you want to use this value, you must: - Issue some statement (e.g., INSERT) that causes an AUTO_INCREMENT value to be generated, and - You must select the value of LAST_INSERT_ID() within the *same* session. If you issue the INSERT, then disconnect, reconnect, and retrieve the value of LAST_INSERT_ID(), it won't work (you'll get zero), because that involves two sessions with the server, not one. there is an indexed, auto-incrementing field in the table, but it refuses to show any results. I don't understand the manual's text, so any help would be appreciated. Dave Carter Chief Web Architect Accelerated Business Technologies, Inc. http://www.abti.cc 717.464.2970 g sql,database -- Paul DuBois, [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
Case question on inserting data
Is there a way inside of mysql to force the case of data being inserted into the database??? Dave Carter Chief Web Architect Accelerated Business Technologies, Inc. http://www.abti.cc 717.464.2970 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Basic Beginner Question
my experience with web hosts is that they usually give you one database per domain name hosted. So you likely CAN'T create another db that you can administer in this fashion. bummer, Dave Carter Chief Web Architect Accelerated Business Technologies, Inc. http://www.abti.cc 717.464.2970 -Original Message- From: Savin, Jill [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 24, 2001 12:27 PM To: [EMAIL PROTECTED] Subject: Basic Beginner Question I am brand new to MySQL - my web host has set up a graphical tool for me to use, to try and administer it - it's called MysqlTool, Version 0.85. It's got a database there that my host created for me. Now I want to create an additional database, but don't see any kind of button for doing that. If I go inside the database he already created, I can find a prompt that says Execute SQL Statement or Generate Create Table Script, and a New Table - would either of these links allow my to create a new database? And if so, how would I do it? thanks j - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
works in SQL not on page
When I execute this in mysql it works fine, but when I execute it on a web page it gives a Not Unique table/alias 'sporttable' I would expect errors if 'playerpayment' was in my FROM clause but as you can see it is not. Note my example: INSERT INTO playerpayment ( Family_ID, Player_ID, Player_Fee, Sport_ID ) SELECT playertable.Family_ID, playertable.pid, sporttable.Category_1_Fee, sporttable.sid FROM sporttable, playertable WHERE sporttable.sid = playertable.SportRegistered AND (((playertable.Grade)=sporttable.Category_1_Grade_Start And (playertable.Grade)sporttable.Category_2_Grade_Start)) GROUP BY playertable.Family_ID, playertable.pid, sporttable.Category_1_Fee, sporttable.sid; mysql running on W2K-Advanced version: 3.23.33 TIA Dave Carter Chief Web Architect Accelerated Business Technologies, Inc. http://www.abti.cc 717.464.2970 (mail filter bologna: sql,database,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
Advice on Random Numbers
I need to generate a RANDOM UNIQUE number for every new record. Is there an easy way to accomplish this inside of mySQL. TIA Dave Carter Chief Web Architect Accelerated Business Technologies, Inc. http://www.abti.cc 717.464.2970 (mail filter bologna: sql,database,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: Porting Access to MySQL
www.accessmysql.com I use it when doing conversions free download too Cost ya 30 dollars US not get annoying messages every 5 or 10 minutes Dave Carter Chief Web Architect Accelerated Business Technologies, Inc. http://www.abti.cc 717.464.2970 -Original Message- From: Mitchell [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 22, 2001 6:43 PM To: [EMAIL PROTECTED] Subject: Porting Access to MySQL Hi, I have a user who want to move there database from Access to MySQL. Are there tools available to make the conversion simple, or what is the best way of going about this? 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Advice needed....
Well I was hoping to be able to do it in SQL, however I do know it can be accomplished in the middleware. I am seriously considering it as my deadline is approaching quickly Dave Carter Chief Web Architect Accelerated Business Technologies, Inc. http://www.abti.cc 717.464.2970 -Original Message- From: clay bond [mailto:[EMAIL PROTECTED]] Sent: Saturday, May 19, 2001 6:51 PM To: [EMAIL PROTECTED] Subject: Re: Advice needed On Sat, 19 May 2001, Dave Carter wrote: I'm converting an Access db to mySQL, and Access allows users to Insert Records into a table AND call them as well in the FROM clause. This is illeagal in ANSI SQL however and therefore illeagal in mySQL, but I don't know really how to get around it. How can I insert only new records that aren't already in a table, without calling the table first? Can this be done in SQL? But you're not working only with SQL, are you? Like transactions or foreign keys, you can easily do this in your middleware, whatever that might be (PHP, Perl, Coldfusion, whatever). Select first, then check to see if it's there, and if it isn't, insert it. A simple if-statement will do the job, so what's the problem? -- /\ \ /ASCII RIBBON CAMPAIGN X AGAINST HTML EMAIL / \AND POSTINGS - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
UPDATE
Is this ok? UPDATE table1 SET table1.field1 = table2.field1 SELECT table1.field1, table1.field2, table2.field1, table2.field2, table2.field3 FROM table1, table2 WHERE table1.field2 BETWEEN table2.field2 AND table2.field3 HAVING table1.field1 IS NULL; I know there's a lot of rules about the update clause, but I find the documentation not satisfying. Can I use all these clasues in an update sql statement, assuming 3.22.32 on RH 6.2 Dave Carter Chief Web Architect Accelerated Business Technologies, Inc. http://www.abti.cc 717.464.2970 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: UPDATE
Using temp table... thanks I don't understand why this isn't legitimate SQL however. I would think that it should be supported Dave Carter Chief Web Architect Accelerated Business Technologies, Inc. http://www.abti.cc 717.464.2970 -Original Message- From: Don Read [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 20, 2001 7:38 PM To: Dave Carter Cc: [EMAIL PROTECTED] Subject: RE: UPDATE On 20-May-01 Dave Carter wrote: Is this ok? UPDATE table1 SET table1.field1 = table2.field1 SELECT table1.field1, table1.field2, table2.field1, table2.field2, table2.field3 FROM table1, table2 WHERE table1.field2 BETWEEN table2.field2 AND table2.field3 HAVING table1.field1 IS NULL; No, UPDATE ... JOIN is not supported (not sure if standard SQL allows it). Use a temp table, or script the updates. check the comments : http://www.mysql.com/doc/U/P/UPDATE.html Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do 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
Advice needed....
I'm converting an Access db to mySQL, and Access allows users to Insert Records into a table AND call them as well in the FROM clause. This is illeagal in ANSI SQL however and therefore illeagal in mySQL, but I don't know really how to get around it. How can I insert only new records that aren't already in a table, without calling the table first? Can this be done in SQL? Dave Carter Chief Web Architect Accelerated Business Technologies, Inc. http://www.abti.cc 717.464.2970 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 regarding ASP+MySQL in NT with IIS (web server)
Our solution to this was installing myODBC on the NT Server and connecting in this fashion: Dim Conn_STRING Conn_STRING = driver={mysql};database=dbname;uid=uname;pwd=password;option=16386; set rsRecordSet = Server.CreateObject(ADODB.Recordset) rsRecordSet.ActiveConnection = Conn_STRING This assumes VBScript On an off note, I suggest you make the connection string an include file, so that if the name changes or the pw changes or whatever, you will not have to change every page in your site. Hope this helps you, Dave Carter Chief Web Architect Accelerated Business Technologies, Inc. http://www.abti.cc 717.464.2970 -Original Message- From: ASHUTOSH SHARMA [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 7:51 AM To: [EMAIL PROTECTED] Subject: problem regarding ASP+MySQL in NT with IIS (web server) respected sir, i have a problem regarding connectivity between ASP and mysql. will it possible to connect asp with mysql if yes then how we can do it will it need any driver if yes then from where we get that driver .. will i get some tutoril in this matter... thanking you ashutosh - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: ISAM v.s. MYISAM
I'm working a project with the same exact scenario right now. My ver. of mySQL is 3.23.xx and my client's is 3.22.xx. there table sturcturing is ISAM and mine is myISAM. The only I've been able to transfer succesfully is by dumping all the data and re-importing on the clients end. -Original Message- From: Warren van der Merwe [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 7:27 AM To: [EMAIL PROTECTED] Subject: ISAM v.s. MYISAM Hi there I am working on a site where they are using ISAM files, (.ISM .IS1), I want to know if there is a way of accessing these from MYSQL? From what I have been able to tell they appear totally differently in comparison to some of my MYISAM table when I open them in Notepad. Can anyone shed some light? ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL 4.0 FULLTEXT SPEED
correct me if I'm mistaken, but I believe the latest version of mysql is 3.23.38 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, May 15, 2001 1:04 PM To: [EMAIL PROTECTED] Subject: MySQL 4.0 FULLTEXT SPEED Hi Everyone, I've compiled the mysql 4.0 version on my computer to test the speed of creating full text indexes. I read that it was supposed to be 100 x faster than 3.23. However, it seems just as slow to me. I've been building an index on my 400+MB table for 5 days now. Does anyone have any experience with 4.0 to know how the FULLTEXT indexing is working. Would you say that it's much faster than 3.23? P - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: problem updating recordset with MyODBC
I've encountered this before. Several of my clients use mySQL and most of them Linux, however my servers that run mySQL all are W2k. The issue happened like you said when migrating data from w2k to linux. It was a few versions ago in 3.22 however, but the auto-increment field didn't translate for some reason, and so when people inserted records on the linux-mysql version of the db, it didn't auto-increment in the field it was supposed to. The error would happen when I would call the data/update it, and it would look for the field with the auto-increment data, and lo- it was not there hence the error. Check to make sure any auto-increment data is inserting like it should. my (2cents(US)) (2.5 cents(UK)) (.9 cents(CA)) (God only know how many pesos, rubbles, yen, or euros) Dave Carter Chief Web Architect Accelerated Business Technologies, Inc. http://www.abti.cc 717.464.2970 -Original Message- From: David S. Green [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 1:06 PM To: [EMAIL PROTECTED] Subject: problem updating recordset with MyODBC When I try and update a recordset I get the following problem- Microsoft OLE DB Provider for ODBC Drivers error '80004005' Query based update failed. The row to update could not be found. /Part1_Section1_Process.asp, line 82 Line 82 happens to be when I call rs.Update() The problem only occurs when I update certain records. Other records have no problems. Before I had no problems (all records were fine updating). Then I migrated my tables from Win2000 mySQL to a mySQL running on Linux. That is when I noticed that it would not update in some cases. It isn't clear why some records give me problems and others do not. What makes it frustrating is that there seems to be no obvious cause of problem. The code has not been altered one bit. If I move back to Win2000 I'm sure it will work again. But I really want this to work consistently for our Linux DB server. Has anybody seen anything like this before. Can anybody help? David -- David Green Northwestern University, Evanston, IL USA [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