SitePoint Sponsor
  1. Announcement:
    Is everything in your Database an error?
    Mittineague (Programming Team)
    Mar 7, 2013
    Views:
    273
Page 5 of 669 FirstFirst 1234567891555105505 ... LastLast
Threads 161 to 200 of 26753

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,260
    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,047
    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,141
    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,746
    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,161
    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,868
    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,214
    Practicality
    Dec 17, 2007, 16:29 Go to last post

  1. Question Cross table update case query

    Started by mickyginger, Feb 16, 2013 17:26
    mysql query
    • Replies: 1
    • Views: 378
    mickyginger
    Feb 16, 2013, 17:33 Go to last post

  2. Question Unknown column in 'on clause' in Multiple Joins

    Started by hiddenpearls, Feb 16, 2013 01:13
    mysql join
    • Replies: 2
    • Views: 372
    hiddenpearls
    Feb 16, 2013, 15:54 Go to last post

  3. Convert string to datetime

    Started by cms9651, Feb 16, 2013 10:05
    • Replies: 2
    • Views: 318
    cms9651
    Feb 16, 2013, 11:36 Go to last post

  4. Tackling a table with duplicates using LIMIT

    Started by busboy, Feb 8, 2013 23:23
    • Replies: 2
    • Views: 510
    busboy
    Feb 15, 2013, 09:49 Go to last post

  5. Reducing a field's size

    Started by wonshikee, Feb 14, 2013 19:03
    • Replies: 1
    • Views: 378
    gelabz
    Feb 14, 2013, 22:48 Go to last post

  6. How to run phpmyadmin on 2 different web servers

    Started by Fati Kom, Feb 14, 2013 21:02
    • Replies: 0
    • Views: 345
    Fati Kom
    Feb 14, 2013, 21:02 Go to last post

  7. Select GROUP BY sums AND individual lines in one query?

    Started by CreedFeed, Feb 14, 2013 08:26
    • Replies: 9
    • Views: 497
    CreedFeed
    Feb 14, 2013, 11:38 Go to last post

  8. Post count function

    Started by jemz, Jan 21, 2013 04:36
    • Replies: 16
    • Views: 829
    jemz
    Feb 14, 2013, 04:40 Go to last post

  9. Results of an online poll

    Started by cms9651, Feb 10, 2013 03:30
    • Replies: 6
    • Views: 495
    cms9651
    Feb 13, 2013, 11:47 Go to last post

  10. Slow query

    Started by HighFlyerPL185, Jan 30, 2013 14:10
    2 Attachment(s)
    • Replies: 14
    • Views: 999
    HighFlyerPL185
    Feb 13, 2013, 11:24 Go to last post

  11. What code to use for visitor comments

    Started by hiya, Feb 12, 2013 13:29
    visitor comments
    • Replies: 1
    • Views: 383
    K. Wolfe
    Feb 13, 2013, 09:50 Go to last post

  12. how to find the updated value from the mysql table

    Started by samiuddin.adse, Feb 11, 2013 02:07
    • Replies: 7
    • Views: 587
    rajeev13
    Feb 12, 2013, 22:31 Go to last post

  13. [Err] 1111 - Invalid use of group function

    Started by cms9651, Feb 12, 2013 08:37
    • Replies: 6
    • Views: 493
    cms9651
    Feb 12, 2013, 13:14 Go to last post

  14. table design issue

    Started by windowsxp, Feb 6, 2013 05:18
    • Replies: 2
    • Views: 546
    rajeev13
    Feb 11, 2013, 01:13 Go to last post

  15. Strange issue with front-end of site not populating new database entries from backend

    Started by Copyright1977, Feb 7, 2013 16:22
    1 Attachment(s)
    • Replies: 6
    • Views: 813
    Copyright1977
    Feb 8, 2013, 13:59 Go to last post

  16. The TimeClock conundrum continues...now with more MATH

    Started by josh.sheffield, Feb 8, 2013 08:31
    • Replies: 12
    • Views: 1,311
    josh.sheffield
    Feb 8, 2013, 10:33 Go to last post

  17. How to make auto backup of MySQL databases & rotate 3 days?

    Started by WorldNews, Feb 7, 2013 13:34
    • Replies: 2
    • Views: 657
    WorldNews
    Feb 8, 2013, 09:38 Go to last post

  18. Need a suggestion Data Recovery in sql

    Started by lina johansson, Feb 7, 2013 10:00
    • Replies: 4
    • Views: 672
    lina johansson
    Feb 8, 2013, 08:31 Go to last post

  19. Interval day and week

    Started by cms9651, Feb 8, 2013 07:53
    • Replies: 2
    • Views: 519
    cms9651
    Feb 8, 2013, 08:22 Go to last post

  20. Making an INSERT using a SELECT

    Started by busboy, Feb 5, 2013 17:01
    • Replies: 3
    • Views: 596
    busboy
    Feb 6, 2013, 19:38 Go to last post

  21. Duplicated inserts for some reason

    Started by busboy, Feb 4, 2013 22:30
    • Replies: 11
    • Views: 729
    K. Wolfe
    Feb 6, 2013, 08:14 Go to last post

  22. Query to find routines that should have run since timestamp

    Started by digitalquill, Feb 6, 2013 05:41
    • Replies: 0
    • Views: 410
    digitalquill
    Feb 6, 2013, 05:41 Go to last post

  23. parent child relationship

    Started by windowsxp, Feb 5, 2013 23:58
    • Replies: 1
    • Views: 414
    r937
    Feb 6, 2013, 01:22 Go to last post

  24. Need a confirmation before I run this DELETE query

    Started by busboy, Feb 5, 2013 19:54
    • Replies: 3
    • Views: 503
    r937
    Feb 5, 2013, 23:56 Go to last post

  25. Problem updating data with UNION Query

    Started by DoubleDee, Feb 3, 2013 22:28
    • Replies: 6
    • Views: 626
    DoubleDee
    Feb 5, 2013, 22:03 Go to last post

  26. Need a Selective GROUP BY in My Query

    Started by Chavista, Feb 3, 2013 23:13
    • Replies: 9
    • Views: 743
    Chavista
    Feb 5, 2013, 19:05 Go to last post

  27. How to skip update record ?

    Started by windowsxp, Feb 5, 2013 03:24
    • Replies: 4
    • Views: 509
    K. Wolfe
    Feb 5, 2013, 16:03 Go to last post

  28. BETWEEN query not working just right...

    Started by josh.sheffield, Feb 4, 2013 13:51
    • Replies: 8
    • Views: 577
    josh.sheffield
    Feb 5, 2013, 14:01 Go to last post

  29. How to find duplicate entry ?

    Started by windowsxp, Feb 5, 2013 04:34
    • Replies: 2
    • Views: 431
    r937
    Feb 5, 2013, 12:32 Go to last post

  30. Mysql 1286 Unknown table engine 'InnoDB''

    Started by whisher, Jan 28, 2013 03:18
    • Replies: 10
    • Views: 1,112
    whisher
    Feb 5, 2013, 01:47 Go to last post

  31. two queries without using UNION

    Started by afridy, Feb 4, 2013 03:38
    • Replies: 5
    • Views: 522
    afridy
    Feb 5, 2013, 00:41 Go to last post

  32. Truncated incorrect DOUBLE value in update query

    Started by cms9651, Feb 4, 2013 02:58
    • Replies: 2
    • Views: 580
    cms9651
    Feb 4, 2013, 13:43 Go to last post

  33. Convert Xml

    Started by altarek, Feb 4, 2013 03:03
    • Replies: 3
    • Views: 413
    guido2004
    Feb 4, 2013, 11:50 Go to last post

  34. Database design for Meal Plans

    Started by SomeGuyinNJ, Feb 4, 2013 09:46
    • Replies: 2
    • Views: 470
    SomeGuyinNJ
    Feb 4, 2013, 11:00 Go to last post

  35. how to update Table data with Excel data

    Started by windowsxp, Feb 3, 2013 05:19
    • Replies: 7
    • Views: 686
    r937
    Feb 4, 2013, 06:51 Go to last post

  36. MYSQL query order problem

    Started by Archbob, Jan 30, 2013 22:37
    • Replies: 11
    • Views: 1,151
    molona
    Feb 4, 2013, 06:39 Go to last post

  37. Update foreign key values in parent table

    Started by seannie, Feb 3, 2013 04:54
    • Replies: 1
    • Views: 448
    r937
    Feb 3, 2013, 06:58 Go to last post

  38. How 2 find duplicate rows (PHP/MySQL)

    Started by Chavista, Jan 30, 2013 18:51
    • Replies: 2
    • Views: 742
    Chavista
    Feb 1, 2013, 19:44 Go to last post

  39. Is this possible in one query?

    Started by wh33t, Jan 31, 2013 21:30
    • Replies: 11
    • Views: 681
    wh33t
    Feb 1, 2013, 16:12 Go to last post

  40. copying/cloning a record in the database?

    Started by Cmarenburg, Feb 1, 2013 11:53
    • Replies: 0
    • Views: 411
    Cmarenburg
    Feb 1, 2013, 11:53 Go to last post
Page 5 of 669 FirstFirst 1234567891555105505 ... 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