0
votes
0answers
4 views

Stack Depth Limit Exceeded (After delete trigger)

CREATE TABLE parent ( parent_id VARCHAR(30) PRIMARY KEY ); CREATE TABLE child ( parent_id VARCHAR(30) REFERENCES parent ON DELETE CASCADE, child_id VARCHAR(30) PRIMARY KEY ); CREATE OR ...
2
votes
0answers
8 views

Schema for storing historical data on shared identifiers

When user account is assigned an IP address, I create a table entry for the account/IP mapping. This data in the table is updated every 5 minutes. Right now I'm only keeping real-time data but I need ...
0
votes
0answers
6 views

MySQL loading XML

Hello i have this XML format (illustration) [Im using MySQL 5.6] <ROWS xmlns:xsi="..." xmlns="..." xsi:schemaLocation="..."> <TABLE col1="7169340714" col2="2" col3="2013-09-05T15:19:42" ...
0
votes
2answers
29 views

Why MAX() of SUM() giving wrong output?

I have a table employee id name salary city 1 ram 50000 c1 2 sham 20000 c2 3 jadu 80000 c1 4 madhu 90000 c4 5 hari 10000 c2 6 gopal 34000 c3 7 ...
0
votes
1answer
6 views

Inserting only 1 data into database PDO

Why is this not working please help me! how can i insert 1 data into database and also i want where in it :( $Recipient = $_GET['Add_Friend']; $Sender = $_SESSION['IsLogged']; $query = 'INSERT INTO ...
1
vote
1answer
11 views

How the sys user gets the sysdba privilege?

I am using oracle 12c on Linux. Using the enterprise manager database express I am looking at the list of privileges and roles for the sys user but I haven’t found the sysdba privilege assigned there. ...
0
votes
1answer
18 views

What database should I use?

I am writing a log analysis program in bash. As part of it, I am compiling a list of known errors, so that I can search and reference those errors as part of the known list. I originally was going to ...
0
votes
1answer
8 views

Import binary database file into postgres

I have a quite newbie question that I do not know if is possible or not: I had to format my computer, and the only way to keep my postgres database was accessing to data with my folder browser ...
1
vote
1answer
10 views

Index on integer column not helping. Help? (EXPLAIN ANALYZE output inside)

The table market_trades has an integer column market_id which takes values from 1 to 5. This seems like a pretty straightforward query to get the number of trades on each market: WITH markets AS ( ...
0
votes
0answers
4 views

problem with localhost or path on xampp instalation

I have xampp installed on my E: drive, windows 7 system the control panel works fine, both apache and mysql start normally ports for apache are 81 and 444 port for mysql is 3306 My wordpress ...
1
vote
2answers
23 views

left join not working

CREATE TABLE `table1` ( `id` INT(10) NOT NULL ) ENGINE=InnoDB; CREATE TABLE `table2` ( `id` INT(10) NOT NULL, `value` INT(10) NOT NULL ) ENGINE=InnoDB; INSERT INTO table1 VALUES (1), (2), (3), (4); ...
0
votes
0answers
14 views

plsql script continue excution even there ar promt statement

I am facing new problem in plsql , i programmed a script for 200 line but ,there is no wrong but its weird wrong ,it means oracle doesnot inform with error ,but from human being it error like iam ...
0
votes
0answers
3 views

MySQL DATE vs DATETIME read/write performace

Did anyone perform accurate read/write performance comparisons of MySQL's DATE vs DATETIME column types? Please do not bother writing "It should be faster" or "I think it's faster". I am looking for ...
-2
votes
0answers
11 views

can any one explain Mysql Backup Types and those backup uses in real time?

can any one explain MYSQL backup types ,and how to take those back ups with examples. iam using Mysql community edition 5.6.17. Thanks.
0
votes
2answers
22 views

Need Help maintaining multiple databases for a multi-tenant application?

i need some information about multiple databases for a multi-tenant application ? I am working on a project in which we are maintaining separate database for every company? The Companies Database ...
-1
votes
0answers
8 views

click a button two popup windows will be open

when i click a button , two popup windows will be open or click a button two new windows will be open. i use windows.open() method it just open only one window but i need a two windows so tired two ...
1
vote
2answers
29 views

Reduce space used on C drive

I have installed SQL Server 2008 R2 on my laptop, under 32-bit Windows 7. The SQL Server installation is using approximately 30GB of space on my C: drive. Why is it using so much space, and how can I ...
0
votes
0answers
9 views

What are recommended (working) permissions for a user to view all SQL Agent jobs

A new user (associated with an existing login) is created in msdb and assigned membership: use [msdb]; create user [TheUser] for login [AnExistingLogin]; alter role [SQLAgentUserRole] add member ...
0
votes
1answer
17 views

Mysql speed issues with SHOW COLUMNS or SHOW FIELDS

To avoid making code changes every time we have a database change, we just use the SHOW FIELDS (Alias of SHOW COLUMNS) to get all of the columns for Inserts. We call this multiple times for multiple ...
0
votes
1answer
16 views

Schema check or “DATE as separate table”

I'm dusting of my SQL, and would love to know if I've got my mental ER-diagram right. http://sqlfiddle.com/#!2/c5c59 Basically, I've got 10-15 different datasets (actividades) from several locations ...
1
vote
1answer
36 views

Optimizing a query on a large table (EXPLAIN ANALYZE result inside)

I have a table market_trades with a timestamp column: api_production=# \d market_trades; Table "public.market_trades" Column | Type ...
0
votes
0answers
6 views

how can I call nzsql or nzload from script without disclosing sensitive password?

I don't see this in the Netezza documentation. We have lots of Linux scripts where we do this: NZ_PASSWD_ENCRYPTED=29TY20T98= NZ_PASSWD_CLEAR=`DecryptFunc $NZ_PASSWD_ENCRYPTED` NzResult=$(nzsql -db ...
0
votes
1answer
14 views

mysqldump: Got error: 1066: Not unique table/alias

What usually causes this mysqldump error? exec error: Error: Command failed: mysqldump: Got error: 1066: Not unique table/alias: 'TableFoo' when doing LOCK TABLES
0
votes
0answers
7 views

how to sync local mysql database and live server database?

my plan is to store data in my local mysql database and after a time intervel it will update my live mysql database remotely. Is it possible? i'm planing a inventory management script in php mysql. ...
-1
votes
2answers
21 views

Indexing into two “buckets”

I'm creating a database with PostgreSQL that has an integer field called "delay". All of my queries on this column will be checking if the value of this column is less than or equal to 0, or greater ...
0
votes
0answers
30 views

How can I deal with a multi-record type field without breaking things futher? [on hold]

If I remember anything about database design, I think this is a scenario where I'd use a combined key right? So I have. Note: Field1, Field2, Field 3, FieldX; Alert: FieldA, FieldB, FieldC; All of ...
0
votes
0answers
13 views

Infinite loop in MySQL when connecting to database

I am running xampp on Windows - Apache and MySQL start fine, but when I try to go to the directory where I have my example app, it loops infinitely waiting for localhost: The log shows: 2014-08-22 ...
0
votes
1answer
13 views

Are there any good tools to convert mysqldump files to CSV?

I need to convert a file resulting from mysqldump into a csv file. I'm not willing to write my own ad hoc, informally-specified, bug-ridden, slow implementation of a sql parser to extract the values ...
2
votes
1answer
21 views

How to enforce the structural constraints of rectangularly arrayed data?

(I'm particularly interested in answers that view the question below as a special case of the question: how should a RDBMS enforce structural constraints that are more specific than "one-to-many" and ...
0
votes
1answer
31 views

Replicating a View to a Table. Issues with schema binding, view indexing

I am rather new to this. On my development server, I have 3 views that get live data from another database on a private internal server. Sample structure: DevDB --> Tables --> Views ...
0
votes
2answers
38 views

How to use same stored procedure for different tables and avoid using dynamic sql

I have quite a few tables which contain some common columns (same name and datatype). On these columns I need to perform the same operations and I would like to do that via a stored procedure. However ...
0
votes
2answers
34 views

How to break table into two without losing performance?

According to http://stackoverflow.com/a/174047/14731, splitting away infrequently-needed columns frees up the cache allowing faster retrieval of the commonly-used columns. I've got a table whose ...
1
vote
2answers
26 views

Collect results of many sql server jobs

I intend to create a simple job on a bunch (100+) sql servers (of differing flavors) that does a simple automated query periodically (like weekly). These jobs then need to push the result out to a ...
1
vote
1answer
16 views

sp_publication_validation procedure doesn't seem to work properly

I am trying to use sp_publication_validation stored procedure to validate that my replication setup is working correctly. This procedure is pretty straightforward and is described here. I am running ...
0
votes
0answers
9 views

Multi-Column Full Text Search Going Very Slow

I have a full text index on a table articles for the columns content, title and keywords When doing the search on each of the columns, like so select count(1) from articles where ...
0
votes
0answers
19 views

Slow SQL Server authentication, but fast SAN, fast querying?

I am asking you after days of research but I think I don't have required skills to understand what is happening. I have a slow authentication on a SQL Server 2008R2, which leads to a timeout for the ...
0
votes
0answers
14 views

Combining 2queries: One filtered Users on Role, One Select users with only one specific role

First query: Selects All users with specific rid ( 3 or 4 or 19 or ...). SELECT u.uid AS uid, u.name AS name, fn.field_full_name_value AS field_full_name_value FROM users u LEFT OUTER ...
4
votes
3answers
113 views

Using the sysadmin role with EXECUTE AS

It is my understanding that I can use the EXECUTE AS OWNER clause as part of a procedure that I create to make the body of that procedure run as a different user. My goal is to execute a command that ...
0
votes
1answer
5 views

In DB2 LUW 9.5, is there any way to change the collating sequence without recreating the db?

The documentation says "no" :-) I'm looking for some heady old DBA to whisper dark secrets about cludgy hacks that I'll get fired for sure for using ;-)
5
votes
1answer
46 views

Huge differences of performance of MySQL in two servers

We have a MySQL server installed in two different machines, a testing server and a production server, both windows, which is used by a web application. The problem is that there are HUGE performance ...
2
votes
0answers
45 views

Finding rows with duplicate values

I have a one to many relationship between the Account table and a ScheduledPayment table. One account can have many payments but there should be a maximum of one payment per day. Although unlikely, ...
3
votes
1answer
32 views

Tail Log backup when doing a restore?

Typically when doing a restore of a DB from a production server to a non-production server I will use the WITH REPLACE option as when I forget I get an error about the tail log not being backed up. ...
3
votes
1answer
62 views

Does sp_indexoption cause index rebuilds?

I want to switch AllowRowLocks=ON on a number of indexes. Some of those indexes are on large tables, and I don't really want to rebuild or reorganize the index. It is not clear from the MSDN article ...
1
vote
1answer
30 views

Revoke write privileges vs setting database to readonly

I am planning to do a database migration to a new server. During the transition stage, I do not want Apache user to be able to write anything to the database. I have two options. Revoke write ...
0
votes
0answers
22 views

Replication overview

My boss wants me to elaborate a comprehensive report about synchronisation/replication. I know that replication can be done with the DBMS (we are using SQL Server 2012), but he wants something manual ...
1
vote
0answers
17 views

How to add mssql server in networks list?

After changing my PC name and workgroup, I am no longer able to connect to SQL Server. Currently in my servers list I have only Home & localhost. Anybody know how to add server to networks list? ...
1
vote
2answers
34 views

how to resolve mssqlsystemresource.mdf corruption?

Desperate for help, but fearing the worst here :( Something crashed SQLSERVER 2005 this afternoon approx 3pm. Since then I have been trying to get running again. Original log file messages told that ...
-1
votes
1answer
46 views

What makes yum difficult with RAID [on hold]

I as working with someone on a redhat server using RAID 10 with MySQL, and they mentioned it is hard to use yum when having a raid setup. Is this true? If so, what actually makes it 'difficult'?
-1
votes
1answer
35 views

View vs TableValued Function vs SubQuery

I have a scenario where i need to join with 3 tables to get the value for one field for second field join with 4 tables for third field join with 3 tables all above joins are inner and if data ...
1
vote
1answer
23 views

Joins in Update statement in sqlite

CREATE TABLE Table_1 ( Id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL , EmailId VARCHAR ) INSERT INTO Table_1 VALUES (1,'raj@gmail.com'); INSERT INTO Table_1 VALUES (3,'test@gmail.com'); ...

15 30 50 per page