clear markdown compare help best fiddles feedback dbanow.uk
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2555381 fiddles created (37439 in the last week).

CREATE TABLE clients ( id_client INT PRIMARY KEY AUTO_INCREMENT NOT NULL, surname TEXT, name TEXT, patronimic TEXT, phone_number TEXT )
 hidden batch(es)


INSERT INTO clients ( surname, name, patronimic, phone_number ) VALUES ( 'Bidlocoder', 'Vasyan', 'Makakinovich', '88005553535' )
 hidden batch(es)


SELECT LAST_INSERT_ID()
LAST_INSERT_ID()
1
 hidden batch(es)


SELECT id_client FROM clients WHERE phone_number = '88005553535'
id_client
1
 hidden batch(es)