I have a problem when I'm studying the full text search's expansion mode

The official table's data. ++---+-+ | id | title | body| ++---+-+ | 1 | MySQL Tutorial| DBMS stands for DataBase ...

Re: I have a problem with MySQL.

If you give more details maybe someone on the list will be able to help. Astghik Barseghian wrote: Hello Philippe, I am trying to use DBMail from MySQL to send and receive messages but I get an SQL sytax error. Could you please tell me is there any way to use the mentioned component, or how can I

Have some problem with Ver 4.0.13

Hi. I used MySQL for over 2 years since ver 3.22 and now use ver 3.23.49 Z9bundle with RedHat 7.3) it work fine and now I decide to upgrade to ver 4 (as production cersion) I download ver 4.0.12 but when I will start to upgrade the new one 4.0.13 launch so I decide to up to 4.0.13 instead of

have a problem

Hello mysql, When I execute this SQL: update table1 as a, table2 as b set a.field1=b.field1 where a.field2=b.field2 and a.field3=b.field3 and a.field4=b.field4 I received this error execute failed: The table 'a' is full What is the meaning of this? My server version: 4.0.12

Re: have a problem

Hello, When I execute this SQL: update table1 as a, table2 as b set a.field1=b.field1 where a.field2=b.field2 and a.field3=b.field3 and a.field4=b.field4 I received this error execute failed: The table 'a' is full What is the meaning of this? This means that the table is full ;-)

Re[2]: have a problem

Hello Stefan, Wednesday, April 02, 2003, 2:27:40 PM, you wrote: Here is table status:

Re[3]: have a problem

Hello, Here is table status: +---+++-++-+-+--+---+-+-+-+-++-+ | Name | Type | Row_format |

Have a problem when I try to connect MySQL( on Linux) thru win32

He all, I have a problem with MySQL ver 3.23.52 on Linux Redhat 8. It is working successfully on the server, and can response all request comming on Server. But, when I try to connect to the database thru any client running on a Windows 2000 (like MySQLAdmin), I can't connect it. Firstly, I got

re: Have a problem when I try to connect MySQL( on Linux) thru win32

Cem, Tuesday, November 26, 2002, 1:13:45 PM, you wrote: CY I have a problem with MySQL ver 3.23.52 on Linux Redhat 8. It is CY working successfully on the server, and can response all request CY comming on Server. But, when I try to connect to the database thru CY any client running on a Windows

Have a problem when I try to connect MySQL( on Linux) thru win32

He all, I have a problem with MySQL ver 3.23.52 on Linux Redhat 8. It is working successfully on the server, and can response all request comming on Server. But, when I try to connect to the database thru any client running on a Windows 2000 (like MySQLAdmin), I can't connect it. Firstly, I got

Re: Have A problem

Hi Chuck, or take a look at the LEFT() function. =dn Try : SELECT * FROM yourtable WHERE word LIKE 'D%'; Regards, Jocelyn - Original Message - From: Chuck PUP Payne [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, September 08, 2002 2:42 AM Subject: Have A problem

Have A problem

Hi, I got a small problem I can't seem to do a sql statement that will pick on the first letter of word in a feild. I have over 700 record in a database, but I like to be able only to see those that let say start with D. How can I do a statement that will let me do that. Chuck Payne Magi Design

Re: Have A problem

Hi, Try : SELECT * FROM yourtable WHERE word LIKE 'D%'; Regards, Jocelyn - Original Message - From: Chuck PUP Payne [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, September 08, 2002 2:42 AM Subject: Have A problem Hi, I got a small problem I can't seem to do a sql

I have a problem....

We are running mysql on a red hat box. We replicate a single database twice, once on another red hat box(thank whatever is holy), once on a winnt box. The winnt box cares not for case sensitivity, so it created all our table names in lower case ( our standard is to use CAPS for tablenames ) (

I have a problem!

I use phpBB. When I change default character set in mysql I have a problem in phpBB so: Warning: Supplied argument is not a valid MySQL result resource in /../functions.php on line 230 Unable to query db! But /../admin/index.php regularly runs. What my problem is? thanks Edakom Internet

I have a problem with make.

Please help me. I'm installing mysql-3.23.45 on Sparc 20 with Solaris 2.5 and when i give the comand make...i have this problem. .. make[2]: Nothing to be done for `install-data-am'. make[2]: Leaving directory `/usr/local/mysql-3.23.45/libmysql' make[1]: Leaving directory `/usr/local/mysql

Can you Help me? I have Appostroph problem

Hi, I'm new in mysql, I have a problem in the apostroph, I would write a query like : select ID from table where sentence = 'does't take' Can you help me? ___ Do You Yahoo!? -- Pour dialoguer en direct avec vos amis, Yahoo! Messenger

Re: Can you Help me? I have Appostroph problem

is replace the following chars: ' - \' " - \" \ - \\ null - \0 where null is a binary null. gl - Original Message - From: "Sofiane Sakhri" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 16, 2001 11:37 AM Subject: Can you Help me? I have Appostroph problem

Re: Can you Help me? I have Appostroph problem

select ID from table where sentence = '".does't take."' I think that should do the trick. Or if not...hopefully you're using mysql in combination with some other programming languages like asp or php or...in php you just use addslashes() function bvefore sending a query to mysql. Cheers