How to insert data into MySQL table

Here is a general form of insert command:

insert into table (column1, column2) values (value1, value2);

The insert statement inserts new row into an existing table. The table is the name of the table into which we want to insert data, column1 and column2 are column names and value1, value2 are values for the respective columns.

Example:

How to convert xls files to csv in Linux

Install xls2csv

yum -y install xls2csv

To convert your xls file to csv, just type this command:

convertxls2csv -x filename.xls -c filename.csv

This script is very useful if you have a lot of excel files to convert. This will help you save a lot of time than converting it one by one.

#!/bin/bash
for files in *.xls
do
convertxls2csv -x "$files" -c "${files%.*}.csv"
done

How to configure Java plugin in Google Chrome beta in Fedora 12

If you don't have a Java Runtime Environment installed in your system, you can follow this guide. Download and install the beta version of Google Chrome for linux from here or install it using yum, you can follow my tutorial here.

How to install VirtualBox Open Source Edition in Fedora 12

Enable RPM Fusion repository

rpm -Uvh http://download1.rpmfusion.org/free/fedora/rpmfusion-free-release-stable.noarch.rpm
rpm -Uvh http://download1.rpmfusion.org/nonfree/fedora/rpmfusion-nonfree-release-stable.noarch.rpm

Then install Virtualbox by typing this command:

yum -y install VirtualBox-OSE kmod-VirtualBox-OSE

How to install Google Chrome Beta in Fedora 11 and Fedora 12 via yum

Configure Google rpm repository

Google's Linux packages are signed with a GNU Privacy Guard (GPG) key. You must install the public package signing key on your system to prevent warnings or errors when installing packages from the Google Linux software repositories. Download the key and then use rpm to install it.

How to fix Nautilus in Fedora 11 to open new folder in the same window (Single Window mode).

The Nautilus file manager in Fedora is configured in "Spatial Mode" by default. Everytime you open a folder, it will open in seperate window.

To disable this feature, open System->Preferences->File Management
Check the box that marked “Always open in browser windows.”

File Management behavior

How to install Compiz Fusion in Fedora 11

This guide assumes that you have video card that supports 3d acceleration installed in your system.
To install compiz fusion, open up your terminal and type this command:

yum install ccsm compiz-manager compiz-fusion-extras compiz-fusion-extras-gnome fusion-icon-gtk compizconfig-backend-gconf

Then go to System->Preferences->Startup Applications.

Startup Applications

How to install NVIDIA proprietary graphics driver in Fedora 11 using yum

Why install this driver?

Your NVIDIA video card will work on your Fedora box without this driver, however if you want to enable the 3D acceleration (if you want to use Compiz Fsuion) you need to install it.

Which driver to use?

The latest nvidia driver: This is a proprietary driver that works with newer nvidia cards.
The legacy nvidia driver: This is also a proprietary driver, but it works with older nvidia cards.
Current list of Legacy NVIDIA drivers:

  • Legacy version (173.xx series)
  • Legacy version (96.xx series)
  • Legacy version (71.xx series) Note: This driver is not available in RPM Fusion repository.

More from this website.
You need to identify which nvidia driver is ideal for your video card. Open up your terminal and type this command:

How to make wma, wmv, mp3, mpeg, mp4, dvd, mov, real audio and video playble in Fedora 11 using Totem with xine backend.

Totem is the default multimedia player for Fedora 11. It uses gstreamer backend by default, but also works with xine backend. Witht the xine library in use, totem can play all media formats with the exception of encrypted/drm’d media and blu-ray/hd-dvd.

This tutorial will show you how to force totem to use xine as a default backend.

To install xine backend, the the command below as root:

yum install xine-lib xine-lib-extras xine-lib-extras-freeworld xine-plugin totem-xine

How to install latest Flash Player plugin for Firefox on Fedora 11

Adobe flash player is available via yum. To download flash player, enable adobe yum repo using this command:

rpm -Uvh http://linuxdownload.adobe.com/adobe-release/adobe-release-i386-1.0-1.noarch.rpm

After enabling the repo, install the flash player plugin. Type this command:

yum install flash-plugin

Flash player is now installed in your system, just restart your firefox if is currently running and you can now watch flash content in your browser.

Syndicate content