Abstract
After reading this chapter you should be able to:
-
use a MySQL command to create a database table
-
understand the various data types available in MySQL
-
construct an appropriate column definition for each field in a table
-
copy the structure and/or the contents of one table to another
-
find the structure of a table
change the structure, name and field specification of a table.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsAuthor information
Authors and Affiliations
Rights and permissions
Copyright information
© 2015 Springer International Publishing Switzerland
About this chapter
Cite this chapter
Bramer, M. (2015). Creating and Updating MySQL Tables. In: Web Programming with PHP and MySQL. Springer, Cham. https://doi.org/10.1007/978-3-319-22659-0_14
Download citation
DOI: https://doi.org/10.1007/978-3-319-22659-0_14
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-22658-3
Online ISBN: 978-3-319-22659-0
eBook Packages: Computer ScienceComputer Science (R0)