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
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
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
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?
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
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
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,
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
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 (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
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
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,
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
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
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
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
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
. 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
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
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
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
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
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
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()
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
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
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
Update tblCompany SET CoName='quot;testerquot;' 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
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
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
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.
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
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.
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,
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
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
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
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).
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:
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().
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
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)
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
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
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 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
How about:
select position(' ' IN name) as fs from contacts having fs0;
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
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
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
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)
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
Have a look at the PHP mysql_fetch_array and mysql_fetch_row functions and
associated documentation...
?php
//assuming the db is already connected
$query = select id,name from Categories;
$res = mysql_query($query,$dbh) or die (bad query);
while($row = mysql_fetch_array($res)) {
echo
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
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
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
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
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
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
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
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:
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
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:
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
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
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,
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
69 matches
Mail list logo