rick emmet wrote:
> My database backround is mostly in MS Access and I use Append Queries quite a lot. Does MySQL
> have an equivalent to the Append Query, or is it only a feature of Access?
If I'm remembering correctly, Access Append Queries are implemented with something similar to the following MySQL INSERT syntax (you can verify this by looking at the Access SQL):
INSERT [LOW_PRIORITY | HIGH_PRIORITY] [IGNORE]
[INTO] tbl_name [(col_name,...)]
SELECT ...
[ ON DUPLICATE KEY UPDATE col_name=expr, ... ]
(see
http://dev.mysql.com/doc/mysql/en/insert.html).
What happens when you do an Append Query on MySQL tables linked to Access?
--
felix
Please use
BBCode to format your messages in this forum.