How to Insert an Asterisk in MySQL
The asterisk character is a keyword used in MySQL programming, so you must insert an asterisk character using string notation if you wish it to appear in text. This means you must surround the asterisk you want to insert into the database table with apostrophe characters. Use the Script Debugger program to create the function to insert the table information.
Other People Are Reading
Instructions
-
-
1
Click the Windows "Start" button and select "All Programs." Click "MySQL," then click the "Script Debugger" shortcut to open the software.
-
2
Click the database name in the main Script Debugger window and then click the "New Query" button. This button starts the MySQL editor to create the insert statement for your tables.
-
-
3
Type the following code to insert an asterisk:
insert into customers (location) values ('*')
This example code inserts the asterisk character into the field labeled "location." The table used is "customers." Replace the field and table values to your own table and field names.
-
4
Click the "Run" button to run the query on the MySQL server. The information inserts into the database table and a "Success" message returns in the Script Debugger program.
-
1
