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
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
, 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','asdf',ecc))
that containts some dublicates in the unic key.
That sounds
-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 ) solution
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.
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.com/manual.php
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,
-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 02, 2002 3:23 PM
To: 'savaidis'; [EMAIL PROTECTED]
Subject: RE: get one name for each row
[snip]
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
-hotels.gr
Makis
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 02, 2002 6:59 PM
To: 'savaidis'; [EMAIL PROTECTED]
Subject: RE: get one name for each row
[snip from mysql list message]
I tried
select distinct Location from hotels1 order
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
: 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
Emne: a query from php doen't work
I get a Query failed
I get a Query failed error on this:
What could hapent?
I login as root 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
- 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?
Hi everyone,
I am trying to understand what's
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]]
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 a href with onMouseOver but I'll but rather a form
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 statements.
Cary
At 12:10 PM 3/9/02, savaidis wrote:
I found
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]
Subject: RE: what's wrong
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 field10
and it shows me an error!
But when I execute it without 'explain', it updates the fields correctly.
Why?
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/
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 fields
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 the
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)
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,
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's book at Safari and I
couldn't fint info about the various
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,
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:09 -0600 2/25/02, Paul DuBois wrote:
At 21:35 +0200 2
, 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'
Subject: Re: Paul DuBois - Thank You
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
)
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 book here in Thessaloniki/Greece
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
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:52 PM
To: savaidis; 'MySQL
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; [EMAIL PROTECTED]
Subject: RE: Comments
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 WHERE FIELD1= mpla-mpla%
Also binary at field creation or WHERE should be ON by default. And WHERE
works erroneously with Greek chars (without the binary
:[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 SELECT command on MySQL manual!
http://www.mysql.com/doc/S/t
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
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: savaidis; [EMAIL PROTECTED]
Subject: RE: Comments in Documentation
At 19:28
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 query on php
Just a comment:
Doing so
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:
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
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
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 query on php
Just a comment:
Doing so
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:
: savaidis [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 8:14 PM
To: MySQL list (E-mail)
Subject: long query on php
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
word
and before the closing quotations) if you plan on continuing the query
on
the next line, or else your SQL will be invalid.
Good luck,
Brett
Original Message Follows
From: savaidis [EMAIL PROTECTED]
To: MySQL list \(E-mail\) [EMAIL PROTECTED]
Subject: long query on php
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
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
48 matches
Mail list logo