MySQL 插入数据

MySQL 插入数据

MySQL 表中使用 INSERT INTO SQL语句来插入数据。

语法

INSERT INTO table_name ( field1, field2,...fieldN )
                       VALUES
                       ( value1, value2,...valueN );

以下是实战操作 各位看官老爷请细看:

INSERT INTO student ( student_name, student_age, submission_date )
VALUES
   ( "宫本", "16", NOW( ) );
INSERT INTO student ( student_name, student_age, submission_date )
VALUES
   ( "婉莹", "16", NOW( ) );
   INSERT INTO student ( student_name, student_age, submission_date )
VALUES
   ( "东皇", "16", NOW( ) );

出现以下结果即显示为成功

INSERT INTO student ( student_name, student_age, submission_date )
VALUES
	( "宫本", "16", NOW( ) )
> Affected rows: 1
> 时间: 0.004s


INSERT INTO student ( student_name, student_age, submission_date )
VALUES
	( "婉莹", "16", NOW( ) )
> Affected rows: 1
> 时间: 0s


INSERT INTO student ( student_name, student_age, submission_date )
VALUES
	( "东皇", "16", NOW( ) )
> Affected rows: 1
> 时间: 0s

这是运行结果;