Category "database"

UPDATE Query without WHERE Clause

Can the UPDATE query be used without a WHERE clause? And if so in what conditions?

Export data in parquet file in teradata

I cannot figure out a solution for exporting data from the Teradata database in a parquet format. I am using tdload and tbuild method which required tpt script

How to test an SQL Update statement before running it?

In some cases, running an UPDATE statement in production can save the day. However a borked update can be worse than the initial problem. Short of using a test

Find duplicate records in MongoDB

How would I find duplicate fields in a mongo collection. I'd like to check if any of the "name" fields are duplicates. { "name" : "ksqn291", "__v" : 0

how to pass a java object to oracle stored procedure with following details

I have my ORACLE table with structure as desc extraction_log1 Name Null

Drop default constraint on a column in TSQL

I have a table with a column like this that is currently live: name NVARCHAR(128) NOT NULL DEFAULT '' I am altering the column like this to make it nullable:

Make survey at laravel 5.4 and MySQL

I need to make a survey for my website. I have this: Route: Route::resource('survey','surveyController'); Controller: public function index() { $show=surve

ETL Migration Solution for OceanBase to Aurora

I am looking for an ETL solution that has all the necessary components with limited hand-coding that helps to migrate data from Oceanbase DB to AWS aurora. I tr

Tuple Relational Calculus query

I am revising for a Database course and I have the following question from a past assignment: The database schema is as follows: LIKES(drinker,beer); FREQUENTS

Error: Packets out of order. Got: 1 Expected: 0

All the Solutions I found for this Problem don't work for me. I'm just loading one Dataset and after approximate 150 Request I get this Error: Error: Packets o

Saving Data from form to database using AngularJS and php

I'm pretty new in angular. i created a modal window to user share story and after that show it in body: html <button class="btn btn-primary new-story" n

Correct use of transactions in SQL Server

I have 2 commands and need both of them executed correctly or none of them executed. So I think I need a transaction, but I don't know how to use it correctly.

How to get product details from Magento Database with mysql query?

I just want to know about how to get product details from magento database tables. I know how to run MySQL Query and get results from database. But the problem

Run xp_create_subdir without admin privilidges

The Point: I want to be able to create a directory on the filesystem through a non-sysadmin SQL user. I'm creating a web front-end for a deployment script whi

How to save php socket resource in database?

I am creating a socket in php with socket_create and would like to store the received socket in a database (to access from other php code). However the socket i

How would I make Flutter connection with Oracle?

I want to make a simple web page using flutter as flutter for web, but I want to use Oracle as database in the backend. I know firebase will be more helpful, bu

How to access the files in kaha db

As the kaha db used to store the persistent data is there any method to access the un consumed files in the db. Please suggest with some of the UI through which

Post Form Data To phpmyadmin Database

I need to post data from a website (HTML5 based) to a database on PHPMyAdmin. I have the database created as sewcute and a table named members. I'm using XAMMP

Using text as a primary key in SQLite table bad?

Is it bad to have text as a primary key in an SQLite database? I heard that it's bad for performance reasons, is this true? And will the rowid be used as the ac

How to convert DB2 binary data to UTF-8 at query level

I am connected to IBM DB2 database with java but data is stored as binary format in database so when I fetch any value it comes as binary or hexdecimal format.