sql Archives - Page 3 of 71

Programming, sql

IT Nursery

How to do a case sensitive search in WHERE clause (I’m using SQL Server)?

I want to do a case sensitive search in my SQL query. But by default, SQL Server does not consider the case of ...

June 2, 2022
0 Comments

WordPress

IT Nursery

Edit post_content on posts with Featured Image

Great forum! I’m a total newbie to SQL but a quick learner. I have a large database of content, >140k posts. Some posts ...

June 2, 2022
0 Comments

Programming, sql

IT Nursery

Conversion failed when converting date and/or time from character string while inserting datetime

I was trying to create a table as follows, create table table1(date1 datetime,date2 datetime); First I tried inserting values as below, insert into ...

June 2, 2022
0 Comments

Programming, sql

IT Nursery

How big is too big for a PostgreSQL table?

I’m working on the design for a RoR project for my company, and our development team has already run into a bit of ...

June 2, 2022
0 Comments

Programming, sql

IT Nursery

How to alter a column’s data type in a PostgreSQL table?

Entering the following command into a PostgreSQL interactive terminal results in an error: ALTER TABLE tbl_name ALTER COLUMN col_name varchar (11); What is ...

June 2, 2022
0 Comments

MySQL, Programming

IT Nursery

What does it mean by select 1 from table?

I have seen many queries with something as follows. Select 1 From table What does this 1 mean, how will it be executed ...

June 2, 2022
0 Comments

PHP, Programming

IT Nursery

How to insert multiple rows from a single query using eloquent/fluent

I have the following query: $query = UserSubject::where('user_id', Auth::id())->select('subject_id')->get(); and as expected I get the following result:...

June 2, 2022
0 Comments

Programming, sql

IT Nursery

Copy data into another table

How to copy/append data from one table into another table with same schema in SQL Server? Edit: let’s say there is a query ...

June 2, 2022
0 Comments

Programming, sql

IT Nursery

What is the purpose of Order By 1 in SQL select statement?

I’m reading through some old code at work, and have noticed that there are several views with an order by 1 clause. What ...

June 2, 2022
0 Comments

Programming, sql

IT Nursery

Delete sql rows where IDs do not have a match from another table

I’m trying to delete orphan entries in a mysql table. I have 2 tables like this: Table files: | id | .... ------------ ...

June 1, 2022
0 Comments