View Full Version : MySQL


Pages : 1 2 3 [4] 5 6 7 8 9 10 11 12 13 14 15 16 17 18

  1. order of operations
  2. Help - MySQL Inconsistency
  3. Databases with only a .frm file
  4. Bug ? #1030 - Got error 139 from storage engine
  5. value by default 0
  6. Lost relationships when copying database
  7. LIKE Problem
  8. Nice backup script...
  9. Fulltext escape char
  10. MySQL Unicode Problem?
  11. Using IF
  12. selection criteria spread on multiple rows.
  13. MySQL Backup/Restore Performance issue with Large database
  14. Help with a subselect
  15. use variables in sql
  16. Synch dbs
  17. error "Can't find record in tbaleName"
  18. Greater than/Less than with numeric strings
  19. help: writing a query
  20. Best way to Do this
  21. select attributes as where parameters
  22. Will I trigger an update of the indexes?
  23. backup challenges
  24. max() and
  25. Yellowfin Business Intelligence Version 3.3 release
  26. UPDATE with JOIN breaks partial replication
  27. Need help with PHP/mysql syntax please
  28. How long are TINYTEXT, TEXT, and MEDIUMTEXT variables?
  29. UPDATE or INSERT or both
  30. use case diagrams
  31. carriage return - Chr(13) & Chr(10)
  32. optimal index for subquery
  33. MySQL LIMIT/OFFSET and JOIN
  34. How to mimic PLSQL in mysql?
  35. connect fieldname of tabel A with record 'fieldname' of file B
  36. field features...
  37. problem with simple JOIN
  38. secondary index question
  39. Is it possibe to create index without locking table?
  40. Importing multiple files
  41. Restoring mysqldump file from within c# application
  42. Connecting to localhost
  43. index question
  44. Clearing a database
  45. privileges on ndbcluster engines
  46. COUNT() - returning rows with 0 value
  47. COUNT() - returning rows with 0 value
  48. primary / unique
  49. "patch" join?
  50. MySQL file in the same directory with php files
  51. Rackspace Managed Hosting is hiring MySQL Database Administrators!
  52. Problem with query
  53. large database question: mysql large read query
  54. does "inserting" add or overwrite...?
  55. Replicate from Mysql 5.1.20 to SQL Server 2000
  56. Index merge is not performed
  57. NEED HELP: Database structure
  58. update with join
  59. multi-table delete
  60. table content rebuild - "optimal" solution
  61. Troubles with triggers in version 5.0.45
  62. Is there any newsgroup(forum) based on mysql?
  63. Dependent Subquery?
  64. SQL command to show only databases that contain a particular table
  65. granting privileges only on some rows of a table
  66. No ndb_mgmd file in the /mysql/bin/ directory
  67. Tracking Schema Changes in mySQL
  68. write conflict question
  69. Slow queries problem
  70. Is this a normal way of working, sending *.MYD, *.frm and MYI files?
  71. Report writer options for MySQL that is web based?
  72. Select for float field fails
  73. Is there such a thing as a parameterized view, or must I resort to astored procedure?
  74. Automatic killing of thread by user ID
  75. optimising table
  76. mysql info from database
  77. mySQL JOIN query help
  78. MySQL Administrator: "phantom" databases ?
  79. Any advantage to use MySQL with PHP, .Net, or Coldfusion?
  80. select inside update for same table
  81. newbie question - 0 rows affected
  82. help needed selecting from multiple tables
  83. example database of milion records
  84. Isn't there a regexp function?
  85. Count with other field
  86. return two values from the same table column in one result
  87. Minimum MySQL Requirements
  88. Performance issue with sub query
  89. automatic creation and last modification timestamps in table?
  90. Help with negative join syntax?
  91. Clustering, Security, Performance, Load Balance
  92. efficient way to determine "is there a nonzero value"
  93. updating SQL
  94. select non-existent column
  95. Comparing a backup so I can restore lost data
  96. CONCAT_WS
  97. Facing Probelm with backup and restore.....
  98. Query - Sorting alphabetically starting by certain letter number
  99. Copying raw database files
  100. When is null not null?
  101. Search entire database (logic question)
  102. if "repair" does not work?
  103. Alter table add autoincrement
  104. Stripping the from beginning of field name when it occurs
  105. Re: Asp and Mysql
  106. UPDATE which does not mention TIMESTAMP column seems to update timestamp.
  107. Question about INFORMATION_SCHEMA
  108. Comparing numeric values between rows.
  109. Uploading database from the windows command prompt
  110. Scripting the Creation of a MySQL User
  111. automate data entry from forms how can I do that ?
  112. Better way to get Max ID?
  113. Accessing MySQL tables from Excel
  114. Is it possible to implement select/update/insert within one SQLquery? Thanks
  115. Moving row from one table to another, auto_increment question
  116. how to write the SELECT query for ...
  117. Re: Help with date query
  118. RES Re: Help with date query
  119. copy record
  120. Random record from latest 10 entries...
  121. desparate - why is this join not working?
  122. How to speed Up query execution
  123. MySQL installation: Package or compiled source ?
  124. Data display issues with MS Access
  125. need urgent help
  126. Select * with multiple distinct columns
  127. get counts of psitive feedback and Negative?
  128. insert date into database
  129. How to drop Constraints from all table at once in a database
  130. Strange collation error
  131. Help with date query
  132. Cannot start mysqld and mysql
  133. identify duplicate addresses?
  134. MI5 Persecution: Faxes Sent to Media2 (8683)
  135. MI5 Persecution: Faxes Sent to Diplomatic/Legal (4333)
  136. MI5 Persecution: Faxes Sent to Media1 (6508)
  137. MI5 Persecution: Bernard Levin - The Times (32608)
  138. MI5 Persecution: Come back, Norma! (34783)
  139. MI5 Persecution: Victor Lewis-Smith (36958)
  140. returning records where date column is within a given boundary
  141. MI5 Persecution: Introduction to Sent Faxes (2158)
  142. MI5 Persecution: Clapham Junction 6/5/00 (17383)
  143. MI5 Persecution: he's an idiot you know 3/11/00 (19558)
  144. MI5 Persecution: tinker tailor wanker thief 2/12/00 (21733)
  145. MI5 Persecution: Jon Holmes (4-5/Jan/2002) (23908)
  146. Why can I use a particular field in an ON clause but not thepreceding WHERE clause?
  147. MI5 Persecution: Post Office 14/11/02 (26083)
  148. MI5 Persecution: Eclipse pub 20/12/02 (28258)
  149. MI5 Persecution: Barbican Library 6/2/2003 (30433)
  150. DSN and error DB Error: connect
  151. mysqld Can't start server: can't create PID file: Permission denied
  152. Getting count of items with more than x reviews
  153. How to export database, in readable format?
  154. Best way to work with data from multiple MySQL databases?
  155. MI5 Persecution: BA984 LHR->TXL 13/6/98 (2158)
  156. MI5 Persecution: BHS Croydon 18/12/98 (4333)
  157. MI5 Persecution: Ravenscourt Park 20/3/99 (6508)
  158. the easiest way to copy table?
  159. MI5 Persecution: Battersea Library 29/3/99 (8683)
  160. MI5 Persecution: Royal Festival Hall 15/4/99 (10858)
  161. MI5 Persecution: Balham Bus 8/7/99 (13033)
  162. MI5 Persecution: Clapham South 17/2/00 (15208)
  163. Proper Indexing of this table
  164. Need help with complicated SQL statement
  165. Deleting all rows except the first row
  166. Former MS query with joins won't run in mySQL
  167. connessione lenta MySQL 5
  168. CREATE TABLE with mediumblob, but most of the data will never be that big
  169. regex match multiple words in a line
  170. Increase by 30% the efficiency of MYSQL
  171. How to optimize primary key change on a large table?
  172. order by problem
  173. import data - how to change code page on the fly
  174. Replication or dumping database?
  175. Lock access to SP
  176. Timesheet Design Suggestions
  177. Copy column
  178. Conversion from later version
  179. Limit the insert
  180. Strange interaction between GROUP BY and EXISTS condition
  181. COLLATION 'utf8_bin' is not valid for CHARACTER SET 'binary'
  182. How do I check what collation a table is?
  183. Why is MySQL lying to me?
  184. neewbie question - looking for windows front-end app for database backend
  185. Filtering results
  186. Accessing Column Names
  187. SELECT CONCAT and WHERE clause
  188. Counting records query
  189. Several server || MYSQL databases
  190. Index of row
  191. MYSQL Localhost restriction || Multiserver Architecture
  192. MySQL: 4.1.20 DB from external servers. Why ?
  193. efficient join based on non-constant range condition?
  194. Function type CURSOR
  195. mysql truncates decimal point for float bigger than 100000
  196. MySQL Remote server || Open ports
  197. Incorrect usage of UNION and INTO
  198. Conditions and triggers
  199. what is wrong with this view script?
  200. Distant Connection to MySQL - Localhost restriction
  201. databases.mysql : Multi Server || Localhost Restrictions
  202. Performing a Deletion on a MySQL Database
  203. MYSQL for Windows 98?
  204. Need Efficent Query
  205. Can % be used in prepared statement
  206. not graphic mysql table browser
  207. Databases.mysql : Communication between DB
  208. Trigger problem - Error Code : 1064
  209. MI5 Persecution: POSK 2/2/98 (13027)
  210. MI5 Persecution: Leicester Square 9/2/98 (15201)
  211. mySQL and AutoNumbers
  212. Appending Data from MS-Access to mySQL
  213. Mysql perfomance
  214. Newbie question: How do I remove double spaces from a field?
  215. Lack of regular expression manipulation.. speed up function?
  216. Split full name in to first, middle, and last name
  217. Top x records in very large table
  218. strange DATE() problem
  219. Please help with a query before I lose my mind
  220. MI5 Persecution: Neil Fox (Nov/1998) (2157)
  221. MI5 Persecution: Flying Eye (Mar/1999) (4331)
  222. MI5 Persecution: Johnny Boy (21/Aug/1998) (6505)
  223. MI5 Persecution: Johnny Boy (19/June/1999) (8679)
  224. MI5 Persecution: Brighton 24/9/98 (10853)
  225. create table in stored procedure
  226. newbie (i mean really)
  227. Strange Input Variable Behavior
  228. Unwanted escape
  229. how to compact database table files after deleting a lot
  230. double posts/requests to mysql corrupt cached table data
  231. mysql request with regexs
  232. Group By, Limit only group?
  233. aggregating remote partitioned tables using federated tables?
  234. Running a query across collations
  235. How do I handle not found conditions?
  236. UPDATE'ing with multiple WHERES
  237. How do I filter the results of this query?
  238. SELECT CONCAT From Different Tables?
  239. Loading a tabel with extract from another tabbe!?
  240. Error while creating procedure
  241. Any way of matching partial matches against a reference string?
  242. Unusual Query Help Request
  243. Order of WHERE Clausels
  244. Re: Query Help
  245. variable data for a search
  246. MYSQL Internal tables
  247. update in trigger : same table => crash
  248. Best way to model Many-to-Many relationship?
  249. Foreign Key and relationship
  250. MySQL Query Browser help required