View Full Version : answers

Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 [18] 19 20
  1. Is this legal sql code ?
  2. How to get the total number of rows with a query "limit" ?
  3. Matching escaped strings
  4. MySQL Installation Challenges
  5. Matching escaped strings
  6. MySQL Installation Challenges
  7. AW: mutual declarations produce Error 1064
  8. mysql build problem (fwd)
  9. How to get the total number of rows with a query "limit" ?
  10. Is this legal sql code ?
  11. How to get the total number of rows with a query "limit" ?
  12. AW: mutual declarations produce Error 1064
  13. fulltext searching
  14. fulltext searching
  15. Accessing Mysql after fresh installation
  16. Import Database from MySQL3.x to MySQL 4.x
  17. Import Database from MySQL3.x to MySQL 4.x
  18. sub queries in mysql?
  19. sub queries in mysql?
  20. Performance MySQL with ADO VB
  21. non-standard characters shown wrong in generated emails but not on the web
  22. Performance MySQL with ADO VB
  23. non-standard characters shown wrong in generated emails but not on the web
  24. Sppeding up on ORed coloumns query
  25. Reading table structure and data from sql file.
  26. Reading table structure and data from sql file.
  27. efficient placement of fields
  28. Fwd: Dynamic enabling of log files
  29. Fixing autoincrement
  30. Running Total of a column on a SELECT
  31. Multiple items in an ALTER TABLE statement
  32. Joins and Unions
  33. Tricky INSERT
  34. alter table froze entire machine!
  35. symlinking tables to a new db
  36. Difference of GROUP BY + ORDER BY
  37. Foreign Key Constraints
  38. Designing a secure database?
  39. backups of raw db files - indexes needed?
  40. Problem with indexes ?
  41. backups of raw db files - indexes needed?
  42. Problem with indexes ?
  43. How to optimize this query ?
  44. A final Windows MySQL PHP plea
  45. table corruption problem on 4.0.14
  46. table corruption problem on 4.0.14
  47. mySQL & ADO?
  48. InnoDB - mysqldump
  49. Replication Problem...
  50. replication blues
  51. Meaning of Column time in Show Processlist
  52. Multiple field updates
  53. Transferring database from one PC to other
  54. mysql insert records in the middle of database table
  55. Connect via VB
  56. order by rand()
  57. MySQL routing issue
  58. optimisation of a code
  59. Converting Sequel to MYSQL
  60. optimisation of a code
  61. access denied on individual table
  62. Reset Primary Field Counter..
  63. mysql build problem (fwd)
  64. Foreign Keys
  65. mysqlbug
  66. Foreign Keys
  67. mysqlbug
  68. q re apostraphes that are escaped...
  69. mysqld_multi don't starts groups on Linux RedHat 9
  70. mysqld_multi don't starts groups on Linux RedHat 9
  71. How to do a subquery with MySQL 4.0 ?
  72. Form values are truncated
  73. How to do a subquery with MySQL 4.0 ?
  74. Form values are truncated
  75. Form values are truncated
  76. Select match from a stored delimitated string?
  77. Select match from a stored delimitated string?
  78. Tomcat+MySQL. Intermitent DbcpException: Server configuration denies access to data source
  79. Tomcat+MySQL. Intermitent DbcpException: Server configuration denies access to data source
  80. Random Errors in Replication Binlog
  81. Random Errors in Replication Binlog
  82. Password formats 3.23-4.x
  83. Help debugging this Query?
  84. Password formats 3.23-4.x
  85. Help debugging this Query?
  86. MySQL Replication
  87. MySQL Replication
  88. Quick ones to speed up acces!
  89. Quick ones to speed up acces!
  90. libmysqlclient.so.10 is needed by (installed) mod_auth_mysql-1.11-12
  91. libmysqlclient.so.10 is needed by (installed) mod_auth_mysql-1.11-12
  92. the logic of full text search
  93. ERROR 1045: Access denied
  94. the logic of full text search
  95. Text File
  96. Error 127, some questions
  97. Text File
  98. ERROR 1045: Access denied
  99. Error 127, some questions
  100. Fw: Mysqld dead subsys locked
  101. Mysqld dead subsys locked
  102. Please Help
  103. Fw: Mysqld dead subsys locked
  104. Mysqld dead subsys locked
  105. Please Help
  106. Help with count(*)
  107. Checking the mysql status
  108. Checking the mysql status
  109. Help with count(*)
  110. Problem with date query
  111. Int fields...
  112. Problem with date query
  113. Whats wrong.
  114. Int fields...
  115. Searching for rows that depend on other rows in some fashion...
  116. Whats wrong.
  117. Remote connection
  118. Reset Database
  119. Searching for rows that depend on other rows in some fashion...
  120. Reset Database
  121. csv --> mysql
  122. Remote connection
  123. csv --> mysql
  124. grant select temporary.
  125. Can't connect to local MySQL question
  126. Can't connect to local MySQL question
  127. REQ: MySQL Query Syntax Error
  128. grant select temporary.
  129. REQ: MySQL Query Syntax Error
  130. Insert file data into text field
  131. UnixODBC Perf Question
  132. UnixODBC Perf Question
  133. Extract data and create database:
  134. Extract data and create database:
  135. Filtering special-chars
  136. check it!
  137. Filtering special-chars
  138. check it!
  139. Dirk Kunischewski/UK/IBM is out of the office.
  140. Dirk Kunischewski/UK/IBM is out of the office.
  141. quick q
  142. quick q
  143. Updating table based upon matching field in second table
  144. microsof
  145. Updating table based upon matching field in second table
  146. microsof
  147. Hardware recommendation
  148. read_const error 127 - then MySQL dies
  149. FW: Can MySQL 4.0.14 store HTML? Among other things....
  150. FW: Can MySQL 4.0.14 store HTML? Among other things....
  151. Can MySQL 4.0.14 store HTML? Among other things....
  152. FW: mysql LOAD DATA INFILE
  153. Can MySQL 4.0.14 store HTML? Among other things....
  154. Is there trigger function in MySQL ?
  155. mysql w/ mod_perl
  156. Date Problem
  157. "show slave status" returns nothing
  158. "show slave status" returns nothing
  159. 4.0.14 runs CPU usage up and eventually stop
  160. Importing data from text files
  161. 4.0.14 runs CPU usage up and eventually stop
  162. Importing data from text files
  163. imputing missing values in MySQL?
  164. imputing missing values in MySQL?
  165. MySql Control Center
  166. MySql Control Center
  167. UDF and row data
  168. UDF and row data
  169. myodbc error
  170. myodbc error
  171. 99.9% mysqld Utilization Problem
  172. just testing
  173. 99.9% mysqld Utilization Problem
  174. Just testing please ignore
  175. Native Arabic speakers wanted
  176. Perfomance Tuning
  177. Perfomance Tuning
  178. AW: mutual declarations produce Error 1064
  179. AW: mutual declarations produce Error 1064
  180. database per user
  181. Oledb connector
  182. database per user
  183. Import edict file into mysql database with 1 table and 3 fields
  184. Import edict file into mysql database with 1 table and 3 fields
  185. Cache encrypt key for ENCRTPY/DECRYPT in a variable?
  186. Cache encrypt key for ENCRTPY/DECRYPT in a variable?
  187. Select items with same catehory as given item
  188. Select items with same catehory as given item
  189. Replication troubles
  190. Performance
  191. Performance
  192. MySQL Replication
  193. MySQL Replication
  194. MySQL Logging and encryption
  195. order by question
  196. STUMPED: How Can I Pull Related Info Using Subqueries/Joins?
  197. select count(*) Problem in PowerBuilder Thru MySQL ODBC 3.51
  198. heading off in mysql?
  199. heading off in mysql?
  200. client ignores close of connection?
  201. client ignores close of connection?
  202. Unix date problems
  203. Unix date problems
  204. myisamchk Illegal Instruction
  205. myisamchk Illegal Instruction
  206. Loading quite large amounts of data into a DB
  207. FROM_DAYS doesn't take timestamp?
  208. mysqld cannot access innodb
  209. easy-to-use
  210. Running two Servers?
  211. World Class Award, 2003
  212. InnoDB crash - recovery
  213. easy-to-use
  214. transfer InnoDb in correct order ??
  215. transfer InnoDb in correct order ??
  216. fulltext key search
  217. connection
  218. connection
  219. ERROR 1005: Can't create table './db/table.frm' (errno: 150)
  220. ERROR 1005: Can't create table './db/table.frm' (errno: 150)
  221. DB Performance - Celeron vs. P4
  222. 2 tables or 1?
  223. MySql Replication through a tunnel.
  224. preserving indexes
  225. Help with SQL statement please
  226. User that can connect from any host?
  227. User table and version
  228. Upgrading to MySQL 4.0
  229. mysql shuts down overnight
  230. Problem with merge tables in 4.1
  231. Select statement with a field name that is a number?
  232. 4.0.14 standard creating user issues
  233. Connecting to MySQL from ASP
  234. Using Temporary
  235. Users and permission
  236. Functions as default values
  237. Help!
  238. Query Problem, Confused by Left Join.
  239. replication problem
  240. How can I enable unicode and japanese support?
  241. Insert bug into MyISAM table (Linux + MySQL 3.23.56)
  242. Connections
  243. database comparison
  244. FW: table size in mysql
  245. mysql installation problem
  246. PHP / InnoDB, sources for good search ideas?
  247. mysqlbug
  248. ON UPDATE CASCADE fails
  249. Mysql won't install (crashes) on Red Hat Enterprise Linux 3 Beta 1 (Taroon)
  250. multiple databases creation
  251. Database Design
  252. Database Design
  253. column privilege problem--Solved
  254. column privilege problem
  255. column privilege problem--Solved
  256. column privilege problem
  257. reindexing
  258. reindexing
  259. Left join performance
  260. Left join performance
  261. Problem with data import from text file
  262. New Article on SET Datatype
  263. Problem with data import from text file
  264. New Article on SET Datatype
  265. win200 - lost root privilege - cannot shutdown - need help
  266. Multiple table joins in a select
  267. win200 - lost root privilege - cannot shutdown - need help
  268. Multiple table joins in a select
  269. Flush logs, binary log index file
  270. Flush logs, binary log index file
  271. SHOW STATUS confusion
  272. table size in mysql
  273. SHOW STATUS confusion
  274. table size in mysql
  275. Use Like or =
  276. Use Like or =
  277. alter date
  278. alter date
  279. storing large integers properly
  280. load data infile problem
  281. mutual declarations produce Error 1064
  282. Replication question
  283. basic SQL question
  284. MySQL 3.23.54 + update
  285. data type matching / composite key / index name
  286. Problems with spatial extensions
  287. mysql weekend crash course
  288. Using a foreign character set in MYSQL
  289. post install of 4.0 complications
  290. encrypt() problem
  291. Message
  292. Can't start up - access denied to root
  293. benchmarks
  294. Query Help
  295. benchmarks
  296. doubts
  297. File Permission
  298. Query Help
  299. File Permission
  300. doubts
  301. Unable to ADD databases
  302. Open Source Software Survey
  303. Unable to ADD databases
  304. table error 127
  305. MySQL, IIS and PHP
  306. Open Source Software Survey
  307. Replication and LOAD DATA INFILE MySQL Max 3.23.56-1
  308. Error after upgrading to 4.1.0-alpha-max-debug LibMySQL.dll missing
  309. table error 127
  310. MySQL, IIS and PHP
  311. Extensions for MySQL in C not MySQL API
  312. Replication and LOAD DATA INFILE MySQL Max 3.23.56-1
  313. Error after upgrading to 4.1.0-alpha-max-debug LibMySQL.dll missing
  314. Security related! Not possible to hide table structure. I couldn't find..... ?
  315. Extensions for MySQL in C not MySQL API
  316. Convert date from .txt file
  317. replication question
  318. Security related! Not possible to hide table structure. I couldn't find..... ?
  319. Convert date from .txt file
  320. How to Ask Questions the Smart Way...
  321. replication question
  322. Problem reading my.cnf
  323. how to 'tell' the select what to omit
  324. MySQL extensions in C
  325. how to upgrade mysql from 3.20 to 3.23
  326. How to Ask Questions the Smart Way...
  327. Replication problem
  328. Problem reading my.cnf
  329. MySQL extensions in C
  330. how to 'tell' the select what to omit
  331. how to upgrade mysql from 3.20 to 3.23
  332. Replication problem
  333. Creating Grant Tables on WinXP
  334. Creating Grant Tables on WinXP
  335. installation of mysql 4.0.14 on windows xp
  336. Query Cache Issues, Continued
  337. Lowering memory usage?
  338. Query Cache Issues, Continued
  339. installation of mysql 4.0.14 on windows xp
  340. Lowering memory usage?
  341. do long delete/update and view progress?
  342. do long delete/update and view progress?
  343. 3.23.56 Replication Bug
  344. 3.23.56 Replication Bug
  345. Slowing brute force attack
  346. encrypt() call on Win32
  347. Slowing brute force attack
  348. ansi characters in Fulltext search
  349. Restoring from a mysqldump
  350. ansi characters in Fulltext search
  351. ansi characters in Fulltext search
  352. MySQl data Transfer (Window --> Linux ) How ????
  353. Nested SELECT statements problem
  354. Nested SELECT statements problem
  355. SQL - identifying missing matches in two tables
  356. SQL - identifying missing matches in two tables
  357. Date to Days Query
  358. max_connections doesn't change
  359. NON web based client server applications
  360. Can't connect to local MySQL server through socket '/tmp/mysql.sock'
  361. NON web based client server applications
  362. Allowing remote login
  363. Apache-mpm
  364. Dropping primary key/unique key
  365. SQL Error : 1226 - 'max_questions' resource (current value: 10000)
  366. LOL
  367. Dropping primary key/unique key
  368. LOL
  369. retrieving rows by insertion order
  370. Changing error message
  371. retrieving rows by insertion order
  372. mysql crashes
  373. error message: C:mysqin\share\english\errmsg.sys
  374. error message: C:mysqin\share\english\errmsg.sys
  375. Order by umm OR?
  376. Order by umm OR?
  377. Telco Database
  378. Telco Database
  379. Native Arabic speakers wanted
  380. Performance questions
  381. Native Arabic speakers wanted
  382. Performance questions
  383. Need help in querying two tables
  384. Need help in querying two tables
  385. Blobs
  386. Using query file from console
  387. Blobs
  388. Using query file from console
  389. MySQL startup scripts
  390. MYSQL Scalability on SMPs
  391. Importing Tables Using MySQL Control Center
  392. my.cnf is not available under windows 2000
  393. my.cnf is not available under windows 2000
  394. to many connections
  395. to many connections
  396. Retrieving a BMP image from a binary field in the DB
  397. Retrieving a BMP image from a binary field in the DB
  398. InnoDB data file is growing
  399. InnoDB data file is growing
  400. ERROR 1005 at line 3: Can't create table '.\company\employee.frm' (errno: 150)
  401. ERROR 1005 at line 3: Can't create table '.\company\employee.frm' (errno: 150)
  402. recovery from log file
  403. Recreating MySQL server gone away Error
  404. MySQL LOAD zipped DATA from File
  405. C API AND MYSQL
  406. Connection priorisation in Mysql
  407. Searching on Two Keys with OR?
  408. Searching on Two Keys with OR?
  409. MySQL bin log question
  410. Books advice
  411. FULLTEXT Searching
  412. How does one get off of this list
  413. Help Please: Substitute Text to replace Stored Procedures for use with MySQL
  414. Update Table By ID Ranges
  415. connections aren't released?
  416. Backup conventions
  417. Storing Sensitive info in MySQL
  418. ARGGH! - User password problems
  419. Mysqld is keep crashing
  420. mysqlcc LIMIT
  421. Mysqld is keep crashing
  422. Mysqlcc vs Phpmyadmin
  423. mysql_history file?
  424. mysql_history file?
  425. max clients
  426. MySQL 4.1 Question
  427. calender table - time column?
  428. calender table - time column?
  429. Any Issues with 3.23.56 and 4.0.13 using mysqld_multi on one server
  430. Replication Issue?
  431. Replication Issue?
  432. mysql 4.1 win2000 SP3, UPDATE: bug or what?
  433. MySQL on Windows
  434. standardized naming system ?
  435. MySQL on Windows
  436. standardized naming system ?
  437. AW: I Specify explicitly TYPE = InnoDB But My SQL gives me TYPE=MyISAM ?
  438. AW: I Specify explicitly TYPE = InnoDB But My SQL gives me TYPE=MyISAM ?
  439. I Specify explicitly TYPE = InnoDB But My SQL gives me TYPE=MyISAM ?
  440. Constraints under 3.23.55-nt
  441. dropping foreign key
  442. what up
  443. dropping foreign key
  444. bug or some mistake ???
  445. help to structure query without using subselects
  446. bug or some mistake ???
  447. help to structure query without using subselects
  448. A new charset without recompiling
  449. A new charset without recompiling
  450. Problems while compiling mysql on HP-UX 11.11
  451. Mysqldaemon not starting
  452. show variables
  453. Problems while compiling mysql on HP-UX 11.11
  454. show variables
  455. eclipse/tomcat/jboss/mysql
  456. eclipse/tomcat/jboss/mysql
  457. I need help(NO NOT MENTAL HELP)
  458. I need help(NO NOT MENTAL HELP)
  459. Default character set error
  460. Default character set error
  461. replication problem
  462. replication problem
  463. INDEX'd fields...any drawbacks?
  464. INDEX'd fields...any drawbacks?
  465. Sorting question
  466. Sorting question
  467. Problem in restoring database!
  468. Problem in restoring database!
  469. CURRENT_TIMESTAMP and transactions
  470. CURRENT_TIMESTAMP and transactions
  471. Disabling special character sequences
  472. Disabling special character sequences
  473. Starting Mysql
  474. Starting Mysql
  475. Need information on copying mysql from linux to xp
  476. master-connect-retry
  477. Starting MYSQL...
  478. mysqlhotcopy problem
  479. Finding Table and database size
  480. Advice wanted on Data Structure
  481. Advice wanted on Data Structure
  482. Calculating a primary key
  483. Fulltext search not returning matches..
  484. check for duplicate databases
  485. Starting MYSQL...
  486. Error code 1064 - Cannot backup Dbase....
  487. Import databse ?
  488. Import databse ?
  489. MySQL 3.23.55 compilation errors
  490. escape character within sql statement.
  491. Why LIKE not using INDEX?
  492. DB Update -> NewFile - OldFile = UpdateFile
  493. display two columns of data with lookup from another table
  494. Benchmarking w/ Multiple Clients
  495. Missing row
  496. Benchmarking w/ Multiple Clients
  497. mysql find_in_set
  498. Missing row
  499. mysql find_in_set
  500. MySQLD Binary Log
  501. Error compiling MySQL 4.0.14 on Slackware GNU/Linux
  502. MySQLD Binary Log
  503. Fw: mysql4.1 install question
  504. Error compiling MySQL 4.0.14 on Slackware GNU/Linux
  505. Fw: mysql4.1 install question
  506. mysql4.1 install question
  507. mysql4.1 install question
  508. Really slow shutdown with Innodb, db not accessible?
  509. Basic Database Design Question
  510. Basic Database Design Question
  511. Really slow shutdown with Innodb, db not accessible?
  512. mysql vs mysqlMax
  513. Using data in one table to update data in another table
  514. mysql vs mysqlMax
  515. Help with mysql "referencing"
  516. Using data in one table to update data in another table
  517. Help with mysql "referencing"
  518. mysql vs mysqlMax
  519. Select problem
  520. problem installing mysql
  521. mysql vs mysqlMax
  522. problem installing mysql
  523. Select problem
  524. how listen queue size affect MySQL on RedHat
  525. how listen queue size affect MySQL on RedHat
  526. Check table wildcard syntax?
  527. Check table wildcard syntax?
  528. Left Join multiple tables
  529. Left Join multiple tables
  530. text search question
  531. Error code 1064 in another application...
  532. text search question
  533. mysql BUG, again ;)
  534. Error code 1064 in another application...
  535. mysql BUG, again ;)
  536. mysql on SMP CPU under RedHat
  537. affected columns
  538. mysql on SMP CPU under RedHat
  539. Rebuilding Indexs on tables
  540. affected columns
  541. affected columns
  542. utf8 in 4.1 for Windows
  543. Replication
  544. Rebuilding Indexs on tables
  545. When mysql ruinned by Disaster
  546. affected columns
  547. Problems Using UPDATE to modify multiple and non sequential records - a giant conundrum from a total novice....
  548. Replication
  549. which are the updated column?
  550. utf8 in 4.1 for Windows