Databases - TopAnswers

TopAnswers Databases

टेक्-मराठी

«
1
2
»

Do triggers work on dbfiddle with MySQL 5.6? 7

dbfiddle mysql-5.6

(edited, 5 years ago) 5 years ago Vérace

2 Triggers work, but the DELIMITER statement does not. It isn’t supported by the PHP driver, because it is not a mysql database command, but mysql client command.

(edited, 5 years ago) 5 years ago Jack Douglas

Use db<>fiddle Oracle schema name in metadata table 1

dbfiddle oracle-18c

(edited, 3 years ago) 3 years ago User 1791

4 You can just use sys_context to get the schema name dynamically:

(edited, 3 years ago) 3 years ago Jack Douglas

Return a value/row when selecting SDO_GEOMETRY 1

Meta

dbfiddle

(edited, 3 years ago) 3 years ago User 1791

1 Probably not, but you can modify your SQL to use sdo_util.to_wktgeometry

3 years ago Jack Douglas

SHOW WARNINGS; 2

dbfiddle

(edited, 3 years ago) 3 years ago Anonymous 2333

Oracle support on dbfiddle doesn't allow multiple statements in one batch

dbfiddle oracle

3 years ago Anonymous 2328

10 The OCI (“Oracle Call Interface” - their own API) doesn’t support running multiple statements in a single batch.

(edited, 3 years ago) 3 years ago Jack Douglas

Request: update font-awesome version 1

Meta

dbfiddle

3 years ago Anonymous 2311

3 I’ve replaced Font Awesome with raw SVGs from Fork Awesome.

(edited, 3 years ago) 3 years ago Jack Douglas

Missing results for SELECT queries after SELECT * FROM set-returning function with nested row tpe 6

dbfiddle

(edited, 3 years ago) 3 years ago Erwin Brandstetter

3 I’ve managed to find a test case that doesn’t use a function at all:

3 years ago Jack Douglas

Timezone aware datatypes - PostgreSQL & MySQL, potential inconsistencies with UTC? 2

postgresql mysql dbfiddle

(edited, 3 years ago) 3 years ago Vérace

Turn on Oracle Spatial in db<>fiddle?

dbfiddle

4 years ago User1973

db fiddle, Markdown export, Firebird

dbfiddle firebird

(edited, 4 years ago) 4 years ago Arioch

«
1
2
»

chat

transcript

a year

bobiscool — Tuesday, 11th Jun 2024 21:38

is asking questions about ntfs technicalities allowed here?

3 months

Sam — Sunday, 10th Mar 2024 08:16

Hi,
Does anyone know sql can help me with a question? I want to know how to check active IDs from six months ago in one single statment as an attribute, something like lag()?

3 months

Anonymous 11737 — Monday, 11th Dec 2023 12:58

I am using mysql 5.7 version

2 months

Evan845 — Tuesday, 17th Oct 2023 18:44

Hello

a month

ypercubeᵀᴹ — Friday, 15th Sep 2023 11:59

PostgreSQL 16 Released!

3 months

Andriy M — Thursday, 22nd Jun 2023 16:23

Morning

2 hours

PeterVandivier — Thursday, 22nd Jun 2023 14:08

o/

17 hours

Josh Darnell — Wednesday, 21st Jun 2023 20:45

Morning

7 hours

Andriy M — Wednesday, 21st Jun 2023 14:14

Morning everyone

a day

Jack Douglas — Tuesday, 20th Jun 2023 14:22

Morning all 😃

7 hours

John K N — Tuesday, 20th Jun 2023 07:15

Me: Nice to see you! To see you?
Audience: …Nice!
(- Bruce Forsyth)

4 days

Josh Darnell — Friday, 16th Jun 2023 15:37

Morning

13 minutes

PeterVandivier — Friday, 16th Jun 2023 15:24

Morning

5 hours

Andriy M — Friday, 16th Jun 2023 10:00

Morning

3 hours

John K N — Friday, 16th Jun 2023 06:47

Morning

5 months

Andriy M — Tuesday, 10th Jan 2023 11:21

Hi guys. Someone found an issue in my SO answer and posted a better one. Would be great if you could vote it up to make it more visible. Hopefully the OP notices and changes their choice too, although they don’t seem to have been around lately.

4 months

Andriy M replying to Jack Douglas — Tuesday, 20th Sep 2022 17:09

When you look at the map to see who is at war with whom, I can see why!

16 minutes

Jack Douglas — Tuesday, 20th Sep 2022 16:53

it’s interesting to get your first-hand insight!

Jack Douglas replying to Andriy M — Tuesday, 20th Sep 2022 16:53

I find it easy to forget how huge Ukraine is too

2 hours

Andriy M replying to Jack Douglas — Tuesday, 20th Sep 2022 14:53

Thinking about it, it’s what we’ve already had since 2014, which was when the war actually began. Only at that time it was much less prominent and covered less area, hence the sense of normality was easier to maintain. Even here in Ukraine, many lived as though nothing was happening. “Yeah, we have some conflict in the eastern part, yeah, Russia’s annexed Crimea, but other than that everything’s fine, nothing to worry about.” I have to admit that was very close to my way of thinking during those years. Partly the reason was that the conflict wasn’t officially called a war, it was just an anti-terrorist operation. But for the people in Donbas it was as much an actual war as it’s been for everyone since February 24th. Even so, most of Ukraine isn’t occupied or near the front lines, so life must go on (as much as possible, yes).

28 minutes

Jack Douglas replying to Andriy M — Tuesday, 20th Sep 2022 14:24

It’s odd thinking about normal things going on during the war but of course they just have to I guess, as much as possible.

44 minutes

Andriy M replying to Jack Douglas — Tuesday, 20th Sep 2022 13:41

No idea, but it’s possible that some might be. A new academic year has recently begun, after all.

20 hours

Jack Douglas replying to Andriy M — Monday, 19th Sep 2022 17:38

Are lots of Ukrainians learning SQL right now? Seems unlikely but db<>fiddle has had 16k variations of https://dbfiddle.uk/vJq1ro34 run in the last week, which makes me curious.

17 days

Jack Douglas replying to Paul White — Friday, 2nd Sep 2022 16:21

Cool, thanks @Paul

3 hours

Paul White — Friday, 2nd Sep 2022 13:11

Tested ages ago but forgot to say: it’s fine, thanks.

18 days

Paul White — Tuesday, 16th Aug 2022 00:14

Thanks will check later

10 hours

Jack Douglas replying to Paul White — Monday, 15th Aug 2022 14:13

should be fixed now Paul, though there is a chance other things got broken in the process (as all the engines have been rebuilt from scratch)

a month

ypercubeᵀᴹ — Monday, 18th Jul 2022 12:53

heh, super!

15 minutes

Jack Douglas replying to ypercubeᵀᴹ — Monday, 18th Jul 2022 12:38

Just for you @ypercubeᵀᴹ : https://dbfiddle.uk/?rdbms=postgres_15 😃

an hour

Jack Douglas replying to Paul White — Monday, 18th Jul 2022 11:25

thanks Paul, I will look into that

26 minutes

Paul White — Monday, 18th Jul 2022 10:59

Just says “run failed”

Paul White — Monday, 18th Jul 2022 10:58

Also the AdventureWorks sample database on SQL Server 2019 instances of db<>fiddle seems to be broken

an hour

ypercubeᵀᴹ — Monday, 18th Jul 2022 10:09

https://www.postgresql.org/about/news/postgresql-15-beta-2-released-2479/

ypercubeᵀᴹ — Monday, 18th Jul 2022 10:09

@JackDouglas, in case you haven’t noticed, Postgres has released 15 Beta 2

ypercubeᵀᴹ — Monday, 18th Jul 2022 10:05

hi all

4 months

Andriy M — Friday, 11th Mar 2022 10:21

Would really like to just reach out and hug you or shake your hand. You hang on tight there, mate

Andriy M replying to FoggyFinder — Friday, 11th Mar 2022 10:19

Wow, I had no idea you were from Ukraine as well. And from Kharkiv no less. I was scared witless just hearing explosions near our city. What you must be going through, I can’t even imagine.

5 hours

Paul White — Friday, 11th Mar 2022 05:27

It’s kind of amazing to me that people in areas like this still have internet access

Paul White — Friday, 11th Mar 2022 05:27

According to the local police, 209 people had been killed as of 7 March, including 133 civilians. In addition, 443 people, including 319 civilians, had been wounded.

Paul White — Friday, 11th Mar 2022 05:25

Battle of Kharkiv (2022)

The Battle of Kharkiv is an ongoing military engagement taking place in and around the city of Kharkiv in Ukraine as part of the Eastern Ukraine offensive during the 2022 Russian invasion of Ukraine. Kharkiv, located just 32 kilometres (20 mi) south…

Paul White — Friday, 11th Mar 2022 05:25

also

Paul White — Friday, 11th Mar 2022 05:24

Kharkiv, also known as Kharkov, is the second-largest city and municipality in Ukraine. Located in the northeast of the country, it is the largest city of the historic Slobozhanshchyna region. Kharkiv is the administrative centre of Kharkiv Oblast an…

Paul White — Friday, 11th Mar 2022 05:24

I was confused for a while thinking Kharkov and Kharkiv were separate places

Paul White replying to FoggyFinder — Friday, 11th Mar 2022 05:22

What’s the situation there?

15 minutes

FoggyFinder replying to Andriy M — Friday, 11th Mar 2022 05:07

good luck. I’m from Kharkiv btw

5 hours

Andriy M replying to Josh Darnell — Friday, 11th Mar 2022 00:27

✌

2 hours

Josh Darnell — Thursday, 10th Mar 2022 22:26

Words fail me.

Josh Darnell replying to Andriy M — Thursday, 10th Mar 2022 22:25

💙💙💙

8 hours

Andriy M replying to John K N — Thursday, 10th Mar 2022 14:07

Thanks John. I and my friends and relatives are indeed okay so far, thank God.

3 hours

John K N replying to Andriy M — Thursday, 10th Mar 2022 11:29

Nice to see you’re doing ok.

23 minutes