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

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 ar

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.

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" Sent: Wednesday, June 15, 2005 7:24 AM Subject: Visual Basic .NET Oledb Provider > Hi all, > I wou

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

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

Re: MySQL 5.0.4-beta has been released

OMETTRACKER.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" Sent:

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" ; <[EMAIL PROTECTED]

Re: 5.03 Still crashes on win32

for connections. Version: '5.0.3-beta-nt' socket: '' port: 3306 Official MySQL binary - Original Message - From: "Fredrick Bartlett" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; Sent: Monday, March 28, 2005 10:13 AM Subject: 5.03 Still crashes

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.0.2 alpha crashes with Query Browser

ï imminent Dictionary imÂmiÂnent (Äm'É-nÉnt) adj. About to occur; impending: in imminent danger.   - Original Message - From: "Lily Wei" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; "Francisco Tapia" <[EMAIL PROTECTED]> Cc: Sent: Thursday, March 17, 2005 11:47

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

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 lon

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

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]

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]

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

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

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

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)

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 (utf8_general_ci,IMPLICIT

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

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 w

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 fi

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

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

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

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

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.

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

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 d

Re: Data Logging based on MySQL using serial Interface

Look at LOAD DATA LOCAL INFILE... load data local infile '//BackLog//import_csv//KCV81_standard_sales.csv' into table kcv81_standard_sales fields terminated by ',' enclosed by '"' lines terminated by '\r\n' - Original Message - From: "Peter Samulat" <[EMAIL PROTECTED]> To: <[EMAIL PROTEC

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 r

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 s

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

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

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 m

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

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 ke

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

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 Beéck 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] >