当前位置：网站首页>Mysql Workbench uses .sql file to import data into database

Mysql Workbench uses .sql file to import data into database

2022-08-09 00:06:00 【Sweet and sour duck】

  1. Create the specified database (such as library name: message) in Mysql Workbench.
  2. Enter the bin folder in the MySQL directory: C:\Program Files\MySQL\MySQL Server 8.0\bin, enter cmd in the top box, and press Enter to enter the command line.
  3. Enter mysql -u root -p After entering MySQL, enter use message (the database name just created) to switch the database
    insert image description here
  4. Enter source d:/sqltest/message.sql (this is where the .sql file is stored)
    Insert image description here
  5. Data import is complete.
原网站

版权声明
本文为[Sweet and sour duck]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/221/202208090003186843.html

边栏推荐

猜你喜欢

随机推荐