SitePoint Sponsor
  1. Announcement:
    Is everything in your Database an error?
    Mittineague (Programming Team)
    Mar 7, 2013
    Views:
    351
Page 64 of 671 FirstFirst ... 145460616263646566676874114164564 ... LastLast
Threads 2521 to 2560 of 26823

Forum: Databases & MySQL

Using a database such as MySQL, Oracle or SQLite to store your website's data? Learn about common issues and pitfalls, the correct use of indexes, normalisation and much more.

  1. Global Thread Global: Important: How Tos to make forum use easier

    Wondering how to add a mention, quote more than one person at a time, or report a post? This thread will help you learn all the little things that make SitePoint a fun and easy forum. The thread is closed for comments, but if you have any questions on how to do something that isn't covered here,...

    Started by Shyflower, Aug 2, 2012 08:36
    3 Attachment(s)
    • Replies: 7
    • Views: 51,991
    Shyflower
    Aug 4, 2012 08:07 Go to last post

  2. Sticky Thread Important: Do you know where the (database) error is? Add it to the list!

    Started by molona, Mar 4, 2013 12:57
    • Replies: 7
    • Views: 7,287
    Antnee
    Apr 22, 2013, 04:12 Go to last post

  3. Exclamation Sticky Thread Important: Important: Secure your SQL queries!!!

    Started by MarcusJT, May 18, 2002 05:56
    2 Pages •
    1 2
    • Replies: 43
    • Views: 63,239
    Darkwind
    Jun 30, 2012, 20:43 Go to last post

  4. Sticky Thread Important: PostgreSQL - what are the best resources on the net?

    Started by dhtmlhelp, May 13, 2003 02:36
    • Replies: 7
    • Views: 27,329
    someidiot
    Apr 17, 2011, 16:10 Go to last post

  5. Sticky Thread Important: the big, bad thread of "MySQL Best Practices and Other Useful Information"

    Started by longneck, Jul 29, 2006 14:32
    • Replies: 13
    • Views: 35,889
    guido2004
    Jan 23, 2011, 14:46 Go to last post

  6. Exclamation Sticky Thread Important: Database design & normalization resources

    Started by MarcusJT, Jun 12, 2002 08:39
    • Replies: 12
    • Views: 40,458
    r937
    Sep 4, 2008, 17:04 Go to last post

  7. Sticky Thread Important: SQL and RDBMS Database Design DO's and DON'Ts

    Started by MattR, Jul 2, 2002 05:27
    2 Pages •
    1 2
    • Replies: 44
    • Views: 55,445
    Practicality
    Dec 17, 2007, 16:29 Go to last post

  1. Question Possible to select result set as a comma delimited list?

    Started by Darren884, Jan 21, 2011 13:22
    • Replies: 8
    • Views: 1,941
    r937
    Jan 21, 2011, 18:20 Go to last post

  2. Question WP-MU-Multi-Site breaks at

    Started by site4, Jan 21, 2011 14:46
    mysql database
    • Replies: 1
    • Views: 864
    felgall
    Jan 21, 2011, 17:11 Go to last post

  3. Store ID's in each row or use Json ?

    Started by PowerStrike, Jan 20, 2011 15:01
    • Replies: 5
    • Views: 1,140
    wwb_99
    Jan 21, 2011, 14:21 Go to last post

  4. Determining most matches in multiple search

    Started by prince_mallow, Jan 20, 2011 11:00
    • Replies: 2
    • Views: 478
    prince_mallow
    Jan 21, 2011, 10:18 Go to last post

  5. Improving this slow SELECT query

    Started by sxtrail, Oct 15, 2010 07:43
    • Replies: 7
    • Views: 914
    r937
    Jan 21, 2011, 06:40 Go to last post

  6. Data Clear Unsuccessful?

    Started by Antnee, Jan 21, 2011 03:19
    • Replies: 4
    • Views: 503
    Antnee
    Jan 21, 2011, 04:29 Go to last post

  7. Working with a column of data type 'SET'

    Started by ramasaig, Jan 14, 2011 03:41
    • Replies: 7
    • Views: 641
    ramasaig
    Jan 21, 2011, 03:12 Go to last post

  8. Question mysql shows error ""ERROR 1064 (42000):""

    Started by rakeshvijayan, Jan 20, 2011 23:29
    • Replies: 0
    • Views: 3,095
    rakeshvijayan
    Jan 20, 2011, 23:29 Go to last post

  9. ordering within IN clause

    Started by proxi, Jan 19, 2011 16:58
    • Replies: 22
    • Views: 893
    proxi
    Jan 20, 2011, 22:12 Go to last post

  10. Need help with Database Terms/Concepts

    Started by DoubleDee, Jan 13, 2011 17:42
    • Replies: 11
    • Views: 1,234
    DoubleDee
    Jan 20, 2011, 21:07 Go to last post

  11. How to build index in MYSQL

    Started by hm9, Jan 18, 2011 14:14
    • Replies: 6
    • Views: 628
    furicane
    Jan 20, 2011, 15:56 Go to last post

  12. Adjacency list table to Nested Set table conversion algorithm?

    Started by Kadence, Nov 24, 2005 09:04
    • Replies: 9
    • Views: 3,211
    Zinger_Der_GOD
    Jan 20, 2011, 11:53 Go to last post

  13. Import excel file into mysql

    Started by ragy, Jan 19, 2011 05:41
    • Replies: 3
    • Views: 1,085
    prince_mallow
    Jan 20, 2011, 11:11 Go to last post

  14. Stuck on Joins?

    Started by coxdabd, Jan 20, 2011 05:32
    • Replies: 6
    • Views: 531
    guelphdad
    Jan 20, 2011, 09:38 Go to last post

  15. Combining 3 records & grouping by price

    Started by donboe, Jan 20, 2011 02:18
    • Replies: 1
    • Views: 443
    r937
    Jan 20, 2011, 03:59 Go to last post

  16. Sub Query - Need Help with Scope

    Started by JeffWalden, Jan 19, 2011 15:07
    • Replies: 3
    • Views: 900
    guido2004
    Jan 19, 2011, 15:32 Go to last post

  17. What is the point of a self-ref table ?

    Started by fwycruiser118, Jan 18, 2011 20:59
    • Replies: 2
    • Views: 574
    fwycruiser118
    Jan 19, 2011, 15:28 Go to last post

  18. What seems like a very silly "AND" SQL error

    Started by ripcurlksm, Jan 19, 2011 14:52
    1 Attachment(s)
    • Replies: 2
    • Views: 498
    ripcurlksm
    Jan 19, 2011, 15:12 Go to last post

  19. Selecting only fields from a row that are not blank

    Started by ramasaig, Jan 19, 2011 12:53
    • Replies: 3
    • Views: 477
    r937
    Jan 19, 2011, 14:12 Go to last post

  20. which mysql server to download??

    Started by sagar2911, Jan 16, 2011 10:59
    • Replies: 5
    • Views: 649
    mwasif
    Jan 19, 2011, 14:06 Go to last post

  21. Only return one from 1 to many join

    Started by boxhead, Jan 18, 2011 05:44
    • Replies: 6
    • Views: 946
    oddz
    Jan 19, 2011, 12:37 Go to last post

  22. Ajax to display a database as list?

    Started by twb01, Jan 18, 2011 13:08
    • Replies: 1
    • Views: 1,244
    dantel
    Jan 18, 2011, 22:59 Go to last post

  23. One or two tables

    Started by donboe, Jan 17, 2011 10:24
    • Replies: 3
    • Views: 550
    donboe
    Jan 18, 2011, 06:53 Go to last post

  24. Date range query behaviour on different MySQL versions

    Started by EasyCo, Jan 17, 2011 18:36
    • Replies: 1
    • Views: 436
    EasyCo
    Jan 17, 2011, 19:12 Go to last post

  25. Suggestions for multiple databases on multiple servers?

    Started by rustybuddy, Jan 17, 2011 10:13
    • Replies: 1
    • Views: 470
    furicane
    Jan 17, 2011, 12:44 Go to last post

  26. MySQL Mac Help

    Started by Cod3r, Jan 17, 2011 12:32
    mysql server
    • Replies: 0
    • Views: 469
    Cod3r
    Jan 17, 2011, 12:32 Go to last post

  27. Ordering by multiple columns

    Started by Zaggs, Jan 17, 2011 10:41
    • Replies: 2
    • Views: 482
    Zaggs
    Jan 17, 2011, 10:50 Go to last post

  28. Question getting the SUM of 2 fields and subtracting

    Started by dannylewin, Jan 17, 2011 07:24
    mysql
    • Replies: 1
    • Views: 535
    r937
    Jan 17, 2011, 07:35 Go to last post

  29. return entire row where a value = max(value)

    Started by SirDaveTheBrave, Jan 17, 2011 05:55
    • Replies: 2
    • Views: 536
    SirDaveTheBrave
    Jan 17, 2011, 07:30 Go to last post

  30. Dynamic database design

    Started by yukimushu, Jan 15, 2011 18:01
    • Replies: 7
    • Views: 1,608
    yukimushu
    Jan 16, 2011, 18:00 Go to last post

  31. MySQL Size and Optimisation Question

    Started by flipfilter, Jan 15, 2011 05:09
    mysql database
    • Replies: 6
    • Views: 666
    furicane
    Jan 16, 2011, 14:57 Go to last post

  32. Change ENUM Values

    Started by DoubleDee, Jan 16, 2011 01:33
    • Replies: 4
    • Views: 1,583
    DoubleDee
    Jan 16, 2011, 12:23 Go to last post

  33. Question Combining two SELECT results

    Started by Forbes, Jan 15, 2011 15:51
    • Replies: 4
    • Views: 580
    Forbes
    Jan 16, 2011, 05:41 Go to last post

  34. Add 7 days to a date variable

    Started by ro1960, Jan 16, 2011 04:41
    • Replies: 2
    • Views: 796
    ro1960
    Jan 16, 2011, 05:33 Go to last post

  35. MySQL timestamp doesn't match system time

    Started by lgarciaac, Jan 16, 2011 05:12
    timestamp
    • Replies: 0
    • Views: 743
    lgarciaac
    Jan 16, 2011, 05:12 Go to last post

  36. date search within 2 dates

    Started by prithvi.web, Jan 14, 2011 09:37
    • Replies: 10
    • Views: 591
    prithvi.web
    Jan 15, 2011, 17:28 Go to last post

  37. Stored procedure question

    Started by IBazz, Jan 15, 2011 11:57
    • Replies: 2
    • Views: 452
    r937
    Jan 15, 2011, 12:45 Go to last post

  38. db admin question

    Started by IBazz, Jan 15, 2011 11:52
    • Replies: 3
    • Views: 415
    IBazz
    Jan 15, 2011, 12:05 Go to last post

  39. TSQL - Using Case Else statements in where clause

    Started by addstravel, Jan 15, 2011 10:02
    • Replies: 8
    • Views: 3,905
    addstravel
    Jan 15, 2011, 11:10 Go to last post

  40. Index and Explain

    Started by jaswinder_rana, Jan 14, 2011 14:53
    • Replies: 8
    • Views: 579
    jaswinder_rana
    Jan 15, 2011, 10:52 Go to last post
Page 64 of 671 FirstFirst ... 145460616263646566676874114164564 ... LastLast

Forum Information and Options

Moderators of this Forum

Thread Display Options

Use this control to limit the display of threads to those newer than the specified time frame.

Allows you to choose the data by which the thread list will be sorted.

Order threads in...

Note: when sorting by date, 'descending order' will show the newest results first.

Icon Legend

Contains unread posts
Contains unread posts
Contains no unread posts
Contains no unread posts
More than 25 replies or 300 views
Hot thread with unread posts
More than 25 replies or 300 views
Hot thread with no unread posts
Closed Thread
Thread is closed
Thread Contains a Message Written By You
You have posted in 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
  •  

Forum Rules