o use your
e-mail's "Reply" feature to respond to Technical Support e-mails. By doing
so, we keep the information from previous messages, which will assist the
Technicians in resolving your problem in a timely manner.
If this email is concerning WebDemo or WebInteractive you can cal
Hello,
I have found the solution of my sql quueris,
I want to unsubscribe from this list
can u help?
thanx
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hello,
I want to store my table in text file,
I've tried :
select * from news into outfile 'news1.txt'
but doesn't work
Can you help to do this with phpmyadmin or sql,
thanx
-
Before posting, please check:
http://www.mys
Hello,
I am looking for how to save into file content of table,
Can you give an example of mysql query,
thanx
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hello,
If u can help,
I want to do substraction between tables in mysql,
MINUS not yet implemented in mysql
and this not work :
select a.* from table_a a where a in (select * from table_b)
thanx
-
Before posting, please che
You are using PHP. Well PHP is not ASP :-) clever and you can enclose your
variable in single quotes as in:
$customer_select="SELECT * FROM customers WHERE Customer_No = '$id'";
Hope this helps.
*
* Visit http://www.computerstaf
Hello,
Your field(column) is a CHAR and therefore the parameter to it should be in
single
quotes:
Change your query to:
SELECT * FROM customers WHERE Customer_No = 'CMET3558539239'
*
* Visit http://www.computerstaff.net - Compu
Hello,
Has anyone managed to compile the BETA version of MySQL 4 for Windows?
I have downloaded the source however, it appears to be for LINUX or UNIX.
*
* Visit http://www.computerstaff.net - Computer Jobs at all LEVELS *
Hello All,
I have tried the settings as suggested in this FORUM like using htmlentities
etc... however, my pound sign in the database is displayed as: ú
Any more tips help etc...
> -Original Message-
> From: technical Support [mailto:[EMAIL PROTECTED]]
> Sent: 07 June 2001 2
Hello All,
When I insert data submitted via a web page into mySQL, the pound (£)
symbol gets converted to something like &8916.
I am using PHP and Apache on the Server side.
Has anyone else encountered this strange problem?
*
Hello,
Does anyone know of any tool that will take an ORACLE database and port
it to mySQL?
*
* Visit http://www.computerstaff.net - Computer Jobs at all LEVELS *
*
; From: Sergei Golubchik [mailto:[EMAIL PROTECTED]]
> Sent: 20 May 2001 22:44
> To: technical Support
> Subject: Re: Fulltext Strange Results...
>
>
> Hi!
>
> On May 20, technical Support wrote:
> >
> > I have just done this:
> > select * from indexed_table
I have just done this:
select * from indexed_table where match(indexed_col)
against ('"visual basic"')
This returns rows with either visual or basic. I read
phrase searching was allowed in mySQL v4.0? Can someone please advise.
***
*
> -Original Message-
> From: Sergei Golubchik [mailto:[EMAIL PROTECTED]]
> Sent: 20 May 2001 20:51
> To: technical Support
> Subject: Re: Fulltext Strange Results...
>
>
> Hi!
>
> On May 20, technical Support wrote:
> > Hello,
&g
Hello,
I did the following query against my indexed table:
select * from indexed_table where match(indexed_col)
against ('oracle +sybase +london')
It returned 16 rows of which only 4 rows included all words.
I then did:
select * from indexed_table where match(indexed_col)
against ('+oracle
Hello,
I have just downloaded version 4 of mySQL. Compiled it with ft_min_word_len
= 0.
However, my a query like select * from table_name where match(col)
against('asp')
returns nothing, when a similar like query returns several rows of data.
Also a
query like select * from table_name where match
Good morning,
Please,
I use MySql, I would use INTERSECT/UNION functions and they don't work, I need help,
My query is :
select E.*, ME.Emplacement, E.Url,E.EMail, C.Name From Entreprise E, Mot_Entreprise
ME, Mot M, Categorie C where (E.ID=ME.ID) and (ME.CodeMot=M.CodeMot) and (M.Mot like
'wor
> > Why not use a timestamp column to guarentee the order in which rows get
> > inserted into the table? You can then order on the timestamp column.
>
> Hmm, timestamp, ie. seconds as finest resolution, might be to broad
depending on
> the hits his site will get - imagine that 2+ users access the
Hey, I can't stop laughing anymore ( that has no ironical meaning!!! ) :) :)
Good humor in this list, don't stop please
:) Philipp
- Original Message -
From: "Jason Landry" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "John Dean" <[EMAIL PROTECTED]>
Cc: "Bob Hall" <[EMAIL PROTECTED]>; <[
How many Bytes can I save in a user variable?
Because I have the following strategy:
I want to save all PrimaryKeys in a user variable
SELECT @a:=' ';
SELECT @a := CONCAT(@a, ', ', TPrimKey) FROM table WHERE ;
so it is very important to know how many bytes can be stored.
regards
Philipp Has
20 matches
Mail list logo
