MySQL Cookbook > Modifying Tables with ALTER TABLE > Dropping, Adding, or Repositioning a Column

Table of Contents

Download Safari Books Online apps: Apple iOS | Android

Entire Site

Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

This Book

MySQL Cookbook

Search

Preface

Ch. 1. Using the mysql Client Program

Ch. 2. Writing MySQL-Based Programs

Ch. 3. Record Selection Techniques

Ch. 4. Working with Strings

Ch. 5. Working with Dates and Times

Ch. 6. Sorting Query Results

Ch. 7. Generating Summaries

Ch. 8. Modifying Tables with ALTER TABLE

Introduction

Dropping, Adding, or Repositioning a Column

Changing a Column Definition or Name

The Effect of ALTER TABLE on Null and Default Value Attributes

Changing a Column's Default Value

Changing a Table Type

Renaming a Table

Adding or Dropping Indexes

Eliminating Duplicates by Adding an Index

Using ALTER TABLE to Normalize a Table

Ch. 9. Obtaining and Using Metadata

Ch. 10. Importing and Exporting Data

Ch. 11. Generating and Using Sequences

Ch. 12. Using Multiple Tables

Ch. 13. Statistical Techniques

Ch. 14. Handling Duplicates

Ch. 15. Performing Transactions

Ch. 16. Introduction to MySQL on the Web

Ch. 17. Incorporating Query Resultsinto Web Pages

Ch. 18. Processing Web Input with MySQL

Ch. 19. Using MySQL-Based Web Session Management

Appx. A. Obtaining MySQL Software

Appx. B. JSP and Tomcat Primer

Appx. C. References

Colophon

Index

8.2. Dropping, Adding, or Repositioning a Column

8.2.1. Problem

You want to get rid of a table column, add a new column, or move a column around within a table.

8.2.2. Solution

Use the DROP or ADD clauses of ALTER TABLE to remove or add a column. To move a column, drop it and then put it back where you want it.

You are currently reading a PREVIEW of this book.

Get instant access to over
$1 million worth of books and videos.

Start a Free Trial