Benutzer:Andreas Plank/MySQL

-- information
  USE `artenquiz`; -- database
  SHOW TABLES; -- all tables
  SHOW CREATE TABLE `TaxonQuiz`; -- including constraints
  SHOW INDEX FROM `table`;
-- REPLACE(str,from_str,to_str)
  SELECT REPLACE('www.mysql.com', 'w', 'Ww');