insert query

how to insert only blank spaces into a field using insert query. Its getting trimmed off. Regards, Murthy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

insert query

> sql,query,queries,smallint how to insert only blank spaces into a field. Its getting trimmed off. Regards, Murthy - Before posting, please check: http://www.mysql.com/manual.php (the manual) h

TABLE and VIEW have same IDENTIFIER: PLEASE HELP

views have the same identifier as the tables. I don't know if it is possible to have views and tables the same identifier. I didn't create these views. Can someone please help me figure this out? Thanks Murthy __ Do You Yahoo!? Tired

Copying tables sans data from one database to another

How can I copy tables from one database to another on the same host? Thanks for your help Murthy __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

ERROR 2013 (HY000): Lost connection to MySQL server during query

nks Murthy __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

Can't CREATE table using SELECT

Hi The following happened when I tried to create table. Can anyone please help? mysql> create table sfgbackup.advEmail select * from sfg.advEmail; mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrup

MYSQLDUMP uses database name in the SQL statements?????!!!!!!!!!!!

won't work because the sql is referring to sfg database. I think this is the reason why I'm facing the problems (sorry for multiple threads). Can anyone confirm my suspicion and suggest a fix? I'm thinking manually changing all the entries. Is that the only way? Thanks

ERROR 1016 (HY000): Can't open file: 'agent.ibd' (errno: 1)

nyone please help me figure this out? Here are some pertinent facts: a) stopped mysqld b) copied files from sfg to sfgnew in the var directory c) set the permissions to 777 (read, write, execute) for all the files in sfgnew d) restarted

Re: ERROR 1016 (HY000): Can't open file: 'agent.ibd' (errno: 1)

Hi Dan I've set the permissions to 777 for all the files and directories. Basically I did chmod -R 777 sfgnew. Also changed the ownership to mysql using chown -R mysql:mysql sfgnew. Thanks! Dan Buettner <[EMAIL PROTECTED]> wrote: Murthy, do you have appropriate permissions

Re: ERROR 1016 (HY000): Can't open file: 'agent.ibd' (errno: 1)

one that got dropped at some point? See http://dev.mysql.com/doc/refman/5.0/en/innodb-troubleshooting-datadict.html The last half seems relevant - it's pointing you to removing the .frm file manually. Personally, I'd mv it and not rm it. Dan murthy gandikota wrote: > Hi Dan > I&#

Re: ERROR 1016 (HY000): Can't open file: 'agent.ibd' (errno: 1)

ing similar to recreate your tables and move them. HTH. -phpninja -Original Message- From: Dan Buettner [*mailto:[EMAIL PROTECTED] Sent: Wednesday, June 14, 2006 8:12 AM To: murthy gandikota Cc: mysql@lists.mysql.com Subject: Re: ERROR 1016 (HY000): Can't open file: 'agent

Re: ERROR 1016 (HY000): Can't open file: 'agent.ibd' (errno: 1)

operation, please note that I am only interested in preserving the schema without the data. Is it possible to just transfer the schema to a new database? Thanks murthy gandikota <[EMAIL PROTECTED]> wrote: I can't get mysqldump to work. I typed mysql -uuser -ppassword sfg < s

Re: ERROR 1016 (HY000): Can't open file: 'agent.ibd' (errno: 1)

f the `sfg` patterns with `sfgnew`. As you may guess, I don't intend to this often. Why can't we have a tool that copies one DB into another? BTW, I tried create table with select and it didn't work. Michael Stassen <[EMAIL PROTECTED]> wrote: murthy gandikota wrote:

Crashing mysql Ver 14.7 Distrib 5.0.2-alpha, for pc-linux (i686)

Hi Can someone tell me where in the file system to look for the logs? Mysql has been crashing once every hour. Memory is not the issue. This is how I start the mysql: nohup /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/ local/mysql/var --user=mysql --pid-file

Re: Crashing mysql Ver 14.7 Distrib 5.0.2-alpha, for pc-linux (i686)

nosing the problem, so please do resolve it The manual page at http://www.mysql.com/doc/en/Crashing.html contains information that should help you find out what is causing the crash. murthy gandikota <[EMAIL PROTECTED]> wrote: Hi Can someone tell me where in the file system to look for the

Re: Crashing mysql Ver 14.7 Distrib 5.0.2-alpha, for pc-linux (i686)

Looks like I have too many connections to the database. I made sure all the connections are closed after use. Hope this is the fix. Anyone please confirm. Thanks murthy gandikota <[EMAIL PROTECTED]> wrote: Can someone please help me figure out what's in this mysqld output befor

Can Primary Key be added with ALTER?

Hi I have a table with no primary key. I'd like to make one of the table columns as the primary key. Is it possible do it with ALTER? Is there any other way? Many thanks for your help. Murthy __ Do You Yahoo!? Tired of spam? Yahoo!

JSP/JSTL problem

Hi I have created a table with the following specs: create table `cust` ( `ssn` int(9) NOT NULL PRIMARY KEY, `submitdate` date, `submitto` int(3), `first` varchar(30), `last` varchar(30), `loanAmt` decimal(10,2), `company` int(3),

Re: JSP/JSTL problem

I am getting the same result in Java code, i.e. the resultset returned is non-null even though the primary key value is not found in the table. Hassan Schroeder <[EMAIL PROTECTED]> wrote: On 12/29/06, murthy gandikota wrote: > I am posting the relevant JSTL code. Just to clarif

Re: JSP/JSTL problem

ut.println("Customer already exists " + Integer.parseInt(ssn)); return; } do insert (not shown) I get the message "customer already exists" for EVERY ssn that I tried. Hassan Schroeder <[EMAIL PROTECTED]> wrote: On 12/3

Re: JSP/JSTL problem

t;[EMAIL PROTECTED]> wrote: On 1/2/07, murthy gandikota wrote: > ps = con.prepareStatement("select first, last from cust where ssn=?"); > int ssnint = Integer.parseInt(ssn.trim()); > ps.setInt(1, ssnint); > ResultSet rs=ps.executeQuery(); > if ( rs.next()) { > rs.c

Re: JSP/JSTL problem

ch, you guarantee that // each resource will have "close" called on it before returning try { rs.close(); } catch (Exception e) {} try { stmt.close(); } catch (Exception e) {} try { conn.close(); } catch (Exception e) {} } David murthy gandikota wrote: > I tri

Disk parition full

ll me how to manage multiple disk partitions in mysql? BTW, the mysql is version 4 or something like that. Thanks Murthy - Don't be flakey. Get Yahoo! Mail for Mobile and always stay connected to friends.

What does NOW() return: linux time or something else?

Hi I tried to look up the time functions specifically for the disparity between NOW() and the linux time obtained with 'date'. Why are they different? How can I set the database time? Thanks Murthy - Looking for earth-friendly autos?

LEFT/RIGHT Joins not working

cust.disposition=disposition.id) LEFT JOIN leadSource on (cust.source=leadSource.id) where agentCode=11 and newPayment > 0 and cust.disposition > 0 order by SOURCE, DISPOSITION The MYSQL has the following version mysql Ver 14.7 Distrib 5.0.2-alpha, for pc-linux (i686) Thanks

Re: LEFT/RIGHT Joins not working

+---+-+-+ | ssn | disposition | source | +---+-+-+ | 123456789 | dispo2 | source1 | | 123456780 | dispo1 | source2 | | 123456781 | NULL| NULL| +---+-+-+ I'd appreciate your help. Thanks Murthy Michael Dykman <

Re: LEFT/RIGHT Joins not working

disposition, source.source from cust LEFT JOIN source ON (cust.source=source.id) LEFT JOIN disposition ON (cust.disposition=disposition.id); '123456789', 'dispo2', 'source1' '123456780', 'dispo1', 'source2' '123456781', null, null

Is an index on varchar column efficient?

ld like to get your feedback before I actually do this because I don't want to create a disruption when the DB is in production. Thanks Murthy - Ahhh...imagining that irresistible "new car" smell? Check outnew cars at Yahoo! Autos.

Re: Is an index on varchar column efficient?

mos <[EMAIL PROTECTED]> wrote: At 06:23 PM 4/15/2007, you wrote: >Hi, > > I have a table with 2 million records but without an index or a primary > key. The column upon which I want to create an index is a varchar. Will > it give me any advantage when I have to do a select on the column? > > B

Re: Is an index on varchar column efficient?

Baron Schwartz <[EMAIL PROTECTED]> wrote: murthy gandikota wrote: > Hi, > > I have a table with 2 million records but without an index or a primary key. > The column upon which I want to create an index is a varchar. Will it give me > any advantage when I have to do a

Should the db be shutdown before backing up?

Hi I did a hot backup a while ago. When I had to restore from backup there were several error messages. So I ran mysqlcheck for every table with --auto-repair option. Is this the best way? Thanks Murthy - Ahhh...imagining that irresistible &quo

Should the db be shutdown before backing up?

Hi I did a hot backup a while ago. When I had to restore from backup there were several error messages. So I ran mysqlcheck for every table with --auto-repair option. Is this the best way? Thanks Murthy - Ahhh...imagining that irresistible &quo

Re: Should the db be shutdown before backing up?

"Gerald L. Clark" <[EMAIL PROTECTED]> wrote: Mathieu Bruneau wrote: > murthy gandikota a écrit : > >>Hi >> I did a hot backup a while ago. When I had to restore from backup there were >> several error messages. So I ran mysqlcheck for every table wi

Diff between restore from tar and recover from power outage

Hi When restoring a DB from a tar file, I had to repair some of the tables. Whereas when the DB is started after a power failure, everything works fine. I noticed this on RedHat linux and MySQL5. Any thoughts? Thanks Murthy - Building a

Mysql.sock- Help!

hi, Can anyone pl tell me as to how I can resolve a missing mysql.sock problem??? Can anyone pl send me the mysql.sock file??? been trying to start mysql for the past 3 days and everytime am getting a "unable to connect localhost error, missing mysql.sock" I tried most of the suggestions foun

uninstalling

Can anyone please guide me in uninstalling MySQL... P.S: i did a rpm -e but there was no mysql rpm package... tia, sandeep - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql

inserting images

hi all, I have been trying to insert images into my mysql database thru PHP for the past 2 days without any luck.. After having tried various combinations of queries, I gave up.. Wud be grateful if anyone can post a query for inserting images in to my database.. TIA, Sandeep This is what i h

Re: inserting images

The database I have created for storing images has a field called binary_junk which is of type "BLOB" but its still not working... TIA, sandeep - Original Message - From: "AJDIN BRANDIC" <[EMAIL PROTECTED]> To: "Sandeep Murthy" <[EMAIL PROTECTED]&g

Copying data

Hi all, I feed data into a db and a jscript draws that data from the db and dumps it in a Marquee on the pg but what happens is everytime i feed in data, there is an sql update query which updates my db overwriting earlier data... but i need to archive the data which i wrote earlier so am trying

Inserting Data on top

Hi all, I am trying to insert data from a form which has 4 fields such that the data always sits at the top in my database occupying locations : SEC_ID: 1, 2 , 3 & 4 Everytime i insert data the data gets appended at the end i,e, if the first 4 fields are occupied my data takes the postions 5,6

Re: Inserting Data on top

b to show the new data on my frontpage.. I hope I could convey what I need.. Would appreciate any more suggestions... TIA, sandeep - Original Message - From: "jim barchuk" <[EMAIL PROTECTED]> To: "Sandeep Murthy" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]&

Re: Nusphere is spamming me

Have been spammed too by NuSphere earlier on.. so junked my earlier mail id and switched to the present one... let all the subscribers carry a vote to hv this spammer banned from this list... sandeep - Original Message - From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "Michael A. Peters"

Mysql Daemon not starting

Hi all, Am facing a strange problem... I am running MySQL on a WIN 2000 server and was running fine till this morning.. I am using PhpMyAdmin to administer the databases.. Suddenly all of a sudden I could no longer connect to the databases and keep getting an error saying " Can't connect to MySQ

Re: Mysql Daemon not starting

Unable to start the service MySQL thru ctl panel/services too. Tried reinstalling MySQL but to no avail... frustrating... sandeep - Original Message - From: "yilmaz" <[EMAIL PROTECTED]> To: "Sandeep Murthy" <[EMAIL PROTECTED]> Sent: Tuesday, November 20,

MySQL + WIN 2000

hi, I had posted a few days back regarding having problems running MySQL on WIN 2000... I had installed and was running MySQL and PHP with IIS successfully for nearly 2 mths now... All of sudden since a few days back the MySQL service refuses to start and keeps giving various errors such as unab

Mysql & Win200 problem (telnet localhost)

hi, I had posted a few days back regarding having problems running MySQL on WIN 2000... I forgot to add before, I can ping my localhost but unable to do a telnet localhost too... I had installed and was running MySQL and PHP with IIS successfully for nearly 2 mths now... All of sudden since a fe

How to avoid ERROR :1045

Dear Sir, Hello, We have installed MySql in Windows NT Server. MysqlAdmin services are doing fine and but when we try to enter the prompt of mysql.we are getting the follwing error ERROR :1045 Access denied for user 'odbc@localhost )using password yes port is:3306 and user is :root How to r

Very Strange problem.

ppens randomly. One more thing i noticed is that when i run the 'show table status' it says 1000 rows in the table that has lost all the records. Could someone help me here. help is greatly appreciated. regards, -- __

Re: Very Strange problem.

thing happened with that too. i guessed that was because of the alpha version db. so i downgraded to mysql3.23. regards, On Thu, 2 May 2002, Jeremy Zawodny wrote: > On Fri, May 03, 2002 at 11:04:29AM +0530, TP R Murthy wrote: > > > > I have created only one database with 18 table

Re: mySQL under cygwin : mysql_install_db does not create host.frm

; [EMAIL PROTECTED] > Phone : +33 1 44 89 77 59 >: +33 1 44 89 77 50 (secretariat) > Mobile : +33 6 64 63 00 15 > - > > > ----- > Before posting, please chec