[DiscordArchive] hey guys total noob, what's the easiest method to remove a column from an sql query? it's 22000 line
[DiscordArchive] hey guys total noob, what's the easiest method to remove a column from an sql query? it's 22000 line
Original source
hey guys total noob, what's the easiest method to remove a column from an sql query? it's 22000 lines and about 66 colums but i only need 4 of the columns to put into a new query for a diff table?
rektbyfaith
08-24-2024, 08:04 PM #1Archived author: The Canadian Kid • Posted: 2024-08-24T20:04:33.933000+00:00
Original source
hey guys total noob, what's the easiest method to remove a column from an sql query? it's 22000 lines and about 66 colums but i only need 4 of the columns to put into a new query for a diff table?
Original source
probably by creating a temporary table with the columns and data you need
rektbyfaith
08-24-2024, 08:19 PM #2Archived author: Kitzunu • Posted: 2024-08-24T20:19:21.572000+00:00
Original source
probably by creating a temporary table with the columns and data you need
Original source
yeah i ended up creating a table copy with no data, rerun the sql query, omitted and renamed the colums copied that and rerun the query after changing the table name, did it all in heidisql
rektbyfaith
08-24-2024, 08:31 PM #3Archived author: The Canadian Kid • Posted: 2024-08-24T20:31:35.540000+00:00
Original source
yeah i ended up creating a table copy with no data, rerun the sql query, omitted and renamed the colums copied that and rerun the query after changing the table name, did it all in heidisql
1 Guest(s)
1 Guest(s)