Details

Written by: Super User

Category: SQL

Published: 13 November 2012

Hits: 3500

Read more: Lock modes: shared, exclusive

Details

Written by: Super User

Category: SQL

Published: 10 November 2012

Hits: 3469

Kom over en nettside med en god del tutorials for access:

http://www.599cd.com/tips/access/?key=ALZ

Details

Written by: Super User

Category: SQL

Published: 14 October 2012

Hits: 3937

For å slette flere tabeller med lik prefiks kjør denne SQL spørringen:

SELECT CONCAT( 'DROP TABLE ', GROUP_CONCAT(table_name) , ';' )
    AS statement FROM information_schema.tables
    WHERE table_name LIKE 'prefiks_%';

Når den er kjørt, kjører du en ny SQL spørring med utfallet fra forige spørring.