How to Output Characters With a MySQL Query
The MySQL "select" query lets you output characters from your database tables. The MySQL Query Browser application shows you the output characters when you test the code on your database server. You use this application to write SQL code and display the results to the screen. You can use this output to evaluate your database data or save it to another file.
Instructions
-
-
1
Open the Query Browser software from the Windows "Start" menu on your database server.
-
2
Type your username and password to access the database. After the database displays, click "File," then click "New Query" to open a query editor.
-
-
3
Type the select statement to display database characters. For instance, if you want to see your customers' names, type the following "select" query:
select [name] from customers
-
4
Click "Execute" to run the query and display the database characters from the table.
-
1