MySQL Help

23,055 topics in this forum

1. Delete query that deletes from 3 tables

   By pocobueno1388, March 9, 2008
   • 20 replies
   • 3.9k views
   • 
   • pocobueno1388
   • March 25, 2008

2. 5 day moving average

   By rohitb, August 2, 2011
   • 15 replies
   • 3.9k views
   • 
   • kickstart
   • August 4, 2011

3. A SELECT using SUM and AVG that returns the wrong result

   By Gaoshan, September 29, 2006
   • 7 replies
   • 3.9k views
   • 
   • Gaoshan
   • October 1, 2006

4. INSERT statement not working inside of WHILE loop from SELECT query

   By Hobbyist_PHPer, April 27, 2011
   • 12 replies
   • 3.9k views
   • 
   • Hobbyist_PHPer
   • April 28, 2011

5. MySQL configuration

   By MikeD, March 21, 2008
   • 13 replies
   • 3.9k views
   • 
   • MikeD
   • March 23, 2008

6. [SOLVED] new database old tricks

   By 11sven, August 9, 2009
   • 3 replies
   • 3.9k views
   • 
   • 11sven
   • August 9, 2009

7. Error #1064: syntax error in .sql file

   By Seager, October 28, 2013
   • 1 reply
   • 3.9k views
   • 
   • kicken
   • October 28, 2013

8. using MATCH AGAINST - can you build for misspellings/partial matches?

   By bcamp1973, August 23, 2006
   • 2 replies
   • 3.9k views
   • 
   • bcamp1973
   • August 25, 2006

9. Updating records when loading CSV file

   By chilly98, June 10, 2009
   • 5 replies
   • 3.9k views
   • 
   • Barand
   • October 11, 2012

10. Msql Help!!

    By MxpUnk, October 25, 2005
    • 15 replies
    • 3.9k views
    • 
    • MxpUnk
    • October 30, 2005

11. Members gender count and percentage

    By brown2005, December 2, 2010
    • 2 replies
    • 3.8k views
    • 
    • fenway
    • December 3, 2010

12. [SOLVED] MySql, PHP and Vista

    By Cat, August 12, 2007
    • 11 replies
    • 3.8k views
    • 
    • Cat
    • August 14, 2007

13. multiple averages rolling over the same numbers

    By illcrx, September 24, 2014
    • 8 replies
    • 3.8k views
    • 
    • illcrx
    • September 29, 2014

14. Innerjoin and only return 1 result for each row

    By Monkuar, September 14, 2012
    • 9 replies
    • 3.8k views
    • 
    • jazzman1
    • September 15, 2012

15. how to get value in database by id

    By TheSky, April 3, 2011
    • 2 replies
    • 3.8k views
    • 
    • blacknight
    • April 4, 2011

16. What's the fastest way to search INNODB tables?

    By Fluoresce, November 5, 2014   

    • innodb
    • fulltext
    • (and 2 more)

      Tagged with:

      • innodb
      • fulltext
      • myisam
      • search
    • 11 replies
    • 3.8k views
    • 
    • gizmola
    • November 12, 2014

17. Random questions from mysql

    By marcus88, March 2, 2003
    • 3 replies
    • 3.8k views
    • 
    • NL_Johan_UK
    • March 3, 2003

18. Error 1006 (errno: 28)

    By barrow, June 12, 2003
    • 4 replies
    • 3.8k views
    • 
    • barrow
    • June 13, 2003

19. select all years between two dates

    By fife, February 26, 2013   

    • sql
    • unix
    • (and 1 more)

      Tagged with:

      • sql
      • unix
      • date_format
    • 4 replies
    • 3.8k views
    • 
    • fife
    • February 26, 2013

20. [SOLVED] Insert a unique AND random 10-digit number (instead of auto-increment)

    By sKunKbad, May 30, 2009
    • 4 replies
    • 3.8k views
    • 
    • sKunKbad
    • May 30, 2009

21. Slight Problem

    By derekmcd, January 23, 2003
    • 7 replies
    • 3.8k views
    • 
    • metalblend
    • January 24, 2003

22. php/mysql update error

    By HossMan, February 25, 2003
    • 4 replies
    • 3.8k views
    • 
    • pallevillesen
    • February 28, 2003

23. composite key where one field is cascade delete and the other is cascade set null

    By NotionCommotion, October 31, 2019
    • 10 replies
    • 3.8k views
    • 
    • NotionCommotion
    • November 1, 2019

24. MySql Transaction Rollback with multiple queries

    By GregL83, February 17, 2010
    • 1 reply
    • 3.8k views
    • 
    • GregL83
    • February 18, 2010

25. What is the best table structure for use with PHP?

    By bakertaylor28, September 4, 2020   

    • table
    • database php
    • (and 3 more)

      Tagged with:

      • table
      • database php
      • php
      • mysql
      • sql
    • 10 replies
    • 3.8k views
    • 
    • maxxd
    • September 10, 2020