The person I was working with pointed me to a little used link on their
site, and I believe that all of us here should take a look at it when we
have time.
It's a link to get the draft copy of the SQL-200x standard, which,
according to him as he is on the ISO SQL committee, is fairly near ready
to be released. He also says there will be no more fixes to it, other than
spelling/typo fixes.
Here is the link:
http://www.jtc1sc32.org/sc32/jtc1sc32.nsf/23933607697154bf852566160054bcf7/…
You want the first PDF file.
Most notably in it, I find that some things that MySQL thinks are valid,
are NOT part of the SQL standard. ESP how it does the valid identifier
tokens that I had trouble with.
MySQL claims valid tokens are:
([A-Za-z$_0-9]*[a-zA-Z$_][A-Za-z$_0-9]*)
But the standard says:
([a-zA-Z][a-zA-Z_0-9]*)
There are a number of other things, so such a point where I have this
question:
Should we explictly support MySQL where it diverges from the standard, or
only support the SQL standard, with minimal MySQL extensions?
--
Robin Hugh Johnson
E-Mail : robbat2(a)orbis-terrarum.net
Home Page : http://www.orbis-terrarum.net/?l=people.robbat2
ICQ# : 30269588 or 41961639
Hi,
I would like to understand the change made today in sql.php3.
If I understand correctly, it is to avoid doing the big query if we are just
displaying the sql-code of the previous query.
If this is the case, I think we should also remove the navigation bar
(show x rows...), the insert new row, print view, bookmark label,
and avoid the "undefined variable" on $fields_meta at line 493.
Marc
I'd like to contribute to phpMyAdmin project, but you already have a lot
of very knowledgeable people for PHP. What do you think if I will
redesign the front page of http://www.phpmyadmin.net in a neat way? I
will send you few samples, ok?
--
Regards,
Admin
http://www.zaraz.com
Hi List,
A few months ago, after there was an article on slashdot about an SQL
Validator product that you could use freely via the web, I contacted the
company behind it, and suggested that they make a web service version of
the web page they had before, that could be used from within other
applications.
One of their developers that saw my email, and was a great fan of
phpMyAdmin got back to me, and said he'd talk to management about it.
I didn't hear anything for a few months, until a few weeks ago, he
contacted me again, with access to the prototype of the service.
I wrote a small (~15 lines + PHP classes from ActiveState) PHP client that
works wonderfully for the initial version, and we saw his service was
great.
As an optional feature, I would like to include the PHP calls to the
SOAP service in phpMyAdmin. It would get a link in the query box, just
like we currently have for the 'PHP Code' and it would enable you to click
on the link and send the data to Mimer via the SOAP service to be
validated.
In addition to just validating the query, if there is anything wrong with
your query compared to what the standards, it lists each error, along with
possible corrections. Up till yesterday, it was only in a text format, but
as of later today, it will be a parsable XML format that I have had input
on the design of.
I foresee an additional option for it's use. If you type in a query, and
the MySQL server gives you an error message, then run the validator as
well, and it will list possible corrections for each error in the query,
allowing newbie SQL users to debug their SQL queries in record time.
Just a note, DB-config is now officially postponed until 2.3.1, as it
needs some more design work, due to a few things pointed out to me
regarding security.
MySQL parser now passes every one of the tests that are bundled with
MySQL, so I think it is ready :-).
--
Robin Hugh Johnson
E-Mail : robbat2(a)orbis-terrarum.net
Home Page : http://www.orbis-terrarum.net/?l=people.robbat2
ICQ# : 30269588 or 41961639
hi everybody,
one thing i'd really like to do now, before the rc3 is to have a chance for
the user to see why the relationstuff is not working. what i'd like to do
is:
when relation_lib deactivates relations have a link on the frontpage saying
relation features deactivated, please click here for analysis
then link to a page that will just answer
tbl_relation ... <font color="green">OK</font>
tbl_coords ... <font color="red">not found</font> [Doku>
where [Doku] would be a link to documentation.html where it explains how
tbl_coords should look like.
(and of course enter a variable
DontWarnAboutRelation = FALSE;
to config.inc.php3
now, i don't think it is absolutely necessary to translate OK,not found and
Doku, but of course there would be that one sentence on the main page.
so do you want me to wait with that for 2.3.1 (i wouldn't like that as i
think it might really help some users and therefore should be there when we
first officially release with the new features)
or can i implement it and we just ignore if this warning stays english for
some users (Documentation.html is also only available in english, so whoever
sets up pma has to be able to read english and this warning is meant to help
the admin not the users)
cheers
Mike
On Fri, 12 Jul 2002, Beck, Mike wrote:
> > Should we explictly support MySQL where it diverges from the
> > standard, or
> > only support the SQL standard, with minimal MySQL extensions?
> >
> hmm, at least there are some where i really think it is dumb that MySQL
> allows them: especially the _ because it is a wildcard as well, and you can
> get into problems using it.
I definetly agree some of the problems are due to MySQL not following the
SQL standards.
For the moment, I'm going to integrate my tokenizer as is, along with the
extractor and pretty-printer. I'm working on a tokenizer that follows the
SQL standard more closely, and I'll replace the current tokenizer with the
new one that is faster and mostly standards compliant in 2.3.1. There are
a few things MySQL has that I think should stay. Most notable amongst them
is hexadecimal numbers.
--
Robin Hugh Johnson
E-Mail : robbat2(a)orbis-terrarum.net
Home Page : http://www.orbis-terrarum.net/?l=people.robbat2
ICQ# : 30269588 or 41961639
Hi
I'm newbie with phpmyadmin
Could you help me?
Two Help:
1) I installed on RedHat PHPMYADMIN to use my personal mysql database but i see that those interface connect only TEST database, how to set the others databases?
2) I have to replace a databse CSV (ex. "first name"; "last name"; ) form a old database ACCESS .... on excel it's fine but on PhpMyAdmin there is not a page to import a CSV table. Coud u explain me how to do it?
Sorry for my english, i'm italian.
Thanx
I'm italian, my english is not good