RE: AUTO_INCREMENT columns randomly restart counting from 1

Hi Andreas, > >I think AUTO_INCREMENT is on a per-connection basis. So if > you're doing > >this across different database connections, it will reset to 0. [snip] > do a 'select * from where test=1' and you will > see that the 2 new > values will be visible to both of the clients. As I unde

RE: OleDB

Hi, I think that adding .;Extended Properties="OPTION=16400" to your ADO connection string should do the trick. Cheers, Bruce -Original Message- From: Mattias Persson [mailto:[EMAIL PROTECTED]] Sent: 08 January 2002 13:29 To: [EMAIL PROTECTED] Subject: OleDB Hello Im using OleDB

RE: mySQL

Thomas, What is the connection string you are using? Bruce -Original Message- From: Thomas Ekegren Christensen [mailto:[EMAIL PROTECTED]] Sent: Tue, 28 August 2001 18:43 To: [EMAIL PROTECTED] Subject: mySQL Hi mySQL, I have a huge problem and unfortunately my Domain Hosting Services

RE: Inner selects

Hi, >> - In oracle you have outer joins, where you have to use a (+) >>to find rows with null values and stuff like that. Any suggestions on >>how to do this in MySQL? You must use the Left Join type syntax in the FROM clause of your query. >> - The function UNION to connect 2 select

RE: MySQL OLEDB

Steeve, I have had the same problem for months, with no solutions. If you find a solution, please let be know. Thanks, Bruce -Original Message- From: Roy, Steeve [mailto:[EMAIL PROTECTED]] Sent: Mon, 20 August 2001 16:21 To: '[EMAIL PROTECTED]' Subject: MySQL OLEDB Hello, I us emysql

RE: SELECT .. OR from multiple tables

>> How about a UNION query...? >Too bad MySQL doesn't support them yet ;) Oops...sorry...I see it is on the TODO list. Would a MERGE table not achieve the same result as a UNION query? It appears that a MERGE table acts like a VIEW. Eric if your Current and Temporary tables have identical str

RE: SELECT .. OR from multiple tables

How about a UNION query...? -Original Message- From: Eric Anderson [mailto:[EMAIL PROTECTED]] Sent: Tue, 14 August 2001 18:56 To: [EMAIL PROTECTED] Subject: SELECT .. OR from multiple tables I've got two tables, "Current" and "Temporary", Current has a row with login='keric', Temporary

RE: Help required for OLEDB on win32 for MySQL(linux)

Asit, Did you ever solve your problem? - I have the same... Bruce -Original Message- From: Miguel Angel Solórzano [mailto:[EMAIL PROTECTED]] Sent: Thu, 07 June 2001 21:42 To: asit; [EMAIL PROTECTED] Subject: Re: Help required for OLEDB on win32 for MySQL(linux) At 20:56 07/06/2001 +05

RE: not null

You must specify a datatype: create table table_name ( Column_Name integer not null ); -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Fri, 27 July 2001 06:48 To: [EMAIL PROTECTED] Subject: not null I am having trouble setting a column attribute to not n

RE: win2k ERROR 1036 (read only) problem

Using the 'GRANT' syntax is the recommended method for assigning permissions. -Original Message- From: Panos Melas [mailto:[EMAIL PROTECTED]] Sent: Mon, 23 July 2001 13:51 To: '[EMAIL PROTECTED]' Subject: win2k ERROR 1036 (read only) problem Hello everyone, I try to install and configu

Outer join syntax..

Hi all, MySQL doesn't support nested subqueries, I know, and I also understand that the same results can be achieved through outer joins (Left join, Right join and WHERE IS [NOT] NULL). Also, inner joins can be expressed either in the FROM clause or the WHERE clause. My question is: Can outer j

RE: selecting with LIMIT and including the total?

How about something like this: SELECT title FROM news WHERE cond1 LIMIT 1, 10 union SELECT count(title) from NEWS WHERE cond1 LIMIT 1, 10 -Original Message- From: nsabbi [mailto:[EMAIL PROTECTED]] Sent: Tue, 03 July 2001 09:48 To: [EMAIL PROTECTED] Subject: selecting with LIMIT and inclu

RE: win32 oledb

Joel, I have used the MySQL.OLEDB Provider, but haven't been able to get it to work on anything except 'localhost'. So, I use the OLEDB provider for ODBC drivers, and then use a MySQL DSN. I did mail the people who built the provider a month or two ago, but no response. If you, or anyone else, f

RE: install service on nt

> 2. copy and edit c:\my.cnf and set basedir=d:\mysql\ >and try mysqld-nt --install >and then net start mysql --> specified file not found error I think you need to use "/" instead of "\" in your path as per the documentation. ie: basedir=d:/mysql/ --

RE: Full text search gotchas

If you searched for '% john %' - note the spaces, you would not find 'johnson' etc.. -Original Message- From: Matthew Brealey [mailto:[EMAIL PROTECTED]] Sent: Tue, 26 June 2001 11:29 To: [EMAIL PROTECTED] Subject: Full text search gotchas We're having quite a lot of difficulty with MySQ

RE: Join mysticism

Nick, What happens to the time if you run the following on your database: SELECT DATE_FORMAT(visits_1.date_time_visit, '%Y-%m-%d') AS dt, Count(DISTINCT visits_1.id_visitor) AS cnt, visits_1.id_visitor, visits_1.id_visit, visits_2.id_visitor, visits_2.id_visit, visits_1.visit_number, visits_2.vi

RE: MyODBC through ADO

The easiest way to work out what your connection string should be is to create a "new text file" in explorer, rename it Something.UDL, and double click it: You then get the MS Data Link editor dialog. Select the "MS OLEDB Provider for ODBC Drivers" as the Provider, select your ODBC datasource

RE: Can only create 127 records in a table :o(

Change the datatype of your primary key from TINYINT to something larger, like SMALLINT, MEDIUMINT, or INT. -Original Message- From: Mette Møller Madsen [mailto:[EMAIL PROTECTED]] Sent: Fri, 15 June 2001 13:46 To: mysql listserver Subject: Can only create 127 records in a table :o( Hi

RE: MySQL front end tool

Also http://www.mysql.com/Downloads/Contrib/MyTool-DLL_for_VB_and_MySQL.zip -Original Message- From: Crercio Osmaildo da Silva [mailto:[EMAIL PROTECTED]] Sent: Fri, 25 May 2001 14:17 To: [EMAIL PROTECTED] Subject: RE: MySQL front end tool Hi, Try DBTools ( http://dbtools.vila.bol.com.b

RE: auto_increment

I believe that this behaviour is standard for autoincrementing fields on all database systems that support them. -Original Message- From: Stefan Wehowsky [mailto:[EMAIL PROTECTED]] Sent: Fri, 04 May 2001 10:37 To: [EMAIL PROTECTED] Subject: auto_increment Let´s say I got a column "id" t

RE: Using the IN function

As I understand it, you can only list distinct values in an IN clause - MySQL doesn't yet support subqueries here - according to the manual.See page 139 of the pdf manual. -Original Message- From: Bobby Chopra [mailto:[EMAIL PROTECTED]] Sent: Thu, 26 April 2001 14:10 To: [EMAIL PROTEC

RE: Migration Oracle => MySQL

Johan, I'm working on something similar at the moment. Attached at two files I downloaded from somewhere. If you import/attach the Oracle tables to an access database you could give them a try - I haven't used them. If you want a more complete solution, the Oracle views: USER_TABLES, USER_TAB_CO