Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
ACTIVIDAD
CREATE DATABASE EMPRESA; USE EMPRESA CREATE TABLE EMPLEADOS ( num_emp INT(5) NOT NULL AUTO_INCREMENT, nom_emp VARCHAR(50) NOT NULL, rfc_emp VARCHAR(13) NOT NULL, fing_emp DATE, fbaja_emp DATE, salmen_emp FLOAT(7.2), saldia_emp FLOAT(7.2), salint_emp VARCHAR(7.2), puesto_emp VARCHAR(20), turno_emp VARCHAR(10), PRIMARY KEY (num_emp)); DESCRIBE EMPLEADOS;
run
|
edit
|
history
|
help
0
MySQL : calculate overlapping periods
grre
Simon_Test1
Práctica MySQL 1
user data by unspecific date, according to param "last entry, last but one, last but two, etc."
Show Tables
Get max score and the fields in the max score row in MySQL 5.7
W
par
test