DPO1_U4_A2_ADO | Paradigmas de programación | Datos informáticos

Please download to get full document.

View again

All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
 0
 
  -- Base de datos: `bdvillalobos` CREATE TABLE `autos` ( `placa` varchar(7) NOT NULL, `marca` varchar(70) NOT NULL, `modelo` varchar(100) NOT NULL, `year` int(11) NOT NULL, `color` varchar(50) NOT NULL, `combustible` varchar(70) NOT NULL, `tipo` varchar(7) NOT NULL, `codpropietario` varchar(15) NOT NULL, `fecreg` date NOT NULL, `descripcion` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; INSERT INTO `autos` (`placa`, `marca`, `modelo`, `year`, `color`, `combustib
Share
Transcript
  -- Base de datos: `bdvillalobos`CREATE TABLE `autos` ( `placa` varchar(7) NOT NLL! ` arca` varchar(7#) NOT NLL! ` odelo` varchar($##) NOT NLL! `%ear` i&t($$) NOT NLL! `color` varchar('#) NOT NLL! `co bustible` varchar(7#) NOT NLL! `tipo` varchar(7) NOT NLL! `codpropietario` varchar($') NOT NLL! `ecre` date NOT NLL! `descripcio&` varchar($##) NOT NLL) EN*+NE,+&&oB E.ALT C/AR0ET,ut12+N0ERT +NTO `autos` (`placa`! ` arca`! ` odelo`! `%ear`! `color`! `co bustible`! `tipo`! `codpropietario`! `ecre`! `descripcio&`) 3ALE0(4A56-$#4! 4Auris4! 4 Auris $8 C3T4! 9#$1! 43ERE4! 4*N34! 4ATO4! 49#$;8'714! 49#$1-#-994! 4O5T+<A0 CON+C+ON4)!(4A56-$#$4! 4TO=OTA4! 4>E554! 9#$'! 4RO>O4! 4*N34! 4CA<+ON4! 49#$;$#?$;'4! 49#$1-#-94! 4O5T+<A0 CON+C+ONE04)!(4A56-$#;4! 4TO=OTA4! 4>E54! 9#$8! 45LO<O4! 4*L54! 4ATO4! 49#$;$#?'$#4! 49#$7-$9-994! 4O5T+<A CON+C+ONE04)!(4A56-$#'4! 4TO=OTA4! 4>E554! 9#$'! 4RO>O4! 4*N34! 4CA<+ON4! 49#$;$#?'$#4! 49#$1-#-94! 4O5T+<A0 CON+C+ONE04)!(4A56-$#?4! 4Auris4! 4 Auris $8 C3T4! 9#$1! 43ERE4! 4*N34! 4ATO4! 49#$$9;84! 49#$1-#-994! 4O5T+<A0 CON+C+ON4)!(4A56-$9'4! 4Auris4! 4 Auris $8 C3T4! 9#$1! 43ERE4! 4*N34! 4ATO4! 49#$;8'714! 49#$1-#-994! 4O5T+<A0 CON+C+ON4)!(4A56-$;'4! 4Auris4! 4 Auris $# C3T4! 9#$7! 4RO>O4! 4*L54! 4ATO4! 49#$';1'8?4! 49#$1-#-#84! 4O5T+<A CON+C+ON4)!(4A56-$?4! 4TO=OTA4! 4>E54! 9#$1! 45LO<O4! 4*L54! 4ATO4! 49#$;$#?'$#4! 49#$7-$9-$4! 4O5T+<A CON+C+ONE04)!(4A56-'84! 4Auris4! 4 Auris $# C3T4! 9#$7! 4RO>O4! 4*L54! 4ATO4! 49#$';1'8?4! 49#$1-#-#84! 4O5T+<A CON+C+ON4)!(4A56-8'4! 4TO=OTA4! 4>E554! 9#$1! 4RO>O4! 4*N34! 4CA<+ON4! 49#$;$#?'$#4! 49#$1-#-9$4! 4O5T+<A0 CON+C+ONE04)2CREATE TABLE ` arcas` ( `&u re` i&t($$) NOT NLL! ` arca` varchar(7#) NOT NLL! ` odelo` varchar($##) NOT NLL) EN*+NE,+&&oB E.ALT C/AR0ET,ut12+N0ERT +NTO ` arcas` (`&u re`! ` arca`! ` odelo`) 3ALE0($! 4TO=OTA4! 4COROLLA4)!(9! 4TO=OTA4! 4=AR+0 0EAN4)!(! 4TO=OTA4! 4=AR+0 /B4)!(;! 4TO=OTA4! 4CA<R=4)!('! 4/%u&dai4! 4CRETA4)!(8! 4/%u&dai4! 4ACCENT4)!(7! 4/%u&dai4! 4ELENTRA4)!(1! 4/%u&dai4! 4EON4)2CREATE TABLE `propietario` ( `codpropietario` varchar('#) NOT NLL! `apater` varchar('#) NOT NLL! `a ater` varchar('#) NOT NLL! `&o bre` varchar($##) NOT NLL! `direccio&` varchar($') NOT NLL!   `distrito` varchar(?) NOT NLL! `teleo&o` varchar($##) NOT NLL! `correo` varchar($##) NOT NLL! `lice&cia` varchar($9) NOT NLL! `&acio&alidad` varchar('#) NOT NLL) EN*+NE,+&&oB E.ALT C/AR0ET,ut12+N0ERT +NTO `propietario` (`codpropietario`! `apater`! `a ater`! `&o bre`! `direccio&`! `distrito`! `teleo&o`! `correo`! `lice&cia`! `&acio&alidad`) 3ALE0(4$9;'8714! 4@EL5/+R4! 40AR=N4! 4*ARA4! 4Av A&cash4! 4L+<A-#$4! 4?;'97#74! 4E<ON'?9*<A+LCO<4! 4A$'?7;984! 45ERANA4)!(49$9$';4! 43ALAA04! 43OLTO4! 4.RO0T4! 4Av A&cash4! 4L+<A-974! 4?;'97#74! 4E<ON'?9*<A+LCO<4! 4A';$'8'4! 45ERANA4)!(49$';4! 4CALLA4! 4BOLTOR4! 4ROBERT4! 4Calle $?! & ;'4! 4L+<A-#$4! 4?;'97#74! � 4E<ON'?9*<A+LCO<4! 4A$';'$4! 45ERANA4)!(49$9;$99$4! 43AL6=R4! 4*ALBO4! 4ROBERT4! 4Calle $7! & ;'4! 4L+<A-974! � 4?;'97#74! 4E<ON'?9*<A+LCO<4! 4A$';4! 45ERANA4)!(49$'$8;4! 43AL6=R4! 4*ALBO4! 4+NARO04! 4Calle $7! & ;'4! 4L+<A-974! � 4?;'97#74! 4E<ON'?9*<A+LCO<4! 4A$'?7$9;4! 45ERANA4)!(4'$8$#';84! 43ALAA04! 43OLTO4! 4ROBERT4! 4Av A&cash4! 4L+<A-974! 4?;'97#74! 4E<ON'?9*<A+LCO<4! 4A9$';4! 45ERANA4)!(4';$1$94! 4@EL5/+R4! 4NE6RO4! 4ROBERT4! 4Av A&cash4! 4L+<A-#$4! 4?;'97#74! 4E<ON'?9*<A+LCO<4! 4A';9$4! 45ERANA4)!(4'8;$'$4! 4CALLA4! 4BOLTOR4! 4<ANEL4! 4Calle $?! & ;'4! 4L+<A-#$4! � 4?;'97#74! 4E<ON'?9*<A+LCO<4! 4A98;184! 45ERANA4)2ALTER TABLE `autos` A 5R+<AR= 6E= (`placa`)2ALTER TABLE ` arcas` A 5R+<AR= 6E= (`&u re`)2ALTER TABLE `propietario` A 5R+<AR= 6E= (`codpropietario`)2-- ATO+NCRE<ENT de las tablas volcadas-- ATO+NCRE<ENT de la tabla ` arcas`ALTER TABLE ` arcas` <O+.= `&u re` i&t($$) NOT NLL ATO+NCRE<ENT! ATO+NCRE<ENT,'$882
Related Search
We Need Your Support
Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

Thanks to everyone for your continued support.

No, Thanks
SAVE OUR EARTH

We need your sign to support Project to invent "SMART AND CONTROLLABLE REFLECTIVE BALLOONS" to cover the Sun and Save Our Earth.

More details...

Sign Now!

We are very appreciated for your Prompt Action!

x