Created
May 12, 2021 20:54
-
-
Save eliizquierdo/a2502745fba86a0d772acfe806812a79 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| create database liceo; | |
| use liceo; | |
| -- Creamos la tabla Alumno | |
| create table Alumno( | |
| Id_Alum int(4), | |
| Nombre varchar(20), | |
| Edad_Alum int(3), | |
| primary key(Id_Alum) | |
| ); | |
| -- Agregamos a la tabla la columna llamada apellido con la acción add | |
| alter table Alumno | |
| add column Apellido varchar(20); | |
| -- Modificamos la columna apellido con una extención de 30 caracteres. | |
| alter table Alumno | |
| modify column Apellido varchar(30); | |
| -- Renombramos la columna Apellido por Ape_alum con una extencion de 30 caracteres. | |
| alter table Alumno | |
| change column Apellido Ape_alum varchar (30); | |
| -- Eliminamos la columna Ape_alum | |
| alter table alumno | |
| drop column Ape_alum; | |
| -- Renombramos la tabla Alumno a Clase | |
| rename table Alumno to Clase; | |
| rename table Clase to Alumno; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment