Basic Database Operations and basic database operations

Basic Database Operations and basic database operations
1. start mysql: 1. net start mysql (stop mysql: net stop mysql, where mysql is the service name when mysql is installed) 2. log on to mysql: cmd and enter mysql-h localhost-u username-p to enter the password. <-H-u-p followed by parameters> If the remote machine localhost is changed to an IP address, 3. the connection tool that comes with mysql is transient: The my. ini file is missing. Rename my-default-ini to my. ini. Right-click the built-in Connection Tool to view the location of my. ini. 4. Configure the environment variable and then restart cmd. 5. Installation Problems: mysql depends on. Net3.5 and. Net4.0. 6. Call mysql help :? Or help7. exit; exit or \ q8. Change password: mysqladmin-u username-p old password new password 9. selected Database: use databaseName10. display Database: show databases11. display the table in the default database: show tables12. discard the command being entered: \ c; command list \ h; view MYSQL server status information \ s13. display supported character sets: show charset; Modify Character set combination: set character_set_client = utf8/modify mysql. INI file show variables like '% character %' 14. display status information: status15. display table structure: desc table name 17. view TABLE details: show create table <indicates \ G> \ G makes the display more organized. * Obtain the version information: select version ();