Hi, I'm trying to resolve why InnoDB is crashing. It happened twice for the last month without obvoius reason Any help will be...

AT

05-12-2006 11:01 AM
AT

Is there any way to optimize a range query that includes an ORDER BY with keys from two different tables? I'm running MySQL 4.1.18 on FreeBSD. I've...

AT

05-12-2006 10:59 AM
AT

------=_Part_10993_355608.1147394536662 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding:...

AT

05-11-2006 07:42 PM
AT

--0-2103955855-1147267649=:89701 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit hello, I used the php and mysql to...

AT

05-11-2006 06:36 PM

We have been using MyODBC to connect Microsoft Word 2000 through Microsoft Query. This allows us to select specific the data and use it for...

AT

05-11-2006 06:19 PM
AT

Hello all, I have inherited this query: SELECT events.eventID AS id, attribute_master.attributeID AS attrib_id FROM events, attribute_master

AT

05-11-2006 05:53 PM
AT

Mysql 4.x I have a one to many case, key is `id`, in this case, I have tables users and transactions. A user can have 1 to x transactions, each...

AT

05-11-2006 03:53 PM
AT

Yup. The problem solved! Thanks John! ;) -afan

AT

05-11-2006 12:04 PM
AT

Following my post about this complex search I'm trying to do... In the initial post I said I'd tried adding: left join table_ga as tga on tga.id =...

AT

05-11-2006 12:03 PM
AT

Not long ago, some highly knowledgeable people here kindly helped me out with a fairly complex query... Finding names of people (and other info)...

AT

05-11-2006 11:47 AM
AT

<<Sorry about the re-post, all!>> Hello all, I just inherited an application that has 2 tables under consideration, = "events" and...

AT

05-11-2006 11:23 AM
AT

Hello MySQL Users I have a contract table. Each contract has a certain level, which can be in a range from 1-5. This information is stored as a...

AT

05-11-2006 10:29 AM
AT

------=_Part_13127_23257334.1147097043435 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding:...

AT

05-11-2006 07:24 AM
AT

hi, I got a table where the myi isn't able to re be read. I tried to run myisam but it give an error about the index. Do I need to drop the table?...

AT

05-11-2006 07:16 AM
AT

Here comes a newbie question... I want to get a total of entries from four tables which all match a particular id. The result for the id I'm testing...

AT

05-11-2006 05:18 AM
AT

------_=_NextPart_001_01C674C4.4788A0E3 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi...

AT

05-11-2006 02:13 AM
AT

Version 5.0.19. We have no autogenerate keys. We perform a single insert and get a lock timeout. The insert is done with a stored procedure with a...

AT

05-11-2006 02:10 AM
AT

------=_Part_28877_17722556.1147317789094 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding:...

AT

05-10-2006 10:42 PM
AT

------=_Part_28545_28079720.1147317200858 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding:...

AT

05-10-2006 10:13 PM
AT

I am trying to install DBD::mysql on the following node: # uname -a Linux snv1 2.6.9-34.ELsmp #1 SMP Fri Feb 24 16:56:28 EST 2006 x86_64 = x86_64...

AT

05-10-2006 05:06 PM
AT

Hello all, Is there any way I can search for a term such as 'c++' using a fulltext search index? Here is the query that should return rows but it...

AT

05-10-2006 03:39 PM
AT

Thanks to Ing. Edwin Cruz and George Law for pointing me in the right direction, as previous messages in this thread indicate. phpMyAdmin now working...

AT

05-10-2006 03:32 PM
AT

I would like an integer field to capture the current date as a Unix Timestamp by default. But this will not be accepted at all. I get the error...

AT

05-10-2006 02:06 PM
AT

------=_NextPart_000_00B7_01C67469.54D08E60 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding:...

AT

05-10-2006 01:07 PM
AT

I've finally got MySQL 5.0 going on my Win2K machine, but phpMyAdmin 2.8.0.3 is now giving me grief. It gives me this error: phpMyAdmin tried to...

AT

05-10-2006 12:45 PM
AT

I have a very simple table that looks like this: CREATE TABLE `contacts` ( `id` int(11) NOT NULL auto_increment, `fullname` varchar(100) default...

AT

05-10-2006 11:59 AM
AT

------=_NextPart_000_001D_01C67459.CF565210 Content-Type: text/plain; charset="iso-2022-jp" Content-Transfer-Encoding: 7bit Hi, I want to install...

AT

05-10-2006 06:29 AM
AT

Hallo, i'm a new user of myslq and i have a problem, please help me. I have my data table in which i have the first column that represents an id and...

gbattine

05-10-2006 06:15 AM
gbattine

------=_NextPart_000_005D_01C67460.99EE6DE0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding:...

AT

05-10-2006 05:36 AM
AT

hi again, I have to restart as soon as possible mysql and apache on our web server (mandrake cooker 10) - since our admin is "out of office" for...

AT

05-10-2006 04:35 AM
AT

------=_Part_21463_12807285.1147205179474 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding:...

AT

05-10-2006 04:13 AM
AT

Hi, I'm running MySQL 5.0.19 (Debian sid, package revision 3) on a Dual Opteron250 64 bit machine with 4gb memory. The problem i'm experiencing is...

AT

05-10-2006 03:59 AM
AT

Hello, I can get a select result like the following: (SELECT ID,Changes FROM mytable WHERE somecondition;) ID Changes ----------------- 1 ...

AT

05-10-2006 02:11 AM
AT

------=_NextPart_000_000B_01C67439.35B12EC0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding:...

AT

05-10-2006 01:29 AM
AT

------=_NextPart_000_0006_01C67333.99D83E90 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi List, I...

AT

05-10-2006 01:05 AM
AT

Hi all, I have a strange problem and I can't really understand what's going on! mysql> SELECT n.nid, n.sticky, n.created FROM node n WHERE...

AT

05-09-2006 04:42 PM
AT

It looks like today is my day! :) I FULLTEXT indexed my table "products": CREATE TABLE `products` ( `prod_id` int(8) unsigned NOT NULL...

AT

05-09-2006 04:37 PM
AT

--0-1906763250-1147188039=:99519 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hi everyone, I am trying to capture...

AT

05-09-2006 01:37 PM
AT

hi again, I have to restart as soon as possible mysql and apache on our web server (mandrake cooker 10) - since our admin is "out of office" for...

AT

05-09-2006 12:58 PM
AT

Yup! Got it.. Thanks guys, to all of you, for REALLY fast help! :) -afan

AT

05-09-2006 12:20 PM
AT

hi to all, I have to redo a web site of one company and the structure of the current db is a little mess. one of them is customer id number. right...

AT

05-09-2006 11:40 AM
AT

I just noticed that a key field (emailaddress) in my db is case sensitive when it should not have been, so now I've got a bunch of what are...

AT

05-09-2006 10:13 AM
AT

------=_Part_33107_10613571.1147184036687 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding:...

AT

05-09-2006 09:14 AM
AT

ÅíÒ»·² schrieb: So this would likely not work. If you tell what you want to be outputted we might help find a solution. barry --

AT

05-09-2006 08:44 AM
AT

Hello everyone! I have a slight problem matching rows. My problem is the Value in a textfield is: "87682<next>39857" I created that with...

AT

05-09-2006 08:43 AM
AT

Hi I have bought the MySQL certification study guide (v 5.0) and am almost ready for the exams, does anyone know if the questions in the self...

AT

05-09-2006 03:42 AM
AT

Hi, This query running fine on 4.0.25 but when trying on 3.23 an error occurs. can one help me to find correct command for 3.23? DELETE FROM...

AT

05-09-2006 03:00 AM
AT

It appears (for InnoDB at least) that while INSERTing a LOB that all LOB data must be loaded into memory before it is written to disk. Or is it just...

AT

05-09-2006 12:31 AM
AT

------_=_NextPart_001_01C671F3.23D14354 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable What are people...

AT

05-08-2006 08:03 PM
AT

Hey, i´ve a problem with getting the next and the actual birthdays. This my actual birthday sql : SELECT SQL_CACHE birthday,mem.lname,...

AT

05-08-2006 10:36 AM
AT