Re: How do you set a Primary Key when uploading data into a table?
If you are clearing table. Truncate will reset auto_increment to 0 - Original Message - From: Bill Abel [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Monday, October 10, 2005 12:10 PM Subject: How do you set a Primary Key when uploading data into a table? How do you load data into a table and generate a primary key which auto increments by 1. I want to end up with a primary key value of int 1, 2, 3, 4, and so on. My table has three rows, Id (pri_key), Code, Description. I'm loading data from a text file into the table like this: load data local infile 'path_to_myfile.txt' into table sic_codes lines terminated by '\r' (code, description); Currently, the Id gets values of 99897, and then increments by one. Any help is appreciated. -- 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]
Problem detected this morning.
What is this all about? McAfee caught this problem. It was in \data as ofiqa.dll I couldn't delete it until I stopped the MySQL service. 8/5/2005 8:03:39 AM Deleted NT AUTHORITY\SYSTEM mysqld-nt.exe D:\mysql\data\ofiqa.exe W32/Sdbot.worm.gen.by (Virus) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Triggers
Am I reading the documentation correctly. I cannot us a trigger to insert a record into an other table??? I use triggers on other dbms to create an acivity histoy table. Fredrick -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Visual Basic .NET Oledb Provider
Why not use the .NET provider... http://dev.mysql.com/downloads/connector/net/1.0.html - Original Message - From: Leonardo Javier Belén [EMAIL PROTECTED] To: Dev - MySQL - MList mysql@lists.mysql.com Sent: Wednesday, June 15, 2005 7:24 AM Subject: Visual Basic .NET Oledb Provider Hi all, I would need an oledb provider for MySQL. Do you know where I can found a good one. Thanks in advance. Leonardo J. Belén. A-AR -- 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]
Why building obsolete versions.
The documentation indicates that there are three active versions being worked on. Is this true? Why not just release the current one with the most bug fixes? D.1.1. Changes in release 5.0.7 (not released yet) D.1.2. Changes in release 5.0.6 (not released yet) D.1.3. Changes in release 5.0.5 (to be released soon) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Crystal Reports MySQL
Hmmm, they repeated several times... Under the agreement, Business Objects will embed MySQL database technology into BusinessObjects XI for use on the Linux and UNIX Linux and UNIX how can they determine the server is not running on Win32??? Strange. Crystal Reports is a Win32 app. - Original Message - From: Scott Pippin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Thursday, April 28, 2005 7:10 AM Subject: Re: Crystal Reports MySQL I haven't tested it but I am using version 10 with no problems. See the announcement made by business objects at the MySQL users conference: http://www.mysql.com/news-and-events/press-release/release_2005_10.html I hope this helps. Scott Pippin [EMAIL PROTECTED] Kerry Frater [EMAIL PROTECTED] 04/28/05 6:09 AM I have MySQL the downloaded ODBC drivers. I am looking to use Crystal Reports to design run my own reports on my tables. Can anyone tell me if the V11 Standard will happily work with MySQL or do I need a different version? Kerry
Re: MySQL 5.0.4-beta has been released
Hmmm, it ran for about two hours (Win32) then crashed. I don't receive any error messages to post. Server just stops??? - Original Message - From: Martijn Tonies [EMAIL PROTECTED] To: Joerg Bruehe [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: MySQL General List mysql@lists.mysql.com; [EMAIL PROTECTED] Sent: Tuesday, April 19, 2005 2:42 AM Subject: Re: MySQL 5.0.4-beta has been released A new version of MySQL Community Edition 5.0.4-beta Open Source database management system has been released. This version now includes support for Stored Procedures, Triggers, Views and many other features. It is now available in source and binary form for a number of platforms from our download pages at http://dev.mysql.com/downloads/ and mirror sites. Woohoo, it works on Windows :-) One thing that it doesn't do yet though, is saving the view definition in a human readable way instead of that auto-generated gibberish :-) With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL Server Upscene Productions http://www.upscene.com -- 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: MySQL 5.0.4-beta has been released
Here are the sequence of queries that executed before the server crashed... CREATE TEMPORARY TABLE COMETTRACKER.DELIVERY_TRACKING_ETA ( PACKAGEID BIGINT NOT NULL, RECID_CTASKDATA BIGINT , RECTYPE INT(11) , USERID INT(11) , TIMETAG1 DATETIME , TIMETAG2 DATETIME , P_DATA1 VARCHAR(20) , P_DATA2 VARCHAR(20) , SEQVALUE INT(11) , SEQUENCE_NUM_TRIP INT(11) , COMPANY_CD VARCHAR(6), PRODUCT_CD CHAR(2), IO_NUM VARCHAR(4), BARCODE VARCHAR(25), SEQCODE VARCHAR(6), SEQCODE1 VARCHAR(6), PRIMARY KEY (PACKAGEID), UNIQUE RECIDTASKDATA(RECID_CTASKDATA), KEY COCODE (COMPANY_CD, PRODUCT_CD) ) INSERT INTO COMETTRACKER.DELIVERY_TRACKING_ETA( PACKAGEID, RECID_CTASKDATA, RECTYPE, USERID, TIMETAG1, TIMETAG2, P_DATA1, P_DATA2, SEQVALUE, SEQUENCE_NUM_TRIP, COMPANY_CD, PRODUCT_CD, IO_NUM, BARCODE, SEQCODE, SEQCODE1) SELECT PACKAGEID, RECID_CTASKDATA, RECTYPE, USERID, TIMETAG1, TIMETAG2, P_DATA1, P_DATA2, SEQVALUE, SEQUENCE_NUM_TRIP, COMPANY_CD, PRODUCT_CD, IO_NUM, BARCODE, SEQCODE, SEQCODE1 FROM COMETTRACKER.DELIVERY_TRACKING WHERE TRIP_DATE = 20050519 AND P_DATA1 = 14 AND USERID = 21234 ORDER BY RECID_CTASKDATA CREATE TEMPORARY TABLE COMETTRACKER.DELIVERY_TRACKING_SORT SELECT MIN(SEQVALUE) SEQVALUE, COMPANY_CD, PRODUCT_CD, IO_NUM FROM COMETTRACKER.DELIVERY_TRACKING_ETA WHERE P_DATA1 = 14 AND (P_DATA2 = OR P_DATA2 IS NULL) GROUP BY COMPANY_CD ORDER BY COMPANY_CD UPDATE COMETTRACKER.DELIVERY_TRACKING_ETA D, COMETTRACKER.DELIVERY_TRACKING_SORT S SET D.SEQVALUE = S.SEQVALUE WHERE (D.P_DATA2 = OR D.P_DATA2 IS NULL) AND (S.COMPANY_CD = D.COMPANY_CD AND S.PRODUCT_CD = D.PRODUCT_CD AND S.IO_NUM = D.IO_NUM) This query below did not execute because Server Had Gone Away UPDATE COMETTRACKER.DELIVERY_TRACKING D, COMETTRACKER.DELIVERY_TRACKING_ETA E SET D.SEQVALUE = E.SEQVALUE WHERE (E.PACKAGEID = D.PACKAGEID) - Original Message - From: Reggie Burnett [EMAIL PROTECTED] To: Fredrick Bartlett [EMAIL PROTECTED] Cc: MySQL General List mysql@lists.mysql.com Sent: Tuesday, April 19, 2005 8:00 AM Subject: Re: MySQL 5.0.4-beta has been released What were you doing when it failed? What type of connections was it handling? Hmmm, it ran for about two hours (Win32) then crashed. I don't receive any error messages to post. Server just stops??? - Original Message - From: Martijn Tonies [EMAIL PROTECTED] To: Joerg Bruehe [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: MySQL General List mysql@lists.mysql.com; [EMAIL PROTECTED] Sent: Tuesday, April 19, 2005 2:42 AM Subject: Re: MySQL 5.0.4-beta has been released A new version of MySQL Community Edition 5.0.4-beta Open Source database management system has been released. This version now includes support for Stored Procedures, Triggers, Views and many other features. It is now available in source and binary form for a number of platforms from our download pages at http://dev.mysql.com/downloads/ and mirror sites. Woohoo, it works on Windows :-) One thing that it doesn't do yet though, is saving the view definition in a human readable way instead of that auto-generated gibberish :-) With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL Server Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
5.03 Still crashes on win32
Warning, do not install 5.03 it still crashes on win32. This occured after very few minutes of testing. I will send more info as I locate it. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 5.03 Still crashes on win32
Where do I look for the server stopping error. The .err file looks happy with no error listed after server crashes and stops. Here is the last entry... 050328 10:34:30 InnoDB: Started; log sequence number 0 43634 050328 10:34:30 InnoDB: Starting recovery for XA transactions... 050328 10:34:30 InnoDB: 0 transactions in prepared state after recovery 050328 10:34:30 [Warning] 'db' entry 'socaldata [EMAIL PROTECTED]' had database in mixed case that has been forced to lowercase because lower_case_table_names is set. It will not be possible to remove this privilege using REVOKE. 050328 10:34:30 [Warning] 'db' entry 'socaldata [EMAIL PROTECTED]' had database in mixed case that has been forced to lowercase because lower_case_table_names is set. It will not be possible to remove this privilege using REVOKE. 050328 10:34:35 [Note] MySQL: ready for connections. Version: '5.0.3-beta-nt' socket: '' port: 3306 Official MySQL binary - Original Message - From: Fredrick Bartlett [EMAIL PROTECTED] To: [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Monday, March 28, 2005 10:13 AM Subject: 5.03 Still crashes on win32 Warning, do not install 5.03 it still crashes on win32. This occured after very few minutes of testing. I will send more info as I locate it. -- MySQL Windows Mailing List For list archives: http://lists.mysql.com/win32 To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 5.0.2 alpha crashes with Query Browser
imminent Dictionary imminent (m'-nnt) adj. About to occur; impending: in imminent danger. - Original Message - From: "Lily Wei" [EMAIL PROTECTED] To: [EMAIL PROTECTED]; "Francisco Tapia" [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Thursday, March 17, 2005 11:47 AM Subject: RE: 5.0.2 alpha crashes with Query Browser When will 5.0.3 come out?Thanks,Lily-Original Message-From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: Thursday, March 17, 2005 10:17 AMTo: Francisco TapiaCc: mysql@lists.mysql.comSubject: Re: 5.0.2 alpha crashes with Query BrowserLots of users report such instabilities in the 5.0.2-alpha build for Windows. We went back to 5.0.1.PB-Francisco Tapia wrote:Maybe it's my setup... but:whenever I try to login to use the mySQL query browser, it instantllyturns off the 5.0.2 alpha mySQL instance (stops running). the error Iget is:mysqld-max-nt.exe - Application Errorthe instruciton at "0x00538d34" referenced memory at "0x007f9000". Thememory could not be "read".Running Win2k pro w/ 512mb of ram. -- No virus found in this outgoing message.Checked by AVG Anti-Virus.Version: 7.0.308 / Virus Database: 266.7.3 - Release Date: 3/15/2005-- MySQL General Mailing ListFor list archives: http://lists.mysql.com/mysqlTo unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]-- MySQL General Mailing ListFor list archives: http://lists.mysql.com/mysqlTo unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
Re: can 5.0.2 be built for Solaris 8
When will the 5.0.3 binaries be available? Thanks, Fredrick - Original Message - From: Joerg Bruehe [EMAIL PROTECTED] To: mysql@lists.mysql.com Cc: James Black [EMAIL PROTECTED] Sent: Monday, February 21, 2005 11:45 AM Subject: re: can 5.0.2 be built for Solaris 8 Hi James! Am Mo, den 21.02.2005 schrieb James Black um 14:20: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I have tried to compile mysql, and got some linking errors. Any chance a binary for Solaris 8 can be made available? Solaris 8 is a supported platform, and we (try to) generate binaries for it. However, with 5.0.2 (which is still an alpha release!) we must have had some problems on it, or else we would have published it. Then, work on other releases was more important. As we are currently working on 5.0.3-alpha (which is also being built on Solaris 8, and has significant improvements), we will not go back to 5.0.2. If compiling from source does not work for you, please wait for 5.0.3 (and then tell us your experiences with it). Regards, Joerg Bruehe -- Joerg Bruehe, Senior Production Engineer MySQL AB, www.mysql.com Are you MySQL certified? www.mysql.com/certification -- 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: MySQL 5.0.2-alpha-nt highly instable?
This bug was fixed and closed several weeks ago. I guess because it only affected win32 it isn't considered a real bug because it was never listed in the documentation that it was fixed. Yes you are right Win32 5.0.2 is completely unuseable. If it was a *nix build we would have had a 5.0.2x a long time ago. Bug #6955 SHOW PROCEDURE STATUS crashes the server Bugs fixed: a.. Fixed a bug which caused server crash if some error occurred during filling of temporary table created for derived table or view handling. (Bug #7413) b.. Fixed a bug which caused server crash if query containing CONVERT_TZ() function with constant arguments was prepared. (Bug #6849) c.. Prevent adding CREATE TABLE .. SELECT query to the binary log when the insertion of new records partially failed. (Bug #6682) d.. Fixed a bug which caused a crash when only the slave I/O thread was stopped and started. (Bug #6148) e.. Giving mysqld a SIGHUP caused it to crash. f.. Changed semantics of CREATE/ALTER/DROP DATABASE statements so that replication of CREATE DATABASE is possible when using --binlog-do-db and --binlog-ignore-db. (Bug #6391) g.. A sequence of BEGIN (or SET AUTOCOMMIT=0), FLUSH TABLES WITH READ LOCK, transactional update, COMMIT, FLUSH TABLES WITH READ LOCK could hang the connection forever and possibly the MySQL server itself. This happened for example when running the innobackup script several times. (Bug #6732) h.. mysqlbinlog did not print SET PSEUDO_THREAD_ID statements in front of LOAD DATA INFILE statements inserting into temporary tables, thus causing potential problems when rolling forward these statements after restoring a backup. (Bug #6671) i.. InnoDB: Fixed a bug no error message for ALTER with InnoDB and AUTO_INCREMENT (Bug #7061). InnoDB now supports ALTER TABLE...AUTO_INCREMENT = x query to set auto increment value for a table. j.. Made the MySQL server accept executing SHOW CREATE DATABASE even if the connection has an open transaction or locked tables; refusing it made mysqldump --single-transaction sometimes fail to print a complete CREATE DATABASE statement for some dumped databases. (Bug #7358) - Original Message - From: Michael Kofler [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Wednesday, December 29, 2004 7:46 AM Subject: RE: MySQL 5.0.2-alpha-nt highly instable? Is it just me or is the current Alpha build of MySQL 5.0 HIGHLY instable? 5.0.2 on Windows is completely unusable for me too; crashes constantly the Linux version seems to be fine, at least in my tests Michael Kofler -- 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: Problems Moving from 3.23 to 4 (Win2k)
Shut down mysql then in your my.cnf add old-passwords directive. Then copy your user tables again from your backup. You should be ok now. Fredrick - Original Message - From: A. Clausen [EMAIL PROTECTED] To: MySQL Mailing List [EMAIL PROTECTED] Sent: Friday, December 10, 2004 3:33 PM Subject: Problems Moving from 3.23 to 4 (Win2k) I made a copy of my entire Mysql 3.23 data directory and moved it on to a box with a fresh install of MySQL 4. While the NT service starts up fine (I'm using 4.0.22-nt-max), I can't login. I know that there are supposed to be mods made to the mysql database tables, but I thought there was at least a minimum compatibility. The only way to get access to anything is to shut down MySQL, put in the default table that came with the install. What am I doing wrong here? -- A. Clausen [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]
Re: Comparing bug in 4.1.7
I upgraded from 5.01 to 5.02 and now I am getting the error localhost is not allowed to connect to this MySQL server. What should I do, root cannot connect a well. I'm currently using win32 and have old-passwords in my.cnf Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Upgrade 5.01 to 5.02
Sorry, forgot to change the subject in previous message. I upgraded from 5.01 to 5.02 and now I am getting the error localhost is not allowed to connect to this MySQL server. What should I do, root cannot connect a well. I'm currently using win32 and have old-passwords in my.cnf Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Upgrade 5.01 to 5.02
Hmmm, found the problem. In previous versions the installer did not delete and write over existing tables in the mysql database. Good thing I had the database backed up. Be careful all... Fredrick - Original Message - From: Fredrick Bartlett [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 02, 2004 8:56 AM Subject: Upgrade 5.01 to 5.02 Sorry, forgot to change the subject in previous message. I upgraded from 5.01 to 5.02 and now I am getting the error localhost is not allowed to connect to this MySQL server. What should I do, root cannot connect a well. I'm currently using win32 and have old-passwords in my.cnf Thanks -- 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]
5.02 Shuts down on win32
When I try to connect from a remote client 5.02 shuts down with no errors reported in .err file. Fredrick -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
More on 5.02 server crash
MySQL Query Browser 1.1.2 causes 5.02 mysqld-nt.exe server crash as well remote and local. Fredrick -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: data deleted in MySQL but table file (.MYD) remains same size
Why not TRUNCATE table... - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: gerald_clark [EMAIL PROTECTED]; Craig Cummings [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, November 09, 2004 11:21 AM Subject: Re: data deleted in MySQL but table file (.MYD) remains same size At 13:06 -0600 11/9/04, gerald_clark wrote: Craig Cummings wrote: Hi there, I have a table with three columns, two varchar(12) identifiers and a longtext column with very long (some 50 MB) strings. The size of the chromosomes.MYD table was about 2.8 GB. The table was used transiently and I no longer needed to store the strings, so in the interest of freeing up space I did the following: mysql UPDATE chromosomes SET sequence = ; When I query the database I can see that the sequence field is a null string for each record. However, the size of the chromosomes.MYD file in the data directory has not changed (i.e. it is still about 2.8 GB). SHOW TABLE STATUS (in mysql) and df (at the shell prompt) both report the same value. How can I get the table size to correspond to the small amount of data that actually remains in the table? Thanks for your assistance. Dump it, delete it, and reload it. Files never get smaller, only bigger. For MyISAM tables, you could also use OPTIMIZE TABLE. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- 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: ANNOUNCE: MySQL Query Browser 1.1.0 and Administrator 1.0.14 released
Trying to build from IDE. Unicode Editor will not compile because of missing StringContainers.dcu Where can find StringContainers unit? Thanks - Original Message - From: Alfredo Kengi Kojima [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, November 02, 2004 7:17 PM Subject: ANNOUNCE: MySQL Query Browser 1.1.0 and Administrator 1.0.14 released MySQL Query Browser 1.1.0 Gamma and MySQL Administrator 1.0.14 have just been released for Windows and Linux. This is the first gamma release of Query Browser, a graphical query shell and SQL script editor. Feature highlights: - perform queries and edit resultsets; - export resultsets to CSV, HTML and XML; - syntax highlighting SQL script editor; - query bookmarks and history, allowing easy retrieval of often used queries; - compare query results side-by-side; - create master-detail queries. Select a row in one resultset and update a second query, using values from the selectd row; - much more This release contains an extensive list of improvements, most notably the support for MySQL 5 features, such as Stored Procedures, Functions and Views: - support for stored procedures which return multiple resultsets - support for creating and editing Stored Procedures, Functions and Views - many UI improvements MySQL Administrator is a GUI management console for MySQL, with support for tasks such as managing users, configuring MySQL, editing table definitions etc. More details in: http://www.mysql.com/products/administrator/ This version fixes some bugs and contains some improvements. Both tools are freely available under the GPL and can be downloaded in binary or source forms, for Windows and Linux, from: http://dev.mysql.com/downloads/administrator/ and http://dev.mysql.com/downloads/query-browser/ Note that not all mirror sites may be up-to-date at this point. If you cannot find this version on a particular mirror, please try again later or choose another download site. -- Alfredo Kojima, GUI Developer MySQL AB, www.mysql.com Buenos Aires, Argentina Are you MySQL certified? www.mysql.com/certification -- 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]
Extract MySQL Version
I use the following to extract the version number. But it throws an error on newer version 5.xx. It works on version 4.0 and below. SELECT SUBSTRING(VERSION(),1,LOCATE(-,VERSION())-1) AS VERSION On version 5.0.1-alpha-nt-log I get an error... Illegal mix of collations (utf8_general_ci,IMPLICIT)and(latin1_SWEEDIH_CI,coercible) for operation 'locate' Is this problem by design? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Time series
Hmmm... First: select * from table1 order by field1 asc limit 1 Last: select * from table1 order by field1 desc limit 1 - Original Message - From: Schulman, Michael [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 01, 2004 6:47 PM Subject: Time series Hi, I work for a large financial instituition. We are currently evaluating databases to store intraday stock data. These are large tables with 40 million rows per day. We've done some initial testing with MySQL and have been extremely impressed with its speed and ease of use. I know that it goes agains the SQL standard but adding a FIRST,LAST aggregate function along with some other time series functions would allow mysql to compete with just about any timeseries database, and open up mysql to a huge market of financial firms. I know my firm would most likely purchase it.Has anyone developed anyhting like this as an add on? Thanks, Mike -- This message is intended only for the personal and confidential use of the designated recipient(s) named above. If you are not the intended recipient of this message you are hereby notified that any review, dissemination, distribution or copying of this message is strictly prohibited. This communication is for information purposes only and should not be regarded as an offer to sell or as a solicitation of an offer to buy any financial product, an official confirmation of any transaction, or as an official statement of Lehman Brothers. Email transmission cannot be guaranteed to be secure or error-free. Therefore, we do not represent that this information is complete or accurate and it should not be relied upon as such. All information is subject to change without notice. -- 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: Time series
Is Hour a DateTime? If so, will this work... SELECT ticker, DATE_FORMAT(Hour,'%H' ), min(price), max(price) from pricedata order by DATE_FORMAT(Hour,'%H' ) group by DATE_FORMAT(Hour,'%H' ) - Original Message - From: Schulman, Michael [EMAIL PROTECTED] To: 'Fredrick Bartlett' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, January 01, 2004 6:59 PM Subject: RE: Time series That only returns one number.. what we are really looking for is something like SELECT ticker, hour, first(price), last(price) from pricedata group by hour Sorry for the confusion. Thanks, Mike -Original Message- From: Fredrick Bartlett [mailto:[EMAIL PROTECTED] Sent: Thursday, January 01, 2004 9:57 PM To: Schulman, Michael; [EMAIL PROTECTED] Subject: Re: Time series Hmmm... First: select * from table1 order by field1 asc limit 1 Last: select * from table1 order by field1 desc limit 1 - Original Message - From: Schulman, Michael [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 01, 2004 6:47 PM Subject: Time series Hi, I work for a large financial instituition. We are currently evaluating databases to store intraday stock data. These are large tables with 40 million rows per day. We've done some initial testing with MySQL and have been extremely impressed with its speed and ease of use. I know that it goes agains the SQL standard but adding a FIRST,LAST aggregate function along with some other time series functions would allow mysql to compete with just about any timeseries database, and open up mysql to a huge market of financial firms. I know my firm would most likely purchase it. Has anyone developed anyhting like this as an add on? Thanks, Mike -- This message is intended only for the personal and confidential use of the designated recipient(s) named above. If you are not the intended recipient of this message you are hereby notified that any review, dissemination, distribution or copying of this message is strictly prohibited. This communication is for information purposes only and should not be regarded as an offer to sell or as a solicitation of an offer to buy any financial product, an official confirmation of any transaction, or as an official statement of Lehman Brothers. Email transmission cannot be guaranteed to be secure or error-free. Therefore, we do not represent that this information is complete or accurate and it should not be relied upon as such. All information is subject to change without notice. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- This message is intended only for the personal and confidential use of the designated recipient(s) named above. If you are not the intended recipient of this message you are hereby notified that any review, dissemination, distribution or copying of this message is strictly prohibited. This communication is for information purposes only and should not be regarded as an offer to sell or as a solicitation of an offer to buy any financial product, an official confirmation of any transaction, or as an official statement of Lehman Brothers. Email transmission cannot be guaranteed to be secure or error-free. Therefore, we do not represent that this information is complete or accurate and it should not be relied upon as such. All information is subject to change without notice. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
No Notification of Incompatable Change
My application no longer works because COUNT(*) returns BIGINT in 4.1x In 4.0x it returns INT. I cannot find any notification of the change from INT to BIGINT. How can I fix this with out having recode and recompile all my applications? Thanks
Re: Date Conversion with UltraDev (ASP)
With UltraDev you still have to call some javascript. Here is a couple of examples... function MySQLDateToday(){ var tDate = new Date(); year = tDate.getFullYear(); month = tDate.getMonth() + 1; if (month 10) { month = 0 + month; } day = tDate.getDate(); //getDate is day of month, go figure!!! if (day 10) { day = 0 + day; } rDate = year + - + month + - + day; return rDate } function MySQLDateEdit(myDate){ var dArray = myDate.split(/);//myDate.split(myDate,/); var rDate = dArray[2]+-+dArray[0]+-+dArray[1];//MM/DD/ return rDate } - Original Message - From: Dana Shields [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 07, 2003 5:13 PM Subject: Date Conversion with UltraDev (ASP) I am using MySQL with Ultradev (asp server model), and I'm creating a recordset insert form; however, the documenation is obvious that the user has to enter the date in -mm-dd format. However, this will not work for my users, and I need to allow them to enter mm/dd/ or even mm/dd/yy format. Does anyone know of an ultradev extension (for ASP) that will convert to the MySQL date format? This is easily handled with MS Access and SQL Server, so hopefully there's something out there that does this as well. If anyone thinks this posting is misplaced and should be in an Ultradev list, please feel free to let me know. Thank you. Dana - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: For all you people looking for mysql shirts ;-)
Where is the Dolphin - Original Message - From: Colin Faber [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 16, 2002 7:59 PM Subject: For all you people looking for mysql shirts ;-) Hi guys, Just an FYI, We've finally decided to license out our logo to CafePress.com with the MySQL Developer logo. You can buy shirts, mugs, tote bags and more If you have a chance please check it out. Here is the link http://www.cafeshops.com/cp/store.aspx?s=mysqldeveloper.0 P.S. Sorry in advance if anyone is offended by this post. FILTER FODDER{ SQL, SELECT, DATABASE } -- Colin Faber (303) 736-5160 fpsn.net, Inc. * Black holes are where God divided by zero. * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Delphi MySQL Access Components
Hello Daniel! It works fine. Been using it for several years. Close your connection and query objects and there will be no AV problems... Fredrick - Original Message - From: Pierre du Parte [EMAIL PROTECTED] To: Daniel Kiss [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, July 24, 2002 5:39 PM Subject: Re: Delphi MySQL Access Components Daniel, Personally I found ZEOS a pain in proverbial - poorly documented, constant AVs etc.. D6 dbExpress works very well for me, but I think it only comes with D6 Enterprise. The myODBC driver is another way to go, in which case you could probably use the BDE. There is an ADO driver for mySQL somewhere as well. I could never get it work but if it could be made to work then you could use the ADO components distributed with D6 Pro and Enterprise. Pierre http://www.finalfiler.com Daniel Kiss wrote: Hi, Can someone tell me what is the best MySQL native component set for Delphi? It does not matter if it is commercial, but I need one urgently. Thanks, Daniel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Pierre du Parte' Final Filer Software 349 Worrigee Road Worrigee, NSW, Australia 2540 http://www.finalfiler.com Phone 61 2 44216374 Mobile 0413 483 066 If it feels good, 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Connection DB server by borland C++ Builder
You can use the following component. It includes packages for Builder4 Builder5 http://sourceforge.net/projects/zeoslib - Original Message - From: Yuna Yuana [EMAIL PROTECTED] To: Egor Egorov [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, June 18, 2002 7:39 PM Subject: Connection DB server by borland C++ Builder hello, I need source code for connection Data Base Server bby borland C++ Builder. help...help...help On Tue, 18 Jun 2002, Egor Egorov wrote: Silmara, Tuesday, June 18, 2002, 3:43:48 PM, you wrote: SCB I'm using MySQL 4.0.1 and my question is How can i do to create a new table SCB in a tablespace?. Tablespaces are used only for InnoDB tables. If you create InnoDB table, it will be stored in InnoDB tablespace. How to create InnoDB tables read in the manual: http://www.mysql.com/doc/U/s/Using_InnoDB_tables.html SCB Thank you! -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQl and Dot Net
Here is an online store using MySQL and .NET. Source code for both VB.NET and C#.NET is included. http://www.WeDoNET.net Fredrick - Original Message - From: mosbah ejebali [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 11, 2002 10:38 AM Subject: MySQl and Dot Net Hi all I need you help can I use MySql database with .Net Freamwork ? I'm programming with VB.Net thnks _ Téléchargez MSN Explorer gratuitement à l'adresse http://explorer.msn.fr/intl.asp. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Delphi Mysql
Hmmm... If your just requiring two tier client server there are several. This one is open source and free. http://sourceforge.net/projects/zeoslib - Original Message - From: Proliant Business Solutions [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Sent: Monday, June 10, 2002 2:07 PM Subject: Delphi Mysql What is the best way to connect with Delphi 5/6 to Mysql? 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: WinZeos and Transactions
It's easy to upgrade. I just did a search and replace in the .dfm files. Fredrick - Original Message - From: Informatica Handem [EMAIL PROTECTED] To: Kiss Dániel [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 3:00 AM Subject: RE: WinZeos and Transactions Thanks for your help Daniel. I've tried transactions with ZeosDBO 5.3.0 beta6 and it worked well. The problem is that I want not to change zeos component 3.0.3 to 5.3.0 because it changes some things (first changes the names of the components) and I have to change the code of the application. Also ZeosDBO 5.3.0 is supposed to be beta. Iago. -Mensaje original- De: Kiss Dániel [mailto:[EMAIL PROTECTED]] Enviado el: martes 4 de junio de 2002 11:33 Para: [EMAIL PROTECTED] Asunto: Re: WinZeos and Transactions If WinZeos you've written about is the Zeos Database Objects (http://www.zeoslib.org), then I think I know the solution for your problem. First of all you don't have to BEGIN a transaction because when using an InnoDB connection, you always have an apened transaction, and when you close it by COMMIT or ROLLBACK InnoDB will automatically start a new one for you. There must be a TZMySQLTransact component on your palette which must be linked to your TZMySQLDatabase object. And all your TZMySQLQueryes and TZMySQLTable-s have to be linked to it too by their Transaction property. Now you have to AutoCommit property to False and TransactSafe property to True (of the TZMySQLTransact object). And that's all you have to do. Anyway the TZMySQLTransact has it's own Commit and Rollback methods. Use them. The proper documentation of how InnoDB tranasction types work, you can find it in the MySQL manual. Bye, niel At 09:38 2002.06.04.s +0200, you wrote: Hi all. I use WinZeos 3.0.3 to access MySQL 3.23.49 with Delphi 5.0. I'm using InnoDB tables and I want to use transactions. I try to begin a transaction with BEGIN and SET AUTOCOMIT=0 but doesn't work I can see the rows inserted in the database with another connection. What is the problem? The WinZeos components is too old? Iago. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: release 4.0.2
I agree, I would like to use multi table delete and other new features in win32... - Original Message - From: Artem V. Ryabov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 1:00 AM Subject: release 4.0.2 Hello developers, What problem with release 4.0.2? Why you can't release it also as 'alpha' and continue work on next version like 4.0.3. You alredy fix many bugs and add many very nice features, such as query like 'MATCH ... AGAINST(... IN BOOLEAN MODE)'. Release it! We (users) write you all other bugs. -- Best regards, Artem mailto:[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
Re: Strange Command on Load Data!
Hello, Jack! Special characters have a functional meaning to MySQL(and compilers as well). It is necessary to escape them for any other purpose than the host enviroments function. In MySQL \ is an escape character therefore, if you need to pass \ as a string you must escape it \\ . There is a discussion on this in the MySQL doc's. Fredrick - Original Message - From: Jack [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, April 26, 2002 8:22 AM Subject: Strange Command on Load Data! Dear all I had use the Load Data Command to import my CSV file from my client side of pc to the Mysql database which located in Server side. The command i type is follow: Load Data local infile 'c:\\Doucments and Settings\\jack\\Desktop\\Web\\test\\hkd_rate.csv' into table hkd_deposit1 fields terminated by , Then the data inside this file will be import to the table (hkd_deposit1). but the strange thing is i know the command should be type in this way: Load Data local infile 'c:\Doucments and Settings\jack\Desktop\Web\test\hkd_rate.csv' into table hkd_deposit1 fields terminated by , so why i need to put \\ instead of \ to get the work done, is there anything in mysql i had setted wrong? Thx a lot! Jack [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
Re: Edit a MySQL Record
Here you go... update MyDB set FIRST_NAME = JOE, LAST_NAME = BLO where RECNO = - Original Message - From: Nick McBride [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, February 03, 2002 8:58 AM Subject: Edit a MySQL Record How would I go about editing a certain record in a MySQL database; Items? I want to be able to change a value that was already inserted into the table. -Nick McBride __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Optimization problem in 3.23.44
Did you get an answer to this problem. I'm experiencing the same behavior. Mike Wexler wrote: When I do EXPLAIN SELECT status.itemKey, status.auctionUrl, status.hideItem, status.auctionId, status.action, status.auctionHouse FROM auction.status, inventory.thisItem WHERE status.itemKey=thisItem.itemKey AND (status.closeDate=NOW() OR (status.closeDate IS NULL AND action=queued)) AND status.action'build' I get +--+++---+-+--+---++ | table| type | possible_keys | key | key_len | ref | rows | Extra | +--+++---+-+--+---++ | thisItem | system | NULL | NULL | NULL | NULL | 1 || | status | range | itemKey,itemKey_2,closeDate,action | closeDate | 9 | NULL | 23417 | where used | +--+++---+-+--+---++ 2 rows in set (0.01 sec) Note that the second table matches 23417 rows. Here is inventory.thisItem: mysql show fields from inventory.thisItem; +-++--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +-++--+-+-+---+ | itemKey | bigint(10) | | | 0 | | +-++--+-+-+---+ and auction.status: mysql show fields from auction.status; +-+-+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +-+-+--+-+-+---+ | action | enum('atTIAS','build','uploaded','sold','queued','unknown') | | MUL | atTIAS | | | actionDate | timestamp(14) | YES | | NULL| | | auctionHouse| varchar(10) | | | | | | batchNum| int(11) unsigned | | MUL | 0 | | | auctionId | varchar(64) | | MUL | | | | auctionUrl | varchar(255) | YES | | NULL| | | minimumBid | decimal(7,2) | YES | | NULL| | | reserve | decimal(7,2) | YES | | NULL| | | finalBid| decimal(7,2) | YES | | NULL| | | closeDate | datetime | YES | MUL | NULL| | | durationHrs | int(11) | YES | | NULL| | | buyerEmail | varchar(128) | YES | | NULL| | | hideItem| enum('Link','Hide','Ignore','NoAuction') | | | Link| | | buyerName | varchar(64) | YES | | NULL| | | title | varchar(128) | YES | | NULL| | | description | text | YES | | NULL| | | invoiced| enum('no','yes') | | | no | | | uploadKey | varchar(128) | YES | | NULL| | | qty | int(11) | | | 0 | | | uploadFee | decimal(7,2) | YES | | NULL| | | bold| varchar(32) | | | no | | | private | varchar(32) | | | no | | | feature1| varchar(32) | | | no | | | feature2| varchar(32) | | | no | | | feature3| varchar(32) | | | no | | | feature4| varchar(32) | | | no | | | feature5| varchar(32) | | | no | | | feature6| varchar(32) | | | no | | | feature7| varchar(32) | | | no | | | feature8| varchar(32) | | | no | | | imageUrl0 | varchar(255) | YES | | NULL| | | imageUrl1 | varchar(255) | YES | | NULL| | | imageUrl2 | varchar(255) | YES | | NULL| | | imageUrl3 | varchar(255) | YES | | NULL| | | imageUrl4 | varchar(255) | YES | | NULL| | | imageUrl5 | varchar(255) | YES | | NULL| | | imageUrl6 | varchar(255) | YES | | NULL| | | imageUrl7 | varchar(255) | YES | | NULL| | | imageUrl8 | varchar(255) | YES | | NULL| | | takePrice | decimal(7,2) |
Re: OleDB
This works for me... var connectionString = Provider=MySqlProv; Integrated Security=''; Password=1234abcd; User ID=root; Location=localhost; Extended Properties=''; Data Source=test Mattias Persson wrote: Anyone know how to write a connectionstring for the OleDB in ASP. I get all different kinds of errors when i try to do this. I write rsDB.ActiveConnection =Provider=MySQLProv; Data Source=server=localhost;DB=test but it don't work - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Best Delphi VCL to Access MySql.
Zeos Lib is an open source TDataset descendant... http://zeoslib.org/ dfag wrote: Wich VCL is the best to access MySql I used Interbase for long time and I think to switch to MySql ofr My Delphi Application. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Stored Procedure
Explain how to configure the handlers for myperl under the win32 platform... Alexander Skwar wrote: So sprach »Cafetechno« am 2001-12-26 um 10:34:59 +0700 : If mysql will include the stored procedure feature, what kind of langguage to be used for the stored procedure ? If you use myperl, it will be perl. Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.iso-top.de | Jabber: [EMAIL PROTECTED] iso-top.de - Die günstige Art an Linux Distributionen zu kommen Uptime: 9 days 20 hours 11 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: using ASP with MYSQL
You should join the MySQL win32 list. There are MySQL ASP developers there. Milder Lisondra wrote: Has anyone used or tried to use Activer Server Pages with MYSQL. I am currently working on a project currently only has access to these 2 dev tools. Thanks, Milder - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL and .Net
Hello Vaijayanthi.M! If you are successfull, please report to this list your solutions... Thanks, Fredrick Sinisa Milivojevic wrote: Vaijayanthi writes: Sir, We are working in .Net environment. We could not use the MySQL database in the .Net platform. The MySQL ODBC (MYODBC) does not work with the OleDBProvider of .Net. We tried with the myOleDB provided by MySQL which is also not working in .Net environment. Please provide us a solution to work with MySQL and .Net regards, Vaijayanthi.M Hi! You will find a link to the OleDB driver on our site. Try it out. We are planning of making a proper support for C# in the future. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 transfer data from Paradox to mysql?
Hello, Miguel! I have Paradox and copy Paradox tables to mySQL all the time. Just use the copy table function. This is assuming you have installed the MySQLODBC and have created an ODBC mySQL DSN. Most all data types will copy correctly. You will have to alter the tables to recreate the keys. When you say move your apps, I'm assuming your just referring to the tables. But yes, you can just change your table alias to point to a mySQL table instead of your Paradox table. Very little change to your Pal code will be necessary. Fredrick Fredrick Miguel Enriquez Alvarado wrote: i use the paradox and i want move my apps to mysql, but how? Regards otro correo: [EMAIL PROTECTED] --- Runbox Mail Manager - www.runbox.com Free online email application - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 with LAST_INSERT_ID();
This works for me. You will have to translate the javascript to whatever you are using ... SQL = insert into myTable(field2, field3, field4) values(dat2, dat3, dat4) var dataConn = Server.CreateObject(ADODB.Connection); dataConn.open(MM_soCalData_STRING); var rs1 = dataConn.Execute(SQL); // Here my record is inserted rs1 = null; SQL = select field1 from myTable where field1 = last_insert_id(); //field1 is the auto_increment field var rs2 = dataConn.Execute(SQL) if (rs2.Eof==false){ lastIDvar = rs2(field1); rs2 = null; } Fred van Engen wrote: On Sun, Apr 29, 2001 at 03:38:07PM +0200, [EMAIL PROTECTED] wrote: My insert query look like your 'INSERT INTO ordinit(ID_ordine, Cod_Cliente) VALUES (NULL, 10);'; after the query I look into the table 'ordinit' and always looks fine: the value of ID_ordine is really incremented. But the following 'select LAST_INSERT_ID()' return zero :-(( Weird. I've used them often (on ISAM tables) and it works just fine. Do you use the same connection for the 'LAST_INSERT_ID' query as for the INSERT query? The LAST_INSERT_ID is kept per connection and until another INSERT is done. Regards, Fred. What does your INSERT query look like? It should specify NULL for ID_ordine, e.g.: INSERT INTO ordinit(ID_ordine, Cod_Cliente) VALUES (NULL, 10); Any other value for ID_ordine will not assign an auto_increment value. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: DELETE statement
Hello, Lieven! I will kindly answer... Subselects are not supported in current released versions of mySQL. Please "continue" to ask questions, as that is what list groups are for. Fredrick Fred van Engen wrote: Hi, On Sun, Feb 18, 2001 at 05:23:02PM +0100, Lieven Op De Beck wrote: DELETE FROM product WHERE product.id in (SELECT p.id FROM product p, category c WHERE p.cat=c.id AND c.subcatfrom=2) You forgot to read the manual. Regards, Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 driver for DELPHI ?
Here you go... http://www.zeos.dn.ua/eng/index.html Paulo Serra wrote: I am a DELPHI developer and I need to know if exists a MySQL driver for DELPHI. Does MySQL have a driver for DELPHI??? If it does, please send me it... My e-mails: [EMAIL PROTECTED] [EMAIL PROTECTED] ... at least Id like to know if it does or it doesnt and where I can find it. __ Acesso fcil, rpido e ilimitado? Suporte 24hs? R$19,90? S no AcessoBOL. http://www.bol.com.br/acessobol/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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