Arkadius Jonczek arkadiusjonczek

## script.sh
sudo lsof -i
sudo netstat -lptu
sudo netstat -tulpn

## query.sql
SELECT DISTINCT uid
FROM tt_news
ORDER BY uid
INTO OUTFILE '/tmp/uids.csv'
LINES TERMINATED BY ',';

## bash.sh
readlink -f file.txt

## query.sql
SELECT DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS
WHERE table_name = 'oxarticles' AND COLUMN_NAME = 'OXID';

SELECT
  COLUMN_NAME, DATA_TYPE
FROM
  INFORMATION_SCHEMA.COLUMNS
WHERE
  TABLE_SCHEMA = 'ods'
AND

## query.sql
-- Query 1
SELECT
	sum(round(((data_length + index_length) / 1024 / 1024 / 1024), 2)) as "Size in GB"
FROM
	information_schema.TABLES
WHERE
	table_schema = "ods"

-- Query 2
SELECT

## Xdebug.ini
xdebug.profiler_enable=1
xdebug.profiler_output_dir="/var/www/debug"

## git.sh
# remove tag 1.1
git tag -d 1.1
git push origin :refs/tags/1.1

# tag current and push to origin
git tag 1.1
git push origin 1.1

## .htaccess
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /
RewriteRule ^(.*)$ http://domain.de [R=301,L]
</IfModule>

## copy-ssh-public-key.sh
cat ~/.ssh/id_rsa.pub | pbcopy

## snippet.sql
SELECT GROUP_CONCAT(OXID) FROM oxarticles LIMIT 100
	SELECT DISTINCT uid
	FROM tt_news
	ORDER BY uid
	INTO OUTFILE '/tmp/uids.csv'
	LINES TERMINATED BY ',';
	SELECT DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS
	WHERE table_name = 'oxarticles' AND COLUMN_NAME = 'OXID';

	SELECT
	COLUMN_NAME, DATA_TYPE
	FROM
	INFORMATION_SCHEMA.COLUMNS
	WHERE
	TABLE_SCHEMA = 'ods'
	AND
	-- Query 1
	SELECT
	sum(round(((data_length + index_length) / 1024 / 1024 / 1024), 2)) as "Size in GB"
	FROM
	information_schema.TABLES
	WHERE
	table_schema = "ods"

	-- Query 2
	SELECT
	xdebug.profiler_enable=1
	xdebug.profiler_output_dir="/var/www/debug"
	# remove tag 1.1
	git tag -d 1.1
	git push origin :refs/tags/1.1

	# tag current and push to origin
	git tag 1.1
	git push origin 1.1
	<IfModule mod_rewrite.c>
	RewriteEngine On
	RewriteBase /
	RewriteRule ^(.*)$ http://domain.de [R=301,L]
	</IfModule>