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

  1. write a right sql statement to get this job done
  2. What is the #1 pain point of MySQL users with database sizes of more than 200GB?
  3. Get count of distinct dates
  4. Date Time Standardisation
  5. database replication or backup
  6. which table needs to be repaired?
  7. Insert data into DB, return ID number
  8. Have I done it right
  9. Show only rows where there is a full match
  10. How to store something like Facebook Groups in DB?
  11. How to import/export an existing MySQL database using neatbeans?
  12. Why mysql creates an index for one foreign key and ignores the other?
  13. Writing data to 2 Databases with 1 form
  14. Very Basic Question
  15. Help with err 10055 when connecting to MySQL
  16. Data Integrity Issue
  17. Short Login Names
  18. query help
  19. Need help with sorting by MAX average!
  20. Newbie Question
  21. getting an adjacency model table selected into rows?
  22. How to Index and Fasten This Slow Query?
  23. compact framework 6.2.2.0
  24. Twitter style followees feed subscriptions
  25. Simple moving avg (SMA)
  26. prob:connection to database
  27. Could not start service MySQL - reinstall
  28. Resetting MySQL Password - Newbie w/a problem
  29. Making a car-filter - An advanced query you'll never figure out :S
  30. Multiple sorts... totally lost
  31. Search for an incomplete word
  32. How do I simulate 'auto_increment' on a non-primary key field
  33. MySQL & ASP // Password()
  34. Cross Join
  35. need to 'order by' date, but also 'order by' and integer field
  36. convert ms sql query to mysql
  37. insert is slower when DataFile size increases
  38. JOINing 2 colums of one table to 1 column of another
  39. Select 'A and B' records first, then 'A or B' records
  40. C++ & MySQL++ & MySQL API
  41. User Login, check fields from multiple tables
  42. Find Matches Between Partial Names
  43. MySQL MATCH returns no relevance score
  44. Execute shell script through stored procedure
  45. Prepared Statement with IN() Clause
  46. NOT BETWEEN with UNIXTIME field?
  47. Rapidly Growing Database
  48. Database design help
  49. Inserting a File into a table
  50. Help me build a database
  51. Query Help
  52. Dual HAVING on AS
  53. Join 1 column from 1 table to another table
  54. MySQL SELECT distinct & group by
  55. create database gui
  56. multi user
  57. Major SQL Problems
  58. How to write the record number on a separate field
  59. How to join multiple results into one result
  60. not inserting in field properly
  61. duplicate unique key on same column
  62. Best approach to relating databases or tables?
  63. Data truncation?
  64. User in multiple categories
  65. Query Problem
  66. cannot establish a connection
  67. Transaction within a procedure not working
  68. How to Save Session UserName in a table using mysql...
  69. How to query the datetime field in MySQL
  70. Can anyone find me a data model i can use for my coursework?
  71. total number records
  72. very urgent: need help with Database
  73. Grant_priv
  74. SQL and MySQL comunication
  75. Need help with database structure
  76. Search engine help
  77. Ways to store audit trail
  78. Tricky SELECT Statement
  79. How to take backup of a database for a particlar time frame
  80. using innodb engine for my database
  81. Load Data
  82. erased data from MySQL table still populating a Google Map?
  83. Advanced algorithm of an existing MySQL query
  84. Design Question
  85. How can you export stored procedures to a file?
  86. Multiple Foreign Keys to Multiple references
  87. problem with using aggregate functions
  88. Filtering query
  89. Unreliable innodb transaction
  90. database design help
  91. Newbie with fresh install errors.
  92. Select order
  93. Mysql high cpu consume
  94. Reverse a Condition
  95. Many to Many Challenge
  96. challenging query
  97. How to do a JOIN with multiple tables
  98. Desktop App: Keep connection open or not?
  99. update table recursively
  100. How to sort the search result order by most relevancy?
  101. join 2 columns of a table with a column from another table
  102. MySQL settings for large queries
  103. Should i use recursion?
  104. xml/json returned from query/procedure
  105. SQL problem: updating a table's columns with other table's row's data
  106. Complicated select
  107. Date issues
  108. Migrate Informix database to MySQL
  109. NULL Problem
  110. Category table recurssion
  111. MySQL Stored Procedures : Use a variable as the database name in a cursor declaration
  112. Load into file \ character problem
  113. Index for single table query with group by/order by
  114. Problem adding a udf function to mysql server
  115. How to write the repeat of the users with same ID
  116. Count the number of items for a query
  117. Help with Sakila
  118. Trying to search for a word in a field
  119. Is it possible to write a loop to insert?
  120. ID update with various tables in a database
  121. mysql / odbc driver / excel
  122. Does a procedure return a boolean value?
  123. i want EXEC sp_xml_preparedocument same function in mysql
  124. I have createstore procedure in mysql i got error on convert function
  125. Embedded SQL Problem
  126. Return Dates in a Range
  127. Transaction wont Rollback in SP
  128. autoincrement column is odd numbers
  129. Query help. newest distinct rows.
  130. count of two values in a joined table?
  131. Select all years between two years
  132. How can i find last occurence of a substring in string?
  133. Please correct this Query
  134. Source command Question
  135. UNIQUE or PRIMARY
  136. Create trigger
  137. PHP form to query DB for ANY entry
  138. MySQL sets Foreign key references in lower case
  139. Capacity of Database?
  140. high load averages caused by mysql
  141. Setting causing browser lockups?
  142. REGEX Pattern
  143. mysql.sock problem
  144. Multiple Date Range Rates
  145. What Server/Application Do I use?
  146. cout() issue
  147. Pls help me! How to make this SQL query?
  148. Noobie question about NAS server
  149. Problems importing .csv
  150. How to script out all database objects?
  151. Dates
  152. Logs I should always check for health
  153. Needs your help, both of following sql syntax produce same result in MySql
  154. Mysql Order
  155. Count number of matching entries in separate Table with one query?
  156. Left Join returning a Syntax Error
  157. MySQL restarts few times a day
  158. cannot create a new database
  159. Count(count(count()))
  160. How to Write Complex Join Query
  161. Monitor index usage
  162. Using SQL Manager Lite anyone?
  163. Looking for books
  164. Structure Question/Issue
  165. ETL Opinions
  166. Performing Foreign Key Checks
  167. easiest way to convert Access DB into SQL?
  168. mysql database design question
  169. Can connect to database with Dreamweaver, but not with MySQL Query Browser
  170. select query help...
  171. Malformed Packet Error When Calling LOAD DATA LOCAL INFILE
  172. Searching for international characters
  173. Issue with read queries not being directed to slaves in MMM configuration
  174. mysqlimport
  175. Aggregate of a Aggregate producing strange results
  176. Problems in my WHERE clause :(
  177. Join Query
  178. how to setup db like facebook
  179. Newbie query question
  180. duplicate ids not returned
  181. $20 via paypal if you can solve this. (probably easy)
  182. Database inheritance - not sure if i'm doing it correctly?
  183. an html table field "telephone" eg 46799999666, appear it 4.678E09
  184. How To get Hierarchal Data like cte in MSsql server
  185. SELECT FOUND_ROWS() not Working
  186. 1064 error, please help
  187. select certain rows
  188. COUNT times 2!
  189. Problem with php/mysql
  190. Select if else
  191. how do i use multiple lines with SET @var =
  192. Triggers and Stored Procedures in MySQL
  193. How do we create MySQL Stored Function or Procedure from Java JDBC Library?
  194. Database Question
  195. Group supression
  196. code help
  197. Enabling Network Connections?
  198. Slow queries.. Cant think of a solution
  199. Questions!!!questions!!!questions!!!!
  200. Password? mysqldump?
  201. Help with Null Box
  202. Need a Query Help
  203. Lot of small queries or a Large 1
  204. Error
  205. Stored Procedure Caching and Performance comparison of 2 stored Procedures
  206. Help regarding query optimization
  207. InnoDB Buffer Pool Size limited by linux kernel?
  208. mysqldump: Got error: 1045 when run from batch file
  209. search text ignoring tags in it
  210. MySQL case sensitive?
  211. Get column names according to condition
  212. Mysql server configuration for 1 GB RAM
  213. Kichoos
  214. displaying mysql_fetch_array data in a html table
  215. DataBase = Web Page
  216. How to correctly use ON CASCADE DELETE?
  217. how reset autoincrement field ?
  218. If I reinstall MySQL for the bundle AMPP then needs reinstall and the ODBC DRIVER etc
  219. Internal/External DB
  220. Table Partitioning
  221. mysql and btrieve
  222. MySQL free or not?
  223. MySQL View
  224. LIMIT improves query performance?
  225. Fatel Error
  226. need help with a shop
  227. Find string occurrences
  228. small help in MySQL
  229. Help me finding a db schema or sourceforge project
  230. Batch Insert Issue with Mysql
  231. select a rounded float field
  232. please anyone help me to using subqueries in mysql
  233. How to connect to MySQL database protected by SSH
  234. ODBC Connection error
  235. Select a field if mathes to 2 or more criteria
  236. SQL authentication protocol
  237. var and varchar
  238. Simple Query Help
  239. Link mySQL db to content
  240. Help with complex inner join
  241. Help collating multiple records from multiple tables into a single record
  242. Error Loading Text File into Table
  243. Automatic Backup of SQL Database
  244. MAX() in WHERE clause
  245. Query Help
  246. db redesign - too many tables
  247. What are the other Database operations apart from CRUD?
  248. Database Design For Forum
  249. mySQL Query Probleme
  250. find seconds ago on multi row query