Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Database & SysAdmin
  3. Database
  4. Storing Bulk data

Storing Bulk data

Scheduled Pinned Locked Moved Database
question
5 Posts 4 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • M Offline
    M Offline
    muraliDarenKassi
    wrote on last edited by
    #1

    Storing some data (which includes Text,URL,image..) into a single Table. And could be assigned into separate fields. is it possible?if so,how?

    M J 2 Replies Last reply
    0
    • M muraliDarenKassi

      Storing some data (which includes Text,URL,image..) into a single Table. And could be assigned into separate fields. is it possible?if so,how?

      M Offline
      M Offline
      Mycroft Holmes
      wrote on last edited by
      #2

      Judging from your question I would suggest you get a beginners book on database and start reading as it indicates you have no idea what a database does. A column and a field are the same thing. A table on the other hand has a collection of columns which may be of different data types so you could store a row/record of data made up of the different data types. Get book and start studying!

      Never underestimate the power of human stupidity RAH

      M 1 Reply Last reply
      0
      • M Mycroft Holmes

        Judging from your question I would suggest you get a beginners book on database and start reading as it indicates you have no idea what a database does. A column and a field are the same thing. A table on the other hand has a collection of columns which may be of different data types so you could store a row/record of data made up of the different data types. Get book and start studying!

        Never underestimate the power of human stupidity RAH

        M Offline
        M Offline
        muraliDarenKassi
        wrote on last edited by
        #3

        Please omit the second part of the Question. I meant that for Front end fields.

        L 1 Reply Last reply
        0
        • M muraliDarenKassi

          Please omit the second part of the Question. I meant that for Front end fields.

          L Offline
          L Offline
          Lost User
          wrote on last edited by
          #4

          You can store everything in a single column of a single table; but then you'd be better of with storing that blob in a file, and not in a database. Every "field" should hold 1 piece of information, not more - regardless of how it is shown.

          Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

          1 Reply Last reply
          0
          • M muraliDarenKassi

            Storing some data (which includes Text,URL,image..) into a single Table. And could be assigned into separate fields. is it possible?if so,how?

            J Offline
            J Offline
            jschell
            wrote on last edited by
            #5

            Your question isn't clear. If you want to store a single 'item' without respect to the type of the item and you need to have no limit on the size then you would use a single column which has a blob (binary not character data.) If you want to keep a hint as to what type of data is in that column then you could create another string\text column which stores the name of the type like 'url', 'txt', 'img', etc.

            muraliDarenKassi wrote:

            is it possible?if so,how?

            If the above is a correct re-statement of your question then the above is also the answer.

            1 Reply Last reply
            0
            Reply
            • Reply as topic
            Log in to reply
            • Oldest to Newest
            • Newest to Oldest
            • Most Votes


            • Login

            • Don't have an account? Register

            • Login or register to search.
            • First post
              Last post
            0
            • Categories
            • Recent
            • Tags
            • Popular
            • World
            • Users
            • Groups