Showing posts with label typing. Show all posts
Showing posts with label typing. Show all posts

Friday, 26 February 2016

How to Change a Go Daddy Absolute Hosting PathIn Feburary 2016 26,

In Feburary 2016 26,
Open your preferred Web browser.
Log in to your Go Daddy 'Account Manager' by typing your 'Customer No. or Login Name' and 'Password.'
Click 'Web Hosting' under the 'Products' section.
Click the 'Launch' button next to the hosting account you wish to modify.
Navigate to the 'Server' section. Replace the existing 'Absolute Hosting Path' with the new one. Click 'Save.'
In Feburary 2016 26,

Saturday, 20 February 2016

SQL Scripting TutorialIn Feburary 2016 20,

In Feburary 2016 20,
Open up the database program of your choice. This could be Microsoft Access, SQL Server, or Oracle. Create a few sample fields, such as First Name, Last Name, Address, City, State, and Zip. Then add a few sample records to test on.
Write your first query by typing out 'SELECT
FROM table_name' where table_name is the name of the table you created. This example returns every value from every field in the table within your database (the
indicates all). You can also say 'SELECT field_name FROM table_name' to select only the field_name field from your table.
Add to your last statement with the WHERE clause. The WHERE clause specifies which fields you want to return based on a certain value. 'SELECT * FROM table_name WHERE last_name = 'Morgan' ' will search for 'Morgan' in the last_name field and returns all records from the table in which the person's last name is Morgan. Note that if you are searching for a string (letters or words), you will need single quotes around the name. If you are searching for a number, you don't need the quotes.
Add to your last statement once again by using the ORDER BY clause. 'SELECT
FROM table_name ORDER BY last_name' will order your recordset by the person's last name in alphabetical order. You can also do 'SELECT
FROM table_name ORDER BY age' and it will order by the person's age (add DESC after the field name you wish to order by to list the names in descending order).
Create a new query by typing the INSERT INTO statement. The INSERT INTO statement inserts a new row into the table that you specify. 'INSERT INTO table_name VALUES ('Courtney','Morgan',14)' will add the first name of Courtney, the last name of Morgan, and the age of 14 into your table. Likewise, if you want to delete someone from your table, you will use the DELETE statement. 'DELETE FROM table_name WHERE last_name = 'Morgan' AND first_name = 'Courtney' ' will delete Courtney Morgan from your table.
Create another new query. Use the UPDATE statement. This will update a record instead of adding or deleting one. 'UPDATE table_name SET address = '555 Hollywood Blvd', city = 'Los Angeles' WHERE last_name = 'Morgan' AND first_name = 'Courtney' ' will update Courtney Morgan's address to 555 Hollywood Blvd and her city to Los Angeles.
In Feburary 2016 20,

Thursday, 18 February 2016

How to Find My Hostgator IP AddressesIn Feburary 2016 18,

In Feburary 2016 18,
Log on to your HostGator control panel, also known as cPanel. If you're unsure of how to access your cPanel, click the link found in the email you received once you purchased your HostGator hosting plan or by typing 'cpanel' at the end of your domain name, as an example, 'http://www.mywebsite.com/cpanel.' Don't include the quotes or punctuation. This takes you right to the Hostgator control panel after you input your username and password.
Scroll to the bottom of the cPanel page.
Look at 'IP Address' under the blue 'Account Information' bar. Here you will find your service plan, the IP address, the server name and your name servers.
In Feburary 2016 18,

Tuesday, 9 February 2016

How to Add an Administrator Account to Cisco RoutersIn Feburary 2016 09,

In Feburary 2016 09,
Connect a computer to a Cisco router using a Cisco serial or universal serial bus (USB) data cable.
Log in to the Cisco router as the administrator.
Enter the privileged EXEC mode. Access this mode by typing 'enable' or 'en' at the 'Router>' prompt.
Access the global configuration mode. Type 'configure terminal' or 'config t' at the 'Router#' prompt.
Add an administrative user. Type the following command at the 'Router(config)#' prompt, and then press 'Enter' on your computer's keyboard: 'username
priv 15 password
'For example, you could type 'username jdoe priv 15 password johnnydoe22,' which would create a user name 'jdoe' with a password 'johnnydoe22.'
Exit to the privileged EXEC mode. Press 'CTRL Z' until you're back at the 'Router#' prompt.
Save your changes. Type 'copy running-config startup-config,' and press the 'Enter' key on your computer's keyboard.
In Feburary 2016 09,