Skip to content

Instantly share code, notes, and snippets.

@parzibyte
Created January 20, 2021 20:41
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save parzibyte/c9619b3069c3301939a739c5cc13a6db to your computer and use it in GitHub Desktop.
Save parzibyte/c9619b3069c3301939a739c5cc13a6db to your computer and use it in GitHub Desktop.
MariaDB [login]> describe usuarios; describe intentos_usuarios; select * from usuarios; select * from intentos_usuarios;
+-----------------+---------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+---------------------+------+-----+---------+----------------+
| id | bigint(20) unsigned | NO | PRI | NULL | auto_increment |
| correo | varchar(255) | NO | | NULL | |
| palabra_secreta | varchar(255) | NO | | NULL | |
+-----------------+---------------------+------+-----+---------+----------------+
3 rows in set (0.014 sec)
+------------+---------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+---------------------+------+-----+---------+-------+
| id_usuario | bigint(20) unsigned | NO | MUL | NULL | |
+------------+---------------------+------+-----+---------+-------+
1 row in set (0.012 sec)
+----+---------------------+-----------------+
| id | correo | palabra_secreta |
+----+---------------------+-----------------+
| 1 | parzibyte@gmail.com | 123 |
| 2 | luis@gmail.com | 123 |
+----+---------------------+-----------------+
2 rows in set (0.000 sec)
+------------+
| id_usuario |
+------------+
| 1 |
| 1 |
| 2 |
+------------+
3 rows in set (0.000 sec)
MariaDB [login]>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment