newdevs:code:import_csv_into_db
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
newdevs:code:import_csv_into_db [2023/02/27 13:28] – [Finessing the Data Prior to Import] tlittle | newdevs:code:import_csv_into_db [2023/02/27 13:31] – [Importing the Data] tlittle | ||
---|---|---|---|
Line 40: | Line 40: | ||
< | < | ||
- | Then if you do a select * from tlittle.acqprolist you'll see it's now populated with the data from our CSV file. | + | Then if you do a **select * from tlittle.acqprolist** you'll see it's now populated with the data from our CSV file. |
5. To get that data into our Evergreen table, we need to copy it over. | 5. To get that data into our Evergreen table, we need to copy it over. | ||
Line 60: | Line 60: | ||
So the second half is the SELECT--select all these from tlittle.acqprolist--which we then INSERT with the first portion. | So the second half is the SELECT--select all these from tlittle.acqprolist--which we then INSERT with the first portion. | ||
- | If it's successful, you'll get the INSERT 0 [NUMBER OF ROWS] message. You can then do a select * from acq.provider | + | If it's successful, you'll get the INSERT 0 [NUMBER OF ROWS] message. You can then do a **select * from [YOUR TABLE]** |
newdevs/code/import_csv_into_db.txt · Last modified: 2024/06/13 10:52 by sleary