Re: InnoDB Questions

yea, he's right, it may be error log file Nitin - Original Message - From: "Chris Nolan" <[EMAIL PROTECTED]> To: "Leo Huang" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, November 05, 2003 5:53 AM Subject: Re: InnoDB Questions > The "last one" you're referring to - could

Re: InnoDB Questions

not all the log files will work together, i mean, these files work in cyclic fashion, one fills up, second one gets used, it fills up, second one, and then back to first one. so it wont keep getting bigger, it will overwrite the previous data when it comes back to that file. in oracle, if you have

Can dbx update Tables "asynchronous", like ADO.

Can dbx update Tables "asynchronous", like ADO. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Mysql Connection Problems

HI All I was wondering if anyone could tell me how to get around this problems Error: could not connect to the database. It's possible the database itself is just not working at the moment. The admin should also check that the database details have been correctly specified in config.php Database

Complex conditional insert

I have two table, accounts describing various accounts and gives the account balance and ledger, which recodrs all account transactions. Playing around with the accounting tables, I have an user transaction that goes into the ledger but the values placed in the ledger balance columns depend on

Re: InnoDB and raw tablespace

To my knowledge, ext2 does have the limitation but ext3 does not. Additionally, ReiserFS, JFS and XFS all have disgustingly large file size limits. As a side note, apparently NetWare has major file size limitations (going on Gupta's SQLBase documentation) Regards, Chris Mark Lubratt wrote:

Re: mySQL with a quad processor system

Hi Richard, Correct. A single thread can only run on 1 CPU at any given time, even though the OS may switch the thread between CPUs over time. Matt - Original Message - From: "Richard Bewley" Sent: Saturday, November 01, 2003 9:48 PM Subject: RE: mySQL with a quad processor system >

Re: query time in ~3M row table

Hi Sean, LIKE is a range. ;-) I just tried it (on 4.0.16) with an index on (text, num) and it uses the full key_len, so LIKE is not a problem: EXPLAIN SELECT * FROM table WHERE text LIKE 'a%' AND num=123; For the original poster, index on (url, ApacheDate) should be better than (ApacheDate, url)

Re: MySQL vs .NET

.NET v. MySQL is not really a question. The question your asking is .NET v. J2EE. MySQL doesn't care about the client as long as it communicates properly. There are ODBC drivers as well as JDBC drivers. I think I've seen a C# driver, but then its windows and ODBC/ADO or whatever they want to c

Re: InnoDB Questions

The "last one" you're referring to - could it be the error log? The log files will only grow to a pre-determined limit. These log files are used to ensure that transactions maintain their durability. With Oracle, you'd want to be careful. Oracle gets very, very picky about the stuff underneath

Re: query time in ~3M row table

It looks like MySQL is searching on the url first. I'd be curious if you reversed your WHERE clause order, put your ApacheDate first and see if MySQL optimizes your query differently. I'm assuming your URL field is rather large, thus a long string comparison is taking place even though it's

Re: query time in ~3M row table

Wow, ouch. That is an awfully bright light bulb that just lit up in my head. Duh, too obvious for me to see. 1 comes before 2 except after c. On Tuesday, November 4, 2003, at 06:50 PM, Dan Nelson wrote: In the last episode (Nov 04), Brent Baisley said: I had thought it was inclusive, but in qui

Re: mysql memory usage

On Tue, Nov 04, 2003 at 10:09:01AM -, Alexis Guia wrote: > > Hi, > > I think that MyISAM uses the key buffer only if needed. The same happens > with almost all the other buffers (read buffer, sort buffer, etc.). True, but there's a subtle difference between "uses" and "allocates." If you te

Re: query time in ~3M row table

In the last episode (Nov 04), Brent Baisley said: > I had thought it was inclusive, but in quick tests I discovered it > was not. I haven't tried to look it up in the documentation yet. In > my test I did a query on a contact database like this: select > lastname from contacts where lastname betwee

Re: InnoDB and raw tablespace

On Tue, Nov 04, 2003 at 01:42:23AM -0600, Mark Lubratt wrote: > I'm considering using the raw tablespace from InnoDB for a project I'm > working on. I noticed a couple of years ago that there were reports of > tablespace corruption on Linux and these raw tablespaces. Have these > problems been

Re: query time in ~3M row table

I had thought it was inclusive, but in quick tests I discovered it was not. I haven't tried to look it up in the documentation yet. In my test I did a query on a contact database like this: select lastname from contacts where lastname between 'A' and 'B'; Only 'A' names are returned. Yes, there a

Re: InnoDB Questions

Hello Nitin, >From the timestamp of the log files, it seems that the first two files works together while the last one seems just sitting there, doesn't do anything. Also, will the log files getting bigger and bigger in the future?? If so how should I deal with them? For your last suggestion, wh

Re: RAND ()

Hi Payne, This is probably because of a bug in MySQL versions before 3.23.56 and 4.0.10 -- RAND() didn't work right the first time it was used in a *new* connection. After the first run, though, it was OK. To work around the problem, I've told people to just call RAND() a few times before doing y

Re: query time in ~3M row table

In the last episode (Nov 04), [EMAIL PROTECTED] said: > > I have a question about how long queries should be taking and if my server is too > small for what I want to be doing. I have a table setup to record stats from an > apache web server. I import the file currently once per month. Here i

Re: InnoDB Questions

I don't know. I will get some time this week, shutdown MySQL, backup my binary files, have a go as what Nitin said and see what's going on there. Leo Gabriel Ricard wrote: On Tuesday, November 4, 2003, at 07:58 AM, Leo Huang wrote: In InnoDB documentation, it suggests to add another file ibd

Re: query time in ~3M row table

Hi, Yes, make a composite index by adding ApacheDate as the second column in the urlIndex index. As a side note, Brent said that BETWEEN is not inclusive of the second parameter. But it IS inclusive. However, since you have a DATETIME column, there is no row with an ApacheDate of *exactly* '2003-

Re: InnoDB and raw tablespace

Chris Nolan wrote: >2GB limit? On MacOS X? > >On almost every OS I've played with lately, the file size limit is >massive - as in far beyond what disc capacity today will allow. Does >MacOS X have a 2GB limit? No, OS X has a file size limit of 2 TB (prior to 10.2), 8 TB (10.2.x) or 16 TB (10.3).

Re: query time in ~3M row table

Yes, it is an indexed field: mysql> explain select count(*) from hitstats where year(apacheDate) = 2003 and -> month(apacheDate) = 9; ++-+--+---+---+---+-+--+-+--+ | id | select_type | table| type

log information in MySQL

I need a way to log every message that MySQL generates. I have the following in the /etc/my.cnf file: [mysqld] port=3309 datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock log-bin=/var/log/mysql.log bind-address=192.168.0.15 log=/var/log/mysqlquery.log [mysql.server] user=mysql basedir=/va

Re: query time in ~3M row table

You're searching on a calculation so I'm pretty sure that MySQL is not using an index for the search. You should use explain in front of your query to see if MySQL is using indexes. You do have that date field indexed, don't you? You should search on ApacheDate between 9/1/2003 and 10/1/2003. S

Re: Windows to Linux

Well, he could do that but being inexperienced with Linux, I figured it would be more beneficial to use a familiar WYSIWYG so he doesn't blow and hour playing the with CLI like I did :) On Tue, 2003-11-04 at 16:58, Big Brother wrote: > err why not do a mysqldump then just import that? > > --- >

query time in ~3M row table

I have a question about how long queries should be taking and if my server is too small for what I want to be doing. I have a table setup to record stats from an apache web server. I import the file currently once per month. Here is my table: mysql> describe hitStats; +-+-

Re: phpmyadmin screw up

seems like you set the mysql root passwd which is the right thing to do. now should connect as follows: # /usr/local/mysql/bin/mysql -u root -p Saqib Ali - http://validate.sf.net <--- XHTML/HTML/DocBook Validator On Tue, 4 Nov 2003, joffrey leevy wrote: > Hi all: > > I was trying to use

phpmyadmin screw up

Hi all: I was trying to use phpmyadmin for the first time and messed up when trying to give the [EMAIL PROTECTED] a password. I did that because phpmyadmin told me something about lax security using "root" with no password. Anyhow something went wrong. Now I can't do anything with phpadmi

Re: PHP program for sql queries?

http://www.phpmyadmin.net/home_page/ -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: InnoDB and raw tablespace

2GB limit? On MacOS X? On almost every OS I've played with lately, the file size limit is massive - as in far beyond what disc capacity today will allow. Does MacOS X have a 2GB limit? Regards, Chris On Wed, 5 Nov 2003 04:03 am, Mark Lubratt wrote: > On Tuesday, November 4, 2003, at 10:25 A

Re: Selecting data from one table that is not in another

MySQL would eventually finish that query, but it's a big. You are joining every record in one database with every record in another, except where the id's match. You would probably end up with a result set of 499,000 records, assuming there is a one to one match with ids. What you want to do is

Re: PHP program for sql queries?

joffrey leevy wrote: Hi: Does anyone have a simple PHP program that will enable SQL queries to be executed and displayed with MySQL? thanks Isn't there a thing called PHPMyAdmin or MyPHPAdmin or something like that? I just use PHP. It's simple enough to not need a helper app. -- Daniel Kasak I

another insert select question

Table employees: | idnumber | email | phone | address | Table webusers: - | idnumber | userid | website | - Table employees is completely populated. Table webuse

Re: mysql noob can't get msyslog to connect to mysql

Re-posted (corrected a typo in config file name): I want to set up a central log server, doing this on RH9. Using msyslog, a replacement for syslog which can log to a mysql db. I originally had msyslogd logging successfully to mysql. Great, but I want to be able to view my logs via http, and afte

Deadlock

Hello, I'm using MySQL 4.0.15 standard - InnoDB and I got a deadlock. I don't see why ! How Can I find the reason ? It seems to occurs on delete statments. Regards, Christophe Here is my InnoDB status : = Per second averages calculated from the last 51 second

Re: mysql noob can't get msyslog to connect to mysql

Scott H wrote: I want to set up a central log server, doing this on RH9. Using msyslog, a replacement for syslog which can log to a mysql db. I originally had msyslogd logging successfully to mysql. Great, but I want to be able to view my logs via http, and after having trouble setting up apach

mysql noob can't get msyslog to connect to mysql

I want to set up a central log server, doing this on RH9. Using msyslog, a replacement for syslog which can log to a mysql db. I originally had msyslogd logging successfully to mysql. Great, but I want to be able to view my logs via http, and after having trouble setting up apache with PHP support

Re: problem with query

Leonardo Javier Bel? wrote: >Hi ALL! >I have a problem with this query, because it keeps failing and I dont >know why (it says that the concat statement is wrong but there is nothing on >the online docs...) > >select st.id, concat(st.required), st.name from states st, agenda ag left >outer j

Selecting data from one table that is not in another

I'm looking for a way to select data from one table that is not found in another. I am sorting on a column called 'model_id'. Basically I want something like this to work: "SELECT t1.*, t2.model_id FROM data1 as t1, data2 as t2 WHERE t1.model_id != t2.model_id" t1 has about 1000 entries and t

Re: Installing 3.23.57 version without root privileges

Use the --prefix option to tell configure where mysql should go. Add --prefix=$HOME/mysql to your configure options. You could change $HOME/mysql to any path where you have write permission. Michael Fernando wrote: Hello, I need to install 3.23.57 version (i've downloaded the source code

Re: Installing 3.23.57 version without root privileges

On Tuesday 04 November 2003 10:49 am, Fernando wrote: > Hello, > > I need to install 3.23.57 version (i've downloaded the source code from the > mysql page) in a system where i'm not the root. How can i install it in my > account without getting errors while doing the make install? I get this > mes

Re: Lost Password

you can always reset the mysql root passwd http://www.mysql.com/doc/en/Resetting_permissions.html Saqib Ali - http://validate.sf.net <--- XHTML/HTML/DocBook Validator On Tue, 4 Nov 2003, Carol Andrejak wrote: > Hello Listers, > > I have a problem in that I cannot find my user id and pas

Re: Unicode with MySQL4.1

Oops--the Unicode character must have gotten lost in the email, but it does show up in MySQL. Its an "O" with a line above it. _ MSN Messenger with backgrounds, emoticons and more. http://www.msnmessenger-download.com/tracking/cdp_

SUMmarizing/GROUPing over UNION SELECT?

Is it possible to summarize and group over a result set derived from several different tables using UNION SELECT? For example, this is what I have: Table1.field1 1 2 3 4 5 5 Table2.field1 1 2 3 3 And what I want to get is something like this: 1) SUM=29 2) A result set like this by grouping:

Re: Unicode with MySQL4.1

You need to be sure you are using a Unicode font. Are you using xterm? If so you can go to the edit tab and click Current Profile to change the font. Also note that most Unicode fonts only cover subsets of Unicode not the whole thing so use a font that supports the language you are using. I

Installing 3.23.57 version without root privileges

Hello, I need to install 3.23.57 version (i've downloaded the source code from the mysql page) in a system where i'm not the root. How can i install it in my account without getting errors while doing the make install? I get this message saying i can't write in the default folder because i do

Distributed- and/or mutli-server databases

Hi there :) Can anyone recommend a MySQL book about distributed- and/or multi-server databases? Or even a general book about it, not written especially for MySQL? thanks, chris. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lis

Lost Password

Hello Listers, I have a problem in that I cannot find my user id and password to log into mysql as administrator. I can never remember passwords so I write them all down in a small book however when I reinstalled mysql early last month, evidently I neglected to write down the new user id and p

[Stats] MySQL List: October 2003

-- Searchable archives for this list are available at -- ==

Re: mysql 4.0.16/4.0.15a build fails on Mac OS X 10.3

Interestingly enough, when I configure 4.0.16 like this it builds ok: ./configure --prefix=/usr/local --sysconfdir=/ --enable-shared --with-server-suffix=-imax-G5 --with-mysqld-user=mysql --with-comment --with-query-cache --without-docs --with-innodb --enable-thread-safe-client --with-bench -

Re: InnoDB Questions

On Tuesday, November 4, 2003, at 07:58 AM, Leo Huang wrote: In InnoDB documentation, it suggests to add another file ibdata2 to get higher performance. Can I do that now, after I have created the ibdata1 and used it for a while? How exactly does this increase performance? Will InnoDB store some d

Re: InnoDB and raw tablespace

On Tuesday, November 4, 2003, at 11:25 AM, Harald Fuchs wrote: In article <[EMAIL PROTECTED]>, Mark Lubratt <[EMAIL PROTECTED]> writes: I'm considering using the raw tablespace from InnoDB for a project I'm working on. I noticed a couple of years ago that there were reports of tablespace corrupt

Re: mysqldump sorted

On Tue, Nov 04, 2003 at 05:32:47PM +0100, Al Bogner wrote: > > Is it possible to sort the records, which are created with > mysqldump? I didn't find an optioin in man mysqldump. If you cannot > do it with mysqldump, what would be the best workaroud for it? into > outfile? Have you tried sneaking a

Re: Unicode with MySQL4.1

It seems to be working, but I am facing a glitch with display. I tried select convert(_ucs2 0x0400 using utf8); +--+ | convert(_ucs2 0x0400 using utf8) | +--+ | ?| +--+ 1

Re: InnoDB and raw tablespace

On Tuesday, November 4, 2003, at 10:25 AM, Harald Fuchs wrote: In article <[EMAIL PROTECTED]>, Mark Lubratt writes: I'm considering this option to keep database maintenance to a minimum (running out of tablespace issues). That way, InnoDB already owns all the disk space and I don't have to con

Re: Adapting a Select statement to MySQL

Looks like there's a bug in SQLyog -- when I restarted my machine this morning, the query worked. Thanks, -Jim Nitin wrote: query seems perfect, what error is this giving? Nitin - Original Message - From: "Jim Bartram" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, Novemb

mysqldump sorted

Is it possible to sort the records, which are created with mysqldump? I didn't find an optioin in man mysqldump. If you cannot do it with mysqldump, what would be the best workaroud for it? into outfile? Al -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubs

RAND ()

Hi, I have been playing around with RAND(). It works very well if I do a sql statement with mysql, but I having problem using with mysql statement with php. When a person calls on the page, the same output is always view. How can I get RAND() work with php. sorry for the php, stuff. Thanks fo

Re: Column data type maximums?

Yes, probably due to limitations of the Control Center. I also tried BLOB and I get the same results. Thanks Brent Baisley

Re: Column data type maximums?

text would be more than enough to hold your data. a text column is "limited" to about 65K characters. Your are probably running into some limitation of MySQL Control Center. Maybe it's using GETs instead of PUTs. I haven't used Control Center, but I have input text much longer than 1000 charact

Re: group by _date_

* [EMAIL PROTECTED] [...] > Aha, now I have SUM(ROUND(how_much,2)), this works so far. You should swap these two function calls, the way you are doing it you are summing up the rounded values, instead you should round the sum of the values: ROUND(SUM(how_much),2) -- Roger -- MySQL General Mail

Re: group by _date_

* [EMAIL PROTECTED] [...] > Does this mean I can not trust float, decimal etc. for financial purposes? Yes you can, but you need to consider the precission of your calculations and comparisons. How much is 1 dollar divided by 3, if you can only use two digits for decimals? What do you do with the

Column data type maximums?

MySQL version - 4.0.13 MySQL Control Center - 0.9.2 beta I'm interested in storing a lot of plain text. I know varchar2 has a limit of 255 characters. I want to store characters in excess of 800 and even closer to 1000.' I've tried varchar2, text and longtext. My size that I'm trying is 713 charac

Re: group by _date_

Thanks, Roger Baklund wrote: * [EMAIL PROTECTED] Hello, I have a table bill like when (date), how_much (float), what (varchar). Now I store some bills on it - how_much will get numbers with 2 digits after point. Why do you think that? Note that FLOAT is an approximate numeric type. The value you

problem with query

Hi ALL! I have a problem with this query, because it keeps failing and I dont know why (it says that the concat statement is wrong but there is nothing on the online docs...) select st.id, concat(st.required), st.name from states st, agenda ag left outer join ag.id=concat("AGE",st.required) w

temporary tables

I am having trouble creating temp tables. An error message keeps coming up saying that @localhost does not exist. (or something like that) can anyone help. Thanks mhp

RE: Windows to Linux

If you can mount the Windows partitions under LINUX, you can copy file files from partition to partition. If that's not possible, you'll have to export the data under Windows to another location/media, then boot into LINUX and load the data into your LINUX database. You can dump the databases fro

Re: InnoDB Questions

You're right, it wont decrease the physical size, but only free up the space within file to optimize the tablespace, in case, you want to check the size of this data file, you can remove autoextend from: innodb_data_file_path = ibdata1:10M:autoextend and specify the size limit in the place of 10M

Re: mysqlimport question

"Cersosimo, Steve" <[EMAIL PROTECTED]> wrote: > > Am I wrong to assume mysqlimport is supposed to emulate the LOAD DATA INFILE > syntax? I cannot find the command line option to turn on the CONCURRENT > flag. > CONCURRENT currently is not supported by mysqlimport. -- For technical support co

Re: InnoDB Questions

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Thank you very much for your reply, Nitin. I did read the Adding_and_removing in the manual, but it says "Currently you cannot remove a datafile from InnoDB. To decrease the size of your database you have to use `mysqldump' to dump all your tables, c

Re: InnoDB Questions

Hello, first things first, you cann't resize your datafiles without shutting down your database. if it's ok with you, have a look at http://www.mysql.com/doc/en/Adding_and_removing.html you may want to have a look at you my.cnf file, stored in mysql data dir or in /etc dir, for the default option

Re: Adapting a Select statement to MySQL

Have you tried WHERE ytd_sales >= 4095 AND ytd_sales <=12000; Also, you may try adding ( ). They sometimes help. Thanks Emery - Original Message - From: "Nitin" <[EMAIL PROTECTED]> To: "Jim Bartram" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, November 04, 2003 08:30 Subj

Re: MySQL vs .NET

You can get Native database drivers for Delphi to talk to MySQL your database back end makes no differance to any thing with Delphi God know what perl has to do with any thing totaly not the same thing as Delphi Soap supports every thing, soap is language independant... and is fai

InnoDB Questions

Hello, I have a few questions about InnoDB. I am new to InnoDB, and just converted my MyISAM tables into InnoDB a few days ago. I notice that it generates these files -rw-rw1 mysqlmysql2560 Nov 2 13:07 ib_arch_log_00 -rw-rw1 mysqlmysql790626304 Nov 4

Re: MySQL vs .NET

If you are using Perl, take a look at SOAP::Lite - do not let the name fool you... www.soaplite.com Combining this with Apache and mod_perl and given Perl can directly interface with MySQL using Perl's DBI (and also the countless other modules available on CPAN) we have found this to be a v

Re: What information does "Extra" and "Comments" give in "show full fields"

Karam Chand <[EMAIL PROTECTED]> wrote: > How can I add comment to a column? Use COMMENT keyword: CREATE TABLE test( id int NOT NULL auto_increment COMMENT 'this is a comment', PRIMARY KEY (id) ) TYPE=MyISAM; > > karam > --- Egor Egorov <[EMAIL PROTECTED]> wrote: >> Karam Chand <[EMAIL PROTECTE

Re: What information does "Extra" and "Comments" give in "show full fields"

How can I add comment to a column? karam --- Egor Egorov <[EMAIL PROTECTED]> wrote: > Karam Chand <[EMAIL PROTECTED]> wrote: > > > > I have 4.1.0-alpha-max-nt. When i issue a command > - > > > > show full fields from tblname; > > > > I get information about the fields in the table. > There > >

filemaker pro TO MySQL

Hi, Want to import filemaker pro table data on Windows to MySQL database on Linux. Export from filemaker pro could be made in the following formats. SYLK files (*.slk), DBF files (*.dbf), DIF files (*.dif), Lotus 1-2-3 files (*.wk1), Basic files (*.bas), Merge files (*.mer), HTML table fil

Re: group by _date_

* [EMAIL PROTECTED] > Hello, > I have a table bill like > when (date), how_much (float), what (varchar). > > Now I store some bills on it - how_much will get numbers with 2 digits > after point. Why do you think that? Note that FLOAT is an approximate numeric type. The value you insert is stored i

Re: LOAD DATA hangs

> Any idea what has gone wrong here? Yet another limitation I have run > into? Tried this: 1) CREATE TABLE 2) ALTER TABLE DISABLE KEYS 3) LOAD DATA -> Complete after 30 min, table size 5.78 GB, index size 1.21 GB. 4) ALTER TABLE ENABLE KEYS -> Puts a full load on the CPU, but neither index nor ta

Re: What information does "Extra" and "Comments" give in "show full fields"

Karam Chand <[EMAIL PROTECTED]> wrote: > > I have 4.1.0-alpha-max-nt. When i issue a command - > > show full fields from tblname; > > I get information about the fields in the table. There > are two columns i.e. EXTRA and COMMENTS which is > always blank. I cant seem to figure out what > informa

Re: Heap table in replication,bug?

"MaFai" <[EMAIL PROTECTED]> wrote: > Hello, Victoria Reznichenko, > > The p_showing table,the following is the create table sql statement. > > > | p_showing | CREATE TABLE `p_showing` ( > `showing_timestamp` timestamp(14) NOT NULL, > `showing_channel_name` varchar(50) NOT NULL default '', > `

RE: mysql memory usage

Hi, I think that MyISAM uses the key buffer only if needed. The same happens with almost all the other buffers (read buffer, sort buffer, etc.). ;) Alexis -Original Message- From: Benjamin KRIEF [mailto:[EMAIL PROTECTED] Sent: segunda-feira, 3 de Novembro de 2003 21:00 To: [EMAIL PRO

FW: performance while creating indexes

Hi, When creating indices, MyIsam needs a big sort buffer (See MySQL Manual: " myisam_sort_buffer_size: The buffer that is allocated when sorting the index when doing a REPAIR or when creating indexes with CREATE INDEX or ALTER TABLE. "). I don't know how works ISAM tables, but you can try setti

Re: minus operation

In oracle, intersect will work for you better than minus. as it shows data from both tables which doesn't exist in another one. anyway in mysql, you can try this: select A.* from A left join B on (f1, f2, f3, f4) where B.f1 is null and B.f2 is null and B.f3 is null and B.f4 is null; hope it help

group by _date_

Hello, I have a table bill like when (date), how_much (float), what (varchar). Now I store some bills on it - how_much will get numbers with 2 digits after point. Then I want to know how much money I spent each month. SELECT SUM(how_much), YEAR(when), MONTH(when) FROM bill GROUP BY (YEAR(when)*1

minus operation

Hi to all, My question is rather about sql langage than mysql. Here it is: i have 2 tables (A and B) with the same structure (4 fields called f1,f2,f3,f4). Table A counts x records and table B counts y records (and x <> y). Then, table A has records that do not belong to table B and table B has

MySQL vs .NET

I am using Delphi 7 and MySql 4.0.16, since MS release .Net technology and also Delphi 8 .Net to provide web services application, I want to know how to make a web services application using Mysql? Or is there similiar technology like .Net but using Mysql? -- MySQL General Mailing List For list

compiler errors including

I work with MSVC60 on Win98se with mysql-4.0.16-win. I got a project that compile and link. The mysql-include folder is set as a standard include folder and I link the project against mysqlclient.lib. If I include in some of my source-files I got this errors from the compiler:

InnoDB and raw tablespace

I'm considering using the raw tablespace from InnoDB for a project I'm working on. I noticed a couple of years ago that there were reports of tablespace corruption on Linux and these raw tablespaces. Have these problems been fixed? I'm considering running it on a hardware RAID (stripes of mir