MySQL: Difference between revisions
From DWIKI
mNo edit summary |
m →FAQ |
||
| Line 41: | Line 41: | ||
==FAQ== | ==FAQ== | ||
===fix logrotate on debian=== | |||
echo "SET PASSWORD FOR 'debian-sys-maint'@'localhost' = PASSWORD('`grep password /etc/mysql/debian.cnf | head -n 1 | awk -F= '{ gsub(/[ \t]+/, "", $2); print $2 }'`');" | mysql -u root -p | |||
===insert select=== | ===insert select=== | ||
insert into bar(c,d) select concat ("foo ",w) as c, concat("bar ",w) as d from foo; | insert into bar(c,d) select concat ("foo ",w) as c, concat("bar ",w) as d from foo; | ||
