MySQL install and MySQL GUI installation as well as text file import MySQL

The People's Congress a sophomore has been using Windows system, was spoiled by the Microsoft Dad, a see cmd command line to scare urine. Now with Ubuntu, every operation is a statement, but also get exercise (a JB).

Ubuntu installs MySQL and Python code

sudo Install python-setuptoolssudoinstall libmysqld-devsudoinstall libmysqlclient-Devsudoinstall mysql-sudoinstall  mysql-clientsudoinstall python-devsudo easy_install Mysql-python

Then run MySQL and see if you can run.

Mysql-u root-p

See if Python can import MySQL model

Import MySQLdb  

Generally can do, not to fry, reload system who used to know

MySQL GUI installation: http://dev.mysql.com/downloads/workbench/

Next, double-click Deb,install

Import txt Reference: Blog

Open MySQL Workbrench

Create Database

Will find the lower left corner of the schemas more a database

Then you create the table

CREATE TABLE Libary (
Student ID int NOT NULL,
Date of borrowing datetime,
Book name varchar (50),
Book number varchar (10)
) Engine=innodb charset=gb2312

Refresh database We can see the tables inside the Libary table.

Then we import the TXT data

Delete all table data

truncate table educationdb.libary;

Searching the web for MySQL GUI tools import data discovery, there is a problem, so I under another MySQL tool navicat

Installation Reference: Blog

Hack Reference: Blog

After that, it's just as easy as sql-server.

If there is garbled:

You can edit Start_navicat. Modify the value of export Lang to match your system. If it doesn't work, go inside navicat, tool options, or fourth menu. Open the last one on this menu. Here is the option setting, where the second large menu is the appearance, the first submenu of the appearance is the font, the font is changed, and I choose the Noto sans CJK TC Blod. You can try it at will until it appears.

MySQL install and MySQL GUI installation as well as text file import MySQL