MYSQL table
#3

Create a table called 'guns' and run this query...

PHP код:
ALTER TABLE guns ADD charid INT(12); 
ALTER TABLE guns ADD gunid INT(12AFTER charid;
ALTER TABLE guns ADD ammo INT(12AFTER gunid;
ALTER TABLE guns ADD slot INT(12AFTER ammo
Quote:
Originally Posted by webby
Посмотреть сообщение
You enter in PHPMyAdmin, select the database, at the bottom you will have a category „create table” - https://gyazo.com/727c94aba5e7d9271529db52807533ab, enter the table name „guns” and 4 columns.

And then - https://gyazo.com/b936f4557d52a863bb7391a445274955
The integer values should be longer than five. Also, it's much more useful to show him how to write and execute queries than showing him how to create columns and tables via the user interface.
Reply


Messages In This Thread
MYSQL table - by Puff - 01.09.2017, 16:51
Re: MYSQL table - by webby - 01.09.2017, 16:55
Re: MYSQL table - by Luke_James - 01.09.2017, 16:56
Re: MYSQL table - by Puff - 01.09.2017, 17:03
Re: MYSQL table - by Vince - 01.09.2017, 17:09
Re: MYSQL table - by Puff - 01.09.2017, 17:13
Re: MYSQL table - by Banditul18 - 01.09.2017, 17:34
Re: MYSQL table - by Luke_James - 01.09.2017, 17:48
Re: MYSQL table - by Vince - 01.09.2017, 17:59

Forum Jump:


Users browsing this thread: 2 Guest(s)