Kandy Wong wrote:
And what is the good connector (C++ to MySQL) to use?
MySQL++ (http://tangentsoft.net/mysql++/) has native Date, Time, and
DateTime data types. You can convert to these types implicitly:
mysqlpp::DateTime dt = row[my_column];
Row::operator[] doesn't return
PROTECTED]
Sent: Friday, August 15, 2008 2:36 AM
To: Saul Bejarano
Cc: mysql@lists.mysql.com
Subject: Re: Need help to query with timestamp in C++
Hi Saul,
I need to use C++ and I'm not writing a web application.
Thanks anyway.
Kandy
I have done queries to the database in PHP with variables like month
Hi Dusan,
Thank you so much. It works!
Kandy
Hi Kandy,
this could be the query you are looking for. It should return record
with the closest timestamp to your required time:
(SELECT TIMEDIFF('20080815091907', timestamp_column) AS diff, t.* FROM
table1 t
WHERE timestamp_column =
I have done queries to the database in PHP with variables like month but
easily can select from a range of time and data to produce the same
results, the output goes directly to the web so if that is what you are
seeking for, I can help with PHP.
Saul
Kandy Wong wrote:
Hi,
I need to write
On May 9, 2008, at 6:58 AM, Chris Pirazzi wrote:
Hello,
I _thought_ I knew how InnoDB worked, but due to a recent mysql doc
change, I am no longer sure--the change made the dox significantly
less clear, and potentially code-breaking.
Please can someone tell me the real behavior of InnoDB in
Take a look at
http://dev.mysql.com/doc/refman/5.0/en/innodb-foreign-key-constraints.ht
ml
CASCADE: Delete or update the row from the parent table and
automatically delete or update the matching rows in the child table.
Both ON DELETE CASCADE and ON UPDATE CASCADE are supported. Between two
Rakesh!
The distance_sphere and makebox2d functions are specific to postgis.
MySQL GIS Implementation is based on the Open GIS Simple SQL
Specification (read more on www.opengeospatial.com). The SetSRID is also
not in the specification as far as I know (it should be, but I can't
find it),
Mark, is the 'secs' column the offset from the minimum value of the
timestamp column?
If so, you might try something like this:
SELECT UNIX_TIMESTAMP(MIN(timestamp)) INTO @min_timestamp FROM my_table;
SELECT uid, timestamp,
UNIX_TIMESTAMP(timestamp) - @min_timestamp AS secs
FROM my_table
ORDER
On Dec 11, 2007 8:38 AM, Anders Norrbring [EMAIL PROTECTED] wrote:
I'm looking at a situation I haven't run into before, and I'm a bit
puzzled by it.
I have this table structure:
Table USERS: userid, class
Table OBJECT: userid, class, result
Now I want to query the database for a certain
On Dec 11, 2007, at 10:46 AM, Rob Wultsch wrote:
On Dec 11, 2007 8:38 AM, Anders Norrbring [EMAIL PROTECTED] wrote:
I'm looking at a situation I haven't run into before, and I'm a bit
puzzled by it.
I have this table structure:
Table USERS: userid, class
Table OBJECT: userid, class, result
Anders,
I also want to find out the user's position relative to others
depending on the result.
For a given pUserID, something like this?
SELECT userid,result,rank
FROM (
SELECT o1.userid,o1.result,COUNT(o2.result) AS rank
FROM object o1
JOIN object o2 ON o1.result o2.result OR
On Nov 8, 2007 4:08 PM, Stut [EMAIL PROTECTED] wrote:
Hi all,
I've inherited a PHP app that uses a MySQL database. The following query
is extremely slow and I've been battling for a couple of days on an off
to try and get a combination of indexes to optimise it. Any help would
be greatly
Hi Rob,
Thanks for your reply.
Rob Wultsch wrote:
On Nov 8, 2007 4:08 PM, Stut [EMAIL PROTECTED] wrote:
Hi all,
I've inherited a PHP app that uses a MySQL database. The following query
is extremely slow and I've been battling for a couple of days on an off
to try and get a combination of
On Nov 12, 2007 7:57 AM, Stut [EMAIL PROTECTED] wrote:
Hi Rob,
Thanks for your reply.
Rob Wultsch wrote:
On Nov 8, 2007 4:08 PM, Stut [EMAIL PROTECTED] wrote:
Hi all,
I've inherited a PHP app that uses a MySQL database. The following query
is extremely slow and I've been battling
On Nov 12, 2007 9:22 AM, Afan Pasalic [EMAIL PROTECTED] wrote:
If you have to deal with it again consider using a bunch of unions
instead of the 'IN'. Not prettiest thing, but it should fix your
performance issue.
Could you please give me more details about your statement that mysql deals
Guys, just wanted to thank you again for helping me with
the sql statement that I needed. I was able to sorted using
php and I was able to display the correct result.
Thanks again!!1
Nestor :-)
On Nov 6, 2007 7:37 AM, Néstor [EMAIL PROTECTED] wrote:
You guys are correct, that is exactly what
--- [EMAIL PROTECTED] wrote:
Néstor wrote:
I think you'd best begin by normalising your
database. Something along
these lines:
very true indeed, that would save you major headaches
when right after finishing the demo, someone would
say, can we add a 18 gallon pledge? what about a 25?
i believe you need to have root create the file /var/lib/mysql/mysql.sock
and then make it readable and writable by the user that owns mysql.
You can make that same file owner by the user that runs mysql.
-Original Message-
From: Ali Nebi [EMAIL PROTECTED]
Sent: Nov 6, 2007 9:24 AM
You guys are correct, that is exactly what happened.
I must thing of this in the future.
At this moment I have a lot of other projects to take care, that it is
eaiser for me to read the information into an associative array with
the columns and the values and sort the array and then print the
On Tue, 2007-11-06 at 09:32 -0600, [EMAIL PROTECTED] wrote:
i believe you need to have root create the file /var/lib/mysql/mysql.sock
and then make it readable and writable by the user that owns mysql.
You can make that same file owner by the user that runs mysql.
-Original
The mysql.sock location '/var/lib/mysql/mysql.sock' attempted to be used by your
connecting client may be wrong.
linux$ ls -la /var/lib/mysql/mysql.sock
Does the file exist?
You say this is the sock file created by mysqld:
srwxrwxrwx mysql mysql system_u:object_r:mysqld_var_run_t mysql.sock
- Original Message -
From: Russell E Glaue [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Tuesday, November 06, 2007 8:55 PM
Subject: Re: Please help to solve a serios problem
The mysql.sock location '/var/lib/mysql/mysql.sock' attempted to be used
by your
--- Enrique Sanchez Vela [EMAIL PROTECTED]
wrote:
Date: Mon, 5 Nov 2007 15:01:59 -0800 (PST)
From: Enrique Sanchez Vela [EMAIL PROTECTED]
Subject: Re: Need help creating query statement
To: Néstor [EMAIL PROTECTED]
--- Néstor [EMAIL PROTECTED] wrote:
I can do simple select
Enrique that is pretty good and close to what I need.
On top of what you have generously provide, I guess I can just put
each gallon field into an array an then sort the array to display the
first 5 gallon fields per agency. Is there an easier way?
Thanks,
Nestor :-)
On 11/5/07, Enrique
Néstor wrote:
I can do simple select statements but I need your brains to create query
statment.
I am using mysql 4.0 in my 1and1 site.
I have a table that has 8 fields, one is the agency field and the other 7
are
*tip* values on saving water and the value of this field is either 0 or an
Imran wrote:
Hello all:
...
I would like to get all of the records in MenuOptions and any record in
MenuAccess with a specific fkGroupid. For example:
...
IIf I run a query for fkgroupid = 1 I should get
AccessId fkMenuID fkgroupid view execute
Daevid Vincent wrote:
I'm trying to get some 'release/version numbers' to sort properly.
mysql SELECT ReleaseID, Name FROM releases ORDER BY Name DESC;
+---+-+
| ReleaseID | Name|
+---+-+
|18 |
-Original Message-
From: Jay Pipes [mailto:[EMAIL PROTECTED]
Sent: Friday, October 12, 2007 2:07 PM
To: Daevid Vincent
Cc: mysql@lists.mysql.com
Subject: Re: Need help with a natural sort order for
version numbers and release code names
Daevid Vincent wrote:
I'm trying
Here's my full test solution:
use test;
drop table if exists releases;
create temporary table releases
(
releaseid int(10) unsigned not null auto_increment primary key,
name varchar(255)
)engine=myisam;
insert into releases ( name ) values
( 'Unspecified' ),
( 'Next Patch' ),
(
Oh, and here's the output (Sorry):
+---+-+
| releaseid | name|
+---+-+
| 1 | Unspecified |
| 2 | Next Patch |
| 3 | LOCset |
| 4 | Abashiri|
|
Thanks for the help i have got it correct.
--
View this message in context:
http://www.nabble.com/seoparator-help-tf4316769.html#a12568601
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Learn something every day.
TFT
- Original Message -
*From:* Andrew Braithwaite [EMAIL PROTECTED]
*To:* coolcoder [EMAIL PROTECTED], mysql@lists.mysql.com
*Date:* Thu, 23 Aug 2007 14:19:25 +0100
mysql select format(300,0);
+---+
| format(300,0) |
Not really a MySQL problem, this is a presentation problem. MySQL will
store the number as digits only (unless you are storing in a character
field - but why would you?). If using PHP, for instance, the output of
the field would be
number_format($fieldvalue)
or if you want the answer to two
mysql select format(300,0);
+---+
| format(300,0) |
+---+
| 3,000,000 |
+---+
1 row in set (0.00 sec)
mysql select format(300,2);
+---+
| format(300,2) |
+---+
| 3,000,000.00 |
in addition to the correct character-set also set the appropriate
collation sequence
suomi
VeeJay wrote:
Hello there
I have a problem. When I try to select some names starting with extra
alphabets (Å Æ Ø Ä Ö, etc), I simply don't get required results i.e.,
if I give a select command like:
On 6/29/07, Rich Brant [EMAIL PROTECTED] wrote:
Hello all. I'm looking for help with the query below. Is there anyway
to prevent the temporary and filesort?
The filesort is caused by either the ORDER BY or the GROUP BY. There
are sections in the manual about how to get it to use indexes for
Rich Brant schrieb:
Is there anyway to prevent the temporary and filesort?
SELECT
t1.sourceID as sourceID,
count(t1.sourceID) as clicks,
[...]
ORDER BY clicks desc, conversions desc;
When using EXPLAIN:
[...] Using where; Using temporary; Using filesort |
when
Rich Brant wrote:
Hello all. I'm looking for help with the query below. Is there anyway
to prevent the temporary and filesort? I've tried about as many
combinations as I could think of, but can't seem to prevent it. I'm
sure that's the reason, when run on a table of around 750k records, it
On 6/27/07, Dave G [EMAIL PROTECTED] wrote:
Queries on this table when it gets large is slow as molasses. I'm
thinking about making a new table for anything with a different test_id
any opinions as to whether this is good or bad?
Hi Dave G.,
We need to know how:
a)How large the table
Good Afternoon David
sounds as if you have a number of non-unique indices (even possibly FTS!)
slowing down queries..this should help you concentrate on the slower indices
mysql
select TABLE_NAME,COLUMN_NAME,INDEX_NAME from INFORMATION_SCHEMA.STATISTICS
where NON_UNIQUE=1;
Anyone else?
I think I can do that:
I don't have any other indexes, just the keys.
mysql show create table data__ProcessedDataFrames;
I do, but I don't see any way around that with the data I have.
Dave G.
Good Afternoon David
sounds as if you have a number of non-unique indices (even possibly FTS!)
slowing down queries..this should help you concentrate on the slower
indices
mysql
select
On 6/27/07, Dave G [EMAIL PROTECTED] wrote:
select payload_time,HEX(processed_data) from data__ProcessedDataFrames
where test_id=18 AND top_level_product_name=DataProduct AND payload_time
11808.74704 AND payload_time 1180564096.24967;
What I'm concerned about is with how much data I will
That's quite a query. You may not be able to optimize it well with
those nested selects. You may want to think about changing your query
around a little, perhaps joining pieces of data using whatever
programming language you're using on the front end. You have MySQL
doing a lot of work and
HI Sudheer,
THIS DESIGN IS BASED ON MY MANY-TO-ONE DIRECTION PATTERN
OF DATABASE NORMALIZATION DESIGN... PLEASE MODIFY/CORRECT IT ACCORDING TO YOUR
TASTE. AS A JAVA DEVELOPER I'M USING HIBERNATE FOR MY CREATE-UPDATE-DELETE(CUD)
AND DIRECT JDBC FOR MY QUERIES(R).
YOU MAY VARY.
HERE, HOPE
Hi Sudheer,
First of all there a number of ways to design this database.
You will need to choose the one that you feel suites your needs best.
Here one possible design.
Because you have different type of users/accounts, it looks like
ACCOUNT_TYPE table is needed
ACCOUNT_TYPE table
Because you are a novice to data base design, you have fallen into a common
trap. If you think about an array, you don't want to store multiple users in
a row, you want to store them in a column. In other words, you want to have
one table that stores businesses (once per business, probably) and
Thanks Brent, good tip. Works like a charm.
On Jun 14, 2007, at 7:42 PM, Brent Baisley wrote:
Here's a little trick. Get your DELETE query working as a SELECT.
Then replace everything before FROM with DELETE tablename.
SELECT order_items.ord_id FROM order_items LEFT JOIN orders ON
- Original Message -
From: Ben Liu [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thursday, June 14, 2007 3:11 PM
Subject: need help with delete query
I'm trying to delete a subset of items in a table. The problem is, I don't
want to query for the subset first, store the results
Hi All,
I was able to load data properly.
We need to set the parameter
set session collation_database=latin1_swedish_ci;
set session character_set_database=latin1;
please check this url for more info
http://lists.mysql.com/commits/16915
On 5/19/07, Ananda Kumar [EMAIL PROTECTED] wrote:
Hi
Also friends,
When i see this data in the vi editor it looks like this Other Home DÃ(c)cor
Just wanted to give information. Please help me.
regards
anandkl
On 5/19/07, Ananda Kumar [EMAIL PROTECTED] wrote:
Hi All,
I am loading data into mysql database using LOAD DATA INFILE. After the
load
Hi Jesse,
Jesse wrote:
The following query works just fine:
SELECT B.BusNum, COALESCE(CampCount.Cnt,0) As Kids, B.CamperCapacity,
COALESCE(CounselorCount.Cnt,0) As Adults, B.AdultCapacity
FROM Buses B
LEFT JOIN (SELECT BusID,Count(*) As Cnt FROM Campers GROUP BY BusID)
AS CampCount ON
COALESCE(CampCount.Cnt,0) + COALESCE(CounselorCount.Cnt,0) as GT
Duuuh. Why didn't I think of that. What is MySQL's issue with referring to
the variables (As assignments, whatever you want to call them)? I've had
issues like this in situations like this one, when trying to use them in the
Jesse wrote:
COALESCE(CampCount.Cnt,0) + COALESCE(CounselorCount.Cnt,0) as GT
Duuuh. Why didn't I think of that. What is MySQL's issue with
referring to the variables (As assignments, whatever you want to
call them)? I've had issues like this in situations like this one,
when trying to
Nikita Tovstoles [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Do both of your SELECT statements use the same index (`token`) when setting
locks on the rows? My guess is that the situation is as follows.
TX2: SELECT ... WHERE id = ... FOR UPDATE
TX2 sets an exclusive lock for a row
Hi Rakaha,
You have a cursor , select id from table_name and then have a loop where in
you select values of LTA for each id got from the above cursor, close the
loop once all the ID have been processed.
regards
anandk
On 3/30/07, raksha [EMAIL PROTECTED] wrote:
How to retrieve data from
Or you could also do this.
SELECT LTA FROM TABLE A WHERE ID IN (SELECT B.ID FROM TABLE B);
i hope this what your looking at, please let us know.
regards
anandkl
On 3/30/07, Ananda Kumar [EMAIL PROTECTED] wrote:
Hi Rakaha,
You have a cursor , select id from table_name and then have a loop
VeeJay wrote:
How and at What place, can I configure the Makefile under
/usr/ports/databases/mysql50-server/
to have MySQL server working with above mentioned configurations?
Why not just use MySQL that comes from ports?
If you really want to build from source, read:
I only want to view the product per product name
which has the lowest price.
SELECT product_name,MIN(price)
FROM tbl
GROUP BY product_name;
PB
uYe wrote:
Hi,
I have a table with product_name, price field. The product name may be exist
in more than one record. I only want to view the product
with 'reconnect flag' set to 1 in the
MySQL structure...
Thanks
ViSolve DB Team
- Original Message -
From: Sayed Hadi Rastgou Haghi
To: Visolve DB Team
Cc: mysql@lists.mysql.com
Sent: Wednesday, November 08, 2006 11:51 AM
Subject: Re: wait_timeout help
Hi
I set the wait_timeout
*Sent:* Wednesday, November 08, 2006 11:51 AM
*Subject:* Re: wait_timeout help
Hi
I set the wait_timeout in my.cnf.
Sometimes it works well and there is no idle process 120 seconds time.
But sometimes there are idle processes with 1900s time.
What the reason can be?
On 11/7/06, Visolve DB Team [EMAIL
On 2006-11-07 Sayed Hadi Rastgou Haghi wrote:
Dear All,
I want to set wait_timeout variable on mysqld startup.
Is there any way to do that?
Put wait_timeout = XXX into the [mysqld] stanza of your
/etc/mysql/my.cnf (or wherever your global config file is).
bye,
-christian-
--
MySQL
Hi
specify it in the .cnf file in the mysqld options: wait_timeout=x
or specify it at the command line : set wait_timeout=x
or start mysqld with --wait_timeout=x along with other options.
Thanks
ViSolve DB Team
- Original Message -
From: Sayed Hadi Rastgou Haghi [EMAIL PROTECTED]
Thanks
But this sets. GLOBAL wait_timeout variable.
Cab be seen by SHOW GLOBAL VARIABLES not by SHOW VARIABLES;
On 11/7/06, Visolve DB Team [EMAIL PROTECTED] wrote:
Hi
specify it in the .cnf file in the mysqld options: wait_timeout=x
or specify it at the command line : set wait_timeout=x
On 2006-11-07 Sayed Hadi Rastgou Haghi wrote:
Thanks
But this sets. GLOBAL wait_timeout variable.
Cab be seen by SHOW GLOBAL VARIABLES not by SHOW VARIABLES;
Ah, yes, MySQL is very confusing about this special variable:
You have to use interactive_timeout = XXX to change what is called
3:21 PM
Subject: Re: wait_timeout help
Thanks
But this sets. GLOBAL wait_timeout variable.
Cab be seen by SHOW GLOBAL VARIABLES not by SHOW VARIABLES;
On 11/7/06, Visolve DB Team [EMAIL PROTECTED] wrote:
Hi
specify it in the .cnf file in the mysqld options: wait_timeout=x
or specify
mysql set @@session.wait_timeout=15;
mysql show variables;
Thanks
Visolve DB Team.
- Original Message -
From: Sayed Hadi Rastgou Haghi [EMAIL PROTECTED]
To: Visolve DB Team [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Tuesday, November 07, 2006 3:21 PM
Subject: Re: wait_timeout help
Subject: Re: wait_timeout help
Thanks again
I have some questions that may help me explain my problem well.
1- What's this mean:
mysql SHOW PROCESSLIS;
+--+---+--++---+-++-+
| Id | User | Host
by the CLIENT_INTERACTIVE connect
option to mysql_real_connect())
Thanks
ViSolve DB Team.
- Original Message -
*From:* Sayed Hadi Rastgou Haghi [EMAIL PROTECTED]
*To:* Visolve DB Team [EMAIL PROTECTED]
*Cc:* mysql@lists.mysql.com
*Sent:* Tuesday, November 07, 2006 4:12 PM
*Subject:* Re: wait_timeout help
Adriano -
MySQL names temp tables like that (starting with # sign), in paticular
while storing a result set to be sorted. I would guess that your
query is returning a result set large enough to hit a filesystem limit
on your box. How big are you expecting the results to be? Perhaps
you are
The mysql client program never generates the fixed length, pipe layout from the
shell's command line.
This is only possible at mysql's command line.
1) Try this:
my -Ae show tables; | while read a ; do my -Ae show create table $a; echo
myfile.txt ; done
2) Try mysqldump in this manner
Good call on the WHERE email_address IS NULL thing. Also occurs to me
you could do a SELECT DISTINCT instead of just a SELECT to eliminate
duplicate update commands.
Glad this was useful.
Dan
On 10/14/06, Ferindo Middleton [EMAIL PROTECTED] wrote:
Thanks Dan. This does help. This a pretty
Thank u so much. It woked now!
- Original Message -
From: Visolve DB Team [EMAIL PROTECTED]
To: Visolve DB Team [EMAIL PROTECTED]; Renish
[EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Tuesday, October 10, 2006 1:42 PM
Subject: Re: Query Help plss
Hi,
Hope this link will you.
http
Renish koshy wrote:
Hi all,
I have installed MySql 4.1 in my system. when I tried to run Mysql , I
always gets this error.
Could not start MySql service on a local computer
Error 1067: the process terminated unexpectedly.
Stop sending this message!
We get the idea!
The more you send it,
Xp
- Original Message -
From: Visolve DB Team [EMAIL PROTECTED]
To: Renish koshy [EMAIL PROTECTED]
Sent: Tuesday, October 10, 2006 11:42 AM
Subject: Re: Query Help plss
Hi,
On which platform?
Thanks
ViSolve DB Team.
- Original Message -
From: Renish koshy [EMAIL PROTECTED
@lists.mysql.com
Sent: Tuesday, October 10, 2006 12:35 PM
Subject: Fw: Query Help plss
- Original Message -
From: Renish
To: mysql@lists.mysql.com ; Visolve DB Team
Sent: Tuesday, October 10, 2006 12:34 PM
Subject: Re: Query Help plss
b) And what happend when you open
:03 AM
Subject: Re: Query Help plss
Hi
The .err file shows that the service is stopped Normally and no error was
found. sure the service is properly shutdown.
Try,
a)
net stop mysql
mysqld-nt remove
mysqld-nt install
net start mysql
b)
Also run 'services.msc' and double click on the mysql
Date: Mon, 02 Oct 2006 13:22:37 -0400
To: mysql@lists.mysql.com
From: Michael Gargiullo [EMAIL PROTECTED]
Subject: RE: Partition Help
Message-id: [EMAIL PROTECTED]
snip/
Daily partitions are created then sub partitioned across 6 data disks
and 6 index disks.
We attempted to build a new
At 16:23 +0200 10/7/06, Patrick Aljord wrote:
I would like to prohibit the value 'xxx' on my column title, and if it
does contain the value I would like to create an exception by
assigning 'xxx' to the primary key id which is int(5).
This is what I do but I get an error on its creation so I
Hi Patrick,
Patrick Aljord wrote:
I would like to prohibit the value 'xxx' on my column title, and if it
does contain the value I would like to create an exception by
assigning 'xxx' to the primary key id which is int(5).
This is what I do but I get an error on its creation so I guess it's
not
I meant the error is:
mysql CREATE TRIGGER testref BEFORE INSERT ON bookmarks
- FOR EACH ROW
- BEGIN
- IF NEW.title LIKE '%xxx%' THEN
- SET NEW.id ='xxx';
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for
thanx it works the trigger is created successfully but it has no
effect. here it is:
delimiter //
create trigger testref before insert on bookmarks
for each row
begin
declare dummy char(2);
if new.title like '%xxx%'
then
set new.id='xxx';
end if;
end;
//create
On 10/7/06, Patrick Aljord [EMAIL PROTECTED] wrote:
thanx it works the trigger is created successfully but it has no
effect. here it is:
delimiter //
create trigger testref before insert on bookmarks
for each row
begin
if new.title like '%xxx%'
then
set new.id='xxx';
snip
Thanks for the advice.
We've got 12GB of RAM, I'll increase the key_buffer_size.
Unfortunately
I can't turn off indexes, then index after. At these rates, I'd never
catch up.
I don't agree. It takes longer to build the index than to load the data
if
you have indexes active when loading
Thanks, again, for folks who suggested solutions to my problem. To help
users searching the archives, I've pasted in a working solution at the
end of this message. Also, I'd like to ask if there is a more efficient
or better way of checking if the language version exist than the six
lines I
Hi Kevin,
I didn't look that close at it but it
should be IFNULL, not ISNULL which is SQLserver's
version of it.
/Johan
Zembower, Kevin skrev:
I'm trying to use a subquery for the first time, and am having some
problems. I'm hoping someone can give me some suggestions on ways of
doing what I
At 11:40 -0400 26/9/06, Zembower, Kevin wrote:
IF(ISNULL(SELECT lv.langversionid
FROM langversion AS lv
JOIN baseitem AS b3 ON lv.baseitemid =
b3.baseitemid
WHERE lv.langid = 1
AND b.baseitemid =
FROM langversion AS lv
JO' at line 11
[EMAIL PROTECTED]:~$
-Kevin
-Original Message-
From: Chris Sansom [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 26, 2006 12:45 PM
To: Zembower, Kevin; mysql@lists.mysql.com
Subject: Re: Requesting help
At 02:03 PM 9/26/2006, you wrote:
I'm working on a project in which we'd like to convert from Oracle to
MySQL. We need to partition our data for speed concerns. Currently in
Oracle I create 8, 3 hour partitions for each day (Currently running
450M -750M rec inserts/day). I was looking for
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 26, 2006 3:40 PM
To: mysql@lists.mysql.com
Subject: Re: Partition Help
At 02:03 PM 9/26/2006, you wrote:
I'm working on a project in which we'd like to convert from Oracle to
MySQL. We need to partition our
At 02:53 PM 9/26/2006, Michael Gargiullo wrote:
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 26, 2006 3:40 PM
To: mysql@lists.mysql.com
Subject: Re: Partition Help
At 02:03 PM 9/26/2006, you wrote:
I'm working on a project in which we'd like
Mike
We're using the Load infile function to load the data generated by
another process. We do not do updates, but occasionally need to either
walk the table or run a query against it. On Oracle, we currently need
3
hour partitions to keep the 5 indexes timely.
This system handles 450-750
At 03:37 PM 9/26/2006, you wrote:
Mike
We're using the Load infile function to load the data generated by
another process. We do not do updates, but occasionally need to either
walk the table or run a query against it. On Oracle, we currently need
3
hour partitions to keep the 5 indexes
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 26, 2006 5:27 PM
To: mysql@lists.mysql.com
Subject: RE: Partition Help
At 03:37 PM 9/26/2006, you wrote:
Mike
We're using the Load infile function to load the data generated by
another process. We
Chris W wrote:
By default MySQL uses port 3306 so you need to be sure that port is open
on the server, and not blocked by a firewall. You also need to be sure
the user you are trying to login as can login remotely. In the MySQL
user data base, there is a column for host which is the host
By default MySQL uses port 3306 so you need to be sure that port is open
on the server, and not blocked by a firewall. You also need to be sure
the user you are trying to login as can login remotely. In the MySQL
user data base, there is a column for host which is the host that user
can
generally simplify this?
R.
-Original Message-
From: Robert DiFalco [mailto:[EMAIL PROTECTED]
Sent: Friday, August 04, 2006 4:12 PM
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: RE: Query Help for Loosely Couple Properties
I think this only works if I know that Orange
, 2006 9:37 AM
To: Robert DiFalco
Cc: mysql@lists.mysql.com
Subject: Re: Query Help for Loosely Couple Properties
On Tue, 2006-08-01 at 16:23 -0700, Robert DiFalco wrote:
The question is, how do I query this? Say I want all records from
table T whose COLOR property value is ORANGE.
The only
They are user defined properties.
-Original Message-
From: Jay Pipes [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 01, 2006 8:11 PM
To: Robert DiFalco
Cc: mysql@lists.mysql.com
Subject: Re: Query Help for Loosely Couple Properties
On Tue, 2006-08-01 at 16:23 -0700, Robert DiFalco
On Tue, 2006-08-01 at 16:23 -0700, Robert DiFalco wrote:
The question is, how do I query this? Say I want all records from table
T whose COLOR property value is ORANGE.
The only thing I can come up with (and I'm no SQL expert and this looks
wrong to me) is the following:
SELECT *
FROM T
201 - 300 of 1409 matches
Mail list logo