View Full Version : mysql answers


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

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