SitePoint Sponsor
  1. Announcement:
    Is everything in your Database an error?
    Mittineague (Programming Team)
    Mar 7, 2013
    Views:
    271
Page 1 of 669 123451151101501 ... LastLast
Threads 1 to 40 of 26752

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: 47,214
    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: 6,033
    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: 62,128
    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: 26,740
    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,154
    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: 39,861
    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: 54,206
    Practicality
    Dec 17, 2007, 16:29 Go to last post

  1. A question about SQL

    Started by JohnoLFC, Today 06:58
    • Replies: 0
    • Views: 134
    JohnoLFC
    Today, 06:58 Go to last post

  2. date range logic in PL/SQL loop

    Started by devil_vin, May 11, 2013 09:19
    • Replies: 1
    • Views: 105
    guido2004
    Today, 04:43 Go to last post

  3. data in mySQL column

    Started by Marvin_G, May 10, 2013 12:05
    • Replies: 11
    • Views: 209
    ScallioXTX
    Yesterday, 23:17 Go to last post

  4. Selecting one through many in a many-to-many relationship

    Started by atoroqo, Apr 9, 2013 11:37
    • Replies: 21
    • Views: 860
    r937
    Yesterday, 15:46 Go to last post

  5. Choosing Text-Field Size

    Started by DoubleDee, May 11, 2013 07:42
    • Replies: 3
    • Views: 123
    r937
    May 11, 2013, 10:48 Go to last post

  6. Query for searching in multiple tables – UNION or not?

    Started by atoroqo, Apr 29, 2013 04:41
    • Replies: 5
    • Views: 246
    atoroqo
    May 11, 2013, 09:11 Go to last post

  7. Can you use Unique Indexed Fields for Joins?

    Started by DoubleDee, May 10, 2013 11:01
    • Replies: 6
    • Views: 183
    DoubleDee
    May 10, 2013, 19:24 Go to last post

  8. Problem Displaying ntilde using MySQLi form

    Started by RGStephens, May 10, 2013 07:39
    • Replies: 0
    • Views: 132
    RGStephens
    May 10, 2013, 07:39 Go to last post

  9. Need help writing an SQL to pull my order coupons

    Started by nickmccally, May 9, 2013 15:17
    • Replies: 1
    • Views: 140
    guido2004
    May 10, 2013, 00:02 Go to last post

  10. #1064 - You have an error in your SQL syntax

    Started by StevenHu, May 9, 2013 13:41
    • Replies: 3
    • Views: 131
    StevenHu
    May 9, 2013, 13:54 Go to last post

  11. Sorting questions (MySQL)

    Started by atoroqo, May 8, 2013 13:08
    • Replies: 4
    • Views: 178
    atoroqo
    May 9, 2013, 04:59 Go to last post

  12. How to optimize this query

    Started by vaskarbasak, May 9, 2013 04:41
    • Replies: 0
    • Views: 93
    vaskarbasak
    May 9, 2013, 04:41 Go to last post

  13. How to create MySQL database with php for visitor comments, registration, profile pg

    Started by hiya, May 4, 2013 19:40
    • Replies: 5
    • Views: 355
    felgall
    May 8, 2013, 15:26 Go to last post

  14. What data type should be used for an phone number?

    Started by StevenHu, May 8, 2013 14:17
    • Replies: 4
    • Views: 160
    StevenHu
    May 8, 2013, 15:16 Go to last post

  15. Crashed mysql tables - data loss?

    Started by Jon Lawrance, Apr 30, 2013 11:00
    • Replies: 3
    • Views: 335
    Jon Lawrance
    May 8, 2013, 05:54 Go to last post

  16. Fulltext index for single-word columns

    Started by atoroqo, May 8, 2013 00:28
    • Replies: 0
    • Views: 151
    atoroqo
    May 8, 2013, 00:28 Go to last post

  17. Retrieve hierarchy from a table like this

    Started by Nordy, May 7, 2013 02:41
    mysql
    • Replies: 5
    • Views: 211
    guido2004
    May 7, 2013, 03:56 Go to last post

  18. SQL Join Problem

    Started by francisnrb, May 7, 2013 00:49
    • Replies: 9
    • Views: 176
    guido2004
    May 7, 2013, 02:43 Go to last post

  19. MYSQL DATE COMPARISON

    Started by afridy, May 4, 2013 00:19
    • Replies: 9
    • Views: 253
    r937
    May 4, 2013, 06:09 Go to last post

  20. MSYQL STR_TO_DATE

    Started by afridy, May 2, 2013 04:16
    • Replies: 4
    • Views: 295
    afridy
    May 4, 2013, 00:00 Go to last post

  21. Local database testing

    Started by Banana Man, May 3, 2013 10:05
    • Replies: 1
    • Views: 192
    DaveMaxwell
    May 3, 2013, 10:24 Go to last post

  22. Cost of MySQL Indexes?

    Started by DoubleDee, May 1, 2013 18:12
    • Replies: 4
    • Views: 304
    r937
    May 2, 2013, 03:12 Go to last post

  23. A front-end dev turns software dev. Learning curve?

    Started by justinwhall, May 1, 2013 13:23
    • Replies: 1
    • Views: 279
    r937
    May 1, 2013, 14:12 Go to last post

  24. Query to display 4th option (not specified)

    Started by bcalagoure, May 1, 2013 07:17
    • Replies: 7
    • Views: 255
    bcalagoure
    May 1, 2013, 07:52 Go to last post

  25. Creating database problem

    Started by lancewatson08, Apr 30, 2013 14:05
    • Replies: 1
    • Views: 297
    r937
    Apr 30, 2013, 15:46 Go to last post

  26. What Keys to use for Many-to-Many-to-Many?

    Started by DoubleDee, Apr 29, 2013 16:31
    • Replies: 4
    • Views: 282
    DoubleDee
    Apr 29, 2013, 19:18 Go to last post

  27. Is there a way to put a if statement within the where close??

    Started by robin01, Apr 28, 2013 12:06
    • Replies: 5
    • Views: 312
    r937
    Apr 29, 2013, 12:29 Go to last post

  28. Why this query won't work?

    Started by solidcodes, Apr 29, 2013 07:31
    • Replies: 3
    • Views: 309
    solidcodes
    Apr 29, 2013, 08:09 Go to last post

  29. Major problem - Need serious help :(

    Started by Zany90, Apr 17, 2013 17:31
    • Replies: 1
    • Views: 400
    wongck50
    Apr 27, 2013, 23:55 Go to last post

  30. Omitting in-between dates

    Started by tgavin, Apr 27, 2013 10:27
    • Replies: 4
    • Views: 280
    tgavin
    Apr 27, 2013, 11:10 Go to last post

  31. error 1044

    Started by mavra, Apr 18, 2013 03:54
    • Replies: 2
    • Views: 383
    Rubble
    Apr 25, 2013, 07:25 Go to last post

  32. get avg time on site by age ranges

    Started by whisher, Apr 24, 2013 01:20
    • Replies: 2
    • Views: 287
    whisher
    Apr 24, 2013, 11:42 Go to last post

  33. get avg time on site by gender

    Started by whisher, Apr 24, 2013 00:49
    • Replies: 2
    • Views: 242
    whisher
    Apr 24, 2013, 05:22 Go to last post

  34. Returning two lists from one query

    Started by cydewaze, Apr 23, 2013 07:15
    • Replies: 8
    • Views: 370
    cydewaze
    Apr 23, 2013, 14:59 Go to last post

  35. The right way to use group by

    Started by whisher, Apr 22, 2013 12:54
    • Replies: 5
    • Views: 632
    r937
    Apr 23, 2013, 02:57 Go to last post

  36. Get user number group by age range and gender

    Started by whisher, Apr 22, 2013 10:09
    • Replies: 5
    • Views: 552
    DaveMaxwell
    Apr 22, 2013, 12:17 Go to last post

  37. PHPmyadmin, unable to insert, edit, inline edit

    Started by robin01, Apr 20, 2013 11:06
    • Replies: 2
    • Views: 340
    robin01
    Apr 21, 2013, 06:45 Go to last post

  38. Select first token of value

    Started by cydewaze, Apr 19, 2013 10:26
    • Replies: 4
    • Views: 329
    cydewaze
    Apr 19, 2013, 12:31 Go to last post

  39. Question Does a Clustered Index involving a Date/Time ever make sense?

    Started by cpradio, Apr 19, 2013 06:51
    • Replies: 9
    • Views: 348
    r937
    Apr 19, 2013, 11:35 Go to last post

  40. Get proportional value for a value for a pie chart

    Started by whisher, Apr 19, 2013 00:23
    • Replies: 5
    • Views: 326
    whisher
    Apr 19, 2013, 10:47 Go to last post
Page 1 of 669 123451151101501 ... 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