stargeek
PHP news website logo.
home    PHP scripts    articles    seo tools    links    search    contact    shop    realtors


O'Reilly: A Crash Course in MySQL (and SQL)







O'Reilly: A Crash Course in MySQL (and
SQL)

O'Reilly: A Crash Course in MySQL (and
SQL)
12/24/2003 07:05 PM

The O'Reilly Network has posted the latest piece from John Coggeshall - MySQL Crash Course.




This is a GrokNews Entry: (what is grok?)





Similar Items

O'Reilly: A Crash Course in MySQL (and SQL)

Grok Headline matches for O'Reilly: A Crash Course in MySQL (and SQL)

O'Reilly: MySQL Crash Course, Part 2


O'Reilly: MySQL Crash Course, Part 2 01/09/2004 10:08 PM
In part 2 of his "MySQL Crash Course" series, John Coggeshall builds on his previous article and moves on to introduce the UPDATE, DELETE, ALTER, and DROP statements, as well as a few new clauses to the SELECT statement.

Abriasoft partners with O'Reilly to
release box packaged distribution of
MySQL


Abriasoft partners with O'Reilly to
release box packaged distribution of
MySQL
06/12/2002 06:22 AM
AbriaSoft, a Silicon Valley provider of database solutions, today announced its release of Abria SQL Standard, the company's first packaged MySQL distribution. Abriasoft also announced a partnership with O'Reilly & Associates, including the book "MySQL and mSQL", written by Randy Jay Yarger et al. in their distribution.

MySQL Crash Course


MySQL Crash Course 12/23/2003 08:04 PM
Almost every serious web application uses a relational database to store its data. At some point, you'll have to learn how to use them. John Coggeshall explains the basics of relational databases with MySQL.

MySQL Crash Course, Part 3


MySQL Crash Course, Part 3 02/10/2004 02:42 AM
Almost every serious web application uses a relational database to store its data. At some point, you'll have to learn how to use them. John Coggeshall explains how to make the most of the SQL SELECT statement across multiple tables.

MySQL Crash Course, Part 2


MySQL Crash Course, Part 2 01/09/2004 09:51 PM
Almost every serious web application uses a relational database to store its data. At some point, you'll have to learn how to use it. John Coggeshall explains how to change tables, select only the data you want, and delete rows from MySQL.

EnGarde Secure Linux Advisory: MySQL,
MySQL-client, MySQL-shared, mod_php, php


EnGarde Secure Linux Advisory: MySQL,
MySQL-client, MySQL-shared, mod_php, php
12/16/2002 04:17 PM
"Stefan Esser from the PHP.net project discovered two vulnerabilities in MySQL which range from crashing the server to executing arbitrary code as the user under which the MySQL daemon runs (mysql)..."

O'Reilly Network: O'Reilly Network --
2004 Emerging Technology Conference
Coverage [Jan. 16, 2004]


O'Reilly Network: O'Reilly Network --
2004 Emerging Technology Conference
Coverage [Jan. 16, 2004]
02/11/2004 08:18 AM
O'Reilly Network: O'Reilly Network -- 2004 Emerging Technology Conference Coverage [Jan. 16, 2004] .. the DDTI's own aggregation page

oreillynet.com/et2004
track this site | 6 links


SearchEnterpriseLinux: MySQL CEO: Open
Source MySQL Will Rise, Legal Foes Will
Fall


SearchEnterpriseLinux: MySQL CEO: Open
Source MySQL Will Rise, Legal Foes Will
Fall
02/01/2005 09:06 PM
"None of the legal attacks on open source or Linux have been successful. None of that stuff has gone anywhere. That's the biggest story..."

Crash Test Videos - View Crash Test
Videos for Cars, Trucks and SUVs -
Insurance Resource Center


Crash Test Videos - View Crash Test
Videos for Cars, Trucks and SUVs -
Insurance Resource Center
04/02/2005 07:32 AM
See how your car would fare in a crash .. Various Test Crashes .. Crash Test Videos .. Progressive

progressive.com/RC/VSafety/rc_crash_videos.asp
track this site | 2 links


MySQL: MySQL Administrator Announced


MySQL: MySQL Administrator Announced 01/22/2004 10:26 AM
In a startling new note from the MySQL development team, information about their newest application has been posted on their site.

MySQL: MySQL Administrator Now Availible


MySQL: MySQL Administrator Now Availible 02/12/2004 10:10 AM
In a new note passed along to me from MarkL this morning, there's some new information about the admin tool that the MySQL folks have created.

MySQL: MySQL 4.0.20 Released


MySQL: MySQL 4.0.20 Released 05/20/2004 06:59 PM
"MySQL 4.0.20, a new version of the popular Open Source/Free Software Database Management System, has been released..."

MySQL: PHP and MySQL Get a Little Closer


MySQL: PHP and MySQL Get a Little Closer 02/18/2003 04:17 PM

MySQL: MySQL 5.0.0 Has Been Released


MySQL: MySQL 5.0.0 Has Been Released 12/26/2003 07:47 PM
"MySQL 5.0.0, a new version of the popular Open Source/Free Software Database Management System, has been released..."

MIT vs. Tim O'Reilly


MIT vs. Tim O'Reilly 02/10/2004 02:56 AM
The MIT technology review just published this interesting article on the 10 Emerging Technologies That Will Change Your World (registration required). It's a good article to read in preparation for the O'Reilly Emerging Technologies Conference that I'm going to next week. It is interesting to contrast Tim O'Reilly's vision with MIT -- O'Reilly is much more centered around software and the sociology and politics of software, with a little bit on hardware and biology, while MIT's article selects technology to highlight from a somewhat broader field....

O'Reilly Radar


O'Reilly Radar 02/10/2004 01:17 PM
I've heard this talk a couple of times, so Im just listening for something new and cool Timisms. One bit of commentary, its great that wikis are on the O'Reilly Radar, but there is an even better reason for it...

The O'Reilly Radar


The O'Reilly Radar 10/29/2003 12:13 AM

O'Reilly OS X Conference Day One


O'Reilly OS X Conference Day One 10/29/2003 12:13 AM

O'Reilly OS X Conference Day Three


O'Reilly OS X Conference Day Three 10/30/2003 12:34 PM

O'Reilly: Using PHP 5's SimpleXML


O'Reilly: Using PHP 5's SimpleXML 01/16/2004 10:58 AM
NuCleuZ wrote in to tell us about a new article posted over on the O'Reilly Network for all of those out there looking forward to the quick and easy XML features coming in PHP 5.

O'Reilly OS X Conference Day Two


O'Reilly OS X Conference Day Two 10/29/2003 02:21 AM

O'Reilly and the Cold War


O'Reilly and the Cold War 12/19/2004 03:40 PM
Thanks for the amazingly thoughtful and interesting comments on the O'Reilly show. I want to answer one questions about that because several people raised it: Why would any sensible person agree to be a guest on that show? Truth be told, I've always in the past declined to be on the Factor and other shows like it. I agreed this time because the issue "Is dissent disloyal?" is important, I've thought a lot about it, and I thought I might be able to contribute something useful. And I would have, had he not changed the issue! But, since the main thrust of my guest stint on this blog is learning lessons from past mistakes, I won't do it again! (The reason, by the way, is not because it's unpleasant, but because no one should allow himself to be used by a demagogue.) Speaking of which, let's return to our history. We left off with the Japanese internment. As several comments noted, the Supreme Court in 1944 upheld the internment in the case of Korematsu v. United States. In effect, the Court held that, in wartime, we all have to make sacrifices, and it couldn't say that the decision to internment these people was not a rational military decision at the time it was made. Korematsu has gone down as one of the most profoundly embarrassing decisions in the history of the Supreme Court, and the nation has in many ways confessed the unconstitutionality of the internment in the sixty years since the decision. (As an interesting aside, by the way, I sumbitted a friend of the Court brief on behalf of Fred Korematsu --he is still alive and flourishing -- in the Guanatamo Bay, Hamdi, and Padilla cases in the Supreme Court last spring.) At the end of World War II, Americans were optimistic. We had the strongest military in the world, we had just won a "great" war and we had clearly been on the side of the angels. The world was at peace. Within a short time, however, everything changed. Although the Soviet Union had been our ally during the war, relations collapsed beween the U.S. and the Soviet Union as the need for that alliance disappeared. Within a stunningly short period of time, the American economy took a nosedive, there were revelations of Soviet espionage, the Soviet Union exploded its first atomic bomb, China fell to the Communists, Americans began to build bomb shelters as they prepared by nuclear bombs to rain down upon our cities, and the Korean War burst upon the scene. Who was to blame? How did the Soviets get the bomb? Why had China fallen to the Communists? A group of anti-New Deal Republicans and conservative Southern Democrats had the answer -- it was American Communists who had sold us out and were working to further the Soviet cause. Men like Richard Nixon in California and Joseph McCarthy in Wisconsin began to play the Red Card in order to get elected, and they did. In the 1946 elections, the Republicans, who now portrayed the choice as one between Communism and Republicanism, picked up 54 seats in the House. After being out of power for 16 long years, the Republicans had found a strategy that could propel them back into power. Democrats, who were overwhelmed by the growing anti-Communist hysteria, jumped on the bandwagon, afraid to resist. Within a few short years the United States had a new federal loyalty program for over four million government employees, the House Un-American Activities Committee investigated thousands of individuals to determine if they were secret Communists, state and federal governments adopted their own loyalty programs, investigations, blacklists, and anti-Communist laws. Tens of thousands of people were threatened, intimidated, fired, humiliated, and even prosecuted. Who were these people? Were they spies and sabotuers? No doubt, there were Soviet agents in the United States. But they were almost never the target of these actions. They were too well-hidden for that. Rather, these actions were cynical efforts to make political hay by taking advantage of, and exacerbating, the fear that was already upon the land. So, who were these people? After the Depression, many Americans began to search for answers to what had happened to the nation. Many toyed with communism. At this time, the Communist Part of the United States was a lawful political party that ran candidates for public office throughout the nation. It stood for such causes as women's rights, the rights of labor, and public housing; it opposed the rise of fascism in Europe and racism at home. As many as 250,000 Americans joined the CPUSA in this period. Moreover, many millions more participated in CPUSA events or joined other organization that shared some of the goals and programs of the CPUSA. During World War II, we fought side-by-side with the Soviet Union, and FDR encouraged Americans to see the Soviets as our allies and friends. After the war, though, all this fell apart. And suddenly the most dangerous question in America was: "Are you now or have you ever been a member of the Communist Party or a member of any organization that is or was affiliated with the Commnist Party or have you ever attended an event sponored by the Communist Party, or signed a Communist Party petition, or attended a Communist Party rally, or read a Communist book?" An affirmative answer to any of these questions would immediately cast doubt on the patriotism and loyalty of the individual. After all, how do we know you're not still a Commie who is secretly working to subvert the government of the United States. This was the heart of McCarthyism.

The O'Reilly Factor


The O'Reilly Factor 12/19/2004 03:40 PM
I'll get back to the history tomorrow (Saturday). For now, though, I want to tell you about my experience tonight as a guest on the Bill O'Reilly show. I received a call this afternoon (Friday) from the producer inviting me to debate O'Reilly on the question: “Is dissent disloyal?” After the producer and I discussed this issue, O’Reilly (according to the producer) decided to redefine the question: “Can an American want the United States to lose the war in Iraq and still be patriotic?” Of course, this is a loaded question. It not-so-subtly implies that those who oppose the war want the United States to lose and, even worse, want American soldiers to die. One of Joseph McCarthy’s favorite tactics was to imply that anyone who believed in the social or economic principles of communism also supported the violent overthrow of the government. The tactic of guilt-by-inference is all-too-familiar in American history. (I'll return to McCarthyism in my next entry.) In any event, in our “debate” O’Reilly insisted on his “narrow” framing of the question and, when I called him on the issue, denied that he intended to imply anything about those who merely oppose the war. I accepted his framing of the question (it is, after all, his show) and argued that a patriotic citizen could in principle want the nation to lose a war if the war is unjust and if losing meant that fewer American soldiers would die for no good reason. O'Reilly maintained that losing a war necessarily means that more American soldiers will die than continuing the war and that no one could therefore patriotically wants the nation to lose. O’Reilly tossed out such ugly phrases as “despicable,” “traitor,” and “disloyal” to describe those who would disagree. The purpose, of course, was to excite his audience. After the show, I received dozens of emails, most of which were along the following lines: “You ought to be arrested, tried, convicted of wartime treason. And I don't have to tell you the penalty for that.” “I hope they are checking you out for being a traitor!!!” “You are not only despicable, but should go ahead and move out of the USA.” “I must imagine, Mr. Stone, that you will look over your shoulder a little bit, because maybe some soldier in a foxhole somewhere might be a tad angered with you and your lunacy. There may be a few G.I.s in Chicago even that would like to ‘speak’ with you.” “There is the tendency for citizens to take the law into their own hands in these cases. Decent, ordinary people, not of the left, are angry enough at the far left to be willing to go along with things you would consider unconscionable.” “You're a despicable Piece of feces, A Gutless Traitor. and I strongly suggest that you get your Terrorist Sympathizing Worthless ass out of this country while you can still walk and talk.” And so on. What do you make of all this in light of our on-going conversation?

O'Reilly Network:


O'Reilly Network: 07/30/2004 02:58 AM
O'Reilly has a page up about their new magazine called Make

make.oreilly.com
track this site | 6 links


I Hacked at O'Reilly


I Hacked at O'Reilly 03/19/2003 10:24 PM
The O'Reilly Hacks site now has a hacks page for each contributor; mine's here.

Hacks.O'Reilly.com


Hacks.O'Reilly.com 03/11/2003 09:43 AM
The full-blown version of O'Reilly's Hacks Series site is now up at hacks.oreilly.com. In addition to info about the current crop of books (Linux Server, Google, Mac OS X), there are listings of published hacks, some complete hacks, and each has its own discussion forum.

Gotta Hack? Got a non-obvious solution to an interesting problem? Throw your hack into the ring and it just might be in a Hacks book-to-be. Not a hacker yourself but have a hack or Hacks book you'd like to see? Suggest it and perhaps it will be so written.

CC at O'Reilly Etech


CC at O'Reilly Etech 02/10/2004 02:41 AM

Creative Commons will be an exhi bitor at the O'Reilly Emerging Technology Conference in San Diego next week.

Etech is regarded by many as the best tech conference of the year, always in step with the latest creations and aspirations of the alpha geeks, having evolved from the Peer-to-Peer Conference in early 2001 and P2P & Web Services in late 2001 to the current multi-tracked annual conference starting two years ago. (Incidentally, the Creative Commons concept was in troduced at ETCon 2002. How time flies.)

Matt Haughey and Mike Linksvayer will be attending. Stop by the Creative Commons booth, or better yet our parti cipant session (time and location yet to be announced). We'll be introducing a new CC metadata-enhanced application. Hint: it's described in one of our tech challenges, heretofore unmet.

If you're in the area but not an attendee, you can still reg ister for a free exhibits pass, or an exhibits plus keynotes and birds-of-a-feather (participant sessions) pass for only $50. Hope to see you there!


maybe o'reilly will shut up


maybe o'reilly will shut up 08/11/2004 02:55 AM
The producer strikes back. After crowing Monday about how he made mincemeat of NYT columnist Paul Krugman on The Factor, O'Reilly gets rebutted on Tuesday via quicktime on the blog of Outfoxed co-producer Jim Gilliam.

Five New Books From O'Reilly


Five New Books From O'Reilly 12/10/2003 10:25 AM

O'Reilly: Why PHP 5 Rocks!


O'Reilly: Why PHP 5 Rocks! 07/16/2004 08:27 AM
New from the O'Reilly PHP Development Center is an article about Why PHP 5 Rocks!

Mr. O'Reilly, please just stop.


Mr. O'Reilly, please just stop. 07/24/2004 01:10 PM
Mr. O'Reilly, You have declared a "war" on the New York Times. That's good for you, good for them, and good for our democracy: Strong opinions deserve strong spokesmen. Your battle will help sharpen a debate about matters important to the Republic. But in waging this "war," you are continuing to abuse a man whom you have wronged, and to whom you owe an apology. On February 4, 2003, Jeremy Glick was your guest on THE FACTOR. Glick had lost his father in the attack of 9/11. He had also signed an ad criticizing the war in Iraq. You were "surprised" that one who had lost his father could oppose that war. And so you had him on your show, presumably to ask him why. (Here's a clip from Outfoxed putting this story together.) You might not remember precisely what you said on that interview, or more importantly, what Jeremy Glick said. So here's a copy that you can watch. Nor may you remember precisely what the ad that Jeremy Glick signed said. Here's a copy that you can read. And when you've watched what was actually said, and read what was actually written, I'm sure you will see that the statements you continue to make about Jeremy Glick are just plain false. Not Bill Clinton "depends upon what is is" false, but false the way most Americans learned growing up: just not true. For example:I understand how someone loses his temper, Mr. O'Reilly. I have done the same myself. But a decent man apologizes for his lack of control, and he certainly doesn't continue to abuse someone he has wronged. Mr. Glick is not the New York Times. He will not earn more money from higher ratings because you attack him so viciously. Neither he nor his widowed mother get any benefit at all from seeing Glick slandered by your on a regular basis. You are wrong about the facts, Mr. O'Reilly. And you are wrong to continue to do such harm. Have the courage to admit your error. Apologize to Mr. Glick, and let him go back to a life that has been made difficult enough by, as you said, the "barbarians" who killed his father. This family has suffered enough from barbaric behavior.

O'Reilly Intro


O'Reilly Intro 02/10/2004 02:51 AM
Changing the world by spreading the knowledge of innovators. Digital Democracy is an emerging area of innovation. Wonderful moment to hear from the pioneers. Joe is the Edison of the Movement (Brit Blaser), although we are not sure if he...

O'Reilly: Simplify with PHP DataObjects


O'Reilly: Simplify with PHP DataObjects 08/06/2004 07:46 AM
Ever looked at your code and wondered if there was an easier way to perform the basic SQL tasks (insert, update, delete, select) without having to rewrite the SQL each time? Well, thi s new article from the O'Reilly Network aims to help you with just that.

O'reilly Releases Inside .Mac


O'reilly Releases Inside .Mac 06/03/2004 03:44 PM

O'Reilly: PHP Web Services Without SOAP


O'Reilly: PHP Web Services Without SOAP 10/31/2003 09:26 AM
Web services have to be one of the most underused parts of web development, especially in the corporate world. I can't say I've really heard of an instance where a (non-internet) company was using them for much of anything. Well, if you've been hesitant to leap into this powerful tool because you had to learn your way around SOAP, then thi s new article might just interest you.

O'Reilly On What Happened To BountyQuest


O'Reilly On What Happened To BountyQuest 11/10/2003 11:19 PM
Slashdot Nov 10 2003 11:36AM ET

O'Reilly: Searching the Sea of Pages
with PHP


O'Reilly: Searching the Sea of Pages
with PHP
10/25/2002 08:24 AM

O'Reilly Network: WURFLing Your Way to
WAP


O'Reilly Network: WURFLing Your Way to
WAP
04/15/2004 07:46 AM
Given that more and more people are connecting to sites with their moblie devices (phones, PDAs, Blackberries, etc), more and more sites are creating WAP-friendly versions of their own pages. Well, there's a project that's talked about over on the O'Reilly Network that helps that effort in leaps and bounds.

Free Books from O'Reilly


Free Books from O'Reilly 02/14/2004 11:51 PM

www.oreilly.com -- O'Reilly Open Books Project: Did you know O'Rielly publishes some free books? Man, I love free books.

Over the years, O'Reilly & Associates has published a number of "Open Books" — books with various forms of "open" copyright. The reasons for "opening" copyright, as well as the specific license agreements under which they are opened, are as varied as our authors.

There are a couple dozen, from gems like Using Samba to curiosities like Programming the Be Operating System and Embedding Perl in HTML with Mason.

Click here to comment on this entry


Grok Description matches for O'Reilly: A Crash Course in MySQL (and SQL)
GrokA matches for O'Reilly: A Crash Course in MySQL (and SQL)

O'Reilly: A Crash Course in MySQL (and SQL)

The following phrases have been identified by the grok system as matching this entry:

















Also check out:


Grok

Ipod Porn on the
Rise

Brief Abstract of
Wikipedia's
Mesothelioma Cancer
page

Get first aid
instructions in your
cell phone

IE is crap
JSPWiki gains
podcasting support

The Night before
Christmas

Gay News From
365Gay.com

FOX for Tn
Site News: Happy
Holidays

Zend: Looking Back a
Week in the Past

i'm dreaming . . .
PowerBook Trade-in
Program?

Computer
professional's house
burgled

The Best Year for
Chips Since 2000

S&P's Tech Survey,
Part 2

This Yellow Pages Is
Red-Hot Online

How You Can Thwart
ID Thieves

IBM thinks Fast for
searches

GAME REVIEW: Voodoo
Vince a Clever Time

Companies fear
publicizing savings
from outsourcing

BEA, Compuware
partner on Java
development

Feds drop probe of
music industry
online services

Report: Online
holiday sales up 46%
over last year

Survey: IT workers
expect raises in
2004

Incompatibility
Problems Could Stall
3G Phones

beep media player
0.9.6

Thy 0.8.6
(Development)

FireMake 1.9.6
(Development)

kludge3d 2003-12-24
baudline 0.97
ova 1.1.6
Biblos 0.42
(Development)

GBonds 2.0.1
Auto Directory Index
PHP Script 1.3.3

KSubtile 1.0
Skeptical
Environmentalist
Saga Continues

Microsoft settles
patent suit with SPX

Candles Blamed in
Fatal Holiday Tree
Fire

Air France Cancels
U.S.-Bound Flights
Over Security

Bush Administration
Drawing Up
Immigration Plan

Mo. Man Pleads No
Contest in Son's
Death

Pre-Christmas
Economic News Lacks
Cheer

Insurgents Hit
Baghdad Hotel After
Deadly Attacks

FDA Believes Mad Cow
Was Infected in
Birth Herd

Air France Cancels
Paris-LA Flights
Over Security

Glimmer of Christmas
Cheer in Encircled
Bethlehem

Clark Gets On
High-Tech Campaign
Bandwagon

Op-Ed Columnist:
Don’t Stop Dean

kuro5hin.org ||
Dennis Kucinich: the
Kuro5hin interview

stopping
discrimination, part
5,394--Money Talks

Happy Holidays from
MacCentral

Laptop vs. Small
Desktop: Best Bang
Per Watt?

Photo Archives:
Clone Wars Animated
Figures

Biggs Darklighter's
Final Fate!

Baldur's Gate II:
Throne of Bhaal 2.1

what is grok?