Re: Browsing Tables
If you're using Windows, you can use an application like urSQL (http://www.urbanresearch.com/ursql) for easy viewing, adding, editing, deleting, etc, or any of a number of available graphical clients... You may also want to have a look around http://www.mysql.com and the list archives for several clients that do what you describe. On Tue, 24 Jun 2003, Deosaran Bisnath wrote: > Hi, > New, brand new to MySQL: > are there software or apps to browse the TABLES? > and if possible, add/edit/delete rows?? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Licence Free Import/Export for Access?
I believe the same is true of urSQL. However, you do need to set up an ODBC data source and this requires the MS Access driver. The easiest way to get the driver is to install MS Access, but I think it is possible to install the driver without MS Access... On Thu, 13 Feb 2003, Arthur Fuller wrote: > I have used dbScripter a lot for this kind of work. It is definitely NOT > necessary to own Access to use it. > One of its nice features is its database profiles. These function as data > and syntax translation tables. For example, if a column type doesn't exist > in the target, substitute another column type. > It only took a small amount of experimentation to create a MySQL profile, > and using that I have frequently moved databases from SQL 2000, Oracle and > Access to MySQL. dbScripter will work fine with virtually any ODBC-compliant > back end. > Hth, > Arthur - 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: Licence Free Import/Export for Access?
I've used urSQL (http://www.urbanresearch.com/ursql) to accomplish this for quite some time. You can click on an MS Access table and select "Build Script as MySQL" to get a MySQL-like CREATE TABLE script... On Wed, 12 Feb 2003, Christensen, Dave wrote: > There's a relatively low-cost ODBC utility called DBScripter that does a > pretty good job creating scripts for exporting ddl and data from ODBC > datasources. It allows you to build dialects for server-based SQL > variations. I don't think that there's a current MySQL dialect, but looks > pretty simple to put one together. > - 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: Is there anything like Query Analyser for MySQl
Have a look at urSQL -- http://www.urbanresearch.com/ursql > --- Scott Lewis <[EMAIL PROTECTED]> wrote: > I was wondering, is there a program simialar to MS > SQL server - Query > Analyser, where you can write sql queries to query > MySQl databases? - 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: PD: The win admin for Mysql
Have a look at urSQL - http://www.urbanresearch.com/ursql On Wed, 11 Sep 2002, [iso-8859-2] Jêdrzej Kolesiñski wrote: > > > Hi > > I'm looking for some software (under windows) that will connect to a sql - > mysql base > and make some drop of structure and data of a database > > Do you know any small free program like this ? > > TeQ - 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 Poll
I suppose it depends on your needs and/or exactly what you want to accomplish, but I use urSQL (www.urbanresearch.com/ursql) to access data on MySQL, MSSQL, MS Access, and Paradox databases. I use urSQL frequently to do ad hoc queries and basic SQL tasks... I wouldn't really call it an "Admin" tool, but more of an general SQL tool or utility, and I do find it useful. > -Original Message- > From: Marvin Cummings > To: [EMAIL PROTECTED] > Sent: 7/14/02 10:17 PM > Subject: MySQL Poll > > If it's ok with the site admin, I'd like to post a poll to see what > utilities are being used to administer mysql on w2k. I was dreading > having to actually use a command prompt to manage and administer mysql > until I found this mysql-front tool, which seems to handle all of those > responsibilities. > So I guess my question is what tools are being used? Again this is on a > w2k server running apache & php4. > - 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 Windows Client Install
I use urSQL from http://www.urbanresearch.com/ursql. On Wed, 12 Jun 2002 [EMAIL PROTECTED] wrote: > There are several graphical Windows clients available for mysql. The one I'm > using at the moment is from http://www.anse.de/mysqlfront/ and it's very > good. There's a newer one out though (sorry, don't have the URL) that is > more like MS SQL Query Analyzer. I have it installed on my desktop machine > and it's fast becoming my favorite. (It was announced within the last month > on the announce list...check the archives.) - 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: Frontend and report tool
You might want to have a look at urSQL -- http://www.urbanresearch.com/ursql -- it has built in support for exporting query results in a variety of formats... On Tue, 4 Jun 2002, Petre Agenbag wrote: > Hi Can anyone tell me if they know about a good frontend for mysql with > reporting facilities, or alternatively only a report generator? - 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: Command line interface
Have a look at urSQL from http://www.urbanresearch.com/ursql On Mon, 3 Jun 2002, Ehmer David wrote: > Hi > > Very new to MySQL and just wondering if there is an alternative > interface to the command line. The beginners tutorial I am working > through from WWW.Mysql.com seems to do all tasks from the command line. > This seems very cumbersome in modern times. I understand there is a > graphical interface in development. If so is it an improvement to the > command line. - 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: Good color coded SQL editor for MySQL?
Try urSQL (http://www.urbanresearch.com/ursql) -- it's got a very customizable editor... On Tue, 30 Apr 2002, Jerry wrote: > Does anyone know of a good color coded SQL editor for MySQL that > works in Windows? > > TIA, > Jerry k - 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 for mySQL
Have a look at urSQL (http://www.urbanresearch.com/ursql) -- it allows you to run ad hoc queries and export the results to several different formats (ie HTML, MS Word, Excel, Text, etc). On Sat, 20 Apr 2002, Pierre du Parte wrote: > > However, the head bean counter in one office tackled me on this - "In > Access I can quickly create queries and export the results in all manner > of ways. What do I do if we let you talk us into mySql?" > > Where indeed? Are there any nice, user friendly GUI available for mySQL > ad-hoc query and report design? - 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: Graphical UI for MySQL
If you know SQL, you might want to have a look at urSQL (http://www.urbanresearch.com/ursql). It's not a "management tool" per se, but more of a query tool... On Tue, 16 Apr 2002, BD wrote: > At 01:48 AM 4/16/2002, you wrote: > >Greetings, > > > >I would like to ask you following question: > >Is there graphical user interface for managering MySQL database? I think > >command line-based interface is quite clumsy... > > > >Regards, > > Vesa Kela, Helsinki Finland > > Kela, > Try MySQLFront from http://anse.de/mysqlfront/. It is free and > well designed. > You can also try MySQLMgr which is quite good too. Unlike > MySQLFront, it allows multiple tables to be open at one time. They have a > 30 day eval from http://www.ems-hitech.com/mymanager/. It is $99 and runs > on Windows. > > Brent > > > _ > Do You Yahoo!? > Get your free @yahoo.com address at http://mail.yahoo.com > > > - > 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: SQL Script stopping
Also, the CREATE TABLE statement doesn't look right. It should probably be: create table 185_s_Prices ( PriceID INT NOT NULL DEFAULT 0, Service CHAR (80), Category CHAR (20) ); See the MySQL Manual section on "CREATE TABLE". On Mon, 8 Apr 2002, Jim Swanson wrote: > I have a script I'm trying to run through the mysql command. When I run > the script, I get a 1064 error, specifically > > CREATE TABLE 185_s_Prices\g > > PriceID INT NOT NULL DEFAULT 0, > Service CHAR (80); > Category CHAR (20),<--- here > > Can anyone tell me what's wrong with this line? I dumped the tables, > changed Category to ctg, still the same error. I'm running a fresh > install of Mandrake 8.2. Thanks in advance. > > Jim Swanson > > > - > 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: SQL Script stopping
The semi-colon (;) after "Service CHAR(80)" should be a comma (,). On Mon, 8 Apr 2002, Jim Swanson wrote: > I have a script I'm trying to run through the mysql command. When I run > the script, I get a 1064 error, specifically > > CREATE TABLE 185_s_Prices\g > > PriceID INT NOT NULL DEFAULT 0, > Service CHAR (80); > Category CHAR (20),<--- here > > Can anyone tell me what's wrong with this line? I dumped the tables, > changed Category to ctg, still the same error. I'm running a fresh > install of Mandrake 8.2. Thanks in advance. > > Jim Swanson > > > - > 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: Help me to create a table with autoincrementing field
On Thu, 31 Jan 2002, Charitha wrote: > > I want to know how to create a table with an autoincrement field in that > along with a name field with the varchar datatype. > create table MySimpleTable ( id integer not null primary key auto_increment, name varchar(32) not null ); See: http://www.mysql.com/doc/C/R/CREATE_TABLE.html http://www.mysql.com/doc/e/x/example-AUTO_INCREMENT.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
Re: OT: procmail recipe for this list?
On Wed, 30 Jan 2002, Dan Nelson wrote: > In the last episode (Jan 30), Jeremy Zawodny said: > > On Wed, Jan 30, 2002 at 08:11:53PM -0600, j.urban wrote: > > > I've had good results with the following as well: > > > > > > :0 > > > * ^List-ID: > > > mysql-list > > > > That will miss replies which are sent to the list an CC'd to you. > > The list copy will match, but the CC'd copy will not. > > ..Aah, but that's the idea. Then threads you have participated in go > into your inbox, and the rest go into your mysql folder for perusal > later. > Yes, and that's my intention, and I prefer to have the items I'm specifically "copied on" dropped directly into my inbox, but after I re-read the original post, Jeremy's recipe is a little better as the original request was to get the CC's as well... - 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: OT: procmail recipe for this list?
On Wed, 30 Jan 2002, Jeremy Zawodny wrote: > > > do you have a procmail recipe which will catch ALL the messages to > > > this list and put them in one folder? Even CCs, reply's, whatever? > > > > > > I follow several lists, and this is one of the only two that I > > > can't come up with a working recipe for. > > > I use: > > # MySQL > > :0 > * ^[EMAIL PROTECTED] > mysql > > Jeremy I've had good results with the following as well: :0 * ^List-ID: mysql-list - 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: Access -> Mysql conversion
Another option might be ursql (http://www.urbanresearch.com/ursql). This tool has the ability to generate MySQL-compatible CREATE TABLE scripts from a connected MS Access database. Once the basic CREATE TABLE scripts are generated, you can easily tweak the data types to your liking. In my experience, there's almost always some manual tweaking... On Mon, 21 Jan 2002, Mike Grabski wrote: > I too am researching how to do this. I've found plenty of products that will > do this, of course, I'd rather do it myself. > > here's some links i've found: > > http://www.convert-in.com/acc2sqlp.htm > http://ultradev.buzzinet.co.uk/mysql/tutorials/converting_data/index.asp > http://www.winmysql.com/ > > i hope that helps at all. If you find anything useful, would you be able to > pass the word along? > > Thanks. > Mike - 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: Porting from MS SQL to MySQL
> original platform. I can see where this kind of design is useful... if you > KNOW you are going to port to MySQL in the future. But in that case, why not > design there in the first place? I have no idea and I didn't suggest this was a good solution, but the question was posed, so I simply stated that it's possible to develop your MSSQL system with a MySQL port in mind. I agree completely, if you're going to port it anyway, it should simply be developed for MySQL from the beginning. But who knows? As others have stated, there may be a good reason to do this that we don't know about... On Fri, 18 Jan 2002, Chris Lott wrote: > > You > > can easily develop a system that uses the proper datatypes > > and does NOT > > use MSSQL-specific extensions. This type of system can > > easily be ported. > > Yes, and such an application is likely not to be nearly as efficient on the > original platform. I can see where this kind of design is useful... if you > KNOW you are going to port to MySQL in the future. But in that case, why not > design there in the first place? > > Otherwise, if I am using SQL Server, I am going to take advantage of true > foreign keys, stored procedures, and other SQL Server attributes that make > for a more easily supported and performance-enhanced system. This is not > going to lead to a system that is easy to port :) > > c > -- - 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: Porting from MS SQL to MySQL
> Are you seriously saying you could sit down in front a reasonably sized DB > you had never seen before and understand all the business issues and pick it > up and ship to a new RDBMS and platform, rewrite the document, replan what I Absolutely not. I am saying that if I am tasked with developing a NEW database of any size (10 tables or 100 tables or more) and you tell me UP FRONT, "we'd like to be able to port this MSSQL database to MySQL" the system can be designed to make the "port" very painless. > I am not saying it's a huge task to do any of this but whoever said, "I > could do it in a couple of hours", doesn't understand the background that > led to a company quoting E18k; nor do any of us, and for anything other than > a very very trivial system, two hours seems inadequate. You're correct, I don't understand the background that led to a company quoting 18,000 euro -- that's what we're trying to figure out. On Fri, 18 Jan 2002, Tony Buckley wrote: > > > > I still don't agree with this. Yes you can ease the passage by considering > all the issues up front but it is still not a trivial job for a database of > any consequence. There is more to a database than a physical schema - what > about all the administration procedures that sit around it, what about > tuning the new physical implementation, what about reviewing the access > paths and optimisation, what about the redevelopment of data loading > scripts. As I have said in another post, it's futile arguing about it > because we don't know enough about the technical situation let the > business/political one. > > Are you seriously saying you could sit down in front a reasonably sized DB > you had never seen before and understand all the business issues and pick it > up and ship to a new RDBMS and platform, rewrite the document, replan what I > have stated above, and get it back up and running in two hours? Perhaps I > am getting too old and slow but it would take me longer :-) > > I am not saying it's a huge task to do any of this but whoever said, "I > could do it in a couple of hours", doesn't understand the background that > led to a company quoting E18k; nor do any of us, and for anything other than > a very very trivial system, two hours seems inadequate. > > This is an area that interests me, because I directly bid for work such as > this, and when tendering you usually find the bloke down the road working > out of his spare bedroom that thinks he can do it for a tenner over one day. > The company requesting the work then thinks that everyone else is > overinflating their prices so goes cheap and pays for it big time > downstream. Cheapest and quickest is rarely best. On the flip side, nor is > most expensive. Tricky world init. > > Tony > > - 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: Porting from MS SQL to MySQL
I wasn't talking about migration of a 30gb DB2 system. I was talking about porting a system that was specifically designed to be ported. If you design it correctly up front, you can port it very painlessly. You can easily develop a system that uses the proper datatypes and does NOT use MSSQL-specific extensions. This type of system can easily be ported. Porting a legacy application that someone else developed is likely to be a duanting task, I agree. But I'm talking about a system that has not been developed and can be designed with porting in mind. I just finished a system that was developed 100% for MySQL. It was ported to work with MSSQL and now works with either. There was exactly ONE column change and the actual porting of the database and the back-end code was 2 hours max. This is because there is almost nothing to do provided you've designed the system with porting in mind... You've seen some OLAP developers take 3 months to complete a migration, and I've seen (at least one) company take over 6 months to convert a Paradox system to MSSQL. Neither example is relevant to the current discussion. An MSSQL system can be designed and developed with porting in mind and porting can be painless. On Fri, 18 Jan 2002, Todd Williamsen wrote: > I would say it would take a month at least to complete the job > correctly. I have seen some top OLAP developers take 3 months to > complete a 30gb DB2 to an Essbase migration including all documentation > and politics involved. Two hours? You should be fired for just > thinking that! Just kidding. The whole project scope of a migration is > HUGE! > > Here would be a vague outline of this type of project: > > 1. Politics > 2. What can mySQL do that MS SQL cannot do? > 3. Technical issues > 4. Documentation > 5. Schemas > 6. admin functions > 7. training > 8. post installation testing > 9. pre install testing, Beta > 10. load testing > 11. get the picture? > > This is NOT a two hour job! > > -Original Message- > From: Tony Buckley [mailto:[EMAIL PROTECTED]] > Sent: Friday, January 18, 2002 10:56 AM > To: j.urban > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: Porting from MS SQL to MySQL > > > - Original Message - > From: "j.urban" <[EMAIL PROTECTED]> > To: "Tony Buckley" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Friday, January 18, 2002 4:07 PM > Subject: Re: Porting from MS SQL to MySQL > > > > > Porting a DB takes more 'than a couple of hours'. What about the > written > > > procedures, the security mappings, the back up and recovery procs, > the > > > fallback arrangements, the testing etc. > > > > Yes, porting a database that was written for MSSQL with no intention > of > > porting can be a painful proposition. However, if you have control > over > > how the system is developed, you can easily design the system to be > > compatible with EITHER MSSQL or MySQL (the differeces are > > well-documented). If you develop your system with porting in mind (ie > the > > original post of "they'll develop in SQLServer and port it to MySQL > > later") porting should not take more than a couple of hours. You > simply > > choose appropriate datatypes and don't use MSSQL-specific > extensions... > > > > > I still don't agree with this. Yes you can ease the passage by > considering > all the issues up front but it is still not a trivial job for a database > of > any consequence. There is more to a database than a physical schema - > what > about all the administration procedures that sit around it, what about > tuning the new physical implementation, what about reviewing the access > paths and optimisation, what about the redevelopment of data loading > scripts. As I have said in another post, it's futile arguing about it > because we don't know enough about the technical situation let the > business/political one. > > Are you seriously saying you could sit down in front a reasonably sized > DB > you had never seen before and understand all the business issues and > pick it > up and ship to a new RDBMS and platform, rewrite the document, replan > what I > have stated above, and get it back up and running in two hours? Perhaps > I > am getting too old and slow but it would take me longer :-) > > I am not saying it's a huge task to do any of this but whoever said, "I > could do it in a couple of hours", doesn't understand the background > that > led to a company quoting E18k; nor do any of us, and for anything other > than > a very very trivial system
Re: Porting from MS SQL to MySQL
> Unless they are saying they doubt that mySQL is upto, it so it's no good > quoting. They may have a room full of SQLServer people twiddling their > thumbs in which case I agree with you, they are not bucking for the customer > here. On the other hand they have very real doubts that mySQL is upto the > job; they may be wrong on this last point, but at least they are being > honest in their beliefs. Who knows! This doesn't make much sense. If they're being honest and they believe MySQL can't handle it, why would they offer to port it to MySQL for 18,000 euro? On Fri, 18 Jan 2002, Tony Buckley wrote: > > - Original Message - > From: <[EMAIL PROTECTED]> > To: "Tony Buckley" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Friday, January 18, 2002 3:34 PM > Subject: Re: Porting from MS SQL to MySQL > > >...[cut]... - 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: Porting from MS SQL to MySQL
> Porting a DB takes more 'than a couple of hours'. What about the written > procedures, the security mappings, the back up and recovery procs, the > fallback arrangements, the testing etc. Yes, porting a database that was written for MSSQL with no intention of porting can be a painful proposition. However, if you have control over how the system is developed, you can easily design the system to be compatible with EITHER MSSQL or MySQL (the differeces are well-documented). If you develop your system with porting in mind (ie the original post of "they'll develop in SQLServer and port it to MySQL later") porting should not take more than a couple of hours. You simply choose appropriate datatypes and don't use MSSQL-specific extensions... On Fri, 18 Jan 2002, Tony Buckley wrote: > - Original Message - > From: <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Friday, January 18, 2002 2:14 PM > Subject: Re: Porting from MS SQL to MySQL > > What about the customer who asks a car company to make the vehicle's tryes > out of velvet? Would you go off in a huff if they refused and demand they > do it? There are obviously issues here that we are not privy to; there > *must* be logic behind the choice of SQLServer. Are they saying that mySQL > isn't upto it? > > Porting a DB takes more 'than a couple of hours'. What about the written > procedures, the security mappings, the back up and recovery procs, the > fallback arrangements, the testing etc. > > If you think E18k is a lot then ask for a detailed task plan with effort; > find out what they are asking you to pay for. > > The DB was described as 'fairly complicated' whatever that may mean. > Perhaps - and we are all guesing - there are remote data issues, views, > stored procs, java and god knows what else that all needs to be integrated. > > Bottom line when you get a quote is find out what they want to do task by > task and then cut it down from there. > > Tony > > > > - > 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: Porting from MS SQL to MySQL
If you know you're going to port it, it really shouldn't be too difficult. In fact, if you're creating it with the intention of porting it, you can (and should) use MSSQL datatypes that are compatible with MySQL. If you do this, porting is a trivial task at best. 18,000 euro seems a bit steep for a couple hours of work... By-the-way: there doesn't seem to be any obvious reason to create the database in MSSQL (other than a 18,000 euro conversion project later). You might consider developing the database using MySQL or PostgreSQL initially and eliminate the conversion issue... On Fri, 18 Jan 2002, Markus Lervik wrote: > One company offered MS SQL as the platform and said that they can later on > port it to MySQL. For this they wanted 18 000 euro. Now, what I want to know > is, how easy is it to port a (fairly complicated) database from MS SQL to > MySQL? It can't be work worth 18 000 euro, now can it? - 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: Using MYSQL and PHP With Vitual Apache Servers ?
Why not just create separate databases for each virtual server? It sounds
like a perfect situation to create multiple databases, as databases do
provide data separation...
mysql> create database Virtual1;
mysql> create database Virtual2;
mysql> create database Virtual3;
mysql> create database Virtual4;
mysql> show databases;
+--+
| Database |
+--+
| Virtual1 |
| Virtual2 |
| Virtual3 |
| Virtual4 |
+--+
And then in the PHP code for each website, you connect to the appropriate
database.
Say for website Virtual2:
$dbh = mysql_connect("localhost","user","pass");
mysql_select_db('Virtual2');
... Access schema for website Virtual2 ...
http://www.mysql.com/doc/C/R/CREATE_DATABASE.html
http://www.php.net/manual/en/function.mysql-select-db.php
Good luck.
On Sun, 6 Jan 2002, Matthew Darcy wrote:
> I have a redhat server, running apache 1.3.20. The server is running a
> couple of virtual servers for different websites. I now wish to add a few
> new virtual servers/domains to the machine. However (here is the twist)
> these sites will need to use a different mysql schema each and have some of
> the content generated with php based on the data from the different mysql
> databases.
>
> Is this possible ??? if so what is needed to configure this setup (just
> brief), and I would be very interested in hearing from someone who is
> running virtual servers with each site using a different mysql database.
>
> Thanks,
>
> Matt.
>
-
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 on Win2000
You might want to have a look at a client like urSQL (http://www.urbanresearch.com/ursql)... > At 14:51 13/12/2001 -0500, Alex Shi wrote: > > >Hello, > > > >I installed MySQL 3.23.46 on Windows2000. The mysql-nt started > >on Windows startup, and MysqlAdmin is also running well. I tried to > >create a database with it and it works! Everything looks perfect > >except I want to do something more than this admin tool can. > >What I need is to create/drop table, add/drop user for a certain > >database, and place query statement, etc.. However in MysqlAdmin > >I didn't see those I expectedDo I need to login to mysql from dos > >terminal for the admin job? Can I use phpmadmin for Win2k/apache/ > >php/mysql platform? > > > >I'm totally new for mysql on Windows, please help me out if anyone > >is familiar with this issue. Thanks in advance! - 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: ERD
Check out urSQL from http://www.urbanresearch.com/ursql On Fri, 30 Nov 2001, Won Lee wrote: > Anyone know a good ERD program that will also interact with MySQL to write > the CREATE scripts? As usual open source would be nice, also running on a > win2k workstation. > > I used to use PowerDesigner. Nice software but too expensive. > > Won > > = > Not being a materialist in the U.S. is kind of like not appreciating opera > if you live in Milan or art if you live in Paris. We support materialism > better than any other culture. Because retailing and distribution are so > efficient here, stuff is cheaper than anywhere else in the world. And then > we have huge houses in which to archive our stuff. > > > - > 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: Request for information (MS Access & MySQL)
You can also use a tool like urSQL (http://www.urbanresearch.com/ursql) to convert the table schemas. urSQL has the ability to save MySQL tables as MS Access CREATE TABLE scripts and the ability to build a script of insert statements that can be run against the new table. (You can also save MS Access tables as MySQL CREATE TABLE scripts.) On Thu, 25 Oct 2001, Daniel Andrade wrote: > Rob, > > You may start by checking the utility at download.com that claims to be > able to convert Access to MySQL databases. I am currently trying to get > a company off of Access 2000 and onto MySQL in America, but I have not > tried this tool yet and any reviews from someone that knows Access well > are welcome. > > Daniel > - 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: CHAR() becomes VARCHAR() in CREATE
MySQL automagically changes all char columns to varchar if there is one or
more variable-length columns' present. The TEXT column in your first
example is causing ALL char() columns to be converted to varchar(). In
your second example, since there are NO variable-length columns, the
char() columns are not changed by MySQL...
Have a look at the manual:
http://www.mysql.com/doc/S/i/Silent_column_changes.html
On Thu, 18 Oct 2001, jason wrote:
> I am using MySQL Admin to create a new database called CustomerInvoice. I
> enter 10 fields and some of them I set to CHAR(5) or CHAR(9). See Field
> InstallerID and Claim below. MySQL Admin creates the following command and
> sends it to MySQL using root login.
>
> CREATE TABLE `CustomerInvoice` (`InvoiceID` TINYINT(6) NOT NULL, `CustID`
> TINYINT(6) NOT NULL, `InstallerID` CHAR(5) NOT NULL, `ServiceType` ENUM('New
> Install','Install AO','Service Call','Dish Move','Upgrade/Other') NOT NULL,
> `Date` DATE NOT NULL, `Time` ENUM('AM','Noon','PM','Evening','First
> Available') NOT NULL, `PromoCode`
> ENUM('NONE','RNINE','RDHP','RPVR','RDISH','RMOVE','R500') NOT NULL, `Claim`
> CHAR(7) NOT NULL, `Status`
> ENUM('Pending','Complete','LOS','Equip','Cust','Home','Pmt-NA','Pmt-NI','Oth
> er') NOT NULL, `Notes` TEXT NOT NULL )
>
> As you can see the command does call for CHAR and not CARCHAR for
> InstallerID and Claim. But after the command runs MySQL Admin automatically
> selects and displays the properties of the newly created table and the
> following is shown:
>
> Field Type Null Default
> InvoiceID tinyint(6) No 0
> CustID tinyint(6) No 0
> InstallerID varchar(5) No
> ServiceType enum('New Install', 'Install AO', 'Service Call', 'Dish Move',
> 'Upgrade/Other') No New Install
> Date date No -00-00
> Time enum('AM', 'Noon', 'PM', 'Evening', 'First Available') No AM
> PromoCode enum('NONE', 'RNINE', 'RDHP', 'RPVR', 'RDISH', 'RMOVE', 'R500')
> No NONE
> Claim varchar(7) No
> Status enum('Pending', 'Complete', 'LOS', 'Equip', 'Cust', 'Home',
> 'Pmt-NA', 'Pmt-NI', 'Other') No Pending
> Notes text No
>
> Why is it CHAR is converted to VARCHAR in this and other cases like it?
> Sometimes I am able to make CHAR fields and other times I can't make a
> single one at all. It seems to affect certain tables but not others. It
> must have something to do with the other fields or types I am creating alone
> with it.
>
> I can create a table with the following command and it works as expected
> creating a two field table using CHAR() type:
>
> CREATE TABLE `CustomerInvoiceNew` (`InstallerID` CHAR(5) NOT NULL, `Claim`
> CHAR(7) NOT NULL )
> Field Type Null Default
> InstallerID char(5) No
> Claim char(7) No
-
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: [PHP-DB] Re: Yes or No
An enum should work fine as you've described, but remember that the ENUM type is a MySQL proprietary type and if you ever want to convert to another database (Oracle, PostgreSQL, MSSQL, Etc.), you may have to find an appropiate solution (i.e. convert to integer and use 0 and 1)... On Tue, 2 Oct 2001, Jordan Elver wrote: > I've decided on enum. Should work fine. I've used it before and it works fine > with 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: graphic interface
You might want to have a look at urSQL -- http://www.urbanresearch.com/ursql or one of the clients listed in the My SQL manual: http://www.mysql.com/doc/S/E/SEC619.html. On Sat, 22 Sep 2001, Pedro Munoz wrote: > Hi all, > > Is there any graphic tool for controling a Mysql database?. This tool is for > a end user that doesn't know anything about sql. > > Thank you. > > > - > 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: SQL GUI-Based Table Creation Tools?
Have a look at urSQL -- http://www.urbanresearch.com/ursql On Fri, 21 Sep 2001, Calvin Chin wrote: > Can anyone out there provide GUI-Based table creation tools for mySQL? > (something like Access) > > Thank you. > > Regards, > Calvin Chin > [EMAIL PROTECTED] > Ipmuda Berhad - Building materials for tomorrow's world ! - 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: Semi colons in text fields in update statement
> "Update tblCompany SET CoName='"tester"' WHERE CoID=109" It's not the query string. I just submitted this query using urSQL (uses ODBC) and it worked just fine (assuming CoName is a varchar(32)). I'm also able to successfully run this query and similar queries via ADO from a Delphi application without a problem. This doesn't eliminate ADO, but it does raise doubts that ADO is the problem... You might want to submit your CREATE TABLE statement and (as Paul suggested) the exact error message you are experiencing. On Thu, 20 Sep 2001, johnlucas-Arluna wrote: > Hello > > I'm trying to do the following: > > "Update tblCompany SET CoName='"tester"' WHERE CoID=109" > > But getting an error message > > I tried the escape character "\" like > > "Update tblCompany SET CoName='"\;tester"\;' WHERE CoID=109" > > but get the same error > > This happens whether I use ADODB in VB or if I try executing the query > through DBTools 1.0.9 > > Can anybody tell me how I can escape the semi-colon please? > > Many thanks for any help > > John > - 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 and Delphi dude
The Zeos components are fine, but there's no need to change the underlying libraries to get functionality that exists within the current component. Borland's TDatabase object (native VCL) also supports both options -- LoginPrompt or no LoginPrompt. On Tue, 11 Sep 2001, Mike wrote: > Use Zeos componets. You can use either login or no login. > > M;) > > > > -Original Message- > From: Miguel Enriquez Alvarado [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, September 11, 2001 3:29 PM > To: [EMAIL PROTECTED] > Subject: Mysql and Delphi dude > > > hi all > i use delphi 3 and mysql, i can connect to mysql since a component Tquery (i > see the data), but my question is: > > how remove the box where ask me the username and password, when run my app, > anybody recommned me the component Tdatabase but i not know how use, anyone > can help me? - 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 and Delphi dude
The TDatabase component should have a property named "LoginPrompt". You need to set that property to FALSE. 1) Drop a TDatabase on your form or datamodule 2) Set the TDatabase.DatabaseName property 3) Set the TDatabase.AliasName property 4) Set the TDatabase.LoginPrompt property to False 5) Drop a TQuery on your form or datamodule 6) Set the TQuery.DatabaseName to the name you used in #2 These are some simple steps you can follow to connect a TQuery to a TDatabase. Setting the LoginPrompt to false will prevent the displaying of the Username/Password dialog. However, you'll need to set the username and password somewhere (the DSN or my.cnf or the TDatabase.Params. On Tue, 11 Sep 2001, Miguel Enriquez Alvarado wrote: > hi all > i use delphi 3 and mysql, i can connect to mysql since a component > Tquery (i see the data), but my question is: > > how remove the box where ask me the username and password, when run my > app, anybody recommned me the component Tdatabase but i not know how > use, anyone can help me? > > > thanks > - 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 & Delphi
Is it actually truncating data or is the width simply short? If it's the latter, you might want to have a look at the MyODBC settings for the connection. There is an option called something like, "Don't optimize column widths". If this is checked, MyODBC should return the entire column width. On Sun, 2 Sep 2001, Ales Vaupotic wrote: > Hello, > > I've got a problem with MySQL 3.23.41 on Solaris 8 and Delphi 5 Ent. on > Windows 98. I installed the latest MyODBC a week ago and am using ADO > components to connect to the server. The connection itself works but when I > open the field editor of a table, char(50) is interpreted in Delphi as > string with length of 12 or 16 characters. It happens for all char fields, > lengths are from 1 to 20 chars (randomly). > > Should I try another set of components or can this be fixed? > > TIA, > Ales Vaupotic > Amanita Software > - 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: NewLine between statements
It really depends on the client. MySQL does not inherently know how to process multiple statements. If you're sending SQL from a program you developed, you'll probably have to separate the statements and submit them individually. The clients that allow multiple statements (ie urSQL and the mysql command-line) are somehow handling this on the client-side as MySQL expects only one SQL statement at a time... On Fri, 31 Aug 2001, Peter Harvey wrote: > > Anyone know what the deal is with sending multiple statements to the > server and getting errors at ";\n" on the first statement? Even the > result will come back with something other than '\n' in error messages. > > I am using MyODBC but I am not certian that it is a MyODBC behaviour. > - 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: Window-based client program for MySQL (server in Linux)
There is indeed a PHP client called PHPMyAdmin (http://www.phpwizard.net/projects/phpMyAdmin/) and there are several Windows-based clients including urSQL (http://www.urbanresearch.com/ursql). On Fri, 31 Aug 2001, Biniam Gebremichael wrote: > > I have MySQL server installed in my linux box. And want a windows based > client program that can be used to create and modify table designs and > other functions. > > Is there any PHP client for such purpose or any library to enable > Microsoft Access to interface the server. > > Thanks > Biniam - 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: reports? from MySQL
If you're accessing via Windows, you can use MyODBC and a reporting package such as Crystal Reports or Quick Reports or just about any ODBC-compliant reporting package. You should also be able to link MS Access to your MySQL database... For simple reports where you just want to print some data, you can use a tool like urSQL (http://www.urbanresearch.com/ursql) and MyODBC to build your query and then export the results. Results can be exported to HTML, Text, Excel, etc... > - Original Message - > > i'd like to ask... > > if any of you are familar with (File Maker Pro, most recent > > versions)... how does one go about using MySQL to create a printable > > report? e.g., where you select the fields you wanted in the report > > and then create a layout and page setup for the report, (then print > > it)? - 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 Interface Programs
Check out urSQL from http://www.urbanresearch.com/ursql On Thu, 23 Aug 2001, Neil Tompkins wrote: > Hello, > > Currently to connect to mySQL server I use MS Access and ODBC. I have > noticed that the update when scrolling through records is not very good. > Can anyone recommend and suggestion so FREE programs to view and edit data. > > Thanks > > Neil > > _ > Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp > > > - > 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: WANTED: Utility to reverse engineer existing database II
Did you see the -w, --where option? It might be what you're looking for... "Dump only selected records." --http://www.mysql.com/doc/m/y/mysqldump.html If you have a more complicated query and you are using Windows, you can use urSQL + MyODBC to accomplish this as urSQL (http://www.urbanresearch.com/ursql) allows you to export the results of any query (to a variety of formats). On Tue, 7 Aug 2001, Kevin wrote: > > Thanks for pointing out mysqldump. > > I now need to be able to copy a limited number of data records. I see that > mysqldump allows data copy by providing the cooresponding INSERT statements. > However, I don't always want all of the records. Some of my tables have > thousands of records and I may only want the first 200 or so. I did not see > an option on mysqldump that would limit the number of records. Any ideas > without writing a program? > > Kevin > - 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: importing data
http://www.mysql.com/doc/L/O/LOAD_DATA.html http://www.mysql.com/doc/m/y/mysqlimport.html http://www.mysql.com/doc/L/o/Loading_tables.html On Tue, 7 Aug 2001, Kevin Fonner wrote: > Is there an easy way or perhaps a utility to import a tab delimeted text > file of data into a mysql table > > Thanks, > > -- > Kevin Fonner > > > > - > 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: how to delete a database table?
To remove rows from a table: mysql> delete from your_table_name; See: http://www.mysql.com/doc/D/E/DELETE.html To completely remove the table from the database: mysql> drop table your_table_name; See: http://www.mysql.com/doc/D/R/DROP_TABLE.html On Tue, 7 Aug 2001, louie miranda wrote: > > how can i delete a database table? > - 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: WANTED: Utility to reverse engineer existing database
Yup. You can use mysqldump (comes with the MySQL distribution). See the MySQL manual for details: http://www.mysql.com/doc/m/y/mysqldump.html You can also use a graphical tool such as urSQL (MS Windows + MyODBC) to accomplish the scripting if you wish (http://www.urbanresearch.com/ursql). On Mon, 6 Aug 2001, Kevin wrote: > I need a utility that will probe my existing mysql database, analyze the 90+ > tables and spit out the data definition language (create table, create > index, etc.) needed to recreate the database. Does such a utility exist? - 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
Yes, have a look at urSQL (http://www.urbanresearch.com/ursql). You may also want to have a look at MyODBC and the various clients available from mysql.com, including mysqlgui. On Mon, 6 Aug 2001, Naintara Jain wrote: > is there any editor available (eg vi on UNIX) that runs on MS-DOS to make > writing queries easier in MYSQL. I am a newbie. - 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: Cannot change column type from varchar(32) to char(32)
It might depend on the other columns in your table definition. Have you looked at the Silent Column Specification Changes? http://www.mysql.com/doc/S/i/Silent_column_changes.html If you have ANY varchar() columns, all char columns greater than three characters are changed to varchar(). Perhaps the 'little play table' doesn't have any other varchars... On Wed, 1 Aug 2001, Lezz Giles wrote: > I'm running 3.21.33b (yes, I know it's old), and I run the command: > > alter table branch change codebase codebase char(32) not null default > "IPriori"; > > where column codebase has type varchar(32) - but the type does not change to > char(32). > There's no error message or other indication of what went wrong, and if I create > > a little play table I can succesfully change the column type to char(32) from > varchar(32). > The table "branch" has just 180 rows in it. > > I'd like to change the column types from varchar to char to speed up queries & > etc. > Can anybody shed any light on what I'm doing wrong? > > Thanks, > Lezz Giles - 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 Client Software
I use urSQL, available from http://www.urbanresearch.com/ursql, to connect to remote MySQL servers from my Windows box... There is also the mysqlgui client and many more available from the MySQL website (www.mysql.com). On Wed, 1 Aug 2001, Faiz Khan wrote: > Hi there, > > I am having problem finding "MySQL Client software" to connect to Web Hosts > server so i can create tables and run queries at their server remotely. I am > running windows so any related softwares would be great help. > > Please reply soon as i need to proceed on project and really need > aforementioned piece of software... > > Thanks, > Faiz - 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: show create table
Version 3.23.20 On Tue, 31 Jul 2001, Ansgar Becker wrote: > since which version was the "show create table" syntax introduced? - 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/server
Check out urSQL from http://www.urbanresearch.com/ursql. On Tue, 31 Jul 2001 [EMAIL PROTECTED] wrote: > Hello! > > I'm a newbie at mysql and i'm looking for a client program for win23 that > can accsess a mysql database and create and alter tables. > The mysql database is placed on a linux box in my lan, and im not too keen > of sitting in console. The linux box also holds the apache server,with php but > i edit all my code on the win2k box. > > Thanks in advance Lasse - 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: Backup / Import Questions
Because the --opt option builds an output script of SQL commands that can be run to CREATE TABLES and INSERT data. You're on the right track, but using mysqlimport only makes sense based on the options that were used with mysqldump... Based on what you've done, you can re-create the entire database by running the 'file.mysql' as a script (you don't need mysqlimport in this case): mysql -uroot -ppassword TestDatabase < file.mysql On Mon, 30 Jul 2001 [EMAIL PROTECTED] wrote: > mysqldump -uroot -ppassword --opt Database > file.mysql > > Why does mysqldump allow you to dump all the table create data with the > actual data if the import function doesnt allow you to use it? - 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
ADO + show columns
I'm experiencing some unexpected and undesired behavior attempting to run SHOW COLUMNS FROM TABLE using Delphi via ADO. MDAC: 2.6 RTM MyODBC: 2.50.37 O/S:Windows 98 MySQL: 2.23.24 (Linux) I can run most queries just fine (ie SHOW TABLES, selects, etc.). However any SHOW COLUMNS queries return an error or an empty result set. If I attempt to connect the query to a visual control, the error message, "Data provider or other service returned and E_FAIL status". If I just attempt to connect the query and loop through the results, and empty result set is returned. I don't think an empty result set should be possible for a SHOW COLUMNS query. If the table doesn't exist, it will return an error and if the table does exist, there must be at least one column. I've tried several different versions of MDAC/ADO on several different computers, and DESCRIBE, EXPLAIN, and SHOW COLUMNS all exhibit this behavior. Anybody else experience this behavior or have any suggestions? Is this a limitation of accessing MySQL via ADO? query,sql,mysql,homer - 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: Modifing A Table
mysql> alter table mytable add newcolumn varchar(16); Have a look at the ALTER TABLE syntax in the manual... http://www.mysql.com/doc/A/L/ALTER_TABLE.html On Wed, 18 Jul 2001, Paul Castiglione wrote: > Hello > > Is there a way to add addition feilds to a table after it been created. > > Thank in Advance > Paul > - 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: MASON GUI for Windows is it good?
I don't know much about Mascon, but I've been happy with urSQL (http://www.urbanresearch.com/ursql)... I think it largely depends on your needs. On Fri, 13 Jul 2001, Cesar Cuneo /Corpsoft wrote: > I have heard that mason is pretty good , I currently us DB Tools as a > windows GUI for MySQL but would consider changing to Mason it its better. > Can anybody help with this decision? > > Has anyone used Mason GUI before? - 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: word count
How about:
select position(' ' IN name) as fs from contacts having fs>0;
On Mon, 9 Jul 2001, Tommy Beavitt wrote:
> How do I build an SQL query which returns rows based on whether or
> not strings in a column contain more than one word
>
> eg.
>
> SELECT name
> FROM contacts
> WHERE WORD COUNT(name)>1
>
> I am aware that such a query is bogus but it seems as if there must
> be a straightforward way of doing this.
>
> thanks
>
> Tommy Beavitt
>
-
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: front end/client for mysql
You might want to have a look at urSQL (http://www.urbanresearch.com/ursql). There are several options for editing and viewing data. On Fri, 6 Jul 2001, Ed Peddycoart wrote: > I am looking for a Win32 front end/client for mysql. I want to be able to > run it on my local machine, but modify a remote mysql db. I would like it > to be as user friendly as possible, with the user having to know as little > sql as possible. Any suggestions? > > Or maybe a web client that I can run from my website...I believe my webhost > is running Linux. Any suggestions there? I have been using phpMyAdmin > 2.0.1, but it doesn't allow me (or I can figure out how to) edit a record's > data without using a query, which requires a knowledge of sql syntax. I can > edit the structure, but just not the data (again without the use of sql > queries...) Maybe I am wrong about that though > > Ed - 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: Data Entry Forms
You have several options, a few of the more common solutions include: C, C++, Delphi, Perl, PHP, HTML, CGI, etc... Simple data entry forms can often be easily implemented using a web-based solution (which also simplifies deployment)... On Tue, 26 Jun 2001, Stephen Reynolds wrote: > I've created a MySQL database and linked the tables to a MS Access front > end so that I could build the data entry forms using MS Access. Is there a > better way to create the data entry forms in a Windows environment without > using Microsoft or proprietary solutions? > > What is are the most widely used methods for creating data entry forms for > MySQL in a Windows environment? > > Regards, Steve - 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: Database Schema
Try "mysqldump -d database_name"... On Fri, 22 Jun 2001, Juan wrote: > Can I generate my Database Schema from mySQL? How? - 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
For the Windows platform, have a look at urSQL --
http:/www.urbanresearch.com/ursql
You might also want to have a look at the MySQL documentation ("very
friendly" is a subjective and vague requirement):
http://www.mysql.com/doc/n/o/node_17.html
http://www.mysql.com/doc/S/E/SEC592.html
On Thu, 21 Jun 2001, Ricardo Striquer Soares wrote:
> does enyone knows a GUI to use with mysql wich is verry friendly one?
-
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 NT/98 is it available?
Try urSQL from http://www.urbanresearch.com/ursql also see the MySQL website: http://www.mysql.com/downloads/gui-clients.html http://www.mysql.com/downloads/contrib.html#SEC592 On Wed, 13 Jun 2001, John Kennedy wrote: > I am just curious to know whether you have any GUI for mysql for Windows > NT/98? If so kindly send me the link where I could download it. I am curios > to work on MYSQL. > > thanks > John > _ > Get your FREE download of MSN Explorer at http://explorer.msn.com > > > - > 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: PHP + MySQL question
Have a look at the PHP mysql_fetch_array and mysql_fetch_row functions and associated documentation... "; } ?> On Sun, 10 Jun 2001, Vladimir Kravtsov wrote: > Here is my db hierarchy: > Database: xtopsites > Table: Categories > idName > 1Name1 > 2Name2 > 3Name3 > 4Name4 > 5Name5 > 6Name6 > > > I would like the user to get to a sign up form and have all the names > of the categories displayed.is this possible to do using > fetch_array? If it isn't is there another way? (Also could you provide a > valid syntax?) - 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: does show create table work?
I believe SHOW CREATE TABLE was added in 3.23.20... http://www.mysql.com/doc/S/H/SHOW_CREATE_TABLE.html http://www.mysql.com/doc/N/e/News-3.23.20.html On Wed, 6 Jun 2001, Rob Agar wrote: > hi! > > Does SHOW CREATE TABLE x actually work? When I try it I just get error > 1064 (you have an error in your sql syntax near 'CREATE TABLE x') > > (version 3.22.32 on linux) > > ta, > Rob Agar > > > - > 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: Any suggestions on a front end for MySQL database?
Have a look at urSQL from http://www.urbanresearch.com/ursql. On Tue, 29 May 2001, Apolinaras "Apollo" Sinkevicius wrote: > > I currently have Access97 as a front end of MySQL database. Would any of > you be able to suggest me any other "easy" front end for the database. > Employees in my company are very slow to learn, so something like Access > would be good to find. The reason I am asking is, because every damn time I > get new work stations I have to add new licenses that are impossible to > come by (by the way, if you know where I can get a pack of 5 MS Office 97 > Pro licenses for less, let me know). > > Apollo > > > - > 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: Telnet into MySQL
Take a look at the posts from Paul and others... You can't connect directly to MySQL using telnet without knowning the MySQL communication protocol... There are many MySQL client programs -- a good one for Windows is urSQL available from http://www.urbanresearch.com/ursql You might also want to have a look at the MySQL manual at http://www.mysql.com/doc/ Good luck. On Mon, 21 May 2001 [EMAIL PROTECTED] wrote: > > Any good ones for the Windozes version..When I use just regular ol > Telnet I get Smiley and clovers and hearts and the version. > > Cheers > > -Original Message- > FROM: Eric Fitzgerald > TO: Angerer, Chad, 'Tim Thorburn', [EMAIL PROTECTED] > DATE: Mon 5/21/01 15:58 > SUBJECT: Re: Telnet into MySQL > > I really prefer SecureCRT from VanDyke software myself. Perfect blend of > features and simplicity for my needs. It has a shareware version that does > expire, but the license is cheap for it. Go to www.vandyke.com and download > the shareware version to give it a try. > - Original Message - > From: "Angerer, Chad" <[EMAIL PROTECTED]> > To: "'Tim Thorburn'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Monday, May 21, 2001 1:58 PM > Subject: RE: Telnet into MySQL > > > > go to www.ssh.com .. I beleieve there a few nice clients there. > > > > Chad > > > > -Original Message- > > From: Tim Thorburn [mailto:[EMAIL PROTECTED]] > > Sent: Monday, May 21, 2001 3:21 PM > > To: [EMAIL PROTECTED] > > Subject: Telnet into MySQL > > > > > > Hello, > > > > Can someone here recommend a good Telnet program (with SSH) that I can use > > to connect to my servers MySQL database? > > > > Preferably something shareware/freeware - but if it must be purchased, I'm > > not against that. > > > > Thank you > > > > -Tim > > > > > > - > > 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 > > > > > > > > > - > 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 > - 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: escaping semicolon in strings
That SQL statement provided should work just fine without any escape
sequences (at least as far as MySQL is concerned). The semicolons (;)
should be treated as part of a literal string, and therefore, inserted
into the image_data table.
Perhaps you're running this script from some utility or some program that
isn't properly handling the script.
I just ran the following using the urSQL Utility (which uses MyODBC) and
it worked fine:
drop table if exists image_data;
create table image_data(title varchar(64));
insert into image_data (title)
values ("“Blue Clearwing” (Dulcedo polita)");
select * from image_data;
Try running the script directly in MySQL.
On Thu, 10 May 2001, Dave Emerson wrote:
> I'm doing an insert via a SQL script:
>
> insert into image_data (title)
> values ("“Blue Clearwing” (Dulcedo polita)");
>
> The error returned is:
> Error: (-1) You have an error in your SQL syntax near '"$#147' at line 1
> State:42000,Native:1064,Origin:[TCX][MyODBC]
-
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: escaping semicolon in strings
How are you inserting the strings (ie C, Perl, etc)? What is the exact string you're tying to insert? What is the exact error message returned? On Thu, 10 May 2001, Dave Emerson wrote: > I'm trying to store strings the database that contain html > character entities in them. > It appears that the insert fails when it sees the semicolon that > terminates > the entity. I've tried escaping it with \ but that doesn't work. What's > the proper way to escape a semicolon embedded in a string? > > Thanks, > Dave. > > > - > 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: SQL help
You might be able to do something like this instead: SELECT *, id*0+RAND() AS r FROM table ORDER BY r LIMIT 5; Check the list archives, this issue comes up quite often. On Wed, 9 May 2001, Webmaster wrote: > i dont follow step #3. > > > At 11:42 PM 5/8/2001, Tony Shiu wrote: > >i think it is more suitable to do it in programming level in mysql, though I > >know there is a function is M$sql server. > > > >if your table schema has a unique id field, before submit a query to DB, > >1) select count(*) from it > >2) from the above resultset, program to draw whatever number of records you > >want. > >3) submit the query, select * from it where id in (your random record ids); > > > > > >- Original Message - > >From: "Webmaster" <[EMAIL PROTECTED]> > >To: <[EMAIL PROTECTED]> > >Sent: Wednesday, May 09, 2001 11:38 AM > >Subject: SQL help > > > > > >> How do I write SQL in MySQL to randomly select 5 records from a table? > >> - 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: restore 'dumped' database
Check out mysqlimport and LOAD DATA INFILE, as well as the documentation for mysqldump: http://www.mysql.com/doc/m/y/mysqlimport.html http://www.mysql.com/doc/L/O/LOAD_DATA.html http://www.mysql.com/doc/m/y/mysqldump.html On Wed, 2 May 2001, Brian Warn wrote: > Hi, > > How do I restore a copied database that I've created with mysqldump? I have both >the DuBois book and, of course, the online manual handy. I'm obviously looking in >the wrong area of them because I can't find anything (I thought the keyword 'restore' >would net me something, but no joy). I'll happily take my 'RTFM' beatings if someone >would just point me to the appropriate section(s) of one or both... > > -Brian > - 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: Is there mysql client under Windows?
Yes, try urSQL -- http://www.urbanresearch.com/ursql There is also mysqlgui from http://www.mysql.com/downloads/gui-clients.html and several more listed at http://www.mysql.com/downloads/contrib.html#SEC569 On Sun, 29 Apr 2001, [iso-8859-1] Sofiane Sakhri wrote: > Hello, > Is there a windows mysql client to manage a distant > unix mysql server? > Thanx > Sofiane > > ___ > Do You Yahoo!? -- Pour faire vos courses sur le Net, > Yahoo! Shopping : http://fr.shopping.yahoo.com > > - > 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: client side tool of MySQL
Have a look at urSQL -- http://www.urbanresearch.com/ursql On Tue, 24 Apr 2001, Hao Cheng wrote: > 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. > > Any input is greatly appreciated ! > > Hao > - 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
urSQL also supports multiple queries... http://www.urbanresearch.com/ursql On Tue, 24 Apr 2001, Jason Holliston wrote: > Yes, MySQLFront works much better with multiple queries at once. Nice, > quick, simple Win32 UI. I was originally using MySQL GUI that's > downloadable from http://www.mysql.com/. Oh, and for everyone's > information, http://my.anse.de/ does not appear to work, at least for this > morning. http://www.anse.de/ does, however. Thanks for the information. > > -Jason > > -Original Message- > From: Scott Baker [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 24, 2001 8:12 AM > To: Jason Holliston; [EMAIL PROTECTED] > Subject: 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! > > > > -Jason > > > >- > >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 > > > - > Scott Baker - Webster Internet - Network Technician > 503.266.8253 - [EMAIL PROTECTED] > > "If it is not right do not do it; if it is not true do not say it." - > Marcus Aurelius > > > > > > > > > - > 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: free admin/client gui for win32
Check out urSQL at http://www.urbanresearch.com/ursql On Thu, 5 Apr 2001, Kevin Xin Lin wrote: > Can any one share with me a good free admin/client GUI for win32? > > Thanks. - 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: INFO
Yes. There are several Win32 clients such as the urSQL Utility (www.urbanresearch.com/ursql) that can be used to access and/or maintain MySQL databases via Windows. On Wed, 14 Mar 2001, G&B Net wrote: > can I manage mysql server 3.23 on red hat linux 6.1 using a win32 client on > win nt ? > thank you in advance. > regards. > > Andrea GIGLIOTTI > > G&B Net S.n.c. > Via Bagni Caldi, 11 > 55021 Bagni di Lucca (LU) > Tel. 0583-805533 Fax 0583-807912 > http://www.g-bnet.com > > - 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: TXT file to mysql DB
Have a look at mysqlimport and 'LOAD DATA INFILE' in the manual. Your question doesn't provide the format of the text file, so it's hard to pinpoint an exact solution... http://www.mysql.com/doc/L/O/LOAD_DATA.html http://www.mysql.com/doc/m/y/mysqlimport.html On Sun, 4 Mar 2001, Cho Bum Rae wrote: > Do you know how to import TXT file into mysql DB? > Because of big size txt file, I cannot input data into DB manually. > Is there easy way to solve that problem? > > Thanks a lot. > - 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: Deleting Tables
Your script likely includes a CREATE TABLE statement that is tripping on the fact the table already exists. The table can be deleted using the DROP TABLE statement: mysql> drop table home1; You might consider adding the DROP TABLE IF EXISTS to the script as well. Please see the MySQL Manual: http://www.mysql.com/doc/D/R/DROP_TABLE.html On Tue, 27 Feb 2001, Cote, Ronald wrote: > Good Morning, > > Can someone tell me how to delete tables with MYSQL Version 3.23? > I have a database named homework, with 5 tables in it. (Home1, home2, > home3, etc...) I have cleared the databases, and they are empty. But > when I try to run my script to repopulate Home1... I get the > following... > > # mysql -uroot -p homework < home1.sql > Enter password: > ERROR 1050 at line 9: Table 'home1' already exists > [root@acct101 sql]# > > My script is very simple, and it worked last semester. I am hoping if > I delete the table completely... This will solve my problem. - 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: LOOKING FOR A FRONTEND FOR MYSQL
You might have a look at urSQL - www.urbanresearch.com/ursql On Mon, 26 Feb 2001, MANGERA, Faizal wrote: > Hi everyone, > > Is there a front-end available for Mysql. I am currently using Mascon as an > administrative front-end, which is very good. However I need a front-end > with less administrative features, something where-by users can > create/edit/drop tables - therefore it has to be very easy to use. > > I have already an ODBC link to Lotus Approach/MS Access but they only allow > you to create a table - unfortunately they do not allow any editing to be > done to the tables. > > Is there anybody who can point me in the right direction. > > Thanks in advance > --- > Faizal Mangera > Systems Department > CarnaudMetalbox Engineering > Shipley > West Yorkshire > BD17 7AY > > Tel: 01274 846386 > Fax: 01274 846201 > > [EMAIL PROTECTED] > > > > > CONFIDENTIALITY NOTICE > The information contained in this e-mail is intended only for the > confidential use of the above named recipient. If you are not the intended > recipient or person responsible for delivering it to the intended recipient, > you have received this communication in error and must not distribute or > copy it. Please accept the sender's apologies, notify the sender > immediately by return e-mail and delete this communication. Thank you. > > - > 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: ssh
ssh = Secure Shell http://www.ssh.org/faq.html On Thu, 22 Feb 2001, Karl Chen wrote: > I wonder what is ssh stand for. and what is benifit over telnet - 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: dropping columns
> But you could always look up the mysql documentation for your answer. > It should be identical if not, almost. Not even close. MSSQL 6.5 does not support dropping columns using ALTER TABLE. There are many differences between MySQL and MSSQL and even though it might work from time to time, relying on the excellent MySQL documentation to manipulate some other RDBMS is probably not a good idea. On Mon, 19 Feb 2001, Rolf Hopkins wrote: > This is a MySQL list not an MSSQL list. But you could always look up the > mysql documentation for your answer. It should be identical if not, almost. > Even better, switch to mysql and people here would love to help you. - 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 driver for DELPHI ?
The answer is no, MySQL does not include a native driver for Delphi. However, you can use MyODBC or one of the third-party drivers readily available... See the MySQL manual: http://www.mysql.com/doc/S/E/SEC521.html On Tue, 6 Feb 2001, Paulo Serra wrote: > > I am a DELPHI developer and I need to know if exists > a MySQL driver for DELPHI. > > Does MySQL have a driver for DELPHI??? > >If it does, please send me it... > >My e-mails: [EMAIL PROTECTED] > [EMAIL PROTECTED] > >... at least I´d like to know if it does or it > doesn´t and where I can find it. - 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: Displaying Date correctly
It's not annoying if that's the format you require... Try the DATE_FORMAT() function like so: select DATE_FORMAT(datecolumn,"%d/%m/%y") from tbl_name; Please see the manual: http://www.mysql.com/doc/D/a/Date_and_time_functions.html On Wed, 24 Jan 2001, Sam wrote: > Hi all, > > I was wondering how I can display a date in this format 'DD/MM/YY' > As when I do a select statement and display the date I get it in this format > 'DD-MM-YYY 00:00:00' > Which is kind of annoying. > > I am using mySQL and also PHP. > > Thanks in advance. > > Sam Rose - 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: ORDER BY command
select col1,col2 from table1 order by col1 ASC; Please see the manual: http://www.mysql.com/doc/S/E/SELECT.html On Tue, 16 Jan 2001, Robert wrote: > Hello. I am trying to get the results from a query to be ORDERED by > ASCENDING instead of the default DESCENDING. Is this possible, and if so > how? > > Robert > > > - > 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: Fw: SQL HELP
select *,DATE_FORMAT(datecolumn,'%M %D %Y'); On Tue, 16 Jan 2001, Mike Podlesny wrote: > > > Thanks for your help but that unfortunately doesn't answer the question, > > unless I am looking at it wrong. I want the sql statement to read > something > > to the affect: > > > > SELECT * FROM Table > > > > * is about 40 fields, which I do not want to type all of them out > > > > so do i do the following? > > > > SELECT DATE_FORMAT(*,'%M %D %Y') - 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 HELP
select field1,field2,DATE_FORMAT(datefield,"%M %d, %Y"),field4,fieldn from table; See the MySQL Manual: http://www.mysql.com/doc/D/a/Date_and_time_functions.html On Tue, 16 Jan 2001, Mike Podlesny wrote: > I want to select all the fields in from the mySQL database except I want my > date field to be returned in the format of: > > January 16, 2001 > > How can this be done without having to do the select in this manner: > > SELECT field1,field2,MONTHNAME(datefield),DAYOFMONTH(datefield), > YEAR(datefield),field3,field4...etc. FROM table > > Thanks for your help - 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: Your favorite Windows MySQL GUI client?
The urSQL Utility from http://www.urbanresearch.com/ursql allows you to easily edit text columns in a multiline text box. On Mon, 15 Jan 2001, Philip Mak wrote: > Hello, > > What is your favorite Windows MySQL GUI client? I'm developing a database > driven website and I'm looking for a program that I can use to maintain > the database. > > One of my special requirements is that I need a client that can edit text > blobs. So far the clients I've seen display the text blob as one very long > line that is difficult to edit. > > Criteria: > > - fairly stable > - free > - can directly edit the data by clicking on rows > - can edit text blobs in a multiline text area > > Thanks, > > -Philip Mak ([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
