MySQL Startup Guide

@@ -108,11 +111,11 @@ so as to keep this document as consistent as possible) * For security reasons you should set your MySQL root - * password as soon as possible. + * password as soon as possible.

# /etc/init.d/mysql start * Re-caching dependency info (mtimes differ)... - * Starting mysqld (/etc/mysql/my.cnf) ... [ ok ] + * Starting mysqld (/etc/mysql/my.cnf) ... [ ok ] (Replace new-password with your desired password) # /usr/bin/mysqladmin -u root -h localhost password 'new-password'

@@ -244,15 +247,15 @@ Working With Tables In MySQL

-Creating A Table +Creating a Table

In the structure of MySQL, there are databases, tables, records, and fields. Databases hold together tables, tables hold together records, records hold together fields, which contain the actual information. This structure lets -users select how they want to access their information. So far we've dealt -with databases, now let's work with tables. First off, tables can be listed +users select how they want to access their information. So far we've dealt with +databases, now let's work with tables. First off, tables can be listed similiarly to databases using the SHOW TABLES command. Right now there are no tables in our gentoo database, as running the command will show us:

@@ -265,8 +268,8 @@

This means we need to create some tables. In order to do so, we use the CREATE TABLE command. However, this command is quite different from -simple CREATE DATABASE command. This command takes a list of arguments -you must give it. The form is as follows: +simple CREATE DATABASE command. This command takes a list of arguments. +The form is as follows:

@@ -278,17 +281,17 @@
 let's make a table named developers. This table will contain the
 developer's name, email and job. field_name will contain the name of the
 field. We have 3 required names in this case: name, email, and job. The
-field_data_type is what type of information will be stored. The different
-formats avaliable can be found at the field_data_type is what type of information will be stored. The
+different formats available can be found at the MySQL Column Types
 Page. For our purposes, we'll use the VARCHAR data type for all of
-our fields. VARCHAR is one of the simplest of data types when it comes to
-working with strings. size is how much of data a single field will store
-of type field_data_type. In this case, we'll use 128 for our size. This
-means that the field can have VARCHAR data that is 128 bits. You can
-safely think of this as 128 characters for the time being, though there is a
-somewhat more technical explanation that the above site will provide you with.
-Now that we know how we are going to create the table, let's do it.
+our fields. VARCHAR is one of the simplest of data types when it comes
+to working with strings. size is how much of data a single field will
+store. In this case, we'll use 128. This means that the field can have
+VARCHAR data that is 128 bytes. You can safely think of this as 128
+characters for the time being, though there is a somewhat more technical
+explanation that the above site will provide you with. Now that we know how we
+are going to create the table, let's do it.
 
 
 @@ -297,8 +300,8 @@
 
 
 
-Looks like our table was created ok. Let's check it with the SHOW
-TABLES command:
+Looks like our table was created ok. Let's check it with the SHOW TABLES
+command:
 
 
 @@ -312,10 +315,10 @@
 
 
 
-Yes, there's our table. However, it doesn't seem to have any information on



-- 
gentoo-doc-cvs@gentoo.org mailing list