OOP to Laravel# 07 SQL, Create Database and table, Data type, Select, Where, Order by, Limit

Описание: OOP to Laravel# 07 SQL, Create Database and table, Data type, Select, Where, Order by, Limit



Object Oriented PHP
OOP
PHP OOP
OOP PHP Bangla Tutorial
PHP OOP বাংলা টিউটোরিয়াল
OOP
PHP Object Oriented Progrmming
PHP Bangla Tutorial
SQL, Database Management System, DBMS
Laravel
Laravel Tutorial
Laravel Tips
Laravel Bangla Tutorial
Laravel Tutorial in bangla
Laravel in bangla
লারাভেল বাংলা টিউটোরিয়াল
Laravel বাংলা টিউটোরিয়াল
বাংলা টিউটোরিয়াল

Visit my website for more free tutorials:
https://www.artofcse.com/

Source Code Link:
https://www.artofcse.com/video/sql-cr...

Follow Me:
  / almamun.csit  
  / artofcse  
  / almamuncsit  
  / almamuncsit  






SELECT:
========================================
SELECT * FROM students;

SELECT id, name, age FROM students;

SELECT DISTINCT age FROM students;

SELECT * FROM students
WHERE id = 1;

SELECT * FROM students
WHERE name = 'Tamim';

SELECT * FROM students
WHERE id NOT 1;

SELECT * FROM students
WHERE gpa IS NULL;

SELECT * FROM students
WHERE gpa IS NOT NULL;

SELECT * FROM students
WHERE id BETWEEN 2 and 3;

SELECT * FROM students
WHERE id IN (1, 4, 5);

SELECT * FROM students
WHERE name LIKE 'Ra%';

SELECT * FROM students
WHERE name LIKE '%im';

SELECT * FROM students
WHERE name LIKE '%mi%';

SELECT * FROM students
WHERE age = 21 AND id = 3;

SELECT * FROM students
WHERE age = 12 OR id = 3;

SELECT * FROM students
ORDER BY age;

SELECT * FROM students
ORDER BY age ASC;

SELECT * FROM students
ORDER BY age DESC;

SELECT * FROM students
LIMIT 0, 2;

SELECT * FROM students
LIMIT 2, 2;