Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
INSERT INTO |
Tue, Nov 24 2009 12:27 AM | Permanent Link |
Scott Woods | I want to do a simple insert into SQL statement that creates a new record, but I dont want to specify any field values.
So for example INSERT INTO Customers And thats it. When I run the above I get an error... I dont want to specify any values as I have an ID field that will be generated automatically. Is there a way to do this? |
Tue, Nov 24 2009 2:50 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Scott
How about inserting a null to any one of the fields? Roy Lambert [Team Elevate] |
Tue, Nov 24 2009 3:24 AM | Permanent Link |
Uli Becker | Scott
> I dont want to specify any values as I have an ID field that will be generated automatically. Is there a way to do this? insert into MyTable(ID) values (null) should work. Uli |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |