 |
COMPGROUPS.NET |
 Search |
 Post Question |
 Groups |
 Stream |
 About |
 Register
|
Top Users in comp.databases.mysql  luuk (815) 14 Articles, 801 Replies, 815 Points
 toby23 (1080) 20 Articles, 1060 Replies, 1080 Points
 zac.carey (380) 25 Articles, 355 Replies, 380 Points
 maustin (1437) 26 Articles, 1412 Replies, 1437 Points
 paul_lautman (2109) 15 Articles, 2096 Replies, 2109 Points
 bill152 (499) 0 Articles, 499 Replies, 499 Points
 jstucklex (14380) 5 Articles, 14373 Replies, 14380 Points
 axel.schwenke (487) 2 Articles, 485 Replies, 487 Points
 hellsop (943) 8 Articles, 935 Replies, 943 Points
 paul.lautman (522) 27 Articles, 495 Replies, 522 Points
Top Articles in comp.databases.mysql  SELECT * INTO OUTFILE fails if file exists  1
 1939 (11/20/2009 12:41:47 AM) Dear Newsgroup MYSQL won't overwrite an existing OUTFILE. How can I programmatically delete the OUTFILE? Is there a way to make the SELECT...OUTFILE overwrite the OUTFILE? Regards scooper ...   robertc47 (7) Query - Sorting alphabetically starting by certain letter number 9
1360 (11/29/2007 10:14:32 AM) Hi, I am trying to figure out a way of ordering my results alphabetically but also starting by a particular letter or number. To give an example, a user searches for the letter 'c', the query will give every ev...  support how to compact database table files after deleting a lot 2
3943 (11/10/2007 6:34:54 AM) I've just deleted 90% of the records of a table but the .MYD and .MYI files representing the data are still the same size as before. Is there a way to compact them down? Unfortunately I don't know how to get ...  bennett (89) How long are TINYTEXT, TEXT, and MEDIUMTEXT variables? 2
3455 (12/14/2007 3:28:37 AM) Hi, I need to have I column in a table where i will store text whose maximal length is 1024 characters. Which type I have to set for this column? How long are TINYTEXT, TEXT, and MEDIUMTEXT variables? Dos the ...  showandbeshown (31) consolidation of multiple rows 145
231 (3/5/2008 4:19:17 PM) Greetings all, I've got a table raw_Companies --nname --address --phone --fax --email --homepage with no keys defined and a table Companies with the same structure but with nname declared as a primary key. O... canoe414 retrieve most recent record for each user 10
1480 (3/25/2010 5:25:52 PM) I have this query that returns all of the status records for every user (multiple entries per user): SELECT user_id, status, status_date FROM status_table ORDER BY application_date DESC How can I get ...  ewilson917 (2) Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) LEOPARD 35
1412 (12/29/2009 12:22:21 AM) I got this error starting mysql from installation: sh-3.2# /usr/local/mysql/bin/mysql -user=mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) The same ...  jlrough (485) Self-Join to count values 2
5271 (2/22/2008 4:16:15 PM) Hi! I have a table in my mysql5 that roughly looks like this: id foreignid status 1 1 1 2 1 2 3 2 1 4 2 1 I want to sel... Haentz Replacing ONLY the first occurence of a substring in a string 2
1498 (1/16/2008 12:18:04 PM) I have a field which has multiple comma characters in it and I want to change the first occurrence only. I can not work out how to do this as replace changes all occurrences. eg Field 'fred, bob, june, 12... mcl Efficient way to delete a large amount of records from a big table 6
4033 (3/25/2011 3:06:43 PM) Hello, I want to delete a large amount of records (~200K) from a large table (~500K records) in my MySql DB. I want to make this call as efficient as possible because i dont want the DB to become "unres... RanStatistics Last Updated: 5/25/2013 12:00:00 AM |
8 followers. 