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

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: 48,560
    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,340
    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,359
    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,841
    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,292
    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,960
    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,418
    Practicality
    Dec 17, 2007, 16:29 Go to last post

  1. Online school admission system

    Started by RizwanAhmedMemon, Yesterday 22:14
    database
    • Replies: 1
    • Views: 59
    qualityprinters
    Yesterday, 23:18 Go to last post

  2. Select AVG sale price of all items carried in 'A' when sales location <> 'A'

    Started by Billiam80, Yesterday 13:14
    • Replies: 0
    • Views: 107
    Billiam80
    Yesterday, 13:14 Go to last post

  3. Very Simple Subquery Returning Strange Results

    Started by brandonBuster, Yesterday 06:48
    mysql
    • Replies: 5
    • Views: 131
    r937
    Yesterday, 13:11 Go to last post

  4. fetch the max and than if there is equal take max field

    Started by whisher, Yesterday 08:22
    • Replies: 2
    • Views: 93
    whisher
    Yesterday, 11:50 Go to last post

  5. Calculate difference of values for records on outer ends of timeframe

    Started by Hieronymus, May 21, 2013 05:38
    • Replies: 1
    • Views: 154
    Hieronymus
    May 21, 2013, 11:41 Go to last post

  6. Random Sort Order on 2nd Column?

    Started by DoubleDee, May 21, 2013 09:15
    • Replies: 2
    • Views: 132
    DoubleDee
    May 21, 2013, 09:52 Go to last post

  7. upgrading mysql v4.1 to v5

    Started by rooftop, May 21, 2013 04:17
    mysql upgrade
    • Replies: 1
    • Views: 147
    Force Flow
    May 21, 2013, 09:15 Go to last post

  8. PROBLEM WITH COMPLEX PHP MYSQL UPDATE

    Started by kcay, May 21, 2013 08:08
    ultimate 2 Attachment(s)
    • Replies: 0
    • Views: 138
    kcay
    May 21, 2013, 08:08 Go to last post

  9. Why does my while loop loop only 2 times instead of 10?

    Started by Nordy, May 20, 2013 07:58
    mysql
    • Replies: 1
    • Views: 154
    r937
    May 20, 2013, 09:35 Go to last post

  10. Converting Database From LATIN-1 to UTF-8

    Started by Panduola, May 20, 2013 09:01
    • Replies: 0
    • Views: 183
    Panduola
    May 20, 2013, 09:01 Go to last post

  11. Question INSERT SELECT statement

    Started by mickyginger, May 18, 2013 12:03
    mysql
    • Replies: 2
    • Views: 215
    mickyginger
    May 19, 2013, 06:46 Go to last post

  12. Database Content Metadata

    Started by skelleex, May 18, 2013 13:22
    • Replies: 2
    • Views: 186
    skelleex
    May 18, 2013, 17:30 Go to last post

  13. AVG returning NULL - temporal values?

    Started by auth1, May 18, 2013 07:36
    • Replies: 1
    • Views: 166
    r937
    May 18, 2013, 08:09 Go to last post

  14. Select Employee with no attendance

    Started by newphpcoder, May 14, 2013 17:48
    • Replies: 9
    • Views: 330
    guido2004
    May 16, 2013, 23:42 Go to last post

  15. Updating the same table for date.

    Started by firblazer, May 16, 2013 21:07
    • Replies: 2
    • Views: 151
    firblazer
    May 16, 2013, 23:13 Go to last post

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

    Started by atoroqo, Apr 29, 2013 04:41
    • Replies: 6
    • Views: 343
    wwb_99
    May 16, 2013, 11:52 Go to last post

  17. Date interval

    Started by Miguel61, May 16, 2013 07:06
    • Replies: 0
    • Views: 124
    Miguel61
    May 16, 2013, 07:06 Go to last post

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

    Started by atoroqo, Apr 9, 2013 11:37
    • Replies: 22
    • Views: 1,120
    atoroqo
    May 16, 2013, 03:28 Go to last post

  19. Angry [Access 2000/JET SQL] "Join Expression Not Supported" Help with this query??

    Started by jesusw00t, May 15, 2013 16:51
    • Replies: 1
    • Views: 192
    r937
    May 15, 2013, 19:23 Go to last post

  20. Proper normalization for media with multiple types of owners

    Started by JeremyC, May 14, 2013 08:18
    • Replies: 6
    • Views: 303
    r937
    May 15, 2013, 19:17 Go to last post

  21. Question How to connect remotely to mysql

    Started by silversurfer5150, May 14, 2013 02:48
    • Replies: 3
    • Views: 184
    Doug G
    May 14, 2013, 17:16 Go to last post

  22. A question about SQL

    Started by JohnoLFC, May 13, 2013 06:58
    • Replies: 3
    • Views: 311
    JohnoLFC
    May 14, 2013, 02:01 Go to last post

  23. date range logic in PL/SQL loop

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

  24. data in mySQL column

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

  25. Choosing Text-Field Size

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

  26. Can you use Unique Indexed Fields for Joins?

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

  27. Problem Displaying ntilde using MySQLi form

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

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

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

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

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

  30. Sorting questions (MySQL)

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

  31. How to optimize this query

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

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

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

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

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

  34. Crashed mysql tables - data loss?

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

  35. Fulltext index for single-word columns

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

  36. Retrieve hierarchy from a table like this

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

  37. SQL Join Problem

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

  38. MYSQL DATE COMPARISON

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

  39. MSYQL STR_TO_DATE

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

  40. Local database testing

    Started by Banana Man, May 3, 2013 10:05
    • Replies: 1
    • Views: 253
    DaveMaxwell
    May 3, 2013, 10:24 Go to last post
Page 1 of 670 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