How to determine index size ?

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]

Re: Field name DESC

to 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 to know how i can create a table

RE: Reply / Return Address of this List

the 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 mysql@lists.mysql.com cc Subject RE: Reply / Return Address of this List

Re: Key and Primary Key

) ... ? 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 different. Alec -- MySQL General

Re: Question about autoincrement ID

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]

Re: How to shutdown mysql from Java

suggest that it would be wisest to do as Rhino implies and to install MySQL and leave it running all the time. Alec -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Accountability with MySQL

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]

Re: Accountability with MySQL

field. This 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

Re: Merge tables.

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]

Re: Merge tables.

. 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]

Re: Merge tables.

. And if the queries are of the form upon which days/sensors did event X happen, then splitting the table up is a one way path to doom. Alec -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: primary key

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, the table will work. Alec -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Newbie wants to load a couple of tables and join them

, 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]

Re: InnoDB and locking

? 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: Query Complexity Limit Question [Newbie Question]

, 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 queries. Alec -- MySQL General Mailing List For list archives: http

Re: Huge number of tables with InnoDB

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 mysql@lists.mysql.com cc Subject Huge number of tables with InnoDB

Re: MySQL 4.0, FULL-TEXT Indexing and Search Arabic Data, Unicode

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 UTF-8 encoded Japanese text. I see

Re: MySQL 4.0, FULL-TEXT Indexing and Search Arabic Data, Unicode

not properly support Unicode until version 4.1. I am successfully using FullText with MySQL 4.1 to sort UTF-8 encoded Japanese text. I see no reason why it should not work for Arabic - if you upgrade. Alec -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Question for JDBC and Mysql

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 = RS.getDate (1) ; which then allows you to use all the Java library's excellent date handling features. Alec -- MySQL General Mailing List For list

Re: Not finding customers without invoices

side is filled with nulls I think the SQL would be: SELECT customers.company, count(invoices.id IS NOT NULL) as invcount FROM customers LEFT JOIN invoices ON customers.id= invoices.customer_id GROUP BY customers.id ORDER BY customers.creation desc But read up on LEFT JOINs. Alec

Re: String insertion

it is a total waste of space. Any ideas? This is a feature of VARCHAR in MySQL V4 and before. It is fixed 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

Re: Clarification required

:\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 -- MySQL General Mailing

Re: Function to show when a field's value was last updated

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. Alec -- MySQL General

Re: Raw devices and MySQL

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]

Re: MySQL 4.1.13 lint?

as an error. Alec -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How to avoid redundancy between PK and indices ?

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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How to avoid redundancy between PK and indices ?

insert would have to include a full table scan. Alec C.R. Vegelin [EMAIL PROTECTED] 04/10/2005 15:10 To mysql@lists.mysql.com 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 have

Re: Double indexes on one field

inserts. Since a PRIMARY KEY is a UNIQUE index that happens to have been declared to be primary, you are simply storing the same information twice. I cannot think of any possible benefit in having two identical indexes on a table, and there is a cost to maintaining two index trees. Alec

Re: Advice Required

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: http://lists.mysql.com/mysql

Re: Advice Required

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 while I had been

Re: Circular Replication

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:http://lists.mysql.com/[EMAIL

Re: Myisam or innodb

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]

Re: Talking Limit

'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 -- MySQL General Mailing List For list

Re: SCO issue

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 (I think) harming SCO in any way. Alec Cawley

Re: migrating from Postgres to MySQL

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]

Re: Table Collation ?

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]

Re: INSERT IGNORE Doesn't Seem To Work

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: http://lists.mysql.com/mysql To unsubscribe:http

Re: INSERT IGNORE Doesn't Seem To Work

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.com cc Subject

Re: fulltext max size

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: sqlcreate table (test title longtext)TYPE=MyISAM; sqlalter table test add fulltext (title); Alec -- MySQL General Mailing List

Re: Partial Filtering

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't find the

Re: Complex query. (It's killing me)

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 ON

Re: Complex query. (It's killing me)

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, here is how I

Re: Newb learner question

. 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 Select * from products ; Alec -- MySQL General Mailing List For list archives

Re: How to sort results with german umlauts in a UTF8 MySQL Database

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 General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Multiple indexes on same column

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]

Re: use of indexes

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 indexes Hi field2 is indexed. I have 2 indexes

Re: Primary Key question

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 values to be separately unique, in which case you want PRIMARY KEY (id), UNIQUE (name) Alec -- MySQL General Mailing

Re: Avoiding full table scans

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]

Re: Records which link to other records in same table

-data-database Alec -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: create unique index

, maintaining an index takes extra CPU and disk power, so the database will not build an index unless you ask for it, which you should only do for columns used in WHERE clauses. But once created, the rest happens by magic (or rather, courtesy of the skills of the MySQL engineers). Alec

Re: question about field length for integer

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 archives: http

Re: Mysql overall stability

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]

Re: Concorrent users

. 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.mysql.com/mysql To unsubscribe:http

Re: Need help with a query..

be slightly different. Alec -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Need help with a query..

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 Only one problem with your solution, LIMIT tells how many records

Re: LEFT JOIN?

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]

Re: query help?

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]

Re: Index Question in MyISAM

. Alec -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SATA vs SCSI

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]

Re: SELECT Row Numbers?

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]

Re: newbie: how to sort a database without extracting the data

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 PROTECTED] 04/05/2005

Re: full-text search

/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]

Re: Question from a new user:MySQL vs MS SQLserver merges

. You need to post the results of EXPLAIN your select statement together with the structures of your tables, including indexes. This sort of performance dropoff is usually due to inappropriate indexes, and can be solved by adding or changing indexes. Alec -- MySQL General Mailing List

Re: How to make a virtual SELECT?

()) | +---+ |58 | +---+ 1 row in set (0.06 sec) mysql select minute(now()) = 45 ; ++ | minute(now()) = 45 | ++ | 0 | ++ 1 row in set (0.00 sec) Alec -- MySQL General Mailing List For list

Re: LIKE question - is it possible?

/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]

Re: how to run a file in MySQL

The command you need is source filename ; Alternatively, if you are outside the mysql clined mysql filename 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 for all

Re: Index on boolean column

, 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://lists.mysql.com/mysql

Re: if statement help

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. I wrote

Re: help with a mutuality check (good query exercise :)

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 exercise

Re: search through one/several tables

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]

Re: search through one/several tables

. 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

Re: Replicating InnoDB tables in new database

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]

Re: update a field with multiple value

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, and suggest that you should be reconsidering your table design if you need this sort of facility. Alec -- MySQL General Mailing List For list

Re: temporary tables

? Alec -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Compressing after Deletion

, 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 your table name; For InnoDB tables try ALTER TABLE

Re: Automatic server-id generation for slaves?

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]

Re: last_insert_id

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]

Re: how to make question that check the last hour

the question each time I want to ask. select colums from table 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]

Re: auto-increment stops at 127

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 column. Alec -- MySQL General Mailing List For list

Re: How to specify autoincrement primary key value

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]

Re: AW: Slow Replication

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]

Re: Performance of Sockets vs. TCP/IP connections on localhost?

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]

Re: ft_stopword_file

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]

Re: Syntax diagram, where is it located in the doc?

, apparently not. I have never seen such a thing. Alec Cawley -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Syntax diagram, where is it located in the doc?

of Operatiors applied to column names and constants. See manual chapter 12: Operators. The WHERE clause restricts to rows where the expression returns true. Alec Cawley. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

RE: Syntax diagram, where is it located in the doc?

XOR 1;) ; Alec Cawley -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Data in different tables or is one big table just as fast?

the table into daily, weekly, or monthly sub-tables. This means that you can archive very old months, and pack recent months, while keeping only the current month active. But if you need to search the entire archive frequently, this will reduce performance. Alec -- MySQL General Mailing

Trouble with Virus checkers

in this? Have other people had this sort of problem, and how did they cope with it? To my regret, the reply switch to *nix is unacceptable to my management. Alec -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: Can Mysql hold possible field values?

e.g TRUE or FALSE. A SET is a group of possible values e.g. IN_STOCK, ON_ORDER, SHORTAGE, OBSOLETE. A in the first case the thing must be either TRUE or FALSE, but there are sizteen posssible combinations such as IN_STOCK/OBSOLETE, ON_ORDER/SHORTAGE and so on.. Alec -- MySQL General

Re: Amount of data stored in a blob

, it avoids special logic for mapping the 65538 case to zero and erroring the zero case. If you want 65536, go for a MEDIUMBLOB: the overhead is only one part in 60,000. Alec -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: Full text Searching on C#, C++

as a letter. Alec -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: adding automatic alert

Roger Baklund [EMAIL PROTECTED] wrote on 06/01/2005 12:25:31: Aji Andri wrote: Hi all, I'm make an inventory goods database, in one of my table I need to make an automatic alert when my stock reach it's limit (say for tires it's limit is 4), can I make an automatic alert for it so when

Re: Full Text Search - Limits?

keywords (they must both be in the same pararaph) but should have little effect on the efficiency of the index. Alec -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Replication question...

what you want. If you break that rule, behaviour will be unpredictable. You might want to use the replicate_do_db variable to provide a partial enforcement of the rule. Alec -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: binary column type

but didn't find any clue about it thanks for your help before. BINARY is usually used on character columns to tell MySQL to do an case-dependent rather than case-independent indexing and selection. By default, character columns use case-independent ordering. Alec -- MySQL General Mailing

Re: Insert statement problem

indexes right. I think what you want is an Update, not an Insert. Alec -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: [Fwd: row numbers, jumping rows]

I think the reason nobody has replied is that the term row number does not really have any meaning in a DBMS. How the database stores rows inteneally is the DBMS's private business, and should not be visible to you. I think it is true that MySQL does not *have* an internal row number, so there

Re: [Fwd: row numbers, jumping rows]

João Borsoi Soares [EMAIL PROTECTED] wrote on 23/11/2004 12:34:01: First thanks for the answer Alec. But I think you didn't understood my problem. Maybe nobody replied because of that. Let me try again. Suppose I make a select which returns 100 ordered rows. I only want to read rows

Re: 2 ways Replication in MySQL

to the local slave and could therefore continue when the link was down. At the application level, we pipelined a few necessary but uncomplicated updates to be done when the link returned. Alec -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Three Questions

such type. When I have to store such types, I use absolute milliseconds stored in BIGINTs. Alec Cawley -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

  1   2   3   4   >