Roger Federer overcomes windy conditions to beat Andreas Beck and reach the US Open third round, but seeds Nikolay Davydenko and Maran Cilic crash out.
Did you ever read an old science fiction book that felt dated? Maybe the predictions were way off base, or maybe or they were a reflection of the times in which they were written. Yet some books are considered timeless classics, which makes one wonder which of today’s books will fall into that category. So we turned to this week’s and asked them
hey @foursquare –u have a douchebag badge but ur stalling on the library one? that’s really where u want to hang ur hat? http://ow.ly/2ytUA [shifted]
Three Pakistan cricketers accused of corruption are set to be questioned again by police, after being charged and provisionally suspended by the International Cricket Council.
Samsung's Galaxy Tab could have an unsubsidized price high enough that it would be more expensive than most any Apple model, based on early if unconfirmed claims. The French at Journal du Geek were quoted a price of 699 euros with tax for the 16GB version, or $895. At this level, it would cost as much as a 32GB, 3G iPad does despite the smaller screen....
Etsy seller Buster and Boo does a nice line in vintage, moderately priced jewelry and decorative art made from vintage typewriter keys from the 1920s and 1930s.
So where would you go looking if you wanted to find the deepest and sickest cold wave synth-beats of all? Then I think we would have to look all the way back to JohnBender, avant-garde synth pioneer, who released three seminal albums in the early '80s and then just disappeared, forever. What else sounds this fantastic, and has that addictive, computerized, lo-fi ice beat? Maybe Ultravox, and the frosty, hollow majesty of HiroshimaMon Amour. Or Soviet with Candy Girl, or Lori and the Chameleons and Touch
"Earlier this week, Tribune's KTXL Sacramento aired what it says is the first-ever TV station ad for marijuana. The Fox affiliate aired a 30-second spot, paid for by Sacramento-based medicinal marijuana advocacy group CannaCare and produced by KTXL, advertising a medical marijuana dispensary." CannaCare Commercial.
The 33 miners trapped far below the surface of the Earth appear in mind and spirit as strong as " solid rock" and are working well as a team, Chilean Health Minister Jaime Manalich told CNN.
The government of Mozambique says price rises which have led to deadly riots are "irreversible", as Maputo residents are urged to continue their protests.
Another day, another disappointment for progressive Democrats. We learn from former auto-industry car czar Steve Rattner that Obama chief of staff Rahm Emanuel said "Fuck the UAW" during tough takeover talks – just like he called progressives "fucking retarded" for contemplating primary challenges against conservative Democrats.
An oil and gas production platform has exploded 80 miles off the central coast of Louisiana, with 13 people overboard, including one injured, the Coast Guard said Thursday morning.
AP - Dell Inc. doesn't have to start over in its quest to become a significant purveyor of technology for businesses after losing a multibillion dollar bidding contest for an obscure data-storage maker.
AFP - A video cartoon featuring Google's chief giving away ice cream to snoop on children aired on a giant screen in Times Square as a privacy group continued to hound the Internet giant.
The Walt Disney Co. and Time Warner have established a long-term agreement that will continue to bring a wide range of Disney programming to Time Warner cable subscribers. The terms of the deal will allow subscribers to access a variety of online content and video-on-demand services....
Crews removed the cap from BP's ruptured Gulf of Mexico oil well late Thursday afternoon, a company spokeswoman said, an important step toward permanently sealing the well.
The Mexican army says it has killed 27 suspected drug gang members in a clash near the US border, hours after the country's president insisted the war against the cartels would continue.
Apple appears to be the only company immune from a falloff in notebook shipments for the month of July, according to a report from Digitimes Research senior analyst Joanne Chien. HP is said to be the hardest hit, with notebook shipments expected to reach only 39.5 million units by the end of the year. The company had set a goal of 45-47 million units....
Ultrafine measurements of atmospheric gases could help scientists track down the last sources of CFCs thought to be slowing the recovery of the ozone hole.
by Owen Gibson, David Hopps at 17:48 PM, 09/02/2010
Captain and two bowlers protest their innocence as players are to be interviewed by police under caution
The three Pakistan cricketers at the centre of an alleged betting scam that has thrown world cricket into crisis were last night charged under the anti-corruption code of the game's governing body and provisionally suspended.
After a day that began with the Pakistan Cricket Board agreeing to omit the players from the team for the rest of the tour, and the Pakistan high commissioner claiming they were "set-up" by the News of the World, the ICC suspended the three pending a tribunal.
Outside the west London hotel in which Test captain Salman Butt, fast bowler Mohammad Asif and brilliant teenage prospect Mohammad Amir are also staying, ICC chief executive Haroon Lorgat provided the swift action many in the game had demanded.
"We will not tolerate corruption in cricket – simple as that. We must be decisive with such matters and, if proven, these offences carry serious penalties up to a life ban," he said.
"The ICC will do everything possible to keep such conduct out of the game and we will stop at nothing to protect the sport's integrity. While we believe the problem is not widespread, we must always be vigilant. It is important, however, that we do not pre-judge the guilt of these three players. That is for the independent tribunal alone to decide."
Under tougher new rules brought in last year by the ICC, the players can be suspended provisionally ahead of any hearing if it is in the interests of the game.
The row was triggered by allegations in the News of the World that the three had agreed to bowl no-balls in specific overs of last week's fourth Test at Lord's in return for money.
The charges were announced after officials from the ICC's anti-corruption and security unit (ACSU) spent the afternoon at Scotland Yard viewing evidence and seeking police go-ahead. The police are conducting a parallel criminal inquiry.
The three players will today be interviewed under police caution for the first time. Earlier they had agreed to withdraw from the rest of the tour citing the "mental torture" they had been placed under by the allegations. They protested their innocence and the Pakistani high commissioner suggested they might have been "set up" by the News of the World.
While their team-mates were turning out against Somerset 160 miles away in Taunton, the accused three were being whisked into their country's high commission in London amid a flurry of claims and top level political negotiations.
ICC investigators, who had been examining spot-fixing allegations against Pakistan for some time, have been in London since Monday. Sir Ronnie Flanagan, the former Northern Ireland police chief who was appointed chairman of the ACSU three months ago, arrived from Abu Dhabi to join them, while its chief investigator, Ravi Sawani, met police.
But despite withdrawing the players from the tour, following pressure behind the scenes from the England and Wales Cricket Board and the sport's global governing body, the Pakistan camp remained bullish.
The high commissioner, Wajid Shamsul Hasan, claimed the players had been "set up" by the News of the World. Asked if they had been framed, he answered "yes" and suggested the newspaper's video evidence could have been filmed after the contentious no-balls had been bowled.
The News of the World said it "refuses to respond to such ludicrous allegations". The newspaper is understood to be preparing further revelations for Sunday.
Hasan said of the three players: "They are extremely disturbed about what has happened in the past week, particularly in regards to their alleged involvement in the crime. They mentioned they are entirely innocent and shall defend their innocence as such.
"They further maintain that on account of the mental torture that has affected them they are not in right frame of mind to play the remaining matches."
Pakistani journalists repeatedly asked whether the team was a victim of a conspiracy and Pakistan's sports minister, Ijaz Jakhrani, also suggested there could be another explanation for the apparently damning News of the World evidence.
"Let's wait until the report comes. After that we will be in a position to see if it is spot fixing, if it is match fixing or if it is a conspiracy against these players or against the country," he told the Indian news channel CNN-IBN.
After the three wary-looking players arrived to a media posse and a small knot of 20 or so protesters, officials from the Pakistan high commission handed out copies of an article by the journalist and academic Roy Greenslade.
The piece was highly critical of the methods used in previous stings by Mazher Mahmood – the so-called "Fake Sheikh" behind the sensational News of the World claim that a middleman accepted £150,000 to correctly predict the exact time when no-balls would be bowled.
Although Hasan insisted the three players were "not running away" – they will remain in England and their passports are being held by the team manager – they were whisked out of a side door and departed in a people carrier while the car in which they arrived acted as a decoy.
Mazhar Majeed, the 35-year-old middleman the News of the World alleges was at the heart of the betting sting, was arrested on Sunday and released on bail. Separately, he was also arrested as part of an investigation by HM Revenue and Customs into money laundering through Croydon Athletic, the non-league football club he owns.
Both the ECB and the ICC felt the intense focus on and public clamour for action had made it impossible for the three players to play any further part in the tour. The ICC was under pressure to act before Sunday's Twenty20 match between England and Pakistan in Cardiff.
Sources had indicated all week that a negotiated withdrawal was the most likely solution, but a last minute intervention from PCB chairman, Ijaz Butt, threw a spanner in the works. His insistence that the players might still play was seen as an attempt to reassure the Pakistani public that it was not capitulating.
Despite claiming a rather nifty Chanel bag containing cocaine was not hers, it seems the dazzling socialite tweeted a picture of a bag that looks spectacularly similar more than a month ago.
After a week mostly focused on Iraq and Mideast diplomacy, it's back to the economy for President Barack Obama, who will deliver remarks Friday on the August unemployment numbers.
PC World - For all of this year's chatter about the coming army of Android tablets, the near radio silence has been deafening. Until now. First, at consumer electronics show IFA in Berlin, came news of a global launch of the Samsung Galaxy Tab. And starting next week, you can hop onto Amazon.com to pre-order the Stream TV eLocity A7.
Direct talks between Israeli and Palestinian leaders kicked off again with pledges of support for a peace process leading to a comprehensive settlement within one year.
We were all a little relieved when I decided that I'd been raped. Binge drinking and suicidal thoughts had plagued my freshman year of college. "I knew there had to be a reason," my mom said when I confessed my secret to her outside of my psychiatrist's office. Depression was not something my Irish-Catholic family believed in. I had become dramatic. I stopped shaving my legs because I didn't want to be alone with a razor, as if anyone has ever offed themselves with a pink Bic. An attack at least provided an explanation for my behavior. And yet, rape was a powerful, loaded word -- one I wasn't sure was mine to use. How could I say I was raped when I was so wasted I couldn't remember entire portions of the night?
Some things, you have to imagine, don't need massive advertising campaigns. Milk, for instance. But then there you are, staring at life-size posters of all your favorite celebrities with those weird-looking milk mustaches. Up next: carrots! As reported by the AP, some 50 carrot growers from around the country recently joined forces to boost baby carrot sales, which set the bagged-vegetable world on fire in the '90s but have fizzled of late. The result? A $25 million campaign created by advertising agency Crispin Porter + Bogusky that focuses on the untapped hipness of the baby carrot.
Panasonic used the broiling, hectic setting of the U.S. Open tennis tourney in New York Wednesday to showcase the capabilities of its first handheld consumer 3D camcorder.
Ugly Vegas Carpets Want You to Keep Playing. "Mathematician-philosopher Alfred North Whitehead once said, "It requires a very unusual mind to undertake the analysis of the obvious." This certainly rings true with Chris Maluszynski's Las Vegas Carpets series, whose name explains it all. The photos draw out the psychology of Las Vegas through the simple observation of carpet."
Xeni posted a great NASA image of the 2010 Hurricane Earl earlier this afternoon, which got me hunting around for some information on Hurricane Earls past. After all, this is not the first Earl. There've been three others, as well as some lesser Tropical Storms of the same name. The naming lists for these things are used again every seven years, and individual names are only retired after they've been attached to a particularly damaging storm. Earl, so far, has not.
When the names do get retired, replacing them isn't easy. According to Time magazine, there's a whole list of types of names that aren't allowed. Over the years, the meteorologists in charge of naming have resorted to flipping through the weirder end of baby name books and adding friends' names to the list.
Israeli and Palestinian leaders begin framework talks on a peace deal which could encompass borders, Jerusalem, Jewish settlements and security
The Israeli and Palestinian leaders, Binyamin Netanyahu and Mahmoud Abbas, met for the first day of direct talks in Washington yesterday and agreed that a peace deal could be achieved within a year.
George Mitchell, the White House envoy who joined the negotiations, said the two leaders decided to begin putting together a framework agreement on all major issues – such as borders, Jerusalem, Jewish settlements and security – that will "establish the fundamental compromises necessary" to flesh out a comprehensive peace deal.
Mitchell said Netanyahu and Abbas agreed to meet again in a fortnight in the Middle East and every two weeks after that. The US secretary of state, Hillary Clinton, and Mitchell will attend the first of those meetings on 14 September.
The negotiations are likely to face their first real test with the next round of talks coming just days before Israel's partial freeze on construction of Jewish settlements in the West Bank comes to an end.
Netanyahu has so far resisted US calls to renew the freeze, which the Palestinians see as a litmus test of the Israeli prime minister's intent.
Mitchell declined to disclose the detail of the discussions, although he said some of the major issues were touched on. Netanyahu and Abbas met US officials and then met privately. Mitchell described the two men's relationship at the talks as "cordial".
Before the talks opened, Netanyahu said two key demands – recognition of his country as a Jewish state and arrangements to ensure it does not come under attack from within a Palestinian state – were a prerequisite to a wider agreement.
Netanyahu again called Abbas his "partner in peace" and said he was prepared to make "painful concessions" to reach a deal. But the Israeli prime minister said that what he called the "two pillars to peace" must be resolved.
Clinton launched the negotiations by calling for the leaders to show themselves as bold and courageous statesmen and reach a comprehensive peace agreement within the one-year deadline set by Barack Obama. "We understand the suspicion and scepticism that so many feel born out of years of conflict and frustrated hopes," she said. "But by being here today you each have taken an important step toward freeing your peoples from the shackles of a history we cannot change."
Netanyahu said Israel was prepared to make sacrifices to reach an agreement. "Together we can lead our people to a historic future that can put an end to claims and to conflict. This will not be easy. A true peace, a lasting peace, will be achieved only with mutual and painful concessions from both sides … from my side and from your side," he said.
Hamas responded to the talks by announcing that it has joined forces with other armed groups such as Islamic Jihad to launch a wave of attacks against Israel. Earlier this week, Hamas claimed responsibility for the killing of four Jewish settlers in the West Bank, including a pregnant woman.
The Israeli prime minister said there were two issues that he regarded as central to any agreement: legitimacy and security. "Just as you expect us to be ready to recognise a Palestinian state as the nation state of the Palestinian people, we expect you to be prepared to recognise Israel as the nation state of the Jewish people," he said. "I said too, a real peace must take into account the genuine security needs of Israel … new forces have risen in our region, Iran and its proxies and the rise of missile warfare [with Hamas attacks from Gaza]. A peace agreement must take into account security arrangements against these real threats."
Abbas said he believed a deal was possible. "We're not starting from scratch, because we had many rounds of negotiations between the PLO and the Israeli government."
You can keep an eye on hurricanes from your iPhone, iPod touch, or iPad with the help of an assortment of App Store offerings. But which app should you choose for your storm watch? Jeff Merron rates five contenders.
Another oil rig in the Gulf of Mexico exploded today. All crew members survived. Right now, nobody knows whether or not the explosion caused a leak in any of the seven wells that the rig collects from. There have been reports of an oil slick on the water near the fire, but that could just as easily be from the finite amount of oil stored on the rig—which would still a spill, but a significantly less problematic one.
Other than that, there's not really much information out about this right now. If anybody's learned anything from Deepwater Horizon it seems to be that you're better off, PR-wise, if you don't have to correct everything you say two days later.
To give you something to chew over in the meantime, though, Deep Sea News has been doing a really interesting series on the science (such as it is) of oil dispersants. It's interesting, not just because of the basic facts, but also because it gets into the details of why we don't know more.
Dispersants must be applied successfully and have a high effectiveness once in ocean waters. This sounds easy, in principle--once you've perfected your Corexit formula in the lab, just spray it from a helicopter, and voila! Except there are a lot of factors which you also have to take into account: the composition of the oil spilled, sea energy, whether the oil has been subjected to weathering at all, exact type of dispersant used and the amount which you sprayed, and ocean temperature/salinity.
Thank goodness for all those lab tests over the years which figured all this stuff out, you say. Um, well actually it seems like even designing simulation experiments is difficult, and different tests can report different effectiveness scores for the same dispersant. It is difficult to accurately scale up lab tests in order to predict dispersant action on real spills. Older studies used methods and analyses which have since been discredited. Wave-tank tests can probably provide upper limits on dispersant effectiveness, but there are SEVENTEEN (!!) critical factors that require strict control for accurate results (Fingas 2002). Field tests in open ecosystems are even worse for measuring the fate of oil and controlling variables. In terms of measuring dispersant effectiveness, tank tests, field tests, and lab tests all disagree. Awesome.
Oil versus water. He-Man versus Skeletor. Sarah Palin versus rational thought. Bitter enemies, all. None of these, though, has generated as much loyalty or backstabbing as the heated tech rivalry between iOS and Android. The operating systems have been dividing and conquering our gadgets and gizmos for what seems like forever, and today Google launched another Android-based product for us to gobble up. Or spit back out. And it's only the first of many!
US awards $330 million to two coalitions of states to develop standardized testing as part of its Race to the Top competition; tests to employ computers to measure students' skills.
Mary Robinette Kowal sez, "Preschoolers in Richmond, California are being handed RFID jerseys when they get to school. The ACLU points out that in addition to the privacy concerns, these are not secure tags. It has the potential to make kidnapping and stalking very easy."
The editors of Scientific American said it well back in May 2005: "Tagging ... kids becomes a form of indoctrination into an emerging surveillance society that young minds should be learning to question."
The United Nations appears to have been aware of rape by rebels in eastern Congo earlier than it originally said it was, according to an internal e-mail and a humanitarian bulletin.
Every time there’s an Apple event, there’s fallout. Big, nasty, mutate-ants-into-monstrous-rampaging-creatures fallout. With Apple’s media shindig on Wednesday, there’s no shortage of rejoinders and responses from media executives, smartphone rivals, and even…a golf company?
These days, the consumer-oriented iMacs stand on their own against (and in some cases, surpass) the Mac Pro in day-to-day performance. Does that mean that the Mac Pro has lost its relevance in today's work environment? Hardly.
The number of illegal immigrants in the US has declined by about 1 million since the start of the recession. A new study looks at the trend state by state. Here are the top five.
Schools across the country are banning rubber bracelets benefiting breast cancer activism -- all because they read, "I (heart) boobies." Administrators and parents are reacting to "boobies" as though it were a corrupting four-letter word from which we must protect our nation's youth. As though breasts themselves were obscene. As though they weren't a normal object of teenage lust. As though the First Amendment didn't exist.
Gang representatives in Chicago held a press conference Thursday to explain why gangs cannot be held solely responsible for stopping street violence, which has escalated this summer.
Curator and artist Aunia Kahn selected a group of 23 lowbrow/pop surrealist artists to interpret one card each of the Major Arcana of the Tarot deck. Hi-Fructose has a sneak preview of 14 of the cards, which will debut October 1 with a full show at Los Angeles's La Luz de Jesus Gallery, a book, and of course a deck of cards. Above left, card back by Daniel Martin Diaz; right, The Devil by Chet Zar
by PHILIP ELLIOTT, Associated Press at 15:59 PM, 09/02/2010
Delaware Republicans call Senate hopeful Christine O'Donnell a liar who "could not be elected dog catcher" in a fierce attack that underscores GOP fears of the tea party-backed candidate knocking off top recruit Rep. Mike Castle and winning the nomination.
Apple has released a third preview of Xcode 4, the latest set of developer tools for Mac OS and iOS platforms. Version 4 transitions to a single-winder interface, combining a navigation toolbar, which offers search and list content, with a Jump Bar that can be used to quickly switch between various levels....
A few days after AT&T said its push toward "paid prioritization" of network traffic is backed by technical standards, the Internet's primary standards body disagrees.
Investor's Business Daily - Electronic giants Samsung and Toshiba each unveiled new tablet PCs running Google's (NMS:GOOG) Android OS that aim to tap consumer demand ignited by the Apple (NMS:AAPL) iPad. Samsung's Galaxy Tab features a 7-inch touch screen and WiFi and Bluetooth connectivity. Samsung said pricing will be $200-$300, depending on required 3G phone plans. Toshiba's Folio 100 features a larger 10-inch screen, but initially will only have WiFi connectivity. It'll be priced at $510. Apple rose 0.7% to 252.17.
Investor's Business Daily - Google (NMS:GOOG) will continue to provide the search results on AOL's Web site under a new, five-year deal. The deal will put AOL video content on Google's YouTube site for the first time. AOL edged up 0.7% to 23.05.
Film's producers subpoena Qwest Communications for Denver man's records, apparently overcoming legal challenges in their pursuit of alleged file sharers.
by JIM KUHNHENN, Associated Press at 15:45 PM, 09/02/2010
An anti-abortion group plans to air radio ads in three congressional races calling for the defeat of Democratic incumbents, among the first ads to capitalize on a Supreme Court ruling this year that freed corporations to directly influence elections.
These days, the consumer-oriented iMacs stand on their own against (and in some cases, surpass) the Mac Pro in day-to-day performance. Does that mean that the Mac Pro has lost its relevance in today’s work environment? Hardly.
Toshiba has revealed new SDHC memory cards with the Ultra High Speed I (UHS-I) standard that enables them to reach maximum data read rates of 95MBps and write speeds of 80MBps. This makes them the fastest SDHC UHS-I memory cards in the world. The cards can thus far only use these speeds in USB 3.0 readers, as no camera can fully use their performance....
The relatively placid view from the International Space Station belied the potent forces at work in Hurricane Earl as it hovered over the tropical Atlantic Ocean on August 30. With maximum sustained winds of 135 miles (215 kilometers) per hour, the storm was classified as a category 4 on the Saffir-Simpson hurricane scale as it passed north of the Virgin Islands.
Compal president Ray Chen told those at an investors' meeting that he expects the fledgling tablet industry to undergo a major thinning effect for all but Apple's iPad in 2011. He saw the entire competition moving just 10 million to 12 million tablets next year where many expect Apple to reach those numbers in 2010 with only eight months of sales. The poor results will likely see some companies quit the market after just a year, DigiTimes heard, because they falsely assumed they would automatically succeed....
A phone-hacking scheme involving British royals and reporters working for one of Rupert Murdoch's tabloid newspapers went far beyond what was previously disclosed and prosecuted. The British Prime Minister's current media adviser is accused of having encouraged the hacking.
This is the mysql man page, I'll put other information on here some other time.
mysql is a simple SQL shell (with GNU readline
capabilities). It supports interactive and non-interactive
use. When used interactively, query results are presented
in an ASCII-table format. When used non-interactively (for
example, as a filter), the result is presented in
tab-separated format. The output format can be changed
using command-line options.
If you have problems due to insufficient memory for large
result sets, use the --quick option. This forces mysql to
retrieve results from the server a row at a time rather
than retrieving the entire result set and buffering it in
memory before displaying it. This is done by using
mysql_use_result() rather than mysql_store_result() to
retrieve the result set.
Using mysql is very easy. Invoke it from the prompt of
your command interpreter as follows:
shell> mysql db_name
Or:
shell> mysql --user=user_name --password=your_password db_name
Then type an SQL statement, end it with `;, g, or G and
press Enter.
You can run a script simply like this:
shell> mysql db_name < script.sql > output.tab
OPTIONS
mysql supports the following options:
o --help, -?
Display a help message and exit.
o --batch, -B
Print results using tab as the column separator, with
each row on a new line. With this option, mysql does
not use the history file.
o --character-sets-dir=path
The directory where character sets are installed. See
Section 7.1, "The Character Set Used for Data and
Sorting".
o --compress, -C
Compress all information sent between the client and
the server if both support compression.
o --database=db_name, -D db_name
The database to use. This is useful mainly in an option
file.
o --debug[=debug_options], -# [debug_options]
Write a debugging log. The debug_options string often
is 'd:t:o,file_name'. The default is
'd:t:o,/tmp/mysql.trace'.
o --debug-info, -T
Print some debugging information when the program
exits.
o --default-character-set=charset
Use charset as the default character set. See
Section 7.1, "The Character Set Used for Data and
Sorting".
o --execute=statement, -e statement
Execute the statement and quit. The default output
format is like that produced with --batch. See
Section 3.1, "Using Options on the Command Line" for
some examples.
o --force, -f
Continue even if an SQL error occurs.
o --host=host_name, -h host_name
Connect to the MySQL server on the given host.
o --html, -H
Produce HTML output.
o --ignore-space, -i
Ignore spaces after function names. The effect of this
is described in the discussion for IGNORE_SPACE in the
section called "THE SERVER SQL MODE".
o --local-infile[={0|1}]
Enable or disable LOCAL capability for LOAD DATA
INFILE. With no value, the option enables LOCAL. It may
be given as --local-infile=0 or --local-infile=1 to
explicitly disable or enable LOCAL. Enabling LOCAL has
no effect if the server does not also support it.
o --named-commands, -G
Named commands are enabled. Long format commands are
allowed as well as shortened * commands. For example,
quit and q both are recognized.
o --no-auto-rehash, -A
No automatic rehashing. This option causes mysql to
start faster, but you must issue the rehash command if
you want to use table and column name completion.
o --no-beep, -b
Do not beep when errors occur.
o --no-named-commands, -g
Named commands are disabled. Use the * form only, or
use named commands only at the beginning of a line
ending with a semicolon (`;). As of MySQL 3.23.22,
mysql starts with this option enabled by default.
However, even with this option, long-format commands
still work from the first line.
o --no-pager
Do not use a pager for displaying query output. Output
paging is discussed further in the section called
"FBMYSQLFR COMMANDS".
o --no-tee
Do not copy output to a file. Tee files are discussed
further in the section called "FBMYSQLFR COMMANDS".
o --one-database, -O
Ignore statements except those for the default database
named on the command line. This is useful for skipping
updates to other databases in the binary log.
o --pager[=command]
Use the given command for paging query output. If the
command is omitted, the default pager is the value of
your PAGER environment variable. Valid pagers are less,
more, cat [> filename], and so forth. This option works
only on Unix. It does not work in batch mode. Output
paging is discussed further in the section called
"FBMYSQLFR COMMANDS".
o --password[=password], -p[password]
The password to use when connecting to the server. If
you use the short option form (-p), you cannot have a
space between the option and the password. If you omit
the password value following the --password or -p
option on the command line, you are prompted for one.
The password should be omitted on SysV-based UNIX
systems, as the password may be displayed in the output
of ps.
o --port=port_num, -P port_num
The TCP/IP port number to use for the connection.
o --prompt=format_str
Set the prompt to the specified format. The default is
mysql>. The special sequences that the prompt can
contain are described in the section called
"FBMYSQLFR COMMANDS".
o --protocol={TCP | SOCKET | PIPE | MEMORY}
The connection protocol to use.
o --quick, -q
Do not cache each query result, print each row as it is
received. This may slow down the server if the output
is suspended. With this option, mysql does not use the
history file.
o --raw, -r
Write column values without escape conversion. Often
used with the --batch option.
o --reconnect
If the connection to the server is lost, automatically
try to reconnect. A single reconnect attempt is made
each time the connection is lost. To suppress
reconnection behavior, use --skip-reconnect.
o --safe-updates, --i-am-a-dummy, -U
Allow only those UPDATE and DELETE statements that
specify rows to affect using key values. If you have
set this option in an option file, you can override it
by using --safe-updates on the command line. See the
section called "FBMYSQLFR TIPS" for more information
about this option.
o --secure-auth
Do not send passwords to the server in old (pre-4.1.1)
format. This prevents connections except for servers
that use the newer password format.
o --show-warnings
Cause warnings to be shown after each statement if
there are any. This option applies to interactive and
batch mode. This option was added in MySQL 5.0.6.
o --sigint-ignore
Ignore SIGINT signals (typically the result of typing
Control-C).
o --silent, -s
Silent mode. Produce less output. This option can be
given multiple times to produce less and less output.
o --skip-column-names, -N
Do not write column names in results.
o --skip-line-numbers, -L
Do not write line numbers for errors. Useful when you
want to compare result files that include error
messages.
o --socket=path, -S path
The socket file to use for the connection.
o --table, -t
Display output in table format. This is the default for
interactive use, but can be used to produce table
output in batch mode.
o --tee=file_name
Append a copy of output to the given file. This option
does not work in batch mode. Tee files are discussed
further in the section called "FBMYSQLFR COMMANDS".
o --unbuffered, -n
Flush the buffer after each query.
o --user=user_name, -u user_name
The MySQL username to use when connecting to the
server.
o --verbose, -v
Verbose mode. Produce more output. This option can be
given multiple times to produce more and more output.
(For example, -v -v -v produces the table output format
even in batch mode.)
o --version, -V
Display version information and exit.
o --vertical, -E
Print the rows of query output vertically. Without this
option, you can specify vertical output for individual
statements by terminating them with G.
o --wait, -w
If the connection cannot be established, wait and retry
instead of aborting.
o --xml, -X
Produce XML output.
You can also set the following variables by using
--var_name=value options:
o connect_timeout
The number of seconds before connection timeout.
(Default value is 0.)
o max_allowed_packet
The maximum packet length to send to or receive from
the server. (Default value is 16MB.)
o max_join_size
The automatic limit for rows in a join when using
--safe-updates. (Default value is 1,000,000.)
o net_buffer_length
The buffer size for TCP/IP and socket communication.
(Default value is 16KB.)
o select_limit
The automatic limit for SELECT statements when using
--safe-updates. (Default value is 1,000.)
It is also possible to set variables by using
--set-variable=var_name=value or -O var_name=value syntax.
This syntax is deprecated.
On Unix, the mysql client writes a record of executed
statements to a history file. By default, the history file
is named and is created in your home directory. To specify
a different file, set the value of the MYSQL_HISTFILE
environment variable.
If you do not want to maintain a history file, first
remove if it exists, and then use either of the following
techniques:
o Set the MYSQL_HISTFILE variable to /dev/null. To cause
this setting to take effect each time you log in, put
the setting in one of your shell's startup files.
o Create as a symbolic link to /dev/null:
shell> ln -s /dev/null /.mysql_history
You need do this only once.
FBMYSQLFR COMMANDS
mysql sends SQL statements that you issue to the server to
be executed. There is also a set of commands that mysql
itself interprets. For a list of these commands, type help
or h at the mysql> prompt:
mysql> help
List of all MySQL commands:
Note that all text commands must be first on line and end with ';'
? (?) Synonym for `help'.
clear (i Clear command.
connect (
) Reconnect to the server. Optional arguments are db and host.
delimiter (d) Set statement delimiter. NOTE: Takes the rest of the line as new delimiter.
edit () Edit command with .
ego (G) Send command to mysql server, display result vertically.
exit (q) Exit mysql. Same as quit.
go (g) Send command to mysql server.
help (h) Display this help.
nopager (
) Disable pager, print to stdout.
notee ( ) Don't write into outfile.
pager (P) Set PAGER [to_pager]. Print the query results via PAGER.
print (p) Print current command.
prompt (R) Change your mysql prompt.
quit (q) Quit mysql.
rehash (#) Rebuild completion hash.
source (.) Execute an SQL script file. Takes a file name as an argument.
status (s) Get status information from the server.
system (!) Execute a system shell command.
tee (T) Set outfile [to_outfile]. Append everything into given outfile.
use () Use another database. Takes database name as argument.
warnings (W) Show warnings after every statement.
nowarning (w) Don't show warnings after every statement.
Each command has both a long and short form. The long form
is not case sensitive; the short form is. The long form
can be followed by an optional semicolon terminator, but
the short form should not.
In the delimiter command, you should avoid the use of the
backslash (`) character because that is the escape
character for MySQL.
The edit, nopager, pager, and system commands work only in
Unix.
The status command provides some information about the
connection and the server you are using. If you are
running in --safe-updates mode, status also prints the
values for the mysql variables that affect your queries.
To log queries and their output, use the tee command. All
the data displayed on the screen is appended into a given
file. This can be very useful for debugging purposes also.
You can enable this feature on the command line with the
--tee option, or interactively with the tee command. The
tee file can be disabled interactively with the notee
command. Executing tee again re-enables logging. Without a
parameter, the previous file is used. Note that tee
flushes query results to the file after each statement,
just before mysql prints its next prompt.
Browsing or searching query results in interactive mode by
using Unix programs such as less, more, or any other
similar program is possible with the --pager option. If
you specify no value for the option, mysql checks the
value of the PAGER environment variable and sets the pager
to that. Output paging can be enabled interactively with
the pager command and disabled with nopager. The command
takes an optional argument; if given, the paging program
is set to that. With no argument, the pager is set to the
pager that was set on the command line, or stdout if no
pager was specified.
Output paging works only in Unix because it uses the
popen() function, which does not exist on Windows. For
Windows, the tee option can be used instead to save query
output, although this is not as convenient as pager for
browsing output in some situations.
A few tips about the pager command:
o You can use it to write to a file and the results go
only to the file:
mysql> pager cat > /tmp/log.txt
You can also pass any options for the program that you
want to use as your pager:
mysql> pager less -n -i -S
o In the preceding example, note the -S option. You may
find it very useful for browsing wide query results.
Sometimes a very wide result set is difficult to read
on the screen. The -S option to less can make the
result set much more readable because you can scroll it
horizontally using the left-arrow and right-arrow keys.
You can also use -S interactively within less to switch
the horizontal-browse mode on and off. For more
information, read the less manual page:
shell> man less
o You can specify very complex pager commands for
handling query output:
mysql> pager cat | tee /dr1/tmp/res.txt
| tee /dr2/tmp/res2.txt | less -n -i -S
In this example, the command would send query results
to two files in two different directories on two
different filesystems mounted on /dr1 and /dr2, yet
still display the results onscreen via less.
You can also combine the tee and pager functions. Have a
tee file enabled and pager set to less, and you are able
to browse the results using the less program and still
have everything appended into a file the same time. The
difference between the Unix tee used with the pager
command and the mysql built-in tee command is that the
built-in tee works even if you do not have the Unix tee
available. The built-in tee also logs everything that is
printed on the screen, whereas the Unix tee used with
pager does not log quite that much. Additionally, tee file
logging can be turned on and off interactively from within
mysql. This is useful when you want to log some queries to
a file, but not others.
The default mysql> prompt can be reconfigured. The string
for defining the prompt can contain the following special
sequences:
Option Description
v The server version
d The current database
h The server host
p The current TCP/IP port or socket file
Your username
YOUR FULL USER_NAME ACCOUNT NAME
\ A LITERAL ` BACKSLASH CHARACTER
A NEWLINE CHARACTER
A TAB CHARACTER
A SPACE (A SPACE FOLLOWS THE BACKSLASH)
_ A SPACE
R THE CURRENT TIME, IN 24-HOUR MILITARY TIME (0-23)
THE CURRENT TIME, STANDARD 12-HOUR TIME (1-12)
M MINUTES OF THE CURRENT TIME
Y THE CURRENT YEAR, TWO DIGITS
Y THE CURRENT YEAR, FOUR DIGITS
D THE FULL CURRENT DATE
S SECONDS OF THE CURRENT TIME
W THE CURRENT DAY OF THE WEEK IN THREE-LETTER FORMAT (MON, TUE, ...)
P AM/PM
O THE CURRENT MONTH IN NUMERIC FORMAT
O THE CURRENT MONTH IN THREE-LETTER FORMAT (JAN, FEB, ...)
IA COUNTER THAT INCREMENTS FOR EACH STATEMENT YOU ISSUE
S SEMICOLON'SINGLE QUOTE"DOUBLE QUOTE.PP ` FOLLOWED BY
ANY OTHER LETTER JUST BECOMES THAT LETTER.
IF YOU SPECIFY THE PROMPT COMMAND WITH NO ARGUMENT, MYSQL
RESETS THE PROMPT TO THE DEFAULT OF MYSQL>.
YOU CAN SET THE PROMPT IN SEVERAL WAYS:
O USE AN ENVIRONMENT VARIABLE
YOU CAN SET THE MYSQL_PS1 ENVIRONMENT VARIABLE TO A
PROMPT STRING. FOR EXAMPLE:
SHELL> EXPORT MYSQL_PS1="(@H) [D]> "
O USE AN OPTION FILE
YOU CAN SET THE PROMPT OPTION IN THE [MYSQL] GROUP OF
ANY MYSQL OPTION FILE, SUCH AS /ETC/MY.CNF OR THE FILE
IN YOUR HOME DIRECTORY. FOR EXAMPLE:
[MYSQL]
PROMPT=(\U@\H) [\D]>\_
IN THIS EXAMPLE, NOTE THAT THE BACKSLASHES ARE DOUBLED.
IF YOU SET THE PROMPT USING THE PROMPT OPTION IN AN
OPTION FILE, IT IS ADVISABLE TO DOUBLE THE BACKSLASHES
WHEN USING THE SPECIAL PROMPT OPTIONS. THERE IS SOME
OVERLAP IN THE SET OF ALLOWABLE PROMPT OPTIONS AND THE
SET OF SPECIAL ESCAPE SEQUENCES THAT ARE RECOGNIZED IN
OPTION FILES. (THESE SEQUENCES ARE LISTED IN
SECTION 3.2, "USING OPTION FILES".) THE OVERLAP MAY
CAUSE YOU PROBLEMS IF YOU USE SINGLE BACKSLASHES. FOR
EXAMPLE, S IS INTERPRETED AS A SPACE RATHER THAN AS
THE CURRENT SECONDS VALUE. THE FOLLOWING EXAMPLE SHOWS
HOW TO DEFINE A PROMPT WITHIN AN OPTION FILE TO INCLUDE
THE CURRENT TIME IN HH:MM:SS> FORMAT:
[MYSQL]
PROMPT="\R:\M:\S> "
O USE A COMMAND-LINE OPTION
YOU CAN SET THE --PROMPT OPTION ON THE COMMAND LINE TO
MYSQL. FOR EXAMPLE:
SHELL> MYSQL --PROMPT="(@H) [D]> "
(USER) [DATABASE]>
O INTERACTIVELY
YOU CAN CHANGE YOUR PROMPT INTERACTIVELY BY USING THE
PROMPT (OR R) COMMAND. FOR EXAMPLE:
MYSQL> PROMPT (@H) [D]>_
PROMPT SET TO '(@H) [D]>_'
(USER) [DATABASE]>
(USER) [DATABASE]> PROMPT
RETURNING TO DEFAULT PROMPT OF MYSQL>
MYSQL>
EXECUTING SQL STATEMENTS FROM A TEXT FILE
THE MYSQL CLIENT TYPICALLY IS USED INTERACTIVELY, LIKE
THIS:
SHELL> MYSQL DB_NAME
HOWEVER, IT IS ALSO POSSIBLE TO PUT YOUR SQL STATEMENTS IN
A FILE AND THEN TELL MYSQL TO READ ITS INPUT FROM THAT
FILE. TO DO SO, CREATE A TEXT FILE TEXT_FILE THAT CONTAINS
THE STATEMENTS YOU WISH TO EXECUTE. THEN INVOKE MYSQL AS
SHOWN HERE:
SHELL> MYSQL DB_NAME < TEXT_FILE
YOU CAN ALSO START YOUR TEXT FILE WITH A USE DB_NAME
STATEMENT. IN THIS CASE, IT IS UNNECESSARY TO SPECIFY THE
DATABASE NAME ON THE COMMAND LINE:
SHELL> MYSQL < TEXT_FILE
IF YOU ARE RUNNING MYSQL, YOU CAN EXECUTE AN SQL SCRIPT
FILE USING THE SOURCE OR . COMMAND:
MYSQL> SOURCE FILENAME
MYSQL> . FILENAME
SOMETIMES YOU MAY WANT YOUR SCRIPT TO DISPLAY PROGRESS
INFORMATION TO THE USER; FOR THIS YOU CAN INSERT SOME
LINES LIKE
SELECT '' AS ' ';
WHICH OUTPUTS .
FOR MORE INFORMATION ABOUT BATCH MODE, SEE SECTION 5,
"USING MYSQL IN BATCH MODE".
FBMYSQLFR TIPS
THIS SECTION DESCRIBES SOME TECHNIQUES THAT CAN HELP YOU
USE MYSQL MORE EFFECTIVELY.
DISPLAYING QUERY RESULTS VERTICALLY
SOME QUERY RESULTS ARE MUCH MORE READABLE WHEN DISPLAYED
VERTICALLY, INSTEAD OF IN THE USUAL HORIZONTAL TABLE
FORMAT. QUERIES CAN BE DISPLAYED VERTICALLY BY TERMINATING
THE QUERY WITH G INSTEAD OF A SEMICOLON. FOR EXAMPLE,
LONGER TEXT VALUES THAT INCLUDE NEWLINES OFTEN ARE MUCH
EASIER TO READ WITH VERTICAL OUTPUT:
MYSQL> SELECT * FROM MAILS WHERE LENGTH(TXT) < 300 LIMIT 300,1G
*************************** 1. ROW ***************************
MSG_NRO: 3068
DATE: 2000-03-01 23:29:50
TIME_ZONE: +0200
MAIL_FROM: MONTY
REPLY: MONTY.SPAM.COM
MAIL_TO: "THIMBLE SMITH"
SBJ: UTF-8
TXT: >>>>> "THIMBLE" == THIMBLE SMITH WRITES:
THIMBLE> HI. I THINK THIS IS A GOOD IDEA. IS ANYONE FAMILIAR
THIMBLE> WITH UTF-8 OR UNICODE? OTHERWISE, I'LL PUT THIS ON MY
THIMBLE> TODO LIST AND SEE WHAT HAPPENS.
YES, PLEASE DO THAT.
REGARDS,
MONTY
FILE: INBOX-JANI-1
HASH: 190402944
1 ROW IN SET (0.09 SEC)
USING THE --SAFE-UPDATES OPTION
FOR BEGINNERS, A USEFUL STARTUP OPTION IS --SAFE-UPDATES
(OR --I-AM-A-DUMMY, WHICH HAS THE SAME EFFECT). IT IS
HELPFUL FOR CASES WHEN YOU MIGHT HAVE ISSUED A DELETE FROM
TBL_NAME STATEMENT BUT FORGOTTEN THE WHERE CLAUSE.
NORMALLY, SUCH A STATEMENT DELETES ALL ROWS FROM THE
TABLE. WITH --SAFE-UPDATES, YOU CAN DELETE ROWS ONLY BY
SPECIFYING THE KEY VALUES THAT IDENTIFY THEM. THIS HELPS
PREVENT ACCIDENTS.
WHEN YOU USE THE --SAFE-UPDATES OPTION, MYSQL ISSUES THE
FOLLOWING STATEMENT WHEN IT CONNECTS TO THE MYSQL SERVER:
SET SQL_SAFE_UPDATES=1,SQL_SELECT_LIMIT=1000, SQL_MAX_JOIN_SIZE=1000000;
SEE SECTION 5.3, "SET SYNTAX".
THE SET STATEMENT HAS THE FOLLOWING EFFECTS:
O YOU ARE NOT ALLOWED TO EXECUTE AN UPDATE OR DELETE
STATEMENT UNLESS YOU SPECIFY A KEY CONSTRAINT IN THE
WHERE CLAUSE OR PROVIDE A LIMIT CLAUSE (OR BOTH). FOR
EXAMPLE:
UPDATE TBL_NAME SET NOT_KEY_COLUMN=VAL WHERE KEY_COLUMN=VAL;
UPDATE TBL_NAME SET NOT_KEY_COLUMN=VAL LIMIT 1;
O ALL LARGE SELECT RESULTS ARE AUTOMATICALLY LIMITED TO
1,000 ROWS UNLESS THE STATEMENT INCLUDES A LIMIT
CLAUSE.
O MULTIPLE-TABLE SELECT STATEMENTS THAT PROBABLY NEED TO
EXAMINE MORE THAN 1,000,000 ROW COMBINATIONS ARE
ABORTED.
TO SPECIFY LIMITS OTHER THAN 1,000 AND 1,000,000, YOU CAN
OVERRIDE THE DEFAULTS BY USING --SELECT_LIMIT AND
--MAX_JOIN_SIZE OPTIONS:
SHELL> MYSQL --SAFE-UPDATES --SELECT_LIMIT=500 --MAX_JOIN_SIZE=10000
DISABLING MYSQL AUTO-RECONNECT
IF THE MYSQL CLIENT LOSES ITS CONNECTION TO THE SERVER
WHILE SENDING A QUERY, IT IMMEDIATELY AND AUTOMATICALLY
TRIES TO RECONNECT ONCE TO THE SERVER AND SEND THE QUERY
AGAIN. HOWEVER, EVEN IF MYSQL SUCCEEDS IN RECONNECTING,
YOUR FIRST CONNECTION HAS ENDED AND ALL YOUR PREVIOUS
SESSION OBJECTS AND SETTINGS ARE LOST: TEMPORARY TABLES,
THE AUTOCOMMIT MODE, AND USER AND SESSION VARIABLES. THIS
BEHAVIOR MAY BE DANGEROUS FOR YOU, AS IN THE FOLLOWING
EXAMPLE WHERE THE SERVER WAS SHUT DOWN AND RESTARTED
WITHOUT YOU KNOWING IT:
MYSQL> SET =1;
QUERY OK, 0 ROWS AFFECTED (0.05 SEC)
MYSQL> INSERT INTO T VALUES();
ERROR 2006: MYSQL SERVER HAS GONE AWAY
NO CONNECTION. TRYING TO RECONNECT...
CONNECTION ID: 1
CURRENT DATABASE: TEST
QUERY OK, 1 ROW AFFECTED (1.30 SEC)
MYSQL> SELECT * FROM T;
+------+
| A |
+------+
| NULL |
+------+
1 ROW IN SET (0.05 SEC)
THE USER VARIABLE HAS BEEN LOST WITH THE CONNECTION,
AND AFTER THE RECONNECTION IT IS UNDEFINED. IF IT IS
IMPORTANT TO HAVE MYSQL TERMINATE WITH AN ERROR IF THE
CONNECTION HAS BEEN LOST, YOU CAN START THE MYSQL CLIENT
WITH THE --SKIP-RECONNECT OPTION.
FOR MORE INFORMATION, PLEASE REFER TO THE MYSQL REFERENCE
MANUAL, WHICH MAY ALREADY BE INSTALLED LOCALLY AND WHICH
IS ALSO AVAILABLE ONLINE AT HTTP://DEV.MYSQL.COM/DOC/.
AUTHOR
MYSQL AB (HTTP://WWW.MYSQL.COM/). THIS SOFTWARE COMES
WITH NO WARRANTY.
Samsung's Galaxy Tab could have an unsubsidized price high enough that it would be more expensive than most any Apple model, based on early if unconfirmed claims. The French at Journal du Geek were quoted a price of 699 euros with tax for the 16GB version, or $895. At this level, it would cost as much as a 32GB, 3G iPad does despite the smaller screen....
The Walt Disney Co. and Time Warner have established a long-term agreement that will continue to bring a wide range of Disney programming to Time Warner cable subscribers. The terms of the deal will allow subscribers to access a variety of online content and video-on-demand services....
Apple appears to be the only company immune from a falloff in notebook shipments for the month of July, according to a report from Digitimes Research senior analyst Joanne Chien. HP is said to be the hardest hit, with notebook shipments expected to reach only 39.5 million units by the end of the year. The company had set a goal of 45-47 million units....
I can't stop looking at this photo of talented cartoonist Pete Emslie posing with my favorite Catwoman, the beautiful Julie Newmar.
Apple has released a third preview of Xcode 4, the latest set of developer tools for Mac OS and iOS platforms. Version 4 transitions to a single-winder interface, combining a navigation toolbar, which offers search and list content, with a Jump Bar that can be used to quickly switch between various levels....
Toshiba has revealed new SDHC memory cards with the Ultra High Speed I (UHS-I) standard that enables them to reach maximum data read rates of 95MBps and write speeds of 80MBps. This makes them the fastest SDHC UHS-I memory cards in the world. The cards can thus far only use these speeds in USB 3.0 readers, as no camera can fully use their performance....
Compal president Ray Chen told those at an investors' meeting that he expects the fledgling tablet industry to undergo a major thinning effect for all but Apple's iPad in 2011. He saw the entire competition moving just 10 million to 12 million tablets next year where many expect Apple to reach those numbers in 2010 with only eight months of sales. The poor results will likely see some companies quit the market after just a year, DigiTimes heard, because they falsely assumed they would automatically succeed....