RE: Re: [OT] PostgreSQL / MySQL Data Dictionary

> mysqldump --no-data --all-databases > > > Eamon Daly Yeap Eamon, as mentioned MyRun is not the only utility on earth with the functionality. The difference between mysqldump and MyRun is that while MyRun includes all the mysqldump

Order by with one exception

Mysql 4, this has been bothering me for some time now... I made a mailing list archiver, I "thread" discussions by subject. I chose to not use message-id's since so many people hijack threads. In most cases, I ORDER BY id, which is simply a auto-inc that is set as they come in, in order via emai

Re: Proper parens in OR searches

on 8/11/04 9:48 PM, Michael Stassen at [EMAIL PROTECTED] wrote: > With parens: > >SELECT id, name FROM listmail >WHERE date_time > DATE_SUB(NOW(), INTERVAL 30 DAY) >AND (subject = 'semaphore' > OR subject = 'Re: semaphore' > OR subject = 'Re:semaphore') >ORDER BY id ASC

Re: Proper parens in OR searches

Scott Haneda wrote: This SQL in mysql 4 is too aggressive and seems to ignore my 30 day date range, if I remove the AND it finds the date range I want, putting it back in does not. I have tried various ways of wrapping ( and ) in the SELECT to no avail. Because AND takes precedence over OR. I am t

representing a sequence of events in a database

Hi, I have the following problem: I want to store a list of events e_1 to e_n in one table, and in a second table I would like to store sequences of these events so that later I can ask questions like: In what sequence has event e_5 happened as the third event. My more or less trivial solution wou

Keyword Search

I am new to Lasso and My SQL, but I have a pretty basic question on searching a text field using Keywords. I think I am missing something easy. I have a MySql database and am using Lasso 7. The user enters search information on a form on a search.lasso page and an inline search is then ru

Re: R: On the licensing once again

On Aug 11, 2004, at 11:45, Santino wrote: I think that the license scheme is very simple reading gnu faq: If you distribute your software under GPL you and your customer don't need a commercial license but the user can change your code and give it away with a GPL license. In every other case you

Re: R: On the licensing once again

On Aug 11, 2004, at 7:09, Leonardo Francalanci wrote: If you develop a product, say, some kind of online shopping system that you distribute on a CD which installs Linux, Apache, MysQL, PHP and your App and distribute that, then you probably should be paying for a license. This is because instead

Proper parens in OR searches

This SQL in mysql 4 is too aggressive and seems to ignore my 30 day date range, if I remove the AND it finds the date range I want, putting it back in does not. I have tried various ways of wrapping ( and ) in the SELECT to no avail. I am trying to get all records where the subject is one of the

Re: Question about case statement

The original problem was that CASE returns the result corresponding to the matching condition. It isn't really a flow-control function. I don't think Lachlan's suggestion is right either, though. Its missing a comma, I think, but more importantly, it will set QE and QF to NULL whenever they a

RE: Question about case statement

Hi there, What you probably want is UPDATE temp SET QE = CASE WHEN QE = 1 THEN 6 END QF = CASE WHEN QF = 1 THEN 5 END WHERE QA = 1 AND (QE <> 6 OR QF <> 5) http://dev.mysql.com/doc/mysql/en/Control_flow_functions.html Lachlan -Original Message- From: Mo Li [mailto:[EMA

Re: MySQL know

Sorry, I don't speak any Spanish. Are you asking what programming languages can be used to write programs that access MySQL? If that's what you mean, I know that you can use Java, php, Perl and C languages at the very least. There are probably several other languages that work with MySQL but I'm n

Question about case statement

Hello, I'm trying to update table by using case statement. I used following syntax: UPDATE temp SET CASE WHEN QE = 1 THEN QE = 6 WHEN QF = 1 THEN QF = 5 END WHERE QA = 1 AND ( QE != 6 OR QF !=5) but it didn't work. I checked the manual and didn't see where is the problem. Thanks for any help.

RE: MySQL know

En español lo más útil que he visto es: www.mysql-hispano.org/ Para crear tablas y en general para hacer algo útil en MySQL se necesita aprender SQL, hasta donde yo se, con solo MySQL instalado no vas a poder crear aplicaciones y solo podrás interactuar con el por medio de la línea de comandos

MySQL know

I install MySQL Server in my computer, now how a can run the program to make a code In whats program I write the code thanks Yusdaniel Por si alguien habla español: Yo instale el MySQL Server en mi computadora, quiero empezar a aprender a programar en el, pero no encuentro ningun eje

Corrupt table, mysqld crashes, server crashes. Looking for a solution

Today it happened again. For the third time in the last two weeks, my user table got corrupt. I don't know what the problem is Besides that, the server has also a lot of trouble with the fact that sometimes the MySQLd just stops functionizing somehow, and the only way to kill the (all child pro

Re: HELP!!! SEVERE: VendorError: 1064 during INSERT

I didn't actually count the characters but it looks very close to a 512-character limit. (I used a pica stick on the screen, very accurate!) The error message appears to be showing a truncated line. Is possible? --Jon > > > > > > INSERT INTO dirxml.emp > > > (fld_ind_id,fld_frname,fld_srname,fld_

Re: [OT] PostgreSQL / MySQL Data Dictionary

I couldn't follow the threading for this one, but you can quickly and easily dump the table structures for all or part of your MySQL databases with mysqldump: mysqldump --no-data --all-databases This dumps all the database and table creates thusly: -- -- Current Database: test -- CREATE DATABAS

RE: Re: [OT] PostgreSQL / MySQL Data Dictionary

> In MySQL, by parsing the output of SHOW CREATE TABLE. > > It would be a boon if someone were to write a utility, in an OS-independent > language, which does that parsing for all tables in a MySQL database and > returns SQL output that's suitable for creating a set of system tables. > Obviously

MS Server 2003

Hello mysql, I have been using MySQL on MS Server 2000 and happy enough with it. I'm just migrating To MS Server 2003 Enterprise Edition Does any body have an experience of particular problems? -- Best regards, Arthur mailto:[EMAIL PROTECTED] -- MySQL Gene

Can't get C API to recognize Option File

>Description: In spite of many different calls to mysql_options(), I have not been able to get the C API to recognize an Option File. I have also tried many different calls to mysql_real_connect(). I can use the standard ~/.my.cnf with the mysql client, but the onl

Re: Importing from plain text?

-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 On Wednesday 11 August 2004 10:27, Cemal Dalar wrote: > make you text file format same as the table format . then use > > mysqlimport database_name table_name.txt > > by default mysqlimport need tab delimited text. if you need ; or other > use --f

Re: C API: mysql_options and mysql_real_connect

At 13:03 -0700 8/11/04, V. M. Brasseur wrote: Assuming a my.cnf file which looks like this: [client] port=3306 socket=/path/to/mysql.sock [app] user=appuser password=apppwd host=my.host.com Ignore for now the insecurity of putting a password in the my.cnf file. This is mostly a hypo

Re: HELP!!! SEVERE: VendorError: 1064 during INSERT

- Original Message - From: "Rhino" <[EMAIL PROTECTED]> To: "Shaffin Bhanji" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, August 11, 2004 4:20 PM Subject: Re: HELP!!! SEVERE: VendorError: 1064 during INSERT > I think what Victor meant is that you should

OpenSSL

> I'm having a problem getting MySQL 4.0.20 compiled w/ SSL support on one > of my servers. configure finds what it's wanting for SSL support but the > make fails every time. Technically this a RH9 box, although it doesn't > much resemble one after I'm through with it. OpenSSL is of course > com

Re: HELP!!! SEVERE: VendorError: 1064 during INSERT

I think what Victor meant is that you should show the *output* from a System.out.println() that displays the exact contents of the SQL string that you are executing. Can someone refresh my memory: isn't it normal practice to use apostrophes (also known as "single quotes") around literals in SQL st

Re: MySQL Data Dictionary (INFORMATION_SCHEMA)

On Wed, 11 Aug 2004 12:09:34 -0700 Jim Winstead <[EMAIL PROTECTED]> wrote: > On Wed, Aug 11, 2004 at 07:03:18PM +0200, Jochem van Dieten wrote: > > MySQL strives to ful SQL standard compliance (ISO/IEC 9075), so an > > INFORMATION_SCHEMA must be planned for someday. However, that day > > does not

C API: mysql_options and mysql_real_connect

Assuming a my.cnf file which looks like this: [client] port=3306 socket=/path/to/mysql.sock [app] user=appuser password=apppwd host=my.host.com Ignore for now the insecurity of putting a password in the my.cnf file. This is mostly a hypothetical question at the moment. Calling mysq

RE: HELP!!! SEVERE: VendorError: 1064 during INSERT

The statement is from a System.out.println() and my code is as follows: public boolean insert(String sql) { try { System.out.println("Executing INSERT SQL Statement -> " + sql); statement = conn.createStatement();

RE: Auto_increment and existing table

Thanks! -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 11, 2004 3:40 PM To: 'Scott Hamm '; ''Mysql ' (E-mail) ' Subject: RE: Auto_increment and existing table If you do an ALTER TABLE table_name MODIFY id INTEGER AUTO_INCREMENT, ADD PRIMARY K

RE: HELP!!! SEVERE: VendorError: 1064 during INSERT

Can you system.out.println the sql statement to verify what you have is correct? Also, are you using prepared statements? -Original Message- From: Shaffin Bhanji To: [EMAIL PROTECTED] Sent: 8/11/04 2:07 PM Subject: HELP!!! SEVERE: VendorError: 1064 during INSERT Hello All, I have the fo

RE: Auto_increment and existing table

If you do an ALTER TABLE table_name MODIFY id INTEGER AUTO_INCREMENT, ADD PRIMARY KEY(id); ... The next record entered should be properly auto_incremented. -Original Message- From: Scott Hamm To: 'Mysql ' (E-mail) Sent: 8/11/04 1:32 PM Subject: Auto_increment and existing table I've impo

Re: MySQL Data Dictionary (INFORMATION_SCHEMA)

On Wed, 11 Aug 2004 12:09:34 -0700, Jim Winstead wrote: >On Wed, Aug 11, 2004 at 07:03:18PM +0200, Jochem van Dieten wrote: >> MySQL strives to ful SQL standard compliance (ISO/IEC 9075), so an >> INFORMATION_SCHEMA must be planned for someday. However, that day does >> not appear to be in the near

MySQL Data Dictionary (INFORMATION_SCHEMA)

On Wed, Aug 11, 2004 at 07:03:18PM +0200, Jochem van Dieten wrote: > MySQL strives to ful SQL standard compliance (ISO/IEC 9075), so an > INFORMATION_SCHEMA must be planned for someday. However, that day does > not appear to be in the near future. INFORMATION_SCHEMA will be supported in MySQL 5.0.

HELP!!! SEVERE: VendorError: 1064 during INSERT

Hello All, I have the following environment: MySQL 4.1.3-beta-standard Connector/J 3.0.14 SUN Java JDK 1.4.2 SUSE Linux 9.1 I have written a java program to insert information into an "emp" table as follows: INSERT INTO dirxml.emp (fld_ind_id,fld_frname,fld_srname,fld_init,fld_sh_name1,fld_sh_n

Auto_increment and existing table

I've imported Access DB into MySQL, and AutoID was lost. The number in ID column exists and I wonder if I update the column from int(10) to auto_increment, will it replace existing number with MySQL's auto_increment number? Or is there a proper way to update from int(10) to auto_increment without r

Re: [OT] PostgreSQL / MySQL Data Dictionary

> SHOW TABLES does not make sense. How are you going to join the > output of SHOW TABLES against the output of SHOW COLUMNS and > SHOW INDEXES? In MySQL, by parsing the output of SHOW CREATE TABLE. It would be a boon if someone were to write a utility, in an OS-independent language, which does th

Re: Importing from plain text?

It sounds like you want the LOAD DATA function, found at http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html As long as there is some wat of distinguishing the two fields in the file, you can load them into MySQL. Mike Hillyer Robin Lynn Frank wrote: -BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD

Converted successfully!

I used this program Navicat 2004 and it looks like it has done a really nice job of converting my access db to mysql so there you go then -- 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

I think that the license scheme is very simple reading gnu faq: If you distribute your software under GPL you and your customer don't need a commercial license but the user can change your code and give it away with a GPL license. In every other case you need a commercial license. The point of GP

Re: Changing Fulltext defaults in Win32

for sure :) Best Regards, Cemal Dalar a.k.a Jimmy System Administrator & Web Developer http://www.dalar.net - Original Message - From: "leegold" <[EMAIL PROTECTED]> To: "Cemal Dalar" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, August 11, 2004 8:32 PM Subject: Re: Changin

Re: Changing Fulltext defaults in Win32

On Wed, 11 Aug 2004 20:29:54 +0300, "Cemal Dalar" <[EMAIL PROTECTED]> said: > put a line like below to your my.cnf file under [mysqld] section > > ft_min_word_len=2 I assume I should shutdown-restart MYSQL after I do that ? Thanks, Lee G. snip -- MySQL General Mailing List For list archi

Re: Changing Fulltext defaults in Win32

put a line like below to your my.cnf file under [mysqld] section ft_min_word_len=2 Best Regards, Cemal Dalar a.k.a Jimmy System Administrator & Web Developer http://www.dalar.net - Original Message - From: "leegold" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 11,

Re: Importing from plain text?

make you text file format same as the table format . then use mysqlimport database_name table_name.txt by default mysqlimport need tab delimited text. if you need ; or other use --fields-terminated-by= http://dev.mysql.com/doc/mysql/en/mysqlimport.html Best Regards, Cemal Dalar a.k.a Jimmy Sys

Changing Fulltext defaults in Win32

I'm using MYSQL 4.x on Win2k. I want to change the default smallest word size from the default (4 chars I think) to 2chars. Any links, how-to's appreciated. Thanks, Lee G. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAI

Re: [OT] PostgreSQL / MySQL Data Dictionary

On Wed, 11 Aug 2004 11:04:01 -0500, Josh Trutwin wrote: > On Wed, 11 Aug 2004 17:20:45 +0200 Jochem van Dieten wrote: >> >> SHOW TABLES does not make sense. How are you going to join the >> output of SHOW TABLES against the output of SHOW COLUMNS and SHOW >> INDEXES? >> >> SELECT * FROM INFORMATIO

Importing from plain text?

-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 My apologies for so basic a question, but I am just getting started with mysql. I have a text file that looks like this: textother text text2 othertext2 [...] I want the text in the left column in one field and the text in the rig

Re: On the licensing once again

On Wed, Aug 11, 2004 at 05:43:16PM +0200, Leonardo Francalanci <[EMAIL PROTECTED]> wrote: > > If you develop a product, say, some kind of online shopping > > system that you > > distribute on a CD which installs Linux, Apache, MysQL, PHP and > > your App and > > distribute that, then you probably

RE: Indicating an INDEX during TEMPORARY table creation

You will need to know the name of the column(s) you will be indexing in order to do this. create temporary table some_table (index idx_name(col1) SELECT * from source_table -Original Message- From: David Perron To: [EMAIL PROTECTED] Sent: 8/11/04 11:36 AM Subject: Indicating an INDEX duri

Re: MySQL Tables

Thanks Victor - Original Message - From: "Victor Pendleton" <[EMAIL PROTECTED]> To: "'EWAGW '" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, August 11, 2004 11:38 AM Subject: RE: MySQL Tables > Unless you are specifying some other type in your table creation statements, > you

MySQL Tables

Easy Martijn!! I am a newbie ;-) please do not be surprised if you see a lot more stupid questions!! Seriously though can I use MySQL front for converting access dbs or is there a better program? Thanks a lot -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsu

Re: On the licensing once again

> If you develop a product, say, some kind of online shopping > system that you > distribute on a CD which installs Linux, Apache, MysQL, PHP and > your App and > distribute that, then you probably should be paying for a license. This is > because instead of you handing over full code (and it's rig

RE: MySQL Tables

Unless you are specifying some other type in your table creation statements, your tables will be created as MyISAM. -Original Message- From: EWAGW To: [EMAIL PROTECTED] Sent: 8/11/04 11:30 AM Subject: MySQL Tables Hi list, If I am converting an access db to mysql what will the tables be

Indicating an INDEX during TEMPORARY table creation

When executing: CREATE TEMPORARY TABLE temp_1 AS SELECT * FROM table_name Is it possible to indicate an index within the syntax of this statement - as opposed to issuing an ALTER TABLE command after the table is created? Thanks in advance for any help. -- MySQL General Mailing List For

Re: MySQL Tables

> Hi list, If I am converting an access db to mysql what will the tables be > MyISAM? Thanks That depends on your tool, your settings and what not. Ask a better question if you want a better answer. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, My

MySQL Tables

Hi list, If I am converting an access db to mysql what will the tables be MyISAM? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: [OT] PostgreSQL / MySQL Data Dictionary

On Wed, 11 Aug 2004 17:20:45 +0200 Jochem van Dieten <[EMAIL PROTECTED]> wrote: > SHOW TABLES does not make sense. How are you going to join the > output of SHOW TABLES against the output of SHOW COLUMNS and SHOW > INDEXES? > > SELECT * FROM INFORMATION_SCHEMA.TABLES makes sense. > > > And as f

Get General Log and Binary Log location from MySQL database.

I am using MySQL 4.1.3 and wondering if there is any way to get binary log, and general log location by querying database. I've checked mysql> show variables; command, but it only returns if log is ON or OFF. Thanks, Aleksandar - Do you

Re: Replication - multiple masters

I've come up with pretty much the same solution to that problem. Here's an alternative solution that requires a lot more work, but is prettier. Set up a MySQL proxy server (of sorts). What it will do is act as a slave to multiple masters, merge the log files it receives from them, and act as

MySQL not detecting OpenSSL install

I'm having a problem getting MySQL 4.0.20 compiled w/ SSL support on one of my servers. configure finds what it's wanting for SSL support but the make fails every time. Technically this a RH9 box, although it doesn't much resemble one after I'm through with it. OpenSSL is of course compiled from

Replication - multiple masters

Hello, list. I have seen this subject come up here more than once, but I have never seen a solution I liked. The drill is pretty standard: I have several (4 to be more precise) MySQL 4.1.2 servers running 13 different databases. All of them use MyISAM tables, except for one, which uses

Re: Concat fields

"Paul McNeil" <[EMAIL PROTECTED]> wrote: > If I am not running 4, is there another way to achieve the same result as > GROUP_CONCAT(myField) > ? I don't think so. :( -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://w

Re: Difference between PostgreSQL and MySQL

On Wed, 11 Aug 2004 10:00:32 -0500, Josh Trutwin wrote: > On Tue, 10 Aug 2004 23:34:49 +0200 Jochem van Dieten wrote: >> On Tue, 10 Aug 2004 16:00:12 -0500, Josh Trutwin wrote: >>> >>> MySQL's command line interface and programming API also are nicer >>> for newer users. Why in the world do I need

Re: Difference between PostgreSQL and MySQL

On Tue, 10 Aug 2004 23:34:49 +0200 Jochem van Dieten <[EMAIL PROTECTED]> wrote: > On Tue, 10 Aug 2004 16:00:12 -0500, Josh Trutwin wrote: > > > > One area where MySQL beat Postgres is in Windows installation. > > Installing postgres on Windohs is like pulling your fingernails > > off slowly. >

Re: my.cnf - do we need it or not?

You'll get better results if you keep threads on the list. Server settings are described in the manual: Tuning server settings is also described:

Re: Difference between PostgreSQL and MySQL

On Tue, 10 Aug 2004 23:40:39 +0200 Jochem van Dieten <[EMAIL PROTECTED]> wrote: > On Tue, 10 Aug 2004 16:49:26 -0400, [EMAIL PROTECTED] > <[EMAIL PROTECTED]> wrote: > > Well, since you admitted to being a newbie, I would suggest that > > you learn with MySQL. It supports several types of data stor

Fulltext Search takes 17 sec.

I am trying to do a fulltext search on my database of 3.3 million rows (~ 1 Gb). I attempted to make the searching faster by concatenating all columns I wanted to search and placed them in a table: product_fulltext (product_id, search_text) Then I added the fulltext index: ALTER TABLE product

Converting access to mysql db

Hi all, does anyone use this program MySQL Front 2.8 to convert access to mysql? I have been looking in the menus and cant see anything to do it. Any other programes that do the job? Thanks a lot for any advice -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsu

RE: Concat fields

If I am not running 4, is there another way to achieve the same result as GROUP_CONCAT(myField) ? God Bless Paul C. McNeil Developer in Java, MS-SQL, MySQL, and web technologies. Microneil research Sortmonster Anti Spam GOD BLESS AMERICA! To God Be The Glory! -- MySQL Genera

R: On the licensing once again

> If you develop a product, say, some kind of online shopping > system that you > distribute on a CD which installs Linux, Apache, MysQL, PHP and > your App and > distribute that, then you probably should be paying for a license. This is > because instead of you handing over full code (and it's rig

Re: my.cnf - do we need it or not?

But only if you need to change settings from the defaults. [EMAIL PROTECTED] wrote: Not if you are are on a Win32 platform, all you need is my.ini. Otherwize with the *nix versions, you do need it. "Scott Fletcher" <[EMAIL PROTECTED]> wrote on 08/11/2004 09:35:22 AM: Hi! Do we really need the m

Re: my.cnf - do we need it or not?

Not if you are are on a Win32 platform, all you need is my.ini. Otherwize with the *nix versions, you do need it. "Scott Fletcher" <[EMAIL PROTECTED]> wrote on 08/11/2004 09:35:22 AM: > Hi! Do we really need the my.cnf file to tweak MySQL? Mine doesn't > have it and it just work fine... > >

Re: High Memory Usage

On Tuesday 10 August 2004 05:25 pm, Jeremy Zawodny wrote: > On Thu, Aug 05, 2004 at 10:27:54AM -0500, Sashi Ramaswamy wrote: > > Hi, > > > > All of a sudden the memory used by mysql threads has gone up. Each thread > > is consuming about 20 M of RAM. My databases are really small and usage > > is

my.cnf - do we need it or not?

Hi! Do we really need the my.cnf file to tweak MySQL? Mine doesn't have it and it just work fine... Thanks, Scott

Re: RE Concat fields

If you use mysql 4.1, you can use GROUP_CONCAT(). See the manual for details . Michael Paul McNeil wrote: Thank you for your response, Egor. My question is whether or not it is possible to concatenate the fields without knowing the even

Re: What capacity of registers will mysql support?

I am not exactly sure what you mean by the term "registers". I have heard of databases being described as fields (columns) and tuples (rows). Registers is only something I have heard in association with CPU architecture If you mean "can MySQL handle a dataset of 20 million rows?" the answer

RE Concat fields

Thank you for your response, Egor. My question is whether or not it is possible to concatenate the fields without knowing the event ID. pseudo SQL Select concat(data from all grouped fields) from foo group by (eventID); God Bless Paul C. McNeil Developer in Java, MS-SQL, MySQL, and web technol

Re: What capacity of registers will mysql support?

"EWAGW" <[EMAIL PROTECTED]> wrote: > Will it work with 20 million for example? Thanks a lot for any advice Like a charm. :) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __

RE: R: On the licensing once again

You're overcomplicating things here.. MySQL is either one license or the other. If for any reason you're required to have a licensed copy of the MySQL server on a particular machine and you buy a licensed copy for it. It remains a licensed copy.. whether you use any additional closed, open or othe

Re: Concat fields

"Paul McNeil" <[EMAIL PROTECTED]> wrote: > How can I combine the elements from many text fields into one text field. See http://dev.mysql.com/doc/mysql/en/String_functions.html, in particular, you need CONCAT() > I have a table. > ID(auto inc) eventID data > > ID is unique > eventID

Concat fields

Good morning to all. How can I combine the elements from many text fields into one text field. I have a table. ID(auto inc) eventID data ID is unique eventID is repeated data represents what happened at this event. I would like to return all of the data for a given event ID, sorted b

Re: Simple list sought

- Original Message - From: "Scott Hamm" <[EMAIL PROTECTED]> To: "'Mysql ' (E-mail)" <[EMAIL PROTECTED]> Sent: Wednesday, August 11, 2004 7:52 AM Subject: Simple list sought > Do anyone know where I can find a simple table that specify > character/max/min specifications of each types i.e

Re: R: On the licensing once again

LF> What if I sell a web site built using mysql? LF> Do I need a license on my web server? The conclusion i have made is that from end-user point of view his mySQL is running under multiple licencies simultaniously depending on what 3rd parties software makes request to it. To be more precise at a

RE: Simple list sought

Thanks!! It is located here: http://dev.mysql.com/doc/mysql/en/Numeric_types.html after picking up your pointer. "column types" was what I were trying to think up -- Appreciate it very much. -Original Message- From: Lachlan Mulcahy [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 11,

RE: removing duplicates and giving average of other field.

Hi Jeroen, Have you tried creating a new table by selecting the data that you want and then removing the old table and replacing it with the new one. Eg. CREATE TABLE new_g2d ( chr char(10) NOT NULL DEFAULT '', start int NOT NULL DEFAULT 0, stop int NOT NULL DEFA

Re: On the licensing once again

If someone pays you to develop a website for them based on MySQL, you won't pay for it. As you are not selling a product that contains MySQL. You are selling your service and handing over full code to the client as their property. There is no licensing involved in this case. If you develop a prod

RE: Simple list sought

Scott, Don't know about a table exactly but the manual has a comprehensive reference of all column types and their limitations/descriptions here: http://dev.mysql.com/doc/mysql/en/Column_types.html Lachlan -Original Message- From: Scott Hamm [mailto:[EMAIL PROTECTED] Sent: Wednesday, 11

Simple list sought

Do anyone know where I can find a simple table that specify character/max/min specifications of each types i.e. varchar, char, double, int and so on? TIA, Scott -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECT

R: On the licensing once again

What if I sell a web site built using mysql? Do I need a license on my web server? > -Messaggio originale- > Da: Lachlan Mulcahy [mailto:[EMAIL PROTECTED] > Inviato: mercoledi 11 agosto 2004 13.14 > A: [EMAIL PROTECTED] > Oggetto: RE: On the licensing once again > > > Essentially the spi

removing duplicates and giving average of other field.

Hi again, thanks for the quick reply on my previous question, the solution given by Michael Stassen worked like a charm. But now I've again run into a situation where I'm stuck with my limited knowledge of MySQL. Given the table: mysql> select * from g2d; +---+--+--+--

RE: On the licensing once again

Essentially the spirit of the license is, if a company builds a system of some kind where the database facilities are provided by MySQL and wish to sell that system as a whole without a GPL or other accepted open license then they will be required to purchase a license for each copy of the server t

Re: Pattern Matching

In article <[EMAIL PROTECTED]>, "Jason Glicken" <[EMAIL PROTECTED]> writes: > I have 2 tables set up in MySQL, one with a dialed number field and > duration, the other with a list of country codes, there names, and the > rates. I am trying to match the dialed number with country code. My > probl

Re: efficiency of searching in SETs (InnoDB)

From: "Jeremy Zawodny" <[EMAIL PROTECTED]> > Sets result in table scans if they're the only condition in WHERE > clause. Until MySQL has a way of indexes them, you're stuck. Thanx Jeremy! We've just found another reason (specifics about the data we wanted to store in the sets have just been rele

Re: MEM_ROOT mysql.h

Alexander Hannemann wrote: Hi, I am trying to learn the MySQL C-Api and use PDuBois book. Trying to compile the simple 'client1.h' code leads to an error once the include 'mysql.h' statement' is reached: SUSE Linux 8.2 Error message: Intel Compiler 7.0 /usr/include/mysql/mysql.h(127): error: identi

Re: Setting custom information in processlist

Thank you very much for your reply, Jeremy. I have been searching high and low for some sort of solution in MySQL, now I can stop. In answer to your question other systems simply allow certain attributes to be set at connection time, e.g. application_name, host_name, etc. So I normally post_fix t

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: On the licensing once again

On Aug 11, 2004, at 1:21, DebugasRu wrote: 1) LM> If your software is licensed under either the GPL-compatible Free Software LM> License as defined by the Free Software Foundation or approved by OSI, then LM> use our GPL licensed version. 2) LM> If you distribute a proprietary application in any

On the licensing once again

1) LM> If your software is licensed under either the GPL-compatible Free Software LM> License as defined by the Free Software Foundation or approved by OSI, then LM> use our GPL licensed version. 2) LM> If you distribute a proprietary application in any way, and you are not LM> licensing and distr

MySQL 4.0.18 and 4.0.20 vs. PostgreSQL OUTER [long]

Welcome, I've found IMHO "anomaly" in MySQL. I call it "anomaly" because : - it isn't intuitive; - other databases got other result; Example description: Tables in databases: Kontrahent, Lokal, Umowa, UmowaTemp (contractor, place, contract, contractTemp) UmowaTemp is temporary table including new