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 stackoverflow.com
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 stackoverflow.com
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 stackoverflow.com
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 stackoverflow.com
1 answer

SQL 2008 R2 ERROR ON DATABASE ENGINE

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 stackoverflow.com
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 stackoverflow.com
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 stackoverflow.com
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 stackoverflow.com
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 stackoverflow.com
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 stackoverflow.com
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 stackoverflow.com
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 https://cloud.google.com/sql/docs/admin-tools 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