RE: export to .sql to other SQL platforms
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 no 'key' keyword ecc) Thanks Makis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
insert and deletind dublicating
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
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: insert and deletind dublicating
I had already done the first (insert ignore into bla-bla ) solution with
personal e-mail from a friend. It works fast and fine. But the word ignore
leds me to missunderstanding: insert the row inspite of the unique key!
continue I think it is more meanfull as without this I get an error
message and the job stops at this row.
I think also something like explain to insert should exist as to select
too (and to other commands too). We could locate missplaced quots , missing
fields ecc to run the whole .sql without actualy insert it to the table.
Also the error message couldn't be more precise? I mean to show where is the
problem on the insert line? Close too - shows always the begin of the line.
Something relative: If the table contains dublicate keys I haven't define
yet, I should export to .sql , empty the table, define the keys and import
again or is there a simpler way to delete dups at once?
Also is possible to MERGE identical tables with same unique keys and abord
dublicates ?
Or must use export-import trick again?
JOIN does this or is used only for SELECT?
thanks anyway...
Makis
-Original Message-
From: 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','asdf',ecc))
that containts some dublicates in the unic key.
That sounds self-contradictory.
How can I do this and later to delere the dublicate records?
The unic key has 3 string fields segments.
You can either:
- Create the table, including the unique index, and then load it
with either INSERT IGNORE or REPLACE
- Create the table, but do not place any index on it yet. Then load
then table. Then add the index using ALTER IGNORE TABLE ... rather
than ALTER TABLE ... to tell it to ignore (and delete) duplicate
records when creating the index.
Thanks!
Makis
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: insert and deletind dublicating
-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 with personal e-mail from a friend. It works fast and fine. But the word ignore leds me to missunderstanding: insert the row inspite of the unique key! That's why it's a good idea to read the manual if you're not sure about what something means. I have read the manual 3-4 times and I'm surprised everytime- I work in MySQL more than a year now, so simple things in front of my eyes, I can't see them. continue I think it is more meanfull as without this I get an error message and the job stops at this row. A matter of taste, perhaps. I don't find IGNORE confusing, and I don't find CONTINUE meaningful, myself. On that, I have to agree :) I think also something like explain to insert should exist as to select too (and to other commands too). We could locate missplaced quots , missing fields ecc to run the whole .sql without actualy insert it to the table. Also the error message couldn't be more precise? I mean to show where is the problem on the insert line? Close too - shows always the begin of the line. EXPLAIN cannot work in the way you describe, because it requires a syntactically legal statement to begin with. Syntax errors are the domain of the parser. If it says the error is close to the beginning of the line, normally that's exactly what is wrong. I believe parser works before every command. It works before searching, it founds the error possition anyway, so it wouldn't slowdown the execution of searching proccess ecc. I see always pointing at the beggining of the line. I don't know if this is becouse of MySQL itself (doesn't return the exact possition) or MySQL-Front doesn't make good implementation of returning error. As for EXPLAIN, if could be also easily add too to every command with no extra cost as is an external (seperated) command. In addition to some hundreds checks of rights, locks, keys ecc one more if it is real or EXPLAIN. Makis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
benchmark to my MySQL
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. What that means? Makis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
about MySQL CC
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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
fishcart on win98
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 (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
get one name for each row
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 check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: get one name for each row
I tried select distinct Location from hotels1 order by Location and worked. But how can I show all fields of the rows? It doesn't accept any field before distinct and shows every row after distinct (if I put select distinct Location, Name ... ) Thanks again Makis -Original Message- 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 only, to put it in a pull down menu in the search form. How is that? [/snip] SELECT DISTINCT city FROM tblFOO So if you have this table; +---++ | City | Hotel| +---++ | Houston| Hotel A | | Houston| Hotel B | | Houston| Hotel C | | San Antonio | Hotel A | | Dallas | Hotel A | | Detroit | Hotel A | | Detroit | Hotel B | +---++ The query will return; +---+ | City | +---+ | Houston| | San Antonio | | Dallas | | Detroit | +---+ Hope this helps! Jay Blanchard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: get one name for each row
The table has about 80 fields. I would something like: select *, distinct Location from hotels order by Name (this one creates a MySQL error) to one full row for every Location. I suppose I have to do it with a php script. (with limit 1 to the second query) You can see it at http://www.macedonia-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 by Location and worked. But how can I show all fields of the rows? It doesn't accept any field before distinct and shows every row after distinct (if I put select distinct Location, Name ... ) [/snip] Can we see your table? Can you also write out what you expect the results to be? Thanks! Jay Blanchard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ID - sort problem
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 from 1. BUT: In my remote table, the records are displayed with ID *AND* Name in accending order wich doesn't happent to my local table: ID NAME 1ACH 2ADA 3ARIS ecc. (in remote table) ID NAME 1 XEN 2 VER 3 TOUR ecc (in local table) So how is possible to change the local table - I suppose this is only possible- to set the IDs identicals to Local+remote tables? I need this to pass the UPDATEs I make to local table by coping the query to remote table. PS. I deleted all recs on remote table, I export the data from my local and re-create the data to remote and I run the above query , still the same. I think something is different on Internet server's MySQL config. Thanks Makis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: a query from php doen't work
The problem was with the ; I ended my queries on each line (!!!) Not needed for only one query -one for every line. Thanks to you all and to those who send me prive Now runs on server too, only I had to change the filename to upercase.(Linux server) Makis -Original 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 Emne: a query from php doen't work I get a Query failed error on this: What could hapent? Try to alter this line: $result=mysql_query($buffer); to look like this: $result=mysql_query($buffer) or die($buffer.hr.mysql_error()); Then you will a) print the failed query, and b) print MySQL's own error-response. Then you cal probably figure out, what is wrong. - Carsten - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
a query from php doen't work
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
Makis
?php
$link=mysql_pconnect(localhost,root, );
mysql_select_db(test) or die(Could not select database);
$fd = fopen (c:\\tp5\\hotels.sql, r);
$i=0;
while (!feof ($fd)) {
$buffer = fgets($fd, 1024);
$i=$i+1;
print $buffer;
$l=strlen($buffer);
if ($l0)
{
$result=mysql_query($buffer);
if ($result==0) echo( Query failed, line $i , length $l BR);
}
}
fclose ($fd);
?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: swe7 character set - strange mappings?
Will you never put your files on the net? If so, what will you expect to
find at the remote server? Your character set?
IMO forget character mapping and use BINARY option at fields creation,
usally the contains will be upercase or lowercase, not both. The only
exeption I can think is to index - 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 going on here and I hope you can help me.
The swe7 characters set in swe7.conf has some really strange
mappings in it.
For instance, the to_upper array maps ASCII 0x7E (a tilde) to
0x5E (a hat
aka Ctrl character). Why doesn't a tilde remain a tilde?
Stranger still is the entry in the sort_order array that maps tilde (0x7E)
to Y (0x59). And worst of all, the last letters in the Swedish
alphabet (ä,
å and ö == 0xE4, 0xE5 and 0xF6) map to themselves which means that MySQL
sorts them case sensitively while the rest of the alphabet is sorted
case-INsensitively. Similar problems are present in the to_upper and
to_lower arrays so that lower('Ö') (e.g.) returns a capital letter.
I realize that I can make my own character set and I will do so
in order to
fix the problems I am seeing. But first I want to make sure that the
problems I describe above are indeed problems due to a buggy character set
and not user error on my part.
There's a good reference to the ISO-8859 character set that Swedish uses
here:
http://czyborra.com/charsets/iso8859.html#ISO-8859-1
I am using version 3.23.41.
Thanks in advance
Philip
filter fodder: sql query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: SELECT w/LIKE on Swedish character ö finds ], why?
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: SELECT w/LIKE on Swedish character ö finds ], why?
Hi Philip,
before running your test next time try this:
vi /etc/my.cnf
insert into this file:
[mysqld]
default-character-set = swe7
then stop mysql (mysqladmin shutdown)
and restart (safe_mysqld)
then try your test again. It worked fine for me.
Ken
Philip Semanchuk wrote:
Hi everyone,
I am having a little trouble with searching for Swedish
characters. When I
SELECT using LIKE I get matches that I do not expect. I have
created a
simple test case that is entirely reproduced below. To summarize,
I insert
one row into a single-column table that contains the right square
bracket
character (ASCII 0x5d). When I search for the Swedish letter ö
(ISO-8859-1
0xf6) I find the row containing the right bracket.
We're running RedHat 7.2 with nothing fancy added in as we're
Linux novices
and just playing around with the system to see how it works.
MySQL -V
produces this:
mysql Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386)
Here's my test:
mysql create database swedish_character_test;
Query OK, 1 row affected (0.00 sec)
mysql use swedish_character_test;
Database changed
mysql create table simple (name varchar(255) NOT NULL);
Query OK, 0 rows affected (0.00 sec)
mysql insert into simple (name) values (']');
Query OK, 1 row affected (0.00 sec)
mysql select name from simple where name like '%ö%';
+--+
| name |
+--+
| ]|
+--+
1 row in set (0.00 sec)
I'd appreciate any help understanding why ö = ] in this case.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: SELECT w/LIKE on Swedish character ö finds ], why?
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]]
Sent: Tuesday, March 26, 2002 6:45 PM
To: '[EMAIL PROTECTED]'
Subject: SELECT w/LIKE on Swedish character ö finds ], why?
Hi everyone,
I am having a little trouble with searching for Swedish characters. When I
SELECT using LIKE I get matches that I do not expect. I have created a
simple test case that is entirely reproduced below. To summarize, I insert
one row into a single-column table that contains the right square bracket
character (ASCII 0x5d). When I search for the Swedish letter ö (ISO-8859-1
0xf6) I find the row containing the right bracket.
We're running RedHat 7.2 with nothing fancy added in as we're
Linux novices
and just playing around with the system to see how it works. MySQL -V
produces this:
mysql Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386)
Here's my test:
mysql create database swedish_character_test;
Query OK, 1 row affected (0.00 sec)
mysql use swedish_character_test;
Database changed
mysql create table simple (name varchar(255) NOT NULL);
Query OK, 0 rows affected (0.00 sec)
mysql insert into simple (name) values (']');
Query OK, 1 row affected (0.00 sec)
mysql select name from simple where name like '%ö%';
+--+
| name |
+--+
| ]|
+--+
1 row in set (0.00 sec)
I'd appreciate any help understanding why ö = ] in this case.
Thanks in advance,
Philip
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
exanging vars between form/php/javascript
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 submit
there to a php script. How is possible not to run another php but to stay on
the same php script to show all $line fields in a page?
The code:
===
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
$cnt = $cnt+1;
print \ttr\n;
print \t\ttd bgcolor='#C0C0C0'B$cnt/B/td\n;
$cnt2=0;
foreach ($line as $col_value) {
$cnt2=$cnt2+1;
$ID=$line[ID];
if (($col_value!=$line[ID]) AND ($cnt231)) {
if ($col_value==$line[Name]) { $col_value=a href=.''.$col_value.'
onMouseOver=show_rec(ID)'.$col_value./a; }
if (($cnt % 2) ==0)
print \t\ttd bgcolor='#D0FFD0'$col_value/td\n;
else
print \t\ttd bgcolor='#CC'$col_value/td\n;
}
}
print \t/tr\n;
}
Makis
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: what's wrong with EXPLAIN?
Thanks. But I think, it would be more usefull to INSERT/UPDATE as they change the talbe's contents. Makis -Original Message- From: Cary [mailto:[EMAIL PROTECTED]] Sent: Monday, March 11, 2002 12:16 AM To: [EMAIL PROTECTED] Subject: Re: what's wrong 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 statements. Cary At 12:10 PM 3/9/02, savaidis wrote: 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? (field1 is a real of cource and I tried where field10.0 too with the same error) If I'm not shure 'explain' is working correctly, then how I will trust to use it? To show me errors where they doesn't exist? Makis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: what's wrong with EXPLAIN?
I give an example to make clear what I mean. I had a table with about 100 records scanned from a book. I scanned another 70 and when I finished with INSERT/correcting/INSERT ecc cycle, my table had about 500 records. Of course I had in mind this, so one field was set to '1' so I could delete 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] Subject: RE: what's wrong with EXPLAIN? Thanks. But I think, it would be more usefull to INSERT/UPDATE as they change the talbe's contents. Makis -Original Message- From: Cary [mailto:[EMAIL PROTECTED]] Sent: Monday, March 11, 2002 12:16 AM To: [EMAIL PROTECTED] Subject: Re: what's wrong 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 statements. Cary At 12:10 PM 3/9/02, savaidis wrote: 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? (field1 is a real of cource and I tried where field10.0 too with the same error) If I'm not shure 'explain' is working correctly, then how I will trust to use it? To show me errors where they doesn't exist? Makis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
what's wrong with EXPLAIN?
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? (field1 is a real of cource and I tried where field10.0 too with the same error) If I'm not shure 'explain' is working correctly, then how I will trust to use it? To show me errors where they doesn't exist? Makis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
is MySQL relational?
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/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: BETWEEN... LIKE query
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 surname_from and surname_to, I want to be able to do a select query where the results will lie between these to values. That's easy enough but I also want to include all results where the record field (surname) matches the first part of the fields - in effect a BETWEEN query incorporating the LIKE function. For example select * from consumers surname BETWEEN '$surname_from' AND '$surname_to' assume $surname_from = A and $surname_to = B would only return results where the surname is A or greater but less than B, but I would like to include all records where records also start with B. For example it would return A Allan Anderson Appleby B But I want it to return A Allan Anderson Appleby B Black Brown Butterworth Has anyone any ideas? Thanks in anticipation Craig Shepherd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: InnoDB frightens me...
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 table to 2 tables, one for each kind of update. Also I use a kind of transactions before I know that exists, I don't subtract from items directrly but I put it in a field named keeps. If user change his mind or something goes wrong, I only subtruct from keeps fields.Otherwise I subtract from items and keeps. Of course I have create another temp file with the invoice. I use these methods several years now mainly with C-tree from Faircom, they work fine. But to tell you the true, I use Delphi with Interbase for this kind of application on the net. I don't know if it's possible with PHP. Can someone directs me to the avantages of Inno base comparing wtih default MySQL? Row locking is the bigest one as I can read here? Thanks Makis -Original Message- From: Tobias Lind - Telia Internet [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 2:46 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: InnoDB frightens me... Thanks - that would be great! I'm sure a lot of people will find this very helpful. Regards, Tobias - Original Message - From: Michael Widenius [EMAIL PROTECTED] To: Tobias Lind - Telia Internet [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, March 05, 2002 12:36 PM Subject: Re: InnoDB frightens me... Hi! Tobias Hi! Tobias I'm in the same position as Steve: Considering switching from MyISAM to InnoDB because of the Tobias row-level locking capabilities. My application has quite a lot of updates/inserts mixed with Tobias selects, and is starting to suffer from the table-locking policy... Tobias And like Steve, I'm also scared! :) cut Tobias Maybe some of this confusion and fear could be avoided with a section in the InnoDB documentation Tobias that describes InnoDB from a MyISAM-point-of-view :) Tobias Explaining how all common things, principles and routines with MyISAM works with InnoDB. I'm sure a Tobias lot of people have very good knowledge of MyISAM and comes from the same direction as I do... I have forwarded this to our docmentation team and we shall try to do this in the near future. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
VARCHAR/CHAR problem
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.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
documentation about the various databases
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 check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: documentation about the various databases
I suppose I can't use InnoDB as I work remotly on a Internet Host. But if I can, can you explain me - shortly- the benefits of InnoDB copmaring with default MySQL? I see has the transactions but new MySQL has them too. Or if there is a comparison sheet somewhere. Thanks Makis -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'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? They are called table types... you can combine tables of different types in the same database. URL: http://www.mysql.com/doc/T/a/Table_types.html -- Roger query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: about installing mysql on windows 98
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, March 01, 2002 6:20 AM To: [EMAIL PROTECTED] Subject: about installing mysql on windows 98 dear sir, please help me out to install the mysql windows version.the problem is i have only windows 98 as stand alone.i donot have windows NT SERVER. so can mysql be installed on windows 98 as stand alone without the help of a server.please mail back. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Paul DuBois - Thank You
There is not your book here in Thessaloniki/Greece. This is the second bigest city of Greece. (at least at bigest bookstore I checked, they have only O'Reily books and they have only one about MySQL with 3 writers) So I intend to take a subscription to Safari but I want to know if I will have access to complete text of the book, how many points I need for this and if I can copy the chapters to my hard disk. Also in what form will be this copy : in html or in PDF? And will this be context-sensitive? But why you don't shell it in classic e-book form (with glassbook i.e.)? Please be 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:09 -0600 2/25/02, Paul DuBois wrote: At 21:35 +0200 2/25/02, savaidis wrote: Is there any electronic version of this book (e-book)? One of the chapters (the C API chapter) is online at the publisher's site, and there are some other pages available at Amazon. All of these are PDF format. There are pointers to this material at the book's companion site: http://www.mysql.com/mysql-book/ Otherwise, no it's not available electronically. I've been informed that I'm incorrect on this. MySQL is available electronically at: http://safari.oreilly.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Paul DuBois - Thank You
You download the program to read it and the source togeter. It is copy protected. Try www.glassbook.com (there are various solutions by Abobe) I have one Glassbook with poems, free, downloaded from a Greek bookstore. It works just fine and has many possibilites : it's contex sensitive, with 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' Subject: Re: Paul DuBois - Thank You Is not possible to copy e-book either, I think! =how could one download it then? (PS: You're so sick to read work books at home ? :) =if I work at home, does that mean I'm reading home-books at work, or work-books at home? - either way, yes I know, I must be doubly sick! BTW some of us enjoy our work/hobby! =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Hi
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 PROTECTED]' Subject: Hi Hi , I am using Mysql in Linux OS. I created a table in Mysql. The table has 3 fields and one is Primary key among them. I have populated 40K entries in the table. While populating the entries in the table, For each 500 entries that i populated in the table, i have searched for a single entry in the table using primary key and measured the time taken to complete the search. As the Number of entries grows in the table, the time taken to search for a entry are increasing linearly. Why is the time increases linearly? Is this the Mysql behavior? I read in Myself manual that, by default Mysql creates index file(.MYI) on Primary Key using B-Tree algorithm. My Question is , When Mysql using B-Tree for searching, Why the time taken to search for entries increases linearly as the entries in the table grows? According to B-Tree algorithm, the time has to be O(log n) , which is not linear as n increases. Even though if we assume disk overhead as some constant (typically O(log m), where m is the order ), it is not linear. Why is this happening ? Can any one help me out? Thank You, Battini Chandra Sekhar. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Paul DuBois - Thank You
I took 5 points with 10$, your book deserve only 1 ! :))) So I have 4 more points left to look for other books in one month I have subscription. It will take a couple of days to copy it in my HD as html. I take a first look to the book at the same time. Thanks Safari! (and Paul of cource ) 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. This is the second bigest city of Greece. (at least at bigest bookstore I checked, they have only O'Reily books and they have only one about MySQL with 3 writers) So I intend to take a subscription to Safari but I want to know if I will have access to complete text of the book, how many points I need for this and if I can copy the chapters to my hard disk. Also in what form will be this copy : in html or in PDF? And will this be context-sensitive? But why you don't shell it in classic e-book form (with glassbook i.e.)? Please be specific so I can send the subscription. These are all points that you should take up with the Safari people. I don't know the answers to any of these questions. (Not surprising, since I didn't even know there *was* a Safari edition until yesterday. :-)) 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/25/02, savaidis wrote: Is there any electronic version of this book (e-book)? One of the chapters (the C API chapter) is online at the publisher's site, and there are some other pages available at Amazon. All of these are PDF format. There are pointers to this material at the book's companion site: http://www.mysql.com/mysql-book/ Otherwise, no it's not available electronically. I've been informed that I'm incorrect on this. MySQL is available electronically at: http://safari.oreilly.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Paul DuBois - Thank You
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:09 PM To: MySQL List Subject: Paul DuBois - Thank You for the EXCELLENT index in your MySQL book. I developed several questions this morning and was able to find answers to all easily using the index in your book. Much appreciated. Craig [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Paul DuBois - Thank You
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 List' Subject: Re: Paul DuBois - Thank You On Monday, 25. February 2002 20:35, savaidis wrote: And why pay for paper? We live on 2000 no? Cause your wife/girlfriend will make some trouble, if you read digital books via notebook in your bed :-) Regards Georg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Comments in Documentation
One relative question: If with binary flag OFF the database makes upercase conversion to the field then where does it keep it? It dublicates it for search purposes? Because it is kept with origin form too, of course. Or it makes it on the fly? To slow I suppose and another friend on 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; [EMAIL PROTECTED] Subject: RE: Comments in Documentation At 19:54 +0200 2/23/02, savaidis wrote: I say by default means to do nothing, not to do the upercase conversion as I suppose it does to the fields. As it happens, the standard SQL behavior for LIKE is to not be case sensitive. Which is roughly equivalent to doing an uppercase conversion. You appear to be saying that it's a bad thing for MySQL to use the standard behavior. I haven't met since now the binary as an alternative to case sensitive and I'm quite old in programming and age believe me :) Also if I knew 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? Your original question appeared to imply that you already knew about LIKE, and that you were wondering where it was in the manual. Not that you were wondering whether there was any such thing in SQL itself. 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 +0200 2/23/02, savaidis wrote: Instead of binary it sould be better to use a case conversion flag with reverse function - NOT set by default. You have to have *something* on by default. I guess I don't understand what you're getting at. I'd say BINARY is reasonably concise. Perhaps you have an alternative, but you haven't actually specified any syntax, so it's difficult to say whether or not it might be better. Binary doesn't make sence to me. BINARY is nothing more than a synonym for case sensitive. As for LIKE I think most WHERE commands use it so it is obvious it should be there. I disagree. It is not obvious in the slightest that the section on WHERE should be turned into a list of possible functions that can be used there. Most such functions can also be used in the output column list, ORDER BY, GROUP BY, etc. Functions should be documented in the section on functions. As, in fact, they are. Makis -Original 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 SELECT command on MySQL manual! http://www.mysql.com/doc/S/t/String_comparison_functions.html http://www.mysql.com/doc/P/a/Pattern_matching.html I found manual very-very amateur work. I was trying about half hour to use WHERE FIELD1= mpla-mpla% I'm surprised that if you wanted to use LIKE, that you didn't just try it. Also binary at field creation or WHERE should be ON by default. What would the syntax be for turning it off? And WHERE works erroneously with Greek chars (without the binary option). I think it is comfused by other languages chars so it should be an option to declare the language character set at runtime (not at server cnf). Makis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Comments in Documentation
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 option). I think it is comfused by other languages chars so it should be an option to declare the language character set at runtime (not at server cnf). Makis -Original Message- From: Steve Rapaport [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 23, 2002 4:46 PM To: [EMAIL PROTECTED] Subject: Comments in Documentation Has anyone noticed that the comments in the Mysql on-line docs are almost entirely always off-topic? Compare, for example, to the PHP docs www.php.net What's strange is not the number of moronic posts (minimal), but the number of useful and often insightful posts that appear to have been entered under a totally random heading in the manual. (almost all!) Because those posts are obviously intelligent, it's making me wonder if perhaps the posters tried to post to a relevant heading and the software is perhaps broken and misclassifying them... If so, this is a bug report I suppose... Steve - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Comments in Documentation
Instead of binary it sould be better to use a case conversion flag with reverse function - NOT set by default. Binary doesn't make sence to me. As for LIKE I think most WHERE commands use it so it is obvious it should be there. Makis -Original 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 SELECT command on MySQL manual! http://www.mysql.com/doc/S/t/String_comparison_functions.html http://www.mysql.com/doc/P/a/Pattern_matching.html I found manual very-very amateur work. I was trying about half hour to use WHERE FIELD1= mpla-mpla% I'm surprised that if you wanted to use LIKE, that you didn't just try it. Also binary at field creation or WHERE should be ON by default. What would the syntax be for turning it off? And WHERE works erroneously with Greek chars (without the binary option). I think it is comfused by other languages chars so it should be an option to declare the language character set at runtime (not at server cnf). Makis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
benchmarks?
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? (not only data of INT field but all fields before)It works if I save to txt first? And I declare in 2 INT fields but it creates one field INT(3) and another INT(5) as I see at SQL window. Why? Thanks Makis QUERY - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Comments in Documentation
I say by default means to do nothing, not to do the upercase conversion as I suppose it does to the fields. I haven't met since now the binary as an alternative to case sensitive and I'm quite old in programming and age believe me :) Also if I knew 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: savaidis; [EMAIL PROTECTED] Subject: RE: Comments in Documentation At 19:28 +0200 2/23/02, savaidis wrote: Instead of binary it sould be better to use a case conversion flag with reverse function - NOT set by default. You have to have *something* on by default. I guess I don't understand what you're getting at. I'd say BINARY is reasonably concise. Perhaps you have an alternative, but you haven't actually specified any syntax, so it's difficult to say whether or not it might be better. Binary doesn't make sence to me. BINARY is nothing more than a synonym for case sensitive. As for LIKE I think most WHERE commands use it so it is obvious it should be there. I disagree. It is not obvious in the slightest that the section on WHERE should be turned into a list of possible functions that can be used there. Most such functions can also be used in the output column list, ORDER BY, GROUP BY, etc. Functions should be documented in the section on functions. As, in fact, they are. Makis -Original 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 SELECT command on MySQL manual! http://www.mysql.com/doc/S/t/String_comparison_functions.html http://www.mysql.com/doc/P/a/Pattern_matching.html I found manual very-very amateur work. I was trying about half hour to use WHERE FIELD1= mpla-mpla% I'm surprised that if you wanted to use LIKE, that you didn't just try it. Also binary at field creation or WHERE should be ON by default. What would the syntax be for turning it off? And WHERE works erroneously with Greek chars (without the binary option). I think it is comfused by other languages chars so it should be an option to declare the language character set at runtime (not at server cnf). Makis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: long query on php
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 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 high limit, no? Makis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 3:03 AM To: Nathan Cc: MySQL Subject: Re: long query on php Hi. I prefer doing like this $query = CREATE TABLE query ; $query .= tabledef for col a,; $query .= tabledef for col b,; $query .= lots more table defs,; $query .= welcome to line 400; You get the point i guess you can do same things many different ways in php:) /PM\ Alex Aulbach wrote: Yesterday, from Nathan: Since PHP ignores whitespace, I think this is also acceptable: PHP doesn't ignore whitespace in a quote. But your code is of course correct. $query = CREATE TABLE query tabledef for col a, tabledef for col b, lots more table defs, . welcome to line 400; Another way: (without test) $bladefault=24; $query = eoq; CREATE TABLE query ( idchar(2) default 24 # doublequotes work hugo char(2) default '24' # singlequotes work either bla char(2) default '$bladefault' # inline vars work ... ) eoq -- 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? Strings in PHP can be really, really long and are binary safe. Perhaps the problem is the editor? -- SSilk - Alexander Aulbach - Herbipolis/Frankonia Minoris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 and then alter? Thanks Makis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: long query on php
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 high limit, no? Makis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 3:03 AM To: Nathan Cc: MySQL Subject: Re: long query on php Hi. I prefer doing like this $query = CREATE TABLE query ; $query .= tabledef for col a,; $query .= tabledef for col b,; $query .= lots more table defs,; $query .= welcome to line 400; You get the point i guess you can do same things many different ways in php:) /PM\ Alex Aulbach wrote: Yesterday, from Nathan: Since PHP ignores whitespace, I think this is also acceptable: PHP doesn't ignore whitespace in a quote. But your code is of course correct. $query = CREATE TABLE query tabledef for col a, tabledef for col b, lots more table defs, . welcome to line 400; Another way: (without test) $bladefault=24; $query = eoq; CREATE TABLE query ( idchar(2) default 24 # doublequotes work hugo char(2) default '24' # singlequotes work either bla char(2) default '$bladefault' # inline vars work ... ) eoq -- 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? Strings in PHP can be really, really long and are binary safe. Perhaps the problem is the editor? -- SSilk - Alexander Aulbach - Herbipolis/Frankonia Minoris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: long query on php
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 high limit, no? Makis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 3:03 AM To: Nathan Cc: MySQL Subject: Re: long query on php Hi. I prefer doing like this $query = CREATE TABLE query ; $query .= tabledef for col a,; $query .= tabledef for col b,; $query .= lots more table defs,; $query .= welcome to line 400; You get the point i guess you can do same things many different ways in php:) /PM\ Alex Aulbach wrote: Yesterday, from Nathan: Since PHP ignores whitespace, I think this is also acceptable: PHP doesn't ignore whitespace in a quote. But your code is of course correct. $query = CREATE TABLE query tabledef for col a, tabledef for col b, lots more table defs, . welcome to line 400; Another way: (without test) $bladefault=24; $query = eoq; CREATE TABLE query ( idchar(2) default 24 # doublequotes work hugo char(2) default '24' # singlequotes work either bla char(2) default '$bladefault' # inline vars work ... ) eoq -- 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? Strings in PHP can be really, really long and are binary safe. Perhaps the problem is the editor? -- SSilk - Alexander Aulbach - Herbipolis/Frankonia Minoris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: long query on php
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 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 high limit, no? Makis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 3:03 AM To: Nathan Cc: MySQL Subject: Re: long query on php Hi. I prefer doing like this $query = CREATE TABLE query ; $query .= tabledef for col a,; $query .= tabledef for col b,; $query .= lots more table defs,; $query .= welcome to line 400; You get the point i guess you can do same things many different ways in php:) /PM\ Alex Aulbach wrote: Yesterday, from Nathan: Since PHP ignores whitespace, I think this is also acceptable: PHP doesn't ignore whitespace in a quote. But your code is of course correct. $query = CREATE TABLE query tabledef for col a, tabledef for col b, lots more table defs, . welcome to line 400; Another way: (without test) $bladefault=24; $query = eoq; CREATE TABLE query ( idchar(2) default 24 # doublequotes work hugo char(2) default '24' # singlequotes work either bla char(2) default '$bladefault' # inline vars work ... ) eoq -- 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? Strings in PHP can be really, really long and are binary safe. Perhaps the problem is the editor? -- SSilk - Alexander Aulbach - Herbipolis/Frankonia Minoris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 and then alter? Thanks Makis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: long query on php
The variable will be string of cource that contains nomore than 255 chars. No, I didn't even tried it :) (concatenation will be the same) But it has to be a way... It is a problem, because my internet MySQL base doesn't permmit me to login with MySQLfront as I have dynamic IP, for security and other reasons I can understand :) So is difficult to pass my local base's structure to my remote MySQL base. Makis -Original Message- From: Alain Fontaine - Consultant and developer [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 2:30 PM To: 'MySQL list (E-mail)' Subject: RE: long query on php Have you tried just putting the querys into a variable and pass the var along to mysql_query() ? Did it not work? --- Alain Fontaine 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 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: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: long query on php
The obious question is: (before I test it) This is concatenation to $query that is a string type, no? So the limit isn't also set to 255 chars too? Or is a trick especially for this case? Makis -Original Message- From: Johnny Withers [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 7:36 PM To: [EMAIL PROTECTED] Subject: RE: long query on php Or you could do it like this: $query=some query .some more of this query .still some more query .and so on and so forth...; ; The tabs are no needed, I just put them there to make it easy to understand that all those lines are actually just one line. - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.209.4985 -Original Message- From: Brett Burgess [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 11:25 AM To: [EMAIL PROTECTED] Subject: Re: long query on php Here is how I do it: $query = some query ; $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 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 Date: Wed, 6 Feb 2002 21:13:44 +0200 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: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
renumbering auto-increment?
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 somewhere? Or is there a pack command? 2) I use MySQLfront just for a couple of days. I find it very usefull (has to be written in Delphi) Is this the best freeware for this job or is there a better one ? Thanks Makis Thessaloniki Makedonia Greece - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
PHP with TTF fonts
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 stings are displayed on the image? This is to slow and consumes to much of server's memory. Thanks Makis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
