. Not having much luck
finding a solution in the manual.
SELECT 1
+ CHAR_LENGTH(0 0 0 1 0 1 0 25 7 0 139 0 9)
- CHAR_LENGTH(REPLACE(0 0 0 1 0 1 0 25 7 0 139 0 9, , ))
AS ret
HopeItHelp,
Francesco
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
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
not know what to do, so I need your help to solve this
problem.
Greetings
Francesco Vincenti
*
*
-Uvh --nodeps perl-DBI-1.50-1.i386.rpm
and the installation finished without problems.
Then, I installed both MySQL-server-standard-5.0.18-0 .rhel3.i386.rpm, with
which I have had the problem, and
MySQL-client-standard-5.0.18-0.rhel3.i386.rpm and all went in the right way.
Greetings
Francesco
Alle 08:21, giovedì 13 ottobre 2005, Huub ha scritto:
Hi,
Can someone tell me if it is anyhow possible to import a dBaseIII+
database into MySQL and if so: how?
On linux there is dbf2mysql
http://packages.debian.org/stable/misc/dbf2mysql
On windows you could import the tables in m$access
in log 'tana-bin.001' produced
6 warning(s). Default database: 'TSM'
What's happened? How i can see the produced warning on the slave?
Thanks in advance,
Francesco Dalla Ca'.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
admin, not by me).
There are some particular SQL mode that permit this?
Thank in advance. Francesco.
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
: [EMAIL PROTECTED]
Hello.
This issue has been raised in the list already before, however I don't
remember that good solution was found. And without queries which was
executed these log records don't give any useful information in most
production environments.
Francesco Dalla Ca' [EMAIL PROTECTED
)
Settore Gestione Sistemi
Francesco Dalla Ca'
Email [EMAIL PROTECTED]
===
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
probably are compiled with NPTL.
The thread are still there but to see them you must use a different
sintax of ps , like:
#ps -eLf
--
No problem is so formidable that you can't walk away from it.
~ Charles M. Schulz
But sometimes run fast is better
~ Francesco R.
--
MySQL General Mailing List
Dear list,
I've been searching the archives before posting this request since it
is about something you've already discussed. But I didn't find the
solution, so here it comes my question.
It is about RAM consuming.
I'm running a PHP/mysql application on a redhat 8.1 - kernel 2.4-18 -
512 MB
Hello,
I tried to drop a table with Mysql 4.0.1 alpha nt and I have encountered
the following problem:
ERROR : Error on delete of .'\camcomm.tmpge.MYI'
The problem persists. I don't know the reason of this error.
I ask if a new version of Mysql (the version 4.0.7 i s released) is better.
this Joke
Francesco Delete this Joke
Francesco Delete this Joke
Add a Joke!
Only the insert from a form does run. I don' t understand the problem.
I also ask if the FoxServer Version has bounded perfromance because the
form in a script PHP that call itself run only if the action of the form
Hello,
I tried the modify two fields in a table and MyCC and MySqlFront return the
following error:
Error: 7 - Error on rename of '.\aziendeseat\aziendege.MYI' to
'.\aziendeseat\#sql2-610-1a.MYI' (Errcode: 13)
The Table is named aziendege and contains the fields:
ID NOT NULL AUTO_INCREMENT,
Nome
Hello,
I tried to execute the following query:
SELECT studenti.*
FROM studenti,valutazioni LEFT JOIN valutazioni ON studenti.sid=valutazioni.sid
WHERE valutazioni.sid IS NULL;
and give me the following error message:
ERROR 1066: Not unique table/alias: 'valutazioni'
I have the Mysql 4.0.1 alpha
I have a GFS/OpenGFS-based cluster I intend to use for an HA mysql setup.
Just for fun, I tried running two instances of MySQL over the same table
files,
and you can imagine my surprise when it mostly worked
I only got an error in table handler when when inserting row #8k of a
concurrent
the starting scripts under /etc/rc.d/init.d ?
Thanks a lot
Francesco
[EMAIL PROTECTED]
Hi.
I'd like to build an HA MySQL server using shared storage over
Fibre Channel.
Having a look at the mailing list archives, the issue was addressed
earlier on (I could find traces of it as early as 1999) but AFAICS
no definitive solution has been reached.
I know there is a commercial solution
24 matches
Mail list logo