Programming etc

SQLite browser. Insert example.

user1272047's photo
user1272047
·

1 min read

id.241221615.874562

SQL command with the table name tab.001 and fields named field1, field2, field3, and field4:

INSERT INTO `tab.001` (field1, field2, field3, field4) VALUES
('Cartoonizer.ai', 'https://cartoonizer.ai', 'artintel', ''),
('Canva', 'https://www.canva.com/features', 'artintel', ''),
('AI Ease', 'https://www.aiease.ai/ai-filter', 'artintel', ''),
('Vidnoz AI', 'https://www.vidnoz.com/ai-cartoonizer', 'artintel', ''),
('MyEdit Online', 'https://myedit.online/photo-editor', 'artintel', ''),
('Artguru', 'https://www.artguru.ai/blogs/ai-cartoonizer', 'artintel', ''),
('AI Image Enlarger', 'https://imglarger.com/cartoonizer', 'artintel', ''),
('VanceAI', 'https://vanceai.com/toongineer-cartoonizer', 'artintel', ''),
('Nero Software', 'https://ai.nero.com/photo-to-cartoon', 'artintel', ''),
('Picsart', 'https://picsart.com/photo-effects', 'artintel', '');

Steps to Execute

  1. Open SQLite Browser and go to the "Execute SQL" tab.

  2. Paste the above query into the SQL window.

  3. Click "Execute All" to insert the rows into the tab.001 table.

  4. Verify the changes in the "Browse Data" tab.

sqlite-browserSQLite