DokuWiki

Site Tools

Trace:
chuleta_mysql

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision		Previous revision
chuleta_mysql [2018/06/04 08:09] – creado etfiatchuleta_mysql [2020/06/10 10:51] (current) – etfiat
Line 1: Line 1:
 +
 +<code>
 +innodb_file_per_table=ON
 +</code>
 +
 <code> <code>
 mysql> create database gdpr; mysql> create database gdpr;
Line 8: Line 13:
 mysql> GRANT ALL PRIVILEGES ON gdpr . * TO 'user_gdpr'@'localhost'; mysql> GRANT ALL PRIVILEGES ON gdpr . * TO 'user_gdpr'@'localhost';
 Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec)
 +
 +mysql> create table hash  (id MEDIUMINT NOT NULL AUTO_INCREMENT, hash CHAR(150) NOT NULL, fecha DATE, PRIMARY KEY (id));
 +Query OK, 0 rows affected (0.09 sec)
 +
 +mysql> insert into hash (hash,fecha) VALUES ('123123',sysdate());
 +Query OK, 1 row affected, 1 warning (0.00 sec)
 +
 </code> </code>
chuleta_mysql.1528099751.txt.gz · Last modified: by etfiat