Difference between revisions of "MySQL"

From Wikicliki
Jump to: navigation, search
 
Line 24: Line 24:
  
 
[[Image:repairtable.png]]
 
[[Image:repairtable.png]]
 +
 +
== Joke ==
 +
 +
http://gizmodo.com/5498412/sql-injection-license-plate-hopes-to-foil-euro-traffic-cameras
 +
  
 
== See Also ==
 
== See Also ==
  
 
[[Category:Programming]]
 
[[Category:Programming]]

Latest revision as of 19:09, 23 August 2013

Alter collation of wordpress tables to utf8

ALTER TABLE `wp_comments`  DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ; 
ALTER TABLE `wp_links`  DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ; 
ALTER TABLE `wp_options`  DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ; 
ALTER TABLE `wp_postmeta`  DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ; 
ALTER TABLE `wp_posts`  DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ; 
ALTER TABLE `wp_terms`  DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ; 
ALTER TABLE `wp_term_relationships`  DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ; 
ALTER TABLE `wp_term_taxonomy`  DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ; 
ALTER TABLE `wp_usermeta`  DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ; 
ALTER TABLE `wp_users`  DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ; 

the default is latin_swedish cos mysql is made in sweden!

NEW ADDITION - i think this one is new category added in new WP?

ALTER TABLE wp_commentmeta DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ; 

How to repair table in phpMyAdmin

Repairtable.png

Joke

http://gizmodo.com/5498412/sql-injection-license-plate-hopes-to-foil-euro-traffic-cameras


See Also