Stack Overflow
Stack Overflow

Questions tagged [tablename]

143 questions
0
votes
1 answer

SQL how to update table based name tablename from other table column

I need to update a value in several tables, when migrating a production database to a test environment. The name of the tables can be found in another table. How can I do this? I mean: for each value$ in select replace(tablename,' ','') from…
Gerrit
  • 3
  • 2
0
votes
1 answer

mysql query select * values from 2 tables and return the name of the table where result exists?

I am trying to put together a MySQL query which will search 2 tables, table1 and table2 and select all results which are less than 30 days old in either table. my tables: table1 id | user_id | name | age | date …
James Daley
  • 259
  • 2
  • 8
  • 20
0
votes
1 answer

Check if the stored procedures contain correct table names

I got MySQL database from my client and it has lot of stored procedures. The problem is that some of the stored procedures contain wrong table names (table names that do not exist). So is there a mechanism I can find those wrong table names in…
hotcoder
  • 3,176
  • 10
  • 58
  • 96
0
votes
1 answer

Laravel SQL request too big

My objective Is to create a simple DB navigator for lambda users. For this, i have a side-bar which contains all DB table_name And at the center of the page, i want the data. Here are my table names…
Gui O
  • 363
  • 4
  • 8
  • 22
0
votes
0 answers

Extract table name from field in an open ADO recordset (SQL SERVER / VBA)

How can I extract the table name from a field in an open ADO recordset? I can use the .source property to return the select statement, but if I want to know which table a field is associated with, how would I do that? i.e. if .source returns a…
CBRF23
  • 1,340
  • 1
  • 16
  • 44
0
votes
3 answers

SQL statement to find a table by its name

We have a lot of databases and a lot of tables within those databases. I'm searching for a specific one. I know the name of the table but it wouldn't be easy to search through every database manually. What SQL statement could I used to find the…
navig8tr
  • 1,724
  • 8
  • 31
  • 69
0
votes
1 answer

CRM_FilteredTableName vs FilteredTableName VS Tablename in report SQL query

I understand that CRM_FilteredTableName will indicate prefiltering and the user will be prompted to enter the filter before running the report. But what if I only use "FilteredTableName" , what difference does this make ? And how is it different…
user3340627
  • 3,023
  • 6
  • 35
  • 80
0
votes
1 answer

Dynamic MySQL table name within a class

class Patient { protected static $table_name = "siteA"; public $id; public $first_dx; public $confidence; public $second_dx; public $path_dx; } I have simply shown the class attributes here. I have CRUD methods within the class…
GhostRider
  • 2,109
  • 7
  • 35
  • 53
0
votes
1 answer

How to show the tablenames with foreign key = myId

I am trying to figure out where my primary keys of a table with translation per language resides as a foreign key. This is what i already have ... SELECT * FROM ( SELECT TM.seqtrans, T.trans, CASE T.seqlang WHEN 1 THEN 'NL' …
Rockatansky
  • 1
0
votes
2 answers

Support of Escaping query identifiers

I am using Sequelize 2.0.0 in my node project and my dialect is mysql. For now, i am preferring to use raw SQL queries instead of using Sequelize ORM methods. I am not able to find any example or documentation regarding "How to use Escaping query…
Ashwin Hegde
  • 1,733
  • 4
  • 19
  • 49
0
votes
3 answers

Database issue for everyone (QUERY)

I want to create a query that generates the table name. I tried something like this : SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='mytableName' but it return an empty query. So , any ideas ? Thx
Attila Naghi
  • 2,535
  • 6
  • 37
  • 59
0
votes
1 answer

using a table name by php in a submit form

I want the user choose a table name in mysql database and then I can add a data by textbox of a form inside the field. I used PHP $_POST[ ] to send table name to the adding form. but in the adding form; when I submit the add button; the table name…
Truth
  • 1
0
votes
4 answers

How to get the name of the table with the biggest number of rows in database

I need to get the name of the table with the biggest number of rows, I can find the biggest number of rows with function count and than function max, but I don't know how to see from which table is that maximum, can anyone help?
zeka
  • 31
  • 9
0
votes
1 answer

Set ResultSetMetaDataOptions for a connection object in C3P0 connection pool datasource for Oracle db

Has anybody been successful in retrieving the tablename from ResultSetMetaData via the getTableName() for Oracle database ? All the online materials suggest to set ResultSetMetaDataOptions to "1", but it does not work.
Krithika Vittal
  • 1,477
  • 2
  • 16
  • 32
0
votes
1 answer

select table name in query

I am in need to pulling a table's name as a value in a column. What makes it difficult is that the query is setup as a loop - the query retrieves data from multiple tables, but without the table name/ID, I cannot tell from which table the data was…
Michelle Alston
  • 7
  • 2
1 2 3
…
9 10