source from your
ODBC-capable program using the name of the data source.
Cheers
Andrew.
David Blomstrom wrote:
--- Andrew Pattison <[EMAIL PROTECTED]> wrote:
The ODBC control applet in Windows can be found in
two places:
1. Control Panel.
2. Administrative Tools (if you are using Windows
20
unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
______
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
Andrew Pattison
mail at apattison.plus.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL supports sub-queries in the 4.1 versions.
Cheers
Andrew.
- Original Message -
From: "Andy Bakun" <[EMAIL PROTECTED]>
To: "Laszlo Thoth" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, September 25, 2004 6:30 PM
Subject: Re: MIN(foo) as bar WHERE bar>50
On Fri, 2004-09-2
There should be a PID file somewhere - either in the MySQL directory or
under /var - that needs to be deleted before the init script will let you
start another server instance.
Cheers
Andrew.
- Original Message -
From: "Grant" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday,
Yes, use the MyODBC driver to connect to MySQL directly from ASP.net .
Cheers
Andrew.
- Original Message -
From: "Scott Hamm" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "Scott Hamm" <[EMAIL PROTECTED]>
Cc: "'Mysql ' (E-mail)" <[EMAIL PROTECTED]>
Sent: Friday, August 20, 2004 3:03 PM
Subj
Two main ways:
1. Dump your tables to a file and import them using the text import filter.
2. Install MyODBC and open a connection to the MySQL tables in Excel.
Since Excel is a proprietary file format, MySQL does not support it. Also,
bear in mind that Excel has a 65,535 row limit hard coded into
I'm guessing that you have indexes on the 321st_stat table? If this is the
case, try dropping them before you do the insert, then rebuilding them.
MySQL is known to be slow at doing bulk inserts on indexed tables. Also,
updates are much faster than inserts since with inserts there are much more
Subqueries aren't implemented in 4.0 - only 4.1 and upwards support
subqueries.
Cheers
Andrew.
- Original Message -
From: "nambi c" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 22, 2004 10:31 PM
Subject: subquery problem.
> Hi,
>
> My server version : 4.0.18-max-n
What other processes are running on the Solaris box? Solaris tends to favour
giving each process a fair share of the processor rather than getting one
process (e.g. MySQL) to complete as quick as possible. I suspect that if you
compared the time taken for much larger queries on the Solaris machine
To do the restore:
1. Stop the MySQL server. On Windows NT/2000/XP you should use the command
"net stop mysql" assuming you have installed MySQL as a service. On
Unix/Linux, if you installed the init script, simply issue a command
something like "/etc/rc.d/init.d/mysql stop" or
"/etc/rc.d/init.d/m
Are you running Linux or Solaris on these servers?
Andrew.
- Original Message -
From: "mac" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, July 02, 2004 4:42 PM
Subject: INTEL vs. SPARC
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> hi there,
>
>
I saw reference somewhere (I believe it was either an Apache or PHP
discussion) to 4.1.3 being beta but I'm not sure if this was just wishful
thinking on the part of those particular developers. If this is the case
then going by the dates of previous releases in the 4.1 branch (not always a
good gu
I've a funny feeling the kernel authors re-wrote much of the SMP code for
2.6 with the aim of getting it to scale better to 8 processor systems, so I
would expect there to be a few stray bugs in it. You could always downgrade
to 2.4 if it doesn't work out ;-)
Cheers
Andrew.
- Original Messag
I've not seen this on MySQL but under Informix 7.24 on Solaris 2.6 I noticed
a similar problem when doing a lot of number crunching and transaction
logging was turned on. If you are running with transaction logging switched
on then you might want to try turning it off. For some reason the database
The way I do this is within PHP is to echo the value stored in mysql_error
after each SQL statement. If you're not using PHP then this probably doesn't
help though ;-)
Cheers
Andrew.
- Original Message -
From: "Bob Lockie" <[EMAIL PROTECTED]>
To: "MySQL Mailing List" <[EMAIL PROTECTED]>
By default MySQL flushes keys to disk with every INSERT, hence the
performance degredation with performing several single INSERTs one after the
other. The following extract from the MySQL documentation hints at one way
of changing this on a per-table basis:
a.. Declaring a MyISAM table with the DE
I use this method also, but I usually put a --NONE-- item in at the top of
the listbox so the user has the option of selecting none of the items in the
list. This may or may not be required for your application.
Also, you can get the select box to automatically have the value that the a
given fiel
You are probably better setting up permissions using the GRANT statement
since this should be less prone to errors. Using the GRANT statement, you
name the permissions which you want to give the user. This means that you
are less likely to put a "Y" where you didn't mean to.
Use a statement like:
The standard MySQL distribution comes with InnoDB support. You can also
split tables into up to 255 blocks using MyISAMs RAID support.
Cheers
Andrew.
- Original Message -
From: "Rahul Sood" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 24, 2004 10:14 PM
Subject: table
I seem to recall old versions of MySQL did re-use auto-increment values but
this was changed since it's not really supposed to do that ;-)
Cheers
Andrew.
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Joe Wong" <[EMAIL PROTECTED]>; "Egor Egorov" <[EMAIL PROTECTED]>;
<
Un-named views are supposed to be there already. I know this is not the
"real thing", I just thought I would mention it. ;-)
Cheers
Andrew.
- Original Message -
From: "Josh Trutwin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 22, 2004 5:53 PM
Subject: Re: Views Synta
Another possible solution would be to store partial dates as, for example,
2004-05-01. In other words, simply make the partial date the same as the
first day of that month. This has the advantage that range date range
functions work, but you will not be able to tell the difference between a
partial
There is no icon. The best way to run MySQL is as a service. If you have
Windows NT, 2000 or XP you can install MySQL as a service as follows:
1. Open a command prompt.
2. change to the mysql bin directory ("cd \mysql\bin").
3. type "mysqld-nt --install". You should see a message saying "service
i
You are using a subquery. Subqueries are only supported in version 4.1 and
later. You will eithe rneed to rewrite your query so that it doesn't use a
subquery, or upgrade.
Cheers
Andrew.
- Original Message -
From: "Anton Ivanov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday,
> Anyone know when we can expect 4.0.20 for Windows?
>
> Also, is there a timescale for a beta version of 4.1?
>
> Cheers
>
> Andrew P.
>
> Andrew Pattison
> mail at apattison.plus.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
t sure. If
anyone has any pointers it would be much appreciated.
Cheers
Andrew.
- Original Message -
From: "Andrew Pattison" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 01, 2003 12:18 PM
Subject: Fw: Problem deleting data
>
> > I hav
- Original Message -
From: "Andrew Pattison" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 01, 2003 12:02 PM
Subject: Problem deleting data
> I have a strange problem with MySQL 4.0.15 . When I delete an entire
table,
> then ru
27 matches
Mail list logo
