Avatar
FROM INFORMATION_SCHEMA.COLUMNS
WHERE table_schema = 'database_name'
AND table_name = 'table_name'
[ view entry ] ( 1762 views ) | print article
!!!!CentOS 6.4 !!!!
//the following command overwrites /etc/resolv.conf (or when rebooting)
service network restart
//instead, add the following to /etc/sysconfig/network-scripts/ifcfg-eth0
DNS1=4.2.2.2
DNS2=4.2.2.1
!!!!!!!!!!!!!!!!!!!
//open this file
vim /etc/resolv.conf
//add entries
nameserver 4.2.2.2
nameserver 4.2.2.1
//test
nslookup barney.com
[ view entry ] ( 1923 views ) | print article
//edit interface configuration file
sudo vim /etc/sysconfig/network-scripts/ifcfg-eth0
//set settings
DEVICE=eth0
BOOTPROTO=none
HWADDR=00:05:29:E0:4F:3D
IPADDR=10.0.1.10
NETMASK=255.255.255.0
GATEWAY=10.0.1.1
DNS1=4.2.2.2
DNS2=4.2.2.1
ONBOOT=yes
TYPE=Ethernet
[ view entry ] ( 1836 views ) | print article
//list rules
iptables -L --line-numbers
iptables --list
//inserting rules
iptables -I INPUT -p tcp --dport 80 -j ACCEPT //inserts a rule on top
iptables -I INPUT 5 -p tcp --dport 21 -j ACCEPT //inserts a rule on the 5th position
//deleting rules by line number
iptables -D INPUT 5 //deletes the 5th rule
//saving rules
service iptables save //centos
[ view entry ] ( 1403 views ) | print article
//You might find strtotime useful in these situations.
setcookie('cons', 1, strtotime('today 23:59'), '/');
http://stackoverflow.com/questions/1313 ... t-midnight
[ view entry ] ( 1534 views ) | print article
//Open a new tab
ctrl+shift+T
//Switching tabs
ctrl+pageUp
//Also: Switching consoles in linux:
ctrl+alt+F1
ctrl+alt+F2
ctrl+alt+F3
ctrl+alt+F4
ctrl+alt+F5
ctrl+alt+F6
ctrl+alt+F7
[ view entry ] ( 1781 views ) | print article
<?php
/*
We'll get the content of a remote page to display locally ;)
*/
$curl=curl_init();
// Set some options - we are passing in a useragent too here
curl_setopt_array($curl, array(
CURLOPT_RETURNTRANSFER => 1,
CURLOPT_URL => 'http://www.televisa.com/us/',
CURLOPT_BINARYTRANSFER=>true,
));
// Send the request & save response to $resp
$resp = curl_exec($curl);
// Close request to clear up some resources
curl_close($curl);
echo $resp;
?>
[ view entry ] ( 1684 views ) | print article
SELECT * FROM tablename
WHERE somefield='something'
ORDER BY RAND() LIMIT 5
[ view entry ] ( 1672 views ) | print article
INSERT INTO NewTable (col1, col2, col3) SELECT col1, col2, col3 FROM OldTable
Page 985 in MySQL Developer's Library (Paul DuBois), and
http://stackoverflow.com/questions/3140 ... to-another
[ view entry ] ( 1754 views ) | print article
//Use the following query:
SELECT DATE(`date_time_field`) AS date_part, TIME(`date_time_field`) AS time_part FROM `your_table`;
//Also you can use:
SELECT DATE_FORMAT(colName,'%Y-%m-%d') DATEONLY,DATE_FORMAT(colName,'%H:%i:%s') TIMEONLY FROM `your_table`;
http://stackoverflow.com/questions/1233 ... e-in-mysql
[ view entry ] ( 1432 views ) | print article
<<First <Back | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | Next> Last>>