mysql

select * from `data_vtg` where `date` = CAST(CURRENT_TIMESTAMP AS DATE)

select * 

from data_vtg 

where 

date = cast(current_timestamp as date) 

and 

absence = 'true'

and

(date_start <= cast(current_timestamp as date) 

and 

date_end >= cast(current_timestamp as date))

- -

Dump just the table structure to a file in MySQL

mysqldump -d -h localhost -u root -pmypassword databasename > dumpfile.sql

mysqldump -d -h localhost -u root -p2Uad7as9 database01 > dumpfile.sql

- - - - - - -

mysqldump -u USER -p --opt --where="true LIMIT 10" DB TABLE > BU.sql

mysqldump -u USER -p --opt --where="true LIMIT 10" TABLE > BU.sql

mysqldump -u USER -p --opt --where="1 limit 1000000" DB TABLE > BU.sql

mysqldump -u USER -p --opt --where="1=1 ORDER BY id DESC LIMIT 1000" DB TABLE > BU.sql

mysqldump -u USER -p database --ignore-table=database.table1 > database.sql

mysqldump -u USER -p --no-data DB > BU.sql

#mysqldump -u $user -p --opt --where=$where $db_name --ignore-table=$db_name.$ignore_table > $BU_path/$db_name-$date.sql ;

#mysqldump --user=$user --password --where="TRUE ORDER BY id DESC LIMIT 1" $db --ignore-table=$db."data_words" > $BU/$db-$date.sql ;

- - - - - - -

$username = "username";

$password = "password";

$db = "dbname";

$filename ="dumpfilename.sql";

$rows = 10;

exec("mysqldump --opt --where='1 limit ".$rows."' -u ".$username." -p".$password." ".$db." > ".$filename);

- - - - - - -

SELECT table_schema AS "Database", ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS "Size (MB)" FROM information_schema.TABLES GROUP BY table_schema;

- - - - - - -

$sudo mysql -u root

[mysql] use mysql;

[mysql] update user set plugin='' where User='root';

[mysql] flush privileges;

[mysql] q