mysqlslap not recognizing database schema

170
March 22, 2019, at 2:20 PM

I'm running mysqlslap like this:

mysqlslap hhi --concurrency=20 --iterations=5 --query=queries.sql --delimiter=";" --create-schema=hhi -u root -h 127.0.0.1 -p

A query in queries.sql references a table called "orders", which for sure exists. However, when I run that command I get:

mysqlslap: Cannot run query SELECT orders.order_num, ship_billing, ship_date, po_num, customer_name, employees.FirstName,employees.LastName,rev_num,trans_date,orders.employee_num as ordempnum ERROR : Unknown table 'orders' in field list

Does that mean it's not actually looking at the right database?

Rent Charter Buses Company
READ ALSO
Generate income in Odd number MLM

Generate income in Odd number MLM

I want to generate income in odd numbers in MLM

131
MySql Workbench and Html Sublimetext 3

MySql Workbench and Html Sublimetext 3

I have been writing SQL queries for a while now, but brand new to HTML

146
Add image to existing MySql record

Add image to existing MySql record

I'm quite new to PHP and MYSQL

154
MySQL ORDER BY Datetime works in PHPMyAdmin but not PHP

MySQL ORDER BY Datetime works in PHPMyAdmin but not PHP

When I run this query in PHPMyAdmin

174