How to get a S-lock in a Transaction

Hi: I tried to get a S-lock using following SQL: 1. start transaction; SELECT * FROM test.t1 where id=1; But I found this way does not work. I changed it as following: 2. start transaction; SELECT * FROM test.t1 where id=1 lock in share mode; I am wondering why the fi

optimize mysql geometric query

hi, i have attached my geometric query which is very slow. how to optimize this query regards shann ___ Hot new product - Spider Networks introduces stunning online ePortfolio solution for students and teachers http://www.spider-n

tune a geometric query

hi, we are working on automotive traking solutions and insert our location records into the mysql database v 4.1.20. If we want search for a particular record, its taking too long time and mysql is identifying the queries as slow queries. I have attached the queries. How to optimize the attac

MyISAM and InnoDB co-existance

hi, I need to have 2 DB in our development/production environment which require both InnoDB and MyISAM engines. This is bacasue, DB1 contains spatial/geom data which has to be on MyISAM engine and DB2 which needs transactional support has to be InnoDB. Now how to achieve this co-existance of

Re: MyISAM and InnoDB co-existance

hi, thnaks for the speedy reply. I already have both the DBs in my server. is there any way/method that the DB2 which needs transaction support can be converted from myisam to innodb format without any hitch regards shann ___ Which f

query

hello i hv one query as explained below : Table FIRST contains This is What is this how whom color white Table SECOND contains WHOM THIS IS WHAT WHITE AND BLACK i want the result as This is what is this what whom white WHITE AND BLACK i want a query which searches both table for exact matc

Re: can we convert shape files

yes. on linux it is possible to convert shp files you have to use libmygis avaliable at http://jcole.us/software/libmygis/ shann ___ Halloween Humour: Why did Dracula divorce his wife after 800 years? postmaster.co.uk http://www.

Optimization suggestions

I have following table structure, I have to use merge storage engine. Please have a look, and provide feedback if theres some thing wrong or if there's space for optimization. /*Table structure for table `messages2009` */ CREATE TABLE `messages2009` ( `id` varchar(36) NOT NULL default '', `

delete a data from 3 tables

hi,   I would like to know how to delete a data from 3 table which is interconnected with each other by foreign key. i.e 1st table is connected with 2nd table by foreign key and 2nd table is connected with 3rd table with foreign key. please help to solve this problem.   Thanks chandra  

delete a data from 3 tables

hi all   I created 3 tables namely authen_tbl,profile_tbl,astro_tbl,in which column name mail  as primary key in authen_tbl table , query:  pid int primary key auto_increment,  foreign key (mail) references authen_tbl(mail) given in astro_tbl table and query foreign key(pid) references profile_

split a table into two

Hi,   How to split the datas in a table into two table. Please help me.

MySQL server has gone away

Hi,I am using Moodle which itself uses SQL for the database. Problem is that, when I run the email plugin and execute the command, the refresh time of the page becomes high (in the order of 3-5 minutes) and at the end, I see this message Debug info: MySQL server has gone away SELECT id, sid, sta

Re: MySQL server has gone away

So it likely has died, or perhaps is mis-configured. On April 3, 2017 7:07:25 AM EDT, Mahmood N wrote: Hi,I am using Moodle which itself uses SQL for the database. Problem is that, when I run the email plugin and execute the command, the refresh time of the page becomes high (in the order o

Re: MySQL server has gone away

When I click on the submit button in Moodle and it is waiting for refresh, I execute the mysql command but the output is not meaningful mahmood@ce:/var/www/html/courses$ mysql -u moodle -p Enter password: Welcome to the MySQL monitor.  Commands end with ; or \g. Your MySQL connection id is 30912

Re: MySQL server has gone away

Dear all, Currently max_allowed_packet is set to 8M. That test email is simply a test email containing some basic information in the message body to assure that the email system works. Thing that can help me is to put mysql in the debug mode in one terminal and at the same time, submit a test em

Re: MySQL server has gone away

The my.conf file contains log_error=/var/log/mysql/error.log slow_query_log=1 slow_query_log_file=/var/log/mysql/error_slow.log max_connections=200 max_user_connections=30 wait_timeout=30 interactive_timeout=50 long_query_time=5 character-set-client-handshake = FALSE thread_concurrency = 8 query_ca

Re: MySQL server has gone away

>given that a reasonable server should be able to >handle hunredts to thousands of requests per second anything above 1 >second is a alert sign Excuse me, do you mean higher values are better? I didn't understand. I said in my posts that when I submit the email test, the refresh time for that pa

Re: MySQL server has gone away

>since when is phpinfo() - the *real* active configuration be it changed >by some config snippet, vhost-configuration or even ini_set() - the same >than a random file in /etc? Sorry I totally didn't understand that sentence... Regards, Mahmood

Re: MySQL server has gone away

So I set long_query_time=5 and restarted the service. Test the email page again. Still the logs are empty.  Regards, Mahmood

Re: MySQL server has gone away

Dear reindl, I tested with both 5 and 1 and see the log files are empty. I am really confused about that error and it is taking more than 2 weeks about that! Regards, Mahmood

Re: MySQL server has gone away

Good news! I changed wait_timeout=30 to wait_timeout=600 and now the error disappears... I don't know if long_query_time=1 has effect. Regards, Mahmood On Monday, April 3, 2017 10:32 PM, Mahmood N wrote: Dear reindl, I tested with both 5 and 1 and see the log files are empty.

Re: MySQL server has gone away

>well, who did set it that low? ِDon't know. Maybe the previous admin hadn't used mysql for sending emails!! Anyway, thanks.  Regards, Mahmood On Monday, April 3, 2017 11:37 PM, Reindl Harald wrote: Am 03.04.2017 um 20:41 schrieb Mahmood N: > Good news! > > I c

Problem with the stopword file in 4.1.9-Max

Hi I set ft_min_len_word = 3 and ft_stopword_file = /etc/stopword.cnf in my.cnf file under the [mysqld] section I then restart the server and rebuild the indexes with REPAIR TABLE ... QUICK The ft_min_len_word=3 seems to work: I get the expected results when quering for 3-letter words Unfortuna

regarding cron

hi i have a prgrm which dumps the data extracted from the txt file to database. i want to run it using cron daily.i m using mysql as backend. when i run this program using my shell script it will run and insert data into the database. but when i give the same in cron it will not work ? what ma

mysqlinstall-error

hello all i installed red hat linux 9 in my home s/m and i tried to install mysql mysql-standard-4.1.10a-pc-linux-gnu-i686.tar.gz i have followed the steps for installation. the installation dir is /usr/local/mysql installation will go smoothly. but when i try to start, it stars and ends sud

write a spatial queary

hi, i have created / imported a table to mysql thru mysqlgisimport libraries and it has created a table with the following field / table structure Field name Type Allow nulls? Key Default value Extras id int(10) unsigned No Primary NULL auto_increment NAME varchar(100) No N

unable to start mysqld_multi

hi as per the online manual, i have configured mysql and able to run the server as mysqld_safe. but if i want to run mysqld_multi with the following configuration it doesnt work... the config file is like [mysqld_multi] mysqld = /usr/local/mysql/bin/mysqld_safe mysqladmin = /usr/local/mysql/

ERROR 1006: Can't create database 'X'. (errno: 13)

Hello I am having difficulties: I am working on Mac OSX 10.2.8 with mysql 4. I needed to change the data directory of MySQL from its original place (where the application have to be and not the databases because there is not enought room) to an other volume of my computer. I made a symlink from

fulltext searching

How fulltext is working!!? I have the following table with just one record! And when I do a select statement, mysql returns no hits!!! Would you explain to me what is wrong?? Tanks Cheers! Adam CREATE TABLE `mytest` ( `id` int(11) NOT NULL default '0', `sub` text, PRIMARY KEY (`id`

writing subquries in 4.0.18 version

where id IN (select id from table as T2 where one = 4 ); this syntax will not work.how to go ahead or which version documentation i can refer? N. Kavithashree === -- MySQL General Mailing List

Query--SelectionFromSameTable

which have flower entries for the same date , same regno and same codeno. 3) To retrieve records which doesnt hv a flower entry for the same date as that of perfume N. Kavithashree === -- MySQL

how to select last records

select from particular row no to othereg. row 10 to row 30 ? like this? N. Kavithashree === -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

selection

' and code='US'; it works select * from table where code='NP'; it works; why is it so bcoz of the Space between 2 words, the problem arises ? How to retrieve such fields then by giving specific value? can anybody help me

copy2diffdatabase

hello, i hv a database ONE with some 10 tables; i want to have a backup so how can i copy these tales to another database in the same server and also to any other server? N. Kavithashree

DBI->connect does not work in crontab but works interactively

hello, i have a shell script with 6 programs. if i run it directly as : sh first.sh all progrms with get executd and everything works fine. but if i give this script in crontab using 0 10 * * * /two/three/name.sh Only progs without database connection will get executed . but database tables

distinctSelection(veryUrgent)

hello, i m using mysql 4.0.18-standard version it is not accepting subqurries. problem is: i have 2 tables: First(id,Flower,Color); => color is char(2); Second(Shop,Date,Flower,Color); first table will contain only unique flowers , and colors, id is autoincrement. second tab

manyaccesses

hello, if a progm read difft tables for some 10 times for one run each day..how will be the load on mysql server. usually how many table accesses per run will be there if a company is maintaining an export business and daily read and write will be there on tables.

redirectingerror

hello, the questn may be simple.but i m still in learning stage so please dont get angry. thank you how to redirect every single error cmg in program with database connection to other place than standard error log. my error log is growing so fast so want to avoid error log for any type of erro

free graphing tool for perl and mysql

hello, thank you for info. but i want one graphics tool which is free. i m using perl and mysql. i am also searching for the graphics tool which i can use for the data in mysql table or the output by my perl program. if anyoneknow abt this please do reply ===

backup of database

hello, how to take a backup of database? i have a database with name1 now i want to move all the tables into another database? how to do? kavi -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

groupbyorderby

hello, can we give the same field name in group by and order by ? Eg. select count(*) from table group by filedname1 orderby filedname1 desc; = kavi -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

orderbymonths

hello, is there any way so that months r ordered as that of calender year. means . i have a month field of 3 chars. like Jan, Feb, Mar etc when i select distinct months , the result will be displayed in the calender year month order. but if i use order by mon then this order jan,feb,mar will g

Indian Languages Support

Hi All, Could any one tell me how to get the Indian Languages Support in MySQL??? Regards, N.Velmani - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the

Re: Indian Languages Support

9 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: "N-Velmani" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, January 22, 2003 7:38 AM Subject: Indian Languages Support > Hi All, > > Could any one tell me how to get the > In

Column present in diffrent tables

Dear Helpers, I want to check one column name is present in how many table in a databse , and name of those tables. does mysql supports this function ? Ex : Tables 1> Item master columns are ItemID, ItemName 2> Item details

Datentypen

Hallo Liste, als MySql Einsteiger hätte ich gerne eine Liste der Datentypen mit Beschreibung. Leider kann ich diese nicht in der Doku finden. Schon mal vielen Dank im vorraus. Ingo Döring - Before posting, please check: http:

Hoe to install client

Hello how to install mysql client only to connect server in windowsNt and Linux right now i'am working in server please mail to [EMAIL PROTECTED] _ Join the world’s largest e-mail service with MSN Hotmail. http://www.hotmail.com

Replication zwischen MYSQL und MS Access 97(2000)

Hallo Gibt es eine Möglichkeit meine vorhandene Access DB mit einer MYSQL DB zu syncronisieren. Das möglichst automatisch oder per Zeitauftrag. Beim aktualisieren zwischen 2 Access Replikaten kommt ein Konflict Manager zum tragen. Gibt’s ähnliches zwischen MYSQL und Access auch? Mit freundliche

java.sql.SQLException: Lost connection to server during query the error is here

hello we are running web application using apache as web server and mysql as databse. after running server for 6- 8 hr it will give the following error java.sql.SQLException: Lost connection to server during query the error is here if we restart apache server it will works i want to know wh

Re: adding columns to my database

and if that won't work you dont have alter privileges for your table. Cheers, Nikke > Från: "Billy Passauer" <[EMAIL PROTECTED]> > Datum: Thu, 12 Apr 2001 15:16:19 -0400 > Till: "Dean MacIsaac Jr." <[EMAIL PROTECTED]> > Kopia: <[EMAIL PROTECTED]> > Ämne: RE: adding columns to my database > > A

Can we store Japaneese characters in MySql Database

Hello, Is it possible to store the Japaneese character set in MySql Database? Thanks Regards Narayanan. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (t

Re: forwarded message from Brian Kaney

One of the buggy ones is Internet Explorer 5.x for Mac. Nikke > The problem is a buggy browser that decides to submit http:// or some other > non-empty garbage for a referrer. manual.php gives absolute URL for the > search results to bounce you back to the mirror if you search from the > mirror.

Connecting to MySQL Community Edition from Informatica Powercenter 9.5.1 running on AIX

Is it possible to MySQL Community Edition (as target) from Informatica Powercenter 9.5.1 running on AIX? If so, what is ODBC driver should we use?

Re: MySQL Connector/ODBC 5.2.6 has been released

no binaries for AIX? -- saqib http://hivemined.net On Wed, Oct 9, 2013 at 3:02 PM, Kent Boortz wrote: > > Dear MySQL users, > > MySQL Connector/ODBC 5.2.6, a new version of the ODBC driver for the > MySQL database management system, has been released. > > The available downloads include bo

Re: Optimises LEFT JOIN

Hello Mathias! I know what is the difference between LEFT and INNER JOIN. I need the NULL records too. mysql> select * from a left join b on a.id=b.id; +--+-+--+-+ | id | txt | id | txt | +--+-+--+-+ |1 | a test1 |1 | b test1

Regd Sub Queries

hello every one, i am in the process of converting my database from access to mysql ... now tat i have started working with mysql i have realized that my subqueries wont work here ... i read the article on how to handle some of the simple subqueries with joins ... my subquery is as follow and i d

Regd Sub Queries

Could you please tell me more about the pass through queries. i dont have an idea abt it sandeep -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Can't connect to MySQL server on 'localhost' (10061)

? Executing telnet to the PC won't work (probably need the a telnet server). When I move to the shared directory on the PC and try to execute mysql, I get the error. Thanks for an assistance. N. Chris Frost

Can MySQL 4.0.14 store HTML? Among other things....

Hey. I'm New (as you probably can tell), and I was wondering if MySQL 4.0.14 can store HTML, PHP, JavaScript and/or Flash. Can it? I'm assuming it would be stored as a string, and if outputted by PHP, would it output as HTML? (Or JavaScript, PHP, or Flash) Thanks! --Machiste&#x

Socket Error While Starting MySQL

Hi All, I am facing some problems with installation of MySQL on Mac. I have installed MySQL on mac 10.3.5. but now whenever I try to run and start MySQL, it gives me following error ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) I went to the directo

INSERT using Unicode strings

ly how the characters are specified? Thanks! Lisa N. Michaud, Assistant Professor of Computer Science Department of Mathematics and Computer Science, Wheaton College [EMAIL PROTECTED] http://cs.wheatoncollege.edu/lmichaud -- MySQL General Mailing List For list archives: http://lists.mysql.co

Unicode help

command in SQL that uses them. THANKS! Lisa N. Michaud, Assistant Professor of Computer Science Department of Mathematics and Computer Science, Wheaton College [EMAIL PROTECTED] http://cs.wheatoncollege.edu/lmichaud -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Regd Updating my Database schemas

the problem that i am likely to face is the following. We have a database in our developement server . we keep making changes to the db very often like adding few feilds , deleting etc ... now whenever i make the change in the developement server . i just do the changes in the productions serv

Basis for queries in MySQL

I am a grad student attempting to complete an assignment to research a DBMS engine. Is the SQL implemented by MySQL based on relational algebra or relational calculus? And if it's relational calculus (which I suspect it is based on an archive search), is it tuple or domain calculus? Thank you fo

Embedded MySQL

Hi, Since libmysqld don't use sockets or TCP/IP, what's the mechanism it uses when client and server communicate with each other? Thanks for reply in advance. Regards. -- ___ Get your free email from http://mymail.mailasia.com Powered by Outblaze -

Embedded MySQL Server

Hi, Since libmysqld does not use sockets or TCP/IP, what's the mechanism it uses when the client and server communicate with each other? I mean how embedded MySQL Server works as a server. Thanks for reply in advance. Regards. -- ___ Get your free e

Problems with INNODB table

Hello!! I have various databases, one with a table with more than 3 millions of registers, and other has 250 MB, 50MB. My ibdata1 grow to more than 1 G, well I do not want my big database, I drop the database but the size of the ibdata continues with the same size, what can I do?? I waant my

Problems with INNODB in MySQL 4.0.6-gamma

> > Hello! > > I have a problem with the innodb files, Well I have a database with a big > table with more than 3 milon of register, beside I have other databases > that haz different size. My innodb file grow up to 1 G, I make a sql sentence, delete from from big_table, and the size of the i

Re: Innodb: Limited creation of tables

On Tue, 4 Feb 2003, Shomal Bafna wrote: > The box is running a MySQL 3.23-47 Max rpm based version on a Mandrake 8.2 > Linux with Duron processor and 256MB Ram. Thera are 10 InnoDb type tables > created and several MyISAM types too (approx 30 more.). On adding the 11 > table of InnoDb type the

optimizing left join query

Hello All, I have the following 2 tables and "LEFT join" query as follows: mysql> describe user_lic; +++--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +++--+-+-+---+ | license_id | big

Re: optimizing left join query

Diana, Thanks for the suggestion. I completely forgot to add the index/primary key. Now it works just fine :) Thanks again. In Peace, Saqib Ali "I fear, if I rebel against my Lord, the retribution of an Awful Day (The Day of Resurrection)" Al-Quran 6:15 http://docbook.sc-icc.org |+

Mysqld not starting as user "mysql"

I have just installed mysql-max-3.23.55-pc-linux-i686.tar.gz and now I'm finding it impossible to run mysqld without being root. The permisions for the mysql data tree are all set with user and group "mysql". However when I run mysql.server I get permission denied errors: Starting mysqld daemon

Dump from big table in MySQL

machine?? I have a machine with 1.7 G, 256 MB, using Red Hat. Grover Cussi N www.cs.umss.edu.bo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Development environment for MySQL

Hi, How should I setup MySQL development environment? We run MySQL from Sun Solaris. I have a script file to create tables and load data which will be distributed to all developers. The developer will "own" his set of data where he is the only one who can modify it. In Oracle, each user acc

Re: Visualizing the shema of the db

Hello andy, http://www.datanamic.com/ a> Hi there, a> I am wondering if there is a software (free or shareware) which is a> visualizing the shema (table strukture) of the mysql database. a> thanx for any hint, a> Andy a> query a> ---

Re: MySQL + cygwin

Hello Chris, I would recommend to try to compile MySQL itself under cygwin (or you already tried it?). Just use GCC version they suggest (I failed to compiled it using GCC 3.1). BTW, if you succeed, I would really appreciate if send me mysqlclient-library compiled under cygwin.

Re[2]: Can I override the auto-increment setting?

Hello Jason, I think you have to ALTER this field, insert what you want and then ALTER it back. Another way is to insert the record, detect the value of auto-increment field it got (there is a function mysql_insert_id / LAST_INSERT_ID) and update it. JL> I have a mysql table tha

auto_increment, is this a bug?? Where to report it?

s like the auto_increment pointer didn't do the decrement when I deleted the last entry. Is this a bug?! Where should it be reported to? Thank you all... William N. Zanatta - Before posting, please check: http://www.mysql

Re: auto_increment, is this a bug?? Where to report it?

OK guys, Thank you all... That's it... the problem is that I'm using MyISAM at this time and the other tables I have are of ISAM type. Sorry and thank you again! William N. Zanatta Ravi Raman wrote: > > hi. > > from the manual: > > If you delete the row cont

Re: auto_increment, is this a bug?? Where to report it?

ng a bad design problem since I'm using the auto_increment feature to define the number of the editions of my bulletins. I'm studying other ways to do it. William N. Zanatta - Before posting, please check: http://www.mysql.co

Re: auto_increment, is this a bug?? Where to report it?

Well David, Using MyISAM tables, you would get 501 'cos the auto_increment pointer continues adding and never subtracts, but with ISAM tables, you would get 500. So take care of what type of table you are using and don't get bored as I've got. Best regards, Wil

design

Hi Is there any design document available of the complete architecture of the mysql database. I wanted to try out small changes . I want to make sure that it does not effect any transactions or anythings like that in any way. mallik -- ---

doubt urgent

Hello Sir, I am having doubt in connecting mySQL client to server.i want some explaination, before that i worked in Oracle.I am newly entering to mySQL. my mySQL server is in LINUX OS,my machine is WIN NT . now i want to connect with the server and access the database.

Perl/mysql.

Hello there, I just installed "mysql Ver 11.12 Distrib 3.23.33, for sun-solaris2.6 (sparc)". How do I insert rows into mysql database.tablevia PERL ?. It would be appreciated if some one can send some basic structure of connecting into sql using perl and some useful links. Thanks in advance.

Can't locate DBI.pm in

mo"; $dbh=DBI->connect($dsn,$user,$password)||die "cannot connect"; $sth=$dbh->prepare("SELECT * FROM telephone"); $sth->execute(); while(@row=$sth->fetchrow_array) { print "@row\n"; } $dbh->disconnect(); t# ls -al training1.pl -

Re: Can't locate DBI.pm in - CLOSED

Thank you all. I installed and seems working fine. - Original Message - From: "Paulus" <[EMAIL PROTECTED]> To: "N Sikkandar Dulkarnai" <[EMAIL PROTECTED]> Sent: Saturday, March 03, 2001 8:04 PM Subject: Re: Can't locate DBI.pm in > You haven

DBUG_PRINT

Hi all, How can I get the output of the DBUG_PRINT (which is everywhere in the code of the mysql) option to print the output as it is intended (functions and their parameters) and further extension to my question is how to get separate the DBUG_PRINT output(once I get it, I am sure there a

Not able to compile "mysql-test"

Hi, I have been working with mySQL and Apache for years on linux servers. But recently I purchased Solaris machine, and I am have problems compiling mySQL on it. I have - SunOS machine1 5.8 Generic_108528-10 sun4u sparc SUNW,Sun-Blade-100 - with gcc 2.95.3 20010315 And I am getting the following

errors

.42-unknown-freebsdelf4.3-i386 Regards // Joel -- Joel N. Eusebio MIS/Technical Support Engineer Commverge Solutions Philippines 11/F 6750 Ayala Avenue Makati City, 1200 Philippines Tel: +63 2 8931139 Fax: +63 2 8123122 Mobile: +63 917 8395009 Em

RE: problem with Linux

Last time I saw this error, it was due to an authentication issue. Try adding the user you have for the JSP pages or the user who is used for Apache to your domain controller or to the administrative user list under the NT users dialog. If you add this to the domain controller make sure Password

Problem in connecting to mysql using perl

Dear Sir, I have downloaded DBI-1.15. I tried installing it. The tests failed. I am using PMAKE to prepare an install program. The error is as follows: "can't locate loadable object for module DBI in @INC." I am also providing you with the procedure i adopted to install DBI

hello

testing

mysql query

Hi all ,  as I came across a certain prob , so I am here , I have three tables  1 customer_mast ( custid  pk )    2 comment_mast ( multiple comments against custid , sysdate()  3   contact_mast ( multiple contacts ( three each ) against single custid , contact id )   i wa

Re: CURRENT insert ID

2011/1/21 Jerry Schwartz : >>-Original Message- >>From: João Cândido de Souza Neto [mailto:j...@consultorweb.cnt.br] >>Sent: Friday, January 21, 2011 12:47 PM >>To: mysql@lists.mysql.com >>Subject: Re: CURRENT insert ID >> >>Ok, you must have your own reasons to do that. >> >>The fact is:

Re: Query Help 2

yes, it should work, but should not be 1,1 ? or simply: UPDATE RemoteStation SET company=LEFT(ID, 4); ? "gerald_clark" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > How about: > update RemoteStation set company=substring(ID,1,1); > > Jeff McKeon wrote: > > >Damn fat fingers and

mysql NOT operator

Hello, Could you please tell me how I can write an sql statement in php when I'd llike to select boolean search in one field like "except" or "NOT" result. What I mean here is that I can execute the following: 1. SELECT data_id from table WHERE keyword = a AND keyword =b 2. SELECT data_id from ta

how to use except operation?

Hello, I've had a problem: statement "SELECT data_id from table WHERE keyword = a NOT keyword =b" returns SQL error I've got the following not working solutions to my problem: SELECT data_id FROM table WHERE keyword = a AND keyword <>(or !=) b SELECT data_id FROM table WHERE keyword = a AND NOT (

how to use except operation (corrections for the return results)?

Hello, I've had a problem: statement "SELECT data_id from table WHERE keyword = a NOT keyword = b" returns SQL error I've got the following not working solutions to my problem: SELECT data_id FROM table WHERE keyword = a AND keyword <>(or !=) b SELECT data_id FROM table WHERE keyword = a AND NOT

union, intersct and except operation?

Hello, I've had a problem trying to get working except operator in mysql: statement "SELECT study from table WHERE keyword = 'chemistry' NOT keyword = 'computers'" returns SQL error I've got the following not working solutions to my problem: SELECT [distinct] study FROM table WHERE keyword = 'ch

mySQL 4.1.3-beta subqueries

Hello, Since I had a problem with except operator and subqueries, I investigated a topic on mysql version capability. I tried a few examples which were offered on this mailing list, all of them gave me a syntax error, so I've read a manual and tried some examples from it. However, things that m

  1   2   >