D.2.17 Изменения в версии 3.23.36 (27 Мар 2001)

Раздел в стадии перевода.

User Comments

The documentation on $sth->{rows} should talk
about the difference between rows matched and
rows changed.

For example

UPDATE foo SET bar=1 WHERE uniqueKey=1

Could set rows to 0 or 1 even if there was
exactly one record with uniqueKey=1 if the field
bar was already 1 $sth->{rows} would be zero
otherwise $sth->{rows} would be 1. Also a pointer
to how to get the other piece of information
(rows matched) would be nice.

Some of the field names listed there seem to be incorrectly cased. For example, using the current DBI::mysql, after a $sth=$dbh->prepare("LISTFIELDS users"); $sth->execute();, $sth->{TYPE} is set (as an ARRAYREF of types) but not $sth->{type}. Readers should probably consult the DBI docs if some fields turn up undef when typed in the cas mentioned here.

This doc is a little backwards.
After you enter mysql by issuing:
$mysql mysql
do:
mysql> FLUSH PRIVILEGES;
mysql> set password for root = password('new_password');
You will be unable to issue any commands until you've reset the privileges, giving yourself root access. (Hey this took me 2 hours to figure out)10/10/00

Without Foreign keys, referential integrity is hard to maintain. Its even harder without subselects, or allowing left joins in DELETE statements.

Is there some example where rows from a are deleted where the corresponding column is missing in b? Similar to

select table1.* from table1
LEFT JOIN table2 ON table1.id=table2.id
where table2.id is NULL;

Except delete the rows instead of selecting them?

To use MyODBC with Access 2000 you WILL need the
updated jet drivers, available as
jet40sp5_9xnt.exe from microsoft.com.

You may need MDAC 2.6 aswell but the jet drivers
are not included with it.

It would be nice to be able control the character set used for detecting words. That has to be
easier to implement than fancier control over
parsing. I'm using mysql for a web forum where
the messages are stored as text fields and
they contain html tags. So I don't want the
tags showing up in text searches. Easiest way
is to include '<' and '>'
characters as word constituents.

Installed MyODBC-2.50.36 (Win95). Trying to use it with Office 2000 (Excel, Word, Access) works fine for simple queries, but found that it would not allow me to do joins other than a simple LEFT JOIN (the default). I've found the only way to handle complex queries is OUTSIDE of the MyODBC interface -- I write them in perl to create a csv file to be imported into Excel. I am anxiously waiting for a new version of MyODBC that can solve this. Also have found that more complex queries tend to hang the driver. But what I can do with a simple query & MyODBC is Wonderful!!!

Note on Coldfusion: Coldfusion (as of 4.51) has
some very frustrating bugs when using ODBC to
connect to mySQL. If you're trying to connect
them, go read this page first: <a
href="http://www.geocrawler.com/archives/3/13/2000
/12/0/4767478/">http://www.geocrawler.com/archives
/3/13/2000/12/0/4767478/</a>

...briefly, when you add a new myODBC
connection
into ColdFusion, ColdFusion erroneously
writes 'Servername=server.name.com' instead
of 'Server=server.name.com' into its
odbc/odbc.ini file. You'll need to edit this
file by hand to fix it (at least in the most
current version of ColdFusion for Linux).

First, I have read that last_insert_id() pertains
only to the current ODBC connection so there
shouldn't be a problem with that. Though i
haven't tested it and the manual isn't clear.
Second, if you are using Win2k and/or the latest
ADO and having problems with the above example
try using "SELECT id FROM footable WHERE id =
last_insert_id()" instead. The example shown
(SELECT LAST_INSERT_ID() AS last_id) would give
me a problem when I'd reference the column in a
recordset objRS('last_id') (Driver does not
support this parameter). Interestingly(?) this
occurred when referencing the column, not when
executing the query itself, which suggest its a
MS problem not MySQL...

The installation instructions for the mm.mysql
driver imply that you only need to place the jar
file in a directory that is within your
CLASSPATH. You should unjar the file (jar xvf
mm.mysql.2.01-bin.jar, for example) in a
directory within your class path to create the
proper directory structure for the java compiler
to find the driver).

I use mysql C API and I have queries that are
longer then 255 characters
how I can use mysql_query with those strings in
order that the commands are executed?

Is there a reason why the MySQL Front client
isn't included on the D2 Client page?

I found it on www.download.com and has the
following home page:
http://www.anse.de/mysqlfront

It had good rating on download.com and at a first
glance it seemed were nice.

One solution for MS Windows users might be
restarting the machine and then trying again. I
guess there is a database file open somewhere and
MySQL can't open it again for modifications.

Add your own comment.