文档
我要评分
获取效率
正确性
完整性
易理解
提交关闭

Manually Adding Data to the Primary Database

  1. Log in to the primary database.
    1
    /usr/local/mysql/bin/mysql -uroot -p123456 -S /data/mysql/run/mysql.sock
  2. Create the test database.
    show databases;
create database test;
  3. Create a student table in the test database.
    use test
create table student(name char(100),age int);
show tables;
  4. Insert one data record into the student table.
    insert into student(name,age) values('David',18);
  5. Query data in the student table.
    select * from student;