06-11-2009
Hi,
I am trying to fire a query in MyLSQ 5.1.34 like
mysql> select table_schema from INFORMATION_SCHEMA.TABLES where table_name='table11';
Empty set (0.08 sec)
where table11 is not present in the INFORMATION_SCHEMA.TABLES.
I am expecting the error as table not found but as it is returning the empty set.
I tried to fire a query using mysql_real_query() API. How would I get the correct result as table not found?
Or any other ways to achieve same?
4 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
I recently installed mysql-standard-5.0.21-solaris9-sparc-64bit.pkg on a Solaris 9 machine (SunOS 5.9 Generic_118558-19 sun4u sparc SUNW,Ultra-250). The package installation went very smooth, however, starting mysql is a different story. I get the message below everytime I try to start mysql:
#... (2 Replies)
Discussion started by: xnightcrawl
2 Replies
2. Programming
Hey, for the purpose of a research project I need to know if a specific type of parallel processing is being utilized by any user-run programs. Is there a way to detect whether a program either returns a value to another program at the end of execution, or just utilizes any form of parallel... (4 Replies)
Discussion started by: azar.zorn
4 Replies
3. UNIX and Linux Applications
After doing a yum install mysql mysql-server on Fedora 14 I wasn't able to fully install the packages correctly. It installed MySQL 5.1. I was getting the following error when running the:
mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)... (3 Replies)
Discussion started by: jastanle84
3 Replies
4. Shell Programming and Scripting
#cat file1.log
10.51.61.38;Thu Nov 1 08:06:12 2012;Logout
10.51.62.21;Thu Nov 1 08:06:16 2012;Login
output result:
10.51.61.38;2012-11-01 08:06:12;Logout
10.51.62.21;2012-11-01 08:06:16;Login
how to write script using awk, need help (1 Reply)
Discussion started by: pillawa
1 Replies
LEARN ABOUT DEBIAN
grass-mesql
grass-mesql(1grass) Grass User's Manual grass-mesql(1grass)
NAME
grass-mesql - MySQL embedded driver
MySQL embedded driver MySQL embedded driver in GRASS MySQL database driver in GRASS enables GRASS to store vector attributes in MySQL
embedded database without necessity to run MySQL server.
Driver and database name
GRASS modules require 2 parameters to connect to a database. Those parameters are 'driver' and 'database'. For MySQL embedded driver the
parameter 'driver' should be set to value 'mesql'. The parameter 'database' is a full path to the directory where database tables are
stored. The best place is a directory in the mapset. The directory must be created before use of the driver. In the name of database it is
possible to use 3 variables:
$GISDBASE - path to current GISBASE
$LOCATION_NAME - name of current location
$MAPSET - name of current mapset
Examples of connection parameters:
db.connect driver=mesql database='$GISDBASE/$LOCATION_NAME/$MAPSET/mysql'
db.connect driver=mesql database=/home/user1/db
Data types, indexes
For more informations about supported data types and indexes see the documentation for MySQL (mysql) driver
Database type
Because database closing was found very slow if InnoDB was used, the InnoDB storage is disabled by default (hardcoded '--skip-innodb'
server option).
Note
The embedded server is started with hardcoded '--bootstrap' option to avoid warning about missing mysql.time_zone_leap_second table. This
can be fixed in future.
SEE ALSO
db.connect, SQL support in GRASS GIS
Credits
Development of the driver was sponsored by Faunalia (Italy) as part of a project for ATAC.
AUTHOR
Radim Blazek
Last changed: $Date: 2011-02-07 18:59:50 +0100 (Mon, 07 Feb 2011) $
Help Index
GRASS 6.4.2 grass-mesql(1grass)