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

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

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:

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

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

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. -

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

Re: MySQL 5.0.4-beta has been released

= 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

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

' 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

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: 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,

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

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

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:

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 --

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

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

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:

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

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

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

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

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

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

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:

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

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

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

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?

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

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

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

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

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

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,

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

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

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

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); //

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:

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]