Is it possible to cut a MySQL table in half?

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Rhesus
    Confirmed User
    • Aug 2004
    • 2009
    #1

    Is it possible to cut a MySQL table in half?

    Any experts?
    Tags: None
    • s9ann0
      Confirmed User
      • Sep 2001
      • 4873
      #2
      from top to bottom or left to right ?

        Comment

        • mrthumbs
          salad tossing sig guy
          • Apr 2002
          • 11702
          #3
          delete half of the records!

            Comment

            • Mr Pheer
              So Fucking Banned
              • Dec 2002
              • 22082
              #4
              yes its possible with the MySQL table saw

                Comment

                • pornguy
                  Too lazy to set a custom title
                  • Mar 2003
                  • 62910
                  #5
                  Or you can use the MSQL Jigsaw. Hand held of course.
                  PornGuy skype me pornguy_epic

                  AmateurDough The Hottes Shemales online!
                  TChicks.com | Angeles Cid | Mariana Cordoba | MAILERS WELCOME!

                    Comment

                    • MattO
                      The O is for Oohhh
                      • Feb 2003
                      • 10861
                      #6
                      print it out and use scissors

                        Comment

                        • Matt 26z
                          So Fucking Banned
                          • Apr 2002
                          • 18481
                          #7
                          Count the number of rows. If there is 1000. Put 500 in one table and the other 500 in another.

                            Comment

                            • drama
                              Confirmed User
                              • Jul 2004
                              • 847
                              #8
                              its better to find out what your root problem is rather than start creating multiple tables but incase you're wondering you can have multiple tables which are the same and MERGE. If you're not sure what i mean by "MERGE" then you got some homework to start doing

                                Comment

                                • mikesouth
                                  Confirmed User
                                  • Jun 2003
                                  • 6337
                                  #9
                                  If your database design is correct, cutting your table in half will make it wrong. If your design is incorrect cutting it in half wont make it right

                                  determine what your real problem is first.

                                  email me if I can help
                                  Mike South

                                  It's No wonder I took up drugs and alcohol, it's the only way I could dumb myself down enough to cope with the morons in this biz.

                                    Comment

                                    • Rhesus
                                      Confirmed User
                                      • Aug 2004
                                      • 2009
                                      #10
                                      No (root) problems here. And yes, I know what merge means ;-)

                                      Of course you can just select, load into a new table and delete the old records (which is what I've done), I was just wondering if there's a set of queries to do this more easily.

                                      Thanks for the comments!

                                        Comment

                                        Previous template Next
                                        Working...