Questions tagged [source-code]
11 questions
6
votes
1 answer
Show procedure code in MySQL
I've tried to show the SQL code of a stored procedure called add_pixel:
mysql> SHOW PROCEDURE CODE add_pixel;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right…
Adam Matan
- 12,079
- 30
- 82
- 96
2
votes
1 answer
PostGIS error building with `make` in ./extensions: nothing to be done for 'comments'
I'm using code I checked out from SVN. Whenever I run make in ./extensions/, I get
make
for DIR in postgis postgis_tiger_geocoder postgis_topology address_standardizer; do \
echo "---- Making all in ${DIR}"; \
make -C "${DIR}" all || exit…
Evan Carroll
- 65,432
- 50
- 254
- 507
1
vote
0 answers
SQLite insertion with junction table
I need to write a transaction for SQLite, that adds a blog post and links it to content tags, and it seems to be a bit too complicated for me. Here's an example schema:
CREATE TABLE blogpost(
id INTEGER PRIMARY KEY,
content…
dba9999
- 11
- 1
1
vote
1 answer
Implementing a simple ERD in MySQL: is the implementation below 100% compliant with the ERD?
ERD
Consider the following ERD:
Tables
From it, I derived the following tables:
Company
------------------
c_id c_name
------------------
CompanyEmail
------------------
c_id e_id
------------------
Email
------------------
e_id …
feelthhis
- 265
- 1
- 3
- 10
1
vote
0 answers
mysql build error on Raspberry Pi Model 3A+ with Raspbian
I am building MySQL version 8.0.37 on a Raspberry Pi Model 3A+ with the Raspbian OS.
I have encountered several build errors regarding missing dependancies and resolved them. I am now faced with an error I am not sure how to debug. Can anyone…
user10709800
- 21
- 2
1
vote
0 answers
How would I skip test compilation in a MySQL build?
As the title suggests, I am building MySQL version 8.0.37 from source on a Linux machine and would like to skip test compilation.
I have attempted adding the flag:
-DINSTALL_MYSQLTESTDIR=
which, according to…
user10709800
- 21
- 2
1
vote
2 answers
Is there a way to examine SQL Jobs for references to linked servers?
In preparation for migrating a server farm to the cloud, I am attempting to enumerate all the linked servers that have been defined over the years. I also need to find (and correct) the code that references these linked servers.
Here is something…
datagod
- 7,141
- 4
- 38
- 58
1
vote
1 answer
Source code of View of Linked server sp_HelpText
How to use sp_helptext for view on the linked server ?
Adam
- 21
- 2
- 4
1
vote
1 answer
PostGIS error building with `make` in ./extensions: make[1]: *** No rule to make target
Whenever I run make in extensions, I'm getting error.
make
for DIR in postgis postgis_tiger_geocoder postgis_topology address_standardizer; do \
echo "---- Making all in ${DIR}"; \
make -C "${DIR}" all || exit 1; \
done
---- Making all in…
Evan Carroll
- 65,432
- 50
- 254
- 507
0
votes
1 answer
Can't find source code for building mysql
I'm trying to follow the instructions for building MySQL from source. They guide me to a link where I can download the latest GA. I end up at the downloads page, where I can download mysql-5.6.19-osx10.7-x86_64.tar.gz for my mac, and then untar and…
SaganRitual
- 109
- 3
0
votes
0 answers
How to selecting data from two queries using union?
I have three tables. I am trying to taking the data with two times interval after then subtracting from first two second for every possible row and getting the ledger report.
Solution is given by: jkavalik
Solved MySql Fiddle
My Problem
MYSQL…
Kabir Hossain
- 103
- 8