newdevs:code:import_csv_into_db
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | Next revisionBoth sides next revision | ||
newdevs:code:import_csv_into_db [2023/02/27 13:30] – [Importing the Data] tlittle | newdevs:code:import_csv_into_db [2023/02/27 13:31] – [Importing the Data] tlittle | ||
---|---|---|---|
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** to see all your new data. | + | If it's successful, you'll get the INSERT 0 [NUMBER OF ROWS] message. You can then do a **select * from [YOUR TABLE]** to see all your new data. |
newdevs/code/import_csv_into_db.txt · Last modified: 2024/06/13 10:52 by sleary