Månedsarkiv: januar 2006

MySQL: Getting a random roll of the dice

Udgivet den januar 27, 2006 af mike

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 →

Udgivet i Knowledge Base, Old Base, SQL | Skriv en kommentar

MySQL: Getting a random roll of the dice

Udgivet den januar 27, 2006 af Brian Lund Klint

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 →

Udgivet i Knowledge Base, Mysql | Skriv en kommentar

MySQL: MERGE: Several tables can be merged into one

Udgivet den januar 27, 2006 af mike

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 →

Udgivet i Knowledge Base, Old Base, SQL | Skriv en kommentar

Mysql transactions

Udgivet den januar 27, 2006 af mike

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 →

Udgivet i Knowledge Base, Old Base, SQL | Skriv en kommentar

Check om en streng kun indeholder bogstaver og mellemrum

Udgivet den januar 27, 2006 af mike

function IsAlpha($char) { if (preg_match(“/[a-z;A-Z]/”,$char)) { return true; } else if (in_array(htmlentities($char),explode(” “,”æ &Aelig; ø Ø å Å”))) { return true; } else if ($char == ” “) { return true; } else { return false; } } function StripSigns($string) … Læs resten →

Udgivet i Knowledge Base, Shellscript | Skriv en kommentar

Mysql show status information on table / show create

Udgivet den januar 27, 2006 af mike

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 →

Udgivet i Knowledge Base, Old Base, SQL | Skriv en kommentar

Mysql Clean up binary log files

Udgivet den januar 27, 2006 af Brian Lund Klint

Clean up binary log files. For a default install they may be in /usr/local/var/ with names ending in -bin.000001,-bin.000002,.. mysql> reset master; reset master; Query OK, 0 rows affected (0.02 sec) See (TIP 24:) details working with binary log files … Læs resten →

Udgivet i Knowledge Base, Mysql | Skriv en kommentar

How to create and use temporary tables in MySQL?

Udgivet den januar 27, 2006 af mike

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 →

Udgivet i Knowledge Base, Old Base, SQL | Skriv en kommentar

MySQL: Find out who is doing what, and kill the process if needed.

Udgivet den januar 27, 2006 af mike

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

Udgivet i Knowledge Base, Old Base, SQL | Skriv en kommentar

Qmail on Debian

Udgivet den januar 26, 2006 af mike

Like this http://sylvestre.ledru.info/howto/howto_qmail_vpopmail.php

Udgivet i Uncategorized | Skriv en kommentar