wing data fixed, which executed
"SHOW FIELDS..." and "SHOW KEYS..." twice.
- Fixed bug at resizing the pagecontrol at the bottom
- Fixed numerous tiny bugs
see the complete changes-log on http://www.anse.de/mysqlfront/changes.php
-
ry, I don't know..
On win32-hosts letter 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/man
> 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
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
-
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 mysql
xed a bug on the "Insert record"-button
- Bugfix: Not maximized windows causes every new window to be not
maximized too
- ODBC-Import: Asks for username and password now on selecting a DSN
- Updated libmysql.dll to latest version (3.23.39)
Greetings,
Ansgar Becker
---
> 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 ho
>
> 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:
http://ww
works
- 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:
> How can I transfer the data from a MySQL 3.22.32 running on RedHat
> 6.2 Linux to a MySQL 2.23.37 running on Windows 98?
MySQL-Front 1.18 (www.mysqlfront.de) is able to replicate directly between
two opened connected hosts : "Im-/Export" => "Export Tables" => "Output:
Another Host/DB". You only
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 YOU
> 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 m
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: M
s"
- Query-Tab: Now click on the dropdown-menu-command "Selection", if you want
only a range of the sql-script to be executed.
- Query-Tab: When executing one or more queries, Errors are collected at
first and shown at the end of the script-executi
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,
> key
> > 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 tabl
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 B
I think, CPU and disks are ok (if disks are scsi or raid). But if you want
to optimize it, throw as much RAM on your Database-Server as you can buy
(512 is not that much). But it depends on your service, too.
Greetings(),
Ansgar
> It will probably be a dual PIII 800mhz with 512mb ram and 3 physi
lot of time. If you make an application 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
---
(through php!).
I 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
> 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
-
g a simple "select *" on a table, you can at first send another query,
which returns the number of rows like "select count(*) from table".
Greetings,
Ansgar Becker
http://anse.de/ | [EMAIL PROTECTED]
-
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 cl
rectly from one database to another.
Get the actual version at http://www.mysqlfront.de/ or
http://www.anse.de/mysqlfront/
Greetings,
Ansgar Becker
[EMAIL PROTECTED] | http://www.anse.de
AB7670-RIPE
-
Before posting, please check:
http
27 matches
Mail list logo
