PDA

View Full Version : MySQL

Pages : 1 2 3 4 5 [6] 7 8 9 10 11 12 13 14 15 16 17 18
  1. Is it possible to combine a SELECT and UPDATE in a single query
  2. Rows Positions problems while performing several operations
  3. week numbers doesnt correspond with the official ones
  4. MySQL ignores datatdir on Vista
  5. how to monitor dynamic performance
  6. INSERT works in phpMyAdmin but not in PHP
  7. Query /Stored proc issue..Help please
  8. activating slow query log
  9. converting mysql 4 statements to mysql 5
  10. SELECT has different effect in a view
  11. using fulltext like 'like'
  12. return result set from cursor
  13. Query with WHERE ... IN () AND ... NOT IN ()
  14. Installing MySQL 5.0 (Windows 2000)
  15. please help with searching in mysql database
  16. MySQL error log becomes zero bytes
  17. Select Top 1 * problem
  18. Regular Expression to Update a field
  19. MYSQL with VB
  20. How do I find out exactly why a query is taking so long?
  21. Query which uses more than one value from the same column?
  22. Child and parent rows
  23. Basic MySQL MERGE table question
  24. How to create Read Only Table
  25. Is it possible to QUERY and insert result into another table?
  26. How to find out the current version of the MySQL installation ?
  27. How to list all existing databases and their size ?
  28. I need help optimizing this query
  29. mysql connections vs threads
  30. Multiple Count in 1 Query
  31. how does view work??
  32. Trying to wrap my brain around a normalization issue. Assistance please?
  33. Case sensitivity
  34. double insert
  35. Question about Warning (Code 1262): (number of input rows & @dummy)
  36. How to count number of distinct rows
  37. top3 with or without "having" in query
  38. concatonating 2 SELECTS into the same result set?
  39. Query optimization
  40. return min between 2 fields
  41. Do i need to install mysql-Enterprise to use monitoring?
  42. grouping results
  43. Normalization
  44. mysql and monitoring
  45. How do I create a new user?
  46. function both exists and doesn't exist
  47. subquery fails, i don't think an outer join will work
  48. Accessing Database on another PC
  49. Help Me
  50. Adding 10 hours to specific time
  51. Data from 2 columns
  52. Index Join without temporary tables
  53. bussiness logic - how to develop in mysql
  54. iterating over fetched tablenames ?
  55. Everything about MySQL Certification
  56. Slow connections
  57. How stable is MySQL ?
  58. Selective inserts or something?!?
  59. Select second max record..
  60. Performance comparison between mutliple tables and multiple databases
  61. Unique constraint across columns?
  62. unable to use aliases in SELECT
  63. Trace SQL Statements
  64. [MySQL 5] DBDesigner 4
  65. MySQL
  66. how do you know which indexes are actually used
  67. How to enforce an ENUM ?
  68. Unique constraint for the columns does not work when one of values is null.
  69. Performance Problems With JOINS - Tunnng required or upgrade hardware?
  70. Profiling (not racial)
  71. MySQL table got temporarily locked up? how to monitor this kind of event?
  72. newbie: installing MySQL Connetor .NET driver in Ubuntu Linux
  73. newbie: "using System.Data.MySql" in Mono
  74. Irregular stored proc results giving me headaches, please help
  75. Table design
  76. Converting Query from MSSQL to MySQL
  77. adding LIMIT 1 to improve performance?
  78. free tool to dreate ER diagram
  79. Help needed with SQL query.
  80. updating with regexp
  81. compute the ratio from two tables with a common column
  82. CREATE PROCEDURE
  83. Does the password in the ConnectionString travel encrypted?
  84. Counting Query Problem
  85. mysql < dumpfile.sql problem
  86. Combining Queries
  87. making mysqldump faster, or an alternative backup?
  88. charset problem... sigh
  89. Workaround for missing "DROP USER IF EXISTS" ?
  90. Select number
  91. Ordered lists
  92. Selecting rows from a table based on the highest value in a field
  93. Newbie: Indexing Words from a Field
  94. mysql format function
  95. Good Solid Books on SQL?
  96. Different behavior when using aliases in 4.1.21 vs. 4.1.22 version
  97. character encoding problems with export/import
  98. JOB: MySQL DBA, London, UK
  99. function and procedure
  100. help about 'on query cache'
  101. Getting a list of updated rows?
  102. Query too slow, please help optimize
  103. How many of one string in another
  104. Searching Google n-gram corpus?
  105. External web access to mysql
  106. what can this be ?
  107. JOINing derived tables, with incomplete records
  108. Problem of "Incorrect information in file: '.\xxx\xxx.frm'"?
  109. Order by the biggest of 2 fields
  110. prepare statement with date parameter
  111. SQL query to get UP and Down jobs ignoring subseqent dups
  112. MySQL PHP Code problem. Please help!
  113. MySQL Performance issues
  114. is it better to not index a high-write, low-read table?
  115. my.cnf and default charsets
  116. I'm Sorry To Ask, But I'm Stumped
  117. LOAD DATA INFILE fails
  118. mysqldump error
  119. returning only numerical portion of varcar
  120. Most basic php/mysql test?
  121. replace non numerical caracters in field
  122. 'unauthenticated user' x 100 in SHOW PROCESSLIST
  123. name and surname in a single field
  124. how to write sql to map attributes in one table to attributes in another table?
  125. Group by Top x ?
  126. mysql performance
  127. Vista
  128. displaying grouped items when using count()
  129. server time != my time
  130. INSERT and SELECT how can I do this.
  131. error in starting mysql server ...
  132. Multiple threads connection
  133. Is MySQL more ansi compatible now?
  134. ANN: DBForms from MS Access to PHP + MySQL v.2.1.1 released
  135. Best way to get the SUM/GROUP BY and ORDER BY
  136. Update Statement Continues to give me an error
  137. Moving a database between 5.0 and 5.1
  138. TRUNCATE TABLE * ?
  139. SQL Select statement
  140. Installed MySQL - updating charsets
  141. MySql Performance with 60.000.000 of records stored in longtext
  142. JOB: MySQL DBA/ DATA ARCHITECT - London, UNITED KINGDOM
  143. Query help please!
  144. mysql stored proc date param calling problem
  145. mySQL change default date format
  146. mysql_connect : Problem connection
  147. Finding number of days between dates
  148. UUID datatype
  149. mysql services not started
  150. UPDATE ON DUPLICATE KEY DELETE ?
  151. Finding row entries with no matching entry in a second table
  152. Reset AutoIncrement Index?
  153. Max length of text in a column..
  154. Looking for a C/C++ DB SQL library
  155. Finding missing entries between two tables linked by a link table
  156. syntax for update table with primary key
  157. designing a survey table
  158. Query caching issue
  159. Multiple statements
  160. mysql installation issue
  161. User Access Rights in SELECT Query
  162. Create table statement doesn't accept extra comma
  163. my.cnf tune for extra large
  164. MI5 Persecution: GLR: David Hepworth (21/Feb/1997) (2435)
  165. MI5 Persecution: GLR: David Hepworth (9/May/1997) (3658)
  166. MI5 Persecution: Capital Radio (11/April/1997) (4881)
  167. MI5 Persecution: Neil Fox (March/1998) (6104)
  168. trouble MySQL AES_ENCRYPT() using PHP for SQL statement
  169. How to query words
  170. Help making a query more selective
  171. Categories, subcategories table design
  172. MI5 Persecution: Chris Tarrant - 10/March/1999 (1212)
  173. MI5 Persecution: Nicholas Witchell - 10/April/1999 (2435)
  174. MI5 Persecution: England expects every man to do his duty (3658)
  175. MI5 Persecution: C4 SnowMail - January/2001 (4881)
  176. MI5 Persecution: BBC-TV See You, See Me - 7/Dec/2001 (6104)
  177. MI5 Persecution: Channel Four TV News - 10/April/2002 (7327)
  178. MI5 Persecution: BBC1 TV News - 18/Dec/2002 (8550)
  179. MI5 Persecution: Life is so hard (1212)
  180. making this query run faster?
  181. copy or cp??
  182. Can't connect to local MySQL server through socket '/tmp/mysql.sock' (46)
  183. Mysql -> LIKE?
  184. Help with a query
  185. create an auto_increment key in a table
  186. Extracting and inserting a null value
  187. Access denied for user: root@localhost
  188. Timestamp field ignores supplied value
  189. Need help to merge 2 queries.
  190. Join of two tables with poor design
  191. limit seems to cause rows to be missed when used with like clause
  192. was open -- how did it get closed????
  193. updating table..
  194. Oracle to MySQL
  195. Report su stampante ad aghi lentissimo
  196. Error 2
  197. MI5 Persecution: Dimbleby / John Major, April 1997 (4881)
  198. MI5 Persecution: Channel Four TV News - 12/Feb/1999 (6104)
  199. Store Hindi Text in mysql table column
  200. libmysql.lib link problem in Visaual C++
  201. Are versions of MySQL above 4.0.25 unsafe?
  202. SELECT help: union of a join with an implicit self-relation.
  203. unusual behaiour with MySQL LIKE and LEFT join
  204. INNODB problems
  205. How To create an array styled selection? Maybe with Procedures or JOINs??
  206. MI5 Persecution: Ken Clarke (2), April 1997 (3658)
  207. MI5 Persecution: Excellent web page 19/10/96 (7327)
  208. MI5 Persecution: WTGROMT 18/11/96 (8550)
  209. MI5 Persecution: No Justice 20/11/96 (9773)
  210. MI5 Persecution: Striking out action 10/3/97 (12219)
  211. How to reorder a string on the fly within a sql query
  212. MI5 Persecution: I am being ignored 17/4/97 (13442)
  213. MI5 Persecution: Peak Practice 26/4/97 (14665)
  214. MI5 Persecution: Continuing Silence 9/5/97 (15888)
  215. MI5 Persecution: Victor Lewis-Smith 9/5/97 (17111)
  216. MI5 Persecution: David Hepworth (2) 16/5/97 (18334)
  217. MI5 Persecution: Overview (1212)
  218. MI5 Persecution: Ken Clarke (1), April 1997 (2435)
  219. A quick question on database structure.
  220. MI5 Persecution: Just too crazy 30/9/96 (4881)
  221. MI5 Persecution: Fitted up 26/4/96 (1212)
  222. MI5 Persecution: Bernard Levin 1/6/96 (2435)
  223. MI5 Persecution: alt.fan.mike-corley 6/6/96 (3658)
  224. MI5 Persecution: Old_500 5/7/96 (4881)
  225. MI5 Persecution: Silly-billy 6/7/96 (6104)
  226. MI5 Persecution: Silly-billy 6/7/96 (1212)
  227. MI5 Persecution: BBC+ITN=MI5 23/7/96 (2435)
  228. MI5 Persecution: Latest technology 31/7/96 (3658)
  229. MI5 Persecution: Usual targets of such abuse 10/10/96 (6104)
  230. Most Efficient RecordExists Query
  231. default value linked value
  232. about INDEX...
  233. MI5 Persecution: Fitted up 26/4/96 (1212)
  234. how to get data out of old application
  235. Kind of fallback in SELECT
  236. AES encrypt/decrypt character encoding problem using Java / JDBC
  237. Joins
  238. I Can't Find My Syntax Error
  239. Super easy questions about syntax
  240. What is wrong this query ?
  241. MySQL + 2 Tables Query
  242. need a result from two tables
  243. VIEWs: Can this be done?
  244. Displaying a single cell
  245. joining many tables together while searching
  246. ANN: MicroOLAP Database Designer for MySQL 1.9.5 has been released
  247. Why is this not partitioning?
  248. Which is more efficient, regarding indexes and bigints...
  249. Query don't givet row name back
  250. standard and easy way to do schema design