×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Glenn Gundermann wrote:
When I omit the user and time stamp columns, I get a message saying
the number of values don't match.
CRPence wrote:
<snip>
When the columns are omitted on the insert, the default will be
established for each row inserted in those omitted columns.
Elvis & Charles already clarified separately so this is mostly
redundant... for the archive to clarify my specific example.
I should have clarified in my original response, that to /omit/ the
columns required the /specify column list for insert/ as shown in the
code example that was given:
insert into tofile (a, b) -- specify column list for insert
(select F.* from fromfile F -- F.* is column list (a, b)
where ... )
In that example, the /tofile/ table has four columns, two more than
named in the column list (a,b) for the insert. The full column list for
the /tofile/ table is the four columns (a,b,createdby,createdat). Since
only the first two fields (a,b) are named on the insert, the last two
fields (createdby,createdat) are therefore /omitted on the insert/.
Regards, Chuck
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
