Rating Thread / Thread Starter	Last Post	Replies	Views
Advice the database schema Hi I need to design the database that will be storing a lot of personal information and preferences for my employer users. Right now I'm trying to... Ralph	10-30-2006 12:32 PM Jerry Stuckle	3	79
question about datetime column in mysql Hey there, i tried this question in the mysql group, but have not heard anything. i have a database with about 20 tables. The some of these tables... nephish	10-30-2006 07:41 AM nephish	2	83
LCASE() not working on columns. Hi everyone. I am trying to pull everything out of my table using LCASE() like so: SELECT LCASE(`URL`) FROM tags LIMIT 10; However, it's not... Daz	10-30-2006 07:37 AM Daz	2	88
php/mysql hosting? Hi Would anyone be able to recommend a mySQL/php web hosting services with PEAR installed? ---- Jack Vamvas Jack Vamvas	10-30-2006 07:02 AM Daz	1	117
leading zero removed from varchar(6) Hi I have a table where a field is described as checkin_time varchar(6). The value might have a leading zero (0730) . When I SELECT checkin_time... John	10-30-2006 06:51 AM Brian Wakem	6	121
Error In SQL String... I'm Stumped Hi All, I have only a limited understanding of SQL, so I have tried to determine the cause of this problem, but I have been unable to do so... lucanos@gmail.com	10-30-2006 06:48 AM Daz	1	82
Can it be done better? Chow can i do something like that: SELECT rfc.radioid, rank, CONCAT_WS(' ', rfc.fac_callsign, rfc.fac_service, rfc.fac_frequency)... Ralph	10-30-2006 06:22 AM Daz	4	125
Mysql won't start from init.d/mysql but will from mysqld_safe mysql Ver 14.12 Distrib 5.0.21, for pc-linux-gnu (i686) using readline 5.0 on CentOS 4.3 Mysql will run fine if I use mysqld_safe. But it won't... dterrors@hotmail.com	10-30-2006 06:12 AM Daz	1	108
Utf8 Import problem I use MySQL database with utf8 character set and utf8_czech_ci collation. It works well on Linux server but when I try to export the data and import... Pythoni	10-30-2006 06:06 AM Daz	1	95
Displaying a DB item from an RSS link Peter H. Coffin wrote: Okay, I understand how MySQL pulls the correct ID from your example. But in my situation I need to get the value of "test"... builder	10-28-2006 02:19 PM builder	2	70
SHOW TABLES and CHECKSUM TABLE statements Hello, (thanks in advance for any replies) If I run SHOW TABLES; or CHECKSUM TABLE <tbl name>;, the result gets displayed in mysql client. Now, is... estebanjang@gmail.com	10-28-2006 12:01 PM estebanjang@gmail.com	5	65
Table name "case sensitivity" I am still quite new to MySQL, so this is definately a "newbie" question. I have loaded MySQL on my WinXP system to use as a... Lee Peedin	10-28-2006 05:01 AM Dikkie Dik	5	94
Where should I find the mysql? Hi, Where should I find the mysql? What is the meaning of mssql and mysql server? sam	10-28-2006 02:34 AM Bill Karwin	2	84
Yellowfin reporting supporting tighter integration with MySQL and Ingress Yellowfin reporting supporting tighter integration with MySQL and Ingress Yellowfin continues to make "Business Intelligence" easy by now announcing... YellowFin	10-28-2006 02:20 AM YellowFin	0	62
Linux & MySQL on Intel Hello all, I have a project which I am not sure if MySQL can handel. I will be getting around 80Million records daily (230 bytes per record) I... Q	10-27-2006 07:13 PM Q	0	99
Linux & MySQL on Intel Hello all, I have a project which I am not sure if MySQL can handel. I will be getting around 80Million records daily (230 bytes per record) I... Q	10-27-2006 02:52 PM Brian Wakem	1	77
php/mysql hosting? Hi Would anyone be able to recommend a mySQL/php web hosting services with PEAR installed? ---- Jack Vamvas Jack Vamvas	10-27-2006 08:48 AM Jack Vamvas	0	102
Very Newbie Q: I mainly develop desktop apps and have been asked to look into MySQL. Is MySQL a web based app. only? Do you design forms, etc or is all the GUI... Michelle M	10-27-2006 07:07 AM Jerry Stuckle	9	127
Website completly down due to MySQL Hi, We had a website that is completly down due to MySQL. If we look at the processes (TOP) of the linux server with apache 2.0 : httpd (PHP) takes... Nick name	10-26-2006 03:29 PM Giuseppe Maxia	2	73
caparing date problem I have a table which include the fields activity_start_date and activity_end_date the problem is that i dnt want to insert any record in the table... jasvaran	10-26-2006 04:06 AM Manish Pandit	2	80
removing temporary tables from queries The following query has to create a temporary table and do a filesort. I have many such queries and from what I can tell all occur due to... austinbarton@gmail.com	10-25-2006 02:58 PM austinbarton@gmail.com	2	87
SELECT INTO OUTFILE Hi there, I'd like to dump the result of a select query such as e.g. select * from table where clause = 'true' into outfile 'outfile.csv'; but not... Thomas A. Anderson	10-25-2006 02:19 PM Radoulov, Dimitre	3	159
GROUP BY creation date I have a table structure which includes a UNIX timestamp (seconds since '1970-01-01 00:00:00' UTC) for the creation date. I would like to return a... Bosconian	10-25-2006 12:57 PM Bosconian	2	80
Foreign Key Constraints Hello - I've created several tables with FKC's, but for some reason, this one won't work... DROP TABLE IF EXISTS bi_votes; CREATE TABLE... pengypenguin@gmail.com	10-25-2006 10:39 AM pengypenguin@gmail.com	3	104
MySqlAdapter.Fill Error... Hello, I got an error message every time when I run the code below. The code is below, the last line is where the error occurs, could anybody tell... Till Merker	10-25-2006 12:47 AM Till Merker	0	100
MySQLAdapter.Fill Error.. Hello, I got an error message every time when I run the code below. The code is below, the last line is where the error occurs, could anybody tell... Till Merker	10-25-2006 12:38 AM Till Merker	0	83
Archiving old records Hi there, I'm a mysql user, but not an expert, and I'm looking for some advice on standard practices. I have a table of 'simulations', each record... Sven	10-24-2006 08:37 PM Sven	0	77
mysql recently started using 50% of processor I have a machine with several MySQL database tables and several scripts that use the tables periodically (i.e. it would be a huge pain to shut them... bennett@peacefire.org	10-24-2006 07:33 PM bennett@peacefire.org	0	78
deleting using temporary tables ( 1 2 ) I'm trying to clean up a table that has been used to store versions of some text until they are pronounced status='ready' Once ready all the previous... n00bie	10-24-2006 02:31 PM n00bie	17	159
mySQL mentioned in article I wrote I wrote an article that is in this month's SEMA News Show Issue that features mySQL amoung other open source projects. I had to write this article... Walter Vaughan	10-24-2006 08:09 AM Walter Vaughan	0	73
order the GROUP BY visual hi there, got a problem, im using "group by" to dont show the row duplicates, how does group by show the row? i mean does it show the 1st record that... salvatore scarantino	10-23-2006 08:01 PM Daz	3	97
mysql and multiprocessor machines Hello. I am trying to run mysql with SusE 10.0 in a 4xCpu machine. I see that mysql only uses 1 of them. Is it possible in any way to use all the... David Waizer	10-23-2006 03:32 PM David Waizer	2	125
Seeking contribution for MySQL Quality Assurance Hi, all. MySQL is about to launch yet another contribution project. We are still in the planning phase, and I have outlined the issue in this... Giuseppe Maxia	10-23-2006 05:55 AM Giuseppe Maxia	2	68
Features compare with db2 or oracle Hi, List. Did you konw if exists a matrix to compare MySql with db2 or Oracle? TIA Alberto Salvati Alberto Salvati	10-23-2006 03:37 AM Alberto Salvati	2	88
Re: Frontbase to MySQL Thomas Götz <tom (AT) richmountain (DOT) de> wrote in news:200610201219408930- tom@richmountainde: Hi Tom I'm not familiar with Frontbase, but you... Jody	10-22-2006 05:50 PM Jody	0	85
ERROR 1064 when trying to load dump from sql file Hi, Can somebody tell me what's wrong with the following syntax: G:\>mysql -u root --password=testpw test2x < c:\test2x.sql I get: ERROR 1064... docw@globetrotter.net	10-22-2006 04:56 PM Brian Wakem	3	105
Can't see how to change the DEFAULT_CHARACTER_SET_NAME for MySQL. Hi Everyone. I am having difficulty trying to find a way to change the DEFAULT_CHARACTER_SET_NAME to utf8-general-ci for all databases.... Daz	10-22-2006 04:49 PM Daz	0	73
MyISAM vs. InnoDB Forgive me if this is an overly-asked question. I have heard that InnoDB is faster than MyISAM. Unfortunately, all of my personal benchmarks seem... jinxidoru	10-22-2006 12:07 PM Axel Schwenke	5	126
Sorting text with Numbers in a MYSQL query ( 1 2 ) I have a mixture of text and numbers... for example Anthony Matthew 12 111 45 66 Gregory Anthony Ezkinazi	10-21-2006 10:48 AM Radoulov, Dimitre	10	160
How to get the query's thread id to kill by using `show full processlist`, there are so many query returned how to get the id of a particular statement? e.g. "SELECT count(*)... howa	10-21-2006 10:20 AM howa	1	79
Troubleshooting MySQL. Hi everyone. I have recently moved over to a new webhost, who seem to be very good, but I am experiencing big time differences in the times that my... Daz	10-20-2006 04:29 AM Captain Paralytic	2	79
Select last entries for many items take forever.... Hi, I'm trying to get the last inserted record for items (cNo) in a table. SELECT csp.cNo, CONVERT_TZ(posDateTime,'GMT','SYSTEM') as... AlexHWGUY	10-20-2006 04:23 AM Captain Paralytic	5	82
nested subquery in FROM clause Hi all, I am using MySQL 5.0.26-community-nt, and was excited about possibility to use nested queries in the FROM clause of SELECT statement. It... sashap	10-19-2006 02:46 PM Daz	2	88
Mysql limit for users Hi I work on the server Windows XP/MySQL/PHP When somebody use my website then mysql CPU usage is 100%. How can I decrease or set limit for CPU... PI	10-19-2006 08:08 AM Jerry Stuckle	7	132
Sorting fractions ( 1 2 ) In a DB I am managing there is a varchar field that contains integers or fractions as strings. As an example it contains strings like "1", "2" ,"100"... numismatica@gmail.com	10-19-2006 06:01 AM strawberry	10	164
column alias Been Googling around, but can't find quite the answer. To massively simplify what I'm trying to do I want to have some aliased columns and then... LittleRob	10-19-2006 02:31 AM LittleRob	4	123
Form time intervals _dynamically_? Dear NG, Let's assume we have a basic table like this: ---------------------------------------- ID \| user \| timestamp_IN \|... Georg	10-19-2006 02:17 AM Georg	0	64
default value problem. ( 1 2 ) Have created table CREATE TABLE `com_member` ( `dist_no` int(2) unsigned zerofill NOT NULL, `fname` varchar(14) NOT NULL, `lname` varchar(14) NOT... sk	10-18-2006 11:26 PM Jerry Stuckle	15	140
Intelligent searches in MySql Are there functions in Mysql that allow intelligent searches? So that records with words similar to the one that is typed would also be found? For... Ubi	10-18-2006 09:30 PM Ubi	0	76
Safe crash recovery with MyISAM I am doing a multi-row INSERT ON DUPLICATE KEY UPDATE on a MyISAM table in MySQL 5.0. If the server crashes half way through this query, I get some... jinxidoru	10-18-2006 09:29 PM jinxidoru	0	71

Page 109 of 129

109

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off