MySQL selection syntax

EnverexEnverex Worcester, UK Icrontian
edited December 2005 in Internet & Media
I'd like to change the default character set and character sets of every table and entry structure in the entire MySQL system or selected database. Is there actually any way of doing that? At the moment I have to do every one individually like:

ALTER TABLE `blah` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

So, any idea?

Comments

  • KwitkoKwitko Sheriff of Banning (Retired) By the thing near the stuff Icrontian
    edited December 2005
    ALTER DATABASE
  • EnverexEnverex
    stabs the forum

    Why does SM only selectively email me to tell me someone has replied? Sometimes it will email me and other times (like now) it wont.... grrr....
     Worcester, UK Icrontian
    edited December 2005
    stabs the forum

    Why does SM only selectively email me to tell me someone has replied? Sometimes it will email me and other times (like now) it wont.... grrr....
  • EnverexEnverex Worcester, UK Icrontian
    edited December 2005
    Ok, I saw that page but it doesn't really help. I know the syntax to change it normally, but what is the syntax to change everything at once, normally like you'd use * for?
  • MiracleManSMiracleManS Chambersburg, PA Icrontian
    edited December 2005
    I'm not so sure you can do a general change of everything since you've already made the database...because there are changes you can make that can't be done to other things, etc...

    I hope that makes sense...

    Like altering everything to be a primary key or some such but they can't be...(bad example). Just...I don't think you can.
Sign In or Register to comment.