Månedsarkiv: januar 2006

MySQL: Getting a random roll of the dice

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

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

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

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

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

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

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?

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.

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

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

Udgivet i Uncategorized | Skriv en kommentar