411 REFERENCE · Wikibooks
XML - Managing Data Exchange/Database and XML/Answers
Reference material by Wikibooks contributors. This retains its source identity and is not 411 news reporting.
<nowiki>
CREATE TABLE Movies (doc VARCHAR(150));
INSERT INTO Movies VALUES
('
<movie id="1">
<mtitle>Office Space</mtitle>
<mlength>89 min</mlength>
<mrating>R</mrating>
</movie>
');
INSERT INTO Movies VALUES
('
<movie id="2">
<mtitle>The Ghost and the Darkness</mtitle>
<mlength>109 min</mlength>
<mrating>R</mrating>
</movie>
');
INSERT INTO Movies VALUES
('
<movie id="3">
<mtitle>Donnie Darko</mtitle>
<mlength>118 min</mlength>
<mrating>R</mrating>
</movie>
');
</nowiki>
Image:MySQL Command Prompt screenshot.jpg