Kategoriarkiv: Old Base

CREATE TABLE dice ( d_id int(11) NOT NULL auto_increment, roll int, PRIMARY KEY (d_id) ); insert into dice (roll) values (1); insert into dice (roll) values (2); insert into dice (roll) values (3); insert into dice (roll) values (4); insert … Læs resten →

CREATE TABLE log_01 ( pkey int(11) NOT NULL auto_increment, a int, b varchar(12), timeEnter timestamp(14), PRIMARY KEY (pkey) ) type=MyISAM; CREATE TABLE log_02 ( pkey int(11) NOT NULL auto_increment, a int, b varchar(12), timeEnter timestamp(14), PRIMARY KEY (pkey) ) type=MyISAM; … Læs resten →

Transactions: Not all table types support transactions. BDB and INNODB type do support transactions. Assuming the server has NOT been started with –skip-bdb or –skip-innodb the following should work: mysql> create table tran_test (a int, b int) type = InnoDB; … Læs resten →

Show status information on a table. Note, if the database was started with –safe-show-database or –skip-show-database some of these commands may not work. Note the “\G” option may provide a nicer format. Show the create statement: mysql> show create table … Læs resten →

The temporary tables could be very useful in some cases to keep temporary data. The most important thing that should be know for temporary tables is that they will be deleted when the current client disconnects You could try to … Læs resten →

mysql> show processlist; show processlist; +—–+——+———–+———+———+——-+——-+——————+ | Id | User | Host | db | Command | Time | State | Info | +—–+——+———–+———+———+——-+——-+——————+ | 657 | prog | localhost | weather | Sleep | 28619 | | NULL | … Læs resten →