Hello,
In my application, I am connecting to various RBDMS
but primarily SQL Server and MySQL using ODBC 3.0
driver. In SQL Server, if I execute SQLCollAtrribute
with SQL_DESC_OCTET_LENGTH, it is returning me the
maximum number of bytes that the column can have
irrespective of whether the column i
Matt,
Thanks for the great reply. We have a database that has been migrated
over to MySQL 4.0, and the column-definitions are a bit wacked - way
more space is allocated than is needed for many columns. I think you are
using MyISAM tables; we are using InnoDB. I think it woudl be worth
dropping
I'm trying to come up with an efficient way to query my table of names for all first
initials.
I.e. There are 50,000 names, and I want a result of:
A, B, C, F, H, I, J, K...
That is, a list of all first initials that are actually present in the data (and
ideally are also used in a joined
Hi David,
Great questions:
- Original Message -
From: "David Griffiths"
Sent: Friday, May 28, 2004 6:05 PM
Subject: Specifying an index length and the default value
> The length of indexes on varchar and char indexes can be specified at
> index creation.
>
> What is the default length o
Gerben Gieling wrote:
Dear all,
I have an auto_increment value in an innodb table. I recently introduced
a new row by mistake and removed it. I beleive I read somewhere in the
manual that an innodb table does not reuse this number by default. I
also remember vaguely that it is possible to reset thi
Hello all,
I am currently running mysql on a SuSE 9.0 machine. here is the mysql version
Server version 4.0.15
Protocol version10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 23 min 0 sec
The
problem I'm
> 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://li
Hi!
Long-awaited MySQL-4.1.2 was released today. Windows binaries of 4.1.2 will
be released as soon as they are available. The binaries and source are
available for download at:
http://dev.mysql.com/downloads/mysql/4.1.html
InnoDB is a MySQL table type that provides foreign key constraints,
trans
Alek,
Create a file of any name, e.g. script.cnf.
Put the following in it,
[client]
user = dba
password = dba_pass
Run mysql with the --defaults-file arg
mysql --defaults-file=script.cnf
So long as the cnf file is only readable by the the cronjob owne
Hi,
I am new to MySQL and have one question.
I would like to run mysql job as a batch job (scheduled through cron) and have to
provide password to the batch job:
mysql -udba -ppassword
My concern that anybody running:
ps -ef
will be able to see the password when job is run.
Is there
Randy Burgess <[EMAIL PROTECTED]> wrote:
> Apologies for what is a pitifully simple question from someone who has
> just started using MySQL 4.0. I've looked in the documentation and
> elsewhere, but can't find the exact syntax for adding comments to
> columns when creating a table. My attempts
Apologies for what is a pitifully simple question from someone who has
just started using MySQL 4.0. I've looked in the documentation and
elsewhere, but can't find the exact syntax for adding comments to
columns when creating a table. My attempts at guessing the syntax so far
have failed. Tips,
--- Osvaldo Sommer <[EMAIL PROTECTED]> wrote:
> Yeap, that's the idea.
>
> That's call normalization. If you are interested in
> database design, you
> need to read Codd's book in database.
I thought I had a natural talent for database design,
since I've done so much work with data, but it isn't
On Sun, May 30, 2004 at 06:58:35PM +0200, Bernhard Döbler wrote:
> searching for latest MySQL-Downloads I see there's no
> mysql-4.1.2a-alpha-win.zip available by now on - for example -
> ftp://ftp.fh-wolfenbuettel.de/pub/database/mysql/Downloads/MySQL-4.1/.
As Patrick's release announcement (http
Hi,
searching for latest MySQL-Downloads I see there's no
mysql-4.1.2a-alpha-win.zip available by now on - for example -
ftp://ftp.fh-wolfenbuettel.de/pub/database/mysql/Downloads/MySQL-4.1/.
http://dev.mysql.com/downloads/mysql/4.1.html links the file
mysql-4.0.20a-win-noinstall.zip in the MySQL
Yeap, that's the idea.
That's call normalization. If you are interested in database design, you
need to read Codd's book in database.
If you want, you I can help you looking at the database you build and
give you some pointers.
Osvaldo Sommer
-Original Message-
From: David Blomstrom [ma
I found it interesting. Thanks Eric.
>>(reconstructed from archives i accidentally deleted the copy in my mailbox
>>>Daniel Clark writes:
>>>I don't see how LIMIT would make a difference. LAST_INSERT_ID() only
>>>returns one record.
>>>But it's worth trying in a big loop to get timing numbers
At 15:21 -0500 29-05-2004, mos wrote:
At 01:39 PM 5/29/2004, you wrote:
Hello,
Does the cluster support fulltext indexes?
After a quick reading of preliminary documentation it seems NO.
Can someone confirm it?
Thank you.
Santino Cusimano
-
Santino,
Where does it say that in the docs? Can y
--- Peter Brawley <[EMAIL PROTECTED]>
wrote:
> David,
>
> If one finds oneself thinking about creating large
> numbers of columns for
> particular features, the working model is likely not
> general enough (eg why
> not a child table that permits you to add any number
> of features you please
> f
19 matches
Mail list logo
