Create Unsigned Int in MySQL Database
Last post Jul 06, 2015 07:47 AM by Pengzhen Song - MSFT
Jun 24, 2015 05:58 AM|mikichi|LINK
I'm trying to store an IP addresses, according to this guide I need to create an Unsigned Int column...
How I can do that?
Jun 24, 2015 07:26 AM|jeremyh|LINK
Just add it to your table create script like
CREATE TABLE tbl_table (
ip_adrs INT UNSIGNED NOT NULL,
Jun 24, 2015 08:29 AM|mikichi|LINK
It's impossible to do it from the WebMatrix editor?
Because if I add this with query it's not appear in Definition tab.
Jun 24, 2015 09:34 AM|jeremyh|LINK
Sorry for some reason thought you where using MySQL. But for this I would just use VARCHAR.
Some back ground on this look at
Jun 24, 2015 09:52 AM|mikichi|LINK
No no. I'm using in MySQL, the picture is just sample for what I call Definition Tab... I should to clarify this...
So is there way do it in WebMatrix?
Jul 06, 2015 07:47 AM|Pengzhen Song - MSFT|LINK
I suggest that you can submit feedback in webmatrix suggestion:
Hope it can help you.