Details

Written by: Super User

Category: SQL

Published: 13 November 2012

Hits: 3765

Read more: Lock modes: shared, exclusive

Details

Written by: Super User

Category: SQL

Published: 10 November 2012

Hits: 3719

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: 4146

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.