×

Error

Module MODULE_NAME: eBay API Error: Cannot find item 323778944744 on source site 3.
Module MODULE_NAME: eBay API Error: Cannot find item 223472616469 on source site 3.

Home

... without destroying the database. 

You can do it all in the shell:

  • Create a SQL script from the database to drop all the tables
  • Execute the SQL script against the database

mysql -u[pwd] -p[user] [dbname] -s -e 'show tables' | sed -e 's/^/drop table /' -e 's/$/;/' > dropalltables.sql
mysql -u[pwd] -p[user] [dbname] < dropalltables.sql

A quick and dirty way of stripping duplicate records out of a MySQL table!, if your table has no indexes or constraints:

Assuming the name of the offending table is customers:

CREATE TABLE customer_dedupe AS SELECT DISTINCT * FROM customers;
RENAME TABLE customers TO customers_dupe;
RENAME TABLE customers_dedupe TO customers;

Done!

But what if your original table had indexes?

The task of matching strings between heterogeneous systems, especially that of matching personal or company names or addresses, is not easy with SQL Server's limited set of built-in string SQL functions. Here is a C# CLR-Assembly (with source code) for SQL Server with some advanced string-handling functions that may help:

  • LTrim - like Oracle's LTRIM function.

  • InitCap - like Oracle's INITCAP function

  • FlattenCharSet - Replace western characters with diacritics with best-choice, non-diacritic characters

  • StripPunctuationMarks - Remove all punctiation marks from the given string.

 

Click to view details on eBay
Click to view details on eBay
BLACK HEAT SHRINK CAR ELECTRICAL TUBE SLEEVING CABLE VARIOUS SIZES & LENGTH
Location:East Tilbury, ESSEX
Price:1.49 GBP
Bids:0
End date:2020-03-05
End time:23:15:34 GMT
Time left:17 days 15:03:20
Status:Active
Buy It Now
Click to view details on eBay
Click to view details on eBay
Raspberry Pi 3 Model B+ B Plus Kit Module Board + Acrylic Case + Fan + Heatsink
Location:深圳
Price:41.50 GBP
Bids:0
Status:Completed
Click to view details on eBay
Click to view details on eBay
Hubsan H501S S X4 Brushless FPV Quadcopter Drone 1080P Camera GPS Follow Me RTF
Location:Leicestershire
Price:155.00 GBP
Bids:0
Status:Completed
Click to view details on eBay
Click to view details on eBay
15 Bedroom Spanish Farmhouse - Rent to Own Option Seller Finance. Spain
Location:Rayong
Price:1300000.00 GBP
Bids:0
End date:2020-03-06
End time:17:33:49 GMT
Time left:18 days 9:21:28
Status:Active
Buy It Now

Directly Burn DVD's from .avi files

Here is a quick and simple-to-use utility to convert an AVI file to the weird intermediate files and to then write them all to a DVD. It is called avi2dvd and is written in BASH-shell. It is unlikely to run on Windows.

More about it here at https://sourceforge.net/projects/avi2dvd

So, you downloaded a torrent expecting a nice AVI- or MPG-file for instant-action AV entertainment, and all you got was a big .bin file and a funny little .cue file? Here's the Linux-way of how to extract the content from them:

Yet another bespoke file format that unsuccessfully attempts to futher the agenda of vendor lock-in: If you are running Windows, you need to purchase PowerISO from poweriso.com , if you are running X86-based Linux flavour, the same people offer a free program to read and write .daa files. Go figure...

A well-meaning person gives you a .nrg file and you will not invest in a piece of expensive bespoke software to read it. After all, you run free, open-source software and never have and never will pay for software. What to do with this stupid .nrg file?

If you want to install Perl on Windows or do anything vaguely sophisticated in the brain-dead command line shell of Windows (a.k.a. the DOS prompt), then you need a collection of commonly used UNIX utilities that can run under Windows.

I have put together such a collection of the most popular UNIX utilities and a few other command-line programs. Most of these are GPL-licensed (i.e. open source) and the remaining few are free-ware (but not open source). Either way, you can do with these programs whatever you want.

You can download the bundle of utilities from here.

These utilities are particularly useful for installing Perl on your Windows PC. Download Perl for Windows from http://www.activeperl.com. 

  • You are here:  
  • Home