I repeat my question to a diferent form : how is possible to export my MySQL
data to a diferent SQL form?
Makis
-Original Message-
From: Savaidis [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 27, 2002 1:38 PM
To: [EMAIL PROTECTED]
Subject: export to .sql to other SQL platforms
I tried to import an .sql file from MySQL table (str+data) to interbase
and I encountered many errors . Is there any utility to convert this .sql
from MySQL to .sql suitable to feed SQL servers like interbase ecc?
(these errors are : no quots to field names, no 'binary' , no int(3) but int
n
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 7:59 PM
To: Savaidis; mysql list
Subject: RE: insert and deletind dublicating
At 17:54 +0300 9/19/02, Savaidis wrote:
>I had already done the first (insert ignore into bla-bla ) solut
Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 5:10 PM
To: Savaidis; mysql list
Subject: Re: insert and deletind dublicating
At 12:06 +0300 9/19/02, Savaidis wrote:
>Hello!
>
>I have to add a .sql file from MySQL-Front
>
>(insert into mytable ('0&#x
Hello!
I have to add a .sql file from MySQL-Front
(insert into mytable ('0','asdf',ecc))
that containts some dublicates in the unic key.
How can I do this and later to delere the dublicate records?
The unic key has 3 string fields segments.
Thanks!
Makis
--
Is there any standard method or benchmark to run localy or remotly to my
host to help me to setup MySQL better
or to check various computer/configurations?
I could find anything on http://www.mysql.com/information/benchmarks.html
links.
Only at third part software but it is in C++, not .sql. Wh
I have install MySQL CC (control center) after some months living with
MySQL-front.
I think it is faster but:
1) How to delete a row without giving SQL command? Or append row?
2) How is possible to see in SQL the edit I am doing to one field?
Makis
Hello!
Does anyone know how to install the "fishcart" - using My-SQL- on win98 or
help me anyway on
this?
It's really important!
Thanks
Makis Savaidis
-
Before posting, please check:
http://www.mysql
I have one table on my computer and one remote to my host on Internet.
I have this problem:
I use =>
ALTER TABLE hotels1 DROP ID;
ALTER TABLE hotels1
AUTO_INCREMENT=1,
ADD ID int unsigned not null auto_increment default '0' first,
ADD primary key (ID);
to refresh the ID starting f
age-
> From: Jay Blanchard [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 02, 2002 6:59 PM
> To: 'savaidis'; [EMAIL PROTECTED]
> Subject: RE: get one for each row
>
>
> [snip from mysql list message]
> I tried
>
> and worked.
> But how can I show all fie
I tried
and worked.
But how can I show all fields of the rows?
It doesn't accept any field before and shows every row after
(if I put )
Thanks again
Makis
> -Original Message-
> From: Jay Blanchard [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 02, 2002 3:23 PM
&
I have one table with about 1000 hotels and name or the city they belong.
I want to run a query to get one row for every city only, to put it in a
pull down menu in the search form.
How is that?
Makis
-
Before posting, please
ginal Message-
> From: Carsten Gehling [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 17, 2002 11:23 PM
> To: savaidis; [EMAIL PROTECTED]
> Subject: SV: a query from php doen't work
>
>
> > Fra: savaidis [mailto:[EMAIL PROTECTED]]
> > Sendt: 17. april 2002 22:14
&g
I get a "Query failed" error on this:
What could hapent?
I login as with MySQL-Front and pass the same query with no problem.
Query's length is about 500 bytes.
I need it to send my data to a remote MySQL server.
PS I send this here becouse is more related to MySQL than to php.
Thanks a lot
Ma
- or search- a text file.
Makis
> -Original Message-
> From: Philip Semanchuk [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 02, 2002 7:21 PM
> To: [EMAIL PROTECTED]
> Cc: 'Ken Menzel'; savaidis
> Subject: swe7 character set - strange mappings?
>
&g
Is there something similar for Greeks too?
(not that matters very much as I run on internet host but in case..)
Makis
> -Original Message-
> From: Ken Menzel [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 26, 2002 10:25 PM
> To: Philip Semanchuk
> Cc: [EMAIL PROTECTED]
> Subject: Re
I have the same problem with Greeks, it is a bug of MySQL.
Try:
1) Create the fields of the table with BINARY option.
2) Use LIKE with BINARY option (slower)
BINARY doesn't make the uppercase convertion.
Makis
> -Original Message-
> From: Philip Semanchuk [mailto:[EMAIL PROTECTED]]
> Se
First in generally: How is possible to exange vars between a
form/php/javascript?
I have fetch the data from a MySQL query and I need to pass the $line from a
form to a new php script to show the record in details in one whole page.
I have put a with onMouseOver but I'll but rather a form
there
elete them all new and re-insert to 70
records for last time.
If I could use EXPLAIN to examine the 70 records, I hadn't to do this.
Makis
> -Original Message-
> From: savaidis [mailto:[EMAIL PROTECTED]]
> Sent: Monday, March 11, 2002 11:25 AM
> To: [EMAIL PROTECTED]
with EXPLAIN?
>
>
> I am probably wrong, but my assumption was that EXPLAIN was
> used to help
> optimize SELECT statements, not INSERT/UPDATE statements.
> So if I am thinking correctly (this time :-), EXPALAIN is
> erroring for you
> because it only deals with SELECT stat
I found - once again- strange behaviour on some MySQL functions, i.e. with
EXPLAIN command.
I give one very simple query : explain update mytable set field1 =
round(field1,2) where field1>0
and it shows me an error!
But when I execute it without 'explain', it updates the fields correctly.
Why?
(f
Is MySQL a relational database?
If yes, how is implemented a "one to one" and "one to many" relation?
Makis
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
You can use "logical lock" - set a STATUS int <>0 (probably the ID of user)
to indicate someone started to edit it interactively to block other user to
edit the same record.
Before you write it back to disk, read it again in a buffer to keep all data
possible changed by batch updates.
Or separate
Why you don't try:
BETWEEN '$surname_from' AND concat($surname_to,'z') ?
Makis
> -Original Message-
> From: Craig Shepherd [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 05, 2002 1:30 PM
> To: [EMAIL PROTECTED]
> Subject: BETWEEN... LIKE query
>
>
> Hi,
>
> I have a form with two
I give this query:
ALTER TABLE `companies` ADD `Tel3` CHAR(30) BINARY
but it creates tel3 as VARCHAR(30) !
Why?
Makis
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.
Original Message-
> From: Roger Baklund [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, March 03, 2002 8:06 PM
> To: 'mysql'
> Cc: savaidis
> Subject: RE: documentation about the various databases
>
>
> * savaidis
> > I took a look at documentation and Paul
I took a look at documentation and Paul's book at Safari and I couldn't fint
info about the various types of databases MySQL supports (Inno, default
MySQL ecc).
Where are they?
Thanks
Makis - no query
-
Before posting, please
I have Apache and MySQL both installed on W98 with no problem at
installation or running.
I think, yes, is possible to install and run MySQL only.
But how you can use it without php for example?
Makis
> -Original Message-
> From: Rajesh Chabria [mailto:[EMAIL PROTECTED]]
> Sent: Friday,
)
Makis
> -Original Message-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 26, 2002 5:36 PM
> To: savaidis; 'MySQL List'
> Subject: RE: Paul DuBois - Thank You
>
>
> At 13:06 +0200 2/26/02, savaidis wrote:
> >There is not your b
Are you adding the data in order ? If Btree is not "balanced" then it
matters. It search them all. But I don't believe it is not balanced.
Makis
> -Original Message-
> From: Battini, Chandrashekar
> [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 26, 2002 4:38 PM
> To: '[EMAIL PRO
zoom, indexes, images, graphics ecc.
At least Computer books I think they should be sold -and- by this form.
Makis
> -Original Message-
> From: DL Neil [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 26, 2002 1:34 PM
> To: savaidis; 'MySQL List'
> Subjec
e specific so I can send the subscription.
Thanks
Makis
Query
> -Original Message-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 26, 2002 12:46 AM
> To: savaidis; 'MySQL List'
> Subject: RE: Paul DuBois - Thank You
>
>
> At 16:0
I don't take work out of office, NEVER! :)
Is not possible to copy e-book either, I think!
(PS: You're so sick to read work books at home ? :)
Makis
> -Original Message-
> From: Georg Richter [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 25, 2002 9:5
Is there any electronic version of this book (e-book)?
Because it will be very helpfull if it has an index-content like PDF docs.
And why pay for paper? We live on 2000 no?
Makis
> -Original Message-
> From: Craig Westerman [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 25, 2002 8
this list told me I can use
BINARY clause with WHERE but it is slow in contrary with "binary" flag on
the field description.
Makis
> -Original Message-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, February 23, 2002 11:04 PM
> To: savaidis;
SQL already, then I didn't have to read the MySQL manual.
If you don't know there is a LIKE function then how to go and look for it?
Makis
> -Original Message-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, February 23, 2002 10:21 PM
> To: savaid
I'm using still a very small MySQL database -just testing yet- but I read
many people talking about some Gigas of data. I wonder where can I find some
benchmarks about MySQL with various O.S.
I work with MySQLFront and:
Is there a way not to loose data when I change a field i.e from INT to
FLOAT
ginal Message-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, February 23, 2002 6:29 PM
> To: savaidis; [EMAIL PROTECTED]
> Subject: RE: Comments in Documentation
>
>
> At 16:01 +0200 2/23/02, savaidis wrote:
> >Also there is not LIKE at all at
Also there is not LIKE at all at SELECT command on MySQL manual!
I found manual very-very amateur work.
I was trying about half hour to use
Also "binary" at field creation or WHERE should be ON by default. And WHERE
works erroneously with Greek chars (without the "binary" option). I think it
is
How is possible to pass a long query to MySQL server with php?
I mean i.e a "create table" statement with more than 400 chars.
Have I to use shorter "create" and then "alter"?
Thanks
Makis
-
Before posting, please check:
ht
Hi!
I use a query : SELECT * FROM Table1 WHERE name LIKE "K%" (K = Greek char =
ASCII 137)
but it selects also "k" (small K Greek) and "L" (Greek , ASCII 138)
Why so and what I have to do? Something is in Apache setup?
Also is there a way to print a counter at first row intead of ID
(autoincrem
Surprisingly it is mote than 64 KB! (I count strlen=74KB)
Bravo!!
Makis
> -Original Message-
> From: savaidis [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 08, 2002 9:08 AM
> To: [EMAIL PROTECTED]; 'Nathan'
> Cc: 'MySQL'
> Subject: RE: long
Just a comment:
Doing so it's possible to insert a line between $query.. statements.
(comments ecc) Its very simple to write it with copy+paste and I prefer
this.
Thanks.
PS. I'll check the string limit and I let you know. I think it has to be the
64KB.
I think only Visual Basic has this hig
Hi!
I use a query : SELECT * FROM Table1 WHERE name LIKE "K%" (K = Greek char =
ASCII 137)
but it selects also "k" (small K Greek) and "L" (Greek , ASCII 138)
Why so and what I have to do? Something is in Apache setup?
Also is there a way to print a counter at first row intead of ID
(autoincrem
Surprisingly it is mote than 64 KB! (I count strlen=74KB)
Bravo!!
Makis
> -Original Message-
> From: savaidis [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 08, 2002 9:08 AM
> To: [EMAIL PROTECTED]; 'Nathan'
> Cc: 'MySQL'
> Subject: RE: long
Just a comment:
Doing so it's possible to insert a line between $query.. statements.
(comments ecc) Its very simple to write it with copy+paste and I prefer
this.
Thanks.
PS. I'll check the string limit and I let you know. I think it has to be the
64KB.
I think only Visual Basic has this hig
uot;;
>$query.="some more of the same query ";
>$query.="still more query ";
>$query.="and so on... ";
>
> $rst = mysql_query($query);
>
> NOTE: you need to add a space at the end of each line (after the last
> word
> and before th
ontaine
> Consultant & Developer
> VAlain S.A.
> Tel: +32-4-2522950
> ---
>
> -Original Message-
> From: savaidis [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, February 06, 2002 8:14 PM
> To: MySQL list (E-mail)
> Subject: long query on php
>
>
>
> How is possibl
How is possible to pass a long query to MySQL server with php?
I mean i.e a "create table" statement with more than 400 chars.
Have I to use shorter "create" and then "alter"?
Thanks
Makis
-
Before posting, please check:
ht
Hello again!
I see many people works here with php and that's natural, as php is
connected with MySQL.
In php graphics, I found that printing with a TTF font has no possibility
to set the font high. Is this true?
Also is not possible to open only once one font file and not as many times
as text
Hello all !
I see it's a very busy list so I will try to by short to my first question:
1) Is there a way to put the REAL numbers of rec in the ID=auto-increment? I
made some tests so this number is higher than total recs of the
table.(export/import to text doesn't help)
The Rec_num is stored s
51 matches
Mail list logo
