Hi folks
I need a MySQL statement that will calculate a new unique identifier for
each record in a table.
The identifier format is "-888" where the letters are the first four
letters of the company's name and the 3 digit number is accounts for
each occurrence of the letters.
E.G. MadMax L
Sorry Rudy
Still no luck Can't seem to figure out what's wrong.
CREATE TABLE Contact
SELECT
ContactNo,
Work_Address,
Field20,
Hi all
I am trying to adapt a query, (kindly) given by Rudy and I can't seem to
debug it.
Here is the query:
CREATE TABLE Contact
(SELECT
ContactNo,
Work_Address,
Hi
I am trying to extract two lots of information from one table but in
such a way as to maintain the relationship between the two entities.
I.E.:
Table A
ID NAME WORK HOME
^
1 Jon A null
2 TracyA n
