Mysql Question posted in
The official MySQL documentation can be found here.

When querying a simple table in MySql, the row values appear as NULL. How do I get my query to show the row values?

I created a table called "Author" and inserted row values into it in MySql. When I query the table with SELECT * FROM Author; the result will show the columns but not row values.Author Table
Author Row Values
Query Results

I assume I have some kind of white space or syntax problem, but I cant seem to figure it out.

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    @Russell Fox thank you. I needed to highlight the INSERT query and run that before the SELECT.


  2. 0

    It looks like you just didn’t run the 2nd query (insert). My IDE for MySQL (dbeaver) doesn’t automatically run all the queries on the screen, just the one where the cursor is. Or there’s a button that says "execute sql script" which will run all of the queries in turn.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search