rt_table.
It would also a nice idea to include '--quote-names' as a default
in mysqldump since without this option above mentioned tables
aren't dumpable.
>Submitter-Id:
>Originator:Anders Henke
>Organization: Schlund+Partner AG
>MySQL suppor
NLOCK TABLES") unless ($lock_tables_failed)
This gives certain advantages: Those who want dumps no matter if
the --lock-tables worked but prefer "complete" backups, can perform
such a "relaxed" backup with "--opt --relaxed".
ent library of course.
Enjoy, and comments are welcome, I hope this tool will turn out useful
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Anders Karlsson ([EMAIL PROTECTED])
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Sales Engineer
/_/ /_/\_, /___/\___\_\___/ Stockholm
<_
te this featuer into an upcoming version of the tool though.
Best regards
Anders Karlsson
John May wrote:
Is there any way with this tool, or some other tool, to monitor the
amount of data (in KBytes or the likes) returned by a particular query?
- John
The first version of MyMonitor is n
Also, I need to learn how to spell. The docs arn't as bad as the
language in the reply below.
/Karlssons spellchecker
Anders Karlsson wrote:
John!
No, that is not within the scope of this tool. One could imaging
that is was possible though, but without some
No, that is not withi
ilable. Or just look at the project at
sourceforge now and then.
Best regards
Anders Karlsson
Gabriel Mahiques wrote:
Anders I want this for Windows?
how do I do it?
Anders Karlsson escribió:
The first version of MyMonitor is now available in source form on
sourceforge and can be downloa
Or try my own tool mymonitor. Available on sourceforge at
https://sourceforge.net/projects/mymonitor
It's still in beta, but works OK. Still work in progress, and features
will be added, but in your situation, I think it could be useful.
Best regards
Anders Karlsson
Duncan Hill wrote:
e url = 'xxx'".
Thanks,
Peter
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Anders Karlsson ([EMAIL PROTECTED])
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Sales Engineer
/_/ /_/\_, /___/\___\_\___/ Stockholm
<___/ www.mysql.com Cellphone: +46 708 608121
--
MySQL General Mailing List
Fo
can
read more about that on the Linux HA homepage at:
http://www.linux-ha.com/
There are a few different way to adopt MySQL in this type of
environment. You can use DRBD (which is part of the Linux HA project) or
a SAN or you can use MySQL Replication.
Best regards
Anders Karlsson
JM wrote:
Hi
age WITH ROLLUP;
Regards,
Anders
c nelson wrote:
I'm working on MySQL v5.0 and I have a table with dateOfBirth and I want
a histogram of ages at a point in time. I tried something like:
select round(datediff(curdate(), dateofbirth)/365) as age, count(age)
from myTable group by ag
Hello,
You can get MySQL 5 either by a backport (www.backports.org) or by
changing to Etch that will be the new stable release in december. See
www.debian.org for more information.
Greetings,
Anders
Jangita @ FSA wrote:
hello all
i installed debian linux netinst which installed well; and
stored procs either.
Any suggestions about how to manage users/privileges would be appreciated.
Donna
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Anders Karlsson ([EMAIL PROTECTED])
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Sales Engineer
/_/ /_/\_, /
olumn 'f.id' in 'on clause'
The alias seem not working?
What should I do, I dont want to rewrite all my sql statement....
Thanks.
Jason
--
Anders Lundgren
Master Software Engineer
Viba IT Handelsbolag
Web: http://www.vibait.se
[EMAIL PROTECTED] wrote:
hi,
currently us
I think you should try % that is used as wildcard instead for one or
many characters. Granting on 'foo_%' might work.
Regards,
Anders
--
Anders Lundgren
Master Software Engineer
Viba IT Handelsbolag
Web: http://www.vibait.se
David Felio wrote:
Assume database 'biggie' w
l.com/doc/refman/5.0/en/password-too-long.html
Best regards
Anders Karlsson
Cornelia Menzel wrote:
Am 16.10.2006 um 13:08 schrieb Dominik Klein:
Unfortunately, that is not the reason, why I get this message. I
have tried 'mysql', 'mysql -uroot', mysql -u root', &#x
nt version. You have to watch for this if the client has
version 4.0 or earlier, and you have server with version 4.1 or higher,
then this is surely the problem you are experiencing.
Read more here:
http://dev.mysql.com/doc/refman/5.0/en/password-hashing.html
Best regards
Anders Karlsson
Corneli
l see the light if someone
just pushes me in the right direction on this problem.
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Anders Karlsson ([EMAIL PROTECTED])
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Sales Engineer
/_/ /_/\_, /___/\___\_\___/ Stockholm
<___/ www.mysql.com Cellphone: +46 7
or these, as well as some Wizards is among what
is planned.
MyQuery is GPL and may be downloaded from Sourceforge here:
http://sourceforge.net/projects/myquery/
Best regards
/Karlsson
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Anders Karlsson (and...@mysql.com)
/ /|_/ / /
enhancement. Color syntax highlightning by using the Scintilla editor
control. The MyQuery_3_1_setup.zip contains a single full-featured
installer, including the documentation.
Best regards
Anders Karlsson
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Anders Karlsson (and
/
Best regards
Anders Karlsson
Anders Karlsson wrote:
MyQuery 3.1 is now ready for download from Sourceforge:
http://sourceforge.net/projects/myquery/
The features of this release includes, but is not limited to:
- UTF-8 support
- Events management dialog
- SQL Statement profiling
- Much enhanced
re using a colour printer that is, and query
results. Printing also, as does the editor, screen results and the
database, support UTF-8 data.
Best regards and happy SQLing
Anders Karlsson
BTW. Sorry for cross-posting, but I felt this is interesting to both
groups, and I don't really overflo
se to host MyQuery, and I'll also check links before posting.
Best regards
Anders Karlsson
After a few beers, including an Anderson Valley Double IPA, not bad!
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Anders Karlsson (and...@mysql.com)
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB,
was reported back in 2004 and ignored:
http://bugs.mysql.com/bug.php?id=3138
I think this is a serious security problem that demands more attention
than dismissal as documented behavior. To solve it, there needs to be a
way to force the use of SSL from the client side.
Anders
--
MySQL General
On Wed, 18 Aug 2010, Yves Goergen wrote:
> Since MySQL is now Oracle […]
Yves, I think we should be treating this security issue seriously, and
working with Shawn and the MySQL team towards solving it constructively,
instead of just taking potshots at their new company.
Anders
--
My
Not in use
> From the same page but a few lines above the line he quoted
> ##
> This option is not sufficient in itself to cause an SSL connection to be used.
> You must also specify the --ssl-ca option, and possibly the --ssl-cert and
> --ssl-key options.
> #
I was a MySQL Sales Engineer up til a few weeks ago. I spent 6+ year at
MySQL. MySQL Classic never ever had InnoDB in it. Actually, the reason
for the existence of MySQL Classic was just that: MySQL without InnoDB
for OEMs.
If you wanted a non-GPL MySQL, you had to pay for it. And if MySQL
wa
.html
The plugin is GPL and is downloadable from sourceforge here:
https://sourceforge.net/projects/sqlstats/
Best regards
Anders Karlsson
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
If you downloaded this earlier today, note that there is now a 1.2
version available, that also shows ROWS_EXAMINED in INFORMATION_SCHEMA
tables.
/Karlsson
Claudio Nanni wrote On 2010-11-24 09:02:
Cool!
On Nov 24, 2010 8:46 AM, "Anders Karlsson" <mailto:and...@recordedfutur
on
Windows 7. Read more on the blog here:
http://karlssonondatabases.blogspot.com/2010/11/announcement-myquery-341-released.html
Or just go ahead and download it from here:
http://sourceforge.net/projects/myquery/
Best regards
Anders Karlsson
--
MySQL General Mailing List
For list archives: http
t,insert,update,references
es text utf8_general_ciYES (NULL)
select,insert,update,references
de text utf8_general_ciYES (NULL)
select,insert,update,references
fr text utf8_general_ciYES (NULL)
select,insert,update,reference
k.com/pointmade.band
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
--
Anders Karlsson, Senior Sales Engineer
SkySQL | t: +46 708-608-121 | Skype: drdatabase
--
MySQL General Mailing List
For list archives:
;m
looking for in it.
Since I am not sure if what I want exists or what it may be called, I just
may be looking in the wrong places for the answer.
TIA!
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Anders Karlsson ([EMAIL PROTECTED])
/ /|_/ / // /\ \/ /_/ / /__ MySQ
a1.auth is not 0,
AND
f1.free is either not populated or false.
AND
p1.validdate is either not populated, or the timestamp is before NOW.
Everything seems to work except for the passed time check. If I set
p1.validdate to a timestamp for something next week, the username is
still returned in the
NULL)
Thanks for the hints, you who gave them.. ;)
Anders.
> - Original Message -
> From: "Anders Norrbring" <[EMAIL PROTECTED]>
> To:
> Sent: Sunday, October 14, 2007 7:13 AM
> Subject: Help with query...
>
>
> > I'm trying to set up a
I'm looking at a situation I haven't run into before, and I'm a bit
puzzled by it.
I have this table structure:
Table USERS: userid, class
Table OBJECT: userid, class, result
Now I want to query the database for a certain user's result in a
specified class, which is very, very easy. No proble
Hi.. I'm struggling with a query that I'm trying to simplify as much as
possible, but I can't seem to get rid of using the very same subqueries
several times.
Would there be a way to optimize the following so I get rid of
subqueries that do the exact same thing more than once?
SELECT (count(*
FROM users WHERE username = %s)
"
Well, I am escaping the strings in sprintf in PHP, so the %s isn't an issue.
Can't it be done without temporary tables?
On Dec 20, 2007 4:23 PM, Anders Norrbring <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>> wrote:
Hi.. I'm
a first glance, it doesn't work at all, I get NULL results from it,
but I haven't spent any time trying to locate the problem yet..
So, I'm still open for ideas!
On 12/20/07, Anders Norrbring <[EMAIL PROTECTED]> wrote:
Hi.. I'm struggling with a query that I'm
ECT seems to do it..
Anders
Anders Norrbring skrev:
Brent Baisley skrev:
You might be able to use variables to store the result of the query.
Although I've never tried assigning the result of a query to a
variable, only field values.
SELECT (count(*)+)/(SELECT COUNT(*) FROM score AS s2
WHER
hat should work better, or at least put you on a better track.
I haven't checked this yet, but would it be better/smoother than putting
the variables assignments in separate SET statements in front of the
SELECT as I mentioned?
Anders
On 12/20/07, Anders Norrbring <[EMAIL PROTECTED]
Anders Norrbring skrev:
Brent,
you put me on the right track.. ;) Reading up a bit on syntax for
variables, I came up with the following, which seems to work.
SET @tid:=(SELECT tid FROM objects WHERE shortname = %s);
SET @vid:=(SELECT vid FROM itemtypes WHERE itemtype LIKE %s);
SELECT (count
(not
including SRID support though) is available in special version that you
can read about here: http://forge.mysql.com/wiki/GIS_Functions where you
can also find download links.
Best regards
Anders Karlsson
[EMAIL PROTECTED] wrote:
Hi All
I looking for the stated functions. Earl
-8 but otherwise doesn't care
about Unicode, i.e. sorting should be broken, comparison is correct.
PostgreSQL didn't find its own columns again, so I cancelled the test.
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Anders Karlsson ([EMAIL PROTECTED])
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Sales Enginee
say SET collation_connection_comparison = 'utf8_bin'. That would do what
you want basically, and I think there might possibly be a need for this.
/Karlsson
Yves Goergen wrote:
On 03.03.2008 10:27 CE(S)T, Anders Karlsson wrote:
> [a lot about why sorting unicode is complicated]
I
jects/myquery/ and there is sourcecode or a
complete Windows Installer or the documentation in PDF format. The
latter is included with the Windows installer.
Well, that's it for now, happy programming
/Karlsson
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Anders Karlsson ([EMAIL
: proper UTF-8 support. Supporting UTF-8 should
be easier, now that Scintilla is in place, but more work is needed for this.
Download MyQuery 2.0 from Sourceforge here:
https://sourceforge.net/projects/myquery/
/Karlsson
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Anders
far from ready
done this.
Download MySQL 2.1, inslcuding a complete windows installer
(including PDF documentation), PDF documentation and sourcecode from:
https://sourceforge.net/projects/myquery/
Happy SQL'ing
/Karlsson
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / And
implement, more so than
one might think, so input in this area is highly valued.
/Karlsson
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Anders Karlsson ([EMAIL PROTECTED])
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Sales Engineer
/_/ /_/\_, /___/\___\_\___/ Stockholm
<___/
give it another
chance now, there are some cool features in this Query tool.
Available for download at: http://sourceforge.net/projects/myquery/
Best regards
/Karlsson
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Anders Karlsson ([EMAIL PROTECTED])
/ /|_/ / // /\ \/ /_/ / /__ MyS
Export of data (To a spreadsheet for example).
* More output command options.
etc.
/Karlsson
Moon's Father wrote:
It's very nice!
But it's too simple.
On Mon, Oct 6, 2008 at 12:26 AM, Anders Karlsson <[EMAIL PROTECTED]> wrote:
Sorry for crossposting, but I think this is
ce,
ViSolve PlanCAT Team
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Anders Karlsson ([EMAIL PROTECTED])
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Sales Engineer
/_/ /_/\_, /___/\___\_\___/ Stockholm
<___/ www.mysql.com Cellphone: +46 708 608121
--
MySQL General Mailing
ed?
Thanks,
Anders
Dan Buettner wrote:
Thomas, I do not think in this case that one is better than the other,
for the most part, because both require using a value computed from
the column. Computing month from a DATE field should be just as fast
as computing from a DATETIME column I would
OK, thank you. How is the speed of this index compared with an indexed
date column if I do:
year_number='x' and month_number='y' and day_number='z';
They should have about the same cardinality, right?
Thanks,
Anders
Chris wrote:
Anders Lundgren wrote:
> O
Yes, of course. Thank you!
- Anders
Brent Baisley wrote:
Splitting out your values will cause problems where doing greater
than/less than searching.
If you search on year_number>=2000 and month_number>=6, that's not going
to give you everything from 6/2000 on. It will return real
-+
|1.2500 | 1.5000 | 5 | 4 | 2 |4 |
+---++---+-+---+--+
TIA,
CVH
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Anders Karlsson ([EMAIL PROTECTED])
/ /|_/ / //
mysqldump -u USER -h HOST.DOMAIN.XXX -p DATABASE_TABLE > the_database.sql
Anders Norrbring
Norrbring Consulting
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
The load average on the server is between 0.5 and 5.
Can someone give me some tips about what I should alter to get the
performence better?
Anders Gjermshus
Hiya all!
I'm curious about if there's a simple way to manage user quotas in a MySQL
database? F.x. user one can have 10MB data in the database and user two can
have a maximum of 5MB?
Anders Norrbring
--
MySQL General Mailing List
For list archives: http://lists.mysql.co
Hiya all!
I'm curious about if there's a simple way to manage user quotas in a MySQL
database? F.x. user one can have 10MB data in the database and user two can
have a maximum of 5MB?
Anders Norrbring
--
MySQL General Mailing List
For list archives: http://lists.mysql.co
i_id INT PRIMARY KEY AUTO_INCREMENT NOT NULL,
i_date DATE NOT NULL UNIQUE,
i_number INT NOT NULL,
i_editor INT,
UNIQUE (i_date, i_number)
);
For local development I'm using MySQL 3.23.55-NT on a Windows 2000 server.
My ISP uses 3.22.25 on a SunOS 5.7 server.
Any s
un_article_writer.a_id AND un_section.s_id = un_article.a_section AND
un_article.a_deadline = '-00-00' AND un_article.a_issue = '-00-00'
ORDER BY un_section.s_name ASC, un_article.a_header ASC"
Help appreciated! :)
--
anders thoresson
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
WHERE un_section.s_id = un_article.a_section AND un_article.a_deadline =
'-00-00' AND un_article.a_issue = '-00-00' ORDER BY
un_section.s_name ASC, un_article.a_header ASC
How are they combined to one?
--
anders thoresson
--
MySQL General Mailing List
For list archive
osedir($handle);
}
And another question: The created backup files, do they have to be
restored to a database with the very same name, or could they be restored
to another database?
Are there any differences between backing up this way, and using
mysqldump?
And finally: Does mysqldump have a co
osedir($handle);
}
And another question: The created backup files, do they have to be
restored to a database with the very same name, or could they be restored
to another database?
Are there any differences between backing up this way, and using
mysqldump?
And finally: Does mysqldump have a cou
Is it possible to resort the rows in a table like in a query where using
ORDER BY, but have to new sort order stored in the table structure?
--
anders thoresson
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
n*
A friend of mine noticed the same thing as he is in the middle of upgrading
to 4.1 as well. Then I said "Aha! Two people makes a pattern!" (Well,
that's a little bit of a stretch...) so I wondered if others had seen this,
and (here's the kicker!) knew how to fix it.
At 09:52 AM 10/15/2004, Crouch, Luke H. wrote:
"user permission trouble"
MySQL version? I've been having some trouble with
4.1.5.
Anders
+=======+
|Anders Green Email: [EMAIL PROTECTED] |
|
18. Any help would be
greatly appreciated.
Thanks,
Luke Venediger.
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Anders Karlsson ([EMAIL PROTECTED])
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Sales Engineer
/_/ /_/\_, /___/\___\_\___/ Stockholm
<___/ www.mysql.com Cellphone:
uch of an issue, and the performance gains from
those days or doing things this
way are way less now.
In some cases, cleaver SQL constructs can be used for simple conditional
processing, but it's not
generally applicable.
Good luck to you
/Karlsson
Luke Venediger wrote:
Hi Anders,
Thanks f
e my equipments in "eq", the different parameters in "eq_params"
and each change of given parameter in "eq_deltalist", how do I query for the
valid parameters a certain date (i.e. when the "lastmodified" date is
closest to the date in question) ??
Thankful for
d?"
That is, in what file and what location?
Cause now I'm curious. :)
Cheers,
Anders
+===+
|Anders Green Email: [EMAIL PROTECTED] |
| Home: 919.303
Tobias Asplund wrote:
If you installed MySQL 4.1.7 on Windows with the new installer
Yes I did.
it will automatically use InnoDB tables as the default
Ah ha. Thanks. :)
That just leaves this:
> So now my question "Where does InnoDB data get stored?"
C
There are differences, starting with 4.1.5, with the
user/schema administration, that need to be updated/massaged.
Perhaps that is your problem?
Maybe.
:)
Anders
+===+
|Anders Green Email: [EMAIL PROTECTED
IL PROTECTED]
select ifnull(column,'0') from table
_
Do You Yahoo!?
150??MP3
http://music.yisou.com/
???
http://image.yisou.com
1G??1000???
http://cn.rd.yahoo.com/mail_cn/tag/1g/*http://cn.mail.yahoo.com/event/mail_1g/
CRIPT: slots
--- END OF OUTPUT
Can somebody please help me out here? If the /usr/bin/mysqladmin tries to
use a user from localhost (any) then it fails, because "localhost" doesn't
have access to the SQL server... What user should be granted access (and
from where) to make this
ver... What user should be granted access (and
from where) to make this job work correctly?
Anders Norrbring
Norrbring Consulting
Halmvägen 42
SE-691 48 Karlskoga
SWEDEN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.my
and if the user has voted or not.
I have tried many different queries, but I haven't managed to get it to
work. Can someone help me.
My poll_votes table has this structure:
Poll_id
User_id
Time
I hope someone can help me.
- Anders Gjermshus
d as being part of something like that in 4.0 (or so it seems).
And now I close the SQL-92 standard docs. It is saturday after all and a
beautiful day outside!
Anders Karlsson
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Anders Karlsson ([EMAIL PROTECTED])
/ /|_/
at did not work, mysql automatically changed the value to 1, and that
created some trouble fore me.
Why is that? Is this a bug or Is it something I did wrong?
- anders
MOD returns the remainder of the division, assuming we use integer
arithmetic. I.e.:
234 / 10 = 23
Then 4 remains (234 - (10 * 23))
Or:
23 / 6: (23 - (6 * 3)) = 5
Best ragards
Anders Karlsson
Thomas Nyman wrote:
Hi All
I'm a bit perplexed..perhaps its a language thing,,but
the MYSQL refe
cpp : 3.3-23
bison: 1.875
autoconf: 2.53
automake: 1.5
libtool: 1.5
Thanks
Steffen
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Anders Karlsson ([EMAIL PROTECTED])
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Sales Engineer
/_/ /_/\_, /___/\___\_\___/ Stockholm
<___/ www.m
e: It is the data in the row that matters, not how
or
where it is stored.
Michael
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Anders Karlsson ([EMAIL PROTECTED])
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Sales Engineer
/_/ /_/\_, /___/\___\_\___/ Stockholm
<___/ www.mysql.com Cellphone: +46 708 608121
--
MySQL Genera
the host field of the user table in the mysql database.
I have read the docs, I have tried examples but to no avail, any and all
help is apriecieted
--
&ers
-
Anders Nygård
Västertorpsvägen 135
129 44 Hägersten Sweden
Phone 46-8-5222 35 00
Direct
bility.
Any and all help is appreciated.
--
&ers
-----
Anders Nygård
Västertorpsvägen 135
129 44 Hägersten Sweden
Phone 46-8-5222 35 00
Direct 46-8-5222 35 86
Mobile 46-73-988 65 86
www.x-source.se
>What version of MySQL do you use? autoextend is supported since
>3.23.50 and 4.0.2
Ahaa, I am using 3.23.49 (came with rh7.3).
Close but no cigar :)
--
&ers
-----
Anders Nygård
--
nd passwords is
specified.
antispam device: sql, query, queries, smallint
Merry Christmas/Happy Hannuka/Happy holidays & A Happy New Year
--
&ers
-----
Anders Nygård
-
Before posting
the ondisk-files you are also able
to ptrace mysqld and aquire the data that way. To me it seems as a
good way of making oneself just feel secure when infact it almost
doesn't buy you anything.
> PS. Please CC replies on the in
Den 01-08-07 14.57, skrev "Anders Alstrin" <[EMAIL PROTECTED]>:
> Does anyone know how to do this sub select in MySQL.
> I know how to do it in Oracle!
>
> table media
> +--+---+--+
> | media_id | price |filename |
> +--+---
Thanks everyone!
I did´nt found this URL at first but when I did everything got clearer ;)
http://www.mysql.com/doc/M/i/Missing_Sub-selects.html
Sorry for all the fuzz and RTFM was the answer!
/Anders
Den 01-08-07 17.39, skrev "Sam Masiello" <[EMAIL PROTECTED]>:
>
>
es explaining the problem
to each user - argh.
Including both fixing options might be the best for the current
situations :-)
>Submitter-Id:
>Originator:Anders Henke <[EMAIL PROTECTED]>
>Organization: Schlund+Partner AG
>MySQL support: none
>
Hello!
How do I get the size of a blob?
I want to do something like this:
SELECT * FROM blob_table WHERE size(blob_column) > 1024;
Best regards
Sven
--
---
>>> ANDURAS AG - solutions for the NET <<<>>> h
nns inte särskilt "DISTINCT". :( Samma sak händer med DISTINCTROW.
Mvh Anders Bjarby, Infomaker Scandinavia AB
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.c
he problems (my problems started after upgrading glibc).
After I downgraded glibc back to glibc-2.2.4-29 on the server I could
once again connect to mysql over network.
--
Anders Nielsen <[EMAIL PROTECTED]>
-
Before
On Mon, 2002-10-14 at 17:29, Anders Nielsen wrote:
> On Mon, 2002-10-14 at 16:51, John Hinton wrote:
> > I'm having the same problems. I'm on a RedHat machine... 7.2 running
> > MySQL ver. 3.23.41. I've been told to upgrade my package.
> >
>
> Me too.
an be done to optimize? I have considered placing the data in memory,
since speed is of more concern than data integrety. Have anybody tried that?
I am very open to suggestions.
Best regards
Anders Johannsen
Denmark
-
Before
Hi
I'm making a db design tool for the web, and would like some feedback.
Please try it out at http://dbd.aktieprat.nu/ (this domain will probably
change
later on).
TIA
/ah
-
Before posting, please check:
http://www.mysql.co
Hi
I have been building an online dbdesigner for MySQL, to be able to
design a database with some of my non-programming friends.
The result has become more than a toy, so I thought I'd show it to
y'all, dear MySQL community.
Features
* Create/change/delete databases / tables / fields / keys
* Ea
I don't know why I keep forgetting the URL every time I do this.
Here it is,
http://dbd.aktieprat.nu/
...
Anders Hedström wrote:
> Hi
> I have been building an online dbdesigner for MySQL, to be able to
> design a database with some of my non-programming friends.
&g
r alternative.
For the record, here is our configuration:
Dual opteron 250, 4 GB RAM
Debian stable, with MySQL 4.0.21 from backports.org
--
mvh. / Sincerely,
Anders Schau Knatten
Teknisk sjef / CTO
Hardware.no
email: [EMAIL PROTECTED] phone: (+47) 22 82 32 35
--
MySQL General Mailing List
For l
this
matter. Should we file a mysql bug-report?
Please advise. I am happy to provide any additional information that you
should find necesarry to resolve the issue.
Sincerely,
Anders Schau Knatten
Norway
OS: Debian GNU/Linux
Kernel: Linux 2.6.8-rc1 #4 SMP Fri Jul 16 18:03:51 CEST 2004 x86_64 unknow
1 - 100 of 102 matches
Mail list logo
