XML - Managing Data Exchange/Database and XML/Answers

From Wikibooks, open books for an open world
Jump to: navigation, search
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>
');


Screenshot.jpg