tablename Questions
6
I was wondering if there is anyway to return the name of the table using a formula?
I was working on a way to break down a few thousand addresses into there perspective column of information. ie.....
3
Solved
I have installed mysql v5.5.17 in linux using yum, now i want default lowercase table names so i have added
set-variable = lower_case_table_names=1
in
/etc/my.cnf
but if i do that then i coul...
8
Is there a way to do what this code did in EF Core RC 2?
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
modelBuilder.Conventions.Remove<PluralizingTableNameConvention>...
Snubnosed asked 27/5, 2016 at 22:23
10
Solved
I am trying to execute this query:
declare @tablename varchar(50)
set @tablename = 'test'
select * from @tablename
This produces the following error:
Msg 1087, Level 16, State 1, Line 5
Must decl...
Meakem asked 15/5, 2010 at 1:7
4
I need the DB2 SQL query to find the table/tables from column name. I have the column name but don't have table name which this column belongs to.
4
Solved
I have a situation, I have a Access table named Gas Flow Rates that I want to add records. When I try to run my insert query for a similar table Common Station, I get the following error:
"error...
Geochronology asked 27/6, 2011 at 20:0
3
Solved
What is the safe way how to put table name as parameter into SQL query? You cannot put table name as parameter using PreparedStatement. Concatenating string to execute query with dynamic table name...
4
I've been playing with mysqlimport and I've run into the restriction where the filename has to be the same as the table name. Is there any way to work round this?
I can't rename the file as it is ...
Arty asked 24/3, 2010 at 14:41
1
Solved
I am new in PostgreSQL and I wonder if it's possible to use number from table tbc as part of the table name in left join 'pa' || number. So for example if number is 456887 I want left join with tab...
Dewees asked 16/7, 2014 at 8:18
1
Solved
I'm doing a query manager in Delphi using ADO, I need to know all fields that will be returned by a query, does no matter how complex and how much joins they will have. I want to call a function, t...
Mishnah asked 15/3, 2013 at 11:56
2
Solved
I want to loop through all my tables to count rows in each of them. The following query gets me an error:
DO $$
DECLARE
tables CURSOR FOR
SELECT tablename FROM pg_tables
WHERE tablename NOT LIK...
Eulogia asked 7/3, 2013 at 8:26
1
When I use postgresql, I found following code:
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from t");
String tableName = rs.getMetaData().getTableName(1);
S...
Cochin asked 12/2, 2012 at 16:40
1
Solved
I inherited a MS Access front-end that has linked tables to SQL Server. The linked table names in MS Access do not match the table names in SQL Server. How can I find out what SQL server tables are...
Janellajanelle asked 16/5, 2012 at 21:55
1
Solved
I have a case where getting the table name should be from a set variable like:
SET @ID_1 = (SELECT ID FROM `slider` LIMIT 0,1);
SET @Cat = (SELECT Category FROM `slider` LIMIT 0,1);
select * from...
2
Solved
I'm trying to create a table with a name based on the current year and month(2011-09), but MySQL doesn't seem to like this.
SET @yyyy_mm=Year(NOW())+'-'+Month(NOW());
CREATE TABLE `survey`.`@yyyy_...
1
I have a long script that I need to run on several different databases (all witht he same tables and field names).
What I would like to do is something like this:
1 SET @TARGET_DATABASE = 'beta'
...
1
© 2022 - 2024 — McMap. All rights reserved.