Browsing the MySQL Documentation by Topic
The MySQL Reference Manual is huge – far more than 2000 pages. On the
MySQL documentation team, we've been discussing how to split it into
easier to digest portions. But a real split doesn't seem the best thing
to do, so we've decided to make use of our
Good morning everyone,
products.id is defined as a PRIMARY KEY so it's index.
browse_nodes_to_products.product_id is defined as a INDEX so it's
indexed.
browse_nodes_to_products.browse_node_id is defined as an INDEX so it's
indexed.
browse_nodes.amazon_id is defined as an INDEX so it's
Glancing over things I suggest:
ALTER TABLE browse_nodes_to_products ADD INDEX(browse_node_id,product_id);
(if product_id has greater cardinality put that before browse_node_id)
The syntax:
inner join (browse_nodes, browse_nodes_to_products) on
(browse_nodes.amazon_id =
Hello everyone.
I have a complex situation. I have a list of related records (see
partial extract below) where I am trying to determine the unique lowest
number for each relation. This number should always be an AB number,
since all the MA numbers will always relate to an AB number. I need the
In your ini/cnf play around with the default-character-set variables.
[mysql]
# default-character-set=latin1
default-character-set=utf
C:\Program Files\MySQL\MySQL Server 5.0\binmysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: