We are excited to announce that the IIS.NET Forums are moving to the new Microsoft Q&A experience. Learn more >

Create Unsigned Int in MySQL DatabaseRSS

5 replies

Last post Jul 06, 2015 07:47 AM by Pengzhen Song - MSFT

  • Create Unsigned Int in MySQL Database

    Jun 24, 2015 05:58 AM|mikichi|LINK

    Hi,

    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?

    Bests

    Michael

  • Re: Create Unsigned Int in MySQL Database

    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, 
    
    ); 

    Regards
    Jeremy
    If this has helped Please: Don't forget to click "Mark as Answer" on the post that helped you.
    That way future readers will know which post solved your issue.
  • Re: Create Unsigned Int in MySQL Database

    Jun 24, 2015 08:29 AM|mikichi|LINK

    Thank you,

    It's impossible to do it from the WebMatrix editor?

    Because if I add this with query it's not appear in Definition tab.

  • Re: Create Unsigned Int in MySQL Database

    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 http://stackoverflow.com/questions/1385552/datatype-for-storing-ip-address-in-sql-server

    Regards
    Jeremy
    If this has helped Please: Don't forget to click "Mark as Answer" on the post that helped you.
    That way future readers will know which post solved your issue.
  • Re: Create Unsigned Int in MySQL Database

    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?

  • Re: Create Unsigned Int in MySQL Database

    Jul 06, 2015 07:47 AM|Pengzhen Song - MSFT|LINK

    Hi,

    I suggest that you can submit feedback in webmatrix suggestion:

    https://webmatrix.uservoice.com/forums/128313-webmatrix-suggestions

    Hope it can help you.

    We are trying to better understand customer views on social support experience. Click HERE to participate the survey.
    Thanks!