CREATE TABLE chatusers( id BIGINT, username VARCHAR(20), lastname VARCHAR(30),…
- User
CREATE TABLE chat_users( id BIGINT, username VARCHAR(20), last_name VARCHAR(30), second_name VARCHAR(30), mood DECIMAL(1,10), data_create_account DATE, timestamp_last_auth TIMESTAMP, age SMALLINT, country_name VARCHAR, birthday DATE ); Напиши 15 INSERT запроса
- Assistant
Конечно! Вот пример с 15 запросами для вставки данных в таблицу
chat_users:INSERT INTO chat_users (id, username, last_name, second_name, mood, data_create_account, timestamp_last_auth, age, country_name, birthday) VALUES (1, 'johndoe', 'Doe', 'John', 0.1234567890, '2022-01-15', '2023-10-05 12:34:56', 28, 'USA', '1995-06-24'); INSERT INTO chat_users (id, username, last_name, second_name, mood, data_create_account, timestamp_last_auth, age, country_name, birthday) VALUES (2, 'janesmith', 'Smith', 'Jane', 0.9876543210, '2021-05-20', '2023-09-15 08:20:30', 32, 'Canada', '1991-02-14'); INSERT INTO chat_users (id, username, last_name, second_name, mood, data_create_account, timestamp_last_auth, age, country_name, birthday) VALUES (3, 'alexbrown', 'Brown', 'Alex', 0.5555555555, '2023-03-12', '2023-10-01 17:11:22', 25, 'UK', '1998-11-05'); INSERT INTO chat_users (id, username, last_name, second_name, mood, data_create_account, timestamp_last_auth, age, country_name, birthday) VALUES (4, 'chriswhite', 'White', 'Chris', 0.7689423456, '2022-07-09', '2023-07-14 06:45:00', 29, 'Australia', '1994-09-22'); INSERT INTO chat_users (id, username, last_name, second_name, mood, data_create_account, timestamp_last_auth, age, country_name, birthday) VALUES (5, 'lisagreen', 'Green', 'Lisa', 0.3647391284, '2020-11-23', '2023-06-30 15:11:10', 34, 'Germany', '1989-03-19'); INSERT INTO chat_users (id, username, last_name, second_name, mood, data_create_account, timestamp_last_auth, age, country_name, birthday) VALUES (6, 'mikejohnson', 'Johnson', 'Mike', 0.4829571256, '2021-02-01', '2023-05-25 09:29:40', 40, 'France', '1983-12-08'); INSERT INTO chat_users (id, username, last_name, second_name, mood, data_create_account, timestamp_last_auth, age, country_name, birthday) VALUES (7, 'karendavis', 'Davis', 'Karen', 0.6423517894, '2019-06-18', '2023-10-03 17:10:59', 27, 'Spain', '1996-08-01'); INSERT INTO chat_users (id, username, last_name, second_name, mood, data_create_account, timestamp_last_auth, age, country_name, birthday) VALUES (8, 'danielmartin', 'Martin', 'Daniel', 0.9812374850, '2022-09-13', '2023-01-15 20:23:45', 22, 'Italy', '2001-04-27'); INSERT INTO chat_users (id, username, last_name, second_name, mood, data_create_account, timestamp_last_auth, age, country_name, birthday) VALUES (9, 'sarawilson', 'Wilson', 'Sara', 0.4598712365, '2023-08-05', '2023-10-02 11:43:21', 19, 'Brazil', '2004-12-30'); INSERT INTO chat_users (id, username, last_name, second_name, mood, data_create_account, timestamp_last_auth, age, country_name, birthday) VALUES (10, 'georgeharris', 'Harris', 'George', 0.2374619852, '2021-12-14', '2023-08-12 13:36:57', 41, 'India', '1982-06-10'); INSERT INTO chat_users (id, username, last_name, second_name, mood, data_create_account, timestamp_last_auth, age, country_name, birthday) VALUES (11, 'emilyyang', 'Yang', 'Emily', 0.3284596127, '2020-04-27', '2023-09-21 02:10:00', 30, 'South Korea', '1993-09-15'); INSERT INTO chat_users (id, username, last_name, second_name, mood, data_create_account, timestamp_last_auth, age, country_name, birthday) VALUES (12, 'jameslee', 'Lee', 'James', 0.7498234506, '2021-11-11', '2023-07-02 08:11:22', 37, 'China', '1986-11-20'); INSERT INTO chat_users (id, username, last_name, second_name, mood, data_create_account, timestamp_last_auth, age, country_name, birthday) VALUES (13, 'patriciaroberts', 'Roberts', 'Patricia', 0.5892374812, '2023-02-09', '2023-09-18 21:55:31', 23, 'Japan', '2000-05-25'); INSERT INTO chat_users (id, username, last_name, second_name, mood, data_create_account, timestamp_last_auth, age, country_name, birthday) VALUES (14, 'brianthomas', 'Thomas', 'Brian', 0.4123657984, '2018-10-31', '2023-08-20 15:16:17', 29, 'Russia', '1994-10-03'); INSERT INTO chat_users (id, username, last_name, second_name, mood, data_create_account, timestamp_last_auth, age, country_name, birthday) VALUES (15, 'annawalker', 'Walker', 'Anna', 0.2763849157, '2019-05-14', '2023-07-31 07:03:43', 35, 'Netherlands', '1988-01-22');Обратите внимание, что значения в столбцах, таких как
id,username,mood,data_create_account,timestamp_last_auth,age, иbirthday, были сделаны в виде примера, и вы можете изменить их в соответствии с вашими требованиями. - User
ПЕрепиши так чтобы было не палевно по именам. Сделай их рандомными словами и все остальные тоже строки как можно более рандомными буквами
- Assistant
Конечно! Вставлю случайные строки в качестве значений:
INSERT INTO chat_users (id, username, last_name, second_name, mood, data_create_account, timestamp_last_auth, age, country_name, birthday) VALUES (1, 'zxqwelmn', 'Kldyal', 'Fyonps', 0.1234567890, '2022-01-15', '2023-10-05 12:34:56', 28, 'Qrmstia', '1995-06-24'); INSERT INTO chat_users (id, username, last_name, second_name, mood, data_create_account, timestamp_last_auth, age, country_name, birthday) VALUES (2, 'knqwirza', 'Typsqi', 'Mvwroy', 0.9876543210, '2021-05-20', '2023-09-15 08:20:30', 32, 'Lolmfek', '1991-02-14'); INSERT INTO chat_users (id, username, last_name, second_name, mood, data_create_account, timestamp_last_auth, age, country_name, birthday) VALUES (3, 'uqplonmc', 'Eyrnaw', 'Ilsbrt', 0.5555555555, '2023-03-12', '2023-10-01 17:11:22', 25, 'Qpekln', '1998-11-05'); INSERT INTO chat_users (id, username, last_name, second_name, mood, data_create_account, timestamp_last_auth, age, country_name, birthday) VALUES (4, 'cjaklrie', 'Bvpaer', 'Rlwnek', 0.7689423456, '2022-07-09', '2023-07-14 06:45:00', 29, 'Plexmn', '1994-09-22'); INSERT INTO chat_users (id, username, last_name, second_name, mood, data_create_account, timestamp_last_auth, age, country_name, birthday) VALUES (5, 'ubomejxk', 'Zhurtw', 'Ytxnei', 0.3647391284, '2020-11-23', '2023-06-30 15:11:10', 34, 'Afvujem', '1989-03-19'); INSERT INTO chat_users (id, username, last_name, second_name, mood, data_create_account, timestamp_last_auth, age, country_name, birthday) VALUES (6, 'bfvszanp', 'Qyetns', 'Watdko', 0.4829571256, '2021-02-01', '2023-05-25 09:29:40', 40, 'Plfmncd', '1983-12-08'); INSERT INTO chat_users (id, username, last_name, second_name, mood, data_create_account, timestamp_last_auth, age, country_name, birthday) VALUES (7, 'aoklvwqe', 'Cytqwe', 'Dqlpvi', 0.6423517894, '2019-06-18', '2023-10-03 17:10:59', 27, 'Dlbvk', '1996-08-01'); INSERT INTO chat_users (id, username, last_name, second_name, mood, data_create_account, timestamp_last_auth, age, country_name, birthday) VALUES (8, 'iqpamdfw', 'Rbmwak', 'Nxtwyz', 0.9812374850, '2022-09-13', '2023-01-15 20:23:45', 22, 'Yzrtkm', '2001-04-27'); INSERT INTO chat_users (id, username, last_name, second_name, mood, data_create_account, timestamp_last_auth, age, country_name, birthday) VALUES (9, 'pqeuvnkl', 'Fxgmpv', 'Vupqjl', 0.4598712365, '2023-08-05', '2023-10-02 11:43:21', 19, 'Rmbvte', '2004-12-30'); INSERT INTO chat_users (id, username, last_name, second_name, mood, data_create_account, timestamp_last_auth, age, country_name, birthday) VALUES (10, 'wlpweoiq', 'Nxkrqn', 'Iotwxe', 0.2374619852, '2021-12-14', '2023-08-12 13:36:57', 41, 'Bkplt', '1982-06-10'); INSERT INTO chat_users (id, username, last_name, second_name, mood, data_create_account, timestamp_last_auth, age, country_name, birthday) VALUES (11, 'carebfjq', 'Tempoq', 'Yxvnel', 0.3284596127, '2020-04-27', '2023-09-21 02:10:00', 30, 'Rkrezmv', '1993-09-15'); INSERT INTO chat_users (id, username, last_name, second_name, mood, data_create_account, timestamp_last_auth, age, country_name, birthday) VALUES (12, 'lasdhfrp', 'Tuthlm', 'Qbrwol', 0.7498234506, '2021-11-11', '2023-07-02 08:11:22', 37, 'Xmvznym', '1986-11-20'); INSERT INTO chat_users (id, username, last_name, second_name, mood, data_create_account, timestamp_last_auth, age, country_name, birthday) VALUES (13, 'asohimvw', 'Ugrspo', 'Bqlenu', 0.5892374812, '2023-02-09', '2023-09-18 21:55:31', 23, 'Wtixdlb', '2000-05-25'); INSERT INTO chat_users (id, username, last_name, second_name, mood, data_create_account, timestamp_last_auth, age, country_name, birthday) VALUES (14, 'bucnewqo', 'Lpwoqj', 'Mpxlka', 0.4123657984, '2018-10-31', '2023-08-20 15:16:17', 29, 'Vwejkz', '1994-10-03'); INSERT INTO chat_users (id, username, last_name, second_name, mood, data_create_account, timestamp_last_auth, age, country_name, birthday) VALUES (15, 'bdlqwzem', 'Omfwel', 'Zpwkfj', 0.2763849157, '2019-05-14', '2023-07-31 07:03:43', 35, 'Lxzokm', '1988-01-22');Эти данные включают случайные последовательности букв в полях, таких как
username,last_name,second_name, иcountry_name, для создания более случайного и непалевного вида записей.