Re: MySQL Administration Tools
At 11:19 -0800 1/22/04, David Blomstrom wrote: I'm using a preconfigured package that includes PHPMyAdmin, which seems to be a pretty good program. However, I just read that similar programs are available, including MySQL Control Center, EMS MySQL Manager, urSAL, PremiumSoft MySQL Studio and MySQLGUI. I just wondered if there might be some advantage to having two or more such programs installed. Would working with MySQL through two different interfaces give you a different perspective, making it a little easier to understand? Or are there particular strengths each program has? Also, would different MySQL administration tools conflict with each other? If you created a new database with phpMyAdmin, would it be recognized by MSQL Control Center? Could you work on MySQL with both programs on at the same time? I just wondered if there might be some advantage to having two or more suchprograms installed. Would working with MySQL through two different interfaces give you a different perspective, making it a little easier to understand? Or are there particular strengths each program has? I believe so, as you get different persectives from different interfaces. As far as easier to understand, I think that's relative to one's current understanding -- certainly different people prefer different tools. Many of the programs attempt to provide the same basic functionality, but certainly most have some key strengths -- a tool like urSQL, for example, isn't as strong at administration, as it's geared more toward SQL development, query testing, and ad hoc queries. Also, would different MySQL administration tools conflict with each other? No, I'm not aware of any conflicts between MySQL tools and it doesn't seem likely that there would be. If you created a new database with phpMyAdmin, would it be recognized by MSQL Control Center? Definitely. The database creation is handled at the MySQL server and is independent of the tool. Could you work on MySQL with both programs on at the same time? This should also be possible. However, you might want to be careful with updates and deletes as one program could easily overwrite a previous update or incorrectly identify a row (e.g. when a value of a where clause changes). -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: simple windows client for mysql
Check out urSQL from http://www.urbanresearch.com/ursql You might also have a look at the MySQL website, there are many different clients available... On Tue, 21 Jan 2003, David Driscoll wrote: I have a fairly basic mysql database running on unix. Now I need to make this data available to other people. These would be various engineers and administrators using every version of windows from 95 (japanese version) to XP all using laptops connected to our internal network. I am looking for an easy to use, easy to install mysql client which would enable users to query my database. It seems that installing mysql server for windows on each machine would do this but it seems like using a shovel to swat a fly. Suggestions? Cheap is good too. Thanks Dave Driscoll - 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: Table solution
You can use mysqldump to export the data from your webserver to a file, ftp the file, and import into your local database. There are also some tools that might help -- urSQL (http://www.urbanresearch.com/ursql), for example, can export query results directly to Excel. This means you could connect urSQL directly to your webserver database (provided it's accessible), submit a select * from my_table, and export the results directly to an Excel file... There are other tools that provide similar functionality. If you want to do it manually: 1) mysqldump on the webserver (http://www.mysql.com/doc/en/mysqldump.html) 2) Transfer the file to your local machine 3) Import into mysql (mysql dump-file.sql) On Mon, 11 Nov 2002, Lamar wrote: I want to copy a table from a webserver that has MySQL database server located on it, then, ftp to my local machine to insert into my local database. any ideas on how to do this? my goal is to create an Excel spreadsheet from the table for distribution. I have created the spreadsheet using the database on my local machine, but I want the database on the webserver. - 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: sql
This behavior is okay and is normal. MySQL sees the varchar(20) column [identified by `item`] and because one column is variable, MySQL changes all columns to be variable... Have a look at the MySQL manual here: http://www.mysql.com/doc/en/Silent_column_changes.html On Tue, 13 Aug 2002, Pushkar Pradhan wrote: I'm not very familiar with dbs, I'm creating tables in mysql 3.23.49 and even though I specified a field as CHAR (e.g. customer CHAR(9)) when I do a show create table on this table it displays that this field is a VARCHAR(9). | sales | CREATE TABLE `sales` ( `item` varchar(20) default NULL, `employee` varchar(9) default NULL, `quantity` smallint(5) unsigned zerofill default NULL, `price` float default NULL, `customer` varchar(9) default NULL, `date` date default NULL ) TYPE=MyISAM | Is this okay behaviour? -Pushkar S. Pradhan - 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: editor
Have a look at urSQL -- http://www.urbanresearch.com/ursql/urquery.php urSQL is a query editor (much like a text editor with database/query support and SQL syntax highlighting). It has the capability to connect directly to your server and submit the query. The History feature keeps track of each query that is submitted to the database. You also have the option of saving, opening, and editing existing queries. On Wed, 8 Aug 2001, Naintara Jain wrote: actually all i need to know is say i type in a long sql query and make a typing error, is there any convenient way to retain the query and make the correction without having to re-type the entire query? eg. when i work with sybase on linux, i simply use 'vi' within sybase and can correct the last query in memory. Even Oracle has an editor for saving/editing queries and running them. I don't really need a query-creator. If i use notepad, copy and paste doesn't seem to work -- MSDOS hangs. Do i need to make them into script files and then run? - 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 GUI for Windows
urSQL - http://www.urbanresearch.com/ursql On Mon, 12 Feb 2001, indrek siitan wrote: Hi, can anyone suggest a good GUI client to suggest to MySQL hosting customers? it should: * be able to display table structures, add and alter tables (field, indexes) * show and edit table data * be freeware (or it can be half-commercial, as long as the above functionality is available without paying) * ask for database name in the connection parameters or only display the list of databases user has access to Rgds, Indrek --- Indrek Siitan, CEO eMotion Ltd. [http://www.eMotion.ee] e-mail: [EMAIL PROTECTED] Narva mnt 31, 10120 Tallinn Estonia GSM: +372 50 17621+372 6605 890 - 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