I was trying to add a new column as a foriegn key in existing table in laravel 9. But, it continuously giving SQL error. I want to create a simple category_id as a foreign_key in brand table. The below code…
I am wondering if the following MySql SELECT query takes O(N) or O(logN). Let us we have a table represents 4 integer intervals [startNum, endNum]. And the table is indexed by the startNum and endNum columns. startNum, endNum 3, 8…
I'm wondering if there is a more concise way of finding trees that have had a Vigor rating of 6, 8 or 9 for the past 5 years. In the past, I was looking trees dead only for the past…
can someone help me with my code? Why is it not working? My views.py def register(request): if request.method == 'POST': form = RegisterForm(request.POST) if form.is_valid(): fullname = form.cleaned_data.get('fullname') emailaddress = form.cleaned_data.get('emailaddress') password = form.cleaned_data.get('password') form.save() return redirect('/') else: form =…
I am using NestJS and Mysql without using TypeORM. I need to execute 2 or more simple SQL's, second SQL will use result from the first SQL. The problem is although I am using async/await the program doesnt wait for…
For example, I have a table with multiple order number and each order number has multiple itemnum. Then, each order number has same item but some order number has only one item. How can I get them? How can I…
I have a table similar to the following. (The addresses are actually IP addresses, but I'm keeping them short for simplicity.) | Cust ID | Address | | ------- | --------| | 1 | 111 | | 1 | 222…
I'm trying to order a list of addresses by street name, then street number. Both forms of this data reside in the same column, 'address' within my schema, 'data'. The data have a similar format to: 27 Longshire Cir 109…
I'm running sequelize-cli db:migrate to initialize a migration, but this happens Sequelize CLI [Node: 19.6.1, CLI: 6.6.0, ORM: 6.28.1] Loaded configuration file "config\config.js". == 20230221223939-aluno: migrating ======= ERROR: Cannot read properties of undefined (reading 'type') This is my config.js file:…
I have a python script written using twisted module which is running on an ubuntu server as a service. We have many gps devices which sends data every 10 sec. My job is to parse that data and store it…