SitePoint Sponsor
Page 1 of 684 123451151101501 ... LastLast
Threads 1 to 40 of 27327

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.

Forum: Databases & MySQL

  1. Global Thread Global: Important: This Week in JavaScript - General Service Announcement

    Hello all, I'm happy to announce that "This Week in JavaScript" has become "On Our Radar" and has (for the foreseeable future at least) moved from the JavaScript forum to SitePoint's main site. You can find the first edition here: http://www.sitepoint.com/week-web-swift-bitcoin/ The posts...

    Started by Pullo, Jun 17, 2014 04:11
    • Replies: 4
    • Views: 5,508
    Jun 30, 2014 00:21 Go to last post
  2. 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...

    Started by Shyflower, Aug 2, 2012 08:36
    • Replies: 7
    • Views: 109,959
    Aug 4, 2012 08:07 Go to last post
  3. 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: 75,531
    Dec 17, 2007, 16:29 Go to last post
  4. Exclamation Sticky Thread Important: Important: Secure your SQL queries!!!

    Started by MarcusJT, May 18, 2002 05:56
    2 Pages
    1 2
    • Replies: 43
    • Views: 83,202
    Jun 30, 2012, 20:43 Go to last post
    • Replies: 13
    • Views: 47,703
    Jan 23, 2011, 14:46 Go to last post
  5. Exclamation Sticky Thread Important: Database design & normalization resources

    Started by MarcusJT, Jun 12, 2002 08:39
    • Replies: 12
    • Views: 51,706
    Sep 4, 2008, 17:04 Go to last post
  6. Sticky Thread Important: PostgreSQL - what are the best resources on the net?

    Started by dhtmlhelp, May 13, 2003 02:36
    • Replies: 9
    • Views: 37,779
    Sep 15, 2013, 10:35 Go to last post
  1. The Merits of Joins

    Started by KodeKrash, Feb 7, 2002 12:45
    4 Pages
    1 2 3 4
    • Replies: 88
    • Views: 8,586
    Dec 19, 2002, 13:24 Go to last post
  2. Poll Poll: Why not save images in SQL Database?

    Started by Floezen, Apr 14, 2004 08:24
    4 Pages
    1 2 3 4
    • Replies: 86
    • Views: 22,665
    Jul 13, 2004, 07:13 Go to last post
  3. Computing attendance hours

    Started by newphpcoder, Oct 23, 2011 19:23
    4 Pages
    1 2 3 4
    • Replies: 86
    • Views: 6,721
    Nov 22, 2011, 18:55 Go to last post
  4. What type of relation is this scenario?

    Started by co.ador, Apr 16, 2011 16:51
    4 Pages
    1 2 3 4
    • Replies: 80
    • Views: 4,169
    Apr 28, 2011, 05:50 Go to last post
  5. How scalable is MS Access?

    Started by cydewaze, Jul 9, 2009 13:31
    4 Pages
    1 2 3 4
    • Replies: 78
    • Views: 11,600
    Jul 15, 2009, 17:38 Go to last post
  6. database driven websites page chapter4

    Started by bail, Mar 21, 2010 10:53
    3 Pages
    1 2 3
    • Replies: 66
    • Views: 8,179
    Apr 19, 2010, 07:06 Go to last post
  7. SQL Looping Query

    Started by bumpyride, May 19, 2006 10:41
    3 Pages
    1 2 3
    • Replies: 63
    • Views: 3,459
    Jun 10, 2006, 18:18 Go to last post
  8. Database structure and potential queries

    Started by creole, Feb 13, 2002 17:37
    3 Pages
    1 2 3
    • Replies: 62
    • Views: 7,153
    Mar 6, 2002, 09:11 Go to last post
  9. Angry Multiple Cyclical Cascade Paths Error

    Started by aaron.martone, Sep 22, 2010 10:53
    3 Pages
    1 2 3
    • Replies: 61
    • Views: 5,805
    Oct 1, 2010, 05:54 Go to last post
  10. The sum of the recent m1Bs or m2Bs

    Started by dotJoon, Dec 3, 2009 07:37
    3 Pages
    1 2 3
    • Replies: 61
    • Views: 3,892
    Dec 7, 2009, 13:03 Go to last post
  11. Question repeated values, how to best handle

    Started by pata, Jun 28, 2010 09:24
    3 Pages
    1 2 3
    • Replies: 60
    • Views: 5,254
    Jan 6, 2011, 03:44 Go to last post
  12. Whats the point in using InnoDB?

    Started by PeterB89, Mar 7, 2007 08:15
    3 Pages
    1 2 3
    • Replies: 60
    • Views: 8,412
    Mar 21, 2007, 10:25 Go to last post
  13. highest point group that a member makes

    Started by dotJoon, Jul 1, 2006 18:38
    3 Pages
    1 2 3
    • Replies: 59
    • Views: 2,541
    Jul 5, 2006, 02:03 Go to last post
  14. Database design query for Golf statistics site

    Started by daddyg, Dec 8, 2004 15:09
    3 Pages
    1 2 3
    • Replies: 57
    • Views: 6,683
    Feb 16, 2005, 20:20 Go to last post
  15. Selecting data from a query

    Started by Caduceus, Feb 6, 2007 15:13
    3 Pages
    1 2 3
    • Replies: 56
    • Views: 3,816
    Feb 21, 2007, 07:41 Go to last post
  16. Question Group similar results, listing users

    Started by Forbes, Feb 22, 2011 16:58
    3 Pages
    1 2 3
    • Replies: 56
    • Views: 3,557
    Mar 2, 2011, 05:35 Go to last post
  17. SQL Server Vs. MySQL - need to make a decision

    Started by matt_12511, May 11, 2004 08:54
    3 Pages
    1 2 3
    • Replies: 54
    • Views: 14,381
    Jun 4, 2004, 17:57 Go to last post
  18. Unknown table in where clause? Quick question

    Started by computerbarry, Jun 2, 2008 09:58
    3 Pages
    1 2 3
    • Replies: 53
    • Views: 4,180
    Jun 8, 2008, 17:45 Go to last post
  19. Index vs Primary Key

    Started by afridy, Mar 13, 2007 12:42
    3 Pages
    1 2 3
    • Replies: 52
    • Views: 3,220
    Mar 16, 2007, 14:10 Go to last post
    • Replies: 51
    • Views: 270,539
    Jul 11, 2012, 03:08 Go to last post
  20. Poll Poll: How do YOU pronounce SQL?

    Started by Googly, Dec 22, 2004 05:45
    3 Pages
    1 2 3
    • Replies: 50
    • Views: 7,313
    Oct 21, 2005, 22:39 Go to last post
  21. Mysql keep restarting

    Started by newtomysql, Feb 15, 2011 23:07
    2 Pages
    1 2
    • Replies: 47
    • Views: 7,740
    Feb 23, 2011, 14:37 Go to last post
  22. Proposed Database Design - is it suitable????

    Started by JATaylor, Dec 15, 2008 05:48
    2 Pages
    1 2
    • Replies: 46
    • Views: 4,403
    Dec 22, 2008, 09:16 Go to last post
  23. How to create a relation between mysql two tables?

    Started by Freejoy, Dec 15, 2010 16:17
    2 Pages
    1 2
    • Replies: 46
    • Views: 11,321
    Dec 19, 2010, 00:53 Go to last post
  24. Want to use LIMIT but its not appropriate for my needs

    Started by multichild, May 29, 2013 03:42
    2 Pages
    1 2
    • Replies: 46
    • Views: 3,233
    Jun 5, 2013, 05:03 Go to last post
  25. Limiting no of records retrieved in Oracle

    Started by Si, Feb 11, 2004 03:26
    2 Pages
    1 2
    • Replies: 45
    • Views: 4,611
    Feb 24, 2004, 13:27 Go to last post
  26. Smile SUBSTRING_INDEX () - Any other way?

    Started by manoloka, Jan 25, 2007 14:53
    2 Pages
    1 2
    • Replies: 44
    • Views: 3,269
    Feb 3, 2007, 08:48 Go to last post
  27. Different Duplicate Issue

    Started by tgavin, Jan 1, 2009 19:36
    2 Pages
    1 2
    • Replies: 43
    • Views: 2,779
    Jan 5, 2009, 12:58 Go to last post
  28. Tough conceptual issue

    Started by ServerStorm, Oct 25, 2011 10:38
    2 Pages
    1 2
    • Replies: 42
    • Views: 3,403
    Oct 27, 2011, 12:16 Go to last post
    • Replies: 41
    • Views: 3,629
    Mar 10, 2006, 13:31 Go to last post
  29. Best database structure for this example

    Started by D3V4, Oct 16, 2010 13:57
    2 Pages
    1 2
    • Replies: 41
    • Views: 4,796
    Oct 26, 2010, 09:05 Go to last post
  30. Trying to Avoid Using Query inside While Loop

    Started by WeakestLink, Jul 9, 2006 10:11
    2 Pages
    1 2
    • Replies: 40
    • Views: 3,014
    Jul 26, 2006, 03:45 Go to last post
  31. Lightbulb Replication SQL SERVER 2000

    Started by borna, Aug 7, 2006 01:51
    2 Pages
    1 2
    • Replies: 40
    • Views: 6,277
    Aug 29, 2006, 01:45 Go to last post
    • Replies: 40
    • Views: 4,436
    Mar 24, 2007, 10:18 Go to last post
  32. Showing player's best game

    Started by Melter, May 14, 2009 06:37
    2 Pages
    1 2
    • Replies: 39
    • Views: 3,030
    May 19, 2009, 07:43 Go to last post
  33. Can anyone suggest a reason why I may want an ID field???

    Started by MatthewBOnline, Apr 12, 2011 06:30
    2 Pages
    1 2
    • Replies: 39
    • Views: 8,239
    May 15, 2011, 13:19 Go to last post
  34. Question MsSQL and Nulls...

    Started by Ostoski, May 4, 2005 09:51
    2 Pages
    1 2
    • Replies: 38
    • Views: 4,518
    May 6, 2005, 10:23 Go to last post
  35. Why MySQL ?

    Started by afrika, Jun 22, 2005 01:07
    2 Pages
    1 2
    • Replies: 38
    • Views: 1,757
    Jun 24, 2005, 08:06 Go to last post
  36. Joining 5 tables

    Started by cronsrcs, Nov 5, 2006 10:18
    2 Pages
    1 2
    • Replies: 38
    • Views: 2,686
    Nov 7, 2006, 14:09 Go to last post
  37. Arranging Date information

    Started by barney0o0, Oct 2, 2007 08:31
    2 Pages
    1 2
    • Replies: 38
    • Views: 4,410
    Oct 8, 2007, 07:41 Go to last post

 

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
  •