sql query problem

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Problem in passing IFS array to SQL Query

Hi, I have created a shell script that reads line from text file and insert into DB table. I have used IFS to separate the line text. Looks IFS is splitting text properly but while passing one of the values that has special characters in it to query, it is giving weird issue. Below is my...

2. Programming

Getting error in sql query

Hi All , I have tried many times am getting syntax error on 'UNION' can anybody tell me ... INSERT INTO table1 ( Type , num_items , num_letters , total_value ) (select type='1', num_items, num_letters=count(*), total_value=sum(letter_value) from table2 where num_items = 1

3. Shell Programming and Scripting

Run SQL thru shell script: how to get a new line when run sql query?

Hi, this's Pom. I'm quite a new one for shell script but I have to do sql on shell script to query some information from database. I found a concern to get a new line...When I run my script, it retrieves all data as wondering but it's shown in one line :( What should I do? I'm not sure that...

4. Shell Programming and Scripting

Problem in formatting output of SQL query in excel sheet in shell script

Hi Guys.. Need your help to format the output of my shell script. I am using spool command to take out put in csv file. below is my code. (for example) col USERNAME for a15 col EMAIL for a30 col FULL_NAME for a20 col LAST_LOGIN for a40 col DATE_CREATED for a40 SPOOL 120.csv...

5. Shell Programming and Scripting

problem in SQL query

I used the following code code select * from tablename where columnname Instead of printing the expected output it prints all the files in the present directory since there is a "*" in the code. Is there any way to overcome the problem? Thanks Ananth

6. Shell Programming and Scripting

How to use sql data file in unix csv file as input to an sql query from shell

Hi , I used the below script to get the sql data into csv file using unix scripting. I m getting the output into an output file but the output file is not displayed in a separe columns . #!/bin/ksh export FILE_PATH=/maav/home/xyz/abc/ rm $FILE_PATH/sample.csv sqlplus -s...

7. Shell Programming and Scripting

Problem in Passing sql query for a script

Unix prompt ========= echo "Enter the query" read q ========== User has entered : SELECT * FROM employee ===================== Now the problem starts.. echo $q Output: SELECT "all files names in the PWD" FROM employee ================================================ ...

8. Shell Programming and Scripting

Problem while storing sql query value in a variable

Hi, When i execute the below statement , the value is not getting stored in the variable. AnneeExercice=`sqlplus $LOGSQL/$PASSWORDSQL << FIN >> $GEMOLOG/gemo_reprev_reel_data_ventil_$filiale.trc SELECT bi09exercice FROM bi09_scenario WHERE bi09idfiliale=UPPER('de') AND ...

9. Shell Programming and Scripting

rsh and sql query

Hi ... I am doing a switch user and then rsh and then running a sql query . I am successfull in rsh and logging into the database , but my query doesnt run .. Here's the command : su - linus -c "rsh -l linus psmf ORACLE_SID=SMP;export ORACLE_SID;sqlplus...

10. Shell Programming and Scripting

& in SQL query

I have a script that looks for all jobs that contain a particular calendar. Some of the calendars have '&' in them and sql freaks out when it encounters that.. is there a way around this? I have tried: select job_name from job where run_calendar='1&15dom' select job_name from job...

LEARN ABOUT PHP

mysql_list_tables

MYSQL_LIST_TABLES(3)							 1						      MYSQL_LIST_TABLES(3)

mysql_list_tables - List tables in a MySQL database

SYNOPSIS

       Warning

	      This  function  was deprecated in PHP 4.3.0, and will be removed in the future, along with the entirety of the original MySQL exten-
	      sion. Instead, the MySQLi or PDO_MySQL extension should be used. See also MySQL: choosing an API guide  and  related  FAQ  for  more
	      information. Alternatives to this function include:

		     oSQL Query:
		       SHOW TABLES FROM sometable

       resource mysql_list_tables (string  $database, [resource  $link_identifier = NULL])

DESCRIPTION

	Retrieves a list of table names from a MySQL database.

	This  function is deprecated. It is preferable to use mysql_query(3) to issue an SQL SHOW TABLES [FROM db_name] [LIKE 'pattern'] statement
       instead.

	      o $database
		- The name of the database

	      o $
		link_identifier -The MySQL connection. If the link identifier is not specified,  the  last  link  opened  by  mysql_connect(3)	is
		assumed. If no such link is found, it will try to create one as if mysql_connect(3) was called with no arguments. If no connection
		is found or established, an E_WARNING level error is generated.

	A result pointer resource on success or FALSE on failure.

	Use the mysql_tablename(3) function to traverse this result pointer, or any function for result tables, such as mysql_fetch_array(3).

       +--------+-----------------------------------+
       |Version |				    |
       |	|				    |
       |	|	     Description	    |
       |	|				    |
       +--------+-----------------------------------+
       | 4.3.7	|				    |
       |	|				    |
       |	|  This function became deprecated. |
       |	|				    |
       +--------+-----------------------------------+
       Example #1

	      mysql_list_tables(3) alternative example

	      <?php
	      $dbname = 'mysql_dbname';

	      if (!mysql_connect('mysql_host', 'mysql_user', 'mysql_password')) {
		  echo 'Could not connect to mysql';
		  exit;
	      }

	      $sql = "SHOW TABLES FROM $dbname";
	      $result = mysql_query($sql);

	      if (!$result) {
		  echo "DB Error, could not list tables
";
		  echo 'MySQL Error: ' . mysql_error();
		  exit;
	      }

	      while ($row = mysql_fetch_row($result)) {
		  echo "Table: {$row[0]}
";
	      }

	      mysql_free_result($result);
	      ?>

       Note

	       For backward compatibility, the following deprecated alias may be used: mysql_listtables(3)

       mysql_list_dbs(3), mysql_tablename(3).

PHP Documentation Group 												      MYSQL_LIST_TABLES(3)

Shell Programming and Scripting