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 tablename where test=1' and you will
see that the 2 new
values will be visible to both of the clients.
As I
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
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
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 queries
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
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
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
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
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
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
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
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,
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/
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,
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
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 (I
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
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 (
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
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,
20 matches
Mail list logo