The original message was received at Mon, 28 Aug 2006 09:00:17 +0200
from mysql.com [196.94.146.79]
- The following addresses had permanent fatal errors -
- Transcript of session follows -
while talking to lists.mysql.com.:
>>> MAIL From:[EMAIL PROTECTED]
<<< 501 [EMAIL PROTECT
The original message was received at Mon, 6 Jun 2005 11:40:11 +0200
from mysql.com [50.161.69.24]
- The following addresses had permanent fatal errors -
- Transcript of session follows -
while talking to lists.mysql.com.:
>>> MAIL From:[EMAIL PROTECTED]
<<< 501 [EMAIL PROTECTED
ist companies where using
GPL-licensed software runs into policy problems, etc.
We do also sell non-GPL licenses separately from MySQL Network, to
OEM/embedded customers.
I hope this clarifies the situation to your satisfaction.
If you have any further questions, please feel free to ask me.
Regard
to
http://www.mysql.com/news-and-events/users-conference/
For more information about O'Reilly conferences, visit:
http://conferences.oreilly.com/ .
--
Arjen Lentz, Community Relations Manager
MySQL AB, www.mysql.com
MySQL related blogs @ http://www.planetmysql.org/
--
MySQL General Mail
4.0 is fairly straightforward:
http://dev.mysql.com/doc/mysql/en/Upgrading-from-3.23.html
The only thing you need to mind is to also download and install the
-shared-compat RPM, which contains the 3.23 libraries as well as the 4.0
libs, to keep some apps on FC3 happy which use 3.23 (Python f
.
Other related posts on http://www.planetmysql.org/
Have a nice weekend!
Regards,
Arjen.
> Oracle buys Finnish open source company
>
> Oracle Corp. said Friday it has bought Innobase OY, a software company
> based in Finland, for an undisclosed price.
>
> Innobase makes ope
any point in the future.
Even for an open source company, operating in the real world means that
not everything is always public.
I do appreciate that you have questions beyond the answers given so far.
At this precise moment in time, I hope you can run on the trust you have
given MySQL and its
't trivial to set up.
Would a special forum for this purpose perhaps be a good intermediate
solution? Routines could be posted there, it's searchable...
Forum = list?
I think it would be a good start, if only to discuss things like this :)
forums.mysql.com
Regards,
Arjen.
--
Ar
under the
GPL license.
If you have any feedback or questions, please feel to ask on the
dedicated forum: http://forums.mysql.com/list.php?95
Regards,
Arjen.
--
Arjen Lentz, Community Relations Manager
MySQL AB, www.mysql.com
MySQL Users Conference (Santa Clara CA, 18-21 April 2005)
Early
some time though.
Would a special forum for this purpose perhaps be a good intermediate
solution? Routines could be posted there, it's searchable...
Regards,
Arjen.
--
Arjen Lentz, Community Relations Manager
MySQL AB, www.mysql.com
MySQL Users Conference (Santa Clara CA, 18-21 April 2005)
Onl
source code and
> compiling it on our systems?
The general compile process is documented in the manual at
www.mysql.com/doc/, with specifics for various platforms. I won't
speculate what the specific issues for this new environment might be.
When the build engineers have the details, we'
nce itself, see:
http://www.mysqluc.com/
Regards, Arjen.
(Program Chair)
--
Arjen Lentz, Community Relations Manager
MySQL AB, www.mysql.com
MySQL ComCon Europe (November) www.mysqlcomconeurope.com
MySQL User Conference (April) www.mysqluc.com
--
MySQL General Mailing List
For list
SERT privs and
any other privileges you want controlled).
Depending on the cron job frequency that's slightly rougher in terms of
disk space use, but the handling could be much cleaner.
Regards,
Arjen.
--
Arjen Lentz, Community Relations Manager
MySQL AB, www.mysql.com
MySQL User Confe
s regardless of their experience or configuration choices.
In addition, we are working on a set of proactive services to help alert
you to bugs, security issues and new features.
Naturally we will also continue to educate our users about security (strong
passwords and firewalls) on all platfor
me specific cases, but this was fixed ages ago in a 4.0 release.
If I'm not mistaken, ALL combinations are now tested in the standard
test suite so any bug would block a release going out.
> I would like to have a comment on this as well... or rather: I wonder if
> anyone agrees with me
These threads do need some memory of course. The
connection-specific variables can be adjusted.
You can also set the maximum # of connections the server will allow.
Regards,
Arjen.
--
Arjen Lentz, Technical Writer, Trainer
Brisbane, QLD Australia
MySQL AB, www.mysql.com
Melbourne 1 December (5 days):
ment:
lala VARCHAR(20) BINARY NOT NULL.
That should solve your problem 100% !
Regards,
Arjen.
--
Get MySQL Training Worldwide, http://www.mysql.com/training/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /_
ion info: CC='gcc' CFLAGS='-O2 -march=i386 -mcpu=i686
Could you please try a binary distribution (from www.mysql.com) of the
same 3.23.47 and let us know how you fare with that?
Thanks.
Regards,
Arjen.
--
Get MySQL Training Worldwide, http://www.mysql.com/training/
__ ___
hen we can post you a
readable example of how it can be done.
The short answer is: use a join.
Regards,
Arjen.
--
Get MySQL Training Worldwide, http://www.mysql.com/training/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]>
/ /|_/ / // /\
server?
Aren't these typically things that a client application should sort out
for itself, in whichever way it likes?
Regards,
Arjen.
--
Get MySQL Training Worldwide, http://www.mysql.com/training/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /
st some other way, it is not
something to restart the server for! Goodness. The client can simply
reconnect, and in fact most will do so automatically without the
application even noticing that the connection was gone for a bit.
Regards,
Arjen.
--
ing/). While MySQL is not difficult to work with,
naturally you won't become an instant expert just by taking a quick look
at it. You can accelerate this learning curve with training. This may
help you both with the decision making process, as well as possible
porting.
Both consulting and tr
e.
Anyway, this way the plain end-user application can be bound by the user
permissions, there's nothing specific the application needs to do, and
no way for the user to circumvent that system.
This may not be suitable for every situation, but it might be useful
here
Regards,
Arjen.
em and MySQL Server configuration, database design and queries.
Regards,
Arjen.
--
Get MySQL Training Worldwide, http://www.mysql.com/training/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical
al system and you can't have long
(if any) downtime MySQL support is a type of insurance; most of the
time you won't need it, but when you do, it's URGENT.
MySQL AB's support people have ample experience with this kind of stuff.
Depending on what type of support contract you&#
e-1.3.23/libexec/libphp4.so does not exist.
Look at httpd.conf, where are the other Apache modules loaded from?
Check where the "make install" of PHP puts the libphp4.so
(also scan your disk for all occurrances of 'libphp4.so&
s/\.frm$/.frm/i;
s/\.(is[md]|my[id])$/\U$&/i;
rename ($a, $_) || warn "Cannot rename $a => $_ : $!";
}
[end snip]
Regards,
Arjen.
--
Get MySQL Training Worldwide, http://www.mysql.com/training/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAI
've forwarded your message there.
Regards,
Arjen.
--
Get MySQL Training Worldwide, http://www.mysql.com/training/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer
a code, and explain
exactly what you are doing. THEN people might be able to help.
Regards,
Arjen.
--
Get MySQL Training Worldwide, http://www.mysql.com/training/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__
MyISAM?
> and even i cant't change table type to INNODB using
> alter query??
This is typical of a server that does not have InnoDB support built-in
or enabled.
I think you have to sort out what you're doing where, make sure you're
configuring, starting, and connecting to the same
.
No luck in what way?
Do you have command line access on the server, and are you allowed to
stop/start the server?
Regards,
Arjen.
--
MySQL Training in Brisbane: 18-22 March, http://www.mysql.com/training/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL
ate table for each year. You can always use a MERGE table if you
need to do queries that span over multiple years.
Anyway, with the MONTH being a separate column, the GROUP statement no
longer has to evaluate an expression. So there too will it be much
faster.
These are just a few basic ideas... iss
to a single company making a large
targeted contribution. It could very well be multiple small(er)
companies that have a similar need.
The question is simply how fast you need a certain feature, and what it
will save you to have it that fast, and/or gain you by having it help
your business. That
about exactly what you are looking for... if you want
solid code, there can't be an absolute timeline with fixed release
dates. I am sure everybody prefers good code. Yet people also keep
asking about specific dates for version releases... I suppose it's
natural, we're all eager and
are removed and so the issue should
resolve itself. Of course this takes time.
Please note that the normal address for feedback regarding the manual is
[EMAIL PROTECTED]
Regards,
Arjen.
--
MySQL Training in Brisbane: 18-22 March, http://www.mysql.com/training/
__ ___ ___ __
/ |/
our table CREATE statement, and some sample queries you use?
Regards,
Arjen.
--
MySQL Training in Brisbane: 18-22 March, http://www.mysql.com/training/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Tec
d essentially have to design a new table handler. Given MySQL's
> flexibility in that respect it is conceivable that someone will provide
> products like that in the future.
Hmm, maybe just a new index type, not a complete new table handler.
Would R-tree indexes (and OpenGIS func
) ?
If it's anything before 3.23.26, definitely upgrade.
If it's a later version, it's probably a bug and in that case please do
a proper bug report detailing how we can reproduce the problem. Then
Sasha can track it down.
Regards,
Arjen.
--
MySQL Training in Brisbane: 18-22 Ma
t through the 'mysqlbug' tool?
That will ensure that these basics are present. Thanks.
Regards,
Arjen.
--
MySQL Training in Brisbane: 18-22 March, http://www.mysql.com/training/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]>
Uh, you asked the question above, but here you just state an unconfirmed
assumption as if it were a fact... ohwell.
Anyway: assumption incorrect, see above.
Regards,
Arjen.
--
MySQL Training in Brisbane: 18-22 March, http://www.mysql.com/training/
__ ___ ___ __
/ |/ /_ __/ __/ _
nt to use an escape function in PHP like mysql_escape_string()
instead of putting user-submitted data straight into your queries. This
can make things not work, or worse, cause security issues.
See also the PHP online manual:
http://www.php.net/manual/en/function.mysql-escape-string.php
Reg
ine.
Perhaps you can you elaborate on where in your project DOS needs to come
into play?
Regards,
Arjen.
--
MySQL Training in Brisbane: 18-22 March, http://www.mysql.com/training/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]>
/ /|_/
'm live in Brisbane,
Australia ;-)
Regards,
Arjen.
--
MySQL Training in Brisbane: 18-22 March, http://www.mysql.com/training/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Write
anguage you use
There is a direct API from PHP, C, Java, and many other languages.
See the manual (www.mysql.com/doc/) for more info.
Regards,
Arjen.
--
MySQL Training in Brisbane: 18-22 March, http://www.mysql.com/training/
__ ___ ___ ____ __
/ |/ /_ __/ __/ _
ex for its search. So, LIKE will be faster.
But of course REGEXP can handle more complex expressions.
Only use REGEXP if you absolutely have to.
Regards,
Arjen.
--
MySQL Training in Brisbane: 18-22 March, http://www.mysql.com/training/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /
.
Then you can do your analysis queries on the one merge table.
Regards,
Arjen.
--
MySQL Training in Brisbane: 18-22 March, http://www.mysql.com/training/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Te
t. But then, of course it's quicker.
Less data to send to the client, less data for the client to process,
and the server can clear some space (RAM or disk) and gains an idle
thread sooner (less CPU).
So, certainly LIMIT can be good in lots of ways!
Regards,
Arjen.
--
MySQL Training in Bris
index would make the query slower,
then it will not use a query.
So, indeed, EXPLAIN is affected by the actual table content (like
cardinality), or at least the quantity (total number of rows).
Therefore, usin EXPLAIN on this query with *this* data set is pretty
much useles
ut I guess the
> PHP guru's will frequent this list as well???
I'm sorry, but it's still off-topic, for obvious reasons. There will
surely also be owners of Ford cars here, but you get the idea ;-)
Regards,
Arjen.
-
on it. Otherwise you *will* get bitten at some point.
Regards,
Arjen.
--
MySQL Training in Brisbane: 18-22 March, http://www.mysql.com/training/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB,
n table takelabexam which references to courses
> should be updated automatically. but it doesn't work.
> Could any one can help me out. i will appreciate very
> much
http://www.mysql.com/doc/A/N/ANSI_diff_Foreign_Keys.html
Regards,
Arjen.
--
MySQL Training in
on RedHat 7.2 Question:
> 1)How do I get the actual length of the BLOB column in the row,
> without storing a separate column to maintain BLOB length manually?
mysql_field_lengths(), which you can call after mysql_fetch_row(), and
naturally the result will be unique for each row.
ything into a column name if you quote
it in backticks: `some thing:bla.bla`.
Maybe that knowledge will help?
Naturally, it's nicer to not have funny characters in db/table/column
names. Avoids confusion, errors, and makes things portable. Other RDBMS
will be even more picky than MySQL
to this mail id as soon as possible because we are waiting to
> tell this information to our client.
I wonder where you got that freeware/enterprise info from....
Regards,
Arjen.
--
MySQL Training in Brisbane: 18-22 March, http://www.
y appreciated.
http://www.mysql.com/doc/U/p/Upgrading-from-3.22.html
Regards,
Arjen.
--
Get MySQL Training Worldwide, http://www.mysql.com/training/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL
optimiser, and don't assume anything about ordering.
Regards,
Arjen.
--
Get MySQL Training Worldwide, http://www.mysql.com/training/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__
de it in the following loop the result is
> 50
> 333
> 333
>
> CREATE OR REPLACE Procedure SP_USER_COMMENT_2
> [...]
Looking at the above SQL code, I'm guessing that you are not using
MySQL. Since this is the MySQL mailing list
Regards,
Arjen.
--
Get MySQL
> is no local firewall on the computer blocking the port either.
Did you log on as Administrator?
And...
On Windows 2000, you should install mysqld as a service (see manual).
Regards,
Arjen.
--
Get MySQL Training Worldwide, http://www.mysql.com/training/
__ ___ ___ ____ __
/ |/
t most 1 index per included table in a query. The
optimiser will in this case not pick the MATCH for index use, so it
might pick another field (like Writer). However, *internally*, the
fulltext search function will still use the FULLTEXT index. Therefore,
effectively, two indexes can/will
Hi Kim,
On Thu, 2002-03-21 at 09:15, Kim Kohen wrote:
> G'day Arjen
Indeed, hi fellow Aussie ;-)
> > FULLTEXT search generally uses an index (the FULLTEXT index), so the
> > server will not use an index on Writer.
> So is an index on Writers worthless in this circums
ut who created each thread/process. So then you get
a fairly neat picture.
Anyway, you should never have to do anything with this for mysqld, since
stopping the server through "Kill" in the task manager is not the
cleanest method...
Regards,
Arjen.
--
Get MySQL Training Worl
Make sure you are in the directory where the server is located, then
enter this command:
C:\mysql\bin> mysqld-max --standalone
"
I didn't see the --standalone parameter in your earlier posting.
Follow the manual exactly
Regards,
Arjen.
--
Get MySQL
omains (bla.domain.com)
ordered right next to the primary domain.
It's a neat trick with minimal effort. ;-)
Hope this helps!
Regards,
Arjen.
--
MySQL Training, Support, Licenses @ https://order.mysql.com/?marl
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr.
courses, see http://www.mysql.com/training/ for details.
Regards,
Arjen.
--
MySQL Training in Australia: 9-13 Sep 2002,
https://order.mysql.com/?marl
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /_
ically, MAX() won't help you here, since it is applied *before* the
LIMIT. That's the fundamental problem with the above query.
How about this:
SELECT id FROM table WHERE DATE = '20020509' ORDER BY id LIMIT 99,1
This applies your date condition, sorts by id in ascending order
SQL-92
or SQL-99), and MySQL does not currently support that variation.
> I would appreciate to be pointed to further docs on
> this topic all the same.
The online manual can be found at http://www.mysql.com/doc/
Regards,
Arjen.
--
MySQL Training in Australia:
than the numbers you mention. Some of these
you will find as Success Stories on the MySQL website
(http://www.mysql.com/), and perhaps others will write their own reply
here. In any case, running a database of this size with MySQL is not a
problem.
Regards,
Arjen.
--
MySQL Training in Austra
e the same mysql development installation
there to do the replication. After all, you can run multiple mysql
servers on a single machine. So I'd suggest doing that. Makes for a much
clearer (and safer) setup, keeps your development stuff separate.
Hi,
On Thu, 2002-05-23 at 13:29, [EMAIL PROTECTED] wrote:
> Anybody has tried installing MySQL on CygWin?
Not to evade your question, but... why would you want this, since there
are native Windows binaries? Faster and more reliable.
Regards,
Arjen.
--
MySQL Training in Australia: 9-13
s there a documentation
> error on the autoextend syntax?
Please note that the manual states that autoextend is only supported
from 3.23.50 and 4.0.2. I'm guessing you're running an older version?
Regards,
Arjen.
--
MySQL Training in Australia: 9-13 Sep 2002,
https://order.my
If you then do SELECT LAST_INSERT_ID() or use the equivalent API
Insert_ID call, you'll get the new value of col.
This trick is actually noted in the manual.
Oh by the way, no locks required for all this.
Regards,
Arjen.
--
MySQL Training in Sydney: 9-13 Sep 2002, https://
f the DISINCT selection, then you'll need to make the filtering
slightly more complicated to have it produce an equivalent result.
Regards,
Arjen.
--
MySQL Training in Sydney: 9-13 Sep 2002, https://order.mysql.com/?marl
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Arjen G
ary with InnoDB support, and fix up the startup scripts so that
binary will be the one started.
Regards,
Arjen.
--
Get MySQL Training Worldwide, http://www.mysql.com/training/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]>
/ /|_/ / // /\
o explicitly enable them by specifying their
configuration parameters.
See http://www.mysql.com/doc/I/n/InnoDB_start.html and the rest of the
InnoDB chapter in the online manual for configuration details.
Regards,
Arjen.
--
Get MySQL Training Worldwide, http://www.mysql.com/tr
the result set is "YES", then you know that InnoDB is enabled in the
server.
> specifically whether it is making the my database memory-resident or
> not.
What do you mean?
Regards,
Arjen.
--
Get MySQL Training Worldwide, http://www.mysql.com/training/
__ ___ __
thing happens.
Regards,
Arjen.
--
Get MySQL Training Worldwide, http://www.mysql.com/training/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer
/_/ /_/\_, /___/\___\_\___/ Bris
mysql/bychapter/manual_Reference.html#DEL
> ETE with an example of code that in function resembles my code almost
> exactly.
The same page contains a note that ORDER BY in DELETE is supported from
MySQL version 4.0. So if you grab a 4.0 from www.mysql.com, you will
find that your query
. Your project actually makes this
quite easy because it itself already has clear relations (samples in a
box, boxes in a freezer, etc).
Good luck!
You may also wish to consider MySQL training, to quickly get to grips
with these concepts. See http://www.mysql.com/training/ for details on
MySQL Control Center),
downloadable from www.mysql.com. A graphical client for both Linux and
Windows. It can't do everything yet, but users say it has a very nice
intuitive interface and it's already got quite a following!
Regards,
Arjen.
--
MySQL Training in Auckland and Sydney, http://
lete a row and insert a new one and you'll definitely
find more disorder ;-)
Regards,
Arjen.
--
MySQL Training in Auckland and Sydney, http://www.mysql.com/training/
Purchase Training, Support, Licenses @ https://order.mysql.com/?marl
__ ___ ___ __
/ |/ /_ __/ __/ __ \/
> AIX 4.3.3
> MySQL 4.0.4
>
>
>innodb_data_file_path=libdata1:100M:autoextend:max:2000M;libdata2:100M:autoextend:max:2000M
Only one (generally the last) data file may be autoextend.
Regards,
Arjen.
--
MySQL Training in Auckland and Sydney, http://www.mysql.com/training/
Purchase
get that the
connection ID will be reset if you restart the server so you can't use it as
a unique key in the table).
Chances are someone has already done something like this so you may just be
able to find the script on the ne
t give
them the wrong idea? And, shouldn't we use any animal logos whatsoever for
the same reason? That seems a bit harsh especially since marketing is
all about perception.
I like the new MySQL logo, simply on artistic ground
.
Finally, there is MySQLfront (www.mysqlfront.de), a native Windows tool that
can connect directly to MySQL (ie. no MyODBC layer required).
Regards,
Arjen.
--
Get Official MySQL Training Worldwide, http://www.mysql.com/training/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. A
select statement to create the temporary table and allow
you to pick (sets of) rows at will.
FYI, optimization techniques are an important part of MySQL training courses
(http://www.mysql.com/training/).
Regards,
Arjen.
--
Get Official MySQL Training Worldwide, http://www.mysql.com/training/
atabase for storage.
RDBMS are very good at summarizing, selecting sets of data according to
search parameters,
etc. But you have to design your tables with this in mind, otherwise you
miss out on all the benefits.
Regards,
Arjen.
--
MySQL Training Worldwide, http://www.mysql.com/traini
you don't need to specify any
inclosure characterrs.
Regards,
Arjen.
--
MySQL Training Worldwide, http://www.mysql.com/training/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer
/_/
query on the list, we could have
a quick look at what things can be optimized. I have recently sent a reply
to another user on the list which also talks about the basics of server
configuration. You may find it of help for your situation too
Regards,
Arjen.
--
MySQL Training Worldwide, http://w
uld rather do it from the mysql command line.. (i am
> on win2k)
Well that's no problem! You can modify the timeout in a PHP script with
the set_time_limit() function.
You may also want to look at the INSERT ... SELECT style statement,
that could provide a very simple
aking, MySQL is extremely fast. If queries become slow,
it's generally time to look at your table and query design, and MySQL
configuration settings. Only in the last instance would one look at
hardware.
Regards,
Arjen.
--
MySQL Training Worldwide, http://www.m
c/c/o/configure_options.html
I do believe this option addresses the issue put forward by Frank and
Shelby.
Regards,
Arjen.
--
MySQL Training Worldwide, http://www.mysql.com/training/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <
when will it be released?
The aim is around December/January for alpha release.
See http://www.mysql.com/doc/N/u/Nutshell_Stepwise_Rollout.html
Regards,
Arjen.
--
MySQL Training Worldwide, http://www.mysql.com/training/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Ar
ith regard to the copyright and licensing of MySQL, you can find more
information here:
http://www.mysql.com/doc/C/o/Copyright.html
Amongst other things, it is important to note that the manual is not
distributed under GPL.
We look forward to seeing your contributions!
Regards,
Arjen.
--
My
has some examples on when a commercial license
is required and when it is not.
You will also find contact info there, in case you have more questions.
Hope this helps.
Regards,
Arjen.
--
MySQL Training Worldwide, http://www.mysql.com/training/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /
ql/alternate.html), for instance
in HTMLs, or PDF format (if you want to print it for comfy reading).
Regards,
Arjen.
--
MySQL Training Worldwide, http://www.mysql.com/training/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]>
/
; If you use these settings and have a suggestion or other feedback,
; please e-mail [EMAIL PROTECTED] (Arjen Lentz).
asp_tags=Off
short_open_tag=Off
allow_url_fopen=Off
warn_plus_overloading=1
;doc_root =...
;open_basedir=...
ignore_user_abort =1
max_execution_ti
from a client, the output uses backticks
like `version` which also prevents any probs.
So, sneaky though it may be, it will actually work! ;-)
You said you were using 3.23.32 if you get different out there from
described above, it has been fixed since.
Okidoki?
Regards,
Arjen.
--
MySQL Train
ng through a good
wrapper.
Regards,
Arjen.
--
MySQL Training Worldwide, http://www.mysql.com/training/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer
/_/ /_/\_, /___/\___\_
cnt > 0 GROUP BY id;
[snap]
I have now put an explicit reference to this section in the explanation of the
SELECT statement in the manual, as I'm sure you're not the first to trip over
this one ;-)
Thanks for your feedback!
Regards,
Arjen.
--
MySQL Training Worldwide, http://www.
ove the single quotes, or change them to double quotes.
PHP does not expand variables for single-quoted strings.
Regards,
Arjen.
--
MySQL Training Worldwide, http://www.mysql.com/training/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz &l
1 - 100 of 119 matches
Mail list logo
