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
- Original Message -
From: "Darryle Steplight" <[EMAIL PROTECTED]>
To: "MySql" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, September 09, 2008 6:59 PM
Subject: Re: Weird problem with mysql_query
Hi G,
There is nothing weird about your results. When y
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
We are running MySql version 5.0.45-Debian_1ubuntu3.1-log Debian etch
distribution under Ubuntu.
If I submit the following query via mysql_query it acts as if the where is not
there:
select count(*) as 'Count' from logins where player = 'aqwert';
this returns:
Count
143578160
Submitting
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
I have a MySQL DBMS running with a mysql DB that apparently is an InnoDB
DB, all other DBs in this DBMS are MyISAM. When I try to upgrade, I get
the following output:
041215 16:41:53 mysqld started
InnoDB: Resetting space id's in the doublewrite buffer
041215 16:41:57 InnoDB: Started; log seque
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
Hi All,
I am getting very weired problem after shifting our server. here is the
details:-
I have a table with two columns
1-TimeStamp timestamp(14)
2- SID bigint(20)
when inserting _INSERT INTO _/_TABLENAME values (1258975462,125987)_
results in /_INSERT INTO _/_TABLENAME values (
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)
Hello,
I have a table with 3 columns:
mysql> desc srv_ref_cities;
++-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
++-+--+-+-+---+
| state_id | char(2) | YES | | NULL|
"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
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' THEN o_typ END) AS T_69B96431,
MAX(CASE WHEN o_key = 'AA0
Ok, I have a program I am working on, there is probably just something I don't
understand about the behaviour of the C API and not a bug with MySQL's C api.
I have an app that listens on a specified TCP port, once a user connects and
successfully authenticates, two more processes are spawned (le
I was the one having issues getting Lost Connection and whatnot for no
reason.
I have recompiled under glibc2.2.5 with 2.95 and 3.04.
I just tried 4.0.2 from the source tree.
Sometimes from the command line of doing mysql -uroot -p I get this:
ERROR:
And that's it.
I run it again, and it go
* 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
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 creates a new account on my database.
Th
Hi there!
I have a question. I've created a page in PHP4 which displays the result of
the following query:
select event_detail.id, event_detail.startdate, event_detail.enddate,
event_detail.title,
event_detail.comment, event_detail.active, event_detail.subscription_open,
event_main.url
from eve
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 = "";
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 = "";
Did any of you ever face this probl
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
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 record where x='3411'.
In spite of the fact that x is a varchar, the
o with perl
or mysql.
-Original Message-
From: Haris [mailto:[EMAIL PROTECTED]]
Sent: Saturday, April 21, 2001 6:11 PM
To: [EMAIL PROTECTED]
Subject: Mysql weird problem
Hello,
When i transfer
the project on my protable
running Win98,Opera and IE
work but netscape just tries
continuouo
Hello,
i am developing a shopping cart
with perl and mysql. The project
almost finished is running fine
on WinME with Mysql and Perl and Apache.
Its running fine with Opera
IE and Netscape. When i transfer
the project on my protable
running Win98,Opera and IE
work but netscape just tries
continuou
Hi,
I am using the newest versions of MySQL,PHPMyAdmin, and PHP4 on IIS server.
The MySQLdatabase and PHP is working like a champ, but when I connect to
localhost/phpmyadmin it asks me for login/password and domain. The problem
is domain. We have a virtual private network here. So the machine is
30 matches
Mail list logo