atable SPARCV9 Version 1" my guess would be there is some mixup with
32 and 64bit somewhere, but to be honest I have no clue where to start to
fix this issue, which is why I came here ;).
Any help is greatly appreciated, thanks in advance, cheers
Felix
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
On Sun, Jan 9, 2011 at 1:54 PM, Yves Goergen
wrote:
> Why does it take ages for MySQL Workbench to startup?
I rarely use MySQL Workbench. But I remember that reducing the maximum
number of items in the undo history greatly improves speed, though maybe
not startup time.
--
MySQL General Mailing
I am dealing with blobs up to - I estimate - about 100 kilo bytes in
size.
Storage engine: InnoDB
Frontend: PHP
Some questions:
* I've read somewhere that it's not good to update blobs, because it
leads to reallocation, thus fragmentation, thus bad performance. Is
that true? Any reference
I am dealing with blobs up to - I estimate - about 100 kilo bytes in
size.
Storage engine: InnoDB
Frontend: PHP
Some questions:
* I've read somewhere that it's not good to update blobs, because it
leads to reallocation, thus fragmentation, thus bad performance. Is
that true? Any reference o
I am dealing with blobs up to - I estimate - about 100 kilo bytes in
size.
Storage engine: InnoDB
Frontend: PHP
Some questions:
* I've read somewhere that it's not good to update blobs, because it
leads to reallocation, thus fragmentation, thus bad performance. Is
that true? Any reference on
eturns the string str, left-padded with the string padstr to a length
of len characters. If str is longer than len, the return value is
shortened to len characters.
Examples:
mysql> SELECT LPAD('hi',4,'??');
-> '??hi'
mysql> SELECT LPAD('hi&#
> editing the sql dump?
SET FOREIGN_KEY_CHECKS=0;
-- do your stuff
SET FOREIGN_KEY_CHECKS=1;
--
felix
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[EMAIL PROTECTED] ("Padmanabhan G") wrote in
news:[EMAIL PROTECTED]:
> mysql> create user [EMAIL PROTECTED] identified by password 'openpne';
>
> Error 1372: Password hash should be a 41-digit hexadecimal number
mysql> create user [EMAIL PROTECTED] i
[EMAIL PROTECTED] wrote in news:[EMAIL PROTECTED]
R04.sysops.aol.com:
> Something like distributing files with encrypted data in most columns
> can be done
I think the OP is more concerned with protecting his datamodel, and this
cannot be done in my opinion.
--
felix
--
MySQL G
biggest problem is MySQL data files. Is there anyway by which
> I can configure the MySQL so that only PHP script can read it and if
> you happen to copy the Data files and try to use it, that will be
> useless.
No.
--
felix
--
MySQL General Mailing List
For list archives: htt
ias but the
individual column. Results of an aggregate function are *never*
available in a WHERE clause.
You need a HAVING clause.
--
felix
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ta is
> on the same computer as mysql. I can't get it to work where the data
> is on a different computer.
Did you try the method outlined here:
http://dev.mysql.com/doc/refman/4.1/en/windows-symbolic-links.html
--
felix
--
MySQL General Mailing List
For list archives: http://lists.
lus 5 * 12 for the next one. Instead it is returning $180.
The monthly_cost column is indeterminate (read meaningless) outside of an
aggregate function, since you're not grouping on it.
See http://dev.mysql.com/doc/refman/4.1/en/group-by-hidden-fields.html
--
felix
--
MySQL General Mailin
he normal behavior?
> Thanks)
Looking at the headers it seems your cc: address is different from the
from: address.
Personally I follow these lists through nntp:lists.mysql.com with a
newsreader.
--
felix
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubsc
ERE id = <>
and *not*
SELECT * FROM Clients ORDER BY Name LIMIT n, 1
--
felix
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[EMAIL PROTECTED] (Gilles MISSONNIER) wrote in
news:[EMAIL PROTECTED]:
> I rewrite my question in a simpler (?) way :
> How could I load in the database, data from a text file containaing
> date in a NOT MySQL standard date format [precisely char(10)], so that
> I get the date into a MySQL standa
ELECT orders_id
> FROM orders WHERE user_id='".$user."') ORDER BY factura_id";
... don't even know if this will work:
SELECT DISTINCT
f.*
FROM facturas f, orders o
WHERE
f.pedido = o.orders_id AND
o.user_id = '$user'
ORDER BY f.factura_id;
INTERVAL ( i)[EMAIL PROTECTED] SECOND AS S,
@min_dt + INTERVAL (1+i)[EMAIL PROTECTED] - 1 SECOND AS E,
DATE_FORMAT(@min_dt + INTERVAL (i)[EMAIL PROTECTED] SECOND, '%H') AS H,
COUNT(timestamp)
FROM ints
LEFT JOIN event ON event.timestamp
BETWEEN @min_dt + INTERVAL (
[EMAIL PROTECTED] ("Paul Halliday") wrote in
news:[EMAIL PROTECTED]:
> I am trying to deal with empty values so that I can graph data over a
> 24 hour period without gaps.
Have a look here:
http://forums.mysql.com/read.php?10,133603,133607#msg-133607
--
felix
--
MySQL Gene
LUES
(1, 20), (2, 30), (3, 40), (4, 10), (5, 20), (6, 20);
SELECT
f1.id,
f1.total
FROM foo f1
JOIN foo f2 ON f2.id <= f1.id
GROUP BY f1.id, f1.total
HAVING SUM(f2.total) <= 100;
--
felix
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
T
r MySQL do all use the same database though. Does it matter what
version phpinfo() is giving me?
Kevin Felix
Op 14-jun-06, om 05:18 heeft Dan Buettner het volgende geschreven:
Kevin -
You can start up the MySQL server without password protection using
the --skip-grant-tables option. Note
ning without me getting access to the
server once again.
Does anyone have a solution?
Thank you for your time
Kevin Felix
[EMAIL PROTECTED] (e-mail)
[EMAIL PROTECTED] (MSN-Messenger)
ekefster (AIM)
ake place in the first or last table of the UNION
list. Use a value of FIRST or LAST to cause inserts to be made in the
first or last table, respectively. If you do not specify an
INSERT_METHOD option or if you specify it with a value of NO, attempts
to insert rows into the MERGE table result in an er
ably not useful in production code for performance reasons, and one
should be careful with duplicate rows (not allowed in this example).
--
felix
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
unsigned NOT NULL default '0',
`Desc` varchar(45) NOT NULL default '',
PRIMARY KEY (`Master_ID`),
FOREIGN KEY (`Master_ID`) REFERENCES `master_tbl` (`ID`)
ON UPDATE CASCADE ON DELETE CASCADE
) ENGINE=InnoDB;
That way, you only have to
DELECT FROM master_tbl WHERE Mast
index on
(account, lastname, firstname) instead of separate indexes on account,
lastname and fistname.
--
felix
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
#x27;, 1, 0))
WHEN MAX(status2) = MIN(status2) AND status2 = 'Neg' THEN
SUM(IF(status1 = 'Neg', 1, 0) +
IF(status2 = 'Neg', 1, 0))
ELSE NULL
END AS count
FROM foo;
--
felix
--
MySQL
th a '*').
Since you are receiving the password from the user when he/she logs in,
you can add some logic to your login procedure to change the password
to the new hashing.
P.S.: This is exactly why MySQL AB advises against the use of
PASSWORD() for your own authentication.
--
felix
foo f2
WHERE f2.fid = f1.fid AND f2.d > f1.d
) < 3 -- top 3
GROUP BY f1.fid, f1.d
ORDER BY f1.fid, f1.d DESC;
which also tries to handle ties.
If you remove the 'COUNT() AS Ties' and the GROUP BY, you can have more
than three results per fid when there are ties.
--
fe
ce with my example?
I regularly use
WHERE CURRENT_DATE() BETWEEN startdate AND enddate
without any problems. In fact the above is equivalent to
WHERE startdate <= CURRENT_DATE() AND CURRENT_DATE() <= enddate
--
felix
--
MySQL General Mailing List
For list archives: htt
types.
What happened when you tried?
--
felix
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
DROP DEFAULT".
I think you have to use
ALTER TABLE MEMBERS CHANGE MEMBER_INFO MEMBER_INFO VARCHAR(160) ...;
with ... optionally NOT NULL and/or DEFAULT 'whatever'
--
felix
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
optimised as you'll get for that query.
> You could always make the actual server faster...
If your template table contains many columns in addition to templateid,
title and template, and title and template are not TEXT columns, you
can consider a covering index on templateid, title and
.
SET @uts := UNIX_TIMESTAMP(NOW());
SELECT
IF(WEEKDAY(FROM_UNIXTIME(@uts)) = 2, 'Yes', 'No') AS 'Wednesday?';
SELECT
IF(TIME(FROM_UNIXTIME(@uts)) BETWEEN '14:00' AND '15:00', 'Yes', 'No')
AS 'Between 2 and 3 pm?';
See h
On 14/09/2005, "Matthias Pigulla" wrote:
> However - why do we need the dependent subquery at all? The subquery
> can be executed on its own, as it does not depend on any information
> of the "superquery".
This is a subquery optimizer bug.
See http://bugs.mysql.co
- the twenty third record
- the last record
unless you provide for some ordering yourself (e.g. by including a
timestamp).
--
felix
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On 18/08/2005, Martin Schwarz wrote:
> When using
> 'update TABLE set FIELD=PASSWORD('foo');'
> the query
> 'select * from TABLE where FIELD=PASSWORD('foo');'
> delivers an empty set.
>
> Same with the SHA1 or MD5 functions.
What
ROM foo;
SELECT * FROM foo;
DELETE FROM foo WHERE a = 'a';
INSERT INTO foo VALUES ('x', 'x');
SELECT a FROM foo;
SELECT * FROM foo;
--
felix
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
record"?
(relational databases are not spreadsheets)
--
felix
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Or put the members alphabetically in the enum definition in the first
place ...
--
felix
On 09/06/2005, Eric Bergen wrote:
> It's not a bug at all. You just hit one of the features of enum :)
>
> If you want to order alphabetically as you describe cast the enum
> name to a
ys prefer to set my 'start' in the WHERE clause, so the index can
do its work, e.g:
SELECT id, dt FROM dtfoo WHERE dt > @some_datetime
ORDER BY dt ASC LIMIT 0, 10;
--
felix
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
esponds to your MySQL server version for the right syntax to
> use near 'exists (select * from SAMPLES S2 where S1.ID = S2.ID)' at
> line
You need MySQL 4.1.x for subqueries.
--
felix
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscr
sking.
COMMIT TRAN A
Exit : ROLLBACK TRAN A
Thanks,
Felix Ang
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
onary given that I can not use more than
one set of characters in mysql server. ( the russian
words need on set of characters , the french ones
another ).
I would appreciate any hint.
kind regards,
Felix
___
Do You Yahoo!? -- Une ad
measurement was for
30 minutes and a segement is missing (12:30-13:00).
What I want is to write some aggregation functions
the will do this kind of computations like the following:
select nisum(starttime,endtime,counter,,trashold) from
where
That's it,
Felix
---
sql, query
V
No. It is not what I want.
This is a normal aggregation.
The sum function will be called once for each
group (SalespersonNm) and it will return one row.
What I have asked is : if I have 10 rows, can I return 12?
It's rude, but that's the idea.
Thanks,
Felix
DL Neil wrote:
> Felix
Is is it possible to write an aggregation function which returns
more than one row?
Thanks,
felix
Mysql sql query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
Hi,
you can see the monitor's output in the logfile. In my case (mandrake linux), it is in
/var/lib/mysql and I do:
tail -f /var/lib/mysql/SERVERNAME.err
> Also, where do I designate autocommit = 0;
Use "SET AUTOCOMMIT = 0" as a SQL query. Just issue it where you do your SELECT,
UPDATE etc.
+
| Impossible WHERE noticed after reading const tables |
+-+
??
Thanks for any advice,
Felix
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
h
Hello everybody,
I could not find any documentation about the BETWEEN function. Am I just
blind? Please point me to it. Or is it not stable yet? How does it
perform in comparison to "field1 >= x AND field1 <= y"?
Thanks,
F
the selected rows.
Felix
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsub
g purposes, you may also just call /etc/cron.daily/logrotate by hand from
the commandline.
Felix
-Ursprüngliche Nachricht-
Von: Alexander Shaw [mailto:[EMAIL PROTECTED]]
Gesendet: Mittwoch, 20. Februar 2002 01:15
An: MySQL List; Felix Richter
Betreff: RE: **Backing Up A Database**
Hi Felix
e script and then compresses the "log"file (i.e.
SQL-Dump), renames older ones and keeps at max 14 of them ("rotate 14"). "nomissingok"
will let you know if the mysqldump failed
Felix
-
Before
Please see
http://www.mysql.com/doc/B/a/Backup.html
I personally issue "mysqldump"s via cron and maintain the files using "logrotate"
(Redhat Linux), which automatically zips and rotates them.
-
Before posting, please check:
about MySQL doing a ROLLBACK automatically after some time with InnoDB tables.
What about BDB?
(MySQL ver 3.23.41)
Thanks, Felix.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
nths ago...
>
> Mail Merge Stuff for Word and VBA
> http://msdn.microsoft.com/library/en-us/dnovba00/html/MailMergePartI.asp
> http://msdn.microsoft.com/library/en-us/dnovba00/html/MailMergePartII.asp
This is really new to me, I will check this out today !
Thanks a lot Butch !
gree
.typindex FROM adressen adressen_0, akte"
-snip --- snap -
But it does not work. I always get the error 5922, Word could not open
Datasource.
can anybody help?
rgds, Felix.
-
Before posting, please ch
Hi folks, hi butch,
yes, I do have MS query installed, but where to start? Is there a FAQ or
HOWTO or just some sample-scripts? I just need the first steps, then I think
I can walk alone ...
rgds,
Felix.
- Original Message -
From: "Butch Bean" <[EMAIL PROTECTED
Hello Folks,
oncemore I post this question:
Is it possible to update data from Microsoft Word useing MyODBC?
Is there any other way to update data from MS Word?
Is here a VB Scripting Guru who can help me?
cheers,
Felix.
(keywords: database, table, sql
,
Felix
- Original Message -
From: "Venu" <[EMAIL PROTECTED]>
To: "Felix Schepmann" <[EMAIL PROTECTED]>
Sent: Saturday, January 26, 2002 8:10 PM
Subject: RE: Newbie: MS Word + MyODBC + MySQL
> Hi,
>
> > -Original Message--
kind
of front-end within Word's VB ?
IS there a FAQ for all my Word-questions?
regards, Felix.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
t TransactionIsolationLevel NONE.
> And, setTransactionIsolation method of 'org.gjt.mm.mysql.Driver' will
> throw SQL Exception. Because, in that case, driver sends SQL statement
> 'SET SESSION TRANSACTION ISOLATION LEVEL ;'
> to MySQL. This SQL statement is wrong.
&
of the database connection and it's working
correctly with another sample code using standard Java API to access
database.
The definition of datasource in poolman.xml is:
mydb
jndi-mydb
org.gjt.mm.mysql.Driver
jdbc:mysql://127.0.0.1/cd
0
10
NONE
C:\
your my.cnf) to
something below 5 minutes (the default is rather high, 4 or more hours).
This should fix you up in no time at all. :-)
Regards,
Felix
On Mon, May 28, 2001 at 11:28:21AM +0200, Xavi Gracia wrote:
> Hi !
>
> I'm a novice mysql administrator and acording to my Web H
64 matches
Mail list logo
