INSERT INTO student (ID, name, major, birthdate, email, gender) VALUES ('ms108537', 'Carlos Ceja', 'ISC', '1987-02-28', 'ms108537@iteso.mx', 1);
INSERT INTO student (ID, name, major, birthdate, email, gender) VALUES ('ms67482', 'Francisco Oblea', 'ISC', '1986-05-24', 'ms67482@iteso.mx',
1);
INSERT INTO student (ID, gender) VALUES ('ms101010', 0);
INSERT INTO student (ID) VALUES ('ms0000');
INSERT INTO student (ID, email) VALUES ('ms0000', 'ms0000@iteso.mx');

CREATE TABLE birthday (  empID text,  b_mon text,  b_day text,  b_yr text,
 PRIMARY KEY (b_mon)
);

INSERT INTO birthday (empID, b_mon, b_day, b_yr) vALUES ('Emp1', 'JUN', '25', '2000');
INSERT INTO birthday (empID, b_mon, b_day, b_yr) vALUES
('Emp2', 'JUN', '28', '2000'); select * from birthday;

DROP TABLE <tablename>;

CREATE TABLE birthday (  empID text,  b_mon text,  b_day text,  b_yr text,
 PRIMARY KEY (empID)
);
INSERT INTO birthday (empID, b_mon, b_day, b_yr) vALUES ('Emp1', 'JUN', '25', '2000');
INSERT INTO birthday (empID, b_mon, b_day, b_yr) vALUES
('Emp2', 'JUN', '28', '2000');

CREATE TABLE student2 (  firstName varchar,  LastName  varchar,
 PRIMARY KEY (firstName, LastName)
);
INSERT INTO student2 (firstName, LastName) VALUES ('Alberto','De Obeso');
INSERT INTO student2 (firstName, LastName) VALUES ('Juan','Lopez');
INSERT INTO student2 (firstName, LastName) VALUES
('Alberto','Sanchez');
SELECT * FROM student2 WHERE firstName = 'Alberto';

CREATE TABLE student2 (  firstName varchar,  LastName  varchar,
 PRIMARY KEY (firstName, LastName)
)
with clustering order by (firstName desc); SELECT * FROM student2 WHERE firstName = 'Alberto';
CREATE TABLE studentset (  name TEXT,  courses SET<TEXT>,  PRIMARY KEY (name)
);

INSERT INTO studentset(name, courses)
VALUES ('Vidal Ortiz', {'Sistemas Paralelos', 'Bases de Datos
Avanzadas'});
SELECT * FROM studentset;
UPDATE studentset(name, courses)
SET courses = courses + {'Ciencia de datos'}
WHERE name='Vidal Ortiz';
SELECT * FROM studentset;
UPDATE studentset(name, courses)
SET courses = courses - {'Ciencia de datos'}
WHERE name='Vidal Ortiz';
SELECT * FROM studentset;
Si repito un valor del conjunto no lo repite:
SET courses = courses + {'Sistemas Paralelos'}
WHERE name='Vidal Ortiz'; SELECT * FROM studentset;

CREATE COLUMNFAMILY studentlist (    name TEXT,    logins LIST<INT>,    PRIMARY KEY(name)
);

INSERT INTO studentlist(name, logins) VALUES ('Vidal Ortiz',
[2]);
select * from studentlist;

UPDATE studentlist SET logins = [3] WHERE name = 'Vidal Ortiz';
select * from studentlist;
UPDATE studentlist SET logins = [2,3,4,6,7,2]) WHERE name =
'Vidal Ortiz';
select * from studentlist;
UPDATE studentlist SET logins = + [100] WHERE name = 'Vidal
Ortiz';
select * from studentlist;

CREATE COLUMNFAMILY studentmap (    name TEXT,
   teachers MAP<TEXT, TEXT>,
   PRIMARY KEY(name)
);

INSERT INTO studentmap (name, teachers)
VALUES ('Vidal Ortiz', {
'Bases de Datos Avanzadas' : 'Alberto de Obeso', 'Sistemas Paralelos' : 'Jose Elvira'}); select * from studentmap;
INSERT INTO studentmap (name, teachers)
VALUES ('Rene Salgado', {
Gestión de Bases de Datos' : 'Rodolfo Luthe', 'Sistemas Paralelos' : 'Jose Elvira'});
select * from studentmap;
UPDATE student SET teachers['Sistemas Paralelos'] = 'Jose Luis Elvira';
select * from studentmap where name='Vidal Ortiz';