sql using regular expression regex_like

SQL
I'm having some issues where I can't seem the like regex to match 3 or more a's or e's in the name. Find all managers that manage employees with at l...
3 years ago

How to combine similar columns in SQL?

SQL
I have 3 possible delay categories for each gate. I am trying to find the Tot_Delay_Min at certain gates for each category, therefor I need to find a ...
3 years ago

Populate an array with column from a database

SQL
I need to populate an array with some datas taken from a database. My DB Table looks like this: Tablename ID | PROFILEID | PAGEID | VOTE -----...
3 years ago

Using a query in ALTER TABLE in CREATE TRIGGER

SQL
I'm trying to create a dynamic ALTER TABLE command but some of the command will be generated from a query. The problem is that I want to use this in a...
3 years ago

Proper way to join tables in mysql to have a single result

SQL
So I have a mysql database with three tables that has three table I am trying to retrieve rows of data from content based on a condition on data phpro...
3 years ago

Is it possible to specify condition in Count()?

SQL
Is it possible to specify a condition in Count()? I would like to count only the rows that have for example "Manager" value in Position column. Edit:...
3 years ago

Access denied for user 'root'@'localhost'

SQL
I am trying to fetch records from database. but I am facing this access denied issue. I tried the other solutions mentioned on Stack Overflow like gra...
3 years ago

Insert from another sister table with one extra field

SQL
I have two tables and need top copy one to another INSERT INTO tbl_new SELECT FROM tbl_old they both have 3 exact same columns, but tbl_new has 4th c...
3 years ago

Fetching via category_name from PHP to Android

SQL
I've been trying to fetch all the data in my table via category name, it works if I fetched it via category_id in the tbl_menu but I decided to change...
3 years ago

how do I query sql for a latest record date for each user

SQL
I have a table that is a collection entries as to when a user was logged on. username, date, value -------------------------- brad, 1/2/2010...
3 years ago

Proper foreign key structure with map tables

SQL
I've got a Kanji database I'm putting together, and it's got several map tables to show one-to-many relationships between characters and how they can ...
3 years ago

Improve MySQL Query

SQL
Apologies if I still use MySQL instead of MySQLI. Will be upgrading this soon but at the moment I need to find a way to solve this. I have a query wh...
3 years ago

the number of transactions in the database Oracle during the day ?

SQL
the number of transactions in the database (oracle 11 g) during the day ?
3 years ago

Mysql error in my syntax

SQL
Hey i have an error in my mysql syntax, and i dont know why i get it. I can't see an error in my code and i have checked the web for help... INSE...
3 years ago

Connecting variable string for WHERE clause

SQL
How do I connect the variable string for where clause in Firebird? I have two variables type of SMALLINT. These variables are incremented after one i...
3 years ago

Select everything from joined tables

SQL
I have two joined tables: SELECT table1.*, table2.* FROM table1 t1 INNER JOIN table2 t2 ON t1.id = t2.t1_id The question: In query results, id will...
3 years ago

PostgreSQL: Remove attribute from JSON column

SQL
I need to remove some attributes from a json type column. The Table: CREATE TABLE my_table( id VARCHAR(80), data json); INSERT INTO my_table (id, da...
3 years ago

MySQL - This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery

SQL
My query is: SELECT VID, thumb FROM video WHERE VID IN ( SELECT VID FROM video WHERE title LIKE "foobar" ...
3 years ago

Insert into temptable from store procedure having ouput variable

SQL
create table #TagsTable ([StandardDeviation] nvarchar, [AffectedPing] nvarchar, [AffectedPingPercentage] nvarchar, [BaselineDataPointsCoun...
3 years ago

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version etc

SQL
I have a simple table having id(autoincrement) and name and i am trying to do a very simple insert query if (connect != null) { quer...
3 years ago