Monita

entrar a la carpeta de xampp
./mysql -uroot -p
source direccion del archivo.sql

show database;

use Northwind;

show tables;

select * from products;
select ProducID,ProducName,CategoryID from products;

select OrderID, OrderDate, ShipCity from Orders WHERE OrderDate between '1998-01-01' and '1998-03-31';

select OrderID, OrderDate, ShipCity from Orders WHERE OrderDate between'1998-01-01' and '1998-03-31' and ShipCity = 'Rio de Janeiro';


select OrderID, OrderDate, ShipCity from Orders WHERE OrderDate between '1998-01-01' and '1998-03-31' and ShipCity LIKE '%D.F.';select OrderID, OrderDate, ShipCity from Orders WHERE OrderDate between '1998-01-01' and '1998-03-31' and ShipCity LIKE '%D';

select OrderID, OrderDate, ShipCity from Orders WHERE OrderDate between'1998-01-01' and '1998-03-31' and ShipCity LIKE 'M%';


select OrderID, OrderDate, ShipCity, firstName from Orders, Employees WHERE OrderDate between '1998-01-01' and '1998-03-31' and ShipCity LIKE'%Ia' and Employees.EmployeeID = Orders.EmployeeID;


select OrderID, OrderDate, firstName from Orders, Employees WHERE OrderDate between '1998-01-01' and '1998-12-31' and Employees.EmployeeID =Orders.EmployeeID and firstName = 'Margaret';

select FirstName, LastName, count(*) as ventas from Employees, Orders WHERE Employees.EmployeeID = Orders.EmployeeID group by Orders.EmployeeID order byventas desc;


select FirstName, LastName, count(*) as ventas from Employees, Orders WHERE Employees.EmployeeID = Orders.EmployeeID and OrderDate between '1998-01-01' and '1998-12-31' group byOrders.EmployeeID order by ventas desc;



%%%%%%%%%%%%%%


create table alumno_materia(id int references Alumno(id),id_materia int references Materia(id_Materia), primary key (id,id_Materia) );insert into Alumno(nombre,email) values('changito lopez','change@hotmail.com'),('rositafresita','lafresa@jf'),('capulina','capu@gdj');

insert into Materia(nombre,horas_semanas) values('base de...