[Q] Rename order table name

Hi,
I am having a problem with intergrating opencart and UPS worldship through an ODBC connection.

Basically the information required stored in table "order" is on a list of words not accepted by the UPS worldship program.

My question is: How can I rename the table "order" to "orderV2" and keep the link between database and website?

Thanks

oh boy. is manually editing more than 100 queries an option for you?

Editing 100 queries sounds like a headache.

How about replicating the table - does that sound plausible? There is documentation here:

http://dev.mysql.com/doc/refman/5.1/en/ ... e-do-table

But I am a bit sketchy when it comes to SQL...

I'm not sure if it will work. Any advice?

So I tried this:

CREATE TABLE order_V2 LIKE production.order;
INSERT order_V2 SELECT * FROM production.order;

But got this error:

#1142 - SELECT command denied to user 'xxxxxxx'@'localhost' for table 'order'

Is their an obvious reason why admin would not have correct privileges?

For anyone interested:
This is the list of words (table names) not allowes by UPS worldship in my installation at present:

language
order
user
zone


FYI - The full list of dissalowed words are:

A
ABSOLUTE
ACTION
ADA
ADD
ADMIN
AFTER
ALIAS
ALL
ALLOCATE
ALTER
AND
ANY
ARE
AS
ASC
ASSERTION
ASYNC
AT
AUTHORIZATION
AVG

B
BEFORE
BEGIN
BETWEEN
BINARY
BIT
BIT_LENGTH
BOOLEAN
BOTH
BREADTH
BY

C
CALL
CASCADE
CASCADED
CASE
CAST
CATALOG
CHAR
CHAR_LENGTH
CHARACTER
CHARACTER_LENGTH
CHECK
CLOSE
COALESCE
COBOL
COLLATE
COLLATION
COLUMN
COMMIT
COMMITTED
COMPLETION
CONNECT
CONNECTION
CONSTRAINT(S)
CONTINUE
CONVERT
CORRESPONDING
COUNT
CREATE
CROSSCURRENT
CURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_USER
CURSOR
CYCLE

D
DATA
DATE
DAY
DEALLOCATE
DEC
DECIMAL
DECLARE
DEFAULT
DEFERRABLE
DEFERREDDELETE
DEPTH
DESC
DESCRIBE
DESCRIPTOR
DIAGNOSTICS
DICTIONARY
DISCONNECT
DISPLACEMENT
DISTINCT
DOMAIN
DOUBLE
DROP

E
EACH
ELSE
ELSEIF
END
ENDEXEC
EQUALS
ESCAPE
EVENT
EXCEPT
EXCEPTION
EXEC
EXECUTE
EXISTS
EXPLAIN
EXTERNAL
EXTRACT

F
FALSE
FETCH
FIRST
FLOAT
FOR
FOREIGN
FORTRAN
FOUND
FROM
FULL

G
GENERAL
GET
GLOBAL
GO
GOTO
GRANT
GROUP

H
HAVING
HOUR

I
IDENTIFIED
IDENTITY
IF
IGNORE
IMMEDIATE
IN
INCLUDE
INDEX
INDICATOR
INITIALLY
INNER
INPUT
INSENSITIVE
INSERT
INT INTEGER
INTERSECT
INTERVAL
INTO
IS
ISOLATION

J
JOIN

K
KEY

L
LANGUAGE
LAST
LEADING
LEAVE
LEFT
LESS
LEVEL
LIKE
LIMIT
LOCAL
LOCK
LONG
LOOP
LOWER

M
MAINMEMORY
MATCH
MAX
MIN
MINUTE
MODIFY
MODULE
MONTH
MUMPS

N
NAMES
NATIONAL
NATURAL
NECHAR
NEW
NEXT
NO
NONE
NOT
NULL
NULLIF
NUMERIC

O
OBJECT
OCTET_LENGTH
OF
OFF
OID
OLD
ON
ONLY
OPEN
OPERATION
OPERATORS
OPTIMITIC
OPTION
OR
ORDER
OTHERS
OUTER
OUTPUT
OVERLAPS

P
PARAMETERS
PARTIAL
PASCAL
PENDANT
PESSIMISTIC
PLAN
PLI
POSITION
POST
PRECISION
PREORDER
PREPARE
PRESERVE
PRIMARY
PRIOR
PRIVATE
PRIVILEGES
PROCEDURE
PROTECTED
PUBLIC

Q

R
READ
REAL
RECURSIVE
REF
REFERENCES
REFERENCING
REGISTER
RELATIVE
RENAME
REPEATABLE
REPLACE
RESIGNAL
RESTRICT RETURN(S)
REVOKE
RIGHT
ROLE
ROLLBACK
ROUTINE
ROW
ROWID
ROWNUM
ROWVER
ROWS

S
SAVEPOINT
SCHEMA
SCROLL
SEARCH
SECOND
SECTION
SELECT
SENSITIVE
SEQUENCE
SERIALIZABLE
SESSION
SESSION_USER SET
SIGNAL
SIMILAR
SIZE
SMALLINT
SOME
SPACE
SQL
SQLCA
SQLCODE
SQLERROR
SQLEXCEPTION
SQLSTATE
SQLWARNING
START
STRUCTURE
SUBSTRING
SUM
SYSTEM
SYSTEM_USER

T
TABLE
TEMPORARYTEST
THENTHERE
TIME
TIMEOUT
TIMESTAMP
TIMEZONE_MINUTE
TINYINT
TO TRAILING
TRANSACTION
TRIGGER
TRIM
TRUE
TYPE

U
UNDER
UNION
UNIQUE
UNKNOWN
UNREGISTER
UPDATE
UPPER
USAGE
USER
USING

V
VALUE(S)
VARBINARY
VARCHAR
VARIABLE
VARYING
VIEW
VIRTUAL
VISIBLE

W
WAIT
WHEN
WHENEVER
WHERE
WHILE
WITH
WITHOUT
WORK
WRITE

X

Y

Z
ZONE



I have raised a service order with UPS support for them to remove the 4 table names from their dissalowed list but not crossing my fingers...