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=''
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
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
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?
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]>; "
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
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
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
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
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
&
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
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
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 -
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
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` (
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
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
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
18 matches
Mail list logo