1. How to install Google Earth in Ubuntu?
(Linux/Linux)

... Run the command below to make the bin file executable chmod +x GoogleEarthLinux.bin Now we need to execute the bin file to install Google Earth. ./GoogleEarthLinux.bin  ...

2. ERROR 1194 (HY000): Table 'mytable' is marked as crashed and should be repaired, how do I fix this?
(Databases/mySql)

Question: ERROR 1194 (HY000): Table 'mytable' is marked as crashed and should be repaired, how do I fix this? 'mytable' is the name of your table. Error: 1194 SQLSTATE: HY000: means ER_CRASHED_ON_USAGE ...

3. How to remove a html table row using JQuery?
(JQuery/JQuery)

Question: How to remove a html table row using JQuery?   Answer:  Ensure that the html table row has an id eg.<tr id="TABLE_ROW_ID"><td>I want to be removed</td></tr> Now ...

4. How to Export your MySQL database schema to a file using the Command Line?
(Databases/mySql)

Question: How to Export your MySQL database schema to a file using the Command Line?   Answer:  Use the following command in the Command Line Interface mysqldump --no-data --tables -uMYSQL_USER_NAME ...

5. How to get random rows when querying a database table using mySql?
(Databases/mySql)

Question: How to get random rows when querying a database table using mySql? For example if you have a table with 100 rows in it and you need to get 3 random rows then this could come in handy.   Answer: ...

6. How to alternate between 2 colors using PHP?
(PHP/PHP)

Question: How to alternate between 2 colors using PHP? This could come in handy if you have a table with multiple rows and if you wish to alternate between 2 colors.   Answer: We'll need to use the ...

7. How to delete a column in a database table using postgres via the command line?
(Databases/pgsql)

Questions: How to delete a column in a database table using postgres sql via the command line?   Answer: Use the following statement ALTER TABLE my_table DROP COLUMN my_column; Replace my_table with ...

8. Installing Adobe Air on Ubuntu
(Linux/Linux)

... using the wget commandwget http://airdownload.adobe.com/air/lin/download/1.5/AdobeAIRInstaller.bin Save the file in your Home Directory or any other Directory Give the file executable privelages by using ...

9. Error: "Ignoring query to other database" when running a mySql command in the command line
(Databases/mySql)

Question: I get the the following error: "Ignoring query to other database" when running a mySql command in the command line. Eg. SELECT  * FROM users; or SHOW tables;   Answer:  In the command line ...

10. How to count the number of table rows within an html table using JQuery?
(JQuery/JQuery)

Question: How to count the number of table rows within an html table using JQuery?   Answer: var countRows = $('#tableID tr').length; alert(countRows) or var countRows = $('#tableID tr').size; alert(countRows)  ...

11. How to upload a file via Ajax using a form with JQuery and PHP?
(JQuery/JQuery)

...         <table cellpadding="4" cellspacing="4" border="0">             <tr>                 <td colspan="2"><h1>Upload File via Ajax</h1></td>             </tr> ...

12. How to change the root mySql password with mySql installed on Ubuntu/Linux?
(Linux/Linux)

... the user table in the mySql database. Open a new Terminal Window and type in the command below to Login to the mySql server. mysql -u root -p Enter your password. Now you need to switch to the mysql database. ...

13. How to export data to a CSV file from a postgres database
(Databases/pgsql)

... ',' products = (Database Table) '/home/user/products.csv' = (Location where to save the csv file) You need to have write permissions to write the file to the filesystem with the postgres user  ...

14. How to export data to a CSV file from a postgres database together with table headings?
(Databases/pgsql)

Question: How to export data to a CSV file from a postgres database together with table headings?   Answer:  Type in the following command in postgres using the command line: copy products to '/home/user/products.csv' ...

15. How to import a CSV file into a postgres database table?
(Databases/pgsql)

Question: How to import a CSV file into a postgres database table?   Answer:  Type in the following command in postgres using the command line: copy products from '/home/user/products.csv' using ...

16. How to check how much memory you have available on Ubuntu (Linux)?
(Linux/Linux)

... Active:           872248 kB Inactive:         640876 kB Active(anon):     599548 kB Inactive(anon):    25012 kB Active(file):     272700 kB Inactive(file):   615864 kB Unevictable:           8 kB Mlocked:               ...

17. What's the difference between RIGHT, LEFT, OUTER, INNER, JOIN?
(Databases/Sql)

Question: What's the difference between RIGHT, LEFT, OUTER, INNER, JOIN? Answer: The difference is the way the tables are joined if no common records are available. RIGHT - RIGHT JOIN is the opposite ...

18. How to copy a columns data from one table into a column in another table using postgres?
(Databases/pgsql)

Question: How to copy a columns data from one table into a column in another table using postgres? Eg. name columns data from the users table into name column in the new_users table. Answer: Execute the ...

19. Comparison Operators
(PHP/PHP)

PHP comparison operators allows you to compare two values with each other. Below is a table of all the different comparison operators that are available for PHP     Comparison Operators ...

20. How to copy data from one table to another using pgsql
(Databases/pgsql)

If you need to copy data from one table (table_a) into another table (table_b) using pgsql. There are 2 methods on how to do this. Method 1 NOTE: If you are using this method table_b should not yet exist. ...