enow.com Web Search

Search results

1. Results from the WOW.Com Content Network

2. How do I rename a MySQL database (change schema name)?

   stackoverflow.com/questions/67093

   MySQL rename database documentation says rename_database was intended for a very specific renaming task (not general case of DB renaming), which is now handled with alter database: 'To perform the task of upgrading database names with the new encoding, use ALTER DATABASE db_name UPGRADE DATA DIRECTORY NAME instead' You can't use this to rename ...

3. mysql - How to change collation of database, table, column? -...

   stackoverflow.com/questions/1294117

   ALTER TABLE mytable CONVERT TO CHARACTER SET utf8 To set default collation for the whole database, ALTER DATABASE `databasename` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin or else, Goto PhpMyAdmin->Operations->Collation. There you an find the select box which contains all the exsiting collations. So that here you can change your collation.

4. How do I change the data type for a column in MySQL?

   stackoverflow.com/questions/1356866

   alter table table1 modify finished bit(1) NOT NULL; alter table table2 modify canItBeTrue bit(1) NOT NULL; alter table table3 modify canBeNull bit(1) NULL; !! Does not keep unique constraints, but should be easily fixed with another if-parameter to concat. I'll leave it up to the reader to implement that if needed..

5. database - How can I modify the size of column in a MySQL table...

   stackoverflow.com/questions/1279568

   I misread your original question, you want VARCHAR(65353), which MySQL can do, as long as that column size summed with the other columns in the table doesn't exceed 65535. mysql> create table foo (str1 varchar(300), str2 varchar(300)); mysql> alter table foo modify str2 varchar(65353); ERROR 1118 (42000): Row size too large.

6. character encoding - How to convert an entire MySQL database ...

   stackoverflow.com/questions/6115612

   Use the ALTER DATABASE and ALTER TABLE commands. ALTER DATABASE databasename CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; ALTER TABLE tablename CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; Or if you're still on MySQL 5.5.2 or older which didn't support 4-byte UTF-8, use utf8 instead of utf8mb4:

7. mysql - How to change the CHARACTER SET (and COLLATION)...

   stackoverflow.com/questions/5906585

   Beware that in Mysql, the utf8 character set is only a subset of the real UTF8 character set. In order to save one byte of storage, the Mysql team decided to store only three bytes of a UTF8 characters instead of the full four-bytes. That means that some east asian language and emoji aren't fully supported.

8. Rename MySQL database - Stack Overflow

   stackoverflow.com/questions/12190000

   mysql -u root -p my_new_database < original_database.sql mysql -u root -p -e drop database originl_database Hope this helps and this is a reliable means to accomplish it without using some ad-hoc method that will corrupt your data and create inconsistencies.

9. sql - Rename a column in MySQL - Stack Overflow

   stackoverflow.com/questions/30290880

   Changing name in MySQL we have to use "ALTER" table command followed by "CHANGE". Below is the query. ALTER TABLE tablename CHANGE COLUMN oldcolname newcolname datatype; ALTER TABLE tablename CHANGE oldcolname newcolname datatype; PS- You can add "COLUMN" word or ignore in the query. It will work same. "RENAME" is used in Oracle database.

10. database - Rename a table in MySQL - Stack Overflow

    stackoverflow.com/questions/12650370

    The MySQL syntax for RENAME TABLE statement is the following: RENAME TABLE <old_table_name> TO <new_table_name> In your query, you've used group which is one of the keywords in MySQL. Try to avoid MySQL keywords for names while creating tables, field names and so on.

11. How do I change the database name using MySQL? [duplicate]

    stackoverflow.com/questions/19806065

    shell> mysqldump -hlocalhost -uroot -p database1 > dump.sql mysql> CREATE DATABASE database2; shell> mysql -hlocalhost -uroot -p database2 < dump.sql If you want to drop database1 otherwise leave it. mysql> DROP DATABASE database1; Note : shell> denote command prompt and mysql> denote mysql prompt.