From the course: Ethical Hacking: SQL Injection
Join today to access over 25,300 courses taught by industry experts.
Creating a MySQL database
From the course: Ethical Hacking: SQL Injection
Creating a MySQL database
- Let's now log into my SQL as our new user Marcus and create a database to use for this course. My SQL minus you Marcus minus P and then to our password which is also Marcus. And we're now in my SQL as the user Marcus. We'll create a new database. Create database called cleo. And then we'll make it our current database. Use Cleo and we'll list the tables. Show tables. And we see it's an empty set because we haven't created any tables in this database yet. Let's build the tables next. We want our database to consist of three tables. One containing the basic details of Egyptian Pharaohs. The second of the dynastic seat of power during the Pharaohs reign and the third the tomb where the Pharaoh was found. So let's create table Pharaoh and we'll put in columns, Pharaoh ID, which is an INT, name, which is a VARcharacter, variable character of length 32, reign start, which is an INT, reign, end which is an…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.