SitePoint Sponsor
  1. Jul 13, 2014
    Views:
    1,515
Page 1 of 684 123451151101501 ... LastLast
Threads 1 to 40 of 27344

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: What you need to do to prepare for our migration to Discourse.

    It feels like it's taken forever, but we're almost ready to flick the switch on the New SitePoint Forums on Discourse™ As I'm sure you can imagine, migrating a community the size of this one is a huge job, and one that I am scared to death of. There are a couple of things that you can do to...

    Started by HAWK, Jul 14, 2014 22:13
    3 Pages
    1 2 3
    • Replies: 54
    • Views: 9,816
    Today 09:54 Go to last post
  2. 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: 5
    • Views: 17,673
    Jul 26, 2014 03:04 Go to last post
  3. 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: 125,706
    Aug 4, 2012 08:07 Go to last post
  4. 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: 82,958
    Dec 17, 2007, 16:29 Go to last post
  5. Exclamation Sticky Thread Important: Important: Secure your SQL queries!!!

    Started by MarcusJT, May 18, 2002 05:56
    2 Pages
    1 2
    • Replies: 43
    • Views: 90,761
    Jun 30, 2012, 20:43 Go to last post
    • Replies: 13
    • Views: 51,971
    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: 55,628
    Sep 4, 2008, 17:04 Go to last post
  7. Sticky Thread Important: PostgreSQL - what are the best resources on the net?

    Started by dhtmlhelp, May 13, 2003 02:36
    • Replies: 9
    • Views: 41,271
    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,608
    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,763
    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,767
    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,234
    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,759
    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,317
    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,470
    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,463
    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,872
    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,956
    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,278
    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,423
    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,554
    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,758
    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,824
    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,623
    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,502
    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,193
    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,230
    Mar 16, 2007, 14:10 Go to last post
    • Replies: 51
    • Views: 272,082
    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,361
    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: 8,015
    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,425
    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,414
    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,617
    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,618
    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,307
    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,835
    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,446
    Oct 27, 2011, 12:16 Go to last post
    • Replies: 41
    • Views: 3,701
    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,805
    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,051
    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,333
    Aug 29, 2006, 01:45 Go to last post
    • Replies: 40
    • Views: 4,464
    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,052
    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,270
    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,541
    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,762
    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,692
    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,446
    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
  •