SitePoint Sponsor
  1. Announcement:
    Is everything in your Database an error?
    Mittineague (Programming Team)
    Mar 7, 2013
    Views:
    273
Page 4 of 669 FirstFirst 123456781454104504 ... LastLast
Threads 121 to 160 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. help me make a query.

    Started by ReGGaeBOSS, Mar 10, 2013 22:16
    • Replies: 0
    • Views: 354
    ReGGaeBOSS
    Mar 10, 2013, 22:16 Go to last post

  2. Question Creating a Trigger on Update that makes a web request.

    Started by aaron.martone, Mar 8, 2013 16:36
    • Replies: 1
    • Views: 472
    aaron.martone
    Mar 10, 2013, 18:03 Go to last post

  3. Question MySQL packages cannot be installed because of unmet dependencies - Ubuntu 12.04

    Started by samabraham, Mar 7, 2013 09:07
    mysql update 3 Attachment(s)
    • Replies: 2
    • Views: 516
    scannon
    Mar 8, 2013, 11:59 Go to last post

  4. build a php/html file to have drop down from 2 MYsql tables

    Started by hachemal, Mar 7, 2013 14:29
    • Replies: 0
    • Views: 474
    hachemal
    Mar 7, 2013, 14:29 Go to last post

  5. Order by and case when

    Started by cms9651, Mar 6, 2013 09:42
    • Replies: 11
    • Views: 570
    DaveMaxwell
    Mar 7, 2013, 13:31 Go to last post

  6. first 3-way join

    Started by nichemtktg, Mar 5, 2013 12:42
    • Replies: 8
    • Views: 580
    nichemtktg
    Mar 6, 2013, 17:05 Go to last post

  7. MySQL username and password

    Started by dineroking, Mar 5, 2013 23:54
    • Replies: 2
    • Views: 398
    SpacePhoenix
    Mar 6, 2013, 14:13 Go to last post

  8. Question MySQL not working. Error: 'mysqladmin: connect to server at 'localhost' failed'

    Started by samabraham, Mar 2, 2013 04:08
    mysql installation 1 Attachment(s)
    • Replies: 4
    • Views: 720
    samabraham
    Mar 6, 2013, 11:20 Go to last post

  9. INSERT Date rows between limits

    Started by Mandes, Mar 5, 2013 11:12
    • Replies: 4
    • Views: 388
    Mandes
    Mar 5, 2013, 11:27 Go to last post

  10. Question What is the database best practice storing Country/State location pointer?

    Started by azuranz, Mar 4, 2013 20:28
    • Replies: 1
    • Views: 420
    r937
    Mar 5, 2013, 03:53 Go to last post

  11. Save lowercase username or make case insensitive queries?

    Started by llnitoll, Mar 3, 2013 13:55
    • Replies: 5
    • Views: 519
    llnitoll
    Mar 4, 2013, 13:55 Go to last post

  12. foreign key-auto increment

    Started by designtrooper, Mar 4, 2013 11:21
    • Replies: 3
    • Views: 453
    r937
    Mar 4, 2013, 12:27 Go to last post

  13. total and group by with where clause in sub query?

    Started by venkat6134, Feb 28, 2013 05:24
    • Replies: 12
    • Views: 795
    r937
    Mar 4, 2013, 05:47 Go to last post

  14. order by issue

    Started by IBazz, Mar 2, 2013 07:56
    • Replies: 4
    • Views: 399
    r937
    Mar 2, 2013, 16:00 Go to last post

  15. Mysql CONVERT_TZ and Vise versa

    Started by stonedeft, Mar 2, 2013 13:30
    convert_tz
    • Replies: 0
    • Views: 349
    stonedeft
    Mar 2, 2013, 13:30 Go to last post

  16. Counting products in each category - php loop getting slow...

    Started by peppy, Feb 20, 2013 18:33
    • Replies: 12
    • Views: 1,374
    Swasstastic
    Mar 2, 2013, 01:18 Go to last post

  17. Question Database structure for music

    Started by skelleex, Mar 1, 2013 05:52
    • Replies: 7
    • Views: 614
    r937
    Mar 1, 2013, 14:08 Go to last post

  18. Insert a field after an existing field

    Started by Philosophaie, Feb 15, 2013 02:06
    • Replies: 8
    • Views: 768
    K. Wolfe
    Mar 1, 2013, 11:29 Go to last post

  19. How to run one database for main domain and subdomain.

    Started by chikitado, Feb 28, 2013 00:20
    • Replies: 2
    • Views: 526
    chikitado
    Feb 28, 2013, 20:20 Go to last post

  20. Post Confuse in FK

    Started by jemz, Feb 26, 2013 05:14
    • Replies: 9
    • Views: 624
    jemz
    Feb 27, 2013, 21:01 Go to last post

  21. MySQL query for creating a recordset of users who've been inactive for 6 months

    Started by scim1971, Feb 27, 2013 08:32
    • Replies: 2
    • Views: 603
    scim1971
    Feb 27, 2013, 09:41 Go to last post

  22. Uploading large .sql file

    Started by Banana Man, Feb 22, 2013 14:39
    • Replies: 8
    • Views: 1,029
    Lemon Juice
    Feb 26, 2013, 18:13 Go to last post

  23. Good Test case SQL files.

    Started by Michael Morris, Feb 26, 2013 16:28
    • Replies: 0
    • Views: 550
    Michael Morris
    Feb 26, 2013, 16:28 Go to last post

  24. Help Please

    Started by AdWarm, Feb 22, 2013 11:00
    • Replies: 7
    • Views: 628
    r937
    Feb 26, 2013, 12:20 Go to last post

  25. Get a value, even if it's null

    Started by BigBadBurrow, Feb 25, 2013 15:20
    • Replies: 4
    • Views: 562
    BigBadBurrow
    Feb 26, 2013, 01:40 Go to last post

  26. simple averaging of table column

    Started by datadriven, Feb 23, 2013 21:06
    • Replies: 3
    • Views: 574
    r937
    Feb 24, 2013, 13:04 Go to last post

  27. code indentation

    Started by windowsxp, Feb 23, 2013 07:03
    • Replies: 1
    • Views: 442
    r937
    Feb 23, 2013, 09:23 Go to last post

  28. dynamic select query

    Started by windowsxp, Feb 23, 2013 04:47
    • Replies: 1
    • Views: 405
    r937
    Feb 23, 2013, 06:53 Go to last post

  29. loading values from a column of one table to the column of another

    Started by Fati Kom, Feb 22, 2013 00:12
    • Replies: 4
    • Views: 487
    Fati Kom
    Feb 23, 2013, 00:45 Go to last post

  30. GROUP BY and ORDER BY

    Started by mickyginger, Feb 19, 2013 04:53
    • Replies: 14
    • Views: 720
    r937
    Feb 22, 2013, 16:16 Go to last post

  31. Query taking >150 seconds to execute ... Need some optimization help

    Started by Takai, Feb 22, 2013 10:12
    • Replies: 2
    • Views: 285
    Takai
    Feb 22, 2013, 12:01 Go to last post

  32. Question about using a datetime column with an unique index

    Started by busboy, Feb 21, 2013 17:41
    • Replies: 1
    • Views: 359
    r937
    Feb 21, 2013, 20:15 Go to last post

  33. How to change column names on the fly in mysql ?

    Started by Tapan, Feb 20, 2013 06:40
    • Replies: 4
    • Views: 482
    Tapan
    Feb 21, 2013, 04:53 Go to last post

  34. How to convert unix timestamp to specific format in mysql ?

    Started by Tapan, Feb 20, 2013 12:16
    • Replies: 3
    • Views: 461
    Tapan
    Feb 21, 2013, 04:08 Go to last post

  35. Populating a column in one table with a column in another table

    Started by busboy, Feb 20, 2013 19:41
    • Replies: 1
    • Views: 304
    busboy
    Feb 20, 2013, 19:52 Go to last post

  36. Is a sub query necessary for this ?

    Started by tangledman, Feb 20, 2013 13:59
    • Replies: 1
    • Views: 359
    DaveMaxwell
    Feb 20, 2013, 14:28 Go to last post

  37. Traversal methods

    Started by Miguel61, Feb 18, 2013 05:24
    • Replies: 13
    • Views: 610
    Miguel61
    Feb 20, 2013, 12:40 Go to last post

  38. Retrieve two values from the same column as two columns

    Started by djeyewater, Feb 19, 2013 16:12
    • Replies: 2
    • Views: 404
    djeyewater
    Feb 20, 2013, 02:32 Go to last post

  39. Question ordering strings containing numbers

    Started by mickyginger, Feb 19, 2013 05:40
    • Replies: 4
    • Views: 413
    r937
    Feb 19, 2013, 13:10 Go to last post

  40. Why do duplicate rows get inserted?

    Started by busboy, Feb 11, 2013 22:01
    2 Pages •
    1 2
    • Replies: 34
    • Views: 1,337
    busboy
    Feb 18, 2013, 15:10 Go to last post
Page 4 of 669 FirstFirst 123456781454104504 ... 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