.
Regards
Brian vd Westhuizen
-Original Message-
From: Asma rabe [mailto:asma.r...@gmail.com]
Sent: Thursday, 6 March 2014 12:08 a.m.
To: Andrew Moore
Cc: Reindl Harald; mysql@lists.mysql.com
Subject: Re: New to MySQL
How to do that?
Thank you
On Wed, Mar 5, 2014 at 8:03 PM, Andrew Moore
Why don't you just use yum install .
Should sort out most if not all your problems regarding installation of mysql.
Regards
Brian vd Westhuizen
-Original Message-
From: Asma rabe [mailto:asma.r...@gmail.com]
Sent: Wednesday, 5 March 2014 1:21 a.m.
To: geetanjali mehra
Cc: Joh
g and particular with mysql the I
suggest you look at other products.
But it is fairly easy to set up and administer, we have quite a few
instalations of this nature, multi master with lots of slaves hanging of the
masters !
Regards
Brian vd Westhuizen
Informix/MySQL/Postgres/MongoDB Dat
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
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-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-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
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
Y `id_type` (`id`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
There are about 16.5 million records in the table.
Thanks!
- Brian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ather than trying to
move it around from platform to platform.
-Original Message-
From: Jan Steinman [mailto:j...@bytesmiths.com]
Sent: Thursday, August 11, 2011 2:37 PM
To: David Brian Chait
Cc: mysql@lists.mysql.com
Subject: Re: Import from Quicken 2004 Mac?
On 11 Aug 11, at 14:17, David
The QIF file includes a lot of data aside from basic transactions, what exactly
are you trying to end up with at the end of the day? Simply a copy of your QB
data in Mysql?
-Original Message-
From: Jan Steinman [mailto:j...@bytesmiths.com]
Sent: Thursday, August 11, 2011 2:15 PM
To: mys
Add:
datadir=/path/to/datadir/mysql
to your my.cnf file and restart mysql.
-Original Message-
From: Tina Matter [mailto:ti...@umich.edu]
Sent: Friday, May 13, 2011 8:22 AM
To: mysql@lists.mysql.com
Subject: URGENT: Change Default Location of where Database Files get written?
I have a My
Go to the cmd line and type ps -ef , do you see mysqld listed? If so then it is
already running.
-Original Message-
From: Gergely Buday [mailto:gbu...@gmail.com]
Sent: Tuesday, April 26, 2011 5:56 AM
To: mysql@lists.mysql.com
Subject: problem starting server
Hi there,
I installed a my
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.
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
...@gmail.com]
Sent: Sunday, February 27, 2011 12:38 PM
To: David Brian Chait
Cc: Johnny Withers; mysql@lists.mysql.com
Subject: Re: centos server's mysql version's problem
about 8,000,000 visit,and about 40,000,000 sql do
about 2g database,and the large table who aften use about 400m
2x
> -Original Message-
> From: Yang Yang [mailto:dapiy...@gmail.com]
> Sent: Sunday, February 27, 2011 12:29 PM
> To: Johnny Withers
> Cc: mysql@lists.mysql.com
> Subject: Re: centos server's mysql version's problem
> thanks johnny
> what about 5.1,did it performance better than 5.0 on c
Hey all -
I've just uploaded some free Canada sample data to complement the US data that
was already available. Testing apps with a representation amount of sample data
is crucial to evaluate performance. Download the data here:
http://www.briandunning.com/sample-data/
Enjoy,
- Brian
--
No, what he is suggesting is that you use Access or MSSQL, and link Mysql to
either platform via ODBC so that you can use it indirectly. All databases are
not the same in terms structure and capabilities..you most likely will not be
able to swap one out for another and make it work directly with
To borrow your line of reasoning, translators can be rather slow and
unreliable. Adding the extra overhead and complexity is certainly not worth the
potential gains.
-Original Message-
From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De
Meersman
Sent: Tuesday, Fe
7:20 PM
To: Yannis Haralambous
Cc: David Brian Chait; mysql@lists.mysql.com; y...@mpi-inf.mpg.de
Subject: Re: How do increase memory allocated to MySQL?
You're query is doing a full table scan.
2011/2/3 Yannis Haralambous
mailto:yannis.haralamb...@telecom-bretagne.eu>>
just a single ta
Yannis,
How is the data structured? Can you give us an example of the queries
that you are trying to run? Do you have indexes in place? A very inefficient
query, or poorly structured database can lead to this type of timeout issue on
the type of low end hardware that you are using.
Than
Sorry Varuna, I received your email with no context and incorrectly assumed you
were one of our consulting customers (I work in our consulting team).
I have sent your question to our web site team, as I similarly do not see the
signature files.
Sorry for the confusion.
Thanks,
Brian
On Dec
Hi Varuna, the signature file links have been put back on the web site.
Can you please try again? Thanks
On 12/2/2010 5:57 PM, Brian Guy wrote:
Sorry Varuna, I received your email with no context and incorrectly
assumed you were one of our consulting customers (I work in our
consulting team
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
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
Hey all -
I have a table with 12,000,000 records spread over about 6 years. I'm trying to
delete all but the last 2 years, but no matter how small of a group I try to
delete at a time, it keeps hanging up the server and I eventually have to
restart MySQL. The table looks like this:
`creation
You're exactly right, that's an important point that I neglected when putting
together my example. Good catch.
On Mar 18, 2010, at 11:27 AM, Chris W wrote:
> I think I would change the math. Since there are several days in there where
> there are no hits, that should in my opinion count again
My brain just squirted out my ear trying to figure this out, so maybe one of
you can help me scoop it back up.
I have a table of accounts, and a table of hits-per-day per account. I'm trying
to sort my accounts by the most hits-per-day, averaged over the preceding 7
days (8 days ago through yes
thor | Chapter |
++--+-+
| 1 | Smith, John |1|
| 2 | Smith, J.|1|
| 3 | Williams, B. |1|
| 4 | Smith, John |2|
++--+-+
I haven't been able to even get a start on this. Any suggestions?
- Brian
zips, exchange, so will work for mapping, phone or
address validation, whatever your needs are. Hope someone find it useful.
http://www.briandunning.com/sample-data/
On Jan 28, 2010, at 3:52 PM, Brian Dunning wrote:
> I need a few million sample contact records - name, company, address, email
dress validation or mapping.
Anyone have a suggestion?
- Brian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Apologies in advance for spamming the list. My name is Brian Krebs, and I'm
a investive reporter who writes about computer security issues.
I've just interviewed the founder of a Russian security firm who says he's
getting close to posting pointers to and in some cases exploits for
select into outfile was the ticket. Thanks!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Thanks. I added orders.order_date to the list of fields being
selected, but it still returns "invalid use of group function".
On Nov 3, 2009, at 1:09 PM, Martin Gainty wrote:
any column used in any group functions such as SUM needs to be
requested in select column e.g.
select foo from tab
More info. If the tables look like this:
customers
--
cust_id
signup_date
orders
--
order_id
cust_id
order_date
Then the SQL needs to accomplish something like this:
select * from customers
left join orders on customers.cust_id = orders.cust_id
where signup_date
I thought I could find the answer to this by googling, but had no luck.
How do I show a list of customers who:
(a) Have placed no orders within 14 days,
(b) Have been a customer for at least 14 days. (They do not have to
have placed any orders, ever, to be a customer.)
I'm trying to show inac
Darn, it's not working after all.
SELECT
people.*,
COUNT ( DISTINCT cars.car_id ) AS car_count,
COUNT ( DISTINCT pets.pet_id ) AS pet_count,
SUM ( IF ( pets.date_bought > NOW() - INTERVAL 7 DAY, 1, 0 ) ) AS
new_pet_count
WHERE...etc
car_count and pet_count are calculating correctly, but new_p
Johnny - Your solution might actually help me solve my next step,
which is to also return a count of pets bought only within the last 7
days. Something like this:
SELECT people.*,
SUM(IF(cars.id IS NULL,0,1)) AS car_count,
SUM(IF(pets.id IS NULL,0,1)) AS pet_count,
SUM ( IF ( pets.d
Thanks, this solved it!
On Nov 2, 2009, at 12:37 AM, Michael Dykman wrote:
I suspect 'distinct' might help you out here.
SELECT
people.*,
count(distinct cars.car_id) as car_count,
count(distinct pets.pet_id) as pet_count
--
MySQL General Mailing List
For list archives: htt
Hi all -
I have a table of PEOPLE, and a table of CARS owned by various people,
and a table of PETS owned by various people. Each person may have 0 or
more pets, and each person may have 0 or more cars. I'm trying to
return a list of all the people, showing how many pets each person
has,
Sorry if this is a n00b question, I did read the docs for mysqldump
before posting, but couldn't figure it out.
I'm successfully doing a mysqldump, but I want only a few of the
columns, and want them in a different order. Is this possible without
substantially slowing it down? The table has
I have a table of projects with several columns for the IDs of some
people in various roles, and then a table of the people. How can I get
all the people for a given project, but keep their roles straight?
Projects
--
Project_ID
Boss_ID
Admin_ID
Assistant_ID
People
ID
Name
is there a way i can traverse a directory on my server,in php and then
have the paths Be Saved as \\server1\projects\ ... etc
and actually store the filenames "NOT the files" and paths in mysql
? thanks for any help
--
MySQL General Mailing List
For list archives: http://lists.mysql.c
.* average(ratings.rating) FROM movies
INNER JOIN ratings ON movies.movie_id=ratings.movie_id
GROUP BY movies.movie_id
Change the INNER JOIN to a LEFT JOIN if you want all movies, even
those with no ratings.
Brent Baisley
On Mon, Dec 22, 2008 at 11:13 AM, Brian Dunning > wrote:
Pretend I'm Ne
Pretend I'm Netflix and I want to return a list of found movies,
including the average of related ratings for each movie. Something
like this:
select movies.*, average(ratings.rating) from movies, ratings where
movies.movie_id=ratings.movie_id
I'm sure that's wrong in about 10 different w
meals.date = '$meal_date'";
-Micah
On 09/05/2008 03:41 PM, Brian Dunning wrote:
I'm trying to calculate glycemic index of all food items eaten in a
day with a single SELECT. The problem is the calculation for
glycemic index of each item requires a total of all items&
I'm trying to calculate glycemic index of all food items eaten in a
day with a single SELECT. The problem is the calculation for glycemic
index of each item requires a total of all items' carbs. It's like a
circular reference. Here's what I'm trying:
SELECT
sum(foodi
Thanks, that was exactly what I needed. :-)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How do I query "How many calories did Brian eat on 2009-09-04"?
Table:People
+---+---+
+ Person_ID + Name |
+---+---+
| 5 | Brian |
+---+---+
Table:Meals
+-+---+---++
| Meal_ID | Person_ID | Meal_N
I have a table like this:
unique_serial - Auto Increment
field_1
field_2
field_3
The Primary key is a combination of field_1, field_2, and field_3.
I want to do:
INSERT IGNORE INTO table_name (field_1,field_2,field_3) VALUES
('xx','xx','xx')
Sometimes this will be an existing record, someti
Can someone spot a way to improve the performance of this query? I see
that every time it runs, it's "Copying to tmp table" and then
"Creating sort index" and taking way too long.
select count(distinct(stats.ip)) as popcount, stats.id, episodes.title
from stats, episodes where stats.id=epis
how can i create a tree View From a mysql table? thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thanks to everyone who replied. So simple I couldn't see it. :-)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I am an idiot. table_a and table_b have exactly the same structure.
How do I say this in SQL:
INSERT (all records from table_a) into table_b where table_a.customer
= '12'
Just trying to eventually duplicate the whole table, one customer's
set of records at a time. Thanks.
--
MySQL Gener
on the doc list, but I figured since it relates to the above
question I'd ask it here first).
Thanks in advance for the help!
--Brian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
how can i join three fields Values into one field? so in three select
boxes i have date :
Projects type 1 - 7 and project type 1 - 6 so the third Filed would
be 116200824 generated by the other three fields?
thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mys
OK, I have all my data on the new machine in a SQL file with 664,000
insert statements. But when I try to run it like this from the mysql
command line:
source filename.sql;
It starts to work, but after a few seconds the server freezes up with
"too many connections". How do I avoid this?
I have similar (not identical) tables in two different db's. I want to
merge all the data from one into the other, and will be dropping the
original. There will be some duplication of keys so some rows will
need to be ignored. Problem is these are on two different servers on
different machi
hi all :
i,m looking for a solution for my PDA that Doesn't have a DB Solution
installed on it : so im having
to write to CSV Files for my Forms , i'm needing a way that when i sink
my PDA with my wireless
network it Moves the Entire CSV File into a MySQL database :any
Suggestions :?
--
M
I have a column where I need to replace all instances of the text "US-
Complete" (contained within a long sentence) with "US Complete".
There are probably 50 or 100 of them. I'm really scared to do it
since I can't risk screwing up that column - what's the correct syntax?
--
MySQL General Ma
lets say u have a table called Parts and another called Projects ,,,
how can u associate the Parts Table with the Projects table so lets say
u wanna add a Specific Part to a project maybe even add three parts
from the parts table and associate it with a specific project ???
so maybe u would
i have a Database called Betatest in MySQL
i have three tables : Projects
ProjBom
Inventory
i wanna enter into projects the project name and date and later on i
wanna be able to add the Projectbom("bill of material
hi all
i have a pretty extensive Project Going on and it would be nice to get
some input on my tables and joins schema, i'd like to send someone my
SQL as for them to help me
thru the rough spots if they could, or i could post the enitre SQL here
for u to use, please someone respond as i woul
Many thanks to all who took the time to reply. :) :)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
...if I add a column to a table with 40,000,000 records, will it
cause that table to hang for any significant amount of time, and
prevent other transactions? It's a MyISAM table and I was going to
add a varchar(20) column, NULL. It's a very busy table, constant
searches and inserts.
--
My
ywhere. Maybe I am just not using the right
Google "query"?
Thanks in advance for any help!
-Brian Menke
so how would i get the Actual file path to the folder into the database,
i know ill have to use a file selector in asp / php but i wanna select
the folder not the Files, it would be really great if u could help me
with these issues,
i'm not asking u to Code anything for me , just links of exampl
i have a question:
i have a Projects folder on my D: drive under this folder is folder
by the name of the Customer then Subfolders that Corespond to the
Project Ex,
d:\projects
.. Jobs
LSRW
-- Rsview
--RSLogix
Thanks to everyone who answered, think I've got enough info now to
handle it. :)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
fast, since it's all self-contained
in the database software. Not having any indices on your temp
table will help too.
HTH,
Dan
On 5/2/07, Brian Dunning <[EMAIL PROTECTED]> wrote:
I have a huge MySQL table, 2.1 million records, 200MB. Once a week I
need to dump it in CSV format
I have a huge MySQL table, 2.1 million records, 200MB. Once a week I
need to dump it in CSV format and zip the file.
This is not on my server, and it's in production, so I don't want to
risk testing different methods and possibly hanging up their server
for a period of time, so I wanted to
The 'group' column needs to be quoted (use --quote-names with mysqldump).
cheers,
--bemansell
On 3/26/07, Rob Tanner <[EMAIL PROTECTED]> wrote:
Hi,
I am porting over 6 databases from a MySQL v4 installation to a MySQL v5
installation and getting an SQL error in the process.
I am using th
both cases
I'm running a single node cluster on one box (I know that's a bit
pointless but it's meant to be a proof of concept :-)). I tried the same
tests using InnoDB and got 1 Changed row in each case, and with MyISAM I
got 0 rows changed.
Can anyone confirm if they have the same problem or if it's something
I've done wrong?
Brian
Jerad -
First of all, please reply all with a SHOW CREATE TABLE of the table
you're inserting the row into, so that we can identify the indexes
you've established for the table.
thanks,
--bemansell
On 3/7/07, jerad sloan <[EMAIL PROTECTED]> wrote:
when i try to insert the string "
http://vids.
I ended up figuring this out. If anyone ever needs it, this works well
select module_id, GROUP_CONCAT(participant_answer SEPARATOR ' ') as answers
from participants_answers
where email = '[EMAIL PROTECTED]'
group by module_id
-Brian
-Original Message-
From:
experienced enough to put it all
together.
Any help is greatly appreciated, even if it's just a pointer to some mysql
docs.
Thanks in advance!
-Brian Menke
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I host at Rackspace, and one thing that their monitoring service does
NOT catch is a problem when too many connections hit MySQL, and for
some reason it remains hung up until the service is manually
restarted. In the meantime, this is happening to us once or twice a
month. It gets hammered
It sounds to me like you're needing to use a left outer join on t2.
Give that a shot instead of the inner join you're currently using.
Cheers,
-bemansell
On 2/17/07, Kerry Frater <[EMAIL PROTECTED]> wrote:
I am trying to select a particular row from a table and include a column for
aq second ta
This is totally possible...
Chris say your table is test, and the column is test_col.. use the
following, and if the number is always at the end.. and always has a
space in front of it this will work:
SELECT test_col, SUBSTRING_INDEX(test_col, '', 1) as test_col_str,
SUBSTRING_INDEX(test_col, '
)'
in the subquery: if I make it a single query and try to do a 'group
by' it always gives the same picture for each person.
On Jan 16, 2007, at 11:55 AM, Rhino wrote:
- Original Message - From: "Brian Dunning"
<[EMAIL PROTECTED]>
To: "
I can't get MySQL 5 to like this query. Can you tell what I'm trying
to do, and is there a problem with my formatting?
select account_id,picture_id from pictures where account_id in
(select account_id from accounts order by rand() limit 20)
order by rand();
--
MySQL General Mailing List
For li
On Jan 7, 2007, at 4:23 PM, TK wrote:
In short, the original inventors of the GIF format (CompuServe,
1987) have always defined the pronunciation to be like "JIF." So,
that has always been the "correct" pronunciation.
Sure, so I'll start pronouncing "graphics" as "jraphics".
--
MySQL Gen
My friend says "my sam" and "in-NOD-b". I want to kill him every
time. He also says "jif" instead of "gif".
On Jan 7, 2007, at 7:16 AM, Michael Stearne wrote:
I just say
"My, I, Sam" and "inno, d, b"
Michael
-Original Message-
From: "js " <[EMAIL PROTECTED]>
Date: Mon, 8 Jan 200
This is the query that's killing me in the slow query log, usually
taking around 20 seconds:
select count(ip) as counted,stamp from ip_addr where stamp>=NOW()-
interval 14 day and source='sometext' group by stamp order by stamp
desc;
Here is the table:
CREATE TABLE `ip_addr` (
`ip` int(
I have an issue where inserts are not being seen properly while in a SP. The
goal is to track payments made by customers, payment distribution. I narrowed
down the issue to the below, so I was able to exclude many columns and other
tables in hopes it is simple enough to get some help.
I have
I recently last week Had and experience with an Very small Company, where as
they had around 15 Machines all hooked "Star topology" and a central iis ASP
Web server that only showed the date, and a few small utilities when
addressed To it, now there entire Operation was based upon Excel,
everythin
The table structure is in my original post.
On Dec 14, 2006, at 11:49 AM, Rolando Edwards wrote:
Just change your table name and you are all set.
If you have the table structure, send it
and I'll make the query if you want.
--
MySQL General Mailing List
For list archives: http://lists.my
Can someone help me with getting a path stored in MySQL, Links ? Snips
would be great thanks a lot
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.409 / Virus Database: 268.15.20/588 - Release Date: 12/15/2006
do Edwards <[EMAIL PROTECTED]>, Brian Dunning
<[EMAIL PROTECTED]>, mysql@lists.mysql.com
Sent: Thursday, December 14, 2006 12:17:30 PM GMT-0500 US/Eastern
Subject: Re: Workaround for distinct?
On Thu, 14 Dec 2006, Chris Boget wrote:
=>>I tried this out this morning on MySQL 5.
=>
give me different random records every time:
select id,color from tablename group by color order by rand();
This should be so easy!! What's the obvious solution that I'm missing?
- Brian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscrib
Im needing to Rescurse thru a directory listing and ONLY add Directory Names
/ Path / and Filename, NOT the actual file itself, how can I do this in
MySQL,
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.409 / Virus Database: 268.15.16/582 - Release Da
I have many sites accessing one MySQL server, all using the same IP,
username, password via a PHP $connection = mysql_connect($ip,$user,
$pass);.
The server is extremely busy, hammered 24x7, but almost all traffic
is coming from one very short script. About once a day we're getting
"No dat
How can I keep a running sum of the values in rows as well as columns in a
> mysql database and display them,,
> Can someone show examples of this thanks
>
>
> Value1 12 14 34 Sum > --
> Value2 14 23 45 Sum> --
>
> Sum > -- -- --
--
No virus
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
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
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,
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:
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
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
1 - 100 of 687 matches
Mail list logo
