MySQL-Front Update: Version 2.0 available
Hello *.*, The new Version (2.0) of MySQL-Front is available: Download at http://www.anse.de/mysqlfront/download.php Again, this version comes with some new features, many bugfixes and improvements, which were requested by some users. -- Changes to the last version: -- New Features: - Usermanager now with support for editing existing users - Interface now Windows(r) XP ready - Added multi-language-support - currently only english and german (Set in Tools->Preferences) - Data-Grids: Specify your favorite font for viewing data - this is especially helpful for users which need a different characterset (e.g. greek) - Added table-types InnoDB and BDB on the create-table-window and to the table-popupmenu - Application-startup allows an sql-file as parameter, so you can associate ".sql"-files to be opened with MySQL-Front (this is an optional task during installation) - Added "auto-refresh"-option to the processlist-tab - Database-Tree allows dragging databases or tables into query-window - Query-tab: sql-memo accepts dragged files from Windows(r)-Explorer - Query-Tab: Added a timer for SQL-execution - SQL-History: Added menu-item "Save as textfile" Improvements: - ODBC-Import: Cursor for reading tables now server-side instead of client-side, which resulted in reading all data on selecting a table - Query-Tab: "Explain"-queries are now recognized to return a result-set - Adding a user automatically flushes privileges - Database-Tab: Removed annoying drag-and-drop-operation for using the "Copy table"-command - Date and Time-Fields are now displayed as native strings even when the option "show native contents of certain fields" is turned off. - Added MySQL ABs new official logo-image in the about-box - Added some information lines at startup to the sql-history, which report statistics and if some illegal database-names were found - Data-Tab: DB-navigator was moved to the main-toolbar at the top - Query-Tab: Toolbuttons were moved to the main-toolbar at the top - Toolbars now drag-and-drop'able - Tools->Preferences->SQL-Font-dropdownbox now only shows fixed-pitch fonts - Most internal queries now use the backtick (`) for databases, tables and columns - "Copy Table" now also copies indexes from the original table - Field-Editor: Disabled length/set- and default-edit for BLOB- and TEXT-fields Bugfixes: - Query-tab: fixed some bugs with internal escape-function, which caused problems with quotes and doublequotes - ODBC Import: Selected database will be used instead of mainscreen's actual db - Export tables: fixed bugs with escaping special characters - Removed access-violation on running queries at startup, when no database was selected - Export Tables: selecting only data without structure exports insert-statements now adds commas between values - Export Tables: export to another host/db, when there is only 1 DB on the target-host, clicking on this option does not produce an error message like "You need at least 2 connection windows". - Data-tab: sql-errors now don't disturb further functions of Data-Grid - Removed annoying bug at viewing 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 - Thanks for your interest! Greetings, Ansgar Becker (Anse) - 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: Re:MySQL-Front can't open some InnoDb tables ***
Hi *.* > what could cause the problem Brent reports in MySQL-Front? > > InnoDB returns the error "Can't open file mytable.InnoDB" > when it cannot find the table in its internal data > dictionary. Maybe the case of letters in the database name > is wrong? Sorry, 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/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: Re: MySQL GUI
> 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 - 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
show create table
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 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: Unix - Windows migration
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, connect and import the data to the old machine. Greetings, Ansgar -Ursprüngliche Nachricht- Von: "Dick Davis" <[EMAIL PROTECTED]> An: <[EMAIL PROTECTED]> Gesendet: Donnerstag, 26. Juli 2001 23:21 Betreff: Unix - Windows migration Hello, On the project I am working on is a MySQL database generated on Sun/Solaris. If memory serves the MySQL version was 3.2.xx on the Sun. On Windows98 the MySQL version is 3.23.39.1 The Sun datafile cannot be read. The file extension in the tables is .ISD and .ISM for Sun, and .MYD and .MYI on W98 machine. The Sun data was deliverd on a CD, and the box is out of service. The queation is: How do I get the PC version of MySQL to talk to the Solaris version. All help will be greatly appreciated. Dick Davis Skyline Data Systems [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
MySQL-Front 1.22 available
Hi *.*, MySQL Front 1.22 is available - download at http://anse.de/mysqlfront/download.php Changes: 1.22: - Added option in preferences-dialog: "Show native field-contents for Text-, BLOB- and Date-Fields" - Changed "Default Column-width in datagrids" to "Maximium column-width", which means, that only columns are resized, which are bigger than this value, not just all columns 1.21: - no longer called "beta"! - Default column-width (preferences) applies to grid on the query-tab, too - BLOB-Editor was moved to the bottom of window - a new PageControl manages the three Tabsheets SQL-History, BLOB-Editor and SQL-Filter. Therefore the BLOB-Editor and the Filter-Dialog were removed - Specify table-type on the create-table-window (ISAM, MYISAM, MERGE, HEAP, automatic or userdefined) - Table-Tab: optimize-/check-/analyze-/repair-commands in the context-menu now apply to all selected tables, not only to the one, which has focus - Data-Tab: enum-fields show always their real values, not their boolean equivalents like "TRUE" or "FALSE" - Advanced Table-Propertis shows all selected tables, not only the one, which has focus - Limit checkbox checks/unchecks the limit-menu-command - Database-Tabsheet: re-organized popupmenu-structure - Database-Tabsheet: Added a "Copy Table"-function, which executes a user-defined CREATE TABLE ... SELECT ... FROM ...-statement - Database-Tab: Added a "Change table-type.."-function (ISAM, MYISAM, MERGE, HEAP or userdefined) - Database-Tab: New Column: "Size" - which represents the KB used on the server for the table - Print tables-list, table-structure, variables-list and so on with a simple printing dialog - Renaming a table doesn't add the old table to the database-tree - Changed the create-/drop-database-commands to use the internal API-function - this allows creating/dropping dbs with not quite legal names (e.g. with dots in it: "my.database") - Fixed bugs in internally used string-functions - Fixed 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 - 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: MySQL 3.22.32 and dots in db name
> 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 tables over API-functions (e.g. mysql_list_tables() in C-API) Ansgar - 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: Re[4]: Proposition: Attach a comment to each connection
> 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 with many client-connectors to identify them. It could contain for example the name of the client-application ("useragent"), client-OS and some version-info. i think 100 chars will do. Greetings, Ansgar http://www.mysqlfront.de/ - 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: MySQL Installation Help Requested.
> > 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 - 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: unique and primary constraints
> 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/ - 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: Help me HOw to load Images or pictures into MYSQL database
> > 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://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
MySQL-Front 1.19 available
Hello *.* The new Version (1.19beta) of MySQL-Front is available: Download at http://www.anse.de/mysqlfront/download.php The main reason for this update is the new editing-grid, which was requested by many users. I said goodbye to the old component (StringAlignGrid) and implemented the ZEOS Database Objects. Special thanks go to Capella Development Group. Changes to the last version: - Data-Tab: Edit data with a standard data-aware grid-component and a DB-Navigator (Buttons for editing, deleting and inserting) - Support for BLOBs now: Bitmap/GIF/JPEG-Support - Data-Tab: Set complex filter for where-clauses now - Copying/Saving data to HTML-tables now generates cleaner HTML and doesn't stop before last record - Copying/Saving CSV-data now with field-terminator, field-encloser and line-terminator (specified in preferences) - Setting a table-comment with quotes now 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: 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: transfering data
> 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 have to be connected to both hosts at the same time. Greetings, Ansgar - 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: longtext
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 YOURTABLE INTO [LOCAL] OUTFILE 'c:/out.txt' FIELDS TERMINATED BY '}}' FIELDS ENCLOSED BY '{{' LINES TERMINATED BY ']]' Then you can easily import this file with MySQL-Front (http://www.mysqlfront.de) . Use the "Import/Export" => "Import Textfile". There you must specify your seperator, field-encloser and lines-terminator. Greetings, Ansgar - 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: Making SQL request from a Mac
> 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 I would prefer the browser-based phpMyAdmin: www.phpwizard.net Ansgar - 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: convert an ms access database file
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: Mittwoch, 6. Juni 2001 13:41 Betreff: convert an ms access database file > I need to convert an ms access database file to a mysql compatible pipe delimited database file. I downloaded a program to convert the database, but it needs to connect to the mysql server on my dedicated server. When I try to connect it says 'ipaddress.internetprovider' is not allowed to connect to this MySQL server. How can I use the GRANT/REVOKE command through mysql to grant myself access to it? > > > > > - > Sign up for ICQmail at http://www.icq.com/icqmail/signup.html > > - > 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
MySQL-Front Update
Hi everybody, The new Version (1.18beta) of MySQL-Front is available: Download at http://www.anse.de/mysqlfront/download.php Again, this version comes with many bugfixes, enhancements and some new features, which were requested by some users. Changes to the last version: - Removed access-violations on renaming and deleting tables - Slightly reorganized main-menu-commands ("Extra" is now "Tools") - Removed parse-error after SHOW PROCESSLIST - New: Import databases through ODBC or directly read from MS-Access-Files now! (beta-stadium) - New: Table-Diagnostics - optimize, check, repair and analyze tables through the menu-command "Tools"->"Table-Diagnostics" or directly through the context-menu of one table - New: Index-Editor - manage (concatenated) keys in the field-editor-window - Import Textfile: move columns up and down to customize your CSV-Data - "Export tables" - 2 New ouput-options: - Another Database on the same host - A database on another host, which is connected by MySQL-Front. This allows a direct replication between two MySQL-hosts(!) - Database-Tree: if a database is selected, rightclick gives you a "Drop Database"-command, if a table is selected, it shows a "Drop Table"-command and the DB-command is disabled. In addition, I removed the shortcut "del", because some users wrote me, that this can result in accidently removing a database. - Database-Tree: Refreshing the database-tree doesn't set the first entry as selected item, but remembers the last selected table or database - Database-Tab: If host-version >= 3.23.00, MySQL-Front uses SHOW TABLE STATUS instead of SELECT COUNT(*) for each table. If version >= 3.23.00 Type, Creation-Time and Comment are additionally shown - Database-Tab: Select more than one table at once now => Drop or Empty multiple tables - Data-Tab: Click on column-headers now for ordering records - Data-Tab: updates and deletes within the data-tab without having a primary key in a table are done with the pseudo-clause where Column1='foo' and Column2='bar'... => therefore the message "No primary key is defined..." was removed. - Data-Tab: Fixed bug at deleting and updating records with multiple primary keys, which had not the same sequence-order as the fields - Data-Tab: On updates only changed fields are included in where-clause - Data-Tab / Query-Tab: "Copy contents as HTML-Table" - makes a formatted HTML-Table out of all rows and copies it to Clipboard - Field-Editor now allows adding new fields between existing fields - Preferences: Log last n lines in the SQL-history - this is especially usefull, if you're executing very large SQL-Scripts, which were logged after executing and wasting an enourmous amount of RAM - Preferences: Configure your favorite color-coding scheme in "Tools"->"Preferences" - 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-execution. They don't stop the whole SQL-script now. - Thanks for your interest! Greetings, Ansgar Becker (Anse) - 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 is the error in this sql query
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 VARCHAR (200) , > have_vote ENUM (3), > PRIMARY KEY(page_ID), > UNIQUE(page_ID), > INDEX(page_ID) > ) - 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: count(*) on different tables
> > 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 > Select 'Table2' as tableName, count(*) as rowCount from table2 > ... > etc > > Assuming that MySQL can use the UNION clause. (I haven't checked) I think MySQL actually doesn't support union. ;/ I wonder if this is so difficult.. Only getting rowcounts of different tables in one result. I tried also the folliowing: select count(*) from table1, table2. But this (curiously) returns "table1rowcount * table2rowcount" Greetings, Ansgar - 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
count(*) on different tables
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 - 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: which db server
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 physical disks. > We have the option of changing this a bit. > > What would give us the best performance ? > More ram : how much ? > more CPU's ? > Any comments ? - 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: Performance MySQL with C-API
> Could you have a better disk environment on the Solaris machine versus the > win32-machine? The Solaris machine was a little bit slower executing the query, but it runs as a production-webserver and there is much more load on it than on my win32-test-machine. > query that inserted 1 string values, but wouldn't it make a great > difference if you made 1 queries that each inserted only one value?? > that's more my situation and I think that's a lot slower, but I do agree I tested it with 10.000 queries executing one after the other with MySQL-Front, too. Result: about 20 seconds. You must notice one thing: executing one query with a GUI like MySQL-Front means not only "executing", but *many* other things too: desplaying the query in the history-window, finding out, if the query returns a result and so on. These side-mechanisms take a 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 - 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: Performance MySQL with C-API
> insert 200 strings + timestamps a second through the API. Does that sound > too less or am I expecting too much? Do benchmarks or test results for the > C API exist? If someone has more experience on this or knows a place where > I can find out more, plz let me know. I just ran this test on a win32-machine with 500MHz, 196 MB RAM and IDE-drive: - created table test with 3 fields: id (unsigned int, primary key, autoincrement, not null), string (varchar 128), ts (timestamp 14) - generated 10.000 random string-values (32 chars each) and made 1 insert-query out of them: insert into test (string) values (randomstring1), values (randomstring3), ... values (randomstring1) - executed this query with mysql-front (same as C-API) Result: less than one second execution time! On our sun solaris (450MHz, 256RAM) the same query needed 1,6 seconds (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 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: User
> 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 - 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: GUI client for large SELECT query results
> With mysql_use_result () I have the problem, that the client do not > know in front, how many records matched the query. > > But if the GUI client user wants to see the last but 30 query result > records, e.g., > I have to know recordnumber of the last matching record. Having 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] - 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: client side tool of MySQL
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 of it, like the toad for oracle? actually I'm not expecting it to be that functional, but at least i wish it's better than the one in the mySQL package. - 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: Question about MySQL GUI on Win32
> It depends on the gui you're using. Get the one at my.anse.de > > At 07:49 AM 4/24/2001 -0700, Jason Holliston wrote: > >This is probably something I'll smack my head about afterward, but here > >goes: is it possible to execute multiple queries in the MySQL client GUI > >on Win32? What's accepted on the command line or in a .sql script > >doesn't work when pasted into it. Thanks in advance! The old subdomain my.anse.de is no longer working, because I switched to another provider, which doesn't support subdomains. ;/ But he's giving me much more traffic for all you guys downloading MySQL-Front - 6000 downloads last month = about 3 GB !! ;) . I'm currently working on the next version 1.18, which comes with ODBC-Import, partial SQL-execution, table-diagnostics and the option to export tables directly 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://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