If you wish to delete all of the records from a table in an SQLite database, you can do so using a command in the form delete from tableName where tableName is the name of the table from which you wish to remove all of the rows in the table. E.g., if I wished to delete all of the records in a table named TimeStamps, I could use the delete command below.

sqlite> select * from Timestamps;
2025-05-01 21:26:22|2025-05-01 21:23|10947739
2025-05-01 21:28:33|2025-05-01 21:28|10967247
2025-05-04 13:37:47|2025-05-04 13:36|18079581
sqlite> delete from Timestamps;
sqlite> select * from Timestamps;
sqlite>

If I only wanted to delete a record or records meeting a specific condition, I could specify that condition in a WHERE clause. E.g., if the columns in the table were CurrentTimestamp, LastUpdateTimestamp, and Size and I only wanted to remove the row where the value of CurrentTimestamp is 2025-05-04 13:37:47, I could use the command below, instead.

sqlite> .schema Timestamps
CREATE TABLE "Timestamps" (
        "CurrentTimestamp"      TEXT NOT NULL,
        "LastUpdateTimestamp"   TEXT NOT NULL,
        "Size"  INTEGER NOT NULL
);
sqlite> delete from Timestamps where CurrentTimestamp='2025-05-04 13:37:47';

[/software/database/sqlite] permanent link

[ More Info ]

[/security/antivirus/avira] permanent link

I booted a PC from a USB flash drive on which I had installed Lubuntu Linux. I also plugged another flash drive into the system, but I didn't know where it was mounted. The hard disk drive (HDD) in the system was /dev/sda and I assumed the Lubuntu Linux bootable drive was /dev/sdb and the new drive would be /dev/sdbc. You can type for devlink in /dev/disk/by-id/usb*; do readlink -f ${devlink}; done at a shell prompt, which you can obtain on a Lubuntu system by clicking on the bird icon at the lower, left-hand corner of the screen and selecting System Tools then Qterminal, to see a list of the USB devices attached to a system.

lubuntu@lubuntu:~$ for devlink in /dev/disk/by-id/usb*; do readlink -f ${devlink}; done
/dev/sdc
/dev/sdc1
/dev/sdb
/dev/sdb1
lubuntu@lubuntu:~$

You can find the location where a USB drive is mounted by issuing the mount command and then piping the output into the grep command to find information on just the particular drive in which you are interested.

lubuntu@lubuntu:~$ mount | grep sdc
/dev/sdc1 on /media/lubuntu/EMTEC C450 type vfat (rw,nosuid,nodev,rela
time,uid=1000,gid=1000,fmask=0022,dmask=0022,codepage=437,iocharset=is
o8859-1,shortname=mixed,showexec,utf8,flush,errors=remount-ro,uhelper=udisks2)
lubuntu@lubuntu:~$

In this case, I knew the USB flash drive was a 16GB Emtec device and I was able to see it was mounted at /media/lubuntu/EMTEC C450. I was then able to view the files and folders for the drive from the shell prompt.

lubuntu@lubuntu:~$ ls /media
cdrom  lubuntu  root
lubuntu@lubuntu:~$ ls /media/lubuntu
'EMTEC C450'
lubuntu@lubuntu:~$ ls /media/lubuntu/'EMTEC C450'
 EMTEC.icns   EMTEC.ico  'System Volume Information'   autorun.inf
lubuntu@lubuntu:~$

References:

1. How do I figure out which /dev is a USB flash drive?
   Date: September 16, 2008
   superuser

[/os/unix/linux/lubuntu] permanent link

[ More Info ]

[/os/windows/utilities] permanent link

1. In the Windows File Explorer, Right-click on the .iso file, then click on Burn, which appears above the file list.

   

2. If the appropriate CD/DVD drive does not appear in the "Disc Burner" field, select it then click on Burn (check the box first for "Verify disc after burning", if you wish to have the program verify that the disc can be read successfully after the iso file is burned to the disc).

   

3. When the iso file has successfully been written to disc, you should see "The disc image has been successfully burned to disc." You can then click on the Close button.

   

   The disc will then be ejected.

[/os/windows/win11] permanent link

• Apple
• Google (online)
• Office 365 (onlilne)
• Outlook
• Outlook.com
• Yahoo (online)

Once I had the .ics file, I was able to click on File then Open & Export in Outlook on my wife's PC to open the .ics file I downloaded and add the organization's calendar to her Outlook calendar.

[/network/email/clients/outlook] permanent link

I don't know how well the technique may work on very large files or directories, e.g., ones that are multiple gigabytes, but I've found it works well at least for those several megabytes in size. I also have not tested what happens if you try another copy and paste operation before the first one has completed.

Related:

1. Transferring Files Via the Remote Desktop
   Date: March 13, 2010

[/os/windows/software/remote-control/rdp] permanent link

[/home] permanent link

Image 1 at full scale

Image 1 at 75% scale

Note: The image above is a photo of Robert H. Goddard with an A-series rocket circa 1935

Related articles:

Automatically resizing an image for mobile devices

[/network/web/html/css] permanent link

[/os/windows/software/audio-video/WMP] permanent link