I actually get the feeling you are not connecting as root.
Try mysql -uroot -p test instead of just mysql test
Have a nice day,
- Martijn
On Wed, Aug 26, 2009 at 03:02, Joe wrote:
> OK, thanks, that got me in. But upon inspection, the user.host
> values do not look fouled up as I thought they w
It sounds to me like you want to join the two tables?
http://dev.mysql.com/doc/refman/5.1/en/join.html
On Mon, Jun 15, 2009 at 03:56, bruce wrote:
> hi.
>
> i've got a situation, where i'm trying to figure out how to select an item
> from tblA that may/maynot be in tblB.
>
> if the item is only in
My first thought was: Archive Storage Engine;
http://dev.mysql.com/doc/refman/5.0/en/archive-storage-engine.html
But then I read "fetch the result", so you're not only inserting data,
but also doing some queries on it? Can you show the queries and your
model?
On Sat, Jun 13, 2009 at 07:40, Krishna
You mean the list you get when you run `./configure --help`?
Also check out http://dev.mysql.com/doc/refman/5.0/en/configure-options.html
Or do you need more detail? Please be specific in what you need.
On Mon, May 4, 2009 at 22:40, michel wrote:
> Is there a place on the net that has detailed d
If I understand your question correctly (and I'm really not sure about
that), you're using a LEFT JOIN where you actually want to use a RIGHT
JOIN.
Or you need to rewrite your query and set the tables in another order.
On Thu, Apr 30, 2009 at 23:01, Nigel Peck wrote:
>
> Can someone please help m
Can you please give the full table structure and query?
On Tue, Apr 28, 2009 at 23:18, Antonio PHP wrote:
> You have an error in your SQL syntax; check the manual that corresponds to
> your MySQL server version for the right syntax to use near 'Created = NOW(),
> Updated = NOW()' at line 8
>
> 'C
Hi Keith,
I'm not sure, but this might be DST that's in your way. Have you
looked into that?
Have a nice day,
- Martijn
On Mon, Apr 20, 2009 at 18:34, Keith Hughitt wrote:
> Hi all,
>
> Does anyone know what is going on here:
>
> //Query:
>
> select UNIX_TIMESTAMP(TIMESTAMP('2003-01-01 00:00:0
They'll normally sort at the top, unless you use ORDER BY DESC.
Anyway, fixing that is easy:
SELECT col1, col1 IS NULL AS isnull
FROM tbl1
ORDER BY isnull DESC, col1 ASC
That should give you the results ordered by col1, with the null-values
at the top.
- Martijn
On Sat, Apr 18, 2009 at 19:54, Da
http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_lower_case_table_names
I think you'll want to set it to 1
On Wed, Mar 18, 2009 at 22:15, David M. Karr wrote:
> Ubuntu 8.10.
>
> I was experimenting with the Spring Petclinic sample application, configured
> with MySQL.
Hi Morten,
You might want to read this post on MySQL Performance Blog that was
posted a few days ago:
http://www.mysqlperformanceblog.com/2009/03/17/converting-character-sets/
Have a nice day,
- Martijn
On Wed, Mar 18, 2009 at 11:50, Morten wrote:
>
> Hi, I just tried this on a local copy of t
10 matches
Mail list logo
