User Tools

Site Tools


newdevs:code:import_csv_into_db

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revisionBoth sides next revision
newdevs:code:import_csv_into_db [2023/02/27 13:30] – [Importing the Data] tlittlenewdevs: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

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
CC Attribution-Share Alike 4.0 International Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki

© 2008-2022 GPLS and others. Evergreen is open source software, freely licensed under GNU GPLv2 or later.
The Evergreen Project is a U.S. 501(c)3 non-profit organization.