If you want to list all of the MySQL database table column names (field names) as a simple list of names, with each column name listed on a separate line, just follow these steps.
First, start MySQL with the -sN options, like this:
$ mysql -sN -u root -p
Then execute a query like this:
How accurate are stock market analysts? If you’re going to invest money in the stock market based on their forecasts, this is an important question.
As technology companies go, Microsoft is a pretty stable, predictable company, so I thought they’d make a good test of analysts’ accuracy. As the image shows, the analysts “hit” on their predictions/forecasts for Microsoft 47% of the time over one year, and 79% of the time over two years. It’s funny/interesting/curious that those numbers are the opposite of what I’d expect; I assumed they’d be more accurate over a shorter time frame.
Analysts were 88% and 93% for Walmart for the last two years; 33% and 40% for Exxon; only 13% and 20% for JC Penney; and just 13% and 23% for Apple.
The image and numbers come from fastgraphs.net.
I just created a TextMate 2 bundle to underline the current line, and this image shows how I created that bundle. The dashed-line will be the same length as the line the cursor is currently on (the current line). I do this a lot when I use TextMate to write notes and even Markdown text, so I wanted a little script/bundle like this.
FWIW, the result of this bundle/command is that I can have the cursor be on a line like “Hello, world,” as shown below, press [Command][u], and end up with this:
Hello, world ------------
As a quick note to self, here is some source code for a simple example PHP script that runs a SQL SELECT query against a MySQL database:
Two of the co-creators of Siri have created Viv, which sounds pretty impressive. As I learned when working on SARAH, a personal/digital assistant needs to have an awareness of “context,” and Viv seems to have that, and a lot of knowledge about how to order a pizza. The story is here on the Washington Post.
I’m currently trying to upgrade a Drupal 6 website to Drupal 8, but the process has been slow-going so far. I’ll explain the problems and workarounds in this article as I learn them.
So far I have been able to get a Drupal 6 website with 7,000+ nodes and 18,000+ URL aliases converted to the point that I can now see all of the old blog posts on the Drupal 8 site, and I’ve also started theming the Drupal 8 website.
I had to go to a doctor’s office today to give blood for another test, but there was a delay in processing my paperwork so I had to sit there for a little while. As I was sitting there my doctor walked into this area with another patient. I don’t remember how we started the conversation, but as we were talking, my doctor said that she was “trying to simplify her life.”
A funny tweet about taking criticism, from this Twitter page.
I don’t know why, but I was unable to get MySQL under MAMP 3.5 to read a my.cnf configuration file. I put that file in all of the usual places, but it wasn’t read. Then I tried to get it to read my configuration file by modifying this MAMP/MySQL startup script:
/Applications/MAMP/bin/startMysql.sh
but all I got then was an error message that these two options don’t work:
--defaults-file=FILE --defaults-extra-file=FILE
I got those errors even though those options are shown in the mysqld_safe help output:
According to this pcworld.com story, Intel is stopping production of its mobile Atom processors and quitting the mobile CPU business. “The company is immediately canceling Atom chips, code-named Sofia and Broxton, for mobile devices, an Intel spokeswoman confirmed.”
