Everything in this list is in the order it will be done. If you want to affect the priority order, please register a license or support us and tell us what you want to have done more quickly. See section 3 MySQL licensing and support.
select id from t where grp in (select grp from g where u > 100)
mysqldto support many character sets at the same time.
ALTER TABLEon a table that is symlinked to another disk, create temporary tables on this disk.
RENAME table as table, table as table [,...]
FOREIGNkey definitions in the `.frm' file.
DEFAULTvalues to columns. Give an error when using an
INSERTthat doesn't contain a column that doesn't have a
SELECT CACHED ....
mysql_query()commands in a row without reading results or give a nice error message when one does this.
BITtype to take 1 bit (now
BITtakes 1 char).
ctime()doesn't work on some FreeBSD systems.
ORDER BYto update. This would be handy with functions like:
LOAD DATA INFILEto not update
LOAD DATA INFILEunderstand a syntax like:
LOAD DATA INFILE 'file_name.txt' INTO TABLE tbl_name TEXT_FIELDS (text_field1, text_field2, text_field3) SET table_field1=concatenate(text_field1, text_field2), table_field3=23 IGNORE text_field3
VARCHARsupport (There is already support for this in MyISAM).
LOCK DATABASES. (with various options)
NUMERICtypes can't read exponential numbers;
Field_decimal::store(const char *from,uint len)must be recoded to fix this.
mysql.ccto do fewer
malloc()calls when hashing field names.
t1 JOIN t2 ON ...and
t1 JOIN t2 USING ...Currently, you can only use this syntax with
unsigned long longtype.
show status. Counts for:
UPDATEstatements. Records reads and updated. Selects on 1 table and selects with joins. Mean number of tables in select. Key buffer read/write hits (logical and real).
GROUP BY, temporary tables created.
mysqlin the middle of a query, you should open another connection and kill the old running query. Alternatively, an attempt should be made to detect this in the server.
SHOW INFO FROM tbl_namefor basic table information should be implemented.
CONNECT BY PRIOR ...to search hierarchy structures.
mysqladmin copy database new-database.
IGNOREoption to the
UPDATEstatement (this will delete all rows that gets a dupplicate key error while updating).
DATETIMEto store fractions of seconds.
NULLfor calculated columns.
update items,month set items.price=month.price where items.id=month.id;
FULL OUTER JOIN. (Currently only
LEFT OUTER JOINis supported)
UNIQUEon fields that can be
SQL_OPTION MAX_SELECT_TIME=#to put a time limit on a query.
LIMITto retrieve data from the end.
mysqldversion which isn't multithreaded (3-5 days).
safe_mysqld: according to FSSTND (which Debian tries to follow) PID files should go into `/var/run/<progname>.pid' and log files into `/var/log'. It would be nice if you could put the "DATADIR" in the first declaration of "pidfile" and "log", so the placement of these files can be changed with a single statement.
UPDATE SET blob=read_blob_from_file('my_gif') where id=1;
gzip-ed files to
LOAD DATA INFILE.
BLOBcolumns (partly solved now).
AUTO_INCREMENTvalue when one sets a column to 0. Use
Time is given according to amount of work, not real time. TcX's main business is the use of MySQL not the development of it. But since TcX is a very flexible company, we have put a lot of resources into the development of MySQL.
SELECTs, and because we don't do transactions, we can be much quicker on everything else). We will support some kind of atomic operations on multiple tables, though. Currently atomic operations can be done with
UNLOCK TABLESbut we will make this more automatic in the future.