Afternoon All, hope someone can help as this is really doing my head in. I have a SQL View which has a field called MOP/T which shows the number like so 28.5140299679490 349.893390000000 349.893389892905 I want to format that field so that it only shows the number before the decimal place. for example 28 249 [...]

• 0 Comments

Hi everyone, I am having an issue with a query i am doing for an assignment, i have made an attempt but i know i have not done it right. below is the table structures: Customer: CustomerCode,[pk] CustomerName Movie: MovieCode,[pk] Name, Rating Video: VideoCode,[pk] Name, CustomerSoldTo,[fk1] MovieCode,[fk2] What i have to do is get the [...]

• 0 Comments

Hello, I am fairly new to SQL and PLSQL and am having a problem debugging some code for triggers, the compiler keeps saying that the trigger is not initialized properly. Here is a posting of the code. This is for a homework assignment, but I am lost so I would appreciate the help. These are [...]

• 0 Comments

I’m trying to use the trigger below on my database but I keep getting the error "#1235 – This version of MySQL doesn’t yet support ‘multiple triggers with the same action time and event for one table’". Could someone tell me what is wrong. DELIMITER $$ CREATE TRIGGER grade_change AFTER UPDATE on takes FOR EACH [...]

• 0 Comments