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 Licensing or When do I have/want to pay for MySQL?.
select id from t where grp in (select grp from g where u > 100)
ALTER TABLE
on a table that is symlinked to another disk,
create temporary tables on this disk.
error 135
or Table
xxx is full
if you execute a query which has to use a big temporary table.
DISTINCT
qualifier to COUNT()
, SUM()
...
BLOB
as a TEXT
field.
DECRYPT()
.
FOREIGN
key definitions in the `.frm' file.
DEFAULT
values to columns. Give an error when using
an INSERT
that doesn't contain a column that doesn't have a
DEFAULT
.
SELECT CACHED ....
mysql_query()
commands in a row
without reading results or give a nice error message when one does this.
BIT
type to take 1 bit (now BIT
takes 1 char).
ctime()
doesn't work on some FreeBSD systems.
ORDER BY
to update. This would be handy with functions like:
generate_id(start,step)
.
IMAGE
option to LOAD DATA INFILE
to not update
TIMESTAMP
and AUTO_INCREMENT
fields.
LOAD DATA INFILE
understand 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
MIN()
, MAX()
(not group functions).
These should be synonyms for LEAST()
, GREATEST()
.
mysql
to netscape.
LOCK DATABASES
. (with various options)
NATURAL JOIN
.
DECIMAL
and NUMERIC
types can't read exponential numbers;
Field_decimal::store(const char *from,uint len)
must be recoded
to fix this.
EXTRACT
function.
mysql.cc
to do fewer malloc()
calls when hashing field
names.
EXPORT_SET(set_column,'Y','N',[separator],[number_of_set_values])where
separator
is ','
by default and
number_of_set_values
is taken from the set_column
(or is
64 if set_column
is an expression). For example:
EXPORT_SET(9,'Y','N',',',5) -> Y,N,N,Y,N
t1 JOIN t2 ON ...
and t1 JOIN t2 USING ...
Currently, you can only use this syntax with LEFT JOIN
.
unsigned long long
type.
LOCK DATABASE
function (for backups).
CASE
.
show status
. Counts for:
INSERT
/DELETE
/UPDATE
statements. 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).
ORDER BY
, GROUP BY
, temporary tables created.
mysql
in 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.
LEFT JOIN .. WHERE not_null_field IS NULL
much
faster. (This is often used to find rows that doesn't match)
SHOW INFO FROM tbl_name
for basic table information
should be implemented.
mysqld
to support many character sets at the same time.
get_changed_tables(timeout,table1,table2,...)
LAST_UPDATED(tbl_name)
update items,month set items.price=month.price where items.id=month.id;
GRANT
command with MySQL extensions.
SHOW
commands.
SET TIMESTAMP=#;
UNION
, MINUS
, INTERSECT
and FULL OUTER JOIN
.
(Currently only LEFT OUTER JOIN
is supported)
UNIQUE
on fields that can be NULL
.
SQL_OPTION MAX_SELECT_TIME=#
to put a time limit on a query.
LIMIT
to retrieve data from the end.
mysqld
version 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;
RAND()
:
SELECT email,RAND() AS ran FROM info ORDER BY ran;
zlib()
for gzip
-ed files to LOAD DATA INFILE
.
BLOB
columns (partly solved now).
AUTO_INCREMENT
value when one sets a column to 0.
Use NULL
instead.
JOIN
with parentheses.
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.
SELECT
s, 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 LOCK
TABLES
/UNLOCK TABLES
but we will make this more automatic in the
future.
Go to the first, previous, next, last section, table of contents.