Re: Licence question

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

MySQL User Conference 2004 Call for Papers

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]

Polls on O'Reilly

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]

MySQL User Conference 2004: Choosing the Internals/Advanced Sessions

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

MySQL User Conference 2004: Choosing the General Sessions

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

MySQL User Conference Computer Lab Sessions and Early Bird Sessions

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

Re: MySQL 4.1 and PHP/Perl Clients

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

Any MySQL + IBM Power CPU Hardware (pSeries, iSeries, JS20, Blade) Users?

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

Re: using mysql in commercial software

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

Re: using mysql in commercial software

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

Re: using mysql in commercial software

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

Re: using mysql in commercial software

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]

Re: using mysql in commercial software

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

Re: On the licensing once again

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]

Re: On the licensing once again

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]

Re: R: On the licensing once again

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

Re: R: On the licensing once again

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

Re: On the licensing once again

-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

Clarifying the MySQL Licensing Policy Documents

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]

Clarifying the MySQL Licensing Policy Documents Pt. II

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

Re: Suppression of result in SELECT @temp := column?

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

Re: Unable to Retrieve HTML Form Values(test1.html) from a PHP Page(test1.php)

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

Re: Insert happens twice

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

Re: Can not make PULL from mysql.bkbits.net

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]

Re: Digest Again, PLEASE SOMEONE HELP?

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

mysql@lists.mysql.com

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

Community Contributor Discount for the 2004 MySQL User Conference

#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]

MySQL Users Conference: New mailing list for those interested in the event

/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]

Re: MySQL history

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

Re: Help - select syntax if else

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

Re: converting text to hypertext

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

Re: Row value uniqueness?

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

Off-Topic Posts

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

Re: relations between tables

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

Re: Dumping remote DB

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

Re: Year data type

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

Re: Blobs

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

Re: Question

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

Re: Upgrading to version 4.

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

Re: indexing a blob

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

Re: Foreign keys

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

Re: details needed

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

Re: Uninstall MySQL?

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]> |

Re: Confirmation of SELECT...IN syntax

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

Re: Avg_row_length

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

Re: Authenticating users

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

Re: mySQL and SQL

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

Re: mysql dump not working

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

Re: mysql dump not working

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? --

Re: building 4.1 from source

#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

Re: mysql dump for remote db

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,

Re: examples of user defined functions

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

Re: copying a row

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

Re: Dropping foreing key without losing data

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

Re: MySQL Truncated returns

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

Re: How can I start my mysql server with max_connections option

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.

Re: partitionong MyISAM tables??

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

Re: Newbie Q: Booleans??

(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

Re: User Accounts...

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

Re: RE : Dropping foreing key without losing data

> 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

Re: Question about Table_Options

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

Re: # of connected user

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

Re: Autoincrement : how does it work / how to reset it

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

Re: line breaks

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

Re: how to change mysql root password

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

Re: What are the best MySQL and PHP resource books?

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

Re: Off Topic - PHP/Mysql Development

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>

Re: optimize table failure

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

Re: Is it my English or does this sound bad?

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

Re: Is there a SQL/diff program out there?

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

Re: updating some records in a table

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

Re: How to build Relay Replication system ?

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

Re: MySQL Feature

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

Re: MySQL Feature

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

Re: REPOST: MySQL 3.23.54 is a buggy, crashing piece of crap.

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

Re: Mysql Table locking

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

Re: Mysql Table locking

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

Re: How do I use COUNT() and DISTINCT together?

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

Re: Very poor Solaris benchmarks

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

Re: Very poor Solaris benchmarks

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

Re: BUG Mysql 3.23.54

: > > 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]>

Re: redirect mysql output to file

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

Re: MySQL Grant issue

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-

Re: Start MySQL along with a update statement.

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.

Re: MySQL codes

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

Re: MySQL v SAB DB

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

Re: Is there a way to time queries?

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

Re: convert to mysql function

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

Re: SPAM

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

Re: RAND() isn't :)

> 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

Re: Restoring from a mysqldump file

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

Re: Table Create Defaults (Type=InnoDB)?

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

Re: Table Create Defaults (Type=InnoDB)?

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

Re: But now new problems :-(

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,

Re: Help with Query

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

Re: Help with Query

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

Re: MYSQL ending right after starting

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 >

Re: database size

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

Re: Support for Dynix/ptx

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

Re: [MySQL] RE: Question: Connecting MySQL with DreamWeaver MX on Windows 2000

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]

  1   2   >