php

php.iniを素早く探したい時のコマンド。
コンソールから素早く探せます。

php -ini| grep /php.ini
#Loaded Configuration File => /etc/php.ini

SELECT * FROM users INTO OUTFILE ‘/tmp/users.csv’;

SELECT * FROM users INTO OUTFILE ‘/var/www/html/naotomi/public/export/2.csv’

mysql -u root | use naotomi :SELECT * FROM users INTO OUTFILE ‘/tmp/users.csv1’;

SELECT * FROM customers INTO OUTFILE “/tmp/1.csv” FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY ‘“‘ LINES TERMINATED BY “\r\n”;

mysql –user=roor < /var/www/html/naotomi/public/export/command/convert.sh

select * from customers into outfile “/tmp/1.csv” fields terminated by ‘,’;

SELECT * FROM customers INTO OUTFILE “/tmp/1.csv” FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY ‘“‘ LINES TERMINATED BY “\r\n”;

mv /tmp/1.csv /var/www/html/naotomi/public/export/1.csv -f
mysql –user=roor < convert.sh

mysqldump -u root naotomi csutomer > test.csv
mysqldump -u root naotomi > test.csv
nkf -sLw –overwrite *.csv

mysql –user=root –database=naotomi <<eof
select from customers into outfile “/tmp/1.csv”;
select from customers into outfile “/tmp/2.csv”;
select * from customers into outfile “/tmp/3.csv”;
eof

chown apache:apache /var/uploads

apache ALL=(ALL) ALL

$upDates = Nenga::get([‘updated_at’])->toArray();

ALTER TABLE customers ADD INDEX idx_1(kanri_bango);
ALTER TABLE zotos ADD INDEX idx_2(kanri_bango);
ALTER TABLE nengas ADD INDEX idx_3(kanri_bango);
ALTER TABLE selects ADD INDEX idx_4(index_code);
ALTER TABLE users ADD INDEX idx_5(id);
ALTER TABLE moves ADD INDEX idx_6(kanri_bango);

SHOW INDEX FROM tbl_Address;
SHOW INDEX FROM tbl_Address;
SHOW INDEX FROM tbl_Address;
SHOW INDEX FROM tbl_Address;