[EMAIL PROTECTED] ha scritto:
We have numerous identical tables with a varchar column that holds data
like this: 0 0 0 1 0 1 0 25 7 0 139 0 9. Essentially there are a bunch
of integers with a single space as a separator. There _should_ be no more
than 30 entries ( and 29 spaces ), but
It's possible to repeat with a varbinary field also in 5.1
CREATE TABLE t1 (
RoomNo varbinary(10) DEFAULT NULL,
LastName varchar(25) NOT NULL,
FirstName varchar(25) NOT NULL,
ChapterID int(11) NOT NULL DEFAULT '358'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `t1` (`RoomNo`,
Maybe this one could do (untested) ?
SELECT COUNT(*),
( SELECT count(*) FROM employees AS t2 WHERE t2.name = 'Joe' AND
t2.state = 'ME' AND t2.hiredate = datevalue) AS joesexist
FROM employees
WHERE name = 'Joe' AND state = 'ME' AND hiredate = datevalue;
Jerry Schwartz ha scritto:
I don't
select rpad(|IFNULL(|null, ''),5,'1');
|/||/|
[EMAIL PROTECTED] ha scritto:
I am running a basic install of MySQL 5.0 with strict mode turned on I
would like to use RPAD however at times a NULL var will be sent to the
function. My goal is to have a function that will convert the NULL to a
Horst Jäger ha scritto:
Hi everyone,
the number of incices per table seems to be restricted to 64.
Any way to change that?
recompile with configure --with-max-indexes=128
I'm using MySQL 5.0.27 .
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Heikki Tuuri ha scritto:
Bill,
we are moving the DNS of innodb.com from Capnova to Oracle Corp.
I can now view http://www.innodb.com through my ISP, Elisa. Does
anyone still have problems accessing http://www.innodb.com?
If you cannot see some web page, you can resort to Google's cache to
And another one is (in inverse order for laziness):
select
(8 1) AS `0`
, (8 2 1) AS `1`
, (8 4 1) AS `2`
, (8 8 1) AS `3`
, (8 16 1) AS `4`
, (8 32 1) AS `5`
, (8 64 1) AS `6`
, (8 128 1) AS `7`
;
Ed Reed wrote:
Well I solved the problem by using LPAD but it would be nice if
Francesco Riosa wrote:
And another one is (in inverse order for laziness):
select
(8 1) AS `0`
, (8 2 1) AS `1`
, (8 4 1) AS `2`
, (8 8 1) AS `3`
, (8 16 1) AS `4`
, (8 32 1) AS `5`
, (8 64 1) AS `6`
, (8 128 1) AS `7`
;
but this one looks better:
select
(8 1
B. Heller wrote:
Hello List,
I compiled mySQLd 4.1.10a from Source on Linux 2.6. Although the server does it's work well, I wondered why there's only one mysqld thread running. Is that new/normal for mySQL 4.1? While using mySQL 3.23 I always had several threads running on my system.
your glibc