Hi!
On Aug 25, 2004, at 8:16, <[EMAIL PROTECTED]> wrote:
Is there any way to not sending the result of a user variable
assignment to
the client?
I.e. Suppress the result of;
SELECT @temp := columnID FROM table WHERE column = whatever LIMIT 0,1
...since I only use @temp in my next statement to pro
eers!
- --
Zak Greant
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.5 (Darwin)
iD8DBQFBL3x8ctLVEMjfMB0RAjmIAJ40f+eyAO6m3alwA4Nb1aZb2dOZ2wCg4w6t
OHCGMCl1oMZGxuNfYC/SaGA=
=cR3c
-END PGP SIGNATURE-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubsc
goes through internal review.
Cheers!
--
Zak Greant
MySQL AB Community Advocate
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-exception.html for a list
of licenses that are accepted in addition to the GPL.)
* See http://www.gnu.org/philosophy/free-sw.html for more information
** See http://www.opensource.org/docs/definition.php for more
information
Cheers!
--
Zak Greant
MySQL AB Community Advocate
--
MySQL General
ood question! I don't usually deal with the details of the proprietary
MySQL licensing, but I would guess that as long as a MySQL server has a
valid license, we don't care how it gets to then end user.
I can put you in touch with one of our sales team members to get you
more informatio
em, then chances are quite good that MySQL can
legally be used under the GPL.
If you build a proprietary software product that is based on MySQL and
distribute this to customers, then you probably can't do so with the
GPL licensed version of MySQL and would need to purchase non-GPL
licenses f
On Aug 11, 2004, at 2:42, [EMAIL PROTECTED] wrote:
Thank you Zak for correcting me.
Much appreciated ;-)
Hi Nils,
Glad to help!
Cheers!
--zak
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
he terms of the license. They can even use GPL licensed
MySQL and proprietarily licensed versions of MySQL at the same time.
Cheers!
--
Zak Greant
MySQL AB Community Advocate
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Aug 09, 2004, at 17:56, Jeremy Zawodny wrote:
This is confusing. There are *two* official places to discuss the
licensing and community issues?
Ugh.
Or am I misunderstanding things?
The licensing forum seems to generally be used provide quick answers on
licensing questions for proprietary soft
urce/Free
Software licenses, but gives them a revenue stream from people who
prefer traditional proprietary licenses.
Cheers!
--
Zak Greant
MySQL AB Community Advocate
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
refers to.
Also, those of you with an interest in licensing might also be
interested in the licensing forum at http://forums.mysql.com/list.php?4
- there are additional discussions there on a variety of licensing
issues.
Have a good weekend!
--
Zak Greant
MySQL AB Community Advocate
--
MySQL
Greetings All,
I walked through the mailing list thread earlier today. The big issues
that I believe that people raised were:
* Incorrect information on distribution as it applies to the GPL in
our licensing documents
* Lack of clarity from MySQL on what is and not acceptable use of
GPL-licen
report had stalled while we worked on
extending the exception to our current GPL licensing
* drop by the MySQL booth at LinuxWorld and discuss your feeling with
the MySQL team who is present. In particular, you would want to talk to
Brian Aker, Zack Urlocker and Marten Mickos.
--
Cheers!
Zak Gr
Greetings All!
MySQL AB is interested in talking to MySQL users who running MySQL on
IBM Power CPU server hardware (pSeries, iSeries, JS20
Blade).
If you (or someone you know) are willing to chat with us, please let me
know at [EMAIL PROTECTED]
Thank you for your help!
Cheers!
--
Zak Greant
/list.php?list=users-conference&sub=1 or by
sending mail to [EMAIL PROTECTED]
--
Zak Greant
MySQL AB Community Advocate
MySQL User Conference Cat Herder
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
#x27;t give you this discount. Still, drop me a line and I will buy you
a beverage of your preference at the conference. :)
Cheers!
--
Zak Greant
MySQL AB Community Advocate
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Greetings All,
If you are interested in attending the conference in person (or
virtually), please read on.
First, in addition to our regularly scheduled conference sessions, we
are going to be having about a dozen training sessions.
The sessions will let small groups of attendees (about 10 per
Greetings All,
My name is Zak Greant. I work for MySQL AB as their community advocate
- I am also helping to organize the content for our upcoming MySQL User
Conference (http://mysql.com/events/uc2004) that is happening in April.
Our deadline for choosing the final list of sessions is a couple
Greetings All,
My name is Zak Greant. I work for MySQL AB as their community advocate
- I am also helping to organize the content for our upcoming MySQL User
Conference (http://mysql.com/events/uc2004) that is happening in April.
Our deadline for choosing the final list of sessions is a couple
O'Reilly has a favorite database poll right now - visit
http://www.oreilly.com/ for details
Cheers!
--zak
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
or so with some extra
input.
Good Luck! See you in Orlando!
--
Zak Greant
MySQL AB Community Advocate
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
d from the Program or any
part thereof, to be licensed as a whole at no charge to all third
parties under the terms of this License.
Cheers!
--
Zak Greant
MySQL AB Community Advocate
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscrib
On Nov 13, 2003, at 14:02, Alaios wrote:
Hi there . How can i passwords so i can login into
myqsl. With current configuration anyone is allowded
to login.
See the REVOKE command at http://mysql.com/GRANT
Cheers!
--zak
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
T
On Nov 12, 2003, at 20:37, Paul Fine wrote:
Unless I am misinformed, subscription to the DIGEST format of this list
should cause all messages to come in one daily e-mail? Can someone
else who
is subscribed this way please at least let me know that this is at
least the
case for them?
While I do n
On Nov 12, 2003, at 17:52, Gelu Gogancea wrote:
bk pull http://mysql.bkbits.net/mysql-5.0
Try bk clone http://mysql.bkbits.net/mysql-5.0
Cheers!
--zak
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Tuesday, Oct 28, 2003, at 15:19 Africa/Accra, Erich C. Beyrent wrote:
Hey folks,
I am having a dreadful problem here, and I cannot get to the root of
it. It
appears that every time I do an INSERT, the insert happens twice. I
have
spent several days on Google, but with no luck.
Some backgro
Dear Prashant,
This list is for MySQL questions, rather than PHP questions. Please try
the PHP general mailing list ([EMAIL PROTECTED]).
Cheers!
--
Zak Greant
MySQL AB Community Advocate
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
l allow PHP to use us without licensing issues. As for Perl,
IIRC the DBI stuff is dual-licensed under Artistic/GPL - like the rest
of Perl. DBI should have no problem with the licensing change.
The details are still in flux - expect firm details in a few weeks or
so.
Cheers!
--
Zak Greant
MyS
romedia.com/devnet/mx/dreamweaver/php.html
Cheers and happy coding!
--
Zak Greant
MySQL AB Community Advocate
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
afraid that I don't know.
Does GCC run on this platform?
> Also, is there a C (not C++) API available?
The C API is the base API :)
Cheers!
--
Zak Greant
MySQL AB Community Advocate
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:h
On Thu, Mar 27, 2003 at 02:35:18PM -0600, Jeff Kilpatrick wrote:
> It's also interesting to note that it's possible to split innodb data
> between multiple files to have databases larger than the OS's max file
> size.
The theoritical maximum table size for the various storage engines is:
BDB
On Tue, Mar 25, 2003 at 06:31:55PM -0500, [EMAIL PROTECTED] wrote:
> We recently upgraded to mysql 4.0 on Mandrake 9. When typing
> safe_mysqld & mysql starts then immediately stops saying mysqld daemon ended.
> There are no other processes running. Tried installing 3.23 and the same
>
On Mon, Mar 17, 2003 at 10:47:09PM -0800, Daren Cotter wrote:
> This seems to be doing the same thing as the
> previously mentioned query...simply listing all
> mailing IDs, along with the # of members it was sent
> to. I've included both queries with their results
> below.
Hi Daren,
Heh. T
the information that you desire:
SELECT COUNT(member_id), COUNT(mail_id)
FROM member_mailings
GROUP BY mail_id;
Cheers!
--
Zak Greant
MySQL AB Community Advocate
-
Before posting, please check:
htt
Why not use the binaries from mysql.com? We recommend them over making
your own binaries.
--
Zak Greant <[EMAIL PROTECTED]>
MySQL AB Community Advocate
Personal Blog: http://zak.fooassociates.com
-
Before posting,
On Mon, Mar 03, 2003 at 08:21:58AM -0700, Zak Greant wrote:
...
> To keep closer to standard SQL, wrap the SET call in an executable
> comment, like so:
>
> /*! SET table_type=innodb; */
>
> Most (all that I know of :) databases except MySQL will treat the
ard SQL, wrap the SET call in an executable
comment, like so:
/*! SET table_type=innodb; */
Most (all that I know of :) databases except MySQL will treat the
comment like a normal multi-line comment. MySQL will strip the comment
and execute the code.
Cheers!
--
Zak Greant <[E
kes a lot of
> time,...especially as the databases grow! I do not have local access
> to the server, but I can connect to it remotely using the normal
> tools,...
mysql -h host.name.tld -u user -p < dump.file
--
Zak Greant <[EMAIL PROTECTED]>
MySQL AB Community Advocate
Personal B
> same number of rows, with the same IDs.
>
>
> Where should I be looking for reasons why the RAND() isn't very random???
Consider upgrading - the problem should be fixed in the most recent
versions of 3.23.x and 4.0.x
Cheers!
--
Zak Greant <[EMAIL PROTECTED]>
MySQL AB
preferences, nationality, etc. on the MySQL lists!
- please mail the list manager before mailing the general list. The
list manager will do what they can to solve the problem.
- we cannot condone attacks against systems suspected of delivering or
relaying spam.
Yours Truly,
Zak Greant
MySQL
pted and run in
> MySQL? thanks
Dianne,
Look up UDF in the MySQL manual.
Also, please do not send multiple copies of the same email in quick
succession - it is considered rude.
Cheers!
--
Zak Greant <[EMAIL PROTECTED]>
MySQL AB Community Advocate
Personal Blog: http
s, but can't quite nail them down, and would like to determine
> if it is PHP or MySQL that I need to address.
Hello,
Check out EXPLAIN and the slow query log in the manual.
Cheers!
--
Zak Greant <[EMAIL PROTECTED]>
MySQL AB Community Advocate
Personal Blog: http://zak.fooasso
gine.
You can use our crash-me utility to see differences in the feature set
implemented between MySQL and SAPDB. This will at least give you some
indication.
Cheers!
--
Zak Greant <[EMAIL PROTECTED]>
MySQL AB Community Advocate
Personal Blog: http://zak.fooassociates.com
AdBu
sql/sql_yacc.yy
cscope allows you to interactively browse though C source code (but
can also handle C++ well enough) - if you don't have a copy, grab one
from http://cscope.sourceforge.net/
Good Luck!
--
Zak Greant <[EMAIL PROTECTED]>
MySQL AB Community Advocate
he following but not the others.
>
> mysql -D test
mysql -e "UPDATE foo SET bar=1 WHERE baz=2;" test
For more information check the output of mysql -?
Cheers!
--
Zak Greant <[EMAIL PROTECTED]>
MySQL AB Community Advocate
Personal Blog: http://zak.fooassociates.
ccess to, or does the GRANT command handle
> that also?
The grant statement takes care of this as well. Cheers!
--
Zak Greant <[EMAIL PROTECTED]>
MySQL AB Community Advocate
Personal Blog: http://zak.fooassociates.com
Using and Managing MySQL
MySQL Training: Stockholm, February 24-
from your command line:
% mysql --execute "\u mysql; DESCRIBE table;" > table.file
--
Zak Greant <[EMAIL PROTECTED]>
MySQL AB Community Advocate
Personal Blog: http://zak.fooassociates.com
MySQL Tip: Upgrading your servers to 4.0.8? Make sure to upgrade your
clients t
:
>
> SELECT userfield.*,user.*,user.userid as userid FROM .
> [1] =>123
> [userid] => 123
>
> Is this is a bug? Or a behaviour change?
What does the query return if you run it from the MySQL command line
client?
Cheers!
--
Zak Greant <[EMAIL PROTECTED]>
source that
handles Solaris - we may have tips in there.
Cheers!
--
Zak Greant <[EMAIL PROTECTED]>
MySQL AB Community Advocate
Personal Blog: http://zak.fooassociates.com
MySQL Tip: Impress your friends with nifty MySQL one-liners
% mysql --execu
x is doing nothing:
Can you identify any major differences in system and/or database
tuning? Perhaps you are using default config settings on the new
server, but tuned settings on the old?
--
Zak Greant <[EMAIL PROTECTED]>
MySQL AB Community Advocate
Personal Blog: http://zak.fooassocia
rgetrange an index too to help speed up the
> query or will it not matter?
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (th
and reduce the lock contention.
Cheers!
--
Zak Greant <[EMAIL PROTECTED]>
MySQL AB Community Advocate
Personal Blog: http://zak.fooassociates.com
MySQL User Conference and Expo
April 10-12, 2003, San Jose, California
Visit http://mysql.co
ysql.com/search/index.php?q=locking
Cheers!
--
Zak Greant <[EMAIL PROTECTED]>
MySQL AB Community Advocate
Personal Blog: http://zak.fooassociates.com
Managing MySQL
MySQL Training: Washington DC, March 19-21, 2003
Visit http://mysql.com/training
is the weekend and that this is a volunteer
list. I would guess that our resident FreeBSD guru (Jeremy Z.) is out
working on his latest book. Assuming that you have not pissed him off,
he may help you out. :)
Cheers!
--
Zak Greant <[EMAIL PROTECTED]>
MySQL AB Community Advocate
Persona
the way you like. I am pretty tired
right now, but I can't think of another query that could return a
variable length list of fields per row. :)
--
Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com
MySQL Tip: Allow duplicate values in columns, but force
fect like this.
Something like:
SELECT CASE expression
WHEN 'value'
THEN column
...
ELSE 'default result'
END
FROM Table;
Cheers!
--
Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com
MySQL T
elieve that it would be best for the bot service to be opt-in. I
personally dislike the idea of a private automated response system for
an otherwise public list.
Cheers!
--
Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com
Using and Managing MySQL
M
s query should meet your needs:
UPDATE table
SET expired = 1
WHERE expired = 0 AND register_date < NOW() - INTERVAL 3 MONTH;
For more information, check the MySQL manual (http://mysql.com/doc/en)
and review the sections on UPDATE queries and DATE functions.
Cheers!
--
Zak
rence
has built a system like this - but AFAIK he has not put it on the web
yet. I will write him to ask if he wants to share before the
conference.
Cheers!
--
Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com
Developing Dynamic Web Applications wi
sn't it sound rude ? :-)
Heh. There are still some gems like this in the manual.:)
I have let our documentation team know about the awkward wording.
Thanks!
--
Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com
MySQL Tip: Load the contents of a text file
ed the same problem ?
Hi Okan,
Could you submit a bug report - others have reported the same problem,
but we are still working on fixing them. A bug report will help us
find the problem more quickly.
For more information, see http://www.mysql.com/doc/en/Bug_reports.html
Cheer
work with an Indian company again.
Please read carefully before abusing someone else - especially in a
public forum.
--
Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com
MySQL Tip: Allow duplicate values in columns, but force rows to be unique
mysql>
On Sun, Feb 02, 2003 at 01:21:53PM +0100, Davy Obdam wrote:
> Hi Loren,
>
> I recomend to take a look at these books:
>
> -MySQL , Paul DuBois
Make sure to get the second edition of the MySQL book - it just came
out, so some stores may have the first edition still
--
Zak
On Fri, Jan 31, 2003 at 03:45:44PM -0500, Jianping Zhu wrote:
>
> How to change mysql root password in redhat 7.3 ?
http://www.mysql.com/doc/en/Resetting_permissions.html
--
Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com
Using and Managing M
If you are using PHP, just call nl2br() on the text before you
display the text.
Cheers!
--
Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com
MySQL Tip: Show the configuration options set in the server
% mysqld --print-defaults
My punct
1 row affected (0.00 sec)
mysql> SELECT * FROM user_log;
++---+
| id | event |
++---+
| 1 | 1 |
| 1 | 2 |
| 1 | 3 |
++-------+
3 rows in set (0.00 sec)
Cheers!
--
Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | h
You can get a list of the various connections and connection states
using SHOW FULL PROCESSLIST.
See http://www.mysql.com/doc/en/SHOW_PROCESSLIST.html in the manual.
Cheers!
--
Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com
MySQL Tip: Upgrading
ike we explicitly state that you can use
multiple options anywhere on the CREATE TABLE page in the manual.
I will ask our documentation team to fix it.
Thanks!
--
Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com
Using and Managing MySQL
MySQ
> How can i resolve that problem ?
Ah... e... let me do some testing. In the past, simply running
alter table would drop the foreign keys. Now that things are
different, I will have to see what works (or ask Heikki about it)
Cheers!
--
Zak Greant <[EMAIL PROTEC
t section of the manual:
http://www.mysql.com/doc/en/User_Account_Management.html
Cheers!
--
Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com
Using and Managing MySQL
MySQL Training: Toronto, March 24-28, 2003
Visit http://mysql.com/training fo
(1). :)
Perhaps check the list archives - this question has been asked in the
past as well. IIRC, there are discussions on whether or not it should
be implemented.
Cheers!
--
Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com
MySQL Tip: Use your favorit
t data) to be presented as a single database.
This is similar to range partitioning.
Visit http://www.mysql.com/doc/en/MERGE.html for more information.
> Do InnoDB tables support partitioning?
> thanks.
AFAIK InnoDB does not support partitioning.
--
Zak Greant <[EMAIL PROT
ons=200 &
> But it is not coming up...
> How can I set max_connections as 200. Do I need to specify that in my.cnf
Good Day!
You are very close. :) Use
safe_mysqld -O max_connections=200 &
Cheers!
--
Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.
e.
If the query seems fine, then try selecting the data directly
using the MySQL command line client? i.e.
mysql -uuser -p -e"SELECT col FROM table WHERE col like 'Tampa';"
Cheers!
--
Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates
ed.
:( The InnoDB developer plans to implement this in the near future.
The only option currently is to recreate the table structure, move the
data into the new table, drop the old table and then rename the table.
Cheers!
--
Zak Greant <[EMAIL PROTECTED]> | MySQ
ield_1, field_2, field_3)
SELECT (field_1, field_2, field_3) FROM temp;
DROP TABLE temp;
Cheers!
--
Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com
Using and Managing MySQL
MySQL Training: Hamburg, March 24-28, 2003
Visit http://mysql.com/traini
ing into a record, or a way to run pre-defined queries?
Brian Aker has some examples online @ http://software.tangent.org/
Cheers!
--
Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com
MySQL Tip: Find the highest score for a given name
mysql> SE
have access to a host that runs cron, run mysqldump with the -h
option.
i.e. mysqldump -hmysql.example.com -usomeuser -p database name
Cheers!
--
Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com
Using and Managing MySQL
MySQL Training: Stockholm,
#x27; not found in library
Youw will need version 1.5 of automake (see
http://www.mysql.com/doc/en/Installing_source_tree.html) for
additional details on the tools required.
Cheers!
> P.S. MySQL, query,database
--
Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak
uipcontent -p test >
> c:\testdump.sql
>
> the file testdump.sql gets created in the appropriate place but the
> file itself has nothing in it.
>
> I'm obviously missing something.
Do you see any output when you run mysqldump without redirecting
stdout?
--
To rephrase: If you run the command
mysqldump -u uipcontent -p test
on the command line, what happens?
Cheers!
--
Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com
Developing Dynamic Web Applications with MySQL and PHP
MySQL Training: Houston, Febr
r Windows" by
Andrew Stopford (published by New Riders)
Cheers!
--
Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com
MySQL Tip: Allow duplicate values in columns, but force rows to be unique
mysql> CREATE TABLE lock (t0 TINYINT NOT NULL, t1 TINYINT NOT
quot;\n";
However, for this specific problem, you need to quote $user in your
query.
Cheers!
--
Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com
Developing Dynamic Web Applications with MySQL and PHP
MySQL Training: Nuernburg, June 02-06, 2
width of 10 will
always require 10 bytes - regardless of what is put into it.
If the column also allows NULL values, then the length of all columns
becomes 10 bytes + 1 byte for the NULL.
Cheers!
--
Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com
On Wed, Jan 15, 2003 at 12:56:39PM -0700, Hoffman, Geoffrey wrote:
> you are correct - subselects are NOT allowed until version 4
Subselects will be available in version 4.1
--
Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com
Developing Dy
did you do
the installs on, where did you try to install, etc.
Generally, (under Unix-like OSs) it is just a matter of removing the
installations directories /usr/local/mysql- and fixing your
startup scripts (if you modified them).
--
Zak Greant <[EMAIL PROTECTED]> |
binaries built for HP-UX 11.11 / RISC 2.0
Cheers!
--
Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com
MySQL User Conference and Expo
April 10-12, 2003, San Jose, California
Visit http://mysql.com/training for more information
Support Global
pport for foreign keys.
Read more at http://www.mysql.com/doc/en/SEC449.html
Cheers!
--
Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com
MySQL Tip: Display the option files read by the server
% mysqld --help
Email signatu
INDEX index_name (col_name(length))
Doing this requires less space for storing the index and should make
index generation/manipulation faster.
Please see http://www.mysql.com/doc/en/Indexes.html
Cheers!
--
Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fo
Additionally, there is a new API that is currently in development that
is intended to support the new features of MySQL like SSL connections,
prepared statements, etc.
Cheers!
--
Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com
MySQL Tip: Find the highest s
can create the backup with the mysqldump utility, with replication
or by copying the data files. See http://mysql.com/doc/en/Backup.html
for more details.
Cheers!
--
Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com
MySQL Tip: Connect to a remote MySQL
NGTH to find the length in bits.
Cheers!
:sql:
--
Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com
Using and Managing MySQL
MySQL Training: New York, January 13-17, 2003
Visit http://mysql.com/training for more information
"While we ar
sqldump utility.
% mysqldump --host mysql.example.com
For more information, see: http://www.mysql.com/doc/en/mysqldump.html
Cheers!
--
Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com
MySQL User Conference and Expo
April 10-12, 2003, San Jose, Ca
he master table to automaticly delete the
> entries from the details table without specifying this in the query.
Dear Teddy,
The InnoDB table type supports this type of functionality - see
http://www.mysql.com/doc/en/SEC449.html for more details
Cheers!
--
Zak Greant <[EMAIL PROT
will deal with the
situation as best we can.
If you wish to discuss this situation further, please mail me *off-list*
at [EMAIL PROTECTED]
Yours Truly,
Zak Greant
MySQL Community Advocate
-
Before posting, please check
asily represent the years 32768 BC to
32767 AD.
--
Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com
MySQL Tip: Connect to a remote MySQL server using the mysql client
% mysql --host=example.com --user=admin -p
Public Service Announceme
OK, 1 row affected (0.00 sec)
Cheers!
--
Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com
Using and Managing MySQL
MySQL Training: Stockholm, February 24-28, 2003
Visit http://mysql.com/training for more information
"While we are postponing, life
nd I do not know of any plans for
one.
A simple bit of shell scripting like:
mysql -e "SELECT something FROM somewhere" -H |\
sed -e 's/http:\/\/[^ ]\+/&<\/a>/'
should replace all of the valid http URLs in your HTML tables with anchors.
Cheer
ripts to check if I have
> image name like in image field so its sucks
>
> so maybe somebody can help me with that ok
Good Day Svens,
You can permanently change the database using the following query:
UPDATE foo1 SET image='noimage' WHERE check=0;
Cheers!
--
Zak
om '99 that lists the early history.
The article is at http://www.linuxjournal.com/article.php?sid=3609
I believe that David Axmark has a more up-to-date information. I will
query him to see what I can turn up.
Cheers!
--
Zak Greant <[EMAIL PROTECTED]> | MySQL
1 - 100 of 146 matches
Mail list logo