当前位置：网站首页>Mysql database connection / query index and other common syntax

Mysql database connection / query index and other common syntax

2022-07-26 08:34:00 【ZenPower】

  • Connect mysql database

mysql -u user name -p password -h host IP

mysql -u root -p 123456 -h 10.77.77.77
 or 
mysql -uroot -p123456 -h10.77.77.77

 notes ： For general security reasons, do not directly enter password plaintext , Enter only -p, Then enter the password at the command prompt
  • Get table index information

show index/keys from Table name ;

show index from TABLE;
show keys from TABLE;
  • Get before a date / after N God / The date of the month 
-- Get before the current date / after 7 The date of day 
select date_sub(now(), interval 7 day);
select date_add(now(), interval 7 day);

-- Get before the current date / after 7 The date of the month 
select date_sub(now(), interval 7 month);
select date_add(now(), interval 7 month);
  • other
原网站

版权声明
本文为[ZenPower]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/201/202207181752354456.html

边栏推荐

猜你喜欢

随机推荐