Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    Join Date
    Mar 2016
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    MySQL Structure Help!

    Hi, im very new to MySQL ( i have done some proyects but this is a special one)

    I really dont know how to implement the following:

    I have a grid of numbers 100*100 = 10000, each number is just a very small int ( it has a value from 0 to 9)

    i need to store every number to a MySQL database, but i dont know how to approach this.
    Do i have to do a table with 10000 columns?, or do i just do 2 columns and in the second one store all the data like "159875621511884...... until i have the 10000 numbers and then separate each number for its retrival? or which is the best way to do it?

    i will use C# to do this, or maybe C# => php => mySQL,

    what do you guys think?, thanks for your answers and sorry for my english (not my first language)

    MichCan

  2. #2
    Master Coder sunfighter's Avatar
    Join Date
    Jan 2011
    Location
    Washington
    Posts
    6,430
    Thanks
    30
    Thanked 878 Times in 876 Posts
    I think this will depend on how you are going to use the numbers. Tell us what you are going to do with the information.
    Evolution - The non-random survival of random variants.
    Physics is actually atoms trying to understand themselves.


 

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •