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. Problem: Displaying MySQL TEXT datatype in C program
  2. Mysql: access denied
  3. two-way replication
  4. Uploading images in MySQL DB using PHP Script
  5. Select Query Help
  6. Delete record
  7. Hey did you forget about today??
  8. mySQL getting .csv file exported to different server
  9. persistant mysql/odbc error
  10. dumping specific inserts
  11. select sum() question
  12. FOR YOUR CONSIDERATION.
  13. Pitfalls for upgrading: 3.23 => 4.1
  14. Upgrading to MySQL 4.0 from MySQL 3.23 - Problems with MySQL Client Install
  15. How to correctly install ByteFX in IDE?
  16. cant select more than 1000 records
  17. Selecting between dates with different timestamps
  18. Help with join, delete
  19. Communication failure during handshake. 4.1 Java
  20. Clay stricken
  21. memory alignment in MySQL
  22. mysqld_safe not so safe!
  23. Finding nearest string match for browsing
  24. using INTERSECT/JOIN on same table in a loop
  25. Sleeping threads even with wait_timeout on Server2003/XP
  26. connection
  27. Date format problem...
  28. How to make MySQL bind to 2 of 3 NIC's?
  29. php5 & mysql 5 install problems
  30. Winmysqladmin?
  31. Can't access created DB's via PHP, though can access them via phpMyAdmin
  32. VB app for MySQL backup files
  33. Very strange table JOIN
  34. recover a database just from the filesystem.
  35. I want to leave a foreign key null in MySQL database
  36. database conversion
  37. Problem: Displaying MySQL TEXT datatype in C program
  38. FOR YOUR CONSIDERATION.
  39. Problem: Displaying TEXT datatype with C program
  40. Can you drop the index created by MySQL for the primary key?
  41. two-way replication
  42. Uploading images in MySQL DB using PHP Script
  43. Select Query Help
  44. how to call a procedure?
  45. Delete record
  46. persistant mysql/odbc error
  47. Importing headers
  48. select sum() question
  49. mysql+firewall
  50. FOR YOUR CONSIDERATION.
  51. cant select more than 1000 records
  52. MySQL and Pervasive
  53. How to correctly install ByteFX in IDE?
  54. encode and decode
  55. Downgrading MySQL version
  56. Help with join, delete
  57. Communication failure during handshake. 4.1 Java
  58. FOR YOUR CONSIDERATION.
  59. Moving text in a string within a row
  60. memory alignment in MySQL
  61. Finding nearest string match for browsing
  62. Retreiving large query results in chunks
  63. Sleeping threads even with wait_timeout on Server2003/XP
  64. Date format problem...
  65. Alter a primary key auto increment column?
  66. Very strange table JOIN
  67. Can't access created DB's via PHP, though can access them via phpMyAdmin
  68. database conversion
  69. FOR YOUR CONSIDERATION.
  70. Reasonable delete alternative to subqueries?
  71. Can you drop the index created by MySQL for the primary key?
  72. how to call a procedure?
  73. ODBC w/ password
  74. SQL statement question
  75. Importing headers
  76. "Complicated" SQL query
  77. Which type to choose: INNODB or MyISAM?
  78. mysql+firewall
  79. How to create fulltext indexes in MySQL 3.23.58?
  80. complicated select!
  81. MySQL and Pervasive
  82. Can MySql have multiple datadir's ?
  83. encode and decode
  84. Downgrading MySQL version
  85. FOR YOUR CONSIDERATION.
  86. Format of tables
  87. Moving text in a string within a row
  88. Do I need INDEXes when a UNIQUE has been set?
  89. MySQL sequential processing
  90. Retreiving large query results in chunks
  91. odd characters in SQL queries doing odd things to putty
  92. Reccount
  93. Code Generators
  94. Alter a primary key auto increment column?
  95. Reasonable delete alternative to subqueries?
  96. Problem using MyODBC (Linux version) - bracketed UNION
  97. ODBC w/ password
  98. "Complicated" SQL query
  99. SQL statement question
  100. Which type to choose: INNODB or MyISAM?
  101. Delivery reports about your e-mail
  102. How to create fulltext indexes in MySQL 3.23.58?
  103. complicated select!
  104. URGENT SECURITY ISSUE on MySQL users ?
  105. All activity on database locked
  106. Can MySql have multiple datadir's ?
  107. Format of tables
  108. Do I need INDEXes when a UNIQUE has been set?
  109. MySQL sequential processing
  110. FOR YOUR CONSIDERATION.
  111. odd characters in SQL queries doing odd things to putty
  112. Code Generators
  113. Unique row question
  114. Reccount
  115. mysql on mandrake 10 problems
  116. like statement
  117. Problem using MyODBC (Linux version) - bracketed UNION
  118. GROUP BY IP Address Range
  119. Delivery reports about your e-mail
  120. URGENT SECURITY ISSUE on MySQL users ?
  121. All activity on database locked
  122. The Right Place At The Right Time Exactly!
  123. FOR YOUR CONSIDERATION.
  124. characters that must be escaped
  125. open source
  126. Unique row question
  127. how to show comment on columns
  128. mysql on mandrake 10 problems
  129. like statement
  130. GROUP BY IP Address Range
  131. Adding literal text to a query
  132. Using table A column row data for table B column headings
  133. The Right Place At The Right Time Exactly!
  134. HELP !! - MySQL version 4 query slowing killing me
  135. characters that must be escaped
  136. Profitable Business
  137. open source
  138. how to show comment on columns
  139. COMMENTS in columns
  140. Problem with ODBC Connector
  141. Adding literal text to a query
  142. Using table A column row data for table B column headings
  143. HELP !! - MySQL version 4 query slowing killing me
  144. Profitable Business
  145. FOR YOUR CONSIDERATION.
  146. FOR YOUR CONSIDERATION.
  147. Problem with ODBC Connector
  148. COMMENTS in columns
  149. MySQL error message
  150. MySql licensing for web site developement : unclear and confusing!
  151. How to force to read the my.ini file in windows - while starting the server
  152. FOR YOUR CONSIDERATION.
  153. ERD again
  154. FOR YOUR CONSIDERATION.
  155. MySQL error message
  156. MySql licensing for web site developement : unclear and confusing!
  157. How to force to read the my.ini file in windows - while starting the server
  158. Conversion of Access97 to MySQL
  159. ERD again
  160. Conversion of Access97 to MySQL
  161. Selecting 1 Record per Foreign Key
  162. connection via MySQLCC
  163. How to handle line breaks when storing textarea entry in a database?
  164. Selecting 1 Record per Foreign Key
  165. How to handle line breaks when storing textarea entry in a database?
  166. connection via MySQLCC
  167. Accessing MySQL with OpenOffice
  168. FOR YOUR CONSIDERATION.
  169. Accessing MySQL with OpenOffice
  170. FOR YOUR CONSIDERATION.
  171. What is the sql way to restrict "superadmin" priv to one user?
  172. Problem with MySQL Connection/J
  173. FOR YOUR CONSIDERATION.
  174. Problem with MySQL Connection/J
  175. Where to put the imagedata in CMS?
  176. What is the sql way to restrict "superadmin" priv to one user?
  177. Where to put the imagedata in CMS?
  178. retrieving new record ID?
  179. retrieving new record ID?
  180. Cant connect to database - please help!
  181. complicated SQL for MySQL
  182. Can't connect to mysql server with J Connector.
  183. Opinions of Pogo's Dataware 2600
  184. trying to get it up and running
  185. mysql cluster in what package(s)?
  186. Can't connect to mysql server with J Connector.
  187. subquery help
  188. Opinions of Pogo's Dataware 2600
  189. Can this format be created?
  190. mysql cluster in what package(s)?
  191. trying to get it up and running
  192. Can this format be created?
  193. subquery help
  194. members
  195. Consistency among multiple connections
  196. fulltext search - doc, xls, pdf
  197. My SQL array and PHP
  198. Join Problem...
  199. members
  200. exported mysql database with TMD file?
  201. Consistency among multiple connections
  202. fulltext search - doc, xls, pdf
  203. My SQL array and PHP
  204. Join Problem...
  205. exported mysql database with TMD file?
  206. Select into Outfile
  207. FOR YOUR CONSIDERATION.
  208. date field saved as 0000-00-00
  209. Database last modified
  210. Incremental db backup?
  211. Lost username and password to MySQL server....
  212. Select into Outfile
  213. FOR YOUR CONSIDERATION.
  214. is there a addslashes()-type function in mysql or sql
  215. date field saved as 0000-00-00
  216. Database last modified
  217. ignoring NULLs in indexes
  218. MySQL Tips and Tricks
  219. MATCH - AGAINST query issue
  220. Incremental db backup?
  221. How to get the time spent on a request from PHP?
  222. Lost username and password to MySQL server....
  223. connection error
  224. is there a addslashes()-type function in mysql or sql
  225. Front-end to create reports and queries, and to load data into thedatabase
  226. ignoring NULLs in indexes
  227. How do i change max_connections and wait_timeout variables globally (for good)
  228. MATCH - AGAINST query issue
  229. MySQL Tips and Tricks
  230. REPLY ME
  231. preventing 2 simultaneous mysql update from a GUI
  232. MYSQL won't start after re-boot
  233. How to get the time spent on a request from PHP?
  234. INSERT... SELECT.. with ON DUPLICATE KEY... Is this possible?
  235. connection error
  236. Selecting specific records from a table
  237. mySQL Remote Backups - No Access to FTP or Remote Command Line
  238. Strange access denied problem
  239. square
  240. Use of AS in SELECT
  241. Front-end to create reports and queries, and to load data into thedatabase
  242. PASSIONATE APPEAL
  243. How do i change max_connections and wait_timeout variables globally (for good)
  244. REPLY ME
  245. How about Views?
  246. preventing 2 simultaneous mysql update from a GUI
  247. Error 1146: Table does not exist
  248. MYSQL won't start after re-boot
  249. SQLColumns function and MySQL ODBC driver
  250. PASSIONATE APPEAL
  251. PRI
  252. INSERT... SELECT.. with ON DUPLICATE KEY... Is this possible?
  253. Charge your Mobile Phone Anywhere, Anytime
  254. FOR YOUR CONSIDERATION.
  255. password for Mysql table ?
  256. command line for sql script
  257. MySQL and error 1044
  258. pconnect() follow up question
  259. mysql_Numrows($query) gives a warning!
  260. oracle - mysql comparison
  261. ORDER BY with match() doesn't work
  262. Get total number of results but still use LIMIT?
  263. Client area and login
  264. Q: Alter
  265. Backup/Restore MySQL databases.
  266. help needed - trimming InnoDB database size
  267. select question that gives me headache
  268. Speed Question
  269. [4.0.20] set character set / bug in replication?
  270. Variable as table name?
  271. Java Null Values
  272. LEFT JOIN returning NULL values?
  273. PHP and IPTC
  274. MySQL client question
  275. Data Transformation : SQL to MySQL
  276. MySQL & Clustering
  277. How can i avoid a subquery here..
  278. ODBC Drivers
  279. real NEWb question.....
  280. Need your help
  281. Query across multiple tables??
  282. Smile to see the world becomes better! ;-) style
  283. mysql select problem
  284. FOR YOUR CONSIDERATION
  285. Error Select data into file (german) :-(((
  286. Fulltext search loading down my server
  287. MySQL setup, Another twist - To mysqldump restoration ?
  288. loading text fields into tables -help
  289. Is TEXT slower than VARCHAR if the same data is held in both?
  290. Error on - Restoring from full mysqldump
  291. 2 left joins of the same table
  292. Where to ask C API questions
  293. FOR YOUR KIND CONSIDERATION
  294. How to create an index of my database.
  295. encode question
  296. MyODBC and Citrix
  297. Problem getting PHP to recognize MySQL, Using PHP 4.3.7 and MySQL 4.0.20
  298. Grant "optimize" difference in 4.0.14 and 4.0.16 ?
  299. PHP and MySQL
  300. How long does MySQL certification take?
  301. how to use Java connector?
  302. 100 processes...server hangs..??
  303. No connection established (PHP)
  304. How to redisplay data from MySQL
  305. BLOBs and VARCHAR?
  306. A query to select a column when a percentage of values non-zero?
  307. help mysql - cant do anything
  308. verifying mysql writes (perl)
  309. Best alternative for an INTERSECT?
  310. Column restruction
  311. FOR YOUR CONSIDERATION
  312. huge database with 800 customers / 3.500 products
  313. Mysql shrill
  314. recovery from server crash
  315. php-mysql
  316. i586 binaries
  317. Friend Query
  318. MySQL error (*not* 1067) soon after startup on XP Pro
  319. Mysql large table SLOW (3 gig table, 3 days to reindex)
  320. Elapsed time between 2 DateTime values
  321. Full text practices
  322. Upgrade Issues
  323. MySQL gethostbyname_r error
  324. CAST / Date_FORMAT function
  325. Importing a MySQL Database from .frm, .myi and .myd files
  326. Can you help me?
  327. Problem with 'load data local infile'
  328. Primary key & index ?
  329. Manual for C API incomplete?
  330. Open Source Business Object Server
  331. Question about the LIMIT clause
  332. Table and/or Database Creation Time
  333. how to carry out a conditional revoke
  334. Relational Database Question
  335. optimize table with LOCAL arg
  336. Optimize table (run for all tables)
  337. Linking problem
  338. MySQL 4.020c (Windows) service startup error
  339. HELP! having BIG problems with mysqldump and backup script....
  340. ODBC 3.51 + ADO + MySQL Solaris server -> Unwanted Select * from..
  341. benchmarks of runtime versions of mysql or other sql versions sqlite hsqldb
  342. restricted rights for admin: only create/drop db and grant options on new db
  343. weird query cache numbers
  344. UDFs in Mysql
  345. MySQL Resilience
  346. Mysql+php+apache soft
  347. MyIsam DB to InnoDB...
  348. Specify codepage
  349. Can't create index... 1044
  350. Foreign keys in mysql
  351. SQL sentence doesn´t work
  352. amd64 mysql hang woes
  353. benchmarks mysql vs sql runtime engines (sqlite & hsql)
  354. Sort by time in text string field (hh:mm:am/pm format)
  355. maxdb 7.5 / automatic database extension
  356. LOAD DATA LOCAL INFILE and Perl DBI/DBD
  357. Q: Adding columns and data
  358. Client notification of DB add/update
  359. possible to shift and splice colums?
  360. winmysqladmin.exe startup problem
  361. Troubles w/ mysql installation, "create" cannot make innodb
  362. need help with select and join for multiple tables
  363. Derived Table with GROUP BY and ORDER BY assistance needed
  364. Using MySQL C API in Visual C++ .Net
  365. Monitoring MYSQL use
  366. SQL question
  367. Logging on and off MySQL
  368. SELECT: Can someone help? This is annoying me!
  369. DB questions about null and the text data type
  370. Left Outer Join with clause
  371. Document a mySql database
  372. On Windows, phpmyadmin creates a trashed gzip file
  373. Problem migrating large db from one server to another
  374. connection error - errno 4
  375. Updates and UDF statements
  376. Improve our society/culture [DB admin WANTED]
  377. How to import a complete db
  378. Stored Procedure
  379. Arrays & storage.....
  380. New to MYSQL
  381. Search two columns in one table
  382. mysql-front over ssh
  383. auto-increments
  384. Testing SSL Conections w/ MYSQL
  385. PASSIONATE APPEAL.
  386. Replacing subselect with joins
  387. Best or most efficient search query (find_in_set or full-text) ?
  388. Need Help creating this Table
  389. Error 2013: Lost connection to MySQL server during query
  390. Verifying Data Integrity
  391. Temporary Tables in MySQL (using php)
  392. slow query log not staying on
  393. mySQL setup on XP localhost?
  394. Select statement help
  395. indexes w/ descending order
  396. Joins
  397. Need a helping hand?
  398. DBD::mysql tests failing: symb unresolved: net_buffer_length
  399. [Q] Backing up a MySql Database
  400. Access gives me the correct results, but MySQL does not?
  401. Calculate number of rows
  402. FYI: Referential Integrity with InnoDB tables
  403. Trouble executing script from command line
  404. MySQL packet structure
  405. Finetuning mysql query!
  406. Access to MySql
  407. Returned mail: User unknown
  408. guid?
  409. adding a foreigner
  410. timestamp problem
  411. Connector/J using JSP not happy???
  412. help install
  413. test
  414. install mysql problems
  415. help with install and startup mysql
  416. speeding up a REALLY slow querey?
  417. FYI: Connect and Select from Java on Linux
  418. Sorting numbers?
  419. alter table query
  420. INSERTing Line Breaks into MySQL DB using ASP
  421. Undeliverable:
  422. MySQL Database server licensing
  423. How to store and read chinese characters
  424. Removing a row when compared to another database or text file.
  425. mysql set up problem
  426. Incredible software deals eggplant dahlias behind 083
  427. Which table is foreign key constraint on
  428. parent-child sophisticated SQL query?
  429. SQL Statement Replce text in a column
  430. Tables readonly
  431. phpMyAdmin w 2 versions, 1 logs in, 1 don't
  432. do standard SQL and mySQL-specific commands overlap?
  433. One more question: why no mysql table?
  434. Upgraded to 4.20a, now winmysqladmin won't run
  435. Unexpected loooong response time when asking for specific information in select
  436. cannot recover the file "/tmp/mysql.sock"
  437. Elt Command - Extracting single item from group from field
  438. A GUI as a Query builder
  439. Question about DATE type limitations
  440. User-defined Function: ERROR 2013 (HY000): Lost connection to MySQL server during query
  441. MySQL tips that I have come across
  442. Easy query problem ..:-) but not for me...
  443. Complex join
  444. Reset unknown root password
  445. query help
  446. Mysql on VIA C3?
  447. Problems using MySQL client via Apache CGI
  448. The MYISAM storage engine and the "KEY" keyword
  449. New MDA tool with MySQL support
  450. Error 1044 Access denied to database
  451. medical,pediatrics,doctors American directoty
  452. order by specific values
  453. Tracking record insertion and deletion
  454. INSER / DOUPLICATE
  455. starting a new database/script
  456. Load balancing
  457. No CNF files
  458. mysql killing the connection after X seconds?
  459. REQ: MySQL 4.0 equivilent of "DateDiff("m", Date, Now())=1"
  460. help with select statement where time <= 5min ago
  461. help with select statement where time <= 5min ago
  462. query query :-)
  463. Multi-tables LEFT JOIN problem
  464. How to hint MySQL which indexes use?
  465. PHPList email imports
  466. Optimize a MySQL OR query
  467. mysql + chroot = CRASH
  468. best way to format html
  469. Spying on database
  470. How to break a long query into shorter ones?
  471. Granting Access to Other Users
  472. max_connect_errors
  473. weird terminal display problems with encrypted passwords
  474. Relationship of MySQL and MaxDB
  475. MySQL's autocommit
  476. SQL index problem
  477. Mysql-win32
  478. Two tables and two relations problem
  479. Limits for TABLES in DATABASE?
  480. Host is not allowed to connect
  481. stock selector
  482. NumberFormatException: For string 'localhost'
  483. Help setting up MySQL
  484. delimiter
  485. Debian - MySql3.23 - innodb issue...help.
  486. mysql licensing issues help!
  487. performance question
  488. A hash at the end of a fieldname does not work
  489. Performing a SQL statement
  490. preparedStatement issue
  491. incrementing a value in a field
  492. Help moving data base from /var to home directory.
  493. Difference between GPL and a Commercial License of MySQL?
  494. How can I reference ID during an INSERT?
  495. 28' You have an Overdue Balance
  496. deamon fails to start in windows
  497. Compile on one mach, run on another
  498. SQL Update Statement in PHP failing
  499. Access denied with LOAD DATA INFILE
  500. Used EXPLAIN, have indexes - query still surprisingly slow
  501. MYSQL on SUSE LINUX Enterprise Server Distribution not working
  502. Access Linked Tables show #Deleted
  503. Problem with floats and decimals
  504. SQL, Count and subqueries
  505. Order By within Group By
  506. I can't start mysql server on Linux.
  507. Constraint
  508. Your employer said they can't hire you because you don't have a diploma
  509. Drop & Rebuild Index Failure
  510. Frontt-end for mysql in client-server setup
  511. Wanted: Help with php/mysql project - charitable effort
  512. Schemaball v0.10
  513. how to rewrite this without subqueries?
  514. MySQL deviations w/ ANSI SQL standards
  515. Replicating 5 tables out of 4000+
  516. Is having internet port 3306 open safe?
  517. What happened to this file '/tmp/mysql.sock'
  518. Problem setting up a user and password
  519. Can I learn MySQL in 1 month?
  520. Date format
  521. Spanning DB over multiple machines
  522. Return rows which satisfy BOTH of my WHERE CLAUSES, not EITHER???
  523. where is my.cnf in redhat?
  524. Tilley
  525. Database Report Generator - beta testers needed
  526. help with error
  527. saving databases in user directories; is there a better way?
  528. Why while loop want query more than once?
  529. Update query syntax question (probably easy)
  530. MySQL eventually brings system to a halt
  531. MySQL 4.0.1 fulltext search relevancy problem
  532. random 11004 errors.
  533. MySQL Cluster
  534. 'show warnings' is not recognized
  535. ERROR 3: Error writing file '/tmp/STcgTgD3' (Errcode: 28)
  536. Double count problem. Who can help?
  537. Get list (count) of records with duplicate field content
  538. SSL Encryption
  539. Federal Provincial Subsidies
  540. Looking for encryption tool
  541. MySQL and MSSql 7
  542. linking asp.net and mysql
  543. timing out problem?
  544. Can't connect to local MySQL
  545. MySQL ODBC 3.51 Driver: Unknown MySQL Server Host (11004)
  546. date and time stamp a changed row
  547. Relevance Algorithm
  548. uninstall MySQL RPM
  549. MySQL query problem
  550. mysql string comparison