agoura

1

votes
2

answer
35

views

i would like to manipulate the “AS age” column from table1

below is a query i wrote SELECT *, YEAR(CURDATE()) - YEAR(age) AS age FROM table1 and i would like to manipulate the 'age' column from the query above for instance like: SELECT * FROM table1 WHERE age BETWEEN 1 AND 9 how can i do it from this query SELECT *, YEAR(CURDATE()) - YEAR(age) AS age FROM...
agoura
0

votes
0

answer
5

views

How to display data-table on a Web page using in python using DASH framework?

I have written my code with an intention of displaying a table in a Web page. However, my current result is coming from console so far but i would like to view from a Web page. Below is what i have tried app.layout = dash_table.DataTable( id='table', columns=[{'name': i, 'id': i} for i in df.columns...
agoura
0

votes
0

answer
3

views

i am getting the following error : Can't reopen table: 't1' error. please assist

i am getting an '#1137 - Can't reopen table: 't1'' error i have my sample code below CREATE TEMPORARY TABLE temp_table ( INDEX(productName),INDEX(age)) AS select productName,age from productsmarket Inner Join customer on productsmarket.customer_username = customer.username; select distinct t1.p...
agoura