Using 5.1.41/Ubuntu
I have 2 tables, members & countries. The former has a column,
country_id (tinyint(3) unsigned). The countries id column is the same
(although auto_increment). I'm trying to select just those countries for
which there is a member. So I decided this query should do the trick
On 10-06-14 09:13 PM, brian wrote:
Using 5.1.41/Ubuntu
I have 2 tables, members & countries. The former has a column,
country_id (tinyint(3) unsigned). The countries id column is the same
(although auto_increment). I'm trying to select just those countries for
which there is a mem
Ver 14.14 Distrib 5.1.49, for debian-linux-gnu (x86_64) using readline 6.1
Logged in as root, SHOW DATABASES displays a DB name that is
inaccessible. I haven't done anything with this DB for ~5 years. I was
recently asked to do some work on the project and was actually surprised
that I (suppos
On 11-03-28 06:38 PM, Dan Nelson wrote:
In the last episode (Mar 28), brian said:
Ver 14.14 Distrib 5.1.49, for debian-linux-gnu (x86_64) using readline 6.1
Logged in as root, SHOW DATABASES displays a DB name that is inaccessible.
I haven't done anything with this DB for ~5 years.
I have a table that joins on itself through a second table:
table expression:
id INT PRIMARY KEY,
lang_id INT
term VARCHAR(128)
table expression_expression:
id INT PRIMARY KEY
expression1_id INT
expression2_id INT
In order to find associated records, I had originally used a UNION,
which work
On 12-07-02 09:33 PM, yoku ts wrote:
Hello,
add index to expression1_id and expression2_id on expression_expression.
it doesn't use index,following,
WHERE
ee2.expression1_id = $ID
OR
ee1.expression2_id = $ID
Thank you for your reply. The table already has indexes on thes
On 12-07-03 01:13 PM, Stillman, Benjamin wrote:
I don't see an index for expression.id.
mysql db_lexi > show index from expression\G
*** 1. row ***
Table: expression
Non_unique: 0
Key_name: PRIMARY
Seq_in_index: 1
Column_name: id
On 12-07-03 02:18 PM, Stillman, Benjamin wrote:
Not sure why it wouldn't show primary as a possible key then...
Yes, that seems rather strange.
From your first email:
*** 1. row ***
id: 1
select_type: SIMPLE
table:
On 12-07-16 06:57 PM, Rick James wrote:
Plan A:
Would the anti-UNION problem be solved by hiding the UNION in a subquery? The
outer query would simply return what the UNION found.
Of course! Yes, problem solved.
Plan B:
Insert every row twice into expression_expression -- (e1,e2) and also
Timothy,
Definately follow the advice that Shawn gave you. Doing it this way
will make it easy to have any number of emails per person without have
to know how many beforehand
. Here's an example below:
Table USERS:
userid=15
fname='Timothy'
lname='Luoma'
Table EMAILS:
userid=15
email='[EMAIL
On Mon, 18 Oct 2004 17:49:22 -0400, Timothy Luoma <[EMAIL PROTECTED]> wrote:
>
> Ok, this makes a lot of sense now. (As usual, what seems like more
> work initially pays off in the end.)
>
> Here's a specific question.
>
> The parent project is called "TiM". We will, at times, want to pull
> o
try:
system "echo hi there";
without the single quotes :)
On Mon, 18 Oct 2004 21:04:19 -0400, Rhino <[EMAIL PROTECTED]> wrote:
> I thought you'd nailed it when I read your note but I found that your
> suggestion didn't work.
>
> When I tried executing the script with this added to it:
>
> syste
system command on my Linux
> system. Is that normal for Mandrake 9.1? If it is, where do I get this
> command? I can get the system administrator to install the appropriate RPM
> if you can tell me what it is and where I can find it.
>
> Rhino
>
>
>
> - Original Me
select s.userid from surveyanswers s where s.userid not in (select
distinct u.id from users u)
On Tue, 19 Oct 2004 16:30:29 -0600, Jonathan Duncan <[EMAIL PROTECTED]> wrote:
> I have a user who is using the following query to try and delete rows
> from one table based on the lack of a user id in
Sorry, I'm used to oracle, thought this was a standard query.
> Brian wrote:
> > select s.userid from surveyanswers s where s.userid not in (select
> > distinct u.id from users u)
> >
> >
> > On Tue, 19 Oct 2004 16:30:29 -0600, Jonathan Duncan <[EMAIL
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Now i don't use the multitable deletes much .. at least not yet
but i think
DELETE tids FROM
:)
Longer explanation:
Javascript is just for font end presentation, or formating.. Like HTML it
doesnt effect the php or mysql
php gets processed on the server.. JS gets processed on the client browser
Brian
> I have a number of web based apps written in PHP/MySql and while they
> are
private Google search engine.
What advice do you have for me?
Thanks for your input,
Brian
Network Services
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Nick:
- Original Message -
From: "Nick Arnett" <[EMAIL PROTECTED]>
To: "Brian" <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]>
Sent: Monday, March 24, 2003 7:47 PM
Subject: RE: Your professional opinion Please...
> > I have a c
> On Mon, Mar 24, 2003 at 06:41:07PM -0800, Brian wrote:
> > I have a client with approximately 2 gigabytes of un-indexed
> > document files (includes text and graphics).
> > He wants to be able to enter a few parameters and bring up
> > a list of all...
> If
- Original Message -
From: "Joe Lewis" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Cc: "Brian" <[EMAIL PROTECTED]>
Sent: Tuesday, March 25, 2003 8:42 AM
Subject: Re: Your professional opinion Please...
> Peter L. Berghold
- Original Message -
From: "James E Hicks III" <[EMAIL PROTECTED]>
To: "Joe Lewis" <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]>
Cc: "Brian" <[EMAIL PROTECTED]>
Sent: Tuesday, March 25, 2003 8:56 AM
Subject: RE: Your
Thanks Mark:
- Original Message -
From: "Mark C. Roduner, Jr." <[EMAIL PROTECTED]>
Sent: Tuesday, March 25, 2003 3:45 PM
Subject: RE: Your professional opinion Please...
> Brian,
> Here's Some hints on how to accomplish an efficiant way
> to index th
Thanks Peter:
- Original Message -
From: "Peter L. Berghold" <[EMAIL PROTECTED]>
To: "Brian" <[EMAIL PROTECTED]>
Cc: "MySQL" <[EMAIL PROTECTED]>
Sent: Tuesday, March 25, 2003 4:07 PM
Subject: Re: Your professional opinion Please...
>
Hi,
I'm in the same situation (installing mysql on a raq4).
The package master site's most recent version (that I noticed) of mysql is
MySQL 3.23.37
Does anyone have suggestions for a more recent version in .pkg?
Than
My mistake. The latest InnoDB works as expected. Sorry to clutter the list
with my own lack of attention.
Never compile the same code on 2 different boxes with different operating
systems and different configurations at the same time.
Thanks for all your work Heikki!
Cheers,
Brian
> Hei
s its running MySQL 3.23.41
Client characterset: latin1
Server characterset: latin1
Any help would be greatly appreciated
Thanks,
Brian
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
I am trying to create an environment where the mysql db server is on one
box and my application server is on a second. The db server is running
on the first box and I can connect to it locally using the mysql
interface.
What needs to be installed from the mysql distribution on the
application ser
Bug#18283: http://bugs.mysql.com/18283)
Enjoy,
Brian
--
Brian Pontz, Senior Product Engineer
MySQL Inc., USA, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mpleted_modules` (
`module_id` char(2) NOT NULL default '',
`email` varchar(64) NOT NULL,
`score` int(2) NOT NULL default '0',
`time` timestamp NOT NULL default CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Brian Menke
Visual Matter, Inc
1445 Fo
(user name, password,
session id's etc.) but I do get what you are saying. Thanks for the
UTC_TIMESTAMP suggestion. Although, since I haven't had a lot of experience,
I don't really understand why it is better than CURRENT_TIMESTAMP. But.
that's why I asked for advice :-)
-Br
olves
huge problems for me and I seriously owe you! I'm gonna do some more
research so I understand how this works.
THANKS!
-Brian
_
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 24, 2006 3:56 PM
To: Brian Menke
Cc: mysql@lists.mysql.com
Subject: Re: Fun
t webex and how they send emails that automatically adjusts
for time zones. I think at some point, I had to tell them what time zone I
was in. I see that a lot on the web. Seems like a pain, but I don't see any
way around it.
-Brian
-Original Message-
From: sheeri kritzer [mailto:[EMAIL P
2
[EMAIL PROTECTED]
7
5/27/2006 9:47 PM
3
[EMAIL PROTECTED]
8
5/27/2006 9:50 PM
I looked a few places on google, but they seemed to be suggesting using DESC
in the where clause and I didn't see how that was going to work?
Any ideas are greatly appreciated!
-Brian Menke
ure out how to piece them together.
Any ideas are greatly appreciated!
-Brian Menke
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
d
and was driving me crazy.
Seems simple now but... yikes!
Thanks for everyone's help on this!
-Brian
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Saturday, May 27, 2006 9:53 PM
To: Brian Menke
Cc: mysql@lists.mysql.com
Subject: Re: Get the record with
ules.module_id = modules.module_id)
GROUP BY module_id, email;
SELECT
module_id,
module_name,
email,
score,
DATE_FORMAT(DATE_SUB(date_time, INTERVAL time_zone HOUR),'%e %M %Y') as
'date_time'
FROM t
WHERE
email = '[EMAIL PROTECTED]'
ORDER BY date_time DESC;
Thanks for any help on this!
-Brian Menke
My understanding is that SCSI has a faster transfer rate, for
transferring large files. A busy database needs really fast access,
for making numerous fast calls all over the disk. Two different,
unrelated things.
I am more than willing to be called Wrong, slapped, and cast from a
bridge.
You could also use OR
select id, title from content where id = 100 or id =106;
Brian
From: "Quentin Bennett" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>,
Subject: RE: select random ids from list
Date: Tue, 1 Aug 2006 14:59:14 +1200
If you know the list of Ids, try
I'm tracking site visitors with a database - one field is the IP
address, the other is the page they've visited. I don't want any
duplicates of this combination. Is there a MySQL statement similar to
INSERT IGNORE but will ignore only if the combination is duplicated?
--
MySQL General Maili
lternative if you
are no longer associated to Zettai.net? (and I draw this conclusion because
George has remove the email link from your name on the "About" page)
Thanks in advance...I appreciate anything you can do or suggest.
Sincerely,
Brian Fox, MBA
--
No virus found in this
I'm searching a database of geopoints, and when two records have the
same latitude and longitude, I only want to return one of them -
basically just find all the unique locations. How do you set up a
select like this? Thanks...
--
MySQL General Mailing List
For list archives: http://lists.m
Many different records will be returned though, I just don't want any
dupes where both lat/lon is the same.
:)
On Sep 12, 2006, at 12:20 PM, Hiep Nguyen wrote:
select * from table where . limit 1
that would do it if you don't care which one it returns
JC
On Tue, 12 Sep 2
Lat & lon are two different fields. Either can be duplicated, but not
both.
On Sep 12, 2006, at 12:33 PM, Steve Musumeche wrote:
Select DISTINCT(lat_long_field) from table where...
Steve Musumeche
CIO, Internet Retail Connection
[EMAIL PROTECTED]
Brian Dunning wrote:
Many diffe
)) from table where ...
Steve Musumeche
CIO, Internet Retail Connection
[EMAIL PROTECTED]
Brian Dunning wrote:
Lat & lon are two different fields. Either can be duplicated, but
not both.
On Sep 12, 2006, at 12:33 PM, Steve Musumeche wrote:
Select DISTINCT(lat_long_field) from table w
Never mind, I figured it out:
select distinct(concat(lat,lon)), lat, lon where
On Sep 13, 2006, at 6:57 AM, Brian Dunning wrote:
But if I do this, how do I still get lat and lon as two different
fields? This finds the right record set, but it returns both fields
concatenated into a
Hi Agrapin -
This sounds great. Could you please post some of your timber products
here to the list? Many of us are really looking for a break from this
boring MySQL stuff. Thanks, and our kind regards to you too.
- Brian
On Sep 11, 2006, at 7:57 PM, Agrapin S.A. - Timber Industry and
south Orange County, CA.
No outsourcers or non-locals can be considered, sorry.
Please email me back-channel for details if interested. Thanks!
- Brian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have a very busy 14,000,000 record table. I made a new version of
the table, that's more efficient, and now I just need to copy over
the data. Just about anything I try swamps the machine and locks up
MySQL with "too many connections" because it's so damn busy. Can
anyone suggest the most
I have a need to insert a record only when the combination of 3
fields is unique. I do this by having an index with all 3 fields, and
doing an INSERT IGNORE. This works fine.
Here's the element I can't figure out how to add: When there is a pre-
existing record, I want to update two of its c
#x27;re
available.
On Sep 27, 2006, at 12:37 PM, Dan Buettner wrote:
Brian, I'm not sure there's a quick way to copy 14 million records, no
matter how you slice it. Disabling the indexes on the destination
table might help - but then you've got to devote some time to
Thanks Dan, I believe that's exactly what I was looking for. Thanks
for not saying "RTFM" even though it clearly applies. :)
On Sep 27, 2006, at 12:57 PM, Dan Julson wrote:
Brian,
Look at the ON DUPLICATE KEY UPDATE syntax within the INSERT SYNTAX
of the
Docs. That
Before I do this, I just wanted to check with you all to see if this
is the correct command:
/etc/rc.d/init.d/mysqld restart --log-slow-queries
If so, where exactly will I find the slow query log?
Will the slow query log be turned off by default next time I restart it?
--
MySQL General Mailin
I have a 17,000,000 record table that I'm trying to duplicate in
order to make some changes and improvements, then I'll rename it and
drop the original table. So I need this duplicate to be a live table
in the same database as the original.
I tried the "copy table" function in the Operation
Thanks Chris, this sounds great but when I read about mysqlhotcopy I
didn't see a way to make it create a live table that's open within
the same database, it seems to want only to create a separate backup
file in some directory.
On Sep 27, 2006, at 6:10 PM, Wagner, Chris (GEAE, CBTS) wrote
The problem when I try this is that the database gets locked up:
INSERT INTO newtable2 SELECT * from oldtable
On Sep 27, 2006, at 12:37 PM, Dan Buettner wrote:
Brian, I'm not sure there's a quick way to copy 14 million records, no
matter how you slice it. Disabling the inde
phpMyAdmin is giving me the following warning:
PRIMARY and INDEX keys should not both be set for column `referer`
Here is what the table looks like:
CREATE TABLE `myspacemap_visitors_2` (
`creation` timestamp NOT NULL default CURRENT_TIMESTAMP on update
CURRENT_TIMESTAMP,
`lat` double NOT
I'm trying to delete all but the newest n records.
DELETE FROM tablename ORDER BY creation DESC LIMIT=n
This does the opposite of what I want. Is there some way to tell it
to start the delete after n and delete all the remaining records?
--
MySQL General Mailing List
For list archives: http:
The offset is what I was thinking of - that would be the simplest -
but as far as I can tell, delete doesn't support the offset. It's not
documented, and it gives me an error when I try it. I was hoping to
avoid two queries but it sounds like that's what I might have to do.
On Oct 4, 2006,
e visit http://www.messagelabs.com/email
__
<
-- Original Message --
FROM: Brian Dunning <[EMAIL PROTECTED]>
TO:mysql@lists.mysql.com
DATE: Wed, 4 Oct 2006 08:49:48 -0700
SUBJECT: Re: Deleting, skip the first n records
The offset is wh
right before I
use the connection. It always returns 1. How can I set my timeout to a
really high number?
Thanks.
-Brian
Brian E Campbell
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysq
I've got a GoDaddy virtual dedicated server and I'm trying to run a
LOAD DATA INFILE, but I keep getting "Can't get stat of '/home/httpd/
vhosts/04planet.info/httpdocs/test.txt' (Errcode: 13)"
As you can see from that error message, I've uploaded my data file to
the httpdocs directory and tr
I just solved my own problem. For the benefit of others, I only
needed to set permissions to 755 for the directory containing my data
file. Works fine now.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
You have to purchase a database. ZIP codes are not geographic, you
can't calculate lat/lon from them. Here is one source:
http://www.zipwise.com
On Jun 26, 2005, at 6:43 PM, Scott Gifford wrote:
Jack Lauman <[EMAIL PROTECTED]> writes:
A couple of months ago these was a discussion about ZI
Dude, that's more than 5 years old.
On Jun 26, 2005, at 8:27 PM, Scott Gifford wrote:
Brian Dunning <[EMAIL PROTECTED]> writes:
You have to purchase a database. ZIP codes are not geographic, you
can't calculate lat/lon from them. Here is one source:
http://www.zipwise.
real business that needs their app to give correct
results. :)
If anyone does know a free source of CURRENT data (updated at least
monthly) please post it - just cuz I can't find one doesn't mean it's
not out there! :)
On Jun 27, 2005, at 8:21 AM, Scott Gifford wrote:
A lot cheaper here:
http://www.zipwise.com/database-download-now.php
On Jun 28, 2005, at 5:30 AM, Mattias Håkansson wrote:
This one goes for $169, and you get longitudes and latitudes.
http://www.buyzips.com/platinum-expanded.htm
Regards,
Mattias Håkansson
- Original Message -
From
http://www.buyzips.com/platinum-expanded.htm
This one also says it's only updated every 6 months. Ouch!! Another
reason I recommend Zipwise instead. Cheaper and fresher data:
http://www.zipwise.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
be changed to "5678" like this:
http://www.domain.com?etc=etc&arg=5678&etc=etc
...without changing the rest of the string. I'm hoping it's possible
to make this update to the entire table with a single SQL
statement If so I have no idea how to create it. Any help
appreciate
Wow - so easy! What a dork. Thanks guys. :) :)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I am cross-posting this to the PHP and the MySQL lists because I'm
not sure in which technology my solution will lie.
I have a pretty busy PHP/MySQL site that executes the following query
a lot:
select count(*) as `count` from terms;
My MySQL account was disabled by my ISP because this que
If I have a table with 200K records, is there an easy way to split it
into two separate tables with 100K records each?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
My RaQ4 is throwing the "Too many connections" error. Now, it is
getting hit pretty hard by traffic, but I wonder if my coding might
be exacerbating this error.
Due to my relatively lazy structure of includes and functions, my
pages might have half a dozen or so of these (most are to the sa
In one case I do need to jump back and forth between databases that
are on different physical servers. What's the most efficient way to
handle this?
On Aug 2, 2005, at 11:14 AM, Devananda wrote:
Brian Dunning wrote:
My RaQ4 is throwing the "Too many connections" er
I'm searching a table of people who own properties, and I want to
also include the total count of related properties, and the count of
related properties whose (status is 'Active' and approval is
'Active'). I've got:
select accounts.name, count(properties.property_id) as totalcount
from a
That's exactly what I'm looking for, thanks Eugene. :)
On Aug 5, 2005, at 12:46 AM, Eugene Kosov wrote:
Brian Dunning wrote:
I'm searching a table of people who own properties, and I want to
also include the total count of related properties, and the count
of related p
I am hosting on a RaQ4 which is terribly underpowered. Within a
minute of a reboot it's CPU and RAM are both red in the admin screen.
The app is optimized as much as possible but it just gets too much
traffic, too many MySQL connections. It's maxed out at 512K RAM.
I have a generic 2.5GHz P
Same machine, any performance difference?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Like crashing, auto-rebooting, memory leaking, program cost, etc...
:)
Brian Duke
Level(3) Communication
==-=-=-=-=--==--==¬
-Original Message-
From: Pat Adams [mailto:[EMAIL PROTECTED]
Sent: Friday, August 12, 2005 9:21 AM
To: mysql@lists.mysql.com
Subject: RE: Linux vs
http://www.briandunning.com/helios.shtml
Sorry this is WAY OFF TOPIC, but it's a pretty darn scary picture.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have a table of questions, and a table of answers. Each question
has a related answer record for each person who has answered that
question, and each answer is timestamped. How do I find a list of
questions where the MOST RECENT answer is less than 30 days ago?
(Basically trying to exclud
So simple - I was trying to WAY overcomplicate it. Thanks. :)
On Aug 17, 2005, at 10:05 AM, Jon Drukman wrote:
Brian Dunning wrote:
I have a table of questions, and a table of answers. Each
question has a related answer record for each person who has
answered that question, and each
>From what I recall MysqlCC has been deprecated and has been replaced by
MySQL Administrator (which does support v5). I don't know think mysqlcc
supports v5.
good luck,
--bemansell
On 8/30/05, Siegfried Heintze <[EMAIL PROTECTED]> wrote:
>
> [Siegfried Heintze] I love MySQL Control center. I c
My web site has always worked, I didn't change anything, so whatever
is causing this error happened all by itself:
#1017 - Can't find file: './kessler/products.frm' (errno: 13)
In phpMyAdmin, it shows the tables are "in use" and there's no way to
execute a repair or anything. I don't know wh
this machine?
do you have administrator access?
does kessler/products.frm still exist? [likely: /var/lib/mysql/
kessler/products.frm]
On Sat, 3 Sep 2005, Brian Dunning wrote:
My web site has always worked, I didn't change anything, so
whatever is causing this error happened all by itsel
On Sep 3, 2005, at 1:43 PM, Jason Pyeron wrote:
google pulls up many instances of this error from several
'different' servers, you might lookinto the software.
http://www.google.com/search?num=50&hl=en&lr=lang_en&safe=off&q=%
27kessler%2Fproducts.frm%27&btnG=Search&lr=
The reason for that is
On Sep 3, 2005, at 1:43 PM, Jason Pyeron wrote:
it could be that the permissions are wrong, too.
The permissions for all the files in there are -rwxrwxr-x ...I don't
know if that's what they should be or not.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
FIXED...
I did a chmod +rwx on the directory, and now all is well.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Sep 3, 2005, at 1:43 PM, Jason Pyeron wrote:
google pulls up many instances of this error from several
'different' servers, you might lookinto the software.
http://www.google.com/search?num=50&hl=en&lr=lang_en&safe=off&q=%
27kessler%2Fproducts.frm%27&btnG=Search&lr=
The reason for that
I got a 12-hour invoice from a consultant who was tasked to do the
following:
- Install a Red Hat machine from absolute scratch for PHP/MySQL/Apache
- Copy over some MySQL databases
- Have mod_rewrite working via htaccess, and have wildcard DNS
I realize there are a billion different variabl
How do I append one table's contents to another? Both have identical
structure. Problem is I don't have shell access, only phpAdmin or a
PHP file I write & upload myself.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[E
INSERT into tbl1 SELECT * FROM tbl2
Thanks to both of you, but this is not working. Since one of the
fields is a primary key that's duplicated in both tables (both tables
have records numbered 1, 2, 3...), it won't allow the duplicate
entries. Fortunately I do not need those primary key va
On Oct 11, 2005, at 8:24 AM, Jose Miguel Pérez wrote:
INSERT INTO table1 (field1, field2)
SELECT field1, field FROM table2
Jose's solution worked perfectly. Thanks everyone, sorry for being so
dense today. :)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Can someone pelase explain to me how to store the pathname and the filename
in a MySQL database , I need it to loop thru a Folder and grab all pathnames
and filesnames within that folder and store it in a MySQL database,,
thanks
ension is: does
it mean that my ISP (PowWeb) probably doesn't have it installed?
Has anyone else who has tackled this application found the Spatial
Extensions to be useful, or is it better to stick with the basics and
go the route discussed in Steffan's recent thread?
- Brian
If I say this, I get all my data:
But if I say this, I get no results at all:
Seems pretty straightforward. What am I missing?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I got it to work - turns out it was a stupid typo on my part (hate it
when that happens - and hate wasting the list's time even more!). How
long does this temporary table persist for - just the execution of
the one page, or will it live on the server (using resources) until I
explicitly mak
That's awesome! I love it. Even though it didn't include me... :(
How are you doing the geotargeting?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I'm trying to find a list of customers including a count of all their
invoices, but it's not including customers who have no invoices - and
it should. What's broken?
SELECT customers.company, count(invoices.id) as invcount
FROM customers, invoices
WHERE customers.id= invoices.customer_id
GROU
Thanks very much to all of you!
Obviously I need to learn more about joins. Appreciate the kick in
the pants.
:)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
1 - 100 of 687 matches
Mail list logo
