Rsa97

SELECT `id`, `date`, `name` 
    FROM `table`
    ORDER by `date`, `id`
    LIMIT 10

SELECT `id`, `name`, `date`
    FROM `table` 
    WHERE (@Date := (SELECT `date` FROM `table` WHERE `id` = :last_id))
        AND (`date` > @Date OR (`date` = @Date AND `id` > :last_id))
    ORDER BY `date`, `id`
    LIMIT 10

INSERT INTO  `food-foreign-id` (`id`, `foreign-id`)  
    SELECT  `food`.`id`, `food`.`foreign-id` FROM `food`

ALTER TABLE `comments` 
    ADD COLUMN `peoples_id` INT(255) NOT NULL AFTER `comment`,
    ADD INDEX `peoples_id_idx` (`peoples_id` ASC);

ALTER TABLE `comments` 
    ADD CONSTRAINT `comments_peoples`
        FOREIGN KEY (`peoples_id_fk`)
        REFERENCES `peoples` (`id_people`)
        ON DELETE NO ACTION
        ON UPDATE NO ACTION;

$req = $mysqli->prepare(
    "SELECT `id` FROM `content` ".
        "WHERE ('' = ? OR `lic` = ?) ".
            "AND ('' = ? OR `selection` = ?) ".
            "AND ('' = ? OR `type` = ?)"
);
$req->bind_param('ssssss', $lic, $lic, $selection, $selection, $type, $type);

UPDATE `table` SET `str` = REPLACE(`str`, '  ', ' ') WHERE `str` LIKE '%  %'