On Thu, Mar 1, 2012 at 8:57 AM, Shawn L Green shawn.l.gr...@oracle.comwrote:
On 2/29/2012 5:54 PM, LUCi5R wrote:
JW,
I'm trying to understand LEFT JOIN as we go - but it's not working.
This query
SELECT *
FROM CUSTOMERS
LEFT JOIN CALLS ON CUSTOMERS.PHONE = CALLS.PHONE
WHERE
On Wed, Oct 19, 2011 at 12:29 PM, Michael Dykman mdyk...@gmail.com wrote:
While we have him online, I think we could all take a moment and be
grateful
for the contributions of Shawn Green.
When I see the Oracle-bashing on this list, I am often reminded that we
still have a hard-core MySQL
On Thu, Mar 10, 2011 at 5:05 PM, Jim McNeely j...@newcenturydata.com wrote:
Shawn Green works for Oracle and has been very helpful, and I am happy to
eat a little bit of shoe leather!
Thanks Shawn!
Jim
Check the archives for Shawn's posts. IMNSHO, they are unparalleled in
clarity and
On Wed, Sep 15, 2010 at 12:10 PM, Gary Roach gary719_li...@verizon.netwrote:
I'm attempting to set up a Linux Apache Mysql PHP (LAMP) system for the
first time. On my internal network (behind firewall) I have a computer
(cruncher) that is acting as the web server. Another computer
On Thu, Feb 11, 2010 at 8:56 AM, Martijn Tonies m.ton...@upscene.comwrote:
Hello John,
About 5 years ago, I was asked to write a php app for my department. The
app keeps track of graduate school applicants to my department at the
university. The main data elements are the scores each
On Mon, Dec 28, 2009 at 2:32 PM, D. Dante Lorenso da...@lorenso.com wrote:
Will anything ever be equal to NULL in a SELECT query?
SELECT *
FROM sometable
WHERE somecolumn = NULL;
I have a real-life query like this:
SELECT *
FROM sometable
WHERE somecolumn = NULL OR somecolumn =
On Mon, Dec 28, 2009 at 5:41 PM, Carsten Pedersen cars...@bitbybit.dkwrote:
David Giragosian skrev:
On Mon, Dec 28, 2009 at 2:32 PM, D. Dante Lorenso da...@lorenso.com
wrote:
Will anything ever be equal to NULL in a SELECT query?
...
What's so special about NULL?
http
On Sat, Dec 12, 2009 at 9:54 AM, Victor Subervi victorsube...@gmail.comwrote:
Hi;
I have a column defined as a set. How do I insert data into that column?
Please give me an example.
TIA,
Victor
Lots of examples here:
http://dev.mysql.com/tech-resources/articles/mysql-set-datatype.html
On Fri, Oct 2, 2009 at 10:53 AM, Victor Subervi victorsube...@gmail.comwrote:
Hi;
I get the following error:
*SQL query:*
SELECT ID, Item
FROM products
JOIN categories ON categories.ID = products.Category
LIMIT 0 , 30;
*MySQL said:*
#1052 - Column 'ID' in field list is ambiguous
On Tue, Sep 29, 2009 at 11:09 AM, Victor Subervi victorsube...@gmail.comwrote:
Hi;
Please give me the syntax below such that I can force the insert statements
to use only selected values (item1, item2, item3):
create table (field SOMETHING_HERE item1 item2 item3,
...
)
TIA,
Victor
On 4/27/09, Jason Todd Slack-Moehrle mailingli...@mailnewsrss.com wrote:
Hi All,
CentOS 5.3
I installed MySQL Server via yum and started it.
I tried entering:
mysqladmin -u root password yourrootsqlpassword
mysqladmin -h server1.example.com -u root password yourrootsqlpassword
But I
I would recommend PilotPig http://www.pilotpig.net/
Good service, good support, reasonably priced, and integrity to boot.
David
On Wed, Apr 1, 2009 at 1:27 PM, PJ af.gour...@videotron.ca wrote:
I am trying to select all books whose authors last names begin with I, J
or K. I have 3 tables: book, author and book_author. The following query
works with one condition but not with three.
SELECT * FROM book
WHERE id
On 3/19/09, Jim Lyons jlyons4...@gmail.com wrote:
I have a rather odd problem with a replication slave.
The slave has been down for a number of hours. Of course, both io and sql
threads are stopped - from SHOW SLAVE STATUS:
Slave_IO_Running: No
Slave_SQL_Running: No
On 1/7/09, Jim Lyons jlyons4...@gmail.com wrote:
There are other factors. If a table is completely fixed in size it makes
for a faster lookup time since the offset is easier to compute. This is
true, at least, for myisam tables. All books on tuning that I have read
have said the CHAR makes
On 12/5/08, Lola J. Lee Beno [EMAIL PROTECTED] wrote:
I'm trying to create a trigger (5.0.45) and I've read the documentation at
mysql.com. I keep getting a syntax error, but can't figure out what the
error is. Here's the trigger I'm trying to create:
delimiter //
create trigger
On 12/1/08, Daevid Vincent [EMAIL PROTECTED] wrote:
Monty Widenius (MySQL co-founder who recently left Sun)...
What's the news on this?
David
Thanks. Just finished the blog, and I think I'm getting the drift.
On 12/1/08, Daevid Vincent [EMAIL PROTECTED] wrote:
Do a quick google search for Monty Widenius left sun and behold...
On Mon, 2008-12-01 at 13:45 -0600, David Giragosian wrote:
On 12/1/08, Daevid Vincent [EMAIL PROTECTED
On 11/21/08, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
I have a PHP application that accesses data from MySQL. There is table
called rooms, and table called beds. There is another table called
patients. Patients are being placed into beds, and beds are in the
rooms. PHP application
On Sat, Oct 4, 2008 at 11:33 AM, Varuna Seneviratna
[EMAIL PROTECTED] wrote:
What is the user account's password.I used the command
C:\mysql -u user -p
Enter password: **
ERROR 1045 (28000): Access denied for user 'user'@'localhost' (using
password: Y
ES)
How can I find it?
On Fri, Sep 26, 2008 at 1:54 AM, Aaron Blew [EMAIL PROTECTED] wrote:
Hi Michael,
Overall and most of the time, SANs are a good thing. They have several
advantaged over dedicated directly attached storage arrays:
1.) They're generally a lot smarter about how and when they write and read
to
Hurricane Ike has caused our replication set-up to misbehave.
I've stopped the (one and only) application that inserts data into the
master, but show master status's 'position' field continues to increment.
Have I missed something or is this unexpected behavior?
version 5.0.22 on CentOS 5.
On Wed, Sep 17, 2008 at 12:54 PM, Martin Gainty [EMAIL PROTECTED] wrote:
Dave-
we havent had a hurricane since up here since 1938..if you want to relocate
your servers just give a holler
and i'll lend you mine!
Martin
__
Thanks, Martin. Wish
On Wed, Sep 17, 2008 at 12:47 PM, [EMAIL PROTECTED]
[EMAIL PROTECTED]wrote:
Hi,
What's in the bin-logs? (mysqlbinlog log)
cheers,
Doug
Doug,
We capture time-sensitive data, and after checking all the counts on tables
known to accept inserts, I restarted the server. That stopped the
On 9/11/08, Ryan Stille [EMAIL PROTECTED] wrote:
Thank you for the link Darryle, but I don't think you read through my whole
question. I have already read through that page, and I see how to use regex
as a condition for a select. What I am interested in is applying a regex to
a column as I
I've extracted text from approx 1600 pdf files using pdftotext.exe and
inserted it into a table.
Now I see there are form feed characters in the field, and I would suspect
other special characters, also.
I'm not having much luck trying to remove them.
Any pointers appreciated.
Thanks,
David
On 8/10/08, Jim Lyons [EMAIL PROTECTED] wrote:
you should probably just resync your slave. If it hasn't run for over a
month then there's not a lot of point in trying to start it up. Even if
you
did start the slave (which seems doubtful) you'd have over a month's worth
of commands to make
On 8/8/08, AndrewMcHorney [EMAIL PROTECTED] wrote:
Hello
I tried to login using localhost and root as user id with no password since
I temporarily did not enter one when I installed the software. I am getting
the following error message:
MySQL Error Number 1045
Access denied for user
On 8/7/08, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Hello
I successfully installed the mysql database on my pc. I also installed the
mysql administrator tool. I am trying to login and I need some assistance.
It is asking for stored connection, server host, username and password. I am
not
On 7/21/08, Moon's Father [EMAIL PROTECTED] wrote:
Any reply is appreciated .
--
I'm a MySQL DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn
Maybe something to do with this: *BDB support will be removed. * Note that,
as of MySQL 5.1, BDB isn't supported any
On 6/12/08, Tim Johnson [EMAIL PROTECTED] wrote:
On Thursday 12 June 2008, Warren Young wrote:
Tim Johnson wrote:
Not sure what you mean by directly usable.
I mean directly usable. :)
If I do an insert statement with a backslash, for example:
headline\one, I will retrieve
31 matches
Mail list logo
