InterBase (29)
MS-SQL (5)
mysql (37)
Oracle (1)
Exchange Links
About this site
General information about mysql - how to get around the differences between version 3.33 an 4, how to do stuff that you think you need a nested query for etc.
Articles:
This list is sorted by recent document popularity (not total page views).New documents will first appear at the bottom.
- mysql: How can I rename a database (122415)
- How can I rename table names and column names in mysql (28666)
- How to compare strings in mysql case sensitive (18607)
- Compare 2 dates in mysql (17702)
- Lock an entire mysql database with all its tables (14549)
- How to reset the root password on mysql (12834)
- mysql message ERROR 1054 (42S22): Unknown column in 'on clause' (11530)
- Create UNIQUE Index yields a not unique index in mysql - why? (10718)
- concat () function to concatenate 2 strings in mysql does not exist (5464)
- How to change the next value of an auto_increment field (5160)
- How can I obtain the next auto_increment number (before inserting a record)? (4270)
- My timestamp field in mysql does not update (4081)
- Problems installing DBD::mysql on Solaris 8 (3914)
- Best operating system settings for mysql throughput (3735)
- How to install mysql 5 on Solaris 8 (3711)
- Kill a long running blocking sql statement (3623)
- Handling of dates in mysql (Date formats) (3550)
- How to pick a random record from a mysql table (3260)
- Creating a table with an autoincrement primary key (3239)
- Can I install MySQL without root access? (3159)
- How to limit the size of a MySQL database (3121)
- Restoring the mysql system user table (2614)
- Setting a user password in mysql (Why do I get 'Access denied') (2417)
- What is the MERGE statement good for? (2414)
- Implementing a full text search with mysql (2392)
- Modifying a field to be auto_increment (2387)
- Extracting a table definition from the command line (2257)
- Exporting and importing between 2 mysql databases (2242)
- How can I connect to mysql? I need to update the helpdesk backend (2233)
- count(*) syntax in mysql (2230)
- Stub to connect from a C program to mysql (1994)
- count(distinct fieldname) very slow in mysql (1890)
- JDBC error message Illegal hour value for java.sql.Time type in value (1273)
- What timezone is my mysql database server running in? (1022)
- How to log all mysql database modifications (969)
- Location of mysql startup script (912)
- Monitoring mysql status (496)
Featured Article
How to pick a random record from a mysql tableQuestion: I have a huge table in mysql with suitable passwords and want to pick a word from this table. If I use a simple select statement, I always get the first word.How can I pick a random record from a mysql table (or result set, in general)? Answer: Use the order by RAND() phrase, and for performance reasons, combine it with LIMIT 1 as shown in the example below.There was a bug in older mysql versions (prior to version 4) where this RAND() phrase did not really lead to truely random results but always to the same rows after a connection was started. This has been resolved with version 4.
|
|
2019-01-22 16:13:59: by anonymous in Finances on Well-respected bank offering Payday loans: If you need to hack your cheating spouse's cell phone remotely, visit www.finessehackers@gmail.com |
|
2019-01-22 04:04:41: by [hidden] in Male Dating Scammers on Dating scammer Michael Moore: Hi I know someone who this man has tried to scam. Same story as the other times mentioned, with him early on sending a lot of details about himself and lots of pics etc.. saying that he will come visi ... read more |
|
2019-01-20 23:11:23: by anonymous in Web publishing on Getting started with CSS: No matter how old you are, family history is important. While you might not think so at the time, as you get older there will be things you and your grandchildren will want to know. Most of us don't r ... read more |
|
2019-01-19 21:15:41: by anonymous in Male Dating Scammers on Dating scammer Mike Bruce: Depende de alguns detalhes, como duração do incidente, e tipo de banco de dados que vamos cortar para limpar os registros, mas geralmente entre 300 - 500 USD |
|
2019-01-19 07:16:45: by anonymous in Other Scams on Another dating / chat scam - USA/ Nigeria connection: Hello all am looking few years that some guys comes into the market they called themselves hacker, carder or spammer they rip the peoples with different ways and it’s a badly impact to ... read more |
|
2019-01-19 02:41:59: by [hidden] in Dating Scams on Dating scammer Sandra Da_Rocha from Accra/Ghana: For many people, making money online would be an absolute dream come true. [url=  https://money-online..te]Earning money online[/url]
|
|
2019-01-18 16:27:45: by [hidden] in Dating Scams on Dating scammer Alisa: Pictures are more than 12 years old. |
|
2019-01-18 11:15:40: by [hidden] in Dating Scams on Dating scammer anastasiya: Hello there, My name is Aly and I would like to know if you would have any interest to have your website here at delphifaq.com promoted as a resource on our blog alychidesign.com ? ... read more |
|
: by in on : |
|
2019-01-17 17:45:54: by [hidden] in Dating Scams on Dating scammer winifred amposah:  ID's as an ATK EXOTICS Porn Model named 'Bianca' ID-7040 from Venezuela -- pixs are more than 10 yearts old...
|