Hi everyone, I am pretty new to SQL and I would like to know how can I add a prefix or postfix to all records in one field. Example: I want to add "PK-" before all barcodes in my database.

• 0 Comments

Im just learning how to do triggers in mysql with php I have two versions of the trigger i would like to use but i keep getting errors saying the syntax is wrong. the first one is: CREATE TRIGGER credits_earned AFTER UPDATE ON takes on (grade) REFERENCING NEW ROW AS nrow REFERENCING OLD ROW AS [...]

• 0 Comments

Hello everyone – first time poster here, long time reader. I have a minor issue that appear to simple to fix – but I’ve just hit a road block. I would like to create a three way inner join to display all the information I need in one SQL statement. Let me describe the issue. [...]

• 0 Comments

Hi all, In a table column, I have this address value: "Muehlgasse 1 86637 Wertingen GERMANY" I want to get only the GERMANY part on my SELECT code. I’ve tested this code: SELECT right(‘Muehlgasse 1 86637 Wertingen GERMANY’,7) It works, but the ’7′ has to be calculated, because we have other countries, too. Any idea?? [...]

• 0 Comments