Não saberia onde procurar estes arquivos sobrepostos.Não são arquivos sobrepostos, são backups do arquivo antes da atualização. Ficam no mesmo local onde ficariam os arquivos originais, e sendo arquivos que você pode ter modificado, a princípio ficariam em "/etc/mysql".
!include /etc/mysql/conf.d
!include /etc/mysql/mysql.conf.d
Em my.cnf.fallback!include /etc/mysql/conf.d
6.39 What is the “Adjust privileges” option when renaming, copying, or moving a database, table, column, or procedure?
When renaming/copying/moving a database/table/column/procedure, MySQL does not adjust the original privileges relating to these objects on its own. By selecting this option, phpMyAdmin will adjust the privilege table so that users have the same privileges on the new items.
For example: A user 'bob'@'localhost‘ has a ‘SELECT’ privilege on a column named ‘id’. Now, if this column is renamed to ‘id_new’, MySQL, on its own, would not adjust the column privileges to the new column name. phpMyAdmin can make this adjustment for you automatically.
Notes:
While adjusting privileges for a database, the privileges of all database-related elements (tables, columns and procedures) are also adjusted to the database’s new name.
Similarly, while adjusting privileges for a table, the privileges of all the columns inside the new table are also adjusted.
While adjusting privileges, the user performing the operation must have the following privileges:
SELECT, INSERT, UPDATE, DELETE privileges on following tables: mysql.`db`, mysql.`columns_priv`, mysql.`tables_priv`, mysql.`procs_priv`
FLUSH privilege (GLOBAL)
Thus, if you want to replicate the database/table/column/procedure as it is while renaming/copying/moving these objects, make sure you have checked this option.
ALTER TABLE 'mytable' CHANGE 'quitacao' 'quitacao' BOOLEAN NULL DEFAULT FALSE;
Incorrect date value: '' for column 'datavenc' at row 1
É como se o NULL não mudasse nada.
<input type="date" name="datavenc" value="<?php echo $datavenc; ?>" > <input type="checkbox" name="quitacao" id="quitacao" value="<?php echo $quitacao; ?>" <?php if ($quitacao=='1') { echo ' checked '; } ?> /> <input type="date" name="dataquit" value="<?php echo $dataquit; ?>" > $query = "INSERT INTO mytable (datavenc, quitacao, dataquit) VALUES ('$datavenc','$quitacao','$dataquit')"; Name: datavenc Type: date NULL: Yes Name: quitacao Type: tinyint(1) NULL: Yes Default: 0 Name: dataquit Type: date NULL: Yes |