: Assistance with trigger
Hi All
I am hoping this email finds all well.
I would like to request some assistance with a MySQL trigger please.
We need to implement a trigger that will in short terms make a backup of a
row before it gets deleted.
so we have tableA and TableB (backup table
Hi All
I am hoping this email finds all well.
I would like to request some assistance with a MySQL trigger please.
We need to implement a trigger that will in short terms make a backup of a
row before it gets deleted.
so we have tableA and TableB (backup table).
I added a
Hi gang,
I am looking for someone that I can pay a few hours to work with me on coming
up with a few needed QUERIES for a large mysql database. The queries will span
across tables, so I great knowledge of JOINS will most likely be necessary. We
will work using SKYPE and GoToMeeting.
Please con
gt;
>
>
> On 12/11/12 13:04, Machiel Richards - Gmail wrote:
>
>> Hi Guys
>>
>> We need some assistance with a master slave setup we are
>> experiencing some issues with.
>>
>> We have one master with 2 slaves replicating from it.
Hi Michael,
Is your binary log running on the slaves?
I have the same issue when forgotten enabling log_bin on SLAVE host
Thanks,
Igor
On 12/11/12 13:04, Machiel Richards - Gmail wrote:
Hi Guys
We need some assistance with a master slave setup we are
experiencing some issues with
On Mon, Nov 12, 2012 at 5:21 AM, Machiel Richards - Gmail
wrote:
> 1. the fact that the slaves say "seconds behind master = 0" does not
> neccesarily mean that repliication is working as I have found this a lot of
> times where it shows 0 then have proven that replication was not working
>
2012/11/12 Machiel Richards - Gmail
> Hi Manuel
>
> Please take careful note of what I have stated in the original
> mail.
>
> 1. the fact that the slaves say "seconds behind master = 0" does
> not neccesarily mean that repliication is working as I have found this a
> lot of time
2012/11/12 Machiel Richards - Gmail <mailto:machiel.richa...@gmail.com>>
Hi Guys
We need some assistance with a master slave setup we are
experiencing some issues with.
We have one master with 2 slaves replicating from it.
Both the sla
2012/11/12 Machiel Richards - Gmail
> Hi Guys
>
> We need some assistance with a master slave setup we are
> experiencing some issues with.
>
> We have one master with 2 slaves replicating from it.
>
> Both the slaves stopped working this morni
Hi Guys
We need some assistance with a master slave setup we are
experiencing some issues with.
We have one master with 2 slaves replicating from it.
Both the slaves stopped working this morning in the early hours
at exactly the same bin_log file and position
On 2012-05-21 11:17 AM, Don Wieland wrote:
I have got this query that returns the correct rows I want to display,
BUT the columns dr_ther_qty, dr_not_ther_qty, and dr_all_ther_qty are
not calculating correctly:
--- START QUERY ONE ---
SELECT q1.* FROM
(SELECT apt.user_id, apt.client_id, c.l
I have got this query that returns the correct rows I want to display,
BUT the columns dr_ther_qty, dr_not_ther_qty, and dr_all_ther_qty are
not calculating correctly:
--- START QUERY ONE ---
SELECT q1.* FROM
(SELECT apt.user_id, apt.client_id, c.last_name, c.first_name,
MIN(apt.time_sta
This is the general list. If your problem is with MySQL and queries, let us
know.
Best regards.
--
WB
2010/11/29 Daniel P. Brown
> On Mon, Nov 29, 2010 at 14:35, Don Wieland
> wrote:
> > Hi all,
> >
> > Is there a list/form to get some help on compiling mySQL queries? I am
> > executing them
On Mon, Nov 29, 2010 at 14:35, Don Wieland wrote:
> Hi all,
>
> Is there a list/form to get some help on compiling mySQL queries? I am
> executing them via PHP, but do not want to ask for help here if it is no the
> appropriate forum. Thanks ;-)
Yes.
For MySQL queries, write to the MySQL
Hi all,
I have a query that is not quite producing what I expected:
select
n.nid,
n.title,
DATE_FORMAT(FROM_UNIXTIME(n.created), '%c/%e/%Y') as created,
c.field_product_price_value as price,
d.name,
t.tid,
v.value AS vote_average
from
node n
left join node_revi
A message in the MySQL log file asserts that someone at this e-mail
address may be able to assist in troubleshooting/diagnosing a chronic
error we encounter during our nightly database dumps.
Here is an excerpt of the log file (near the reference to your e-mail
address):
InnoDB: Error: semaphore
seconds to run
- obviously not quick enough for web use.
What I really need is the most recent comment from each group based
on a variable set of gid's that change from user to user.
Any thoughts on how to tweak this to avoid the full table scan? Thank
you in advance for your assistance.
Erik Gi
;
> What I really need is the most recent comment from each group based
> on a variable set of gid's that change from user to user.
>
> Any thoughts on how to tweak this to avoid the full table scan? Thank
> you in advance for your assistance.
>
> Erik Giberti
>
>
>
gt; > 9 | NULL | 58 | Using where; Using index |
> > +++---+---+---+-
> > +-+--+--+--+
> >
> > Running the query on a production machine with sufficient memory and
>
--+--+--+
>
> Running the query on a production machine with sufficient memory and
> horsepower (box is only 20% utilized) it still takes 3 seconds to run
> - obviously not quick enough for web use.
>
> What I really need is the most recent comment from ea
is to avoid the full table scan? Thank
you in advance for your assistance.
Erik Giberti
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Greetings Rob,
>
> What is the optimum way to structure the database to allow for the
> simplest user search?
> Is it more efficient to store images and large documents in their
> respective format on disc and the URL in the database or as blob objects?
Most of the times, especially for read-o
Hi All,
I have been using MySQL for some time in a basic and simple manner to
retain prompt information and data for my multilingual websites.
My new project is however a much larger matter.
The site is a repository for advertisements advertising vehicles. This
includes land sea and air vehic
d i want to get to know more about
the
> >software angle of IT.
> >I need assistance on how to develop my skills from the basics in using
> SQL and oracle which will improve my credentials in the IT industry.
> >i will appreciate your kind assistance.
>
> chizoba
> a
dear sir,
>i am an IT engineer but i have a specialization in network, internet
>service & hardware. presently i hv setup my WISP company and i am now
free to pursue other endeavours, and i want to get to know more about the
>software angle of IT.
>I need assistance on how to d
dear sir,
>i am an IT engineer but i have a specialization in network, internet
>service & hardware. presently i hv setup my WISP company and i am now
free
>to pursue other endeavours, and i want to get to know more about the
>software angle of IT.
>I need assistance on how t
Hi scott,
you can use datetime or timestamp. Using timestamp in this example shows you
that now() can be a default or inserted value. You can also use
current_tiumestamp.
Other functions like date_add can help you to look for rows verifying interval
days like in this example :
mysql> create table
Hi Scott,
I show you timestamp usage, but there is also datetime and date. you can read
detailled infos at :
http://dev.mysql.com/doc/mysql/en/datetime.html
mysql> create table items(itemRef varchar(10), dat timestamp default
current_timestamp);
Query OK, 0 rows affected (0.20 sec)
mysql>
mysql>
Hello,
I would like to do the following: I am creating a site where people can add
items to a cart. In order to keep items for [X] amount of days, I would like to
create a database table in mysql to hold a 'itemRef' and a 'Date'. Then in a
relationship table I can hold the 'itemRef' and 'items'
"Scott Purcell" <[EMAIL PROTECTED]> wrote on 05/13/2005 12:05:05 PM:
> Hello,
> I am accustomed to Oracle query syntax, and I am having trouble with
> this following query which uses the IN. I am running mysql ( Ver 12.
> 21 Distrib 4.0.15, for Win95/Win98 (i32) ) which does not support the
IN.
>
Sorry, mysql doesn't support sub queries until version 4.1
-Eric
Scott Purcell wrote:
Hello,
I am accustomed to Oracle query syntax, and I am having trouble with this
following query which uses the IN. I am running mysql ( Ver 12.21 Distrib
4.0.15, for Win95/Win98 (i32) ) which does not support t
Hello,
I am accustomed to Oracle query syntax, and I am having trouble with this
following query which uses the IN. I am running mysql ( Ver 12.21 Distrib
4.0.15, for Win95/Win98 (i32) ) which does not support the IN.
How do I rewrite the below query to function?
Basically what I have is three
-Original Message-
From: Richard Whitney [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 15, 2005 10:54 AM
To: Jay Blanchard
Subject: RE: SELECT assistance
Quoting Jay Blanchard <[EMAIL PROTECTED]>:
> [snip]
> I have a table containing three columns:
>
> Int
[snip]
I have a table containing three columns:
Int intint
++-++
| id | serialbegin | serialend |
++-++
| 1 | 10 | 20 |
++-++
And say we have serial number 11.
Is there a way
I have a table containing three columns:
Int intint
++-++
| id | serialbegin | serialend |
++-++
| 1 | 10 | 20 |
++-++
And say we have serial number 11.
Is there a way to SELE
A friend of mine, who is not a member of the MySQL email aliases, is working toward
her Bachelors degree. She is currently taking a database design course. She mentioned
her current assignment to me and I suggested she allow me to forward this request to
this email alias. I understand this is no
Eve,
Best to keep threads on the list. Others may have better ideas, and future
readers may benefit.
The comparison
candidate.Location IN ('CA', 'California')
will match 'CA' and 'California', but will not match 'Cupertino, CA' because
it isn't either of those strings. To match that row as w
Eve,
From your earlier post, I see it should be
resume.Candidate_ID = candidate.Candidate_ID
===
I should also point out that there are several problems with your Location
matching. You have
candidate.Location LIKE '%CA%' OR 'California'
First, this evaluates as
(candidate.Location
Hi Eve,
You have made a very common mistake while using the "comma-join" method. I
think if I translate your implicit inner join to an explicit inner join
you will spot your own mistake:
SELECT resume.Section_Value, candidate.Location
FROM resume
INNER JOIN candidate
WHERE resume.Section_ID
You have a cartesian join because you do not have join criteria between the
resume and candidate tables.
-Original Message-
From: Eve Atley
To: [EMAIL PROTECTED]
Sent: 8/17/04 12:22 PM
Subject: Assistance with SQL syntax: pulling duplicates back
I think this is an easy question...I&#x
You are joining two tables, resume and candidate. Without a join condition,
you get a Cartesian product, each row of the first table paired with each
and every row of the second table. (Some on this list would go so far as to
say that's not even a join.) You need to specify how rows in resume
I think this is an easy question...I've set up a SQL statement like so:
SELECT resume.Section_Value, candidate.Location FROM resume, candidate WHERE
resume.Section_ID = '1' AND MATCH (resume.Section_Value) AGAINST ('html')
AND candidate.Location LIKE '%CA%' OR 'California'
--
And
* Michael Collins
> Using the latest MySQL 4.
>
> I could use some help on performing a join but not retrieving all the
> records of the child table. I have a set of tables, the ones involved
> in this are related as follows:
>
> members (one) -< (many) orders (one) -< (many) orderitems
>
> The end
Using the latest MySQL 4.
I could use some help on performing a join but not retrieving all the
records of the child table. I have a set of tables, the ones involved
in this are related as follows:
members (one) -< (many) orders (one) -< (many) orderitems
The end result should be a list of ord
oisy
Sent: Thursday, November 13, 2003 2:01 PM
To: MYSQL-List (E-mail)
Subject: SELECT Query assistance please
I have two tables EVENT and PROJECTCODE
EVENT.ID
EVENT.ID_PROJECTCODE
PROJECTCODE.ID
PROJECTCODE.Name
EVENT PROJECTCODE
ID = 1 ID_PROJECTCODE = 0
I have two tables EVENT and PROJECTCODE
EVENT.ID
EVENT.ID_PROJECTCODE
PROJECTCODE.ID
PROJECTCODE.Name
EVENT PROJECTCODE
ID = 1 ID_PROJECTCODE = 0 ID = 1
ID = 2 ID_PROJECTCODE = 0 ID = 2
ID = 3 ID_PROJECTCODE = 1 ID = 3
Assistance required.
I have 3 tables:
TABLE: client_invoice
- client_id *1(show all from client_invoice, only those w/ info from client_info)
- invoice_amount
- invoice_date_due
TABLE: client_info
- client_id*1(show all from client_invoice, only those w/ info from
I have 2 tables similar to
T1
---
ID | initial |
T2
--
initial | full_name |
I want output based on the T1.ID row which has a given ID=' X '
(If ID = 7 then pretend initial = initial3, as example)
The first or l
Hello,
I have noticed that my server running mysql-3.23.45 on Solaris 8/400MHz
sparc/1GB ram system appears to be only using up swap space and not free
memory. During light usage this doesn't seem to be a problem but under
heavy usage this causes my cpu to hit 90 - 100% at times. Even with
n
W am looking for some expert assistance using MySQL & PHP on a Linux/Apache
based internet site development project.
The project shouldn't take a knowledgeable & experienced professional long
so you should be able to work it in your schedule without stopping
everything forever
Paul,
Friday, August 16, 2002, 1:19:15 AM, you wrote:
PM> I have a column defined in a table as type date. I desire to include a date
PM> comparison in the WHERE clause of the following statement. The following
PM> statement is not working correctly, I suspect that there is a formatting
PM> issue
describe user.
Paul Maine wrote:
>I have a column defined in a table as type date. I desire to include a date
>comparison in the WHERE clause of the following statement. The following
>statement is not working correctly, I suspect that there is a formatting
>issue. The statement returns true eve
I have a column defined in a table as type date. I desire to include a date
comparison in the WHERE clause of the following statement. The following
statement is not working correctly, I suspect that there is a formatting
issue. The statement returns true even if USER.elig_date has an earlier date
Jon,
This is exactly what was needed. You are correct in that we're using the
mysql
To: "Gerald Clark" <[EMAIL PROTECTED]>; "Corey Wallis"
<[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, July 27, 2002 8:16 AM
Subject: RE: Fw: Complex S
Peoples,
I'm currently trying to work out if this is possible by SQL. I have the need
to use SQL and only SQL to achieve the following.
If a record exists and meets a certain criteria (i.e. field X = '1234') then
update the record. If the record doesn't exist then insert it.
For reasons too com
Take a look at REPLACE:
http://www.mysql.com/doc/R/E/REPLACE.html
On Fri, 2002-07-26 at 10:17, Corey Wallis wrote:
> Peoples,
>
> I'm currently trying to work out if this is possible by SQL. I have the need
> to use SQL and only SQL to achieve the following.
>
> If a record exists and meets a c
> SQL does not exist in a vacuum.
> You have to run a client.
> The client is part of or runs under some scripting language ( perl ,
> php, sh, command.com )
> which in turn runs on an operating system.
> You have to somehow pass values that you want to select, update,
> or insert.
> So it really
SQL does not exist in a vacuum.
You have to run a client.
The client is part of or runs under some scripting language ( perl ,
php, sh, command.com )
which in turn runs on an operating system.
You have to somehow pass values that you want to select, update, or insert.
So it really not possible to
On Fri, 2002-07-26 at 05:17, Corey Wallis wrote:
> Peoples,
>
> I'm currently trying to work out if this is possible by SQL. I have the need
> to use SQL and only SQL to achieve the following.
>
> If a record exists and meets a certain criteria (i.e. field X = '1234') then
> update the record.
Check the mySQL REPLACE syntax... that's what you need.
-Message d'origine-
De : Corey Wallis [mailto:[EMAIL PROTECTED]]
Envoyé : vendredi 26 juillet 2002 11:17
À : [EMAIL PROTECTED]
Objet : Fw: Complex SQL assistance
Peoples,
I'm currently trying to work out if this
m: "Robert L. Yelvington" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: need SQL assistance with a few selects
Date: Fri, 3 May 2002 09:24:02 -0500
Greetings folks,
I am able to do all this by pulling out data with PHP or PERL...just need
some straight MySQL comma
[snip]
2. The date of max disksize and the date of min disksize...in one query...if
that's possible.
[/snip]
mysql> select RunDate,
-> MAX(IF(ClientName = 'ABC INC', DiskSize, '')) AS ABC,
-> MAX(IF(ClientName = 'Eat at Joe', DiskSize, '')) AS Joe,
-> MAX(IF(ClientName = 'The Hop', Di
[snip]
1. An average disksize for each client, date doesn't matter.
The result I'd like to see would be something like:
"ABC INC","1.8"
"Joe's Restaurant","1.2"
[/snip]
mysql> SELECT CLIENT_NAME, AVG(DISK_SIZE) AS Average, MIN(DISK_SIZE) AS
Minimum, MAX(DISK_SIZE) AS Maximum
-> from table <--
Greetings folks,
I am able to do all this by pulling out data with PHP or PERL...just need
some straight MySQL command line advise
Specifically, I need some assistance with the following:
Here's my table's structure (table name is 'table'):
ID, CLIENT_NAME, CLI
On Wed, 30 Jan 2002, Marjolein Katsma wrote:
> Date: Wed, 30 Jan 2002 12:33:29 +0100
> From: Marjolein Katsma <[EMAIL PROTECTED]>
> To: MySQL <[EMAIL PROTECTED]>
> Subject: RE: Urgent Business Assistance.
>
>
> At 03:52 2002-01-30, Todd Williamsen wrote:
>
country with the money before the angry survivors get hold of you and
their money... That might work Happy to help ...
-Original Message-
From: Engr.Martin Douglas. [mailto:[EMAIL PROTECTED]]
Sent: 30 January 2002 01:31
To: [EMAIL PROTECTED]
Subject: Urgent Business Assistance.
Urgent
requiring
maximum confidence.
We are top officials of the Federal Government Contract Review Panel
who are interested
in importation of goods into our
country with funds which are presently trapped in Nigeria. In order to
commence this
business we solicit your assistance to
enable us
On Wed, 30 Jan 2002, Engr.Martin Douglas. wrote:
> Urgent Business Asistance.
>
> Engr.Martin Douglas.
Ok.. I'm about to slamdunk a few phrases into my procmail filters.
However, is there any way mere mortals on this list can get the full
headers?
(sql,mysql,database)
-
requiring
maximum confidence.
We are top officials of the Federal Government Contract Review Panel
who are interested
in importation of goods into our
country with funds which are presently trapped in Nigeria. In order to
commence this
business we solicit your assistance to
enable us
At 03:52 2002-01-30, Todd Williamsen wrote:
>If its so urgent and private then why are you spamming a mail list? I
>smell scam, or is that Spam?
It's both.
And please do not quote the *whole* spam - the loss of bandwidth (it goes to every
subscriber!) from the actual spam is already bad enoug
If its so urgent and private then why are you spamming a mail list? I
smell scam, or is that Spam?
-Original Message-
From: Engr. Martin Douglas. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 30, 2002 2:28 AM
To: [EMAIL PROTECTED]
Subject: Urgent Business Assistance.
Urgent
requiring
maximum confidence.
We are top officials of the Federal Government Contract Review Panel
who are interested
in importation of goods into our
country with funds which are presently trapped in Nigeria. In order to
commence this
business we solicit your assistance to
enable us
transaction
requiring
maximum confidence.
We are top officials of the Federal Government Contract Review Panel
who are interested
in importation of goods into our
country with funds which are presently trapped in Nigeria. In order to
commence this
business we solicit your assistance to
enable us
Yes it is so easy.. You just need to use table joins..
Check out:
http://www.mysql.com/doc/J/O/JOIN.html
Gurhan
-Original Message-
From: Torkil Johnsen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 29, 2002 3:50 PM
To: [EMAIL PROTECTED]
Subject: Need some easy "select"
> Given this example:
> table CARS
> has got an entity "Labourghini" with car_id=5
> table NEWS
> has got an entity "Lambourghini displays new super model" with
> date=2002-05-02, news_id=735 and car_id=5
> I want this output:
> NEWS HEADLINES
> : ()
> Can I do this without 2 select queries?
I
At 09:50 PM 1/29/2002 +0100, Torkil Johnsen wrote:
>Given this example:
>
>table CARS
>has got an entity "Labourghini" with car_id=5
>
>table NEWS
>has got an entity "Lambourghini displays new super model" with
>date=2002-05-02, news_id=735 and car_id=5
>
>Now:
>
>I want this output:
>
>NEWS HEADL
Given this example:
table CARS
has got an entity "Labourghini" with car_id=5
table NEWS
has got an entity "Lambourghini displays new super model" with
date=2002-05-02, news_id=735 and car_id=5
Now:
I want this output:
NEWS HEADLINES
: ()
Can I do this without 2 select queries?
As of now, I
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 12, 2001 8:14 PM
> To: [EMAIL PROTECTED]
> Subject: Urgent Assistance
>
>
> Hi group,
>
> I am in need of assistance with a database and php query we
Hi group,
I am in need of assistance with a database and php query we are trying to
achieve.
Basically we are have a form where one field searches a field in the mysql
database and the other searches for keywords using the MATCH query.
What we need to do is for the user to be able to enter a
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
database,sql,query
If you just reply to this message, and include the entire text of it in the
reply, your rep
>Dear Sir or Madam,
>
>Re: Installation MySQL version 3.23.22-beta.
>
>I am awfully sorry to bother you with some basics. I am a novice.
>I am trying to use the above on my PC which is running on Windows
>98. In WinMySQLAdmin, my.ini set up appears complete. I have
>looked at the starting tu
- Original Message -
From: "René Tegel" <[EMAIL PROTECTED]>
To: "Thomas Morton" <[EMAIL PROTECTED]>
Sent: Sunday, March 11, 2001 8:42 PM
Subject: Re: May I ask for your assistance?
> Thomas,
>
> as far as i know, i didn't notice _any_ diff
Dear Sir or Madam,
Re: Installation MySQL version 3.23.22-beta.
I am awfully sorry to bother you with some basics. I am a novice. I am trying to use
the above on my PC which is running on Windows 98. In WinMySQLAdmin, my.ini set up
appears complete. I have looked at the starting tutorial
Just because you send a message doesn't mean it's gonna get answered!!
Have you successfully installed a non alpha version of the db?
On 31 Jan 2001 11:09:33 -0500, Sanam Azeem wrote:
> I sent this email two days ago and haven't heard from anyone
>
> >Date: Mon, 29 Jan 2001 14:51:30 -0500
I don't know if this is a solution, but you could try using the latest stable
source code 3.23.32 and see if it fixed the problem.
> >We're installing Mysql source mysql-3.23.8-alpha on AIX 4.3.3.0. We were
> >able to run configure without a problem but have problem once make is run,
> >we rec
I sent this email two days ago and haven't heard from anyone
>Date: Mon, 29 Jan 2001 14:51:30 -0500
>To: [EMAIL PROTECTED]
>From: Sanam Azeem <[EMAIL PROTECTED]>
>Subject: Error during make...
>
>Hello,
>
>We're installing Mysql source mysql-3.23.8-alpha on AIX 4.3.3.0. We were
>able to run
86 matches
Mail list logo
