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
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?
---
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 utili
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 wrot
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 DEFAUL
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
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:
> >
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 th
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
-
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 fr
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
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 (sor
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" t
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 creat
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
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 CO
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
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.
>
>
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 r
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 datab
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
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.m
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
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
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
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
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:
>
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
>
> T
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.urbanres
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 suggesti
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,
> 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, re
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
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 admini
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:
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 wro
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 ?
> t
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.mysq
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.
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 mysq
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.
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) Dro
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 c
> "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 applicat
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 materi
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 i
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
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() colum
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
A
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 PowerDesign
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
> >cr
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 Vi
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 fo
> 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 propositi
> 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 up
ge-
> 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
> 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 developi
> 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 sta
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 exper
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 worki
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:
>
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
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 kno
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.mysq
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 function
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 my
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 copie
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 i
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
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 som
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 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 com
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 erro
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
>
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
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
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.
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
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
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
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
>
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 wonde
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 n
83 matches
Mail list logo
