update newslettercontent c set c.timestamp= (select n.publishdate from
newsletter n where
n.NLCID= c.NLCID);
This should work.
On 4/16/08, Chris W <[EMAIL PROTECTED]> wrote:
>
> I have the following query...
>
> SELECT c.NLCID, n.publishdate
> FROM newsletter n
> JOIN newslettersection s using
Hiep Nguyen schrieb:
hi all, i have an existing database (internal) with a user named
'admin', everything works fine as far as privileges concern.
i just created a new database (test) and want to grant admin's
privileges on test as same as internal.
how do i do this???
i tried (as root):
g
Chris W schrieb:
I have the following query...
SELECT c.NLCID, n.publishdate
FROM newsletter n
JOIN newslettersection s using (NLID)
JOIN newslettercontent c using(NLCID)
WHERE contenttype = 1 AND n.publishdate AND c.`timestamp` = '-00-00
00:00:00'
I want to run an update on newslettercon
use can say mysqldump --help, it would give you all the options.
To speedup the dump, you can use -e -q and --single-transaction,
regards
anandkl
On 4/16/08, minky arora <[EMAIL PROTECTED]> wrote:
>
> Thanks.
> I will successful in executing LOAD DATA INFILE>
>
> Now i need to do a SqlDump as w
I have the following query...
SELECT c.NLCID, n.publishdate
FROM newsletter n
JOIN newslettersection s using (NLID)
JOIN newslettercontent c using(NLCID)
WHERE contenttype = 1 AND n.publishdate AND c.`timestamp` = '-00-00
00:00:00'
I want to run an update on newslettercontent and set its t
Can you give the output of the command
show grants for admin;
Thank You,
-srini
Hiep Nguyen wrote:
hi all, i have an existing database (internal) with a user named
'admin', everything works fine as far as privileges concern.
i just created a new database (test) and want to grant admin's
pr
> I would have thought your not = though is matching a lot more rows every
> time..
The field is UNIQUE PRIMARY KEY in both tables, so there
should be 0 or 1 matches.
> I would look into using where not exists as a subselect
My MySQL book (O'Reilly second edition) does not mention
subqueries or
How about using a left outer join. Find all the rows in bar without a
matching row in foo:
To verify:
select *
from bar
left outer join foo on bar.phone=foo.phone
where foo.phone is null
Then
delete bar.*
from bar
left outer join foo on bar.phone=foo.phone
where foo.phone is null
Phil <[EMA
Try using the sub query as a derived table ala:
SELECT eo_name_table.eo_name, eo_name_table.eo_pub_date
FROM eo_name_table LEFT JOIN (SELECT prod.prod_title FROM prod WHERE prod.prod_discont = 0) fake_prod on eo_name_table.eo_name = fake_prod.prod_title
WHERE prod.prod_title IS NULL
I'm not
I would have thought your not = though is matching a lot more rows every
time..
I would look into using where not exists as a subselect
delete from bar where not exists (select 'y' from foo where foo.phone =
bar.phone);
something like that.
On Tue, Apr 15, 2008 at 5:00 PM, Patrick J. McEvoy <[E
I have two MyISAM tables; each uses 'phone' as a primary key. Finding
rows where the primary keys match is efficient:
mysql> explain select bar.phone from foo,bar where foo.phone=bar.phone;
++-+---++---+-
+-+---+---+--
Thanks.
I will successful in executing LOAD DATA INFILE>
Now i need to do a SqlDump as well to get a backup of the DB..I looked at
the syntax but am not sure if /what all options to use.
I only have one DB.
Could someone tell me if I really need to specify any options ?
Unable to find this in the manual ...
Yesterday morning we rebooted the server by accident, which crashed and
restarted MySQL 4.1. Late last night a scheduled job ran mysqlcheck and
found 4 open tables. When I next ran mysqlcheck it found nothing wrong.
mysqlcheck command:
CHECK TABLE $DBTABLES $
Am Dienstag, den 15.04.2008, 15:11 -0400 schrieb minky arora:
> Could someone pls guide me as to the best way of adding excel files as
> tables to Mysql ?
You can import CSV files into MySQL:
http://dev.mysql.com/doc/refman/5.1/en/load-data.html
Norbert
--
MySQL General Mailing List
Fo
Have identical versions installed, in one query works fine, in another,
pukes with the error in the subject.
When I query by hand (via mysql client) works fine.
Not even that much data to complain about!
mysql> select
-> group_concat(concat('',hosts.name,'') order by hosts.name asc
separa
Daniel,
Thanks for pointing that out. I haven't heard of this before so I
really don't have a clue. We use Openoffice 2.4 to create the magazine
and generate the pdf. It works fine in both OO and adobe acrobat (I am
"blessed" with a Windows laptop).
Keith
Daniel Brown wrote:
On Tue, Apr
On Tue, Apr 15, 2008 at 3:11 PM, minky arora <[EMAIL PROTECTED]> wrote:
> Hi Gurus,
> I am a newbie.Please bear with me.
> Could someone pls guide me as to the best way of adding excel files as
> tables to Mysql ?
mysqldump is for exporting data. What you're looking for is the
"LOAD DATA [
Hi Gurus,
I am a newbie.Please bear with me.
Could someone pls guide me as to the best way of adding excel files as
tables to Mysql ?
Thanks
On Tue, Apr 15, 2008 at 7:27 AM, Paul DuBois <[EMAIL PROTECTED]> wrote:
>
> At 10:32 AM +0530 4/15/08, Krishna Chandra Prajapati wrote:
>
> > Hi,
> >
> > I have created a table name group.
> >
> > CREATE TABLE `group` (
> > `group_id` int(11) NOT NULL,
> > `group_name` varchar(128) NOT NULL,
> >
On Tue, Apr 15, 2008 at 2:20 PM, B. Keith Murphy <[EMAIL PROTECTED]> wrote:
> Hey everyone,
>
> I just posted the Spring issue of the MySQL Magazine. This issue contains
> a great group of articles that you will want to read. In addition, Sheeri
> Cabral did a fabulous job with a new layout for
Hey everyone,
I just posted the Spring issue of the MySQL Magazine. This issue
contains a great group of articles that you will want to read. In
addition, Sheeri Cabral did a fabulous job with a new layout for the
magazine. It is as always FREE!!.
Available for download from http://www.my
Hi,
If you really need to call it group, try using :
`group` in your query (use the ` thing)
Regards,
Velen
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Krishna Chandra Prajapati" <[EMAIL PROTECTED]>; "mysql"
Sent: Tuesday, April 15, 2008 6:27 PM
Subject: Re: Cre
On Fri, Apr 11, 2008 at 4:01 PM, Victor Danilchenko
<[EMAIL PROTECTED]> wrote:
> Oooh, this looks evil. It seems like such a simple thing. I guess
> creating max(log_date) as a field, and then joining on it, is a solution --
> but my actual query (not the abridged version) is already half a
Ratheesh,
There's a specific list for PHP database functions, "Databases and
PHP" (PHP-DB), which you can find at http://php.net/mailinglists .
I'm forwarding your message over to there, and recommend that you
subscribe to that list. You'll probably get more direct responses by
narrowing-
I just thought of something else... could the same be accomplished
using stored routines? I could find no way in MySQL to create stored
routines which could be used with the 'group by' queries though.
If this were possible, it should then be also possible to define a
'LAST' stored routine, o
Hello folks,
Any way to retrieve the error code/error number from a stored proc.
Scenario
--
calling a stored proc from PHP - using mysqli_multi_query()
The stored proc has multiple queries. Lets say one of the queries generates
an exception.
How do I retrieve the error message w
It's possibly a DNS problem (reverse DNS exactly).
Best regards.
On Tue, Apr 15, 2008 at 9:05 AM, Wm Mussatto <[EMAIL PROTECTED]> wrote:
> Possible key refers to the keys that the server thinks might be usable.
> key refers to the one is chose. On the slow server it decided that the
> possible key would not work so it didn't use it. You might try to force
>
On Tue, April 15, 2008 02:03, [EMAIL PROTECTED] wrote:
> I'm still trying to decript the EXPLAIN result, and there is something I
> really
> don't understand:
>
> mysql> EXPLAIN SELECT STRAIGHT_JOIN media.* FROM country,content,media
> WHERE
> country.id='Germany' AND country.detail_tid=content.tid
I'm drawing a blank here.
I need to extract two sets of records from a pair of tables. `eo_name_table`
is a list of titles, `prod` is a list of products having titles and a
discontinued flag. I want all of those records from `eo_name_table` that do
not have a matching title in `prod`. I also want
At 10:32 AM +0530 4/15/08, Krishna Chandra Prajapati wrote:
Hi,
I have created a table name group.
CREATE TABLE `group` (
`group_id` int(11) NOT NULL,
`group_name` varchar(128) NOT NULL,
`date_created` datetime NOT NULL,
`created_by` int(11) NOT NULL,
`modified_by` int(11) default NUL
Perrin Harkins schrieb:
On Tue, Apr 15, 2008 at 4:21 AM, Sebastian Mendel
<[EMAIL PROTECTED]> wrote:
use UNION
You can't use UNION to add the results of two queries. It would
return two rows.
of course!
you need to use this UNION as subquery
sorry for being not imprecise
--
Sebastian
-
perl pra schrieb:
Hi ALL,,
I am new to perl,
I have a database which works fine in windows, Now i need to change table
names to uppercase in Linux.
So I have done the following:
I copied all the from files into /var/lib/mysql/new_db from windows to
linux.
Then changed the names to caps;
and
Hi ALL,,
I am new to perl,
I have a database which works fine in windows, Now i need to change table
names to uppercase in Linux.
So I have done the following:
I copied all the from files into /var/lib/mysql/new_db from windows to
linux.
Then changed the names to caps;
and changed the permiss
On Tue, Apr 15, 2008 at 4:21 AM, Sebastian Mendel
<[EMAIL PROTECTED]> wrote:
> use UNION
You can't use UNION to add the results of two queries. It would
return two rows.
- Perrin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysq
hi all, i have an existing database (internal) with a user named 'admin',
everything works fine as far as privileges concern.
i just created a new database (test) and want to grant admin's privileges
on test as same as internal.
how do i do this???
i tried (as root):
grant all on test.* to
Sebastian Mendel <[EMAIL PROTECTED]> writes:
> Changying Li schrieb:
>> why does mysql use group_id index ?
> because in this case group_id would be faster than user_id
but in fact group_id is very slow (51.21 sec), user_id is (0.00 sec)
>>> ok, at least MySQL does think so
>> I know,
I'm still trying to decript the EXPLAIN result, and there is something I really
don't understand:
mysql> EXPLAIN SELECT STRAIGHT_JOIN media.* FROM country,content,media WHERE
country.id='Germany' AND country.detail_tid=content.tid AND
content.id=media.content_id;
On the FAST server:
+--+---+
Jonathan Mangin schrieb:
I'm trying to total certain nutrients consumed on a given date
(though I've removed date temporarily).
You'll see I have three items (in two meals) in itemized,
and two meal totals in simple.
mysql> select id, item, carb from my_menu where id in (10, 11, 22);
++
I have a setup with a master and a bunch of slaves in my LAN as well as
one external slave that is running on a Xen-Server on the internet.
All servers run Debian Linux and its mysql version 5.0.32
Binlogs are around 2 GB per day. I have no trouble at all with my local
slaves, but the external one
Changying Li schrieb:
why does mysql use group_id index ?
because in this case group_id would be faster than user_id
but in fact group_id is very slow (51.21 sec), user_id is (0.00 sec)
ok, at least MySQL does think so
I know, but I what I really want to know is how does mysql think so ?
be
Use the below link to know how to setup replication.
http://dev.mysql.com/doc/refman/5.0/en/replication-howto.html
regards
anandkl
On 4/15/08, Kaushal Shriyan <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I need to run a longer running insert and test it in the Master Slave
> Replication Database Serve
42 matches
Mail list logo
