Category: mySQL

Posted on: 17.08.2020 Posted by: Alex D Comments: 0

How to split data into multiple pages and then combine them

What to do when the table in the database is large? How to optimize the storage of information on different tables? How to automatically create new tables in php. And how to combine several tables of the same type, identical in structure, with the same columns into one temporary, virtual table in the PHP programming language.

Posted on: 12.08.2020 Posted by: Alex D Comments: 0

SQL join table JOIN operator.

Step by step. We make a simple connection of the users and comments tables. Let’s set the selection condition for a specific user. And sort the comments by descending date.

↓ Teasers Spage.me DEMO ↓