Course Hive
Search

Welcome

Sign in or create your account

Continue with Google
or
Base de datos #12 | Eliminar (delete drop truncate)
Play lesson

Base de Datos - Base de datos #12 | Eliminar (delete drop truncate)

4.0 (3)
34 learners

What you'll learn

This course includes

  • 3.3 hours of video
  • Certificate of completion
  • Access on mobile and TV

Summary

Keywords

Full Transcript

En este vídeo aprende a eliminar registros, tablas y bases de datos utilizando las sentencias: delete, drop y truncate. No olvides suscribirte para tomar todos los cursos que estaremos impartiendo Visita nuestro canal: https://www.youtube.com/c/codigocompilado Nuestras redes sociales: Twitter: https://twitter.com/CodigoCompilado Facebook: http://bit.ly/CodigoCompiladoFacebook Correo: [email protected] ******************************************************* create database modificar use modificar create table producto( clave_prod int, nom_prod varchar(20), precio float, constraint pk_cp primary key (clave_prod)) create table cliente( clave_clie int, nom_clie varchar(20), constraint pk_cc primary key (clave_clie)) create table nota( folio int, clave_prod1 int, clave_clie1 int, cant int, subtot float, constraint fk_cp1 foreign key (clave_prod1) references producto (clave_prod), constraint fk_cc1 foreign key (clave_clie1) references cliente (clave_clie)) insert into producto values (1,'papas',7) insert into producto values (2,'refresco',9) insert into producto values (3, 'galletas',9) insert into cliente values (1,'ana') insert into cliente values (2,'sergio') insert into nota values (1,1,1,4,null) insert into nota values (2,2,2,1,null)

Course Hive

Continue this lesson in the app

Install CourseHive on Android or iOS to keep learning while you move.

Related Courses

FAQs

Course Hive
Download CourseHive
Keep learning anywhere