Thanks for the update, Shawn. I'll check it out right now.
On Mon, Sep 24, 2012 at 4:40 PM, Shawn Green wrote:
> Hello Arthur,
>
>
> On 9/24/2012 4:25 PM, Arthur Fuller wrote:
>
>> On this note, one thing that really bugs me about MySQL passwords is the
>> inabili
.
It must contain a mix of upper and lower case.
It must contain at least one special character.
That combination makes a password very difficult to crack. I don't know why
MySQL falls so short in this respect.
Arthur
www.artfulsoftware.com
Tim,
I think you misunderstood the question. Daniel wants to block Select
queries that ask for all rwows, and permit only queries that ask for some
rows, as restricted by the Where clause.
Unfortunately, I don't think that can be done. But I'm not certain of that;
there might be a tric
l the table
NextPK, say. The algorithm might go like this:
1. Lock the table NextPK.
2. Select its value.
3. Update the column with current value + 1.
4. Unlock the table.
5. Do your inserts.
The lock will be very brief, perhaps brief enough to satisfy your
requirement.
--
Arthur
Cell: 647.710
I'm not sure your method isn't working, but try changing changing the "to
date" part to "< '2012-02-08' " and see what you get.
HTH,
Arthur
omatically, based on the table definitions and declared foreign keys.
See www.artfulsoftware.com.
--
Arthur
Cell: 647.710.1314
Prediction is difficult, especially of the future.
-- Niels Bohr
See the piece on trees at www.artfulsoftware.com. It goes into several
variations of how to handle hierarchies.
HTH,
--
Arthur
Cell: 647.710.1314
Prediction is difficult, especially of the future.
-- Neils Bohr
;s
possible that you might benefit by using stored procedures rather than
views. That switch would of course cost you some time invested in changing
the front end to pass explicit parameters.
Hope this helps,
Arthur
On Thu, Dec 29, 2011 at 12:50 PM, Bruce Ferrell wrote:
> Hi all,
>
&g
could
be done, I would rather the engineers spend their time on more significant
problems.
Just my $0.02.
Arthur
2011/12/9 Halász Sándor
> >>>> 2011/12/09 20:37 -0500, Singer X.J. Wang >>>>
> When the procedure is executed, each query in the procedure is obv
You should still lose the pointless WHERE 1.
Arthur
On Sun, Dec 4, 2011 at 1:38 AM, Jan Steinman wrote:
> DOH! Brain unfroze, and I realized I needed an aggregate:
>
> SELECT
>COUNT(lib.Dewey) AS Have,
>ddn.Dewey AS DDN,
>ddn.Classification AS Classification
>
A quick guess, or at least a starting point:
SELECT key, data
FROM myTable
GROUP BY key
LIMIT 2
HTH,
Arthur
On Sat, Dec 3, 2011 at 11:41 AM, Blog Tieng Viet wrote:
> Hellow everybody.
>
> I have a problem difficult for me, please give me an advice.
>
> I want to get a specific
= someValue and b = someOtherValue
Step one isolates the matching "a" values.
Step two walks through that resultset and examines each value of b.
Since the values of b are already in memory, all it has to do is examine the
index keys to find the matches of b. No additional disk read is required.
Arthur
Call me stupid, but IMO this is just plain Bad Design. Maybe your masters
are making you want to deliver this, but it's frankly insane. Go instead
with the Sally Rand Principle: show them just enough to pique their
interest. Given that you've narrowed it down to the WHERE clause, try again.
WHERE
of rows you cite, but it works beautifully and it is quick as
lightning.
HTH,
Arthur
On Wed, Sep 14, 2011 at 9:24 AM, Ananda Kumar wrote:
> Dr. Doctor,
> What kind of 10 entries? Is it insert,update delete etc.
>
> regards
> anandkl
>
> On Wed, Sep 14, 2011 at 6:30 PM, The
whenever I can. For example, it's possible to add a new Hire while
not yet having determined which department s/he will work in, and hence
which manager s/he will report to, but typically I deal with such scenarios
by creating an "Undetermined" value in the corresponding lookup table.
Arthur
Another approach to this is to create a concatenated string from the PKs of
the result set and then parse that within a stored procedure elsewhere in
your Front End (FE). For more information on this, visit
www.artfulsoftware.com and check out the Queries page.
Arthur
, obvious the intent, and easily sortable. Just my opinion.
Arthur
theory, this should be relatively easy, since the
GUID docs are available, but I'm out of my depth here on how to write the
MySQL equivalent function.
In case anyone has devised a MySQL equivalent for the NewID() function, we
could all massively benefit from your posting of same.
TIA,
Arthu
Visit our site (www.artfulsoftware.com) for lots of tips, especially on
queries.
Arthur
>-Original Message-
> >From: Philip Riebold [mailto:p.rieb...@ucl.ac.uk]
> >Sent: Tuesday, October 26, 2010 7:31 AM
> >To: MikeB
> >Cc: mysql@lists.mysql.com
> >Sub
100% agreed.
Arthur
The other exception is also where financial data is being stored. If you
> have, say, a database containing sales order records, then as well as
> storing the individual values of each item in each order, you also need to
> store the total value of the order, the to
n or presentation or
whatever it is. You grab and sum this (fiscal) year's rows, and then look up
the numbers for previous year(s). When you're dealing with say a million
rows per year, this change can dramatically improve performance.
Just my $0.02".
Arthur
hth,
Arthur
I don't want to
start a religious war :)
hth,
Arthur
On Fri, Jan 1, 2010 at 5:09 AM, Victor Subervi wrote:
> Hi;
> I have a table with products for a store to sell. I need to autogenerate
> from code a table or series of tables into which I can enter (and from
> which
> I can r
I don't see why not, but another choice is to create a view that encompasses
all these tables and Select * From my_view.
Arthur
On Fri, Sep 25, 2009 at 11:28 PM, c...@hosting4days.com <
c...@hosting4days.com> wrote:
> :Newbie:
> Short Question: Is it possible to create an inner
I think that you can do what you want with a simple union query:
select * from incoming where user_id = 123
union
select * from outgoing where user_id = 123
order by datetime_received, datetime_sent
hth,
Arthur
On Wed, Sep 23, 2009 at 10:02 AM, Warren Windvogel wrote:
> Hi
>
> I have 2
able1.name is null.
hth,
Arthur
On Tue, Sep 15, 2009 at 6:52 AM, Mark Goodge wrote:
> John Furlong wrote:
>
>>
>> My question is, can the argument in AGAINST() refer to a column in
>> another table or does it have to be a specific string you are
>> searching for? If t
2009/9/13 Dan Nelson
> In the last episode (Sep 12), Arthur Meeks Meeks said:
> > I have a database with about 1000 tables and 150GB. I have done a simple
> > "for f in $(cat tables); do mysql -uuser -ppassword database_name -e
> > "alter table $f engine=InnoDB;
Hello,
I have a database with about 1000 tables and 150GB. I have done a simple
"for f in $(cat tables); do mysql -uuser -ppassword database_name -e "alter
table $f engine=InnoDB;" ; done
I took about 3 hours and everything went fine, but I just realised that the
same database in another server i
Storing it directly will cause problems when you want to add a new Article
Type. IMO it's better to have an ArticleTypes table (AutoIncrement) and
store its values in the ArticleTypeID column in the Articles table.
A.
On Sat, Sep 12, 2009 at 1:19 AM, AndrewJames wrote:
> thank you all, i think
>
elect with a
WHERE clause that passes the uid in:
select * from articles A left joing article_types AT on A.article_type =
AT.Arcticle_types_id WHERE A.uid =
hth,
Arthur
On Fri, Sep 11, 2009 at 8:22 AM, Claudio Nanni wrote:
> A.J., It sounds good to me!
> You can be a little confused but you
I second that emotion (don't store the images in the data file: just store
the paths to said images). Why? Because in the event of an updated image it
is more hassle than it is worth, to drop the old image and replace it with
the new one; if what you store is a simple pointer to an image file, lots
The revenue that MySQL has accrued to date comes (obviously) from the
support contracts. Oracle has no interest in derailing this revenue stream.
It may well slow down the version cycle, which may be a good thing, but that
aside, I cannot see Oracle killing the MySQL stream. There's no argument
tha
I hereby bet the farm that this shall not occur. I have $10 to say that this
shall not occur.
a) Who is going to challenge the deal?
b) What possible purpose would it serve to interr MySQL?
c) Assuming there is some reason for b) above, why incur the wrath of the
MySQL community and their possible
I too am a big entusiast of Sun's VirtualBox, and I hope that nothing goes
sideways on this product.
A.
effects and that is VirtualBox. I've used MySQL for years and hope Oracle
> does not stop it, but you never know with Ellison encharge!
>
> Just my 2 cents.
> --
>
> ---
hin 5 years.
Compared to all these reasons, the mySQL part of the acquisition is small
potatoes.
Arthur
On Mon, Apr 20, 2009 at 11:44 AM, Curtis Maurand wrote:
> I figure that they'll either kill mysql or they'll limit the commnunity
> version in ways that will make you purchase a
IIRC it does not matter. But you can double-check my opinion with EXPLAIN.
A.
On Thu, Mar 12, 2009 at 11:41 AM, mos wrote:
> I have 3 tables that are 1:1 and will always have a row for a given
> product,_code & date. If I want to join them together, is it going to be
> faster to use an equi joi
eliminates the need for a temp table or
actual table (inno or otherwise). The trick here is to pass the maximum
number of parms, even if they are Nulls.
HTH,
Arthur
mmits seppukku.
You might consider looking into the SIC code scheme before bothering to
invent your own. You can download this from a number of sources and in a
number of formats. Just Google SIC and you should get there.
Hope this helps,
Arthur
won't impair the OLTP databases in the slightest. So the big problem this
scenario suggests is the granularity of the updates to the OLAP version of
the data. That's not for me to decide. Ask the stakeholders how recent the
data must be and proceed from there.
Arthur
impact upon the customer, just you.
hth,
Arthur
On Tue, Mar 17, 2009 at 8:21 PM, Daevid Vincent wrote:
> I'm writing a report tool wherein we have many customers who subscribe
> to this SaaS. There are millions of rows of data per customer. All
> customers are islands from each other (
Won't a simple LIMIT 1 do what you want? Or am I missing something?
Arthur
On Fri, Mar 13, 2009 at 3:24 PM, Nigel Peck wrote:
> Nigel Peck wrote:
>
>> SELECT
>>`People`.`person_id`,
>>`People`.`name`
>> FROM
>>`People`
>> I
On Fri, Mar 13, 2009 at 3:20 PM, Andy Wallace wrote:
> ggghh
>
>
> mich...@j3ksolutions.com wrote:
>
>> On Fri, 13 Mar 2009, mich...@j3ksolutions.com wrote:
>>>
>>> Explanation(5): The more you understand how the database is to be used,
and the
nly FKs. Otherwise, how would you handle fax numbers for people
with no fax, or middle names for people with none?
Arthur
>
-- Forwarded message --
From: Arthur Fuller
Date: Fri, Feb 13, 2009 at 3:36 PM
Subject: Re: Codd's rule 8 (physical data idependence)
To: Yusuf Khan
Sad to say, you cannot casually switch engines and hope that everything
shall continue to work. This is after all the real
ko's
books.
Arthur
On Wed, Oct 8, 2008 at 3:33 PM, Ben A.H. <[EMAIL PROTECTED]> wrote:
> I know that this is the standard means of dealing with a many to many
> relationship, I'm just not sure it fits here.
>
>
>
> > USER:
>
> >
entry process while analyzing the data. Personally, I like the OLAP
data to live in another database, but your approach of rebuilding the
de-normalized table nightly works equally well.
Arthur
On Fri, Aug 29, 2008 at 11:11 AM, Jerry Schwartz <[EMAIL PROTECTED]
> wrote:
> >-Original Mes
I think that you need to select old.a otherwise you cannot group by it.
Arthur
On 7/9/08, Phil <[EMAIL PROTECTED]> wrote:
>
> Is it possible to do an insert into with subselect and group by with an
> additional on duplicate insert ?
>
> CREATE TABLE NEW_TABLE (
>
What you need, basically, is to combine two queries, one of which addresses
t1 and t2 while the other addresses t1 and t3. Create two views similar to
your first query and then join the two views on t1.id and you'll get what
you're after.
hth,
Arthur
On Thu, Jun 5, 2008 at 3:44 PM, Eb
I tested the program before running it and it is virus-clean. I ran it
through AVG first and it's clean. I ran it in Windows. I don't know whether
there is a Linux version.
Arthur
On Mon, May 12, 2008 at 11:31 AM, Velen <[EMAIL PROTECTED]> wrote:
> Hi Arthur,
>
> Could
Would you kindly supply the changes you made, for our collective education?
Thanks.
Arthur
On Mon, Apr 28, 2008 at 11:54 AM, Mark-E <[EMAIL PROTECTED]> wrote:
>
> Hi Ian,
> Thanks for the reply. I was specifying the new port of 3307. I actually
> got it working over the we
how
to interpret the Next and Previous commands that you provide on the form.
Just a thought.
Arthur
On Thu, Apr 24, 2008 at 12:44 PM, Velen <[EMAIL PROTECTED]> wrote:
> Hi,
>
> May be it's not the right forum i'm posting to.
>
> I have a Mysql Quer
The beauty of this language is exactly as Johan says, you can skip the
obvious, Just insert all the other non-obvious columns. In the event that
you have numerous defaulted columns, though, it's best to supply a NULL so
the syntax is parallel (IMO), or alternatively to name the columns. But
either
Dis-information not mis-information. Someone has an axe to grind, methinks.
Or just perhaps is puntificating to see wha' 'appen.
The objections PB has raised all apply here in my installation.
Arthur
ginal table, for head-first indexing.
Arthur
On Tue, Mar 25, 2008 at 9:56 AM, J. Christian Hesketh <[EMAIL PROTECTED]>
wrote:
> Hi,
> I have created a rather large table containing about 16M records. Most
> of the indexed fields are smallint, but there is one field that is a
&g
Wow! 70k files in /tmp. Hell of a mistake :) I hope it doesn't happen often.
Arthur
On 3/17/08, Soenke Ruempler - NorthClick <[EMAIL PROTECTED]> wrote:
>
> Hi Baron,
>
>
> There were about 70k files in /tmp (caused by a mistake). the web
> application on this serve
BY create_time
Assuming an index on id_from (or id_from, id_to), it will be used. This will
be very quick.
hth,
Arthur
On 3/16/08, Rob Wultsch <[EMAIL PROTECTED]> wrote:
>
> On Sun, Mar 16, 2008 at 10:36 AM, Velen <[EMAIL PROTECTED]> wrote:
> > I would suggest u use
>
mysql++/sqlplus.hh:1:2: warning: #warning This header is
obsolete.Please use mysql++.h instead.
g++ -o sqltest sqltest.o -L/usr/lib/mysql -R/usr/lib/mysql -lmysqlclient -lm -lz
g++: unrecognized option `-R/usr/lib/mysql'
sqltest.o(.text+0x41): In function `main':
/home/arthur/sqltest.
Hello mysql,
Scanned Barcodes
I will be scanning barcodes and putting them into a innoDb table
Does anybbody have knowledge re: the best columnType, length or other
properties etc
--
Best regards,
Arthur mailto:[EMAIL PROTECTED]
--
MySQL General Mailing
Hello!
Could anyone tell me if updates in multiple tables also make use of table indexes? And
if they do does it works in the same general manner as it does for select clauses?
Thanks,
Arthur
the problem comes from...
Thanks a lot,
Arthur
> Arthur,
>
> What about
>
> select count(category) use index(category) from books where category=1
> (don't think this will be faster, but try it)
>
> Then you could try to run "OPTIMIZE TABLE books" (read t
Thanks for the tip! It is much faster now...
But it still takes about 3 seconds which makes about the same thing like
using count() so this still does not solves the problem
Regards,
Arthur
> Arthur,
>
> Is it faster if you do:
> select SQL_CALC_FOUND_ROWS category use index(cat
number of results with a certain condition
for a large database?
Any help would be really appreciated
Regards,
Arthur
Hello mysql,
I have been using MySQL on MS Server 2000 and happy enough with it.
I'm just migrating To MS Server 2003 Enterprise Edition
Does any body have an experience of particular problems?
--
Best regards,
Arthur mailto:[EMAIL PROTECTED]
--
??
--
Best regards,
Arthur mailto:[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
" _
& "DATABASE=" & strDBName & ";" _
& "UID=" & strLogin & ";" _
& "PWD=" & strPassword & ";" _
& " OPTION=3"
also tried '& "OPTIO
/bug.php?id=1274
But after I have read everything and tried all possibilities I think this is
a little different and I do not know if there is any workaround for this
issue...
Thanks,
Arthur
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
What is recommanded for a large database to use enum or tinyint? Should I
store active inactive or tinyint (1) with 0 and 1?
Thanks,
Arthur
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
thanks for the input, i guess i should stop re-using code that does't
apply in all situations, such as update not returning a result, etc, etc
while im tired ;), thanks!
Ivan Cukic (Foment) wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
| $result = mysql_query("UPDATE sunday SET
| a5_n_1=
I keep getting Warning: mysql_fetch_array(): supplied argument is not a
valid MySQL result resource in lines 17 and 21, they are marked below. I
am drawing a blank, starting to doze off also :S, thunderbird has crappy
default composition widths(anyone know how to change it?), so the
formatting
/bug.php?id=1274
But after I have read everything and tried all possibilities I think this is
a little different and I do not know if there is any workaround for this
issue...
Thanks,
Arthur
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
le
structure...
Thanks,
Arthur
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
could use count() to figure out the total number of results for the
navigation and this would be defintelly much faster since now as I have
tested but I was thinking if anyone else had this problem before and if you
have found any work around...
Thanks,
Arthur
--
MySQL General Mailing List
Fo
> 1. MySQL only uses one index for each table in a JOIN; this query only
uses
> one table, so only one index is used.
> 2. DESC is slower than ASC
> 3. Try creating an index on two columns; try cat and date, and try date
and
> cat.
> 4. Check EXPLAIN SELECT id,name.. to see whether the right in
records at the begining so the mysql database can
retreieve the first records the ones added last because this is my purpose
in fact
But I was wondering if you have any other ideas of how I could do this
because I am not to happy with such operations with such large tables...
Thanks,
Arthur
--
records at the begining so the mysql database can
retreieve the first records the ones added last because this is my purpose
in fact
But I was wondering if you have any other ideas of how I could do this
because I am not to happy with such operations with such large tables...
Thanks,
Arthur
--
Just by curiosity is there any difference between this 2 queries
select * from users where users_id=10
and
select * from users where users_id='10'
assuming that the users_id column is of type integer primary key (if it
would be varchat I know there is a big difference)
Before switching to version 4.0.18 of MySQL the command "delete from table"
was also reseting the autonincrement column value... It seems that this is
not happening anymore after we have installed this version...
Any idee about this problem? Is there any other way to reset this
Try using such command from PHP...
system("$MYSQLDUMP --opt --user=$USER --password=$PASSWORD $DATABASE_NAME
$GZIP - > $BKDIR/$newfile.gz",$status);
where
$MYSQLDUMP is the mysqldump path
$GZIP is the path to gzip
$BKDIR is the path to the backup folder
t?
Thanks!
- - - - - - - - - - - - - - - - - - - - - - - - - - - -
John Arthur
Email: [EMAIL PROTECTED]
T-Mobile USA
Get more from life
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ssues?
Thanks again
Arthur
-Original Message-
From: Thomas Trutt [mailto:[EMAIL PROTECTED]
Sent: Monday, December 22, 2003 12:40 PM
To: [EMAIL PROTECTED]
Subject: Re: AW: Convert MS Access to MySql
question... does anyone know how it sets up the indexes, security
preferences , relation
thanks
Arthur
Dear All
I have recently reformatted my hard disk and done
a clean install of 4.0.15 on Win 2k Pro SP4.
I used C:\> C:\mysql\bin\ mysqld --install
This created a mySQL service and it works ok.
I happened look at a log in the data folder
and noticed
031007 9:37:53 InnoDB: Started
MySql: ready
d read: "A Portuguese mailing list"
I believe this should be addressed to Paul DeBois.
Arthur.
---
_
Tired of spam? Get advanced junk mail protection with MSN 8.
http://join.msn.com/?page=features/junkmail
--
MySQL General Mai
Hi, all...
I've recently configured Courier, postfix and a mysql
database, on Redhat 8.0, and I thought I had it set up
properly (I've followed a few online procedures,
including the one at
http://kirb.insanegenius.net/postfix.html). Postfix
is now delivering mail fine. However, I can't get
cour
Hi...
Thanks to the great help on this list (including Juan), I was able to get postfix
working with mysql. Now, of course, I need to be able to read the mail being
forwarded. :) Due to restrictions beyond my control, it needs to be a pop3 server - I
would prefer IMAP, but pop3 it is. And th
OK, I'm getting closer to a resolution of the problem
I've had with mysql and postfix. I've got it narrowed
down to an access problem on the database. As a
relative novice to mysql, I thought I had things set
right for the database access by the 'postfix' user
account. Following are the user and
l. I realize it's mostly a postfix
question, but I was wondering if anyone else had
experienced this?
Thanks again for the compiling directions...:)
Aj
-Original Message-
From: Juan Nin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 01, 2003 4:24 AM
To: Arthur Lessard; [EMAIL P
This is probably a topic that has been beaten to
death, but I need help in finding a resource for
getting postfix to support mysql on RedHat 8.0. I'm
not a serious RedHat admin, so I'm looking more for an
rpm of a prebuilt mysql-ready postfix for RedHat, but
if I can find a set of (fairly explicit
you restored this type of data before?
An interesting thing is that mysqldump handles this data with no problem -
it will do the very same files without complaining, while the logs will
fail.
The data is coming in originally through JDBC using the MySQL driver.
Rick Arthur
Knexa.com Enterprises
her than in the help.
TIA
Rick Arthur
Knexa.com Enterprises Inc.
519.747.1139 x 109
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
ady existing db (as I said, same db names on master and
slave), so I get an
ERROR 1007: Can't create database 'mydb'. Database exists
I put the replicate-rewrite-db option AFTER creating mydb on master, so
the bin log already contains this action. Can this be the proble
It's dead simple to create a MySQL database -- it's just a directory under
mysql\data. If you want to do it from Access, just determine where the
mysql\data directory is and then create the subdirectory.
Hth,
Arthur
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL
ot;ON" )
Can be re-written as:
SELECT * FROM Customers INNER JOIN Cities ON Customers.CityID =
Cities.CityID
WHERE Cities.ProvinceID = "ON"
Hth,
Arthur
-Original Message-
From: Stefan Hinz [mailto:[EMAIL PROTECTED]]
Sent: February 13, 2003 8:36 AM
To: Elby Vaz
Cc: [EMAIL PR
olumn type.
It only took a small amount of experimentation to create a MySQL profile,
and using that I have frequently moved databases from SQL 2000, Oracle and
Access to MySQL. dbScripter will work fine with virtually any ODBC-compliant
back end.
Hth,
Arthur
-Original Message-
From: Davi
Yes you have neither triggers or stored procedures. Instead you'll have to
remember to use the same code everywhere in your app that can update the
table:
Update mytable
SET col1 = 'somevalue', col2 = 3456, col3 = now(), Viewed = Viewed + 1
hth,
Arthur
- Original Mes
nnoDB? Assuming that anyone besides me finds this interesting, will MySQL
ever support GUID column types?
Arthur
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Maxime LEMAIRE" <[EMAIL PROTECTED]>
Cc: "Mysql" <[EMAIL PR
;drop" statements in one script, all my
"create" scripts in another, and all my "populate" scripts in yet another.
Arthur
-Original Message-
From: David T-G [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 27, 2002 8:15 PM
To: mysql users
Subject: style q
"MySQLProv.3.0"MySQL OLE DB Provider (MyOLEDB) v.3.0
Both use Access 2k as a front end (ADO clientside cursor).
Also I can access mySQL with some tools I use.
--
Best regards,
Arthur mailto:[EMAIL
Nothing can be compared to null, not even null, which implies that MySQL is
wrong in returning two rows in the SELECT. Your query needs to say IS NULL:
delete from t where id = 1 and num is null;
Arthur
-Original Message-
From: Andrew Braithwaite [mailto:[EMAIL PROTECTED]]
Sent
In the meantime, Jan, you don't have to commit your whole database to one
table type. Consider using MyISAM tables where you need fulltext search and
InnoDB for your other data.
Arthur
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 19, 2002
1 - 100 of 148 matches
Mail list logo
