Convert Microsoft to LINUX: Intro to MySQL

This is an example of using MySQL. Using the built in Control Panel on my Linux host with the PHP Admin utility, I created a simple Database containing an abbreviated list of Linux Distros with a little info about each. The database consisted of an info text field of 400 characters and a Linux_name field of 30 characters, which functioned as the primary key. This excellent   MySQL Tutorial   was used to write the php code.

For a list of all the commands in mysql please go to my commands page.

Abbreviated List of Linux Distros (Distributions)

Here are all the Distros in our Database

AntiX Linux   Website:  http://antix.mepis.org

Minimalist disto that go in old DOS belive it or not or Fat32. Put it on top of your windows, that is replacing Windoze so you will not get those nasty trojans and viruses. It is another nice minimalist light Xfce desktop. As you can tell, I love the light Xfce desktops!



Ark Linux   Website:  http://www.arklinux.org

The Ark Linux distribution is based on Red Hat Linux and geared toward the newcomer to Linux. The developers claim it can be installed in 4 mouse clicks. This was verified by me.



Bodhi Linux   Website:  http://www.bodhilinux.com

Nice light desktop minimalist distro with pretty themes.



CentOS   Website:  http://www.centos.org

Community supported distribution which aims to be 100% compatible with Red Hat Enterprise Linux without Red Hat branding and various non-free software



CrunchBang   Website:  http://www.crunchbang.org

Another really light Debian desktop from New Jersey, USA.



Damn Small Linux (DSL)   Website:  http://www.damnsmalllinux.org

Grandfather of mini distributions. A live CD designed for MiniCD with a hard drive install option. Started as a personal project to see how many usable desktop applications could fit inside a business card size 50MB MiniCD. Over time it has grown into a considerably active community project.



Debian   Website:  http://www.debian.org/

A distribution assembled by a large community of volunteers. Debian has a large selection of packages (over 15000) and supports a large number of hardware platforms.



EasYs GNU/Linux   Website:  http://gnulinux.de/pocketlinux/

Created by Marcus Moeller of Germany, this used to be called Pocket Linux. It is Debian based and uses only one CD. EasYs GNU/Linux 2.1 is based on Slackware 10.2



Feather   Website:  http://featherlinux.berlios.de

Sharing similar goals as Damn Small Linux, but not based on it (Feather is more closely related to Knoppix). Includes more software packages than DSL raising the "small" limit to about 115MB. Uses Knoppix-based hardware detection and the Fluxbox window manager. Compatible with Debian packages (.deb)



Fedora Core   Website:  http://fedora.redhat.com/

A general purpose distribution for workstation, desktop and server use. Developed by Red Hat and the community.



Gentoo   Website:  http://www.gentoo.org

A distribution intended for enthusiasts and professionals with its own package management system called Portage. Gentoo focuses on the compilation of source code rather than the distribution of binary packages, which is expected to make applications to run faster.



Knoppix   Website:  http://www.knoppix.de

The first Live CD (later DVD) version of Debian GNU/Linux. Usable after booting from the CD image and comes with a large amount of software. Also has real nice security tools.



Linspire   Website:  http://www.linspire.com

Another desktop-oriented distribution, previously called Lindows, based on Debian. Additional software is available from Linspire or via Debian's apt command, although compatibility with Debian is not guaranteed. Has significant proprietary software.



Linux Mint   Website:  http://linuxmint.com

This is one of the most popular Debian based distros. You will love it.



Mandriva   Website:  http://www.mandriva.com

Formerly known as Mandrakelinux. There are various products for servers, workstations, small businesses as well as individuals. Originally a Red Hat Linux variant optimized for Pentium-class CPUs, Mandriva Linux has since diverged to form its own distribution.



Pear Linux   Website:  http://pearlinux.fr/Download

A great MAC lookalike, so good they had to manufacture it in France so they can not go to jail. Maccies go crazy over this! Now available in 32 & 64 bit
You will love this!



Pocketlinux   Website:  http://www.pocket-lnx.org/

A Slackware-based distribution developed by former developers of the now-discontinued Bonzai Linux. Includes a simplified Slackware installer & KDE Light desktop.



Puppy Linux   Website:  http://www.puppylinux.org

Another really minimalist 159 Meg distro disk with a really light desktop comes in the Slacker and Debian variety. Also very easily multilinugal. Has a built in item to kill anything that is running with a drop down right click.



Red Hat Enterprise Linux   Website:  http://www.redhat.com

The solely-commercial distribution for server market. The inventor of the RPM-packaging system.



Skolelinux   Website:  http://developer.skolelinux.no/index.html.en

A distribution started in Norway as an affordable thin client distribution for schools (cf. EduLinux, Guadalinex).



Slackware   Website:  http://www.slackware.com/

The oldest Linux distribution still maintained. Slackware packages are tar/gziped files with the extension .tgz.



Solaris UNIX from Sun   Website:  http://www.sun.com/

This is actually a UNIX distribution but is one of the oldest open source ones. It is worth taking a look at. See my solaris link for more details on my initial web page.



Suse   Website:  http://www.suse.com/

A desktop-oriented Linux distribution supplied by Novell, Inc. In 2004 Novell acquired SUSE which is based in Nürnberg (Nuremberg), Germany. SUSE is one of the most popular distributions in Europe.



Turbolinux   Website:  http://www.turbolinux.com

A popular distribution in Asia, based on Red Hat Linux.



Ubuntu (Kubuntu, Xubuntu, Edubuntu)   Website:  http://www.ubuntu.com

A distribution sponsored by Canonical Ltd as well as receiving major funding from South African Mark Shuttleworth. Uses its own package repositories seeded from snapshots of Debian. Aims to offer a complete and polished desktop. Very popular with the under 30's. Note, the Ubuntu is a Gnome desktop and the Kubuntu is a KDE desktop. Xubuntu is lightweight made for older PC's. Edubuntu is for schools.



Xandros   Website:  http://www.xandros.com

Canadian based Xandros (based on the defunct Corel Linux) focuses on the desktop market and Windows compatibility. The Xandros distribution, unlike most others, may not be freely copied, as it contains proprietary software. Xandros is compatible with Debian's dpkg package management system.



Yellow Dog   Website:  http://www.yellowdoglinux.com

A Linux Distro that works on the MAC.



Zenwalk   Website:  http://zenwalk.org

Zenwalk is a GNU/Linux operating system, designed to provide the following characteristics: # Modern and user-friendly (latest stable software, selected applications) # Fast (optimized for performance capabilities) # Rational (one mainstream application for each task) # Complete (full development/desktop/multimedia environment) # Evolutionary (simple network package management tool - netpkg)