Questions tagged [sql]

SQL is a programming language designed for managing data in relational database management systems (RDBMS).

SQL is a programming language designed for managing data in relational database management systems (RDBMS).

121 questions
3
votes
1 answer

How to install Adventure Works DB on Ubuntu 16.04?

I have downloaded the free Express version of SQL Server 2017 onto my Linux Ubuntu 16.04 LTS machine. I have created a test database through the command line terminal, and I was able to create a table and also managed to insert data into the…
2
votes
1 answer

Why I can't insert a picture into database?

I have a table with create table pictures( pic_ID int, picture blob, primary key (pic_ID) ); I use INSERT INTO pictures VALUES (1, load_file('/home/hai/Pictures/icon.jpeg')); and then select * from pictures; displays this Why it has…
0
votes
0 answers

How to open SQL file

I am trying to open an SQL file, but unfortunately I have some problems. When I try mysql -u -p dbname < dbsource it says ERROR 1049 (42000): Unknown database The file also encrypted SHA512 and I'm not sure if that is the case or not. Need help.…
sarp
  • 433
0
votes
0 answers

SQL Server on Ubuntu: cannot enumerate files on other Ubuntu

I have an installation: Windows based LAN Ubuntu 20.04 and SQL Server 2022 Ubuntu 22.04 Ubuntu 22.04 has Shared directory. It is visible in File Explorer on Windows and in Ubuntu 20.04 too as a remote shared folder. OK. But when I run SQL Query on…
ZedZip
  • 207
0
votes
2 answers

Unable to install SQL Server 2022 on ubuntu 22.10

I am having trouble on installing SQL server 2022 Express... sudo apt-get update sudo apt-get install -y mssql-server Hit:1 http://security.ubuntu.com/ubuntu kinetic-security InRelease Hit:2 http://packages.microsoft.com/repos/code stable…
mmakr
  • 1
0
votes
1 answer

install SQL server express 2008 r2 on ubuntu 18.04?

I need to install a new invoice software on my pc. It is a Windows' based product and I am trying to run it by wine. The installation process terminates because of this error: "SQL server express 2008 r2 problem 536870913". Any ideas? I tried these…
0
votes
1 answer

SQL database access access

I can get to where I can view databases in my sql, however I want to see what is in those databases? what is my next command?