JavaScript - jQuery - Handling JSON Data: Client, Meet Server(SQL,insert statement)

Head First jQuery
(O'Reilly Media)
Ryan Benedetti(著), Ronan Cranley(著)

開発環境

• OS X Yosemite - Apple (OS)
• Safari, Firefox, Google Chrome(Webプラウザ)
• Emacs (CUI)、BBEdit - Bare Bones Software, Inc.(GUI) (Text Editor)
• JavaScript (プログラミング言語)

Head First jQuery(Ryan Benedetti(著)、Ronan Cranley(著)、O'Reilly Media)のChapter 9(Handling JSON Data: Client, Meet Server)、EXERCISE(No. 4623)を解いてみる。

その他参考書籍

• Head First HTML and CSS
• Head First JavaScript Programming

EXERCISE(No. 4623)

SQL(BBEdit, Emacs)

insert into runners (first_name, last_name, gender, finish_time)
values ('John', 'Smith', 'm', 25:31);

insert into runners (first_name, last_name, gender, finish_time)
values ('', '', '', );

insert into runners (first_name, last_name, gender, finish_time)
values ('Mary', 'Brown', 'f', 26:01);

insert into runners (first_name, last_name, gender, finish_time)
values ('Frank', 'James', 'm', 26:08);

insert into runners (first_name, last_name, gender, finish_time)
values ('Bob', 'Hope', 'm', 26:38);

insert into runners (first_name, last_name, gender, finish_time)
values ('Jame', 'Smith', 'f', 28:04);

insert into runners (first_name, last_name, gender, finish_time)
values ('Ryan', 'Rice', 'm', 28:24);

insert into runners (first_name, last_name, gender, finish_time)
values ('Jacob', 'Zimmy', 'm', 29:24);