…auto_increment value (and of course does it without any warnings) Neither setting auto_increment value for underlying MyISAM tables works: mysql> alter table a1 auto_increment=100; Query…
Post: Using any general purpose computer as a special purpose SIMD computer
May 16, 2011 By 6 Comments
… database interface (MySQL): mysql> select word, md5(…KEY UPDATE `word`=VALUES(`word`), `md5(word)`=VALUES(`md5(word)`), `count(*)`=`count(*)` + VALUES(`count(*)`) Now, consider the query…of 3088896. This is the maximum theoretical degree of…dataset ( id bigint auto_increment primary key, prime_number …
Post: PROCEDURE ANALYSE
March 23, 2009 By 9 Comments
…mysql> desc node; +———-+——————+——+—–+———+—————-+ | Field | Type | Null | Key | Default | Extra | +———-+——————+——+—–+———+—————-+ | nid | int(10) unsigned | NO | PRI | NULL | auto_increment…
Post: Innodb row size limitation
April 7, 2011 By 11 Comments
… INT UNSIGNED NOT NULL AUTO_INCREMENT, fname TEXT NOT …KEY (id) ) Engine=InnoDB; Now you insert some test data into it: mysql> INSERT INTO example -> VALUES…First stylesheet’, ->Â Â ‘First terms’ -> ); Query OK, 1 row …maximum allowed value. So, if your problem domain allows you to limit the size of…
