I created a Springboot application using https://start.spring.io/. After adding some initial application properties for spring-data-jpa, the application starts fine however, I do not see any tables created in my local database. To test this further, I provided incorrect credentials in…
I want to add "/invent" at the beginning of the file path in the invImage and invThumbnail columns. This is what I have in mind, SELECT FROM inventory SELECT CONCAT("/invent") AS invImage, invThumbnail; Since it is not easy to undo…
I have these tables which are not related at all: Books Apps Cars Id Views Id Views Id Views ------------ ------------ ------------ 1 3 4 5 11 10 2 4 5 100 13 3 3 3 6 5 15 7…
I have an XML as: <?xml version="1.0" encoding="UTF-8"?> <products currency="EUR"> <product id="457654754" vat="13.0"> <price gross="0.09" net="0.07"/> <sizes> <size id="0" name="gfdgfdgfdg" panel_name="dfgfdgfdgfd" code_producer="fgdfgfdg" iaiext:code_external="457547547547" code="354643643643" weight="4" iaiext:weight_net="10" > <stock id="1" quantity="333"/> </size> </sizes> </product> </products> when I parse it as: <?php…
I have problem cant exist catogaries : I want chek if the catogary is add before or not please i need help I have problem cant exist catogaries : I want chek if the catogary is add before or not…
DB::table('visitors') ->join('event_visitor', 'visitors.id', '=', 'event_visitor.visitor_id')->where('sex', 0) ->where('event_visitor.event_id', 1) ->count(); this is the query to get the count of men at the visitor's table with an event id of 1 I want to get the record count of men women and…
I'm trying to create a REGEXP pattern that will check if a string contains a set of numbers separated by a space. I have tried the 4 statements below. They all return 0. What am I doing wrong? Thanks. SELECT…
the below query it scans more rows while the table has an index on it but not using that index for that column. Query; SELECT * FROM st_aepsrequest_log WHERE `snd_transno` IN ( SELECT pwcashout_transno FROM st_aeps_transaction_master a WHERE a.`entry_date` >=…
I have a query. It has an index but I'm not sure why it's taking time for fewer rows. Can anyone please suggest to improving that query performance? SELECT up.id post_id, c.id community_id, SUBSTRING(up.description, 1, 30) post_description, c.name community_name, c.is_index…
Help me to populate below columns as date without using to_date or to_char functions. day month year 1 2 1995 2 3 1998 5 6 2020 output date 01-02-1995 02-03-1998 05-06-2020