DELIMITER //
CREATE PROCEDURE X()
BEGIN
DECLARE i INT DEFAULT 0;
WHILE i < 10000000 DO
INSERT INTO map (X,
Y,
STATUS)
VALUES('1','1', FLOOR((RAND() * 5)));
SET i = i + 1;
END WHILE;
END//
DELIMITER ;
BEGIN TRANSACTION;
drop table tuser;
drop table tuser_info;
CREATE TABLE tuser
(`id` int, `name` varchar(255));
INSERT INTO tuser
(`id`, `name`)
VALUES
(1, 'Vasja'),
(2, 'Petja'),
(3, 'Kolja'),
(4, 'Dima')
;
CREATE TABLE tuser_info
(`id` int, `user_id` int, `some_id` int);
INSERT INTO tuser_info
(`id`, `user_id`, `some_id`)
VALUES
(1, 1,1),
(2, 2,3),
(3, 2,1),
(5, 2,2),
(4, 3,1)
;
COMMIT;
select tu.name
from tuser tu
join tuser_info ti
on (tu.id = ti.user_id)
where ti.some_id=1
and exists (select 1 from tuser_info ti2 where ti2.some_id=2 and ti2.user_id=ti.user_id );
SET @r=0;
select id,tname,CONCAT (taliase , addid) as aliase from
(
select * from (
SELECT id,tname,taliase,@r:=@r+1 as addid
FROM FF as f1
GROUP BY f1.tname,f1.taliase
UNION
SELECT id,tname,taliase,"" as addid FROM FF as f2
GROUP BY f2.taliase
ORDER BY taliase DESC
) as t1
order by t1.id,t1.addid
) as t2
group by t2.id
CREATE TABLE FF
(`id` int, `tname` varchar(20), `taliase` varchar(20))
;
INSERT INTO FF
(`id`, `tname`, `taliase`)
VALUES
(1, 'baranka', 'hleb'),
(2, 'bulka', 'hleb'),
(3, 'pirozhok', 'hleb'),
(4, 'konfeta','sladkoe'),
(5, 'karamel','sladkoe')
;
<input type="checkbox" name="p[1]"
<input type="checkbox" name="p[2]"
<input type="checkbox" name="p[3]"
<input type="checkbox" name="p[4]"
$p=$_POST['p'];
echo $p[1] . $p[2] . $p[3] . $p[4];
<input type="checkbox" name="p[par]"
<input type="checkbox" name="p[teach]"