Correcting queries - MySQL Database

James Walker

In Oracle there is a way to correct any mistakes in a query, by simply
entering the edit command. And from there, a text editor is opened, to
allow the corrections to be made to the query. This eleminates having
to retype the whole query. Is this possible in MySQL?

Jul 23 '05 #1

Subscribe Reply

1092

Randell D.

James Walker wrote:

In Oracle there is a way to correct any mistakes in a query, by simply
entering the edit command. And from there, a text editor is opened, to
allow the corrections to be made to the query. This eleminates having
to retype the whole query. Is this possible in MySQL?

It depends on what Client tool you are using to connect to the db
server. I use the MySQL Query Browser that is GPL (I believe) from
MySQL.com for things like this.

randelld

Jul 23 '05 #2

Thomas Bartkus

"James Walker" <wa*******@comc ast.net> wrote in message
news:Wd******** ************@co mcast.com...

In Oracle there is a way to correct any mistakes in a query, by simply
entering the edit command. And from there, a text editor is opened, to
allow the corrections to be made to the query. This eleminates having
to retype the whole query. Is this possible in MySQL?

Possible? It's essential!. It depends upon what you use to communicate with
MySQL. The simplest setup would be to open up ones favorite editor in one
window while simultaneously holding open a second window where you can
execute the script and view results (or errors!). I happen to like being
able to choose my own text editor.

Repeat
Edit
Save
Execute
Until Success

If that sounds complex (it's not!) you can go for one of several integrated
GUI utilities out there. Simple and free is the MySQL Control Center
[MySQLCC] that you can download from www.mysql.com. It is available in both
Windows and Linux/Unix flavors. Using it for making queries - you get a
text editing window (pane) for your SQL, a results window, and an
error/message window. I expect it would look a lot like your Oracle
utility.

but - Probably better :-)
Thomas Bartkus

Jul 23 '05 #3

Similar topics

6782

Bad performance in queries with Jet4.0 and linked ODBC-tables to SQL-Server 2000

by: Andreas Lauffer | last post by:

I changed from Access97 to AccessXP and I have immense performance problems. Details: - Access XP MDB with Jet 4.0 ( no ADP-Project ) - Linked Tables to SQL-Server 2000 over ODBC I used the SQL Profile to watch the T-SQL-Command which Access ( who creates the commands?) creates and noticed:

Microsoft SQL Server

5743

DHTML Floating iFrame - help testing/correcting

by: gsb | last post by:

Don't know if this is the right place to post this JavaScript issue. If not, could someone point me in the right direction please. I am trying to make a "cross browser compliant" floating iFrame. Not real fancy, just load, resize and move. But, I do not have the browsers, OSs and different machines (like Mac) to test the code on. So I need some help to see where this basic example of works and does not work.

Javascript

2319

How to run queries on a subset of records in a table?

by: Roger Green | last post by:

I have inherited a complex database that has many dozens of queries that derive data from a people table. I now need to be able to run these queries (from within a significant number of forms) not on the full dataset, but on a subset of the data in the people table. I want to avoid having to put criteria in all of the individual queries or forms, or having to change the data source for all the queries. Is there anyway I can restrict...

Microsoft Access / VBA

2333

Which are better queries in code or stored queries?

by: NeilAnderson | last post by:

I'm a fairly new user of access & I've never had any training, so I'm wondering if I'm doing the right thing here, or if it matter at all. I'm building a database for room booking purposes and I'm trying to do all record changing using queries. From what I can glean from this (excellent!) group this is the right way to go about it. At present what I'm doing is building & trouble-shooting the queries with query-builder then using code to...

Microsoft Access / VBA

4042

Can't see all of the queries when merging to MS Word and can't get to reports

by: Jerry Hull | last post by:

I'm working with a database developed by an untrained person over several years - and on a network that has recently been upgraded with a new server installed and MS office upgraded from 2K (I think - it might have been XP) to 2003. The database is impressive, both in what it does and the obtuse and inconsistent ways it works. There are several hundred queries, for example, with no indication of where they are used or if they are in fact...

Microsoft Access / VBA

1631

can anyone help in correcting this code?

by: vv1 | last post by:

Write a C program for reading in a message string (with no blanks) and decoding the message. Store the decoded message in another string called outString. After decoding is complete, print the decoded message. Use the following key for decoding.Convert any numeric characters in input (0-9) to a space in the output. Upper case letters in input/message string are decoded by adding 19 to their ASCII/Integer value. Lower...

C / C++

1414

can anyone help me in correcting this code?

by: vp1 | last post by:

C / C++

2098

I don't know enough of what's inside VS2005 to know if what I'm doing need correcting

by: Frank | last post by:

I've done this a few times. In a solution I have a project, Say P1, and need another project that will contain much code that is similar to that of P1. I hope no one gets hung up on why I don't somehow share the code. So, I copy the folder P1 is in, change the new folder name, and is VS2005 to change all occurrences of P1's name tp P2's name.

Visual Basic .NET

1700

Please help me in correcting the code

by: srinivasarv | last post by:

Dear Friends, kindly help me in correcting the following code This code is for printing the report from the combo box after selection which connects to different reports as selected. I have written this code behind the combo box. Private Sub Bank_Name_AfterUpdate() Dim rpt As String

Microsoft Access / VBA

8996

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8832

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

9386

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

9333

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9254

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

6799

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

4608

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

2791

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2217

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General