MySQL Basics by Eduonix Learning Solutions

About the Lecture

The lecture MySQL Basics by Eduonix Learning Solutions is from the course Learn MySQL (EN). It contains the following chapters:

  • What is MySQL?
  • MySQL Queries
  • Connecting to a Database
  • Select data
  • PDO

Author of lecture MySQL Basics

 Eduonix Learning Solutions

Eduonix Learning Solutions


Customer reviews

(1)
5,0 of 5 stars
5 Stars
5
4 Stars
0
3 Stars
0
2 Stars
0
1  Star
0


Excerpts from the accompanying material

... SQL - Structured Query Language. Provides multi-user access to multiple databases. LAMP - Linux/Apache/MySQL/PHP. Ships with ...

... FROM employees. INSERT INTO employees (first_name, last_name, department) VALUES (‘Kevin’, ‘Jones’, ‘IT’); UPDATE employees ...

... and using a MySQL database in PHP is not best practice. It is recommended that you use ...

... $result = mysqli_query($connect,"SELECT * FROM employees"); while($row = mysqli_fetch_array($result)){ echo $row[‘first_name'] ...

... if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . ...

... = new PDO ('mysql:host=localhost;dbname=myDatabase',’Peter123’,’mypassword’); $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $stmt = $conn->prepare('SELECT * FROM employees WHERE id = :id'); $stmt->execute(array('id' => $id)); while($row = ...

Chapters of this lecture