Recent questions tagged SQl

0 votes

398 views

1 answer

sql - Composite Primary Keys : is it good or bad

I've been designing a database for an online store system. The question that I've come across by reading some ... 's the best practice then? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

334 views

1 answer

sql - MySQL - SELECT all columns WHERE one column is DISTINCT

I'm very sorry if the question seems too basic. I've surfed entire Internet and StackOverflow for a finished solution, ... one (for this link). See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

331 views

1 answer

sql - Discard millisecond part from timestamp

How can I discard/round the millisecond part, better if the second part is also removed from a timestamp w/o timezone ? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

365 views

1 answer

sql - SQlite: select into?

I'm not sure if I can use select into to import data from another table like this: select * into ... ? are there any other alternatives? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

389 views

1 answer

sql server - How do you determine what SQL Tables have an identity column programmatically

I want to create a list of columns in SQL Server 2005 that have identity columns and their corresponding ... like: TableName, ColumnName See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

747 views

1 answer

sql - The backend version is not supported to design database diagrams or tables

I'm trying to add a table to my newly created database through SQL Server Management Studio. However I get the error ... up: What's wrong here? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

431 views

1 answer

sql - Why can't I use an alias for an aggregate in a having clause?

My code is like shown below : select col1,count(col2) as col7 from --some join operation group by col1 ... am using SQL server express 2008 See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

458 views

1 answer

sql server - How to return a incremental group number per group in SQL

I would like create a data query in SQL to incrementally number groups of rows, grouped on a common ... like the Required result column. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

394 views

1 answer

sql server - TABLOCK vs TABLOCKX

What is the difference between TABLOCK and TABLOCKX? http://msdn.microsoft.com/en-us/library/ms187373.aspx states ... of sharing a lock? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

340 views

1 answer

sql - The transaction log for the database is full

I have a long running process that holds open a transaction for the full duration. I have no control over the ... . Thanks all for your input. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

431 views

1 answer

sql - Trim trailing spaces with PostgreSQL

I have a column eventDate which contains trailing spaces. I am trying to remove them with the PostgreSQL function ... should work. Any thoughts? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

425 views

1 answer

sql server - T-SQL XOR Operator

Is there an XOR operator or equivalent function in SQL Server (T-SQL)? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

333 views

1 answer

sql server - How to generate auto increment field in select query

For example I have a table with 2 columns, first_name and last_name with these values Ali Khani Elizabette Amini ... . Thanks for your help. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

593 views

1 answer

sql - Boolean vs tinyint(1) for boolean values in MySQL

What column type is best to use in a MySQL database for boolean values? I use boolean but my colleague uses tinyint(1). See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

400 views

1 answer

sql - How do I view grants on Redshift

I'd like to view grants on redshifts. I found this view for postgres: CREATE OR REPLACE VIEW view_all_grants AS ... check grants. (see here) See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

401 views

1 answer

sql - How to regex in a MySQL query

I have a simple task where I need to search a record starting with string characters and a single digit after ... innodb engine to be specific. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

552 views

1 answer

sql server - How to store directory / hierarchy / tree structure in the database?

How do i store a directory / hierarchy / tree structure in the database? Namely MSSQL Server. @olavk: Doesn't look ... This is the way to go! See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

445 views

1 answer

sql - Is there an auto increment in sqlite?

I am trying to create a table with an auto-incrementing primary key in Sqlite3. I am not sure if this is ... sqlite3 under cygwin in Windows 7. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

309 views

1 answer

sql - Grant privileges for a particular database in PostgreSQL

I'm moving from MySQL to PostgreSQL and have hit a wall with user privileges. I am used to assigning a user ... . My problem got more complex. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

420 views

1 answer

sql - ALTER table - adding AUTOINCREMENT in MySQL

I created a table in MySQL with on column itemID. After creating the table, now I want to change this ... itemid INT(10) UNSIGNED AUTOINCREMENT; See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

485 views

1 answer

sql - Postgresql tables exists, but getting "relation does not exist" when querying

I have a postgresql db with a number of tables. If I query: SELECT column_name FROM information_schema.columns WHERE ... to query the table. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

465 views

1 answer

sql - Rails 4 LIKE query - ActiveRecord adds quotes

I am trying to do a like query like so def self.search(search, page = 1 ) paginate :per_page => 5, : ... like '%my_search%' in the end query? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

321 views

1 answer

sql - Using a database table as a queue

I want to use a database table as a queue. I want to insert in it and take elements from it in the ... ? Should I use any special indexes? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

354 views

1 answer

sql - Select from one table matching criteria in another?

I'd really appreciate some help with an SQL query across tables. I realise this sort of thing is asked constantly ... way to organise the data? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

361 views

1 answer

sql - PostgreSQL Index on JSON

Using Postgres 9.4, I want to create an index on a json column that will be used when searching on ... but perhaps there is another option. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

477 views

1 answer

sql - Count cumulative total in Postgresql

I am using count and group by to get the number of subscribers registered each day: SELECT created_at, COUNT(email) ... 2011 200 07-04-2011 500 See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

281 views

1 answer

sql - Copy data from one column to other column (which is in a different table)

I want to copy data from one column to another column of other table. How can I do that? I tried ... CountryName" column of tblindiantime table. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

314 views

1 answer

sql - Generate random int value from 3 to 6

Is it possible in Microsoft SQL Server generate random int value from Min to Max (3-9 example, ... ) magic_number FROM information_schema.tables See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags