A MySQL database is made up of one or more tables. These tables contain rows and columns, which in turn contain data. The columns hold the headers of the table that identify the data in the rows ...

You can set where auto-increment starts. I believe it works in MySQL 4.1; I don't see why it wouldn't (but I hope you have a really good reason for sticking to 4.1).<BR><BR>ALTER TABLE tablename ...

mysql> use mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A. Database changed mysql> select host,user from user; ...

Click Create table, and in the resulting window (Figure D), give the table a name, select the engine and character set, and then add columns. Figure D If you attempt to create the table without ...

A combination of database columns and rows is knowns as a table. Each database table row has the same set of data fields. For example, ... Choosing between rows and columns. Traditional databases, ...