SELECT * FROM table
WHERE artnr BETWEEN '120000' AND '130000'
AND menge IS NOT NULL
ORDER BY art ASC, p DESC

+----+-------------+-------+------+---------------+------+---------+------+--------+-----------------------------+
| id | select_type | table | type | possible_keys | key  | key_len | ref  | rows   | Extra                       |
+----+-------------+-------+------+---------------+------+---------+------+--------+-----------------------------+
|  1 | SIMPLE      | table | ALL  | TEST          | NULL | NULL    | NULL | 533968 | Using where; Using filesort |
+----+-------------+-------+------+---------------+------+---------+------+--------+-----------------------------+

+----+-------------+-------+-------+---------------+------+---------+------+-------+-----------------------------+
| id | select_type | table | type  | possible_keys | key  | key_len | ref  | rows  | Extra                       |
+----+-------------+-------+-------+---------------+------+---------+------+-------+-----------------------------+
|  1 | SIMPLE      | fpos  | range | TEST          | TEST | 48      | NULL | 86134 | Using where; Using filesort |
+----+-------------+-------+-------+---------------+------+---------+------+-------+-----------------------------+

CREATE TABLE `tableX` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `art` int(11) unsigned NOT NULL default '0',
  `p` int(11) unsigned NOT NULL default '0',
  `artnr` varchar(6) character set latin1 default NULL,
  `name` varchar(45) character set latin1 default NULL,
  ...,
  PRIMARY KEY  USING BTREE (`id`),
  KEY `TEST` USING BTREE (`artnr`)
) ENGINE=InnoDB/MyISAM

CREATE TABLE `searcg_xxtemp` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `name` varchar(30) default NULL,
  `pw` varchar(30) default NULL,
  `email` varchar(255) default NULL,
  `isanonym` tinyint(4) NOT NULL default '0',
  `lastlogindatum` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`),
  KEY `user_idkennung` (`id`,`kennung`),
  FULLTEXT KEY `pw` (`pw`)
) ENGINE=MyISAM SELECT * FROM user WHERE {Filterdata goes here}

objID   stackVer   data1   data2   data3   recipeID
---------------------------------------------------
10001          1    66.4     2.3       3        101

drop table if exists Object;
create table Object
(
  objID          bigint not null,
  stackVer       tinyint not null,
  data1          real,
  data2          real,
  data3          real
);

create index idx_Object_objID on Object (objID);
create index idx_Object_stackVer on Object (stackVer);
create index idx_Object_objID_stackVer on Object (objID, stackVer);


drop table if exists ObjectStatus;
create table ObjectStatus
(
  objID              bigint not null,
  stackVer           tinyint not null,
  configID           tinyint,
  processingStatus   varchar(20) /* may be 'prepared', 'processing', 'processed' */
);

create index idx_ObjectStatus_objID on ObjectStatus (objID);
create index idx_ObjectStatus_stackVer on ObjectStatus (stackVer);
create index idx_ObjectStatus_objID_stackVer on ObjectStatus (objID, stackVer);
create index idx_ObjectStatus_processingStatus on ObjectStatus (processingStatus);


drop table if exists Config;
create table Config
(
  configID                 tinyint not null,
  configType               varchar(20), /* may be 'Auto', 'Manual', 'User1', 'User2'... */
  recipeID                 tinyint,
  configDescription        varchar(256)
);

insert into Config values (101, "Auto", 101, "Default");
insert into Config values (102, "Manual", 101, "Default");


drop table if exists Recipe;
create table Recipe
(
  recipeID                 tinyint not null,
  recipePath               varchar(256),
  recipeDescription        varchar(256)
);

insert into Recipe values (101, "/path/to/recipes/Default", "Default");

select Object.objID, Object.stackVer, Object.IcB1, Object.IcB2, Object.IcB3, a.recipeID from Object left outer join 
  (select Config.recipeID, ObjectStatus.objID, ObjectStatus.stackVer, ObjectStatus.processingStatus from ObjectStatus left outer join 
    Config on Config.configID=ObjectStatus.configID where ObjectStatus.processingStatus='prepared') a 
      on a.objID=Object.objID and a.stackVer=Object.stackVer where a.recipeID limit 2;

+----+-------------+--------------+------+----------------------------------------------------------------+-----------------------------------+---------+--------------------+---------+-------------+
| id | select_type | table        | type | possible_keys                                                  | key                               | key_len | ref                | rows    | Extra       |
+----+-------------+--------------+------+----------------------------------------------------------------+-----------------------------------+---------+--------------------+---------+-------------+
|  1 | PRIMARY     | <derived2>   | ALL  | NULL                                                           | NULL                              | NULL    | NULL               | 1070000 | Using where |
|  1 | PRIMARY     | Object       | ref  | idx_Object_objID,idx_Object_stackVer,idx_Object_objID_stackVer | idx_Object_objID_stackVer         | 9       | a.objID,a.stackVer |      11 |             |
|  2 | DERIVED     | ObjectStatus | ref  | idx_ObjectStatus_processingStatus                              | idx_ObjectStatus_processingStatus | 23      |                    | 1176300 | Using where |
|  2 | DERIVED     | Config       | ALL  | NULL                                                           | NULL                              | NULL    | NULL               |       2 |             |
+----+-------------+--------------+------+----------------------------------------------------------------+-----------------------------------+---------+--------------------+---------+-------------+

Things
------
ThingID BIGINT
Timestamp BIGINT 
Attribute VARCHAR(20)

Indexes
-----
AttributeTimestampIndex (Attribute, Timestamp)
ThingIDIndex (ThingID)

Thing ID | Timestamp | Attribute
1        | 1         | 'foo'
1        | 1         | 'bar'
2        | 1         | 'foo'
2        | 1         | 'baz'
3        | 2         | 'foo'

SELECT t1.Timestamp FROM Things t1, Things t2 WHERE t1.AttributeA = 'foo' AND t2.ThingID = t1.ThingID AND t2.AttributeA = 'bar' ORDER BY Timestamp

t2.Timestamp = t1.Timestamp

__ Questions ___________________________________________________________
Total         891.67M   128.0/s
  DMS         685.86M    98.4/s  %Total:  76.92
  Com_        111.21M    16.0/s           12.47
  COM_QUIT     97.60M    14.0/s           10.95
  -Unknown      3.00M     0.4/s            0.34
Slow 10 s           1     0.0/s            0.00  %DMS:   0.00  Log: OFF
DMS           685.86M    98.4/s           76.92
  SELECT      373.76M    53.6/s           41.92         54.50
  REPLACE     202.12M    29.0/s           22.67         29.47
  UPDATE      107.40M    15.4/s           12.04         15.66
  DELETE        2.42M     0.3/s            0.27          0.35
  INSERT      169.72k     0.0/s            0.02          0.02
Com_          111.21M    16.0/s           12.47
  set_option  102.20M    14.7/s           11.46
  stmt_prepar   2.99M     0.4/s            0.34
  stmt_execut   2.99M     0.4/s            0.34

__ Table Locks _________________________________________________________
Waited          9.49M     1.4/s  %Total:   0.79
Immediate       1.19G   170.1/s

SELECT DISTINCT guid, name as unique_name, ip as unique_IP, Violation, vdate, vtime
FROM tbl_player_kick 
LEFT JOIN tbl_guid ON tbl_player_kick.guid_id = tbl_guid.guid_id 
LEFT JOIN tbl_kick ON tbl_player_kick.kick_id = tbl_kick.kick_id 
LEFT JOIN tbl_name ON tbl_player_kick.name_id = tbl_name.name_id 
LEFT JOIN tbl_ip ON tbl_player_kick.ip_id = tbl_ip.ip_id 
LEFT JOIN tbl_violation ON tbl_player_kick.viol_type = tbl_violation.violation_id
LEFT JOIN tbl_date ON tbl_player_kick.date_id = tbl_date.date_id
LEFT JOIN tbl_time ON tbl_player_kick.time_id = tbl_time.time_id
WHERE tbl_player_kick.banned = 1

22 Init DB db_name
22 Query SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE OUTINE_SCHEMA='db_name' AND ROUTINE_NAME='mySP'
22 Query SHOW CREATE PROCEDURE `db_name`.`mySP`
22 Query call mySP (10)

MySqlParameter param1 = new MySqlParameter("?p_param", MySqlDbType.Int32);
param1.Value = 10;
param1.Direction = ParameterDirection.Input;
param1.IsNullable = false;
param1.MySqlDbType = MySqlDbType.Int32;

cmd.Parameters.Add(param1);
cmd.ExecuteNonQuery();

show table status\G
*************************** 1. row ***************************
           Name: name_table
         Engine: MyISAM
        Version: 10
     Row_format: Dynamic
           Rows: 259956366
 Avg_row_length: 128
    Data_length: 33460714548
Max_data_length: 0
   Index_length: 44122680320
      Data_free: 3640
 Auto_increment: NULL
    Create_time: 2008-10-06 14:59:57
    Update_time: 2008-10-16 12:19:30
     Check_time: 2008-10-06 15:32:38
      Collation: latin1_swedish_ci
       Checksum: NULL
 Create_options: partitioned
        Comment: