Re: Vignesh, please don't hijack threads
Posted by:
Jam Su
Date: October 08, 2020 11:36AM
Hi Peter,
I am also using Ver 8.0.21
I am not creating the tables, they already exist, however, here are the data types of the columns, hopefully that provides you with the information you are looking for?
p.num = varchar(70)
p.description = varchar(252)
po.num = varchar(25)
po.dateCreated = datetime(6)
poi.qtyToFulfill = decimal(28,9)
Please let me know if there is any other data you require.
Thank you,
Full Error posted below -
Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(PARTITION BY p.num) 'NUM' FROM part p LEFT JOIN poitem poi ON poi.partid = p' at line 7
Subject
Views
Written By
Posted
246
September 14, 2020 04:08PM
115
September 14, 2020 04:11PM
92
September 14, 2020 04:49PM
102
October 07, 2020 08:18PM
85
October 08, 2020 11:22AM
70
October 08, 2020 11:28AM
Re: Vignesh, please don't hijack threads
72
October 08, 2020 11:36AM
64
October 09, 2020 08:10AM
66
October 09, 2020 09:11AM
66
October 09, 2020 11:21AM
57
October 09, 2020 11:59AM
73
October 08, 2020 08:57PM
83
October 08, 2020 09:25AM
Sorry, only registered users may post in this forum.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.