(?) of Outlook that glues lines together. This
feature can be disabled/reverted (although this is not widely known)
At 21.38 26/03/2012 +0800, Cifer Lee wrote:
-- Forwarded message --
From: Reindl Harald mailto:h.rei...@thelounge.net
h.rei...@thelounge.net
Date: Mon, Mar 26, 2012
-- Forwarded message --
From: Reindl Harald h.rei...@thelounge.net
Date: Mon, Mar 26, 2012 at 9:17 PM
Subject: Re: why must user variable in EXECUTE USING clause ?
To: Cifer Lee mantia...@gmail.com
would you PLEASE send to the list instead off-list
and put your answer BELOW
Hey All,
Can anyone provide some guidance as to what the practical connection limits
to MySQL 5.1/5.5 are under linux?
We're running a ruby on rails application that establishes 50 to 100
connections to our database upon startup resulting in around 1,000
persistent db connections. I've been
Hi Anand,
Just try 'load data local infile',it maybe work.
Eric
2010/12/20 Anand anand@gmail.com:
Hi guys,
i am facing a serious issue with my replication , i tried so many things but
no luck.
my replication is running with mysql 5.0.51a in master and 5.0.90 in slave.
we run LOAD
?
--
Lola J. Lee Beno
LinkedIn: http://www.linkedin.com/in/lolajleebeno
Facebook: http://www.facebook.com/profile.php?id=714355583
Blog: http://www.lolajl.net/blog/
yah, mysql only allows one auto increment field n that's used as the
primary key in tables. I don't think it has to be the primary key as
long as it is a unique key i think that's okay.
so u should be able to do : create table (myid int unsigned not null
auto_increment., unique key (myid));
better.
Regards,
Ciaran Lee
2009/9/24 Gavin Towey gto...@ffn.com
Hi Ciaran,
So I think there's a couple things going on:
1. The explain plan for your slow query looks wrong, such as mysql is
confused. It's possible your index statistics are incorrect. Try ANALYZE
TABLE on listings
Hi,
I hope this is the right place to ask a question about query optimization.
Background:
I have a database which has events, which occur in places (listings). Places
have addresses, and addresses belong to a city. I can select the latest
event within a particular city very efficiently (less
`jobsearchtwodb`.`jobposts` ADD CONSTRAINT `adsourcefk`
FOREIGN KEY `adsourcefk` (`adsource_id`)
REFERENCES `adsource` (`adsource_id`)
ON DELETE RESTRICT
ON UPDATE NO ACTION;
ON DELETE RESTRICT having the behavior like ON DELETE CONSTRAIN?
--
Lola J. Lee Beno - ColdFusion Programmer
triggers because for some reason I
can't get the triggers working properly. Is there any way I can do this
on the database side without having to write code in the application
code I'm working on?
--
Lola J. Lee Beno - ColdFusion Programmer/Web Designer for Hire
http://www.lolajl.net/resume
;
When I run the set query without the and old.jobpost_id line, it runs
correctly. So the syntax problem is elsewhere, but where?
--
Lola J. Lee Beno - ColdFusion Programmer/Web Designer for Hire
http://www.lolajl.net/resume | Blog at http://www.lolajl.net/blog/
In rivers, the water that you
and thus is what this trigger is supposed
to do.
--
Lola J. Lee Beno - ColdFusion Programmer/Web Designer for Hire
http://www.lolajl.net/resume | Blog at http://www.lolajl.net/blog/
In rivers, the water that you touch is the last of what has passed
and the first of that which comes; so with present
id? Maybe
Yes. Jobpost_id. No, not a typo. It's primary key,
jobposts.adsource_id is foreign key while adsource.adsource_id is
primary key.
--
Lola J. Lee Beno - ColdFusion Programmer/Web Designer for Hire
http://www.lolajl.net/resume | Blog at http://www.lolajl.net/blog/
In rivers
the
record. If so, what's the best way to do this?
--
Lola J. Lee Beno - ColdFusion Programmer/Web Designer for Hire
http://www.lolajl.net/resume | Blog at http://www.lolajl.net/blog/
In rivers, the water that you touch is the last of what has passed
and the first of that which comes; so
, double quotes are
really for object names.
Right . . . I'll get the JOIN clause figured out after I figure out
what's causing the above error message.
--
Lola J. Lee Beno - ColdFusion Programmer/Web Designer for Hire
http://www.lolajl.net/resume | Blog at http://www.lolajl.net/blog
that corresponds to your MySQL server version for the right
syntax to use near 'if @counted = 1 then SET dummy = 'Cannot
delete this record' end if' at line 1
Query = if @counted
= 1 then SET dummy = 'Cannot delete this record' end if
--
Lola J. Lee Beno - ColdFusion Programmer/Web Designer
All,
Just curious as to which query would be better in terms of performance:
select * from (select * from a union select * from b) as c;
versus
select * from a union select * from b;
or would these 2 queries be the same ?
Thanks,
Yong.
Yong Lee
Developer
[EMAIL PROTECTED]
http
chris,
you're going to need a source for all the distinct codes that you may see in
your product tableie: if you don't have a full list somewhere (like your
temp table) you cannot do your query because you have nothing to compare
against.
assuming you had some table X which had a list of all
yes, one master to multiple slaves.
I believe u can set up multiple mysql instances on a single machine with
each mysql instance collecting from a different master.
Yong.
-Original Message-
From: Andrey Dmitriev [mailto:[EMAIL PROTECTED]
Sent: May 21, 2008 11:29 AM
To:
Hi all,
Is there a problem with the mysql web page (http://lists.mysql.com/) where
you can query mailing list archives ? I can't seem to get more than 20
results to any query.
Thanks,
Yong.
Yong Lee
Developer
[EMAIL PROTECTED]
http://www.eqo.com/
direct: +1.604.273.8173 x113
mobile
Hello,
I have several tables storing item information, keyword (mainly for searching),
category and subcategory (also for searching). The query I am using now is:
SELECT i.*, it.*, ic.*, c.*, cs.*, s.*, st.* FROM item i
LEFT JOIN iteminfo it ON i.id = it.id
LEFT JOIN itemkeyword ik ON i.id
on current time
before doing an insert) and then have a cron job to create new tables as
needed and to also backup and remove older tables as they are no longer
being used.
Any thoughts on this ?
Thanks,
Yong.
Yong Lee
Developer
[EMAIL PROTECTED]
http://www.eqo.com/
direct
Thanx for the information , but i wanted to go for a long term plan and for a
fixed solution. bcause little by little that load getting high.
please need some mysql expertise help.
Thank you,
Shaine.
Ady Wicaksono [EMAIL PROTECTED] wrote: Hi Lee
better you start to benchmark your system using
Hi Friends ,
I have huge WAP content database and it's included with wallpapers, ringtones,
games ...etc.That content database getting hits more that 1000 /sec. This is
actually massive.
My Webserver s are Tomcat and apache , because some applications written in
java and some are php .
. how can i solve that
problem ? is it a bug ?
please help .
Thank you,
Shaine.
Jake Peavy [EMAIL PROTECTED] wrote: On 1/4/07, Shain Lee [EMAIL PROTECTED]
wrote:
I wanted to get that info which has stored in relavent fields into a CSV fle .
Can somebody help me to do that please ?
Can i do
Thank you , that is working with /tmp/ directory. actually what is the issue
behind writing that files into user defined folder , like /home/test/ ?
have you find any solution for that ?
Thank you,
Shaine.
Nils Meyer [EMAIL PROTECTED] wrote: Hi Shain,
Shain Lee wrote:
ERROR 1 (HY000): Can't
Hi
For example , suppose i have a database - Music, and a table in it is mp3.
under mp3 there is more fields , like, id, artist, name , mp3_file...etc.
I wanted to get that info which has stored in relavent fields into a CSV fle .
Can somebody help me to do that please ?
Can i do it mysql
Hi All,
I noticed that there are RPM downloads for RHEL4 but that these do not
contain the ndb storage engine (ie: these are standard builds). As such,
I've resolved to just use the generic x86 rpm bundles that are offered but
I'm curious if the ndb storage engine will ever get included into
Hi ,
I wanted to store images , musics, videos ..etc in mysql database.storing
contents as content type BLOB , i don't have any issues with that setup.
But , now i need to store that contents in folders and should be kept the
contents path with referrence ofcontents file name .
for
Hi all,
I'm fairly new to character sets and I'm trying to get a better
understanding of how mysql deals with them. I hope someone out there can
shed some light on a behavior that I am seeing. We're using mysql 4.1.12
with clustered tables.
I have a table with a varchar and a text field
Hi ,
Could you please tell me , how can i install C++ , mysql driver in Fedora core
5 ?
Is that available for any platforms ? does YUM supports for install mysql c++ ?
please help me , its really urgent .
Thank you,
Shaine.
-
Yahoo! Cars NEW
)),
LEAST( ABS(MIN(@n-col2)),
ABS(MIN(@n-col3))
)
)
FROM ...
I think the formula is just right - very clever. But is it possible to
make sure that col1, col2 and col3 are all from the same record?
Thanks in anticipation
Lee
--
MySQL General Mailing
using a Kohonen network, but I would prefer to use MySQL.
Many thanks in anticipation
Lee
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi all,
I hope I have hit the right group for this question.
I would like to create a UDF that is configurable at run time. Similar to
how mysql can use variables defined in the /etc/my.cnf file, I'd like my UDF
to make use of configuration parameters that can be set at run time.
I'm
Hi all,
I hope I have hit the right group for this question.
I would like to create a UDF that is configurable at run time. Similar to
how mysql can use variables defined in the /etc/my.cnf file, I'd like my UDF
to make use of configuration parameters that can be set at run time.
I'm
Hi ,
I'm just behind a mulimedia database , that wanted to be online with WAP
contents. So , i decided to go ahead with mysql , and i installed mysql latest
5.0 in fedora core 5 with innoDB .upto now every thing success.
But , my worries is , how can i created huge mulimedia database
Michael Stassen wrote:
So, take a look at yarn_date.txt and let us know.
Yes, you're right . . . there was an extra tab stop. When I deleted the
extra tab, the date field were retained successfully. Thanks!
--
Lola - mailto:[EMAIL PROTECTED]
http://www.lolajl.net | Blog at
Michael Stassen wrote:
Just a quick reply for now . . .
Ummm, if you delete the numbers to the *left* of the decimal point,
2005-01-15 10:15:42.41837 will turn into .41837, which is still not
a valid datetime. You need to delete the numbers to the *right* of the
decimal point (which I
I'm trying to import a set of data into a database (MySQL 5.0.17-max).
Here's the query that I tried to run:
LOAD DATA INFILE `standardwttype.txt`
INTO TABLE StandardWeightType
FIELDS TERMINATED BY `\t`
LINES TERMINATED BY `\r`
(standard_wt_type_id, standard_wt_desc, standard_wt_lud);
And
Peter Brawley wrote:
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'standardwttype.txt`
Use single quotes not (dreaded) backticks.
This seems to have fixed one problem. Now, I
Lola J. Lee Beno wrote:
ERROR 13 (HY000): Can't get stat of
'/users/lolajl/documents/development/knitlib/datafiles/standardwttype.txt'
(Errcode: 13)
Never mind . . . I figured that I needed to add LOCAL to the query.
Should have gone back to the manual page for LOAD DATA.
--
Lola
I have a bunch of data where one of the columns is a date field. Here's
a sample of the data that I have:
1 4 14 150 1 0 0 0 1
0 2005-01-15 10:15:42.41837
2 8 15 120 1 0 0 0 2
,
--
- Lee H // anfl
-I code, therefore I break things.
signature.asc
Description: Digital signature
Hi
I am using visual studio C++ 6, with SDK, my mysql database is 4.1.18, i
downloaded mysql++ 1.7.1 as this is the compatiable version for vc++6.
the example program compiles and runs. when i go to make my own project i use
the wizard and create a basic dialog MFC app. at the top of the main
thanks for the reply Jason, i have now added mysql++.lib to the linker and also
copyied the libmysql.dll to the system folder. the program complies now with a
few performance warnings but no errors.
there is one link error
LINK : warning LNK4098: defaultlib LIBC conflicts with use of other
Hello,
I'm going to upgrade from 4.1 to 5.0. My question is
how do I handle the data from old version. Do I need
to recreate tables in the mysql database when I
install the new version or can I use the old mysql
database from the old version? Data in other database
I believe I can dump and import
I'm trying to create foreign key constraints and keep getting an error
message 1005 (I did look it up, but didn't see an obvious solution to
fixing this for my database).
The version I'm using is 5.0.17-max. I used Mysql WorkBench to create
the database schema and had it generate the sql
Michael Stassen wrote:
1) I'm not sure what you are intending with (`(not null)`) in the
middle of your foreign key definition, but that isn't valid mysql
syntax. See the manual for the correct syntax
http://dev.mysql.com/doc/refman/5.0/en/innodb-foreign-key-constraints.html.
This is from
Peter Brawley wrote:
Lola,
/And got this following error message:
ERROR 1072 (42000): Key column '(not null)' doesn't exist in table
/
Yes, it's telling you what;s wrong: to define a constraint on a key, the
table def must first define the key.
Looking over the script again, RatingID is
Gleb Paharenko wrote:
Hello.
The query which is works is:
Thanks - just what I needed. Looks like I'll need to be extra careful
with sql scripts generated from Mysql Workbench, which is still alpha
right now.
--
Lola - mailto:[EMAIL PROTECTED]
http://www.lolajl.net | Blog at
to
mysql. Your done.
Not sure how you would do it with other pructs, but I
don't imagine it would be much more difficult.
Lee
--- Jerry Swanson [EMAIL PROTECTED] wrote:
How to create ssh tunnel for Mysql?
TH
__
Yahoo! FareChase: Search
Why would a simple select against an innodb db result in a bump of the
table_locks_immediate variable? I've been debugging a different problem and I
noticed this behavior. I don't believe it is a problem but can't explain the
behavor and it seems odd.
Regards,
Lee
mysql create table
We have two clusters running the same data
independently and saving output to databases on two
systems (two hosts) respectively. We need to compare
the output each day. Is there an easy way to compare
tables from two systems? We are sure the structure of
the tables are all the same and we need to
I need to order a few names by the number following
the main name. For example swap2, swap3, swap10 in the
order of swap2, swap3, swap10, not in swap10, swap2,
swap3 as it will happen when I do an order by.
So I came up with the following query:
mysql select distinct secname, date from optresult
I want to check if a column exists in a table before I
do an alter table to add it. How do I do this in
mysql? Thanks.
Claire
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
MySQL
Hi all,
I've a question to guru :)
there're two tables:
mysql show fields from domains;
++--+--+-+-+
| Field | Type | Null | Key | Default | Extra
++--+--+-+-+
| id | int(10)
Hi all,
I've a question to guru :)
there're two tables:
mysql show fields from domains;
++--+--+-+-+
| Field | Type | Null | Key | Default | Extra
++--+--+-+-+
| id |
Hi all, is it possible to send from server to client a handle to MySQL
connection.
for example then i'm trying:
server:
Code:
...
MYSQL mysql;
mysql_init(mysql);
mysql_real_connect(mysql,);
...
send(socket,mysql, sizeof(MYSQL),0);
-
client:
Code:
to pull out the date that
this occured on with,
SELECT max(visits) as maximum, visit_date FROM visit WHERE (((visit_date =
'$sdatestring') and (visit_date '$edatestring')) and (site_id=$site_id))
GROUP BY visit_date
I get a completely different and wrong answer,
any ideas?
Cheers,
Lee
--
MySQL
there be a better
approach?
Cheers,
Lee
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
part, but
does any one have any ideas?
All the best,
Lee
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Is it possible to change the character set just for an individual table and
if so which character set should I try to display this european characters?
Cheers,
Lee
- Original Message -
From: Sumito_Oda [EMAIL PROTECTED]
To: Lee Denny [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent
the data in
the DB if possible.
I know this is a bit vague but I was wondering if anyone had any insight
into this.
Cheers,
Lee
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
...
page_id is already auto_increment.
I'm sure that an INSERT .. SELECT statement should do it, but I'm unsure of
the correct syntax.
cheers,
Lee
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
a seperate install
and then let depot do the migration. However, if
MySQL provides a simple 'upgrade' I would love to hear
of it.
Thanks!
Lee
__
Do you Yahoo!?
The all-new My Yahoo! - Get yours free!
http://my.yahoo.com
--
MySQL General Mailing
the
record-set this returns for 'focus'.
My first thought is use a temporary table - but is there a way of doing this
with one query?
Cheers,
lee
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
.
Anyway, if anyone can provide a lean and concise
statement that will provide this, it would be very
much appreciated.
Thanks!
Lee
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
MySQL
format.
Anyway, thanks again James!
Lee
--- James Weisensee [EMAIL PROTECTED] wrote:
Lee,
On the MySQL side:
GRANT SELECT ON db.* TO user@'host' IDENTIFIED BY
PASSWORD 'password';
This will give 'user' from 'host' SELECT privileges
to
all tables on 'db' (db.*).
http
Hi,
I have a perl script that connect to mysql using the
following:
my $dbh =
DBI-connect(DBI:mysql:$dbname;host=$host,$dblogin,
$dbpasswd) or die Cannot connect to $dbname: .
$DBI::errstr;
But after I upgraded to 4.1.5 I get the following
error message:
DBI-connect(dbname;host=host) failed:
Hello,
I need to perform a select that compares two dates
I need to return all records that haven't had date_2 set after a given
number of days since date_1.
I'm sure this can be done in one query but I just can't get my head around
this one.
Can anyone help?
Cheers,
Lee
--
MySQL General
Hi,
Here's a table of mine
namedate changeDate
n1d1 cd1
n2d1 cd3
n2d2 cd1
n4d1 cd2
n1d2 cd5
n5d1 cd4
n6d2 cd2
I need to select every name for which the changeDate
corresponding
I have a table like this
name price type
A
__
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
http://promotions.yahoo.com/new_mail
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
I have a table like this
name price type
A10 1
B30 2
A20 1
B20 2
would like to distinct based on name and type, do a
sum and get the following result
name price type
A 30 1
B 50 2
How do I do this with one sql
Hi Lam,
Try and see whether following SQL work for you:
create temporary table tmp as
select product_id, min(abs(to_days('2004-6-30') - to_days(snapshot_date))
+ if(snapshot_date '2004-6-30',0,0.1)) as date_diff
from product_tbl group by product_id;
select product_tbl.*
from product_tbl,
Hi,
I would like to use logrotate to manage the log files generated by MySQL.
I used the command mysqladmin flush-logs to close the log file. However,
the sql command displayed on the query log is Refresh.
According to the information from this forum, command flush logs should
be used instead
Hi,
I have enabled the binary log on MySQL (4.0.20). The name of the binary
log is hostname-bin.001, hostname-bin.002, etc ...
What will happen if the suffix become 999? Will error occurs when flush
logs is executed?
Regards,
Michael
Hi,
I would like to migrate my DB from Sybase ASE to MySQL INNODB table. Data has been
extracted and stored as a file. I want to use the command Load Data Infile to insert
the data to MySQL. However, some table contains millions of rows. Can i control the
batch size of the loading (e.g.
` number of inserts.
-Original Message-
From: Michael Lee
To: [EMAIL PROTECTED]
Sent: 6/28/04 1:21 AM
Subject: INNODB transaction log size
Hi,
I would like to migrate my DB from Sybase ASE to MySQL INNODB table.
Data has been extracted and stored as a file. I want to use the command
Load
Hi,
I am using MySQL 4.0.20. For a table of INNODB type, same query return different
results when different query plan is used.
select * from project_team where project_id = 'FMS ';
-- 2 rows. (primary key used)
select * from project_team ignore index (PRIMARY) where project_id = 'FMS ';
applications. Is there any way of using some sort
client-server technology to alert the user, via the browser that a new entry
has appeared in the DB - I'm already sending an email but this is still not
the best solution.
Thanks in advance,
Lee Denny
--
MySQL General Mailing List
For list
the problematic php snippets below, as well as the
forumuser creation and authentication process. If
somone could please point out my mistakes, that would
be awesome!
Thanks again,
Lee
TESTER
?php
//Database connect script
$dbhostname = localhost;
$dbuser = forumuser;
$dbpassword = somepass;
$dbname
for user: '@localhost' to
database 'forums'
mysql Aborted
Spider:/usr/bin# mysql -u ForumUser -p forums
Enter password:
ERROR 1045: Access denied for user:
'[EMAIL PROTECTED]' (Using password: YES)
Sincerely,
Lee
__
Do you Yahoo!?
Yahoo! Finance Tax Center - File
The documentation I find describes the slave contacting the master
to initiate the replication service.
I need the master to be able to contact the slave. Is this possible.
Thanks
lee
--
Lee Chalupa
Something Else Enterprises, Inc.
[EMAIL PROTECTED]
770 381 2377
--
MySQL General Mailing
Hi All,
I have a query problem here. Say I have a table with
employee records of three different departments. If
each department manager wants to see employee info of
their own department. Three different queries will be
needed. Is there a way that I can write one single
query and let SQL decide
.2.1 Changes in release 4.1.2 (not released yet)
* C.2.2 Changes in release 4.1.1 (01 Dec 2003)
* C.2.3 Changes in release 4.1.0 (03 Apr 2003: Alpha)
Thanks in advance!
/lee
=
==
/lee
+---+
| This concludes our broadcast day
the directories functionally equal?
Thanks in advance!
/lee
=
==
/lee
+---+
| This concludes our broadcast day|
+---+
__
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online.
http
Hi,
I'm a newbie working on a big project. The idea is to
transport an existing Oracle database at
http://www.ebi.ac.uk/arrayexpress/ to a local MySQL
server. The Schema, scripts and loader for Oracle can
be found in the website. But how to create an exactly
same database with mySQL? I have no
-do-table=radius.RADPOOL
Cheers
Lee Webb
--
Systems Administrator
DOT Communications
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
method using binary operations
(only one field populated with zeros and ones) but I can't find anything to
help in the manuals.
Any thoughts?
Lee Denny
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi all,
I installed mysql 4.0.14 binary distribution on RedHat
8.0 following the instructions in the manual. But I
can't get it to work. Please help.
When I start mysql using the command:
shell bin/mysqld_safe --use=mysql
the following message shows:
Starting mysqld daemon with databases
this?
Any help greatly appreciated.
--
John Francis Lee
1/9-10 Thanon Trairat
Muang Chiang Rai 57000
Thailand
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello,
I have a problem about foreign key in using MySQL.com manual. According to
the example in MySQL.com manual, one foreign key is ok. However, I have 3
tables (ie. 2 for parent tables and 1 for child table). When I use 2 or more
foreign keys, I have the following errors.
Case 1:
mysql
Dear Sir:
i am a user of mysql gui,version
mysqlgui-win32-static-1.7.5-2. My pc is Petium 4 1.4G,
on which most program run very fast. but when i use
mysql gui, i find it run very slowly although i can
get the result.
I wonder how can i make it run faster. thank you for
your helping.
My OS:
need help.
Thanks in advance,
Lee
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED
Hi marco
In the administration page of coldfusion, usually something like:
http://domainName/CFIDE/administrator/index.cfm?target=/CFIDE/administrator/welcome.cfm
go to your data sources and click the edit button. THen click the show
advance settings button. Make sure that the Allowed sql
Hi there
I want to do a left outer join but i also have a bunch of where conditions
in my sql statment that i need. Can anyone help me out:
SELECT title, authorName, journalName, journalPages, aname, tname,
avg(ranking)
FROM publications, area, topic, pubTopicInt,
LEFT OUTER
AND
publications.pubID = 3
GROUP BY (publications.pubID);
Thanks
Desmond
From: Desmond Lee [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: help with syntax of left outer join
Date: Tue, 13 Aug 2002 14:34:06 -0700
Hi there
I want to do a left outer join but i also have a bunch of where conditions
From: Desmond Lee [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: help with syntax of left outer join
Date: Tue, 13 Aug 2002 14:34:06 -0700
Hi there
I want to do a left outer join but i also have a bunch of where conditions
in my sql statment that i need. Can anyone help me out:
SELECT
Hi guys
I know that you can import data into a table by using 'load data infile' or
'mysql' import.
however, is there something that allows you to export the create statemtns
for the table schema and the data of a database for backup. SO that if we
reinstall the whole thing from scratch all
Thanks Jeremy :)
From: Jeremy Zawodny [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Desmond Lee [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: exporting data
Date: Fri, 2 Aug 2002 15:59:01 -0700
On Fri, Aug 02, 2002 at 03:55:52PM -0700, Desmond Lee wrote:
Hi guys
I know
1 - 100 of 203 matches
Mail list logo