On Thu, Mar 1, 2012 at 8:57 AM, Shawn L Green wrote:
> 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.PHON
On Wed, Oct 19, 2011 at 12:29 PM, Michael Dykman 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 developer who
On Thu, Mar 10, 2011 at 5:05 PM, Jim McNeely 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 depth and breadth of
On Wed, Sep 15, 2010 at 12:10 PM, Gary Roach wrote:
> 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 (supercrunch)
> is being used as t
On Thu, Feb 11, 2010 at 8:56 AM, Martijn Tonies wrote:
> 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 professor gives to
>
On Mon, Dec 28, 2009 at 5:41 PM, Carsten Pedersen wrote:
> David Giragosian skrev:
>
>> On Mon, Dec 28, 2009 at 2:32 PM, D. Dante Lorenso
>> wrote:
>>
>> Will anything ever be equal to NULL in a SELECT query?
>>>
>>
> ...
>
> What's s
On Mon, Dec 28, 2009 at 2:32 PM, D. Dante Lorenso 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 = 'abc';
On Sat, Dec 12, 2009 at 9:54 AM, Victor Subervi wrote:
> 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
David
--
There is
On Fri, Oct 2, 2009 at 10:53 AM, Victor Subervi wrote:
> 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
>
> Please note
On Tue, Sep 29, 2009 at 11:09 AM, Victor Subervi wrote:
> 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
>
CREATE TA
On 4/27/09, Jason Todd Slack-Moehrle 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 get:
>
> r...@serv
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 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 IN (SELECT bookID
>
On 3/19/09, Jim Lyons 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
>
>
> However, t
On 1/7/09, Jim Lyons 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 for more effici
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 j
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]> wrote:
>
> Monty Widenius (MySQL co-founder who recently left Sun)...
What's the news on this?
David
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 applica
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 i
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
On Wed, Sep 17, 2008 at 12:47 PM, [EMAIL PROTECTED]
<[EMAIL PROTECTED]>wrote:
> Hi,
>
> What's in the bin-logs? (mysqlbinlog )
>
> 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 t
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, Mar
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.
Th
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
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 t
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
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 a
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 support
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:
> > > "headlin
31 matches
Mail list logo