PDA

View Full Version : MySQL

Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 [29] 30 31 32 33 34 35 36 37
  1. IF THEN Question
  2. Resolved group_concat, count
  3. Best way to store date in database
  4. Query to get averages, minimums etc. from 2 tables
  5. search from 2 tables based on 1 column
  6. Joining data from 2 tables - what am I doing wrong?
  7. Error 1054
  8. Adding a column name prefix on SELECT
  9. Delete Records from one than one DB table using flat file
  10. Database query 4 failed:
  11. Reorder columns in MySQL table...?
  12. SELECT AS plus WHERE doesn't work
  13. Deleting a Wordpress Database
  14. Subtract as default value
  15. Resolved You have an error in your SQL syntax; check the manual ...
  16. Using UNION
  17. Updating blank rows with data located in same table and ID
  18. Problem in using IN command
  19. Remote connection to mysql
  20. Left Joint and Count(*)
  21. Join multiple tables, then join some more...
  22. Beginner needs Help...please?
  23. Put table names into drop-down menu
  24. get image size when transfering MySQL to MySQL
  25. Value Counts as Columns
  26. Querying data with the "where" statement
  27. need help with select query (begginer)
  28. Can't connect to local MySQL server through socket
  29. Attempting to Create a Comment Feed on Site?
  30. Get SUM from COUNT?!?!
  31. Just does nothing
  32. Can you Run PHP in MySQL?
  33. Resolved SQL - binding table values and compare results
  34. Reset auto increment when value reaches certain number
  35. how to remove slashes ready for outputting to pages, addslashes()
  36. mysql time - now()
  37. Condensing this query for faster processing by MySQL
  38. SELECT ALL entries, but not the last 10 recent entries.
  39. store correct time using gmdate() even when daylight saying is in place in the UK
  40. PHP and MySQL: echo all entries using SHOW COLUMNS
  41. DELETE ALL entries, but not the last 10 recent entries.
  42. Error joining 3 tables
  43. Counting rows based on a field's value
  44. Resolved help combine two queries
  45. get rankings for 100 records
  46. SubSelect minimum year per person
  47. mysql birthday date query
  48. MySql Update
  49. trying to use this query - not working
  50. Left Join query not working in mysql 5.1
  51. Create auto numbered column in mysql query
  52. Advanced FULLTEXT searching
  53. mysql/php script not working?
  54. How do I select using GROUP BY, ORDER BY. based on the date_time which is groupe
  55. Resolved Custom ordering entries
  56. Performance question
  57. Resolved Search Database - Multiple 'OR' statements
  58. how to write the query ?
  59. Need to go 'sideways' with a form... noob
  60. weight system
  61. Help SQL query (find names with a average below...)
  62. Flash to MySQL : Can't figure it out.
  63. sort by random AND by rating?
  64. Search Within Two tables
  65. mysql error help please i'm stumped.
  66. mysql not pulling data with non-letters
  67. Resolved trying to use query to delete
  68. Resolved how to divide
  69. Creating a poll using MySQL & PHP
  70. Echoed DB entries hyperlinked
  71. Help Needed On SQL query
  72. ACT extract
  73. Insert Image Into Mysql Database / path of Image
  74. Faster Method of Query???
  75. setting up a database table question
  76. MySQL IF statement
  77. Passing unique values only to a shopping cart
  78. Resolved group_concat, group_concat
  79. MySQL Error?
  80. storing javascript code in database
  81. "'Cannot add or update a child row: a foreign key constraint fails
  82. accessing MySQL using .cgi file
  83. Need you help guys
  84. Split string and use value as foreign key
  85. I'm not sure how to do this...
  86. Database table with multiple rows
  87. PHP install file to import sql file with php script
  88. maximum of values in an insert statement
  89. "Last modified" specific to a user
  90. many to many not avoidable ?
  91. is there a quick way to check if a record exists in a db
  92. Finding equal values in a table?
  93. Help with join for books and missing books
  94. php mysql show image from path in database
  95. Character set of tables displays wrong in php
  96. How to make a registration form?
  97. Please. Help with Join
  98. Resolved mysql distinct help please.
  99. toad vs mysql workbench?
  100. Rhyme / Word List Retriever
  101. stored proc / into keyword
  102. Geographic Search with Longitude Latitude
  103. stored proc null comparison
  104. date table, find missing dates
  105. php mysql update problem
  106. MySQL and storing binary data
  107. Toggling a row's field to 1 or 0
  108. my site is getting hacked and cant fixed it can anybody help me
  109. MySQL update has broken a lot of things
  110. How to store binary data in mysql
  111. include first previous existing date
  112. general opinion on tables structure
  113. Often corrupted tables
  114. Applying a math algorithm to "re-order" items in a database, and display on website??
  115. Signup Question
  116. Date Issues
  117. Export data/query to csv?
  118. Order BY something that isn't in the database?
  119. Naming a column after the value from another column
  120. COUNT usage in PHP
  121. Resolved Twin InnerJoin Plus Where Clause?
  122. Join two tables
  123. Help with Selecting records between two date range
  124. error querying database
  125. removing duplicates from the results of a double query
  126. Help with Category Count
  127. wanted help in redesign table structure
  128. Resolved master - detail logical problem
  129. simultaneous posts to database
  130. db->csv or xml files.
  131. syntax error
  132. Alphabetizing mySQL records
  133. Best method for storing time?
  134. Data Base Structure Question
  135. mysql distinct help please
  136. Error, changed password?
  137. adding an auto-numbered column to the "results" table
  138. Effeciency Question
  139. Settings table.
  140. Sorting by 3 fields
  141. MySQL and PHP code help for a membership site. Thank You
  142. will this work with (php) query || or ?
  143. similarity - repetition of data
  144. Including a deleted column?
  145. Deleting records
  146. database sleep/processes
  147. How Do I fix Error No. 1064 occured:You have an error in your SQL syntax;:
  148. CREATE INDEX for order by rand() query
  149. Assignments Table
  150. Resolved SQL Search?
  151. how to import text only CSV into MySQL
  152. Illegal mix of collations?
  153. MySQL checkbox data display problem in ZenCart
  154. Learn PHP with a project - Favorite System
  155. basic mysql query question
  156. MySql Query Using SET and IN Clauses with an Array
  157. Problem with foreign key and referential integrity
  158. Inserting Data from comma separated text field values
  159. Moving 689 mb of mysql to another server
  160. Starting out designing a database
  161. Storing information in Sessions
  162. foreign key and index?
  163. MYSQL grouping and ordering by field question
  164. select a fictional column
  165. combining 2 resultsets
  166. How to set up tables for threaded comments?
  167. Clickable link that runs query sometimes getting run twice due to page reload?
  168. valid MySQL result resource Error, Need Help
  169. Where?
  170. Help needed with joins.
  171. Help with date
  172. Categories and Subcategories
  173. how to get rows??
  174. group_concat inside where ?
  175. Getting "invalid syntax", please help
  176. Insert Or Update in mysql query and return row id + action
  177. Trouble with a table join
  178. meta table...
  179. php variable, who is logged in, ty
  180. splitting string with multiple delimiters
  181. Calling rows where column = FILE LIST
  182. how to view structure of a database/ table in mysqladmin?
  183. Procedures and functions
  184. combining tables and columns
  185. i have create three user and database for each premission i have to give thn
  186. querying normalized database
  187. Fastest way to do multiple inserts
  188. Organizational Question
  189. Insert only if no duplicates
  190. You have an error in your SQL syntax; check the manual that corresponds to your MySQL
  191. Subtracting the MIN from multiple results
  192. No database selected :S
  193. how to fetch a table in stored procedure
  194. Retrieve 5 rows from a specific position in table
  195. joining a members and officers table
  196. fetch from table
  197. Looking for a query to copy data from one table to another
  198. Order by a new variable.
  199. Linking tables to look for records that aren't there
  200. Number of brands according to first letter of the brand?
  201. Select all galleries and the appropriate image
  202. how to get value from combobox into textbox
  203. truncate through limited table entries.
  204. User and group managing
  205. SELECT WHERE x LIKE row1+row2
  206. Beginner Question
  207. Resolved Removing one word from a column
  208. SQL string - is this correct?
  209. Unique ID's from query
  210. What performance configuration for mass INSERTS
  211. using mysql and php to track user ids for who voted
  212. Resolved Subquery doesn't work. Good alternate solution?
  213. One MySQL query per page - instead of 100!
  214. mysql get question
  215. Resolved Appending http:// to multiple columns
  216. MySQL 'type' question
  217. MySQL --skip-name-resolve
  218. Optimizing Database Update
  219. update query not working with curdate()
  220. mysql_fetch_array trouble please help!
  221. Parse error: syntax error, unexpected T_STRING in /home/content/d/j/h/djh102/html/pub
  222. User folder access
  223. Query another table withing FOR loop of a table.
  224. Big defference in Update Speed on different systems
  225. MYSQL error
  226. copying table data into other tables
  227. Modified preorder tree traversal Hirearchies
  228. Multiple authors for one article
  229. Selecting parents with nested children for a category - sub category relationship?
  230. need help in update query
  231. Need help deciding best method
  232. Resolved Setting data to '1' not as instructed
  233. to which point join still make sense?
  234. How to change the date format?
  235. Date structure fields in mySQL - which format?
  236. make database and refresh it after click
  237. Using if and or?!?
  238. JOIN or not to JOIN
  239. I think this is a simple JOIN but I cant solve it
  240. Help with Search function PHP and MySql to work with queries like 123ABC
  241. regex or something
  242. Resolved MySQL JOIN Problems
  243. Procedure privilege error?
  244. Join/Union....?
  245. what king of table structure is this
  246. Problem with while loop/group by
  247. deleting childless records
  248. Need a help in this issue
  249. Resolved Connecting To MySQL Server Through Java Program Secure?
  250. Another group-thread-reply question