My Filter
   28 tags on

My Filter

  • All Sites
  • Arqade

1 answer

relation schema for dealer locator mysql and php

I have a project where there is a dealer locator which is supposed to locate the dealers in the area. The dealers supply multiple brands of different items(example: cement bricks etc.). These items ...

1 answer

SQLData with spring not working for Oracle SQL Procedure with complex oracle datatype

In Oracle I have types like: create or replace TYPE "LOCATION_RECORD" AS OBJECT ( PSTL_ADR ADR_TABLE ,GEO_CDE VARCHAR2(36) ,PRMRY_FLG VARCHAR2(5) ); create or replace ...

4 answers

Are Microsoft SQL Server “Express” editions free to develop on?

Am I able to develop a software for free on Microsoft SQL Server 2005/2008 Express edition databases?

2 answers

Accessing SQL Server Instance through NAT

I'm attempting to access a SQL Server which is exposed through an IP NAT mapping. All the ports are open. I don't know the details of the NAT, if it's relevant, since that's somewhere else in the ...

2 answers | 4 mins ago by bassburner on Stack Overflow
1 answer

How to reference groups of records in relational databases

Suppose we have the following table structures: Humans | HumanID | FirstName | LastName | Gender | |---------+-----------+----------+--------| | 1 | Issac | Newton | M | | 2 ...

2 answers

Microsoft Hex dates

I have the following from a Microsoft SQL Server database for date/time value: 0x00009CEF00A25634 I found this post: Help me translate long value, expressed in hex, back in to a date/time Which ...

4 answers

Does read-only access to the database prevent sql injection?

I have a web api that connects to my SQL Server using a read-only connection and want to allow tech savvy users of my api to enter an SQL where clause on the querystring. I basically just want to tack ...

3 answers

How to select SQL results grouped by weeks

I want to select data from following table group by weeks Date Product Name Sale +----------+--------------+-----+ 14-05-11 a 2 14-05-11 b 4 17-05-11 ...

1 answer

MATLAB simple code didn't work - connect matlab to Mysql Using a ODBC Driver

i installed mysql server 5.6 , and Mysql connector ODBC , and tested in matlab with database explorer and worked fine as you can see in the image : how ever when i tried to connect it by a script ...

1 answers | 16 mins ago by Sara Aawati on Stack Overflow
2 answers

Can't connect to database with mysql_* API

I am trying to connect to my database, but I'm getting an error. After all the suggestions this is my php code after editing: if(isset($_POST["submit"])) { ...

3 answers

MySQL - Object not null?

I am trying to check if a player is already is in the database with this code: Statement sql = mySql.getConnection().createStatement(); ResultSet check = sql.executeQuery("SELECT * FROM `playerinfo` ...

3 answers | 24 mins ago by DaanSander on Stack Overflow
1 answer

Как посчитать уникальные значения за период 30 день на каждую дату

Есть таблица по входам в онлайн сервис. Как посчитать уникальных клиентов за диапазон 30 дней на каждый день исторически? Мой пример запроса не отрабатывает, пишет "предел вызовов на использование ...

1 answer

PHP, SQL, Apostrophe, text input

for some reason when I replace an apostrophe with a double apostrophe it will work for a textview but not a regular text input. (I'm using phpFusion). This is my HTML code <tr class='" . ...

1 answers | 27 mins ago by wha1e on Stack Overflow
1 answer


Database 'msdb' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information. (Microsoft SQL Server, Error: 926)

1 answer

Cannot connect to SQL Server from Management Studio (both 2012)

I installed SQL Server 2012 Express. It seems to be running fine. My SQL Server Configuration Manager looks like this: From what I understand it means that my instance is called MSSQLSERVER. ...

2 answers

MYSQL: View statement produces incorrect SUM totals

I have 3 tables. A table for product prices, invoiced products, and ordered products. I am trying to create a view that joins these. I want to output the product prices with a total of invoiced ...

2 answers | 35 mins ago by Kuriso on Stack Overflow
1 answer

Very large table JOIN with GROUP BY

I need to combine information from a 27 millions lines table with a 7 millions lines table and do some filtering. CREATE TABLE event_participation ( place_id int(4), ...

0 answers

Entity Framework map foreign key to parts of composite key

My database schema stores details about a person in multiple different tables some of them are culture specific some are not. Each table uses a GUID as PK and so far it works just fine. Now I want ...

1 answer

Using a SQL function to pad strings with spaces

Is it inefficient to use a user defined function to pad spaces? I have a padding function that I'd more intuitive than using the built in REPLICATE function but I am afraid it is introducing ...

1 answers | 48 mins ago by a b on Stack Overflow
2 answers

How do I remove unknown characters in a string?

I would like to delete parts of an string. We have a Table: Locations mk-MK=New York; sq-AL=Nej York; en-US=New York mk-MK=London; sq-AL=London; en-US=London mk-MK=Paris; sq-AL=Paris; en-US=Paris ...

2 answers | 52 mins ago by Arif on Stack Overflow
1 answer

PHP: Retrieve multiple rows from a MySQL database

I got a MySQL database with reviews and I am trying to retrieve and display them all using this code: $retrieve_reviews = "SELECT * FROM reviews WHERE PRODUCT_ID = $pid"; $do_retrieve_reviews = ...

1 answers | 54 mins ago by puk789 on Stack Overflow
0 answers

net.ucanaccess.jdbc.UcanaccessSQLException: invalid authorization specification - not found:

i am trying to fill a table from a database using ucanacces but it gives me the following error and i don't understand why, upon googling this error most people mention something about a username and ...

1 answer

Where clause and how it it is bound to others

I'll start off with an apology because i really do not know how to give a title to this question. If any editor can think of a better title, please go ahead and edit this. Problem Description: I ...

1 answers | 58 mins ago by Ji_in_coding on Stack Overflow
3 answers

Simple SQL statement to retrieve orders on a specific date

I'm having trouble crafting a simple SQL query that retrieves the number of orders placed on 7/15/1998, which includes the date in the result. The label number of orders should be "OrderCount". This ...

3 answers | 59 mins ago by matters1776 on Stack Overflow
1 answer

Understanding 1NF, 2NF, 3NF, and BCNF

I think I get it...but I'm not 100% sure of where the line is. Given table: I have created what I think is 1NF by splitting address and name: And then 2NF by splitting the partial dependence of ...

13 answers

Sort by minimum value of two columns

I use SQL Server 2008 R2. I need to sort a table by the minimal value of two columns. The table looks like this: ID: integer; Date1: datetime; Date2: datetime. I want my data to be sorted by ...

2 answers

Autoincrement does not increment sequentally if last row was deleted

I have a table which contains an auto incremented primary key id. If I delete the last row (highest id, for example id = 22) and insert a new row, the new id starts at 23. What should I do to start it ...

2 answers | 1 hour ago by Sultan on Stack Overflow
1 answer

SQL selecting multiple MAX and MIN - Python

I have a program which stores scores for students within a database. I want to select the max score for each student. At the moment, only one student with the highest score out of all students is ...

0 answers

How to use MySQL Workbench to set up connection and connect Google cloud sql

enter image description hereI follow this tutorial but it is very abstract. I am unable to set up a new connection in MYSQL workbench correctly. It ...

2 answers

How much does decoupling tables in MySQL improve performance?

I am designing the database to store some blog posts in MySQL. I recently ran across this answer which advises that when you have: A table that will be queried regularly (e.g. a listing of blog ...

15 30 50 per page
1 2 3