>Description:
A cron job runs a shell script (update_adrs) that gets lynx to download and
save a web page (adr.htm). It then runs a perl script (adr.pl) to parse the web page
into an import file (adr.txt). Finally it executes a mysql command to import that file
into a table called Libra
administrator decided as he did, and prepare a refutation
for his argument at that time, not a general complaint that it doesn't
suit your personal needs.
Alec
"Andy Eastham" <[EMAIL PROTECTED]>
18/04/2006 13:16
To
cc
Subject
RE: Reply / Return Address of thi
change the field name e.g. to "descr" or even "description". Making the
field name longer and more meaningful costs next to nothing.
Alec
Anthony <[EMAIL PROTECTED]>
13/07/2006 16:42
To
mysql@lists.mysql.com
cc
Subject
Field name DESC
Hello,
i want
nal question, I would not know about ERP in
particular, but a lot of people are using MySQL in demanding, mission
critical systems. I think most users would classify the production
versions of MySQL as very stable indeed.
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
able future hardware and
software, it would still take half a million years to add that number of
records. It is therefore fairly easy to deduce that the OP has not got,
and will not have within any of our lifetimes, a database that big.
Alec
--
MySQL General Mailing List
For list arc
r columns used in WHERE clauses. But once created, the rest
happens by "magic" (or rather, courtesy of the skills of the MySQL
engineers).
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
xes on
your tables for all the different searches you do. Use the EXPLAIN command
to find out which SELECTs are doing full table scans, and add Indexes as
appropriate.
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
advice pls
This is a link, previously recommended on this list, which I have found
very useful:
http://www.sitepoint.com/article/hierarchical-data-database
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
NSERT INTO os (name,description) VALUES ( 'winxp','winxp');
No. What you have requested is that the combination of id AND name be
unique. Since id is auto-increment, every record will be unique unless you
manually force the id to an old value. I guess you want the valu
me, so there is no point in having two indexes. The only difference is
at insert time, when the unique index enforces the uniqueness rule.
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
erms separately? If the field2 hit is is pretty selective, it does
not really matter what the others do.
Alec
Chris Faulkner <[EMAIL PROTECTED]>
22/07/2005 12:46
Please respond to
Chris Faulkner <[EMAIL PROTECTED]>
To
mysql@lists.mysql.com
cc
Subject
Re: use of inde
umlauts.
> How do I sort results with german umlauts if the database character set
> is set to utf8?
According to http://dev.mysql.com/doc/mysql/en/charset-unicode-sets.html
you might achieve the effect you want by setting the collation to
utf8_unicode_ci
Alec
--
MySQL G
actally
contains, and why you expected non-null results from those queries. Are
you sure that your customers table contains a customer whose name starts
[JM] ? Both commands look perfectly sensible to me.
If your tables are small, post the results of "Select * from customers ;"
or "
Just in the spirit of refining my own skills, here is how I would tackle
the problem. It parses, but I haven't populated the tables so I don't know
if it works:
SELECT s.dateshipped, COUNT(r.type="undelivered"), COUNT(r.type =
"customer"), COUNT(r.status="open")
FROM shipments s JOIN returns r
Sorry - I think you need a LEFT JOIN or it won't count shipments which are
not returned.
Alec
[EMAIL PROTECTED]
12/08/2005 16:38
To
[EMAIL PROTECTED]
cc
mysql@lists.mysql.com
Subject
Re: Complex query. (It's killing me)
Just in the spirit of refining my own skills, her
"Blue Wave Software" <[EMAIL PROTECTED]> wrote on 18/08/2005
15:57:34:
> I'm having one of those slow brain days.
>
>
>
> I want a partial filter egg. All records where field1 begins with "ABC"
any
> body know the where clause to do this.
>
> In Access it's where field1 = 'ABC*' but I can'
command only checks columns that is instructed are to be unique.
The purpose of the IGNORE modifier is simply to ignore the error produced
when a duplicate occurs.
Alec
Hal Vaughan <[EMAIL PROTECTED]>
24/08/2005 07:47
Please respond to
[EMAIL PROTECTED]
To
mysql@lists.mysql.
h of a single word in the indexed column. You surely cannot expect to
get a word 4294967295 characters long. Indeed, if you expect a word 4
characters long, I think you are using the wrong tool.
I think your coad should read:
sql>create table (test title longtext)TYPE=MyISAM;
sql>alter ta
would have to do a linear search through the table in order to check for
duplicates - the kind of lengthy operation it is designed to avoid
whenever possible. The key is a necessary part of the effect you want to
achieve.
Alec
--
MySQL General Mailing List
For list archives: ht
rather than blindly changing it to bin, you
should perhaps consider you real needs. For example, might not a Spanish
collation serve better than a binary one? Many Americans speak Spanish,
few binary.
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
insensitive throughout, so do as you will.
Alec Cawley
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
that platform is marketed by a company who many of us
find totally repulsive. If you let yourself be hyped into dropping MySQL,
you will be harming a company that is, in my opinion, a model of how to
provide full commercial quality software (or better) with an Open Source
licence, while not
"'Yemi Obembe" <[EMAIL PROTECTED]> wrote on 08/09/2005 10:33:25:
> Talking limit (in select query), does it "limit" the search result
> after ordering according to relevancy and the likes, or before?
> thanks
LIMIT operates after ORDER BY.
Alec
k that many applications will find MyIsam faster.\\
I don't thing InnoDB supports Load Data From Master, making adding a
replication slave harder.
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
server id of the server which
originated it. When the update returns to its originating server, it is
dropped instead of being executed. That is why every server must have a
unique id.
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
However, since MySQL is freely available, why not just download it,
install it on your development machine, and run a few tests. The only real
measurement of performance is actual tests: predictions often err, both
high and low.
Alec
--
MySQL General Mailing List
For list archives
Vinayak Mahadevan <[EMAIL PROTECTED]> wrote on 27/09/2005 11:28:51:
> [EMAIL PROTECTED] wrote:
>
> >Vinayak Mahadevan <[EMAIL PROTECTED]> wrote on 27/09/2005 04:55:13:
> >
> >
> >
> >>I am creating an application in Visual Basic 6.0 which will require a
> >>centralised database server. All this
and there is a cost to maintaining two index trees.
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
is only one index even though it is over
two fields (the order in the telephone directory). You would only need
another index if you wanted to search over GivenName,FamilyName. This
would then require an extra index, which would have to be put in the back.
Alec Cawley
--
M
insert would have to include a full table scan.
Alec
"C.R. Vegelin" <[EMAIL PROTECTED]>
04/10/2005 15:10
To
cc
Subject
Re: How to avoid redundancy between PK and indices ?
Hi Alec,
Thanks for your comment. Well, we disagree on a few points.
Suppose I h
ed bit. Which means that you have to get hold of the full
command line that you sent and find out what immediately preceded the
characters it has given as an error.
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
es with
InnoDB are, while not zero, small.
Why do you want such a feature?
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
t find
> anything in the MySQL documentation.
It is almost certainly not possible. If you look in the manual for the
storage space occupied by each field, you will see there is no space to
store any form of timestamp. Since MySQL does not store the data you want,
it cannot extract it for you.
> C:\mysql\data\ to D:\mysql\data. ( i.e., changing the drive location
from
> c:\ to d:\)
Yes, you can change the place data is stored. This is usually done my
setting the value of mysql-data-dir in the my.ini file, which will
probably have been setup by your installation.
Alec
in
5.0.3. The Manual ( http://dev.mysql.com/doc/refman/5.0/en/char.html )
suggests using BLOB or TEXT instead of VARCHAR to avoid this behaviour in
earlier versions.
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ring(1);
> end_time=RS.getString(2);
>
> or
>
> start_time=RS.getString(min(date_time));
> end_time=RS.getString(max(date_time));
You could do
String start_time = RS.getString (1) ;
but you would be much better advised, in my opinion, to do
java.sql.Date start_time
stomers.creation desc
But read up on LEFT JOINs.
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
xt Search TODO
> [2] MySQL Manual -> 6.8 MySQL Full-text Search
>
>
> P.S.
***
> I use MySQL 4.0
***
I think this is your problem: MySQL does not properly support Unicode
until version 4.1. I am successfully using FullText with My
AmirBehzad Eslami <[EMAIL PROTECTED]> wrote on 24/11/2005 18:36:25:
> On 24/11/2005, Alec worte:
>
> > I think this is your problem: MySQL does not properly support
Unicode
> > until version 4.1. I am successfully using FullText with MySQL
> 4.1 to sort
>
e.
I would expect the use of thousands of tables effectively to disable
MySQL's caching capability, which is one of the biggest performance
boosters.
Alec
"John McCaskey" <[EMAIL PROTECTED]>
13/01/2006 17:20
To
"MySQL"
cc
Subject
Huge number of
nt are *logically* and syntactically
done on the huge table produced by the joins. However, the MySQL optimiser
is not stupid and will perform the filter upstream of the JOIN where
possible. Some experimentation and use of the EXPLAIN statement may be
necessary to find the best ordering for querie
th
duplicate
> keys. I thought this was suppose to lock the table so that would not
happen.
>
> What am I not doing right? What am I not understanding about locking?
I think this problem is explained in detail at
http://dev.mysql.com/doc/refman/5.0/en/innodb-locking-reads.html
Alec
Alternatively, the MySQL installation usually sets up a database
imaginatively named "test" with wide rights, so that you could run you
experiments within database test.
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
number in the exim table. Then have another table to convert the
server name to a number. It is then trivially easy to use that table to
convert from server number to name or vice versa. And the server name no
l;onger has to be unique in the first N characters: as long as the names
differ, t
that you are optimising in the right
place before you dive in: your problem suggests that you are trying to fix
that which is not broken, and breaking other things in the process.
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
pecialist engine for seqrching
and sorting stuff in the most efficent manner. And then you have said that
you will disable all its optimisation and force it into a linear search.
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ure might make sense. But if searches are over >10 sensors or >10
days, this architecture will b become astoundingly inefficient.
Generally, I would expect MERGE tables to be used on much larger lumps of
time. If you have tables per month, any random period of a month can be
checked very e
flag with a 10 way join strikes me, as an engineer
rather than a theoretician, the wrong side of the elegance/practicality
trade-off.
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
his means that you have multiplied your number of disk accesses (ignoring
caching, again) by 6-11 times (assuming the master record takes two disk
accesses). That again seems a very high price to pay for theoretical
elegance.
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
roblems if, for example, you wanted
to run two such applications, because they would fight over it. Or if your
application wanted to run on a PC which already had MySQL running for some
other purpose.
So I would suggest that it would be wisest to do as Rhino implies and to
install MyS
ot; flag. All selects then need to add "and deleted = 0". But you
can find a (random) deleted row with "select id from table where deleted =
1 limit 1". If this returns a result, use update to re-populate that
record, clearing the deleted flag. If it returns nothing, use insert to
create a new record.
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
he synax ... primary key keyname (id, field2) ... ?
This creates a single key in which neither of the fields may be null and
the combination of the two fields (but not the two fields separately) must
be unique.
The effects on the two formulations both on constraints and on search
performance are dif
What is the byte size of an index for datetime type column?
How can I compute disk space required if I want to add an index on a
DATETIME column?
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
al variable ft_min_word_len to 3 to achieve what
you want. As shipped, it is set to 4, which means that words of three or
less letters are ignored. After changing the variable, you need to rebuild
the index.
Alec Cawley
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
used on. In simple
performance tests, it appears that named pipe access is between 30%-50%
faster than the standard TCP/IP access."
Alec Cawley
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ot; value, you will be in trouble. The function of autoincrement
keys is to assign unique record identifiers. Do not mix this with other
tasks.
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
e (on the Updates side at least) Raid 0 does not
help you, because there are no overlapping reads to get from alternate
disks.
Alec Cawley
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
field anymore.
> I'm completly lost here, any help would be greatly appreciated..
Please show your table description. This behaviour corresponds to the
AUTO_INCREMENT column being defined as a TINYINT, range -128..+127. You
probably need to change the definition of your key colum
s get
the most recent ID that you inserted, not the most recent that anyone
inserted.
I think, therefore, that the natural behaviour is what you want.
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
t show which new users
> have come the last hour, without that I need to edit the question
> each time I want to ask.
select from where date_sub(now(), interval 1 hour) <=
created ;
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
d inside MySQL, with a hostname to slave ID table
in the mysql database. Obviously, explicitly assigned slave IDs would
override this.
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
cords,
the commands suggested by David will certainly free space and probably
improve performance.
Alec Cawley
"Logan, David (SST - Adelaide)" <[EMAIL PROTECTED]> wrote on 08/03/2005
22:58:12:
> Hi Chris,
>
> For MyISAM/BDB tables use OPTIMIZE TABLE ;
> For In
cterised the behaviour of the system without this kludge in place?
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
s I know, there is no "file fiddling" way of doing what you wish
to achieve. You need, I guess, the InnoDB Hot Backup tool - see
http://www.innodb.com.
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
+
> + A, B +
> +-+
MySQL does not support arrays of data in one field. You cannot enter
multiple entries into a numeric field. You could, of course, enter it as a
string, but this is regarded as very bad practice. Most users would
inquire why you need to do this,
, so I don't think solutions like Lucene could work.
If your tables are all identical, which it sounds like, you want to create
a Merge Table: see
http://dev.mysql.com/doc/mysql/en/merge-storage-engine.html
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> Is there a more elegant (fast) way to do that with mysql?
> > >
> > > Somebody has some tips/doc where I could look for search engines?My
> >problem
> > > is that I don't have one big table with all the data but several
little
> >ones
> > >
select l.b, r.a = l.b from tab l join tab r on l.a = r.b where l.a = 1 ;
seems to produce the result you want
"Gabriel B." <[EMAIL PROTECTED]>
29/03/2005 09:30
Please respond to
"Gabriel B." <[EMAIL PROTECTED]>
To
mysql@lists.mysql.com
cc
Subject
help with a mutuality check (good query e
ore than
30% hits, it will probably be ignored unless the distribution of 0s and 1s
is very skewed. If you only have a tiny fraction of (say) 1s, it might be
useful to extract that tiny fraction - but useless for the opposite.
Alec
--
MySQL General Mailing List
For list archives: http
"Christopher Vaughan" <[EMAIL PROTECTED]> wrote on 30/03/2005 16:48:47:
> I have data in a table listed as
> 44:22:22
> 333:33:33
> It stands for hhh:mm:ss
> I want to break each part of the data into different parts based on
> the ':' to separate them. Then I want to take that data and sum it.
The command you need is
source ;
Alternatively, if you are outside the mysql clined
mysql <
Alec
"Joppe A" <[EMAIL PROTECTED]>
04/04/2005 09:59
To
mysql@lists.mysql.com
cc
Subject
how to run a file in MySQL
Hello all,
This is probably really basic f
to do a FULLTEXT search: see
http://dev.mysql.com/doc/mysql/en/fulltext-search.html
This requres using a FULLTEXT index on your column and using the MATCH
command.
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ther or not it is 45 (returns 1 if
it is).
mysql> select minute(now()) ;
+---+
| minute(now()) |
+---+
|58 |
+---+
1 row in set (0.06 sec)
mysql> select minute(now()) = 45 ;
++
| minute(now()) = 45 |
++
| 0 |
+--
tations of an IP
address.
http://dev.mysql.com/doc/mysql/en/miscellaneous-functions.html
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
#x27;s performance with respect
to
> merges? Needless to say, unless I can improve MySQL's
>
> performance, I will not be converting to MySQL at this time.
You need to post the results of EXPLAIN together
with the structures of your tables, including indexes.
This sort of pe
ort the records during SELECT. But to do
exactly this is what databases are designed to do: to accept data
essentially randomy, build and maintain indexes on that data, and use
those indexes at SELECT to produce a finely crafted subset of your data.
Alec
Christoph Lehmann <[EMAIL
is qitel
likely to deliver them in the order of that index - which may not be the
primary key. Indeed, the optimiser theoretically might use different
indexes for the same query on different days, as the table cnages.
It is therefore *never* safe to assume any sort of ordering unless you
specify it.
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
s like? A year or so ago, the manufacturers drastically cut the
warranties on their ATA drives, without changing the SCSI. Where to SATA
fall in this spectrum?
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
duckies" has a very large number of hits but the phrase does not.
In sum, I wouldn't bother with this optimisation unless your search truens
out in practice to be slow.
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ement a 64-bit LONGTIMESTAMP. This will
become easier in a few years when 64-bit OSs become mor the norm.
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
g the NOT
> EXISTS command?
LEFT JOIN sounds right to me:
SELECT a.* FROM a LEFT JOIN b ON a.userID = b.userID WHERE a.isactive = 1
AND b.buddyID IS NULL ;
All A A's which are active and do not have a buddy.
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
to your target time
and the last says you only want 15 of them.
This version is based on exact seconds from the target time (now() in my
case): the version which works in whole days would only be slightly
different.
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
gt; This does times relative to now(), but I am sure you can generalise
it.
> > The first line specifies the desired fields
> > The second selects (in principle) all the records within your largest
> > target window
> > The third orders them by closeness to your target time
>
ey pause requiring disk access. However, once they are
performing memory-locked operations, a single query will lock a CPU. On
multi-CPU machines, it will generally run queries in parallel on the
separate CPUs.
Alec
--
MySQL General Mailing List
For list archives: http://lists.
Hi all -
I've got a database along the lines of the following
--
| Transactions | | Products | | TransDetails |
--
| TransID | | ProdID | | TransID |
| TransDate| | ProdName | |
not to be recommended at all.
Could you perhaps explain what you are trying to achieve? There is quite
likely to be a better way to achieve it.
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
e two copies of
the data, I don't bother to RAID it, which cuts costs back down to nearly
the same as doing it with a single block of high-availability disks. There
is the further advantage (which I haven't exploited yet) that, which all
queries must go through the master, selects
w record is added, then it is automatically set to NOW().
Similarly, whenever the record is updated, if it is not explicitly set, it
is overwritten with NOW(). This therefore takes care of your updateddate
column. I think that there is no escape from putting "createddate = NOW()"
in all your INSE
2:34:56:01 into the dictionary as "words". Also, people, for reasons
outside our control, put reference strings into title information which may
contain dashes and underscores, which they would like to search on.
Alec Cawley
--
MySQL General Mailing List
For list archives: http://l
nner. To some extent, it depends uponn your application which is
right: engineering vs. finance.
Your system appears to be showing Windows behaviour. You could, I suppose,
try rebuilding MySQL under Cygwin to get Unis-style behaviour. But this
seems a sledgehammer to crack a nut.
thernet_address column has been specified to be UNIQUE.
The MySQL IF is an operator, not a flow control structure: It would map
more closely to the C "A?x:y" operator rather than the " if () then {} else
{}".
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
do this?
Try SELECT FROM ORDER BY RAND() LIMIT 1 ;
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> course, the only documentation I have is a Post-It
> note with the root password on it.
That's a historic quote which should be framed and put above any database
developers monitor.
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscri
I think count(*) is a special case: MyISAM holds a record count which it
can access instantly, InnoDB has to count rows. Does the time difference
persist for real queries?
Alec
Jiří Matějka <[EMAIL PROTECTED]> wrote on 18/02/2004 10:38:13:
> Hi all,
> I'm using m
s. While I am sure
that there is an analytic way of handling the problems which arise, I found
that it was very difficult to understand and a source of avoidable
confusion. I would recommend that in any case where mixed *nix and Windows
systems are involved, you keep database and table names ent
ate for you - you have
"duplicate" tables already.
I imagine the problem would not occur with InnoDB tables, which put all the
tables into a single data space (perhaps someone could confirm). In which
case you could solve the problem by changing table types.
Alec
--
e join users on c_table.users_id = users.id where
users.location_id = 3 ;
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
com/doc/en/LOCK_TABLES.html
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
1Mb L3, 8Gb ram, dual 15000 rpm Scsi with Raid 1 (for performance as well
as reliability).
Does this sound balanced for a MySQL engine? Or what would other people
advise?
Thanks for any advice,
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
avy joins. As I
understand it, if the data is in memory and no lock collisions occur, a
heavyweight query will hog a CPU until completed. Many CPUs (or virtual
CPUs, with hyperthreading) allow many opportunities for simple queries to
overlap complex ones.
Alec
--
MySQL General Mailing List
For list
1 - 100 of 325 matches
Mail list logo
