Using the query ALTER
#3

Quote:
Originally Posted by 10MIN
Посмотреть сообщение
Use:
PHP код:
ALTER TABLE NameOfTable
DROP COLUMN NameOfColumnToBeDeleted

PS: If you need any other information about MySQL, you can get it here: MySQL 5.7 Reference Manual
I am doing this on SQLite as I cannot use MySQL at the moment, using a shitty PC.

PHP код:
db_query(Database"ALTER TABLE `users` DROP COLUMN `test`;"); 
Returns a SQL Debug error

Код:
[Warning] db_query: Query failed: near "DROP": syntax error
Reply


Messages In This Thread
Using the query ALTER - by JaKe Elite - 17.08.2017, 13:24
Re: Using the query ALTER - by 10MIN - 17.08.2017, 13:41
Re: Using the query ALTER - by JaKe Elite - 17.08.2017, 13:48
Re: Using the query ALTER - by GoldenLion - 17.08.2017, 13:54
Re: Using the query ALTER - by JaKe Elite - 17.08.2017, 13:55
Re: Using the query ALTER - by Vince - 17.08.2017, 13:55

Forum Jump:


Users browsing this thread: 1 Guest(s)