beerandnoodles posted a photo:
beerandnoodles posted a photo:
beerandnoodles posted a photo:
You’re importing some data into MySQL and using LOAD DATA INFILE so you can do a SHOW WARNINGS afterwards. Every line of your import file has a warning:
| Warning | 1262 | Row 1 was truncated; it contained more data than there were input columns
| Warning | 1262 | Row 2 was truncated; it contained more data than there were input columns
…etc.
The fix is easy, and you’d think of it eventually, but you thought you’d try google instead. So I’m posting this so that when you do there is something to find. There wasn’t much when I looked.
It’s the line endings. MySQL isn’t getting what it expects, so specify the format of the file using LINES TERMINATED BY ‘\r\n’ or whatever is appropriate for you:
‘\r\n’ for files that came from Windows systems
‘\r’ for files from VMS
‘\n’ for every other source.
Hope that helps.
Posted in Geekery
|
Tagged mysql
|
Shared by Alan
Apple come up with the most ridiculous reasons to keep competing software out of the hands of their users.
Then, says Crosby: “We were rejected for objectionable content. They provided screenshots of the words ‘shit’ and ‘fuck’ showing up in our dictionary’s search results. What’s interesting is that we spent a good deal of time making it so that you must type vulgar words in their entirety, and only then will we show you suggestions in the search results. For instance, if you type ‘fuc’, you will not see ‘fuck’ as a suggestion. This is in contrast to all other dictionaries we’re aware of on the App Store (including Dictionary.com’s application), which will show you ‘fuck’ in the search results for ‘fuc’, ‘motherfucker’ for ‘mother’, etc.
This is an auto import from my Google Reader shares. Read more at the original site.
Shared by Alan
Who needs an alarm? I want one of these!
In artist FilthyLuker’s street installations, giant inflatable tentacles emerge from buildings and vehicles, creating the sense that a monstrous kraken or Lovecraftian horror is trapped inside.
FilthyLuker creates whimsical sculptures and installations, with pieces that include anthropomorphized trashcans and easy chairs, adding eyeballs to bushes and trees, and giant banana peels placed in the middle of the road. His “Octo” installations are perhaps the most inspired, offering all the fun of a B-movie with none of the property damage.
FilthyLuker’s DeviantArt [via WebUrbanist via Neatorama]
Octopied Building
This is an auto import from my Google Reader shares. Read more at the original site.
How about this for a New Rule: Not everything in America has to make a
profit. It used to be that there were some services and institutions so
vital to our nation that they were exempt from market pressures. Some
things we just didn’t do for money. The United States always defined
capitalism, but it didn’t used to define us. But now it’s becoming all that
we are.
This is an auto import from my Google Reader shares. Read more at the original site.
Shared by Alan
These are smart.
Designed by ChappsMalina, Little Fury & Help Remedies | Country: United States | Buy it
This is an auto import from my Google Reader shares. Read more at the original site.
beerandnoodles posted a photo:
I don’t think the Red Arrows have been flying around here, so I thought these clouds looked odd. What’s going on in the skies of Northampton ?
beerandnoodles posted a photo:
