case select

Hi all, I have case like this. 20031221175014.65 0 14.65 14.65 6 200312211800118.9 119.41 14.65 697.17 2003122118101324.1 122.6 697.17 1502.3 2 Last field is MODE. That case is at the middle of the database. But these 3 are continues tripel. When MODE=''

RE: Need a query to get the difference of two tables

SELECT a.address FROM a, b WHERE (a.id LIKE b.id) AND (b.message NOT LIKE 'y') -Original Message- From: Roger Baklund [mailto:[EMAIL PROTECTED] Sent: Sunday, January 30, 2005 7:19 PM To: mysql Cc: Harish Subject: Re: Need a query to get the differe

ALTERing a table with a CREATE TABLE statement????

Hi, I wrote a software generating a statistical database. That database keeps time series. What I am doing is - looking at the data file and get the channel names. - CREATE TABLE IF NOT EXISTS IF Database exits I want to ALTER the table but only add new coloums that are new. Is there a way

Re: MatLab connector

http://www.mmf.utoronto.ca/resrchres/mysql/ I use this.. it works well.. Ferhat - Original Message - From: "Jose Antonio" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, November 25, 2004 4:57 PM Subject: MatLab connector > Do you know if I can use MySQL data from MatLab?

Re: Client program

just to save your time.. C:>root/to/mysql/dir/bin/mysql.exe -h HOST_NAME_HERE -u USERNAME -p you will be promt for password. - Original Message - From: "Scott Hamm" <[EMAIL PROTECTED]> To: "'Ferhat BINGOL'" <[EMAIL PROTECTED]>; "

Re: Client program

http://dev.mysql.com/doc/administrator/en/mysql-administrator-menus-tools-mysql-command-line-client.html this may cheer you up than... - Original Message - From: "Scott Hamm" <[EMAIL PROTECTED]> To: "'Ferhat BINGOL'" <[EMAIL PROTECTED]>; &quo

Re: Client program

Hi, I use those 2... MySQL Control Center http://www.mysql.com/products/mysqlcc/ PHPMyAdmin http://www.phpmyadmin.net/home_page/ Cheers... - Original Message - From: "Scott Hamm" <[EMAIL PROTECTED]> To: "'Mysql ' (E-mail)" <[EMAIL PROTECTED]> Sent: Wednesday, November 24, 2004 2:38

VS.NET C++ and MySQL

Hi, I know this is not the exact topic of the list but I am sure some people from this list spend some time on it. I am new to VC++ but getting better indeed. I need help on how to connect to MySQL server. I need a connector and an example. It must be free because this is a student project :) S

[solved] Re: LOAD DATA INFILE question...

d chop the necassary fields. thanks to MySQL. :) thank yo again for answer... - Original Message - From: "Patrick Connolly" <[EMAIL PROTECTED]> To: "Ferhat BINGOL" <[EMAIL PROTECTED]> Cc: "mysql" <[EMAIL PROTECTED]> Sent: Sunda

Re: LOAD DATA INFILE question...

ROTECTED]> To: "Ferhat BINGOL" <[EMAIL PROTECTED]> Cc: "mysql" <[EMAIL PROTECTED]> Sent: Saturday, November 20, 2004 10:41 PM Subject: Re: LOAD DATA INFILE question... > You can load the file to an intermediate table and then complete your > process using &

LOAD DATA INFILE question...

Hi, I have a 72 fields data txt file and I was inserting all data previously but now I need only some of them to dump into the table. I would like to select only 4 fields which are the 1st, 5th,28th and 71st fields. Is there a statement to do that. I have read http://dev.mysql.com/doc/mysql

MySQL functions

Hi, How do I add a new function to MySQL SQL statement list. What I mean is AVG(), MIN() or MAX() is a ready function isnt it? Is there a way to add new functions without compiling all server? Regards... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscr

Re: SELECT... INTO OUTFILE problem

The directory is being created by Labview and data is written out by MySQL. Can it be this? I am using windows 2000. And that reminded me, do I have to create the directory that I will output the file? Or, MySQL will automaticly create it if not exits??? Regards.. - Original Message -

SELECT... INTO OUTFILE problem

Hi, I am sending a query to a MySQL server on a network via LabView EXEC QUERY VI. It looks like that SELECT `data1` , `data2` INTO OUTFILE 'C:\\data_out\\day234\\data_out.txt' FIELDS TERMINATED BY '\t' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\r\n' FROM data_table; What I

Re: Date as Primary ID

Hi Scoot, I do my table structure like that CREATE TABLE `test_table` ( `timestamp` date NOT NULL default '-00-00', `data` varchar(5) NOT NULL default '', PRIMARY KEY (`timestamp`), KEY `timestamp` (`timestamp`) ) TYPE=MyISAM; Than I send a query as below INSERT INTO `test_table` (

a puzzle (at least for me)

Hi, I could not do this... TABLE1 ID NAME price - -- 1 1stname 34 2 2ndname 0 TABLE2 date 1stname 2ndname --- --- --- 20041023 23.5 12.3 As a result I want to get out raws something like this... 1 34 1stname 23.5 2 0 2ndname 12.3 What is the SQL syntax f

Re: big table, slow queries...???

Tore, Yes, it is necasarry to pick up all the values from 5 tables. I made indexes for each table. My queries are between 12 to 26 seconds now. I am generating a WHERE statement before make the query. If the user do not enter the some min and max values I am skipping this WHERE statements. The in

big table, slow queries...???

Hi, I am new at this group. Nowadays I am using PHP/MySQL more than ever. I have a problem with making queries on my huge database (totally more than 20 million rows and 9 GB). The main problem is it is rather slow. For example I am making a query which is checking the 5 biggest tables for, from