I was given a huge table of stuff to insert into an SQL database table, it wasnt possible to import this using load data but one of my colleagues in the office gave me a handy Excel formula to use:
=”INSERT INTO flight_refund_country_bands SET countryname=’”&A1&”‘, band_id=”&B1
Seems very simple now I think about it but it [...]
Posts in the "General Information" Category
-
-
I basically wanted a really quick validation code function that would check whether any required fields were missing and prevent the form from submitting if this were the case:
Read More... -
find . -type f -mtime -4 -not \( -name .svn -prune \) | grep -v “.svn” | xargs tar -c | tar -xC /home/dan/americafilestozip/
Share with your friends and help out this site:
Read More... -
I just wanted to warn potential people about this company for now – I sent off a drive that had a seized motor to them for repair, everything was smooth while they were touting for my business, they analysed the drive and sent me an invoice for close on £700 for the repair, fair enough [...]
Read More... -
Quick update, I have recently started with a new client who deals with Event Mangement, the boss is the MD and the main programmer on this so it makes a refreshing change to have someone in charge who actually knows what he is talking about and understands the intricacies of programming rather than someone who [...]
Read More...
Dan’s Twitter- voycey_web: Android: Costco Has Online/In-Store Deal for Galaxy Nexus, Comes With Free Extended Battery: Photo Courtesy of ... http://t.co/t0a5fOes
- voycey_web: Android: Rumor: Galaxy S III May Be Waterproof Courtesy of Liquipel: Anyone who has accidentally dropped their ... http://t.co/QJsrgeRW
- voycey_web: AndroidCentral: The best Australian Android phones - As of Feb. 4, 2012: We're back for another look at the bes... http://t.co/KT5vcW9G
- Matt’s SEO Twitter