I don't have that much experience with MySQL having mostly worked with
MSSQL, but I'm sure the logic is still the same. I believe the query
"select count(*) as 'count' from logins GROUP BY dawiz" will fail
because "dawiz" is not a column, it's a value within the table.
If I'm not mistaken, a
Hi G,
There is nothing weird about your results. When you do a Count(*)
without a GROUP BY(someColumn) you are essentially asking MySQL how
many rows are present in the table. But when you do use Group By
someColum , you are asking MySql how many rows do I have of
"someColumn" . It's just a go
No InnoDB here, just some old ISAM tables.
Sorry about my stupidity on this one, I have only myself to blame...
I have a bunch of old-school ISAM tables that need to be converted to
MyISAM, is there any way to do this en-masse?
(I.E. not having to go through each DB in the DBMS and
ALTER TABLE t
According to the docs (http://dev.mysql.com/doc/mysql/en/DATETIME.html)
The number "1258975462" equates to the date "1258-97-54 62:00:00" which is
not a valid date. That's why you get the "zero date" value.
That number could also equate to a unix_timestamp() value for the date
"2009-11-23 06:24
Invalid entry format for the timestamp field. Did this work before?
-Original Message-
From: Tariq Murtaza
To: [EMAIL PROTECTED]
Sent: 7/26/04 4:43 AM
Subject: Weird problem for TIMESTAMP feild
Hi All,
I am getting very weired problem after shifting our server. here is the
details:-
I
Will Richardson wrote:
Hello,
I have a table with 3 columns:
mysql> desc srv_ref_cities;
++-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
++-+--+-+-+---+
| state_id | char(2)
"Axel Tietje" <[EMAIL PROTECTED]> wrote:
> Hi everyone...
>
> I actually have two servers:
>
> 1. Server: MySQL 4.0.12
> 2. Server: MySQL 3.23.38
>
> This query:
>
> SELECT o_obj,
> MAX(CASE WHEN o_key = '69B96431' THEN o_val END) AS _69B96431,
> MAX(CASE WHEN o_key = '69B96431' TH
Some of the values passed to the CASE expressions are NULL.
There was a bug in handling NULL in CASE that was fixed in
MySQL 4.0.8:
http://www.mysql.com/doc/en/News-4.0.8.html
Note the last item on the page. I believe this explains the
differences that you are seeing.
At 16:28 +0200 6/12/03, Axel
* Hamlin Nicholas-qa568
> I have added some extra fields to the mysql.user table, namely:
> full_name VARCHAR(255)
> job VARCHAR(255)
> location VARCHAR(255)
> phone VARCHAR(255)
> reminder VARCHAR(255) NOT NULL
> ip_addr VARCHAR(255) NOT NULL
>
> I want to store these values for each person that
Sinisa Milivojevic writes:
>
>ALTERing will completely break security and permission systems and
>will even prevent MySQL from proper functioning.
>
Can you give me an example? I'm having no problems with security even after adding
these columns. Users only have access to the dbs and tables th
Hamlin Nicholas-qa568 writes:
> I have added some extra fields to the mysql.user table, namely:
> full_name VARCHAR(255)
> job VARCHAR(255)
> location VARCHAR(255)
> phone VARCHAR(255)
> reminder VARCHAR(255) NOT NULL
> ip_addr VARCHAR(255) NOT NULL
>
> I want to store these values for each perso
Silver Fox wrote:
> I just got this problem...
>
> bin/mysql -h localhost -u root
> logs me into MySQL at the command line
>
> However, the CGI script for Apache webserver gave me an error connecting to
> the database
> $source = "DBI:mysql:red:localhost";
> $username = "root";
> $password = "";
Dibo Chen wrote:
> probably there are spaces?
D'oh! Yes, a leading space.
This query...
select length(streetnum),streetnum from main where streetnum=3411;
produced a length of five, not four.
I'll use the trim() function & compare apples to apples. :) Thanks!
--
Tired of Earthlink? Get Jus
Dibo Chen wrote:
> try SELECT * WHERE x like '3411'.
Like doesn't work either. I tried it.
mysql> select ppn from main where streetnum=3411;
+---+
| ppn |
+---+
| 01A003290 |
| 01A016440 |
+---+
2 rows in set (3.04 sec)
mysql> select pp
try SELECT * WHERE x like '3411'.
Steve Sobol wrote:
>
> I have a varchar field that contains the street number (part of a
> mailing address). It's a varchar because the field may occasionally
> contain non-numeric characters, but normally it doesn't.
>
> Let's call the field "x".
>
> I have a
15 matches
Mail list logo
