> like to get the DB server to accomplish this task. 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", " ", "&qu
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 <= ) AS joesexist
FROM employees
WHERE name <= 'Joe' AND state = 'ME' AND hiredate <= ;
Jerry Schwartz ha scritto:
I don't think that will wo
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`, `LastName`
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 unsubscrib
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 ca
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`
>
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 wo
-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
t I do not know what to do, so I need your help to solve this
problem.
Greetings
Francesco Vincenti
*
*
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$acc
'TSM'
050831 6:31:58 [Warning] Slave: load data infile on table
'Day_Occupancy' at log position 32080517 in log 'tana-bin.001' produced
6 warning(s). Default database: 'TSM'
What's happened? How i can see the "produced warning" on the sla
is table with this field? (The database
was created by others 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]
age-ID: <[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.
Franc
)
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]
your glibc 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 M
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 R
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.
--
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
em:
If I try to execute the delete no information is deleted from the database
and I call jokehandle passing addjoke no joke is inserted in the database.
The browser show this message:
Notice: Undefined index: submitjoke in C:\FoxServ\www\db\jokehandle.php on
line 43
Error deleting joke:
Here are a
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 ve
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
Hi,
I'd like to know how to change the port to use for connection
I work under WINNT. I tried with mysqld-nt --port=1234
but it seems it enters in a loop.
Thanks in advance
Francesco
--
FRANCESCO TAGLINO
LEKS - Laboratory for Enterprise Knowledge and Systems, at IASI-CNR
Viale Manzoni 30,
- in order to
update 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 f
25 matches
Mail list logo
