…As you're defining your table you may want to…define specific rules and behaviors for some of your columns.…This is done by using constraints.…I'm going to use the Scratch database for this lesson.…And I'm going to copy and paste some code here…out of the Chapter 3 exercise file, here around line 73.…Everything from drop table to select from test.…Press Cmd+C to copy, and Cmd+V to paste.…That's Ctrl+C and Ctrl+V, if you're using a PC.…
And you see, we start here with a drop table.…Because, again, we're going to be creating this…table over and over again with different options.…So we need a drop table at the start of that.…And, then we have the create table, which is two columns, an integer, and a varchar.…And, we'll insert a row into it, describe it and select from it.…And so that looks like this.…There's our table and there's our one row.…In this example you'll notice that the A column has…a null value because no data was added to that column.…
If you look here at our insert.…We're only inserting data into row B.…
Author
Released
5/14/2014- Writing queries
- Creating and updating databases and tables
- Using MySQL built-in functions
- Sorting and filtering data
- Updating tables with triggers
- Working with subselects and views
- Creating and using a stored function
Skill Level Beginner
Duration
Views
Related Courses
-
Learning MySQL Development (2014)
with Sheeri Cabral2h 57m Beginner
-
Introduction
-
Welcome1m
-
Using the exercise files1m 31s
-
What is MySQL?1m 48s
-
-
1. Installing and Configuring the Test Environment
-
Installation overview3m 16s
-
Installing XAMPP on Windows5m 55s
-
Installing XAMPP on the Mac6m 38s
-
Setting up MySQL users11m 31s
-
Installing SID on Windows5m 43s
-
-
2. Basic Syntax
-
The SELECT statement3m 57s
-
Selecting rows4m 57s
-
Selecting columns3m 8s
-
Filtering results with WHERE3m 52s
-
Inserting rows4m 9s
-
Updating rows2m 21s
-
Deleting rows2m 25s
-
Literal strings3m 11s
-
Understanding NULL2m 42s
-
-
3. Creating a Database
-
Creating a database4m 30s
-
Creating a table7m 18s
-
Creating indexes6m 8s
-
Creating an ID column6m 58s
-
Altering a table4m 9s
-
-
4. MySQL Data Types
-
What are data types?4m 1s
-
Numeric types5m 20s
-
String types2m 58s
-
Date and time types7m 2s
-
Bit type2m 26s
-
Boolean values2m 15s
-
Enumeration types4m 53s
-
-
5. MySQL Functions
-
String functions6m 57s
-
Numeric functions6m 2s
-
Date and time functions4m 12s
-
Time zones in MySQL3m 37s
-
Formatting dates1m 51s
-
Aggregate functions5m 45s
-
Flow control with CASE4m 9s
-
-
6. Transactions
-
7. Triggers
-
8. Subselects and Views
-
Creating a simple subselect3m 22s
-
Creating a view3m 32s
-
Creating a joined view3m 23s
-
-
9. Stored Routines
-
Creating a stored function4m 34s
-
Creating a stored procedure5m 52s
-
10. PHP's PDO Interface with MySQL
-
Executing the SQL4m 8s
-
Using a stored funciton4m 9s
-
Conclusion
-
Goodbye1m 3s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Controlling column behavior with constraints