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]
want to access
via ODBC. Once you have done this, you can then connect to the data 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
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 bar50
On Fri, 2004-09-24 at
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,
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
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
Subject: RE:
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-nt
I
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
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
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,
hope this
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]
Sent:
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
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
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
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
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:
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
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];
[EMAIL
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
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 Syntax for
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
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, June
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/mysql
To unsubscribe:http
- 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 run a repair on that table, it recovers all
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 have a strange problem with MySQL 4.0.15 . When I delete an entire
27 matches
Mail list logo
