at the bottom
- Fixed numerous tiny bugs
see the complete changes-log on http://www.anse.de/mysqlfront/changes.php
-
Thanks for your interest!
Greetings,
Ansgar Becker (Anse
case doesn't matter, but I don't know if his server
runs on win32 or something else.
Greetings,
Ansgar Becker
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
perhaps have limited usefulness. Amd there are other tools for
getting a GUI interface to MySQL. If it can run off the command line
Please have a look at MySQL-Front: www.mysqlfront.de
Greetings,
Ansgar Becker
Hi,
since which version was the show create table syntax introduced?
I'm planning to implement it in MySQL-Front for the database-export-options,
but I have to check the version first.
Greetings,
Ansgar Becker
-
Before
Hi,
I think datafile-compatibilty was introduced in 3.23.xx . To get these old
files imported, I would set up a tiny solaris or linux machine ( I think
there is a free solaris version for PC) then install the (exactly!) same
version (download from mysql.com) as on your old machine. Then run
-Import: Asks for username and password now on selecting a DSN
- Updated libmysql.dll to latest version (3.23.39)
Greetings,
Ansgar Becker
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
is it true that dots were legal in MySQL 3.22.32?
i think they were legal.. but it's a very good question - because this leads
to an error:
show tables from test.db
- You have an error in your SQL syntax near '.db' at line 1
If there is a db with a dot in it, you have only the chance to get
The only thing I would like is to be able to attach a comment to a
connection id which could be returned by the mysqladmin process
command. And something that would not add more load to Mysql nor
more coding in the client.
Yes!! Great idea. This would be helpful for hosters
grant all privileges on *.* to jbrunk@%
and it goes into the user table of the database mysql, and shows that the
host that jbrunk is allowed to connect from is % but it won't let me
connect from mysqlfront
did you FLUSH PRIVILEGES ?
Greetings,
Ansgar
if i set a field as a primary key, does it automatically make sure its
unique or should i declare a UNIQUE constraint as well? or will primary do
the job by itself.
a primary key is always unique. No need to give it an extra unique index.
Greetings,
Ansgar
http://www.mysqlfront.de/
Please inform me how to load IMAGES INTO MYSQL TABLES.
You can do so with MySQL-Front - www.mysqlfront.de . Simply paste image from
clipboard into BLOB-Editor.
Greetings,
Ansgar
-
Before posting, please check:
- Fixed access violation on application exit
- Query-Tab: Loaded SQL-Files no longer disappear from dropdown-menu
after exit
Thanks for your interest!
Greetings,
Ansgar Becker (Anse)
-
Before posting, please check:
http
Hi,
my question is: is it possible to load in a Longtext column
a .txt file? furthermore, is it possible to do that with a .xml file?
of course..
at first you must use seperator, field-encloser and line-terminator, which
is not contained in your data. for example this way:
SELECT *
FROM
I'd like to get informations from my MySQL Server on LiNUX, and the query
must be made from a Mac (Not an Os X)! Is there a good solution ?
If it's not possible, How can I get access to a PC With windows ?
If you run windows, have a look at MySQL-front 1.18:
http://www.mysqlfront.de
on a mac
Have a look at MySQL-Front:
http://www.mysqlfront.de/
it will do extactly what you want. Please be careful: the
ODBC/Access-Importing has beta-quality.
Ansgar
-Ursprüngliche Nachricht-
Von: Terrell Johnson [EMAIL PROTECTED]
An: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Gesendet:
have_vote ENUM (3),
must be this:
have_vote ENUM ('3'),
Greetings,
Ansgar
What is the error in this sql query ???
_
CREATE TABLE page(
page_ID INT (9) UNSIGNED DEFAULT '0' NOT NULL AUTO_INCREMENT,
relative_path VARCHAR (200) Not NULL,
keywords
at
first and shown at the end of the script-execution. They don't stop the
whole SQL-script now.
-
Thanks for your interest!
Greetings,
Ansgar Becker (Anse
is it possible to get *one* quick result with the rowcount of each table
in
one database, without knowing the column-names?
this does *not* work:
select count(t1.*), count(t2.*)
from table1 t1, table2 t2
Select 'Table1' as tableName, count(*) as rowCount from table1
UNION
Hi,
is it possible to get *one* quick result with the rowcount of each table in
one database, without knowing the column-names?
this does *not* work:
select count(t1.*), count(t2.*)
from table1 t1, table2 t2
Manual doesn't say anything about that.
Greetings,
Ansgar Becker
think execution time depends very much on database-design.
Greetings,
Ansgar Becker
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
with the C-API, which
executes exactly only the query and *nothing* else, you would get much
better results.
Greetings,
Ansgar Becker
[EMAIL PROTECTED] | http://www.anse.de
AB7670-RIPE
-
Before posting, please check:
http
I'm new with Mysql database there is anybody that could explain to me how
to
create an user in a specific database with encrypted password?
simply use MySQL-Front (www.mysqlfront.de) - adding users with specific
restrictions is very easy there.
Greetings,
Ansgar
Get the actual version 1.17 of MySQL-Front at http://www.mysqlfront.de/ or
http://www.anse.de/mysqlfront/
Greetings,
Ansgar Becker
[EMAIL PROTECTED] | http://www.anse.de
AB7670-RIPE
Hi, I'm new to MySQL. I'm using it in Windows 2000. I'm just wondering if
there is any great client side tools
://www.anse.de/mysqlfront/
Greetings,
Ansgar Becker
[EMAIL PROTECTED] | http://www.anse.de
AB7670-RIPE
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
24 matches
Mail list logo