Pathology Education Instructional Resource - User contributions [en]

This Is Your Brain On Informatics: Network

2014-11-17T06:58:01Z

Tikenn: /* Using a Static IP */

Possibly the most important aspect to computers: the internet (or more broadly, the network). Here are some guidelines to setting up networks on Linux machines with special sections for the virtual machine controlled by [https://www.virtualbox.org/ VirtualBox].

== Getting Started ==
This first item of note is the location of the file that names the network connections in Linux. This file can be found [[This Is Your Brain On Informatics: Common Pathnames|here]] under the network section. Upon being opened the file should show something similar to this (# indicates a comment):

<pre>
# The loopback network interface
auto lo
iface lo inet loopback

# The primary network interface
auto eth0
iface eth0 inet dhcp
</pre>

The networks shown here are the basic networks that will allow the machine to connect to the internet. If this is a regular computer (not a virtual machine), this file should be similar to what is above meaning that it is already completely setup for internet connection and ssh purposes.

Notice here that the eth0 network has "dhcp" (dynamic host configuration protocol) at the end of the final line. This causes the IP address of this network to be dynamically acquired (meaning that the IP address will be changed frequently) rather than statically set. Below is a discussion of how to set up each.

== Adding a network ==
This step should be taken care of if it is a regular computer; however it is very necessary for a virtual machine.

=== Using a Dynamically Acquired IP ===
This method will cause the network to randomly (within reason of course) select an IP address each time the virtual box is disconnected from an ISP (Internet Service Provider) or another virtual machine is created.

'''Vitual Machine Note'''<br />
This step is critical to allowing the virtual machine to interact with the outside world and not have a host only network. The steps below are for a virtual box, but can be applied to any other network setup in Linux.

# Access the above pathname with pico (pico /etc/network/interfaces)
# Below the first network (indicated by eth0), copy the first network, replacing eth0 with eth1
#::::auto eth1
#::::iface eth1 inet dhcp
# Reboot the machine
# Determine the new IP address of the eth1 network by one of the following
## After logging in, check the IP next to the eth1 network
## Type "ifconfig" into the command line and check the IP next to the "inet addr:"

=== Using a Static IP ===
This can be used if it is necessary to prevent the IP address from changing (e.g. a home server or you're just sick of having to adjust the IP for every program that connects to the virtual machine each time it changes). Below is an example of how it is set.

<pre>
# This is the network that allows communication with the outside world
auto eth1
iface eth1 inet static
address 192.168.56.23
netmask 255.255.255.0
network 192.168.56.0
broadcast 192.168.56.255
gateway 192.168.56.1

</pre>

The key component of this is the word ''static'' at the end of the line beginning with ''iface'', forcing the IP address to bet set statically as determined by the user. Each of the components of the network must now be set individually. The address is the network address and can be set to anything. Typically only the last number is changed from what is currently set. The current IP address can be determined by using the Linux command [[This Is Your Brain On Informatics: Linux Commands|''ifconfig'']] and looking at the ''inet addr'' under the appropriate network. ''Bcast'' will determine the ''broadcast'' and ''netmask'' will determine the Mask. As long as only the final number of the IP address is changed, then these can be used as shown above.

The final numbers (''network'' and ''broadcast'') can be set by simply using 0 and 255 respectively for the last number. Finally, the ''gateway'' is the IP address of the router used to access the internet. This can be accessed from the router settings. The ''gateway'' should NOT be set for a '''Virtual Machine''' through VirtualBox. It should only be set for an actual computer. The gateway is typically the same first three numbers as the IP address with a ''1'' as the last number.

{{This Is Your Brain On Informatics}}

[[Category:This Is Your Brain On Informatics]]

This Is Your Brain On Informatics: Network

2014-11-17T06:57:22Z

Tikenn: /* Using a Static IP */

Possibly the most important aspect to computers: the internet (or more broadly, the network). Here are some guidelines to setting up networks on Linux machines with special sections for the virtual machine controlled by [https://www.virtualbox.org/ VirtualBox].

== Getting Started ==
This first item of note is the location of the file that names the network connections in Linux. This file can be found [[This Is Your Brain On Informatics: Common Pathnames|here]] under the network section. Upon being opened the file should show something similar to this (# indicates a comment):

<pre>
# The loopback network interface
auto lo
iface lo inet loopback

# The primary network interface
auto eth0
iface eth0 inet dhcp
</pre>

The networks shown here are the basic networks that will allow the machine to connect to the internet. If this is a regular computer (not a virtual machine), this file should be similar to what is above meaning that it is already completely setup for internet connection and ssh purposes.

Notice here that the eth0 network has "dhcp" (dynamic host configuration protocol) at the end of the final line. This causes the IP address of this network to be dynamically acquired (meaning that the IP address will be changed frequently) rather than statically set. Below is a discussion of how to set up each.

== Adding a network ==
This step should be taken care of if it is a regular computer; however it is very necessary for a virtual machine.

=== Using a Dynamically Acquired IP ===
This method will cause the network to randomly (within reason of course) select an IP address each time the virtual box is disconnected from an ISP (Internet Service Provider) or another virtual machine is created.

'''Vitual Machine Note'''<br />
This step is critical to allowing the virtual machine to interact with the outside world and not have a host only network. The steps below are for a virtual box, but can be applied to any other network setup in Linux.

# Access the above pathname with pico (pico /etc/network/interfaces)
# Below the first network (indicated by eth0), copy the first network, replacing eth0 with eth1
#::::auto eth1
#::::iface eth1 inet dhcp
# Reboot the machine
# Determine the new IP address of the eth1 network by one of the following
## After logging in, check the IP next to the eth1 network
## Type "ifconfig" into the command line and check the IP next to the "inet addr:"

=== Using a Static IP ===
This can be used if it is necessary to prevent the IP address from changing (e.g. a home server or you're just sick of having to adjust the IP for every program that connects to the virtual machine each time it changes). Below is an example of how it is set.

<pre>
# This is the network that allows communication with the outside world
auto eth1
iface eth1 inet static
address 192.168.56.23
netmask 255.255.255.0
network 192.168.56.0
broadcast 192.168.56.255
gateway 192.168.56.1

</pre>

The key component of this is the word ''static'' at the end of the line beginning with ''iface'', forcing the IP address to bet set statically as determined by the user. Each of the components of the network must now be set individually. The address is the network address and can be set to anything. Typically only the last number is changed from what is currently set. The current IP address can be determined by using the Linux command [[This Is Your Brain On Informatics: Linux Commands|''ifconfig'']] and looking at the ''inet addr'' under the appropriate network. ''Bcast'' will determine the broadcast and ''netmask'' will determine the Mask. As long as only the final number of the IP address is changed, then these can be used as shown above.

The final numbers (''network'' and ''broadcast'') can be set by simply using 0 and 255 respectively for the last number. Finally, the ''gateway'' is the IP address of the router used to access the internet. This can be accessed from the router settings. The ''gateway'' should NOT be set for a '''Virtual Machine''' through VirtualBox. It should only be set for an actual computer. The gateway is typically the same first three numbers as the IP address with a ''1'' as the last number.

{{This Is Your Brain On Informatics}}

[[Category:This Is Your Brain On Informatics]]

This Is Your Brain On Informatics: Network

2014-11-17T06:57:03Z

Tikenn: /* Getting Started */

Possibly the most important aspect to computers: the internet (or more broadly, the network). Here are some guidelines to setting up networks on Linux machines with special sections for the virtual machine controlled by [https://www.virtualbox.org/ VirtualBox].

== Getting Started ==
This first item of note is the location of the file that names the network connections in Linux. This file can be found [[This Is Your Brain On Informatics: Common Pathnames|here]] under the network section. Upon being opened the file should show something similar to this (# indicates a comment):

<pre>
# The loopback network interface
auto lo
iface lo inet loopback

# The primary network interface
auto eth0
iface eth0 inet dhcp
</pre>

The networks shown here are the basic networks that will allow the machine to connect to the internet. If this is a regular computer (not a virtual machine), this file should be similar to what is above meaning that it is already completely setup for internet connection and ssh purposes.

Notice here that the eth0 network has "dhcp" (dynamic host configuration protocol) at the end of the final line. This causes the IP address of this network to be dynamically acquired (meaning that the IP address will be changed frequently) rather than statically set. Below is a discussion of how to set up each.

== Adding a network ==
This step should be taken care of if it is a regular computer; however it is very necessary for a virtual machine.

=== Using a Dynamically Acquired IP ===
This method will cause the network to randomly (within reason of course) select an IP address each time the virtual box is disconnected from an ISP (Internet Service Provider) or another virtual machine is created.

'''Vitual Machine Note'''<br />
This step is critical to allowing the virtual machine to interact with the outside world and not have a host only network. The steps below are for a virtual box, but can be applied to any other network setup in Linux.

# Access the above pathname with pico (pico /etc/network/interfaces)
# Below the first network (indicated by eth0), copy the first network, replacing eth0 with eth1
#::::auto eth1
#::::iface eth1 inet dhcp
# Reboot the machine
# Determine the new IP address of the eth1 network by one of the following
## After logging in, check the IP next to the eth1 network
## Type "ifconfig" into the command line and check the IP next to the "inet addr:"

=== Using a Static IP ===
This can be used if it is necessary to prevent the IP address from changing (e.g. a home server or you're just sick of having to adjust the IP for every program that connects to the virtual machine each time it changes). Below is an example of how it is set.

<pre>
# This is the network that allows communication with the outside world
auto eth1
iface eth1 inet static
address 192.168.56.23
netmask 255.255.255.0
network 192.168.56.0
broadcast 192.168.56.255
gateway 192.168.56.1

</pre>

The key component of this is the word ''static'' at the end of the line beginning with ''iface'', forcing the IP address to bet set statically as determined by the user. Each of the components of the network must now be set individually. The address is the network address and can be set to anything. Typically only the last number is changed from what is currently set. The current IP address can be determined by using the Linux command [[This Is Your Brain On Informatics: Linux Commands|''ifconfig'']] and looking at the ''inet addr'' under the appropriate network. ''Bcast'' will determine the broadcast and ''netmask' will determine the Mask. As long as only the final number of the IP address is changed, then these can be used as shown above.

The final numbers (''network'' and ''broadcast'') can be set by simply using 0 and 255 respectively for the last number. Finally, the ''gateway'' is the IP address of the router used to access the internet. This can be accessed from the router settings. The ''gateway'' should NOT be set for a '''Virtual Machine''' through VirtualBox. It should only be set for an actual computer. The gateway is typically the same first three numbers as the IP address with a ''1'' as the last number.

{{This Is Your Brain On Informatics}}

[[Category:This Is Your Brain On Informatics]]

This Is Your Brain On Informatics: DenyHosts

2014-04-17T02:31:59Z

Tikenn: /* hosts.allow */

DenyHosts is a firewall that is built for the Linux OS and is probably the easiest way to secure a server. This program prevents unauthorized access to the server by blocking an IP address after a set number of unsuccessful attempts have been made.

== Installing DenyHosts ==
Currently, as of writing this wiki page (12/01/13), the easiest way to install DenyHosts is to use aptitude by typing in the following command.

<pre>
aptitude install denyhosts
</pre>

== Important Files ==
There are two important files in DenyHosts in order to make sure that it runs properly: ''hosts.deny'' and ''hosts.allow''. The location of both of these files can be found in [[This Is Your Brain On Informatics: Common Pathnames|common pathnames]].

=== hosts.deny ===
This file stores the IP addresses that have been denied access to the server through ssh. If the server is active, this file will fill up rapidly. The importance of this file lies in the fact that it will also deny your IP address if you attempt to unsuccessfully log into the server more than the set number of times (this can also occur if DenyHosts is glitching). If this is the case, open the file on the actual server (through the virtual machine if that is how the server was built) and delete the appropriate IP address. Then reboot the machine.

=== hosts.allow ===
This file gives permanent ssh access to IP addresses listed inside by preventing them from being placed in the hosts.deny file. This file can be used if DenyHosts is glitching and constantly placing your IP address in hosts.deny. The syntax for permanently allowing an IP address to ssh into the server is shown below.

<pre>
ALL: 192.168.56.23 (or whatever your IP address is)
</pre>

{{This Is Your Brain On Informatics}}

[[Category:This Is Your Brain On Informatics]]

This Is Your Brain On Informatics: DenyHosts

2014-04-17T02:28:45Z

Tikenn:

DenyHosts is a firewall that is built for the Linux OS and is probably the easiest way to secure a server. This program prevents unauthorized access to the server by blocking an IP address after a set number of unsuccessful attempts have been made.

== Installing DenyHosts ==
Currently, as of writing this wiki page (12/01/13), the easiest way to install DenyHosts is to use aptitude by typing in the following command.

<pre>
aptitude install denyhosts
</pre>

== Important Files ==
There are two important files in DenyHosts in order to make sure that it runs properly: ''hosts.deny'' and ''hosts.allow''. The location of both of these files can be found in [[This Is Your Brain On Informatics: Common Pathnames|common pathnames]].

=== hosts.deny ===
This file stores the IP addresses that have been denied access to the server through ssh. If the server is active, this file will fill up rapidly. The importance of this file lies in the fact that it will also deny your IP address if you attempt to unsuccessfully log into the server more than the set number of times (this can also occur if DenyHosts is glitching). If this is the case, open the file on the actual server (through the virtual machine if that is how the server was built) and delete the appropriate IP address. Then reboot the machine.

=== hosts.allow ===
This file gives permanent access to a server so that recorded IP addresses in this file will not be placed in the hosts.deny file. This file can be used if DenyHosts is glitching and constantly placing your IP address in hosts.deny. The syntax for permanently allowing an IP address to ssh into the server is shown below.

<pre>
ALL: 192.168.56.23 (or whatever your IP address is)
</pre>

{{This Is Your Brain On Informatics}}

[[Category:This Is Your Brain On Informatics]]

This Is Your Brain On Informatics: MariaDB SQL Commands

2014-04-12T04:43:30Z

Tikenn:

== MariaDB SQL Commands ==

Note that the commands are capitalized by convention.

{| class = "wikitable"
|-
! colspan="3" | Common Commands in SQL
|-
! colspan="3" align = "center" | Boolean Operators
|-
| style="padding: 10px" colspan="3" align = "center" | AND
|-
| style="padding: 10px" colspan="3" align = "center" | OR
|-
| style="padding: 10px" colspan="3" align = "center" | NOT
|-
! Command*
! Syntax
! Description
|-
| style="padding: 10px" | mysql
| style="padding: 10px" | mysql -u ''username'' -p
| style="padding: 10px" | Command line command where ''username'' should be replaced by the user's account name
|-
| style="padding: 10px" | `''table''`
| style="padding: 10px" |
| style="padding: 10px" | Syntax for indicating a table
|-
| style="padding: 10px" | AS ''var''
| style="padding: 10px" |
| style="padding: 10px" | Sets an output to a variable
|-
| style="padding: 10px" | AUTO_INCREMENT
| style="padding: 10px" |
| style="padding: 10px" | Automatically adds +1 to an entry for a column for each successive entry
|-
| style="padding: 10px" | AVG()
| style="padding: 10px" |
| style="padding: 10px" | Gives an average of the values in the indicated column
|-
| style="padding: 10px" | BIGINT
| style="padding: 10px" |
| style="padding: 10px" | 64-bit integer
|-
| style="padding: 10px" | CHAR
| style="padding: 10px" |
| style="padding: 10px" | Assigns a character variable (allows ONLY 1 character)
|-
| style="padding: 10px" | CREATE TABLE
| style="padding: 10px" | CREATE TABLE `''table''` (<br />`''column_name1''` ''DATA_TYPE'',<br />`''column_name2''` ''DATA_TYPE'',<br />''etc.''<br />);
| style="padding: 10px" | Creates a table of the given name with the properly input variable (see below)
|-
| style="padding: 10px" | CREATE TEMPORARY TABLE
| style="padding: 10px" | CREATE TEMPORARY TABLE `''table''` (<br />`''column_name1''` ''DATA_TYPE'',<br />`''column_name2''` ''DATA_TYPE'',<br />''etc.''<br />);
| style="padding: 10px" | Creates a temporary table of the given name
|-
| style="padding: 10px" | DATE
| style="padding: 10px" |
| style="padding: 10px" | Assigns a date variable of the form 00-00-0000
|-
| style="padding: 10px" | FROM
| style="padding: 10px" | FROM `''table''`
| style="padding: 10px" | Denotes which table SELECT pulls the columns from (e.g. SELECT [col1],[col2] FROM `''table''`
|-
| style="padding: 10px" | INSERT
| style="padding: 10px" | INSERT INTO ''table_name''<br />VALUES (''value1, value2, value3,...''); <br><br> INSERT INTO ''table_name'' (''column1, column2, column3,...'')<br />VALUES (''value1, value2, value3,...''); -- specifies the columns the values go into
| style="padding: 10px" | Used with INTO to insert new data entries into the specified columns
|-
| style="padding: 10px" | INT
| style="padding: 10px" |
| style="padding: 10px" | 32-bit integer
|-
| style="padding: 10px" | INTO
| style="padding: 10px" | SELECT ''column_name(s)''<br />INTO ''newtable'' [IN ''externaldb'']<br />FROM ''table1'';
| style="padding: 10px" | Used with SELECT command to copy ''column_names'' from ''table1'' into ''newtable''
|-
| style="padding: 10px" | LIMIT #
| style="padding: 10px" |
| style="padding: 10px" | Limits to the top # number of entries (not necessarily by rank)
|-
| style="padding: 10px" | MAX()
| style="padding: 10px" |
| style="padding: 10px" | Gives the maximum of the values in the indicated column
|-
| style="padding: 10px" | MIN()
| style="padding: 10px" |
| style="padding: 10px" | Gives the minimum of the values in the indicated column
|-
| style="padding: 10px" | PRIMARY KEY
| style="padding: 10px" |
| style="padding: 10px" | Indicates which variable will differentiate each data entry
|-
| style="padding: 10px" | SELECT
| style="padding: 10px" |
| style="padding: 10px" | Selects columns from a database for analysis
|-
| style="padding: 10px" | UNSIGNED
| style="padding: 10px" |
| style="padding: 10px" | only allows positive integers or float values, always assigned after BIGINT or INT value
|-
| style="padding: 10px" | UPDATE
| style="padding: 10px" | UPDATE ''table_name''<br />SET ''column1=value1, column2=value2,...''<br />WHERE ''some_column''=''some_value;''
| style="padding: 10px" | Changes ''column1'' to ''value1'' based on the WHERE statement (use something unique to update only one row)
|-
| style="padding: 10px" | USE ''database''
| style="padding: 10px" |
| style="padding: 10px" | Selects database for manipulation and analysis
|-
| style="padding: 10px" | VARCHAR(#)
| style="padding: 10px" |
| style="padding: 10px" | Assigns a character array variable of length #
|-
| style="padding: 10px" | WHERE
| style="padding: 10px" |
| style="padding: 10px" | Limits the available values SELECT can pull from each column based on a logical statement (e.g. WHERE ''col1'' < 10)
|-
|}

{{Template: This Is Your Brain On Informatics}}

[[Category:This Is Your Brain On Informatics]]

This Is Your Brain On Informatics: MariaDB SQL Commands

2014-03-28T03:43:42Z

Tikenn: /* MariaDB SQL Commands */

== MariaDB SQL Commands ==

Note that the commands are capitalized by convention.

{| class = "wikitable"
|-
! colspan="3" | Common Commands in SQL
|-
! colspan="3" align = "center" | Boolean Operators
|-
| style="padding: 10px" colspan="3" align = "center" | AND
|-
| style="padding: 10px" colspan="3" align = "center" | OR
|-
| style="padding: 10px" colspan="3" align = "center" | NOT
|-
! Command*
! Syntax
! Description
|-
| style="padding: 10px" | mysql
| style="padding: 10px" | mysql -u ''username'' -p
| style="padding: 10px" | Command line command where ''username'' should be replaced by the user's account name
|-
| style="padding: 10px" | `''table''`
| style="padding: 10px" |
| style="padding: 10px" | Syntax for indicating a table
|-
| style="padding: 10px" | AS ''var''
| style="padding: 10px" |
| style="padding: 10px" | Sets an output to a variable
|-
| style="padding: 10px" | AUTO_INCREMENT
| style="padding: 10px" |
| style="padding: 10px" | Automatically adds +1 to an entry for a column for each successive entry
|-
| style="padding: 10px" | AVG()
| style="padding: 10px" |
| style="padding: 10px" | Gives an average of the values in the indicated column
|-
| style="padding: 10px" | BIGINT
| style="padding: 10px" |
| style="padding: 10px" | 64-bit integer
|-
| style="padding: 10px" | CHAR
| style="padding: 10px" |
| style="padding: 10px" | Assigns a character variable (allows ONLY 1 character)
|-
| style="padding: 10px" | CREATE TABLE
| style="padding: 10px" | CREATE TABLE `''table''` (<br />`''column_name1''` ''DATA_TYPE'',<br />`''column_name2''` ''DATA_TYPE'',<br />''etc.''<br />);
| style="padding: 10px" | Creates a table of the given name with the properly input variable (see below)
|-
| style="padding: 10px" | CREATE TEMPORARY TABLE
| style="padding: 10px" | CREATE TEMPORARY TABLE `''table''` (<br />`''column_name1''` ''DATA_TYPE'',<br />`''column_name2''` ''DATA_TYPE'',<br />''etc.''<br />);
| style="padding: 10px" | Creates a temporary table of the given name
|-
| style="padding: 10px" | DATE
| style="padding: 10px" |
| style="padding: 10px" | Assigns a date variable of the form 00-00-0000
|-
| style="padding: 10px" | FROM
| style="padding: 10px" | FROM `''table''`
| style="padding: 10px" | Denotes which table SELECT pulls the columns from (e.g. SELECT [col1],[col2] FROM `''table''`
|-
| style="padding: 10px" | INSERT
| style="padding: 10px" | INSERT INTO ''table_name''<br />VALUES (''value1, value2, value3,...''); <br><br> INSERT INTO ''table_name'' (''column1, column2, column3,...'')<br />VALUES (''value1, value2, value3,...''); -- specifies the columns the values go into
| style="padding: 10px" | Used with INTO to insert new data entries into the specified columns
|-
| style="padding: 10px" | INT
| style="padding: 10px" |
| style="padding: 10px" | 32-bit integer
|-
| style="padding: 10px" | INTO
| style="padding: 10px" | SELECT * or ''column_name(s)''<br />INTO ''newtable'' [IN ''externaldb'']<br />FROM ''table1'';
| style="padding: 10px" | Used with SELECT command to copy ''column_names'' from ''table1'' into ''newtable''
|-
| style="padding: 10px" | LIMIT #
| style="padding: 10px" |
| style="padding: 10px" | Limits to the top # number of entries (not necessarily by rank)
|-
| style="padding: 10px" | MAX()
| style="padding: 10px" |
| style="padding: 10px" | Gives the maximum of the values in the indicated column
|-
| style="padding: 10px" | MIN()
| style="padding: 10px" |
| style="padding: 10px" | Gives the minimum of the values in the indicated column
|-
| style="padding: 10px" | PRIMARY KEY
| style="padding: 10px" |
| style="padding: 10px" | Indicates which variable will differentiate each data entry
|-
| style="padding: 10px" | SELECT
| style="padding: 10px" |
| style="padding: 10px" | Selects columns from a database for analysis
|-
| style="padding: 10px" | UNSIGNED
| style="padding: 10px" |
| style="padding: 10px" | only allows positive integers or float values, always assigned after BIGINT or INT value
|-
| style="padding: 10px" | UPDATE
| style="padding: 10px" | UPDATE ''table_name''<br />SET ''column1=value1, column2=value2,...''<br />WHERE ''some_column''=''some_value;''
| style="padding: 10px" | Changes ''column1'' to ''value1'' based on the WHERE statement (use something unique to update only one row)
|-
| style="padding: 10px" | USE ''database''
| style="padding: 10px" |
| style="padding: 10px" | Selects database for manipulation and analysis
|-
| style="padding: 10px" | VARCHAR(#)
| style="padding: 10px" |
| style="padding: 10px" | Assigns a character array variable of length #
|-
| style="padding: 10px" | WHERE
| style="padding: 10px" |
| style="padding: 10px" | Limits the available values SELECT can pull from each column based on a logical statement (e.g. WHERE ''col1'' < 10)
|-
|}

{{Template: This Is Your Brain On Informatics}}

[[Category:This Is Your Brain On Informatics]]

This Is Your Brain On Informatics: MariaDB SQL Commands

2014-03-28T03:40:41Z

Tikenn:

== MariaDB SQL Commands ==

Note that the commands are capitalized by convention.

{| class = "wikitable"
|-
! colspan="3" | Common Commands in SQL
|-
! colspan="3" align = "center" | Boolean Operators
|-
| style="padding: 10px" colspan="3" align = "center" | AND
|-
| style="padding: 10px" colspan="3" align = "center" | OR
|-
| style="padding: 10px" colspan="3" align = "center" | NOT
|-
! Command*
! Syntax
! Description
|-
| style="padding: 10px" | mysql
| style="padding: 10px" | mysql -u ''username'' -p
| style="padding: 10px" | Command line command where ''username'' should be replaced by the user's account name
|-
| style="padding: 10px" | `''table''`
| style="padding: 10px" |
| style="padding: 10px" | Syntax for indicating a table
|-
| style="padding: 10px" | AS ''var''
| style="padding: 10px" |
| style="padding: 10px" | Sets an output to a variable
|-
| style="padding: 10px" | AUTO_INCREMENT
| style="padding: 10px" |
| style="padding: 10px" | Automatically adds +1 to an entry for a column for each successive entry
|-
| style="padding: 10px" | AVG()
| style="padding: 10px" |
| style="padding: 10px" | Gives an average of the values in the indicated column
|-
| style="padding: 10px" | BIGINT
| style="padding: 10px" |
| style="padding: 10px" | 64-bit integer
|-
| style="padding: 10px" | CHAR
| style="padding: 10px" |
| style="padding: 10px" | Assigns a character variable (allows ONLY 1 character)
|-
| style="padding: 10px" | CREATE TABLE
| style="padding: 10px" | CREATE TABLE `''table''` (<br />`''column_name1''` ''DATA_TYPE'',<br />`''column_name2''` ''DATA_TYPE'',<br />''etc.''<br />);
| style="padding: 10px" | Creates a table of the given name with the properly input variable (see below)
|-
| style="padding: 10px" | CREATE TEMPORARY TABLE
| style="padding: 10px" | CREATE TEMPORARY TABLE `''table''` (<br />`''column_name1''` ''DATA_TYPE'',<br />`''column_name2''` ''DATA_TYPE'',<br />''etc.''<br />);
| style="padding: 10px" | Creates a temporary table of the given name
|-
| style="padding: 10px" | DATE
| style="padding: 10px" |
| style="padding: 10px" | Assigns a date variable of the form 00-00-0000
|-
| style="padding: 10px" | FROM
| style="padding: 10px" | FROM `''table''`
| style="padding: 10px" | Denotes which table SELECT pulls the columns from (e.g. SELECT [col1],[col2] FROM `''table''`
|-
| style="padding: 10px" | INSERT
| style="padding: 10px" | INSERT INTO ''table_name''<br />VALUES (''value1, value2, value3,...''); <br><br> INSERT INTO ''table_name'' (''column1,column2,column3,...'')<br />VALUES (''value1, value2, value3,...''); -- specifies the columns the values go into
| style="padding: 10px" | Used with INTO to insert new data entries into the specified columns
|-
| style="padding: 10px" | INT
| style="padding: 10px" |
| style="padding: 10px" | 32-bit integer
|-
| style="padding: 10px" | INTO
| style="padding: 10px" | SELECT * or ''column_name(s)''<br />INTO ''newtable'' [IN ''externaldb'']<br />FROM ''table1'';
| style="padding: 10px" | Used with SELECT command to copy ''column_names'' from ''table1'' into ''newtable''
|-
| style="padding: 10px" | LIMIT #
| style="padding: 10px" |
| style="padding: 10px" | Limits to the top # number of entries (not necessarily by rank)
|-
| style="padding: 10px" | MAX()
| style="padding: 10px" |
| style="padding: 10px" | Gives the maximum of the values in the indicated column
|-
| style="padding: 10px" | MIN()
| style="padding: 10px" |
| style="padding: 10px" | Gives the minimum of the values in the indicated column
|-
| style="padding: 10px" | PRIMARY KEY
| style="padding: 10px" |
| style="padding: 10px" | Indicates which variable will differentiate each data entry
|-
| style="padding: 10px" | SELECT
| style="padding: 10px" |
| style="padding: 10px" | Selects columns from a database for analysis
|-
| style="padding: 10px" | UNSIGNED
| style="padding: 10px" |
| style="padding: 10px" | only allows positive integers or float values, always assigned after BIGINT or INT value
|-
| style="padding: 10px" | UPDATE
| style="padding: 10px" | UPDATE ''table_name''<br />SET ''column1=value1, column2=value2,...''<br />WHERE ''some_column''=''some_value;''
| style="padding: 10px" | Changes ''column1'' to ''value1'' based on the WHERE statement (use something unique to update only one row)
|-
| style="padding: 10px" | USE ''database''
| style="padding: 10px" |
| style="padding: 10px" | Selects database for manipulation and analysis
|-
| style="padding: 10px" | VARCHAR(#)
| style="padding: 10px" |
| style="padding: 10px" | Assigns a character array variable of length #
|-
| style="padding: 10px" | WHERE
| style="padding: 10px" |
| style="padding: 10px" | Limits the available values SELECT can pull from each column based on a logical statement (e.g. WHERE ''col1'' < 10)
|-
|}

{{Template: This Is Your Brain On Informatics}}

[[Category:This Is Your Brain On Informatics]]

This Is Your Brain On Informatics: MariaDB SQL Commands

2014-03-27T01:49:58Z

Tikenn:

== MariaDB SQL Commands ==

Note that the commands are capitalized by convention.

{| class = "wikitable"
|-
! colspan="3" | Common Commands in SQL
|-
! colspan="3" align = "center" | Boolean Operators
|-
| style="padding: 10px" colspan="3" align = "center" | AND
|-
| style="padding: 10px" colspan="3" align = "center" | OR
|-
| style="padding: 10px" colspan="3" align = "center" | NOT
|-
! Command*
! Syntax
! Description
|-
| style="padding: 10px" | mysql
| style="padding: 10px" | mysql -u ''username'' -p
| style="padding: 10px" | Command line command where ''username'' should be replaced by the user's account name
|-
| style="padding: 10px" | `''table''`
| style="padding: 10px" |
| style="padding: 10px" | Syntax for indicating a table
|-
| style="padding: 10px" | AS ''var''
| style="padding: 10px" |
| style="padding: 10px" | Sets an output to a variable
|-
| style="padding: 10px" | AUTO_INCREMENT
| style="padding: 10px" |
| style="padding: 10px" | Automatically adds +1 to an entry for a column for each successive entry
|-
| style="padding: 10px" | AVG()
| style="padding: 10px" |
| style="padding: 10px" | Gives an average of the values in the indicated column
|-
| style="padding: 10px" | BIGINT
| style="padding: 10px" |
| style="padding: 10px" | 64-bit integer
|-
| style="padding: 10px" | CHAR
| style="padding: 10px" |
| style="padding: 10px" | Assigns a character variable (allows ONLY 1 character)
|-
| style="padding: 10px" | CREATE TABLE
| style="padding: 10px" | CREATE TABLE `''table''` VALUES(<br />`''column_name1''` ''DATA_TYPE'',<br />`''column_name2''` ''DATA_TYPE'',<br />''etc.''<br />);
| style="padding: 10px" | Creates a table of the given name with the properly input variable (see below)
|-
| style="padding: 10px" | CREATE TEMPORARY TABLE
| style="padding: 10px" | CREATE TEMPORARY TABLE `''table''`VALUES(<br />`''column_name1''` ''DATA_TYPE'',<br />`''column_name2''` ''DATA_TYPE'',<br />''etc.''<br />);
| style="padding: 10px" | Creates a temporary table of the given name
|-
| style="padding: 10px" | DATE
| style="padding: 10px" |
| style="padding: 10px" | Assigns a date variable of the form 00-00-0000
|-
| style="padding: 10px" | FROM
| style="padding: 10px" | FROM `''table''`
| style="padding: 10px" | Denotes which table SELECT pulls the columns from (e.g. SELECT [col1],[col2] FROM `''table''`
|-
| style="padding: 10px" | INSERT
| style="padding: 10px" | INSERT INTO ''table_name''<br />VALUES (''value1,value2,value3,...'');<br />INSERT INTO ''table_name'' (''column1,column2,column3,...'')<br />VALUES (''value1,value2,value3,...''); -- specifies the columns the values go into
| style="padding: 10px" | Used with INTO to insert new data entries into the specified columns
|-
| style="padding: 10px" | INT
| style="padding: 10px" |
| style="padding: 10px" | 32-bit integer
|-
| style="padding: 10px" | INTO
| style="padding: 10px" | SELECT * or ''column_name(s)''<br />INTO ''newtable'' [IN ''externaldb'']<br />FROM ''table1'';
| style="padding: 10px" | Used with SELECT command to copy ''column_names'' from ''table1'' into ''newtable''
|-
| style="padding: 10px" | LIMIT #
| style="padding: 10px" |
| style="padding: 10px" | Limits to the top # number of entries (not necessarily by rank)
|-
| style="padding: 10px" | MAX()
| style="padding: 10px" |
| style="padding: 10px" | Gives the maximum of the values in the indicated column
|-
| style="padding: 10px" | MIN()
| style="padding: 10px" |
| style="padding: 10px" | Gives the minimum of the values in the indicated column
|-
| style="padding: 10px" | PRIMARY KEY
| style="padding: 10px" |
| style="padding: 10px" | Indicates which variable will differentiate each data entry
|-
| style="padding: 10px" | SELECT
| style="padding: 10px" |
| style="padding: 10px" | Selects columns from a database for analysis
|-
| style="padding: 10px" | UNSIGNED
| style="padding: 10px" |
| style="padding: 10px" | only allows positive integers or float values, always assigned after BIGINT or INT value
|-
| style="padding: 10px" | UPDATE
| style="padding: 10px" | UPDATE ''table_name''<br />SET ''column1=value1,column2=value2,...''<br />WHERE ''some_column''=''some_value;''
| style="padding: 10px" | Changes ''column1'' to ''value1'' based on the WHERE statement (use something unique to update only one row)
|-
| style="padding: 10px" | USE ''database''
| style="padding: 10px" |
| style="padding: 10px" | Selects database for manipulation and analysis
|-
| style="padding: 10px" | VARCHAR(#)
| style="padding: 10px" |
| style="padding: 10px" | Assigns a character array variable of length #
|-
| style="padding: 10px" | WHERE
| style="padding: 10px" |
| style="padding: 10px" | Limits the available values SELECT can pull from each column based on a logical statement (e.g. WHERE ''col1'' < 10)
|-
|}

{{Template: This Is Your Brain On Informatics}}

[[Category:This Is Your Brain On Informatics]]

This Is Your Brain On Informatics: MariaDB SQL Commands

2014-03-27T01:47:44Z

Tikenn:

== MariaDB SQL Commands ==

Note that the commands are capitalized by convention.

{| class = "wikitable"
|-
! colspan="3" | Common Commands in SQL
|-
! colspan="3" align = "center" | Boolean Operators
|-
| style="padding: 10px" colspan="3" align = "center" | AND
|-
| style="padding: 10px" colspan="3" align = "center" | OR
|-
| style="padding: 10px" colspan="3" align = "center" | NOT
|-
! Command*
! Syntax
! Description
|-
| style="padding: 10px" | mysql
| style="padding: 10px" | mysql -u ''username'' -p
| style="padding: 10px" | Command line command where ''username'' should be replaced by the user's account name
|-
| style="padding: 10px" | `''table''`
| style="padding: 10px" |
| style="padding: 10px" | Syntax for indicating a table
|-
| style="padding: 10px" | AS ''var''
| style="padding: 10px" |
| style="padding: 10px" | Sets an output to a variable
|-
| style="padding: 10px" | AUTO_INCREMENT
| style="padding: 10px" |
| style="padding: 10px" | Automatically adds +1 to an entry for a column for each successive entry
|-
| style="padding: 10px" | AVG()
| style="padding: 10px" |
| style="padding: 10px" | Gives an average of the values in the indicated column
|-
| style="padding: 10px" | BIGINT
| style="padding: 10px" |
| style="padding: 10px" | 64-bit integer
|-
| style="padding: 10px" | CHAR
| style="padding: 10px" |
| style="padding: 10px" | Assigns a character variable (allows ONLY 1 character)
|-
| style="padding: 10px" | CREATE TABLE
| style="padding: 10px" | CREATE TABLE `''table''` VALUES(`''column_name1''` ''DATA_TYPE'', `''column_name2''` ''DATA_TYPE'', ''etc.'');
| style="padding: 10px" | Creates a table of the given name with the properly input variable (see below)
|-
| style="padding: 10px" | CREATE TEMPORARY TABLE
| style="padding: 10px" | CREATE TEMPORARY TABLE `''table''` VALUES(`''column_name1''` ''DATA_TYPE'', `''column_name2''` ''DATA_TYPE'', ''etc.'');
| style="padding: 10px" | Creates a temporary table of the given name
|-
| style="padding: 10px" | DATE
| style="padding: 10px" |
| style="padding: 10px" | Assigns a date variable of the form 00-00-0000
|-
| style="padding: 10px" | FROM
| style="padding: 10px" | FROM `''table''`
| style="padding: 10px" | Denotes which table SELECT pulls the columns from (e.g. SELECT [col1],[col2] FROM `''table''`
|-
| style="padding: 10px" | INSERT
| style="padding: 10px" | INSERT INTO ''table_name''<br />VALUES (''value1,value2,value3,...'');<br />INSERT INTO ''table_name'' (''column1,column2,column3,...'')<br />VALUES (''value1,value2,value3,...''); -- specifies the columns the values go into
| style="padding: 10px" | Used with INTO to insert new data entries into the specified columns
|-
| style="padding: 10px" | INT
| style="padding: 10px" |
| style="padding: 10px" | 32-bit integer
|-
| style="padding: 10px" | INTO
| style="padding: 10px" | SELECT * or ''column_name(s)''<br />INTO ''newtable'' [IN ''externaldb'']<br />FROM ''table1'';
| style="padding: 10px" | Used with SELECT command to copy ''column_names'' from ''table1'' into ''newtable''
|-
| style="padding: 10px" | LIMIT #
| style="padding: 10px" |
| style="padding: 10px" | Limits to the top # number of entries (not necessarily by rank)
|-
| style="padding: 10px" | MAX()
| style="padding: 10px" |
| style="padding: 10px" | Gives the maximum of the values in the indicated column
|-
| style="padding: 10px" | MIN()
| style="padding: 10px" |
| style="padding: 10px" | Gives the minimum of the values in the indicated column
|-
| style="padding: 10px" | PRIMARY KEY
| style="padding: 10px" |
| style="padding: 10px" | Indicates which variable will differentiate each data entry
|-
| style="padding: 10px" | SELECT
| style="padding: 10px" |
| style="padding: 10px" | Selects columns from a database for analysis
|-
| style="padding: 10px" | UNSIGNED
| style="padding: 10px" |
| style="padding: 10px" | only allows positive integers or float values, always assigned after BIGINT or INT value
|-
| style="padding: 10px" | UPDATE
| style="padding: 10px" | UPDATE ''table_name''<br />SET ''column1=value1,column2=value2,...''<br />WHERE ''some_column''=''some_value;''
| style="padding: 10px" | Changes ''column1'' to ''value1'' based on the WHERE statement (use something unique to update only one row)
|-
| style="padding: 10px" | USE ''database''
| style="padding: 10px" |
| style="padding: 10px" | Selects database for manipulation and analysis
|-
| style="padding: 10px" | VARCHAR(#)
| style="padding: 10px" |
| style="padding: 10px" | Assigns a character array variable of length #
|-
| style="padding: 10px" | WHERE
| style="padding: 10px" |
| style="padding: 10px" | Limits the available values SELECT can pull from each column based on a logical statement (e.g. WHERE ''col1'' < 10)
|-
|}

{{Template: This Is Your Brain On Informatics}}

[[Category:This Is Your Brain On Informatics]]

This Is Your Brain On Informatics: MariaDB SQL Commands

2014-03-27T01:44:46Z

Tikenn:

== MariaDB SQL Commands ==

Note that the commands are capitalized by convention.

{| class = "wikitable"
|-
! colspan="3" | Common Commands in SQL
|-
! colspan="3" align = "center" | Boolean Operators
|-
| style="padding: 10px" colspan="3" align = "center" | AND
|-
| style="padding: 10px" colspan="3" align = "center" | OR
|-
| style="padding: 10px" colspan="3" align = "center" | NOT
|-
! Command*
! Syntax
! Description
|-
| style="padding: 10px" | mysql
| style="padding: 10px" | mysql -u ''username'' -p
| style="padding: 10px" | Command line command where ''username'' should be replaced by the user's account name
|-
| style="padding: 10px" | `''table''`
| style="padding: 10px" |
| style="padding: 10px" | Syntax for indicating a table
|-
| style="padding: 10px" | AS ''var''
| style="padding: 10px" |
| style="padding: 10px" | Sets an output to a variable
|-
| style="padding: 10px" | AUTO_INCREMENT
| style="padding: 10px" |
| style="padding: 10px" | Automatically adds +1 to an entry for a column for each successive entry
|-
| style="padding: 10px" | AVG()
| style="padding: 10px" |
| style="padding: 10px" | Gives an average of the values in the indicated column
|-
| style="padding: 10px" | BIGINT
| style="padding: 10px" |
| style="padding: 10px" | 64-bit integer
|-
| style="padding: 10px" | CHAR
| style="padding: 10px" |
| style="padding: 10px" | Assigns a character variable (allows ONLY 1 character)
|-
| style="padding: 10px" | CREATE TABLE `''table''`
| style="padding: 10px" |
| style="padding: 10px" | Creates a table of the given name with the properly input variable (see below)
|-
| style="padding: 10px" | CREATE TEMPORARY TABLE
| style="padding: 10px" | CREATE TEMPORARY TABLE `''table''`
| style="padding: 10px" | Creates a temporary table of the given name
|-
| style="padding: 10px" | DATE
| style="padding: 10px" |
| style="padding: 10px" | Assigns a date variable of the form 00-00-0000
|-
| style="padding: 10px" | FROM
| style="padding: 10px" | FROM `''table''`
| style="padding: 10px" | Denotes which table SELECT pulls the columns from (e.g. SELECT [col1],[col2] FROM `''table''`
|-
| style="padding: 10px" | INSERT
| style="padding: 10px" | INSERT INTO ''table_name''<br />VALUES (''value1,value2,value3,...'');<br />INSERT INTO ''table_name'' (''column1,column2,column3,...'')<br />VALUES (''value1,value2,value3,...''); -- specifies the columns the values go into
| style="padding: 10px" | Used with INTO to insert new data entries into the specified columns
|-
| style="padding: 10px" | INT
| style="padding: 10px" |
| style="padding: 10px" | 32-bit integer
|-
| style="padding: 10px" | INTO
| style="padding: 10px" | SELECT * or ''column_name(s)''<br />INTO ''newtable'' [IN ''externaldb'']<br />FROM ''table1'';
| style="padding: 10px" | Used with SELECT command to copy ''column_names'' from ''table1'' into ''newtable''
|-
| style="padding: 10px" | LIMIT #
| style="padding: 10px" |
| style="padding: 10px" | Limits to the top # number of entries (not necessarily by rank)
|-
| style="padding: 10px" | MAX()
| style="padding: 10px" |
| style="padding: 10px" | Gives the maximum of the values in the indicated column
|-
| style="padding: 10px" | MIN()
| style="padding: 10px" |
| style="padding: 10px" | Gives the minimum of the values in the indicated column
|-
| style="padding: 10px" | PRIMARY KEY
| style="padding: 10px" |
| style="padding: 10px" | Indicates which variable will differentiate each data entry
|-
| style="padding: 10px" | SELECT
| style="padding: 10px" |
| style="padding: 10px" | Selects columns from a database for analysis
|-
| style="padding: 10px" | UNSIGNED
| style="padding: 10px" |
| style="padding: 10px" | only allows positive integers or float values, always assigned after BIGINT or INT value
|-
| style="padding: 10px" | UPDATE
| style="padding: 10px" | UPDATE ''table_name''<br />SET ''column1=value1,column2=value2,...''<br />WHERE ''some_column''=''some_value;''
| style="padding: 10px" | Changes ''column1'' to ''value1'' based on the WHERE statement (use something unique to update only one row)
|-
| style="padding: 10px" | USE ''database''
| style="padding: 10px" |
| style="padding: 10px" | Selects database for manipulation and analysis
|-
| style="padding: 10px" | VARCHAR(#)
| style="padding: 10px" |
| style="padding: 10px" | Assigns a character array variable of length #
|-
| style="padding: 10px" | WHERE
| style="padding: 10px" |
| style="padding: 10px" | Limits the available values SELECT can pull from each column based on a logical statement (e.g. WHERE ''col1'' < 10)
|-
|}

{{Template: This Is Your Brain On Informatics}}

[[Category:This Is Your Brain On Informatics]]

This Is Your Brain On Informatics: MariaDB SQL Commands

2014-03-27T01:41:37Z

Tikenn:

== MariaDB SQL Commands ==

Note that the commands are capitalized by convention.

{| class = "wikitable"
|-
! colspan="3" | Common Commands in SQL
|-
! colspan="3" align = "center" | Boolean Operators
|-
| style="padding: 10px" colspan="3" align = "center" | AND
|-
| style="padding: 10px" colspan="3" align = "center" | OR
|-
| style="padding: 10px" colspan="3" align = "center" | NOT
|-
! Command*
! Syntax
! Description
|-
| style="padding: 10px" | mysql
| style="padding: 10px" | mysql -u ''username'' -p
| style="padding: 10px" | Command line command where ''username'' should be replaced by the user's account name
|-
| style="padding: 10px" | `''table''`
| style="padding: 10px" |
| style="padding: 10px" | Syntax for indicating a table
|-
| style="padding: 10px" | AS ''var''
| style="padding: 10px" |
| style="padding: 10px" | Sets an output to a variable
|-
| style="padding: 10px" | AUTO_INCREMENT
| style="padding: 10px" |
| style="padding: 10px" | Automatically adds +1 to an entry for a column for each successive entry
|-
| style="padding: 10px" | AVG()
| style="padding: 10px" |
| style="padding: 10px" | Gives an average of the values in the indicated column
|-
| style="padding: 10px" | BIGINT
| style="padding: 10px" |
| style="padding: 10px" | 64-bit integer
|-
| style="padding: 10px" | CHAR
| style="padding: 10px" |
| style="padding: 10px" | Assigns a character variable (allows ONLY 1 character)
|-
| style="padding: 10px" | CREATE TABLE `''table''`
| style="padding: 10px" |
| style="padding: 10px" | Creates a table of the given name with the properly input variable (see below)
|-
| style="padding: 10px" | CREATE TEMPORARY TABLE `[table]`
| style="padding: 10px" |
| style="padding: 10px" | Creates a temporary table of the given name
|-
| style="padding: 10px" | DATE
| style="padding: 10px" |
| style="padding: 10px" | Assigns a date variable of the form 00-00-0000
|-
| style="padding: 10px" | FROM
| style="padding: 10px" |
| style="padding: 10px" | Denotes which table SELECT pulls the columns from (e.g. SELECT [col1],[col2] FROM `''table''`
|-
| style="padding: 10px" | INSERT
| style="padding: 10px" | INSERT INTO ''table_name''<br />VALUES (''value1,value2,value3,...'');<br />INSERT INTO ''table_name'' (''column1,column2,column3,...'')<br />VALUES (''value1,value2,value3,...''); -- specifies the columns the values go into
| style="padding: 10px" | Used with INTO to insert new data entries into the specified columns
|-
| style="padding: 10px" | INT
| style="padding: 10px" |
| style="padding: 10px" | 32-bit integer
|-
| style="padding: 10px" | INTO
| style="padding: 10px" | SELECT * or ''column_name(s)''<br />INTO ''newtable'' [IN ''externaldb'']<br />FROM ''table1'';
| style="padding: 10px" | Used with SELECT command to copy ''column_names'' from ''table1'' into ''newtable''
|-
| style="padding: 10px" | LIMIT #
| style="padding: 10px" |
| style="padding: 10px" | Limits to the top # number of entries (not necessarily by rank)
|-
| style="padding: 10px" | MAX()
| style="padding: 10px" |
| style="padding: 10px" | Gives the maximum of the values in the indicated column
|-
| style="padding: 10px" | MIN()
| style="padding: 10px" |
| style="padding: 10px" | Gives the minimum of the values in the indicated column
|-
| style="padding: 10px" | PRIMARY KEY
| style="padding: 10px" |
| style="padding: 10px" | Indicates which variable will differentiate each data entry
|-
| style="padding: 10px" | SELECT
| style="padding: 10px" |
| style="padding: 10px" | Selects columns from a database for analysis
|-
| style="padding: 10px" | UNSIGNED
| style="padding: 10px" |
| style="padding: 10px" | only allows positive integers or float values, always assigned after BIGINT or INT value
|-
| style="padding: 10px" | UPDATE
| style="padding: 10px" | UPDATE ''table_name''<br />SET ''column1=value1,column2=value2,...''<br />WHERE ''some_column''=''some_value;''
| style="padding: 10px" | Changes ''column1'' to ''value1'' based on the WHERE statement (use something unique to update only one row)
|-
| style="padding: 10px" | USE ''database''
| style="padding: 10px" |
| style="padding: 10px" | Selects database for manipulation and analysis
|-
| style="padding: 10px" | VARCHAR(#)
| style="padding: 10px" |
| style="padding: 10px" | Assigns a character array variable of length #
|-
| style="padding: 10px" | WHERE
| style="padding: 10px" |
| style="padding: 10px" | Limits the available values SELECT can pull from each column based on a logical statement (e.g. WHERE ''col1'' < 10)
|-
|}

{{Template: This Is Your Brain On Informatics}}

[[Category:This Is Your Brain On Informatics]]

This Is Your Brain On Informatics: MariaDB SQL Commands

2014-03-27T01:41:11Z

Tikenn:

== MariaDB SQL Commands ==

Note that the commands are capitalized by convention.

{| class = "wikitable"
|-
! colspan="3" | Common Commands in SQL
|-
! colspan="3" align = "center" | Boolean Operators
|-
| style="padding: 10px" colspan="3" align = "center" | AND
|-
| style="padding: 10px" colspan="3" align = "center" | OR
|-
| style="padding: 10px" colspan="3" align = "center" | NOT
|-
! Command*
! Syntax
! Description
|-
| style="padding: 10px" | mysql
| style="padding: 10px" | mysql -u ''username'' -p
| style="padding: 10px" | Command line command where ''username'' should be replaced by the user's account name
|-
| style="padding: 10px" | `''table''`
| style="padding: 10px" |
| style="padding: 10px" | Syntax for indicating a table
|-
| style="padding: 10px" | AS ''var''
| style="padding: 10px" |
| style="padding: 10px" | Sets an output to a variable
|-
| style="padding: 10px" | AUTO_INCREMENT
| style="padding: 10px" |
| style="padding: 10px" | Automatically adds +1 to an entry for a column for each successive entry
|-
| style="padding: 10px" | AVG()
| style="padding: 10px" |
| style="padding: 10px" | Gives an average of the values in the indicated column
|-
| style="padding: 10px" | BIGINT
| style="padding: 10px" |
| style="padding: 10px" | 64-bit integer
|-
| style="padding: 10px" | CHAR
| style="padding: 10px" |
| style="padding: 10px" | Assigns a character variable (allows ONLY 1 character)
|-
| style="padding: 10px" | CREATE TABLE `''table''`
| style="padding: 10px" |
| style="padding: 10px" | Creates a table of the given name with the properly input variable (see below)
|-
| style="padding: 10px" | CREATE TEMPORARY TABLE `[table]`
| style="padding: 10px" |
| style="padding: 10px" | Creates a temporary table of the given name
|-
| style="padding: 10px" | DATE
| style="padding: 10px" |
| style="padding: 10px" | Assigns a date variable of the form 00-00-0000
|-
| style="padding: 10px" | FROM
| style="padding: 10px" |
| style="padding: 10px" | Denotes which table SELECT pulls the columns from (e.g. SELECT [col1],[col2] FROM `''table''`
|-
| style="padding: 10px" | INSERT
| style="padding: 10px" | INSERT INTO ''table_name''<br /><br />VALUES (''value1,value2,value3,...'');<br />INSERT INTO ''table_name'' (''column1,column2,column3,...'')<br />VALUES (''value1,value2,value3,...''); -- specifies the columns the values go into
| style="padding: 10px" | Used with INTO to insert new data entries into the specified columns
|-
| style="padding: 10px" | INT
| style="padding: 10px" |
| style="padding: 10px" | 32-bit integer
|-
| style="padding: 10px" | INTO
| style="padding: 10px" | SELECT * or ''column_name(s)''<br />INTO ''newtable'' [IN ''externaldb'']<br />FROM ''table1'';
| style="padding: 10px" | Used with SELECT command to copy ''column_names'' from ''table1'' into ''newtable''
|-
| style="padding: 10px" | LIMIT #
| style="padding: 10px" |
| style="padding: 10px" | Limits to the top # number of entries (not necessarily by rank)
|-
| style="padding: 10px" | MAX()
| style="padding: 10px" |
| style="padding: 10px" | Gives the maximum of the values in the indicated column
|-
| style="padding: 10px" | MIN()
| style="padding: 10px" |
| style="padding: 10px" | Gives the minimum of the values in the indicated column
|-
| style="padding: 10px" | PRIMARY KEY
| style="padding: 10px" |
| style="padding: 10px" | Indicates which variable will differentiate each data entry
|-
| style="padding: 10px" | SELECT
| style="padding: 10px" |
| style="padding: 10px" | Selects columns from a database for analysis
|-
| style="padding: 10px" | UNSIGNED
| style="padding: 10px" |
| style="padding: 10px" | only allows positive integers or float values, always assigned after BIGINT or INT value
|-
| style="padding: 10px" | UPDATE
| style="padding: 10px" | UPDATE ''table_name''<br />SET ''column1=value1,column2=value2,...''<br />WHERE ''some_column''=''some_value;''
| style="padding: 10px" | Changes ''column1'' to ''value1'' based on the WHERE statement (use something unique to update only one row)
|-
| style="padding: 10px" | USE ''database''
| style="padding: 10px" |
| style="padding: 10px" | Selects database for manipulation and analysis
|-
| style="padding: 10px" | VARCHAR(#)
| style="padding: 10px" |
| style="padding: 10px" | Assigns a character array variable of length #
|-
| style="padding: 10px" | WHERE
| style="padding: 10px" |
| style="padding: 10px" | Limits the available values SELECT can pull from each column based on a logical statement (e.g. WHERE ''col1'' < 10)
|-
|}

{{Template: This Is Your Brain On Informatics}}

[[Category:This Is Your Brain On Informatics]]

This Is Your Brain On Informatics: MariaDB SQL Commands

2014-03-27T01:40:14Z

Tikenn:

== MariaDB SQL Commands ==

Note that the commands are capitalized by convention.

{| class = "wikitable"
|-
! colspan="3" | Common Commands in SQL
|-
! colspan="3" align = "center" | Boolean Operators
|-
| style="padding: 10px" colspan="3" align = "center" | AND
|-
| style="padding: 10px" colspan="3" align = "center" | OR
|-
| style="padding: 10px" colspan="3" align = "center" | NOT
|-
! Command*
! Syntax
! Description
|-
| style="padding: 10px" | mysql
| style="padding: 10px" | mysql -u ''username'' -p
| style="padding: 10px" | Command line command where ''username'' should be replaced by the user's account name
|-
| style="padding: 10px" | `''table''`
| style="padding: 10px" |
| style="padding: 10px" | Syntax for indicating a table
|-
| style="padding: 10px" | AS ''var''
| style="padding: 10px" |
| style="padding: 10px" | Sets an output to a variable
|-
| style="padding: 10px" | AUTO_INCREMENT
| style="padding: 10px" |
| style="padding: 10px" | Automatically adds +1 to an entry for a column for each successive entry
|-
| style="padding: 10px" | AVG()
| style="padding: 10px" |
| style="padding: 10px" | Gives an average of the values in the indicated column
|-
| style="padding: 10px" | BIGINT
| style="padding: 10px" |
| style="padding: 10px" | 64-bit integer
|-
| style="padding: 10px" | CHAR
| style="padding: 10px" |
| style="padding: 10px" | Assigns a character variable (allows ONLY 1 character)
|-
| style="padding: 10px" | CREATE TABLE `''table''`
| style="padding: 10px" |
| style="padding: 10px" | Creates a table of the given name with the properly input variable (see below)
|-
| style="padding: 10px" | CREATE TEMPORARY TABLE `[table]`
| style="padding: 10px" |
| style="padding: 10px" | Creates a temporary table of the given name
|-
| style="padding: 10px" | DATE
| style="padding: 10px" |
| style="padding: 10px" | Assigns a date variable of the form 00-00-0000
|-
| style="padding: 10px" | FROM
| style="padding: 10px" |
| style="padding: 10px" | Denotes which table SELECT pulls the columns from (e.g. SELECT [col1],[col2] FROM `''table''`
|-
| style="padding: 10px" | INSERT
| style="padding: 10px" | INSERT INTO ''table_name''<br /><br />VALUES (''value1,value2,value3,...'');<br /><br />INSERT INTO ''table_name'' (''column1,column2,column3,...'')<br /><br />VALUES (''value1,value2,value3,...''); -- specifies the columns the values go into
| style="padding: 10px" | Used with INTO to insert new data entries into the specified columns
|-
| style="padding: 10px" | INT
| style="padding: 10px" |
| style="padding: 10px" | 32-bit integer
|-
| style="padding: 10px" | INTO
| style="padding: 10px" | SELECT * or ''column_name(s)''<br />INTO ''newtable'' [IN ''externaldb'']<br />FROM ''table1'';
| style="padding: 10px" | Used with SELECT command to copy ''column_names'' from ''table1'' into ''newtable''
|-
| style="padding: 10px" | LIMIT #
| style="padding: 10px" |
| style="padding: 10px" | Limits to the top # number of entries (not necessarily by rank)
|-
| style="padding: 10px" | MAX()
| style="padding: 10px" |
| style="padding: 10px" | Gives the maximum of the values in the indicated column
|-
| style="padding: 10px" | MIN()
| style="padding: 10px" |
| style="padding: 10px" | Gives the minimum of the values in the indicated column
|-
| style="padding: 10px" | PRIMARY KEY
| style="padding: 10px" |
| style="padding: 10px" | Indicates which variable will differentiate each data entry
|-
| style="padding: 10px" | SELECT
| style="padding: 10px" |
| style="padding: 10px" | Selects columns from a database for analysis
|-
| style="padding: 10px" | UNSIGNED
| style="padding: 10px" |
| style="padding: 10px" | only allows positive integers or float values, always assigned after BIGINT or INT value
|-
| style="padding: 10px" | UPDATE
| style="padding: 10px" | UPDATE ''table_name''<br />SET ''column1=value1,column2=value2,...''<br />WHERE ''some_column''=''some_value;''
| style="padding: 10px" | Changes ''column1'' to ''value1'' based on the WHERE statement (use something unique to update only one row)
|-
| style="padding: 10px" | USE ''database''
| style="padding: 10px" |
| style="padding: 10px" | Selects database for manipulation and analysis
|-
| style="padding: 10px" | VARCHAR(#)
| style="padding: 10px" |
| style="padding: 10px" | Assigns a character array variable of length #
|-
| style="padding: 10px" | WHERE
| style="padding: 10px" |
| style="padding: 10px" | Limits the available values SELECT can pull from each column based on a logical statement (e.g. WHERE ''col1'' < 10)
|-
|}

{{Template: This Is Your Brain On Informatics}}

[[Category:This Is Your Brain On Informatics]]

This Is Your Brain On Informatics: MariaDB SQL Commands

2014-03-27T01:39:57Z

Tikenn:

== MariaDB SQL Commands ==

Note that the commands are capitalized by convention.

{| class = "wikitable"
|-
! colspan="3" | Common Commands in SQL
|-
! colspan="3" align = "center" | Boolean Operators
|-
| style="padding: 10px" colspan="3" align = "center" | AND
|-
| style="padding: 10px" colspan="3" align = "center" | OR
|-
| style="padding: 10px" colspan="3" align = "center" | NOT
|-
! Command*
! Syntax
! Description
|-
| style="padding: 10px" | mysql
| style="padding: 10px" | mysql -u ''username'' -p
| style="padding: 10px" | Command line command where ''username'' should be replaced by the user's account name
|-
| style="padding: 10px" | `''table''`
| style="padding: 10px" |
| style="padding: 10px" | Syntax for indicating a table
|-
| style="padding: 10px" | AS ''var''
| style="padding: 10px" |
| style="padding: 10px" | Sets an output to a variable
|-
| style="padding: 10px" | AUTO_INCREMENT
| style="padding: 10px" |
| style="padding: 10px" | Automatically adds +1 to an entry for a column for each successive entry
|-
| style="padding: 10px" | AVG()
| style="padding: 10px" |
| style="padding: 10px" | Gives an average of the values in the indicated column
|-
| style="padding: 10px" | BIGINT
| style="padding: 10px" |
| style="padding: 10px" | 64-bit integer
|-
| style="padding: 10px" | CHAR
| style="padding: 10px" |
| style="padding: 10px" | Assigns a character variable (allows ONLY 1 character)
|-
| style="padding: 10px" | CREATE TABLE `''table''`
| style="padding: 10px" |
| style="padding: 10px" | Creates a table of the given name with the properly input variable (see below)
|-
| style="padding: 10px" | CREATE TEMPORARY TABLE `[table]`
| style="padding: 10px" |
| style="padding: 10px" | Creates a temporary table of the given name
|-
| style="padding: 10px" | DATE
| style="padding: 10px" |
| style="padding: 10px" | Assigns a date variable of the form 00-00-0000
|-
| style="padding: 10px" | FROM
| style="padding: 10px" |
| style="padding: 10px" | Denotes which table SELECT pulls the columns from (e.g. SELECT [col1],[col2] FROM `''table''`
|-
| style="padding: 10px" | INSERT
| style="padding: 10px" | INSERT INTO ''table_name''<br /><br />VALUES (''value1,value2,value3,...'');<br /><br />INSERT INTO ''table_name'' (''column1,column2,column3,...'')<br /><br />VALUES (''value1,value2,value3,...''); -- specifies the columns the values go into
| style="padding: 10px" | Used with INTO to insert new data entries into the specified columns
|-
| style="padding: 10px" | INT
| style="padding: 10px" |
| style="padding: 10px" | 32-bit integer
|-
| style="padding: 10px" | INTO
| style="padding: 10px" | SELECT * or ''column_name(s)''<br />INTO ''newtable'' [IN ''externaldb'']<br />FROM ''table1'';
| style="padding: 10px" | Used with SELECT command to copy ''column_names'' from ''table1'' into ''newtable''
|-
| style="padding: 10px" | LIMIT #
| style="padding: 10px" |
| style="padding: 10px" | Limits to the top # number of entries (not necessarily by rank)
|-
| style="padding: 10px" | MAX()
| style="padding: 10px" |
| style="padding: 10px" | Gives the maximum of the values in the indicated column
|-
| style="padding: 10px" | MIN()
| style="padding: 10px" |
| style="padding: 10px" | Gives the minimum of the values in the indicated column
|-
| style="padding: 10px" | PRIMARY KEY
| style="padding: 10px" |
| style="padding: 10px" | Indicates which variable will differentiate each data entry
|-
| style="padding: 10px" | SELECT
| style="padding: 10px" |
| style="padding: 10px" | Selects columns from a database for analysis
|-
| style="padding: 10px" | UNSIGNED
| style="padding: 10px" |
| style="padding: 10px" | only allows positive integers or float values, always assigned after BIGINT or INT value
|-
| style="padding: 10px" | UPDATE
| style="padding: 10px" | UPDATE ''table_name''<br />SET ''column1=value1,column2=value2,...''<br />WHERE ''some_column''=''some_value;''
| style="padding: 10px" | Changes ''column1'' to ''value1'' based on the WHERE statement (use something unique to update only one row)
|-
| style="padding: 10px" | USE ''database''
| style="padding: 10px" |
| style="padding: 10px" | Selects database for manipulation and analysis
|-
| style="padding: 10px" | VARCHAR(#)
| style="padding: 10px" |
| style="padding: 10px" | Assigns a character array variable of length #
|-
| style="padding: 10px" | WHERE
| style="padding: 10px" |
| style="padding: 10px" | Limits the available values SELECT can pull from each column based on a logical statement (e.g. WHERE ''col1'' < 10)
|-
|}

*Commands are capitalized by convention.

{{Template: This Is Your Brain On Informatics}}

[[Category:This Is Your Brain On Informatics]]

This Is Your Brain On Informatics: MariaDB SQL Commands

2014-03-27T01:38:50Z

Tikenn:

== MariaDB SQL Commands ==
The language of Maria DB.

{| class = "wikitable"
|-
! colspan="3" | Common Commands in SQL
|-
! colspan="3" align = "center" | Boolean Operators
|-
| style="padding: 10px" colspan="3" align = "center" | AND
|-
| style="padding: 10px" colspan="3" align = "center" | OR
|-
| style="padding: 10px" colspan="3" align = "center" | NOT
|-
! Command*
! Syntax
! Description
|-
| style="padding: 10px" | mysql
| style="padding: 10px" | mysql -u ''username'' -p
| style="padding: 10px" | Command line command where ''username'' should be replaced by the user's account name
|-
| style="padding: 10px" | `''table''`
| style="padding: 10px" |
| style="padding: 10px" | Syntax for indicating a table
|-
| style="padding: 10px" | AS ''var''
| style="padding: 10px" |
| style="padding: 10px" | Sets an output to a variable
|-
| style="padding: 10px" | AUTO_INCREMENT
| style="padding: 10px" |
| style="padding: 10px" | Automatically adds +1 to an entry for a column for each successive entry
|-
| style="padding: 10px" | AVG()
| style="padding: 10px" |
| style="padding: 10px" | Gives an average of the values in the indicated column
|-
| style="padding: 10px" | BIGINT
| style="padding: 10px" |
| style="padding: 10px" | 64-bit integer
|-
| style="padding: 10px" | CHAR
| style="padding: 10px" |
| style="padding: 10px" | Assigns a character variable (allows ONLY 1 character)
|-
| style="padding: 10px" | CREATE TABLE `''table''`
| style="padding: 10px" |
| style="padding: 10px" | Creates a table of the given name with the properly input variable (see below)
|-
| style="padding: 10px" | CREATE TEMPORARY TABLE `[table]`
| style="padding: 10px" |
| style="padding: 10px" | Creates a temporary table of the given name
|-
| style="padding: 10px" | DATE
| style="padding: 10px" |
| style="padding: 10px" | Assigns a date variable of the form 00-00-0000
|-
| style="padding: 10px" | FROM
| style="padding: 10px" |
| style="padding: 10px" | Denotes which table SELECT pulls the columns from (e.g. SELECT [col1],[col2] FROM `''table''`
|-
| style="padding: 10px" | INSERT
| style="padding: 10px" | INSERT INTO ''table_name''<br /><br />VALUES (''value1,value2,value3,...'');<br /><br />INSERT INTO ''table_name'' (''column1,column2,column3,...'')<br /><br />VALUES (''value1,value2,value3,...''); -- specifies the columns the values go into
| style="padding: 10px" | Used with INTO to insert new data entries into the specified columns
|-
| style="padding: 10px" | INT
| style="padding: 10px" |
| style="padding: 10px" | 32-bit integer
|-
| style="padding: 10px" | INTO
| style="padding: 10px" | SELECT * or ''column_name(s)''<br />INTO ''newtable'' [IN ''externaldb'']<br />FROM ''table1'';
| style="padding: 10px" | Used with SELECT command to copy ''column_names'' from ''table1'' into ''newtable''
|-
| style="padding: 10px" | LIMIT #
| style="padding: 10px" |
| style="padding: 10px" | Limits to the top # number of entries (not necessarily by rank)
|-
| style="padding: 10px" | MAX()
| style="padding: 10px" |
| style="padding: 10px" | Gives the maximum of the values in the indicated column
|-
| style="padding: 10px" | MIN()
| style="padding: 10px" |
| style="padding: 10px" | Gives the minimum of the values in the indicated column
|-
| style="padding: 10px" | PRIMARY KEY
| style="padding: 10px" |
| style="padding: 10px" | Indicates which variable will differentiate each data entry
|-
| style="padding: 10px" | SELECT
| style="padding: 10px" |
| style="padding: 10px" | Selects columns from a database for analysis
|-
| style="padding: 10px" | UNSIGNED
| style="padding: 10px" |
| style="padding: 10px" | only allows positive integers or float values, always assigned after BIGINT or INT value
|-
| style="padding: 10px" | UPDATE
| style="padding: 10px" | UPDATE ''table_name''<br />SET ''column1=value1,column2=value2,...''<br />WHERE ''some_column''=''some_value;''
| style="padding: 10px" | Changes ''column1'' to ''value1'' based on the WHERE statement (use something unique to update only one row)
|-
| style="padding: 10px" | USE ''database''
| style="padding: 10px" |
| style="padding: 10px" | Selects database for manipulation and analysis
|-
| style="padding: 10px" | VARCHAR(#)
| style="padding: 10px" |
| style="padding: 10px" | Assigns a character array variable of length #
|-
| style="padding: 10px" | WHERE
| style="padding: 10px" |
| style="padding: 10px" | Limits the available values SELECT can pull from each column based on a logical statement (e.g. WHERE ''col1'' < 10)
|-
|}

*Commands are capitalized by convention.

{{Template: This Is Your Brain On Informatics}}

[[Category:This Is Your Brain On Informatics]]

This Is Your Brain On Informatics: MariaDB SQL Commands

2014-03-27T01:34:16Z

Tikenn:

== MariaDB SQL Commands ==
The language of Maria DB.

{| class = "wikitable"
|-
! colspan="3" align = "center" | Common Commands in SQL
|-
! colspan="3" align = "center" | Boolean Operators
|-
| colspan="3" align = "center" | AND
|-
| colspan="3" align = "center" | OR
|-
| colspan="3" align = "center" | NOT
|-
! Command*
! Syntax
! Description
|-
| mysql
| mysql -u ''username'' -p
| Command line command where ''username'' should be replaced by the user's account name
|-
| `''table''`
|
| Syntax for indicating a table
|-
| AS ''var''
|
| Sets an output to a variable
|-
| AUTO_INCREMENT
|
| Automatically adds +1 to an entry for a column for each successive entry
|-
| AVG()
|
| Gives an average of the values in the indicated column
|-
| BIGINT
|
| 64-bit integer
|-
| CHAR
|
| Assigns a character variable (allows ONLY 1 character)
|-
| CREATE TABLE `''table''`
|
| Creates a table of the given name with the properly input variable (see below)
|-
| CREATE TEMPORARY TABLE `[table]`
|
| Creates a temporary table of the given name
|-
| DATE
|
| Assigns a date variable of the form 00-00-0000
|-
| FROM
|
| Denotes which table SELECT pulls the columns from (e.g. SELECT [col1],[col2] FROM `''table''`
|-
| INSERT
| INSERT INTO ''table_name''<br /><br />VALUES (''value1,value2,value3,...'');<br /><br />INSERT INTO ''table_name'' (''column1,column2,column3,...'')<br /><br />VALUES (''value1,value2,value3,...''); -- specifies the columns the values go into
| Used with INTO to insert new data entries into the specified columns
|-
| INT
|
| 32-bit integer
|-
| INTO
| SELECT * or ''column_name(s)''<br />INTO ''newtable'' [IN ''externaldb'']<br />FROM ''table1'';
| Used with SELECT command to copy ''column_names'' from ''table1'' into ''newtable''
|-
| LIMIT #
|
| Limits to the top # number of entries (not necessarily by rank)
|-
| MAX()
|
| Gives the maximum of the values in the indicated column
|-
| MIN()
|
| Gives the minimum of the values in the indicated column
|-
| PRIMARY KEY
|
| Indicates which variable will differentiate each data entry
|-
| SELECT
|
| Selects columns from a database for analysis
|-
| UNSIGNED
|
| only allows positive integers or float values, always assigned after BIGINT or INT value
|-
| UPDATE
| UPDATE ''table_name''<br />SET ''column1=value1,column2=value2,...''<br />WHERE ''some_column''=''some_value;''
| Changes ''column1'' to ''value1'' based on the WHERE statement (use something unique to update only one row)
|-
| USE ''database''
|
| Selects database for manipulation and analysis
|-
| VARCHAR(#)
|
| Assigns a character array variable of length #
|-
| WHERE
|
| Limits the available values SELECT can pull from each column based on a logical statement (e.g. WHERE ''col1'' < 10)
|-
|}

*Commands are capitalized by convention.

{{Template: This Is Your Brain On Informatics}}

[[Category:This Is Your Brain On Informatics]]

This Is Your Brain On Informatics: Linux Commands

2014-03-27T00:57:56Z

Tikenn:

===General Linux Command Info===
*Almost every single command should have an argument (an input for a function)
*A filename in Linux refers to both a file's name and a directory's name

===Common Linux Commands===
{| class="wikitable"
|-
! style="padding: 10px;"| Command
! style="padding: 10px;"| Syntax
! style="padding: 10px;"| Description
|-
| style="padding: 10px;"| cat
| style="padding: 10px;"| cat ''filename''
| style="padding: 10px;"| Display file’s contents to the standard output device (usually your monitor)
|-
| style="padding: 10px;"| cd
| style="padding: 10px;"| cd ''/pathname''
| style="padding: 10px;"| Change to the given directory
|-
| style="padding: 10px;"| chmod*
| style="padding: 10px;"| chmod ''options'' ''mode'' ''filename''
| style="padding: 10px;"| Changes a file's permissions.
|-
| style="padding: 10px;"| chown
| style="padding: 10px;"| chown ''private_owner:group_owner'' ''filename''
| style="padding: 10px;"| Changes ownership of the file
|-
| style="padding: 10px;"| clear
| style="padding: 10px;"| clear
| style="padding: 10px;"| Clears the screen by scrolling (does not delete anything)
|-
| style="padding: 10px;"| cp
| style="padding: 10px;"| cp ''options'' ''source'' ''destination''
| style="padding: 10px;"| Copies a file from the source to the destination
|-
| style="padding: 10px;"| find
| style="padding: 10px;"| find ''/pathname'' ''string''
| style="padding: 10px;"| Starts at the indicated directory and searches for the string in a filename
|-
| style="padding: 10px;"| grep
| style="padding: 10px;"| grep ''options'' ''pattern'' ''filename''
| style="padding: 10px;"| Searches for the pattern in the file
|-
| style="padding: 10px;"| ifconfig
| style="padding: 10px;"| ifconfig
| style="padding: 10px;"| Displays the current networks available and various information about them
|-
| style="padding: 10px;"| ll
| style="padding: 10px;"| ll ''/pathname''
| style="padding: 10px;"| List Long: lists the details of the entire directory or file indicated
|-
| style="padding: 10px;"| ln
| style="padding: 10px;"| ln ''options'' ''source'' ''destination''
| style="padding: 10px;"| Link: creates a shortcut. Use -s for the ''options'' to create a soft link (more capabilities)
|-
| style="padding: 10px;"| ls
| style="padding: 10px;"| ls ''/pathname''
| style="padding: 10px;"| Lists the files and directories in a given directory
|-
| style="padding: 10px;"| man
| style="padding: 10px;"| man ''command''
| style="padding: 10px;"| Opens the manual page for the given command
|-
| style="padding: 10px;"| mkdir
| style="padding: 10px;"| mkdir ''options'' ''filename''
| style="padding: 10px;"| Makes a directory at the given location with the given name
|-
| style="padding: 10px;"| mv
| style="padding: 10px;"| mv ''options'' ''source'' ''destination''
| style="padding: 10px;"| Moves a file or directory from the source to the destination
|-
| style="padding: 10px;"| [[This Is Your Brain On Informatics: Pico|pico]]
| style="padding: 10px;"| pico ''filename''
| style="padding: 10px;"| Opens the given file in the pico text editor
|-
| style="padding: 10px;"| pwd
| style="padding: 10px;"| pwd
| style="padding: 10px;"| Displays the pathname for the current directory
|-
| style="padding: 10px;"| rm
| style="padding: 10px;"| rm ''options'' ''filename''
| style="padding: 10px;"| Removes the given file. If -rf is used for the options, a directory and its roots will be removed as well
|-
| style="padding: 10px;"| ssh
| style="padding: 10px;"| ssh ''options'' ''user@machine''
| style="padding: 10px;"| Remotely logs into the given machine with the given user name
|-
| style="padding: 10px;"| sudo
| style="padding: 10px;"| sudo ''command''
| style="padding: 10px;"| Allows super user privileges for the given command (requires root password). sudo su allows login to root
|-
| style="padding: 10px;"| tar
| style="padding: 10px;"| tar -xzvf ''filename''
| style="padding: 10px;"| Extracts files with the extension *.tar.gz or *.tgz
|-
| style="padding: 10px;"| touch
| style="padding: 10px;"| touch ''filename''
| style="padding: 10px;"| Creates an empty file with given name
|-
| style="padding: 10px;"| wget
| style="padding: 10px;"| wget ''internet address''
| style="padding: 10px;"| Downloads a file from a given internet address
|-

|}

===*Notes on chmod===
'''chmod''' has several input options. Using a "+" and an "r", "w", and/or "x" will add read, write, or execute permissions respectively to the given file. A "-" will take these away. The other system is a binary system in which there are permissions for the private user, the group, and the public (other) given as 000 000 000 where each set of three 0's equals the private user, group, or public respectively. The first 0 in each set of 0's is for reading permission, the second for writing, and the third for executing. Because it is binary 100 000 000 (permission for the private user to read only) will be written as 400 in the command line (after translating the binary to decimal where 100 = 4)

{{This Is Your Brain On Informatics}}

[[Category:This Is Your Brain On Informatics]]

This Is Your Brain On Informatics: Linux Commands

2014-03-27T00:46:29Z

Tikenn:

This Is Your Brain On Informatics

2014-03-27T00:39:56Z

Tikenn:

== Introduction ==
[[File:This Is Your Brain On Infomatics 03182014 Seung.jpg|thumb|250px|[https://services.medicine.uab.edu/facultyDirectory/FacultyData.asp?s_lname=Park&s_keyword=&s_fname=Seung&FacultyTypeID=&s_Department_Name=&s_ResearchTitle=&FID=61255 Seung Park, MD] Teaching]]

This class is an amazing course taught by [https://services.medicine.uab.edu/facultyDirectory/FacultyData.asp?s_lname=Park&s_keyword=&s_fname=Seung&FacultyTypeID=&s_Department_Name=&s_ResearchTitle=&FID=61255 Seung Park, MD] that gives an excellent background in many of the approaches used to handle "big data" from an informatics stand point (the only way to do it). This wiki has been developed as a general accessory to the course, including content that was taught in the class and content that might be useful for the final project.

However, this wiki is not just for the class. It contains much of the basic information of programming to help someone beginning their journey in programming or to serve as a resource along the way.

Below are several pages with content from the class and content that may be useful when continuing on from the class

*[[This Is Your Brain On Informatics: Linux|Linux]]
*[[This Is Your Brain On Informatics: NGINX|NGINX]]
*[[This Is Your Brain On Informatics: PHP-FPM|PHP-FPM]]
*[[This Is Your Brain On Informatics: MariaDB|MariaDB]]
*[[This Is Your Brain On Informatics: Pico|Pico]]
*[[This Is Your Brain On Informatics: Code Examples|Code Examples]]

== Previous Classes ==
This class has attracted a wide array of students at its inception starting out as a class designed for anyone that is interested in acquiring a foundation in programming. Take a look [[This Is Your Brain On Informatics: Previous Classes|here]] to see some of the previous classes and who all they consisted of.

== Programming Resources ==
While this page is a great resource for programming information, there are many others. Below are some valuable sites for learning to program.

* [http://www.w3schools.com/ w3schools]
* [http://www.bentobox.io/index.html bento]
* [http://www.tutorialspoint.com/ Tutorials Point]
* [http://www.codecademy.com/ Code Academy]

{{Template:This Is Your Brain On Informatics}}

[[Category:This Is Your Brain On Informatics]]

This Is Your Brain On Informatics: Previous Classes

2014-03-19T23:02:07Z

Tikenn: /* Second Class (Mar 2014) */

== First Class (Oct 2013) ==
The first class consisted of MSTP students and a PI. This was the first class at UAB that sparked a movement for the class to begin impacting students around the school.

== Second Class (Mar 2014) ==
The second class was filled with medical students, an MSTP student, a PhD student, pre-dental student, and a pathologist.

<gallery caption="Class of March 2014" align="center" heights="200px" widths="300px">
Image:This Is Your Brain On Informatics 03182014 Class(1).jpg
Image:This Is Your Brain On Informatics 03182014 Class(2).jpg
Image:This Is Your Brain On Informatics 03182014 Class(3).jpg
Image:This Is Your Brain On Informatics 03182014 Class(4).jpg
</gallery>

{{Template:This Is Your Brain On Informatics}}

[[Category:This Is Your Brain On Informatics]]

This Is Your Brain On Informatics: Previous Classes

2014-03-19T22:07:43Z

Tikenn:

== First Class (Oct 2013) ==
The first class consisted of MSTP students and a PI. This was the first class at UAB that sparked a movement for the class to begin impacting students around the school.

== Second Class (Mar 2014) ==
The second class was filled with medical students, an MSTP student, a PhD student, pre-dental student, and a pathologist.

<gallery caption="Class of March 2014" align="center" heights="200px" widths="200px">
Image:This Is Your Brain On Informatics 03182014 Class(1).jpg
Image:This Is Your Brain On Informatics 03182014 Class(2).jpg
Image:This Is Your Brain On Informatics 03182014 Class(3).jpg
Image:This Is Your Brain On Informatics 03182014 Class(4).jpg
</gallery>

{{Template:This Is Your Brain On Informatics}}

[[Category:This Is Your Brain On Informatics]]

This Is Your Brain On Informatics

2014-03-19T03:12:36Z

Tikenn: /* Introduction */

== Introduction ==
[[File:This Is Your Brain On Infomatics 03182014 Seung.jpg|thumb|250px|[https://services.medicine.uab.edu/facultyDirectory/FacultyData.asp?s_lname=Park&s_keyword=&s_fname=Seung&FacultyTypeID=&s_Department_Name=&s_ResearchTitle=&FID=61255 Seung Park, MD] Teaching]]

This class is an amazing course taught by [https://services.medicine.uab.edu/facultyDirectory/FacultyData.asp?s_lname=Park&s_keyword=&s_fname=Seung&FacultyTypeID=&s_Department_Name=&s_ResearchTitle=&FID=61255 Seung Park, MD] that gives an excellent background in many of the approaches used to handle "big data" from an informatics stand point (the only way to do it). This wiki has been developed as a general accessory to the course, including content that was taught in the class and content that might be useful for the final project.

However, this wiki is not just for the class. It contains much of the basic information of programming to help someone beginning their journey in programming or to serve as a resource along the way.

Below are several pages with content from the class and content that may be useful when continuing on from the class

*[[This Is Your Brain On Informatics: Linux|Linux]]
*[[This Is Your Brain On Informatics: NGINX|NGINX]]
*[[This Is Your Brain On Informatics: PHP-FPM|PHP-FPM]]
*[[This Is Your Brain On Informatics: MariaDB|MariaDB]]
*[[This Is Your Brain On Informatics: Pico|Pico]]
*[[This Is Your Brain On Informatics: Code Examples|Code Examples]]

== Previous Classes ==
This class has attracted a wide array of students at its inception starting out as a class designed for anyone that is interested in acquiring a foundation in programming. Take a look [[This Is Your Brain On Informatics: Previous Classes|here]] to see some of the previous classes and who all they consisted of.

== Programming Resources ==
While this page is a great resource for programming information, there are many others. Below are some valuable sites for learning to program.

* [http://www.w3schools.com/ w3schools]
* [http://www.tutorialspoint.com/ Tutorials Point]
* [http://www.codecademy.com/ Code Academy]

{{Template:This Is Your Brain On Informatics}}

[[Category:This Is Your Brain On Informatics]]

This Is Your Brain On Informatics

2014-03-19T03:09:49Z

Tikenn:

== Introduction ==
[[File:This Is Your Brain On Infomatics 03182014 Seung.jpg|thumb|250px|[https://services.medicine.uab.edu/facultyDirectory/FacultyData.asp?s_lname=Park&s_keyword=&s_fname=Seung&FacultyTypeID=&s_Department_Name=&s_ResearchTitle=&FID=61255 Seung Park, MD] Teaching]]

This class is an amazing class taught by [https://services.medicine.uab.edu/facultyDirectory/FacultyData.asp?s_lname=Park&s_keyword=&s_fname=Seung&FacultyTypeID=&s_Department_Name=&s_ResearchTitle=&FID=61255 Seung Park, MD] that gives an excellent background in many of the approaches used to handle "big data" from an informatics stand point (the only way to do it). This wiki has been developed as a general accessory to the course, including content that was taught in the class and content that might be useful for the final project.

However, this wiki is not just for the class. It contains much of the basic information of programming to help someone beginning their journey in programming or to serve as a resource along the way.

Below are several pages with content from the class and content that may be useful when continuing on from the class

*[[This Is Your Brain On Informatics: Linux|Linux]]
*[[This Is Your Brain On Informatics: NGINX|NGINX]]
*[[This Is Your Brain On Informatics: PHP-FPM|PHP-FPM]]
*[[This Is Your Brain On Informatics: MariaDB|MariaDB]]
*[[This Is Your Brain On Informatics: Pico|Pico]]
*[[This Is Your Brain On Informatics: Code Examples|Code Examples]]

== Previous Classes ==
This class has attracted a wide array of students at its inception starting out as a class designed for anyone that is interested in acquiring a foundation in programming. Take a look [[This Is Your Brain On Informatics: Previous Classes|here]] to see some of the previous classes and who all they consisted of.

== Programming Resources ==
While this page is a great resource for programming information, there are many others. Below are some valuable sites for learning to program.

* [http://www.w3schools.com/ w3schools]
* [http://www.tutorialspoint.com/ Tutorials Point]
* [http://www.codecademy.com/ Code Academy]

{{Template:This Is Your Brain On Informatics}}

[[Category:This Is Your Brain On Informatics]]

Template:This Is Your Brain On Informatics

2014-03-19T03:07:44Z

Tikenn:

{{Navbox
|name = This Is Your Brain On Informatics
|bodyclass = hlist
|title = [[This Is Your Brain On Informatics]]

|group1 = [[This Is Your Brain On Informatics: Linux|Linux]]
|list1 =
* [[This Is Your Brain On Informatics: Linux Commands|Using the System]]
* [[This Is Your Brain On Informatics: Common Pathnames|Common Pathnames]]
* [[This Is Your Brain On Informatics: Network|Setting up the Network]]
* [[This Is Your Brain On Informatics: DenyHosts|Working with DenyHosts]]

|group2 = [[This Is Your Brain On Informatics: NGINX|NGINX]]
|list2 =
* [[This Is Your Brain On Informatics: NGINX and Large Files|NGINX and Large Files]]

|group3 = PHP-FPM
|list3 = [[This Is Your Brain On Informatics: PHP-FPM|PHP-FPM]]

|group4 = [[This Is Your Brain On Informatics: MariaDB|MariaDB]]
|list4 =
* [[This Is Your Brain On Informatics: User Interfaces|User Interfaces]]
* [[This Is Your Brain On Informatics: MariaDB SQL Commands|MariaDB SQL Commands]]
* [[This Is Your Brain On Informatics: Q&A|In-Class Questions and Answers]]

|group5 = Pico
|list5 = [[This Is Your Brain On Informatics: Pico|Pico]]

|group6 = [[This Is Your Brain On Informatics: Code Examples|Code Examples]]
|list6 =
* [[This Is Your Brain On Informatics: HTML|HTML]]
* [[This Is Your Brain On Informatics: PHP|PHP]]

|group7 = [[This Is Your Brain On Informatics: Previous Classes|Previous Classes]]
|list7 =
* [[This Is Your Brain On Informatics: Previous Classes|Previous Classes]]

}}<noinclude>

</noinclude>

This Is Your Brain On Informatics: Previous Classes

2014-03-19T03:05:31Z

Tikenn:

== First Class (Oct 2013) ==
The first class consisted of MSTP students and a PI. This was the first class at UAB that sparked a movement for the class to begin impacting students around the school.

== Second Class (Mar 2014) ==
The second class was filled with medical students, an MSTP student, a PhD student, pre-dental student, and a pathologist.

<gallery caption="Class of March 2014" align="center">
Image:This Is Your Brain On Informatics 03182014 Class(1).jpg
Image:This Is Your Brain On Informatics 03182014 Class(2).jpg
Image:This Is Your Brain On Informatics 03182014 Class(3).jpg
Image:This Is Your Brain On Informatics 03182014 Class(4).jpg
</gallery>

{{Template:This Is Your Brain On Informatics}}

[[Category:This Is Your Brain On Informatics]]

File:This Is Your Brain On Informatics 03182014 Class(4).jpg

2014-03-19T02:57:59Z

Tikenn: This will be added to the second class gallery

This will be added to the second class gallery

File:This Is Your Brain On Informatics 03182014 Class(3).jpg

2014-03-19T02:57:14Z

Tikenn: This will be added to the second class gallery

This will be added to the second class gallery

File:This Is Your Brain On Informatics 03182014 Class(2).jpg

2014-03-19T02:56:10Z

Tikenn: This goes in the second class gallery

This goes in the second class gallery

File:This Is Your Brain On Informatics 03182014 Class(1).jpg

2014-03-19T02:54:57Z

Tikenn: This goes in the gallery

This goes in the gallery

This Is Your Brain On Informatics

2014-03-19T02:52:08Z

Tikenn:

== Introduction ==

[[File:This Is Your Brain On Infomatics 03182014 Seung.jpg|thumb|250px|[https://services.medicine.uab.edu/facultyDirectory/FacultyData.asp?s_lname=Park&s_keyword=&s_fname=Seung&FacultyTypeID=&s_Department_Name=&s_ResearchTitle=&FID=61255 Seung Park, MD] Teaching]]

This class is an amazing class taught by [https://services.medicine.uab.edu/facultyDirectory/FacultyData.asp?s_lname=Park&s_keyword=&s_fname=Seung&FacultyTypeID=&s_Department_Name=&s_ResearchTitle=&FID=61255 Seung Park, MD] that gives an excellent background in many of the approaches used to handle "big data" from an informatics stand point (the only way to do it). This wiki has been developed as a general accessory to the course, including content that was taught in the class and content that might be useful for the final project.

However, this wiki is not just for the class. It contains much of the basic information of programming to help someone beginning their journey in programming or to serve as a resource along the way.

Below are several pages with content from the class and content that may be useful when continuing on from the class

*[[This Is Your Brain On Informatics: Linux|Linux]]
*[[This Is Your Brain On Informatics: NGINX|NGINX]]
*[[This Is Your Brain On Informatics: PHP-FPM|PHP-FPM]]
*[[This Is Your Brain On Informatics: MariaDB|MariaDB]]
*[[This Is Your Brain On Informatics: Pico|Pico]]
*[[This Is Your Brain On Informatics: Code Examples|Code Examples]]

== Previous Classes ==

This class has attracted a wide array of students at its inception starting out as a class designed for anyone that is interested in acquiring a foundation in programming. Take a look [[This Is Your Brain On Informatics: Previous Classes|here]] to see some of the previous classes and who all they consisted of.

== Programming Resources ==

While this page is a great resource for programming information, there are many others. Below are some valuable sites for learning to program.

* [http://www.w3schools.com/ w3schools]
* [http://www.tutorialspoint.com/ Tutorials Point]
* [http://www.codecademy.com/ Code Academy]

{{Template:This Is Your Brain On Informatics}}

[[Category:This Is Your Brain On Informatics]]

This Is Your Brain On Informatics: Previous Classes

2014-03-19T02:48:03Z

Tikenn:

This Is Your Brain On Informatics: Previous Classes

2014-03-19T02:47:18Z

Tikenn: Created page with "== First Class (Oct 2013) == The first class consisted of MSTP students and a PI. This was the first class at UAB that sparked a movement for the class to begin impacting stu..."

This Is Your Brain On Informatics

2014-03-19T02:44:58Z

Tikenn: /* Previous Classes */

== Introduction ==

[[File:This Is Your Brain On Infomatics 03182014 Seung.jpg|thumb|250px|[https://services.medicine.uab.edu/facultyDirectory/FacultyData.asp?s_lname=Park&s_keyword=&s_fname=Seung&FacultyTypeID=&s_Department_Name=&s_ResearchTitle=&FID=61255 Seung Park, MD] Teaching]]

This class is an amazing class taught by [https://services.medicine.uab.edu/facultyDirectory/FacultyData.asp?s_lname=Park&s_keyword=&s_fname=Seung&FacultyTypeID=&s_Department_Name=&s_ResearchTitle=&FID=61255 Seung Park, MD] that gives an excellent background in many of the approaches used to handle "big data" from an informatics stand point (the only way to do it). This wiki has been developed as a general accessory to the course, including content that was taught in the class and content that might be useful for the final project.

However, this wiki is not just for the class. It contains much of the basic information of programming to help someone beginning their journey in programming or to serve as a resource along the way.

Below are several pages with content from the class and content that may be useful when continuing on from the class

*[[This Is Your Brain On Informatics: Linux|Linux]]
*[[This Is Your Brain On Informatics: NGINX|NGINX]]
*[[This Is Your Brain On Informatics: PHP-FPM|PHP-FPM]]
*[[This Is Your Brain On Informatics: MariaDB|MariaDB]]
*[[This Is Your Brain On Informatics: Pico|Pico]]
*[[This Is Your Brain On Informatics: Code Examples|Code Examples]]

== Previous Classes ==

This class has attracted a wide array of students at its inception starting out as a class designed for anyone that is interested in acquiring a foundation in programming. Take a look [[This Is Your Brain On Informatics: Previous Classes|here]] to see some of the previous classes and who all they consisted of.

== Programming Resources ==

While this page is a great resource for programming information, it is not the only one. Below are some links to more resources that may be useful.

* [http://www.w3schools.com/ w3schools]
* [http://www.tutorialspoint.com/ Tutorials Point]
* [http://www.codecademy.com/ Code Academy]

{{Template:This Is Your Brain On Informatics}}

[[Category:This Is Your Brain On Informatics]]

HTML: Nucleotide Fun

2014-03-19T02:41:36Z

Tikenn:

Note: This code will only run with the PHP file that is also titled [[PHP: Nucleotide Fun|Nucleotide Fun]]
.
<syntaxhighlight lang="html5" enclose="div">
<html>
<head>
<title>Nucleotide Test</title>
</head>

<body>
<h1>Please enter a nucleotide sequence (DNA or RNA)</h1>
<form action = "nucleotide.php" method = "get">
<input name = "seq" type = "text"></input>
<input type = "submit" value = "submit"></input>
</form>
</body>
</html>
</syntaxhighlight>

{{This Is Your Brain On Informatics}}

[[Category:This Is Your Brain On Informatics]]

HTML: Nucleotide Fun

2014-03-19T02:41:10Z

Tikenn:

Note: This code will only run with PHP file that is also titled [[PHP: Nucleotide Fun|Nucleotide Fun]]
.
<syntaxhighlight lang="html5" enclose="div">
<html>
<head>
<title>Nucleotide Test</title>
</head>

<body>
<h1>Please enter a nucleotide sequence (DNA or RNA)</h1>
<form action = "nucleotide.php" method = "get">
<input name = "seq" type = "text"></input>
<input type = "submit" value = "submit"></input>
</form>
</body>
</html>
</syntaxhighlight>

{{This Is Your Brain On Informatics}}

[[Category:This Is Your Brain On Informatics]]

Form Page

2014-03-19T02:40:58Z

Tikenn:

<syntaxhighlight lang="html5" enclose="div">
<html>
<head>
<title> 
HTML File
</title>
</head>

<body>
<form action="test.php" method="get"> 
<select name="var"> 
<option value="0">0</option> 
<option value="1">1</option>
</select>

<input name="ooga" type="text"></input> 
<input type="submit" value="submit"></input> 
</form>
</body>
</html>
</syntaxhighlight>

{{This Is Your Brain On Informatics}}

[[Category:This Is Your Brain On Informatics]]

Basic HTML

2014-03-19T02:40:46Z

Tikenn:

<syntaxhighlight lang="html5" enclose="div">



<html> 
<head> 
<title> 
HTML File
</title>
</head>

<body> 
<a name="gbs788"></a> 
<h1>GBS 788</h1> 
<p> 
"Well, Prince, so Genoa and Lucca are now just family estates of the
Buonapartes. <strong>But I warn you, if you don't tell me that this</strong> 
means war, if you still try to defend the infamies and horrors perpetrated
by that Antichrist—I really believe he is Antichrist—I will have nothing
more to do with you and you are no longer my friend, no longer my 'faithful
slave,' as you call yourself! But how do you do? I see I have frightened
you—sit down and tell me all the news."
</p>
<p>
HTML is <em>written in the form of HTML elements</em> consisting of tags enclosed 
in angle brackets (like <html>), within the web page content. HTML tags
most commonly come in pairs like and , although some tags represent empty
elements and so are unpaired, for example <img>. The first
tag in a pair is the start tag, and the second tag is the end tag (they
are also called opening tags and closing tags). In between these tags web
</p>
<p>
During the late 1900s, man’s life span has increased dramatically from an
average of 50 years to 70 years. With this amazing increase in life, man
has become afflicted with diseases that were not common, if hardly known,
before. One of those diseases is cancer, a disease today dreaded by many.
Because this disease is so wide spread, a separate classification of
doctors has been made to study and treat this disease: the oncologist.
Oncology is an amazing career that requires extensive education in order
for the oncologist to perform his daily tasks.
</p>

<p>
The first aspect of oncology is the disease itself, cancer. Cancer first
begins by the growth of an abnormal cell, caused by some malfunction in
the DNA of the cell. Although this problem is normally causes certain
systems designed to protect the body to either destroy the cell or cause
the cell to self-destruct, the cancer cell has so maligned its DNA that
these safety precautions are shut down. Once the cancer has developed it
is given a name based on its origin in the body. Because the cancer cells
do not die, the cancer cells reproduction causes their number to increase
without any loss of the previous cells. This reproduction slowly or
sometimes quickly pushes the other good cells away.
</p>
<p>
Because this disease is so deadly and so common in today’s society, a
classification of doctors, called oncologists, was formed to study and
treat cancer, specifically the malignant tumors that cancer forms in the
body. Yet cancer became so wide spread that even the classification of
oncologists was broken down further into three divisions: the medical
oncologist, the surgical oncologist, and the radiation oncologist.
The first division is a medical oncologist who uses certain types of
medicine and chemotherapy to rid the body of malignant tumors. The second
division is a surgical oncologist. This oncologist uses surgery to try to
rid the body malignant tumors. The final division of oncologists is a
radiation oncologist who uses various forms of radiation to kill off
cancer cells.
</p>

<p>
Since Oncology is such a large and complex career, it requires a
significant amount of training to become an oncologist, starting even in
high school. When in high school a student needs to prepare to be an
oncologist by studying most of the sciences including biology, chemistry,
physics, and anatomy to prepare himself for college and extensive science
knowledge necessary to diagnose and treat a patient with drugs or surgery.
Also, mathematic courses such as Algebra I and II, Geometry, and
Trigonometry will be very important since the growth of a tumor and the
effects of chemotherapy on that <a href="#gbs788">tumor</a> can be 
predicted using
</p>

<p>
<a href="http://cnn.com">CNN</a> 
</p>
</body>
</html>

</syntaxhighlight>

{{This Is Your Brain On Informatics}}

[[Category:This Is Your Brain On Informatics]]

HTML/PHP Database Dump

2014-03-19T02:40:29Z

Tikenn:

<syntaxhighlight lang="php" enclose="div">
<?php
$con = mysqli_connect("localhost", "gbs788db", "pw", "gbs788db"); //This references the database. We store it as a variable only so that we don't have to keep writing it out.
if(mysqli_connect_errno())
{
die("Could not connect: " . mysqli_connect_errno());//Kills the connection if an error and uses mysqli_connect_errno () to print a readable message to the screen
/*The error number will pass as a zero if it is successful; otherwise it will include an error number. The "." is a concatenator. */
}
/*If we made it this far, it means that we successfully connected and made it to the next line. By putting echo, we are including html now!!*/
echo '
<html>
<head>
<title>Ooga</title>
</head>
<body>
<h1>It is Tims Fault</h1>
<table border="1">
<tr>
<th>Accession</th>
<th>Ordered By</th>
<th>Test</th>
<th>Turn Around Time</th>
<th>Result</th>
</tr>
';
$sql = "SELECT * FROM `test2`;";
$result = mysqli_query($con, $sql); //This does what we have been doing in SQL: connecting to the database, and then putting in the query.
while ($row=mysqli_fetch_array($result))//This command just looks at a table row by row.
/*This while loop allows the computer to keep going back in and getting another result*/
{
echo '
<tr>
<td>' . $row['accession'] . '</td>
<td>' . $row['ordering'] . '</td>
<td>' . $row['test'] . '</td>
<td>' . $row['tat'] . '</td>
<td>' . $row['result'] . '</td>
</tr>
'; /*This closes out the echo*/
}
echo '
</table>
</body>
</html>
';
?>
</syntaxhighlight>

{{This Is Your Brain On Informatics}}

[[Category:This Is Your Brain On Informatics]]

Genesetdb

2014-03-19T02:40:15Z

Tikenn:

<syntaxhighlight lang="php" enclose="div">
<html>
<head>
<title>genetable for the ooga</title>
</head>
<body>
<h1> Genetable</h1>
<table border="1">
<tr>
<th>Experiment Number</th>
<th>Gene ID</th>
</tr>
<?php
$con= mysqli_connect("localhost", "ooga", "booga","genesetdb");
if(mysqli_connect_errno())
{
die( "could not connect: " . mysqli_connect_error());
}
// Get absolute count of rows in table "genesets"; export
// that count into a variable called $pidcount
$sql = "SELECT COUNT(*) AS cnt FROM `genesets`;";
$result = mysqli_query($con, $sql);
$row = mysqli_fetch_array($result);
$pidcount = $row['cnt'];
/*
Now get the entirety of genesets and CHOWN THE HELL OUT OF IT!
Where "CHOWNing" in this case means the generation of a table
that looks roughly like:
pid geneid
--- ------
1 $row[3]
1 $row[4]
1 $row[5]
...
1 $row[203]
2 $row[3]
...
*/
$sql = "SELECT * FROM `genesets`;";
$result = mysqli_query($con, $sql);
while($row = mysqli_fetch_array($result))
{
for($i = 3; $i<204; $i++)
{
$booga = "INSERT INTO finalgeneset(exp,geneid) VALUES(" . $row[0] . "," . $row[$i] . ");";
$ooga = mysqli_query($con, $booga);
echo '
<tr>
<td>' . $row[0] . '</td>
<td>' . $row[$i] . '</td>
</tr>
';
}
}
?>
</table>
</body>
</html>
</syntaxhighlight>

{{This Is Your Brain On Informatics}}

[[Category:This Is Your Brain On Informatics]]

PHP: Nucleotide Fun

2014-03-19T02:39:57Z

Tikenn:

Note: This is the PHP file that will run with the HTML file also titled [[HTML: Nucleotide Fun|Nucleotide Fun]].

<syntaxhighlight lang="php">
<?php

$DNA = " does not contain U.";
$RNA = " contains U.";
$seq = $_GET['seq'];

for($i=0; $i<strlen($seq); $i++)
{
if($seq[$i] == 'U' || $seq[$i] == 'u')
{
echo "The input sequence is RNA because RNA" . $RNA . "\n";
break;
}

else if($i == strlen($seq)-1)
{
echo "The input sequence is DNA because DNA" . $DNA . "\n";
}

}

?>
</syntaxhighlight>

{{This Is Your Brain On Informatics}}

[[Category:This Is Your Brain On Informatics]]

HTML/PHP Database Dump

2014-03-19T02:39:37Z

Tikenn:

HTML: Nucleotide Fun

2014-03-19T02:39:19Z

Tikenn:

Form Page

2014-03-19T02:39:07Z

Tikenn:

Basic HTML

2014-03-19T02:38:44Z

Tikenn:

This Is Your Brain On Informatics: PHP

2014-03-19T02:38:24Z

Tikenn:

=== Example Codes ===
*[[HTML/PHP Database Dump]]
*[[PHP: Nucleotide Fun|Nucleotide Fun]]
*[[genesetdb]]

{{This Is Your Brain On Informatics}}

[[Category:This Is Your Brain On Informatics]]

This Is Your Brain On Informatics: HTML

2014-03-19T02:37:42Z

Tikenn:

=== HTML Examples ===
*[[Basic HTML]]
*[[Form Page]]
*[[HTML: Nucleotide Fun|Nucleotide Fun]]

{{This Is Your Brain On Informatics}}

[[Category:This Is Your Brain On Informatics]]

This Is Your Brain On Informatics: HTML

2014-03-19T02:37:36Z

Tikenn:

=== HTML Examples ===
*[[Basic HTML]]
*[[Form Page]]
*[[HTML: Nucleotide Fun|Nucleotide Fun]]

{{This Is Your Brain On Informatics}}

This Is Your Brain On Informatics: Code Examples

2014-03-19T02:37:17Z

Tikenn:

=== Languages ===
*[[This Is Your Brain On Informatics: HTML|HTML]]
*[[This Is Your Brain On Informatics: PHP|PHP]]

{{This Is Your Brain On Informatics}}

[[Category:This Is Your Brain On Informatics]]

This Is Your Brain On Informatics: Pico

2014-03-19T02:36:48Z

Tikenn:

Below are some common commands that can be used to easily move around in Pico. This program can be easily accessed by typing in [[This Is Your Brain On Informatics: Linux Commands|pico ''/pathname'']] on the command line.

{| class = "wikitable"

|-
! Command* !! Description
|-
| ^k || delete line
|-
| ^u || undoes one typo
|-
| ^v || page down
|-
| ^w || find
|-
| ^y || page down
|-

|}

<nowiki>*</nowiki>The ^ symbol indicates the Ctrl key for Windows users and the Command key for Mac users.

{{This Is Your Brain On Informatics}}

[[Category:This Is Your Brain On Informatics]]