Insert into select using typeom
I try to execute an “INSERT INTO SELECT” using typeorm in a nestjs project.
I’ve correctly sett the subscriber part, but when I want to execute my function, I have an error
I try to execute an “INSERT INTO SELECT” using typeorm in a nestjs project.
I’ve correctly sett the subscriber part, but when I want to execute my function, I have an error
I have a nestjs project in which I need to store the videos and save their paths in the mysql database my question is: how can I create a createReadStream of one of these videos knowing that the videos and the database will be in one server and the application in another server ??
I have local MySQL database created in docker container from following docker-compose.yml
I am using nestjs and typeorm (Mysql). I have two tables users and categories, and in category table i have a foreign key linked to userid. What i want to do is search firstName from user table while querying the category table.
Here is the query
I’m using TypeORM with MySQL, I have two Entity, User and Project:
I have a NestJS project that has an entity called Users. In this entity there are login related information about a user. I also have another entity called Profile, that will hold the user’s name, pictures etc…
I am making a table for an email with Nestjs, MySQL, and Typeorm. I have char type primary key length of 39, and have put a unique string made up of UUID concatenate with some extra sting in it.
Here is the way I make the primary key with Typeorm in Nestjs entity file named ’email’. There is no @PrimaryColumn or @PrimaryGeneratedColumn in it.
I want to use alias from top query in subquery.
Now I have error with ‘artc’.
Why do I keep getting this error saying