How to Find Host and Domain Name
Terminal Command
hostname
Author Archives: admin
How to create a Virtual Host in CentOS 6.3
After installing apache in CentOS it would go to Apache 2 Test Page.
To locate this directory you need to go to /var/www/
In this directory you can create your file which you needs to run.
To set up Virtual Host navigate to /etc/httpd/conf/httpd.conf file
Open the file in gedit or editor of your preference.
Add the lines below
<VirtualHost *:80> DocumentRoot /var/www/sample/ ServerName virtualhost1 </VirtualHost>
The document root points out to sample older in www directory
The server name is virtual host name you type in URL
You should also add the code in /etc/hosts file
127.0.0.1 virtualhost1
Once this is done dont forget to restart apache server in terminal by typing service httpd.restart
Now you are ready to go now.Open the browser and type http://virtualhost1/
Cheers!!!
Protected: How to run PHP file from Cron Job Cent OS 6
Getting Rows from table whose status changes first time
Table Creation Script
CREATE TABLE Customers(Row_Id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
Cust_Name VARCHAR(255),
Created_Date DATE,
Cust_Status TINYINT)
The Rows in the table are as Below
INSERT INTO Customers(Cust_Name, Created_Date, Cust_Status)
VALUES('Customer A', '20120516', 0),
('Customer B', '20120516', 0),
('Customer C', '20120516', 0),
('Customer A', '20120517', 1),
('Customer B', '20120517', 0),
('Customer C', '20120517', 0),
('Customer A', '20120520', 1),
('Customer B', '20120520', 0),
('Customer C', '20120520', 1),
('Customer A', '20120521', 0),
('Customer B', '20120521', 0),
('Customer C', '20120521', 1),
('Customer A', '20120526', 1),
('Customer B', '20120526', 1),
('Customer C', '20120526', 0),
('Customer A', '20120530', 1),
('Customer B', '20120530', 1),
('Customer C', '20120530', 0);
I want to take the rows which changes their Cust_Status from 0 to 1 only for first time.
When I run the script by giving 20120517 as parameter to where clause it should return Customer A.
When I run the script by giving 20120520 as parameter to where clause it should return Customer C.
When I run the script by giving 20120526 as parameter to where clause it should return Customer B.
SELECT C.Cust_Name
FROM Customers C
WHERE C.Created_Date = '20120526' AND
C.Cust_Status = 1 AND
NOT EXISTS (SELECT c2.Cust_Name
FROM Customers c2
WHERE c2.Cust_Name = C.Cust_Name AND
c2.Cust_Status = 1 AND
c2.Created_Date < C.Created_Date)
How to install wine in CentOS 6.3
To install Wine in CentOS first check for yum Update using the below Command
yum check-update
Once this is done type
yum install wine
Static Methods and Variables in Java
How to call Static Method in Another Package
Sample4.java
package com.scjp.test;
public class Sample4
{
public static void CallMe()
{
System.out.println("I am Static in Another Package");
}
public static void main(String[] args)
{
}
}
Sample6.java
import com.scjp.test.*;
public class Sample6
{
public static void main(String[] args)
{
Sample4.CallMe();
}
}
Variables in Java
Default value of variable
package com.scjp.test;
class Sample3
{
int Size;
public static void main(String args[])
{
Sample3 objSample3 = new Sample3();
}
Sample3()
{
System.out.println(Size);
}
}
Constructors in java
Method name same as Class Name
void Sample3 is a method not a Constructor
package com.scjp.test;
public class Sample3
{
void Sample3()
{
System.out.println("I am Constructor");
}
public static void main(String[] args)
{
Sample3 objSample3 = new Sample3();
}
}
OP:
Overloading Constructors
package com.scjp.test;
class Sample3
{
public static void main(String args[])
{
Vasko objVasko1 = new Vasko(54);
Vasko objVasko2 = new Vasko();
System.out.println(objVasko1.Size);
System.out.println(objVasko2.Size);
}
}
class Vasko
{
int Size;
Vasko()
{
}
Vasko(int s)
{
Size = s;
}
}
OP:
54 0
download mysql workbench for centos 6.3
In the Platform you should select Oracle & Redhat
How to install apache in CentOS Terminal
Install Apache Server in Terminal CentOS
yum install httpd
Check Status of Apache Server
/etc/init.d/httpd status
Start Apache Server
/etc/init.d/httpd start
Start MySQL Terminal
/etc/init.d/service mysqld start
Check Status of MySQL
/etc/init.d/service mysqld status