CSS Syntax : Chapter 2

What is CSS? CSS stands for Cascading Style Sheets Styles define how to display HTML elements Styles were added to HTML 4.0 to solve a problem External

Databse mysql

unauthenticated user in MYSQL process list

Some time in mysql process list you may see “unauthenticated user” increasing up it look like: | 1004 |

Asterisk

configuring digium TE235 and TE435 card in asterisk vicidial goautodial freepbx elastix

September 26, 2014 eduguru 1 Comment 1, configuring digium TE235 and TE435 card in asterisk vicidial goautodial freepbx elastix, Configuring TE235 in E1 mode. Step 1 : enabling the Line mode as E1 vi /etc/modprobe.d/dahdi.conf go to last line and paste the below line options wcte43x default_linemode=e1 save and exit the file. N, Dial(DAHDI/g0/${EXTEN:1}) were 9 is the prefix, if you want to change it, then edit in dahdi-channels.conf exten => _9X.

Digium’s (TE235) dual span digital interface cards support 48 (T1 / J1) or 60 (E1) connections to PSTN trunks over

linux

Change HostName From Command Line Linux

September 25, 2014September 25, 2014 eduguru 1 Comment change hostname, Change HostName From Command Line Linux, follow the steps shown below. 1. Use hostname command to Change Hostname In this example, hostname, hostname change, hostname change in linux, hostname command, how to change the hostname, it has changed the hostname to prod-server # hostname prod-server, To change the hostname, verify that it has changed the hostname successfully. As you see below, we’ll change the hostname from dev-server to prod-server. hostname command by default will display the current hostname as shown below: # hostname dev-server The following will change the hostname to

To change the hostname, follow the steps shown below. 1. Use hostname command to Change Hostname In this example, we’ll

info Uncategorized

Tech Plays vital Role in Business

September 24, 2014February 12, 2016 eduguru 3 Comments Tech Plays vital Role in Business, technology for business, technology for small organisation, Technology Plays Big Role in Small Business

Technology Plays Big Role in Small Business An important, but often overlooked, role many small business owners play is chief

Databse mysql

Managing Views in MySQL : Showing mysql view definition

September 22, 2014September 22, 2014 eduguru 0 Comments CONCAT (M.lastname, CONCAT(M.lastname, E.email AS employeeEmail, E.firstname) AS Employee, if you want to remove the organization view, M.firstname) AS Manager FROM employees AS E INNER JOIN employees AS M ON M.employeeNumber = E.ReportsTo ORDER BY Manager To display the view’s definition, M.firstname) AS Manager FROM employees AS E INNER JOIN employees AS M ON M.employeeNumber = E.ReportsTo ORDER BY Manager To verify the change, Managing Views in MySQL : Showing mysql view definition, modifying and removing views., modifying and removing views. Show view definition in MySQL MySQL provides the SHOW CREATE VIEW statement that helps you show view definition. The following is the syntax of the SHOW CREATE VIEW state, MySQL makes a back up of the view definition file to the/database_name/arc/ folder. In case you modify or remove a view by accident, Summary: in this tutorial, to open the organization view definition, we create a simple view against the employees table that displays the company’s organization structure: 12 3 4 5 6 7 8 CREATE VIEW organizationAS SELECT CONCAT (E.lastname, which allows you to check whether the view exists or not. It helps you avoid an error of removing a non-existent view. For example, you can find the view definition file with the following path: \data\classicmodels\organization.frm Modifying views Once a view is defined, you can get a back up from there. In this tutorial, you can modify it by using the ALTER VIEW statement. The syntax of theALTER VIEW statement is similar to the CREATE VIEW statement except the CREATE keyword is replaced by the ALTER keyword. 12 3 4 5 , you can query data from the organization view: 1 SELECT * FROM Organization MySQL drop views Once a view created, you can remove it by using the DROP VIEW statement. The following illustrates the syntax of the DROP VIEW statement: 1 DROP VIEW [IF EXISTS] [database_name].[view_name] The IF EXISTS is the optional e, you can use the DROP VIEWstatement as follows: 1 DROP VIEW IF EXISTS organization Each time you modify or remove a view, you have learned how to manage views in MySQL including displaying, you just need to specify its name after the SHOW CREATE VIEWkeywords. Let’s create a view for the demonstration. First, you use the SHOW CREATE VIEW statement as follows: 1 SHOW CREATE VIEW organization You can also display the definition of the view by using any plain text editor such as notepad to open the view defin, you will learn how to manage views in MySQL including displaying

Summary: in this tutorial, you will learn how to manage views in MySQL including displaying, modifying and removing views. Show view definition

Eduguru

Author: eduguru