MYSQL : CODIGO DE CLASE

 SENTENCIAS

CREATE
SELECT

INSERT INTO

CODIGO

create database ventas;

use ventas;

create table clientes(

id_cliente int auto_increment,

nombre varchar(33),

email varchar(40),

fecha DATE,

id_zona varchar(10),

primary key(id_cliente));

-- foreign key(id_zona) references zona(id_zona));

insert into clientes(nombre,email,fecha,id_zona)

values

('carlos','carlos@gmail.com','2026-05-14','z1');

select * from clientes;

insert into clientes(nombre,email,fecha,id_zona)

values

('vanesa','vane@gmail.com','2026-05-14','z1'),

('tadeo','tade@gmail.com','2026-05-14','z1'),

('julian','jul@gmail.com','2026-05-14','z1'),

('javier','jav@gmail.com','2026-05-14','z1'),

('renato','rena@gmail.com','2026-05-14','z1'),

('alfredo','alfre@gmail.com','2026-05-14','z1'),

('susana','susa@gmail.com','2026-05-14','z1');

use sakila;

select * from actor; 

select actor_id, first_name from actor;

select * from actor where last_name='chase';

select  distinct last_name from actor;

select * from actor limit 5;

select * from payment;

select * from payment order by amount desc;

select * from payment order by amount asc;