MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE `users_apikey` (
  `id` int NOT NULL,
  `username` text NOT NULL,
  `namekey` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `uapikey` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

INSERT INTO `users_apikey` (`id`, `username`, `namekey`, `uapikey`) VALUES
(1, '', '', 'awddwadwa'),
(2, '', 'wdawd', '6436'),
(3, '', 'awdawd', '8858'),
(4, '', 'awd', '1e5ae2-0dca18-cc55df-d784b7-1a9273'),
(5, '', 'awd', 'a7a72f-7e533a-bd8663-e3c699-8ab2bd'),
(6, '', 'awd', '1f839f-aa1be5-ef507f-0b3261-66e2a3'),
(7, '', 'wda', '26ec30-3b4276-b8afbd-fce38c-b5100e'),
(8, '', 'awd', 'afb124-de81b8-600ccc-ea517e-b3ba16');

CREATE TABLE `users` (
  `id` int NOT NULL,
  `date_signup` datetime NOT NULL,
  `username` text NOT NULL,
  `password` text NOT NULL,
  `logintg` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TRIGGER tr_assign_apikey_to_user
AFTER INSERT 
ON users
FOR EACH ROW
UPDATE users_apikey SET username = NEW.username WHERE username = '' LIMIT 1;
SELECT * FROM users;
SELECT * FROM users_apikey;


id
username
namekey
uapikey


1


awddwadwa

2

wdawd
6436

3

awdawd
8858

4

awd
1e5ae2-0dca18-cc55df-d784b7-1a9273

5

awd
a7a72f-7e533a-bd8663-e3c699-8ab2bd

6

awd
1f839f-aa1be5-ef507f-0b3261-66e2a3

7

wda
26ec30-3b4276-b8afbd-fce38c-b5100e

8

awd
afb124-de81b8-600ccc-ea517e-b3ba16


INSERT INTO `users` (`id`, `date_signup`, `username`, `password`, `logintg`) VALUES
(81, '2022-05-06 19:47:26', 'test', '$2y$10$0KR8hapy5IscIZBN97fTbeYwS6NqxM4Fv5FJ2acF.lnTGUL49kdbi', '123');
SELECT * FROM users;
SELECT * FROM users_apikey;


id
date_signup
username
password
logintg


81
2022-05-06 19:47:26
test
$2y$10$0KR8hapy5IscIZBN97fTbeYwS6NqxM4Fv5FJ2acF.lnTGUL49kdbi
123




id
username
namekey
uapikey


1
test

awddwadwa

2

wdawd
6436

3

awdawd
8858

4

awd
1e5ae2-0dca18-cc55df-d784b7-1a9273

5

awd
a7a72f-7e533a-bd8663-e3c699-8ab2bd

6

awd
1f839f-aa1be5-ef507f-0b3261-66e2a3

7

wda
26ec30-3b4276-b8afbd-fce38c-b5100e

8

awd
afb124-de81b8-600ccc-ea517e-b3ba16

id	namekey	uapikey
1		awddwadwa
2	wdawd	6436
3	awdawd	8858
4	awd	1e5ae2-0dca18-cc55df-d784b7-1a9273
5	awd	a7a72f-7e533a-bd8663-e3c699-8ab2bd
6	awd	1f839f-aa1be5-ef507f-0b3261-66e2a3
7	wda	26ec30-3b4276-b8afbd-fce38c-b5100e
8	awd	afb124-de81b8-600ccc-ea517e-b3ba16

id	username	namekey	uapikey
1	test		awddwadwa
2		wdawd	6436
3		awdawd	8858
4		awd	1e5ae2-0dca18-cc55df-d784b7-1a9273
5		awd	a7a72f-7e533a-bd8663-e3c699-8ab2bd
6		awd	1f839f-aa1be5-ef507f-0b3261-66e2a3
7		wda	26ec30-3b4276-b8afbd-fce38c-b5100e
8		awd	afb124-de81b8-600ccc-ea517e-b3ba16