query question...

for. any help/thoughts would be appreciated! thanks -bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: query question...

. i've tried to do a 'limit' and group, but i'm missing some thing... thanks -bruce -Original Message- From: Peter Bradley [mailto:[EMAIL PROTECTED] Sent: Friday, December 08, 2006 12:26 PM To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: Re: query question... Ysgrifennodd bruce

RE: RE: query question...

... Just add a DISTINCT: SELECT DISTINCT t1.universityID FROM SvnTBL t1 WHERE t1.universityID NOT IN (SELECT t2.universityID FROM SvnTBL t2 WHERE t2.actionID = 2); Dan On 12/8/06, bruce [EMAIL PROTECTED] wrote: hi peter. thanks, the solution you gave me is close...!! my actual data

DROP DATABASE weirdness

I'm running MySQL 5.0.24a and I have a database I need to drop. When I issue the command DROP DATABASE webdb the client seems to just hang. I see the command hit the server in the full log but the database never drops. Anyone have any suggestions? -- One day at a time, one second if

Re: DROP DATABASE weirdness

I get this error: /usr/sbin/mysqld-max: relocation error: /usr/sbin/mysqld-max: undefined symbol: zlibCompileFlags Logan, David (SST - Adelaide) wrote: Hi Bruce, Do you have any messages in the MySQL log? Regards

Re: DROP DATABASE weirdness

Yes, built with SSL support the build seemed to go OK and sometimes it works. I'm building on SuSE 9.2 using the src.rpm and the included spec file Logan, David (SST - Adelaide) wrote: Hi Bruce, Sounds like you are missing a library or two on the system. Did you compile the server yourself

Re: DROP DATABASE weirdness

I think I found it. The system has zlib 1.1.4 the sources have zlib 1.2.3. Trying a static build now. Anyone wanna bet? :) Bruce Ferrell wrote: Yes, built with SSL support the build seemed to go OK and sometimes it works. I'm building on SuSE 9.2 using the src.rpm and the included spec

Re: DROP DATABASE weirdness

Nope, That didn't fix it. I'd uses MySQl provided rpms but they don't seem to have them got glib23 anymore. Suggestions? Bruce Ferrell wrote: I think I found it. The system has zlib 1.1.4 the sources have zlib 1.2.3. Trying a static build now. Anyone wanna bet? :) Bruce Ferrell wrote

Re: DROP DATABASE weirdness

Yeah, that is the bug exactly. I can't even get 5.0.27 to start it comes up with the exact same error. Maybe if I get rid of the SSL option but this sucks! Thanks for the help Logan, David (SST - Adelaide) wrote: Hi Bruce, Have a squiz here http://bugs.mysql.com/bug.php?id=16586 sounds

Re: Importing Text File Into mySQL

I did a little shell script to do it. the key was the shell variable IFS: Normally IFS= to make it work right I set it as follows: IFS= Yes, thats a newline between the quotes John Kopanas wrote: I have a text file with over 500K rows of data in it. The problem is that the data is no

Re: InnoDB, 1 file per table or 1 BIG table?

really really like innodb_file_per_table - but mostly because it makes our lives easier in many ways, not so much for performance reasons. Best Regards, Bruce. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

file i/o operations...

is more or less collected and received at the node level... does anyone know of a way to create a distributed kind of db app, where i can enter information into a db on a given server, and the information is essentially pulled into the master server from the child server... thanks -bruce

RE: file i/o operations...

-bruce -Original Message- From: Brent Baisley [mailto:[EMAIL PROTECTED] Sent: Friday, August 25, 2006 1:45 PM To: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: Re: file i/o operations... Just getting that number of processes running I think would be a challenge. A setup I recently

Re: HELP!

Not the best start to the day, if you have a fairly recent backup and have enabled binary logging then you can recover up to the point before you screwed the data. Peter Lauri wrote: Hi, I did something terrible similar to UPDATE table SET testdate=NOW() And I kind of forgot the

Re: Too many table-locks

Assuming that the locking issues occur mainly when an insert is being performed (i.e. replying to a post) then what about using read local locks for selects so that you can perform con-current inserts? If you have a lot of old threads that are no longer updated but viewed regularly then you

Re: Getting 5 to run

look in /var/lib/mysql for the error file. make sure /var/lib/mysql is owned by mysql Karl Larsen wrote: I am trying to get mysql 5 to run on my Fedora Core 4 linux. I installed both server and client RPM files. The info is good and using that I am trying to do the post-install. I ran

Simultaneous connections

to solve this kind of issue... thanks -bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Log files

hi... i changed the mysql my.cnf to provide log files. i restarted mysql, but i don't see the log files... any idea as to what i may have missed. i'm running FC4, mysql 4.1. the my.cnf is: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock set-variable = max_connections=1000

multiple table inserts

hi... the mysql docs don't seem to allow this.. but i'll ask. is there a way to accomplish: insert into cat,dog (cat.x,dog.y) values (1,2) allowing me to essentially insert items into multiple tables simultaneously... thanks -- MySQL General Mailing List For list archives:

RE: multiple table inserts

:55 AM To: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: Re: multiple table inserts Hell Bruce Yes ,Here is the solution to insert the values from multiple table into a table . We can achieve this by using the JOINs(INNER JOIN,LEFT JOIN,RIGHT JOIN, join) Consider the tables Animal,Feed

RE: multiple table inserts

PROTECTED]; mysql@lists.mysql.com Subject: Re: multiple table inserts Hi Bruce U can you mysql_insert_id function to insert values into multiple tables. Please refer to http://www.desilva.biz/mysql/insertid.html for more details. It also illustrates with examples. Thanks Visolve DB Team

replace/temp tbl question...

hi... can someone tell me if this should work in theory... basically, i'm looking to get a bunch of rows from my initial table, based on the value of a given column/field. i'd then like to do a complete replace/update on the values in the temp table. finally, i'd like to write everything in the

RE: replace/temp tbl question...

thanks for the reply dan... but is there a better/more efficent way... thanks -Original Message- From: Dan Buettner [mailto:[EMAIL PROTECTED] Sent: Friday, August 11, 2006 8:13 AM To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: Re: replace/temp tbl question... Bruce

replace question...

be seriously appreciated. thanks -bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

insert/replace question...

hi. i have the following that works... in that it does a replace on the row. replace into appTBL (appName, universityID) values(%s,%s)... i'm trying to figure out how to do the replace on the row if a given column is not equal to a certain value.. i've tried...

db logic questions...

? are there scaling issues with agiven approach that i'm not aware of... thanks for your time/thoughts on this!!! -bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

building mysql-5.0.22 from src

. thanks -bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: building mysql-5.0.22 from src

that building by source would have been ok... -bruce -Original Message- From: Chris [mailto:[EMAIL PROTECTED] Sent: Thursday, August 03, 2006 5:38 PM To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: Re: building mysql-5.0.22 from src bruce wrote: hi... i have FC3/4 systems. i'm

logic/db question

-bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: logic/db question

hi peter... tried to get to the link...saw that it's 'localhost'!! what's the real/actual url... -bruce -Original Message- From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 02, 2006 2:15 PM To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: Re: logic/db

upgrading mysql...

hi.. i have FC3, with 4.1.13, i also have FC4 with 4.1.20. however, i can't seem to find 5.0.x RPMs for FC3/4. do i have to go ahead and build this from source for the FC3/4 boxes that i have... thanks -bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

allow access to all users within a network..

hi... i'm trying to figure out how to allow all users on machines within my network access to a mysql db... i've tried: grant access all on *.* to '*'@'%' grant access all on *.* to '%'@'%' grant access all on *.* to @'%' with no luck.. thanks -bruce -- MySQL General Mailing List

Re: Selecting Common Data

John I think you are saying you want the Mode? if you are then the following might work: SELECT col2 as val, count(col2) AS cc FROM my_table GROUP BY val ORDER BY cc DESC LIMIT 1; in your case this will retrun the value '2' Regards Ade John Nichel wrote: Running MySQL 4.0.20 on a RHEL3

Re: Replacing A Value

UPDATE Query Tip No. 1: Manuals, Google etc Tip No. 2: Posting a question like this may result in sarcastic responses and possibly mass flaming Ed Curtis wrote: I have a column in a table I need to replace a value of certain records in. The current value is /realtors/Value/. I need to

Re: Multiple engines in one DB a problem?

MySQL has a pluggable storage engine architecture which means that you can use multiple storage engines within your databases. What you need to do is investigate the different features of the engines and devide which one best fits your system i.e. level of locking required, InnoDB=row level

Certification examples

Hi I have bought the MySQL certification study guide (v 5.0) and am almost ready for the exams, does anyone know if the questions in the self study guide are very similar to the ones that you get in the exam? and is there anywhere else that i can get more questions like this for practice

Re: Coded fields

I would approach this in practically the same way as yourself but used an enum field in the student table (like what you were thinking). When a user wants to add or remove an enum value you can build an appropriate MODIFY statement like: ALTER TABLE my_table MODIFY my_col ENUM('K','X') NOT

Re: How to rename a DB

Stop the server, go to the MySQL data directory and physically change the name of the directory that corresponds to the database. Restart MySQL server and SHOW DATABASES to see the change take effect. George Law wrote: Hardi I rotate tables out on a monthly basis. The way I do it is:

RE: New User Setting up MYSQL

hi chuck... i don't use windows, but are you able to get a cmd window up/running, and what happens if you type mysql in the dir where the mysql.exe resides? do you also have this dir in your path? -bruce -Original Message- From: Chuck Wildeman [mailto:[EMAIL PROTECTED] Sent: Thursday

Re: LOAD DATA giving BIG mysql-bin files ...

I think this is normal as the binary log will contain a record of all changes made to the data, therefore if you are loading large files regularly- the bin logs will be quite large. If you do not want the binary logging, edit the my.cnf file, comment out the line log-bin (#log-bin) and

Re: Please help: recovering db from crash

not sure, but it may be worth trying the following run the script: mysql_install_db --user=root In the installation dir this should change ownership and make mysql recognise the data dir. good luck Ade Foo Ji-Haw wrote: Hi all, My Windows-based database server crashed (no fault of MySQL.

Re: query problem

one solution (may not be the best but would work) would be to use 'like' instead of '=' and then put wildcards %%$var % around the variable so that if it is not there then it wount effect the query. Ade [EMAIL PROTECTED] wrote: I am fairly new to sql and am now getting into the area of

RE: replication

There is one issue. MySQL changed the way it parsed SQL join statements in 5.03. Specifically JOINS in the older syntax using implicit joins {tables seperated by ,} i.e. FROM table_a, table_b are parsed differently than they are in versions prior to 5.03. If you have any statements that do any

Can't select to outfile

'/usr/database3-2'; ERROR 1: Can't create/write to file '/usr/database3-2' (Errcode: 13) mysql bruce has all privileges on the table. How can I get my data out? bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

RE: MYSQL: Unlimited Forums, Scalablity Issues, advice please? - Bayesian Filter detected spam

Let's try to characterize the load and sizing. If the posts are mostly text. 100 forums X 100,000 posts X 2,000 bytes per post = 20GB large but not huge We have people reading the posts. Even speed readers will take minutes to read the new posts. Maybe 1 in 10 - 100 readers will do a new post. A

using WHERE and OR in a query

(Reason: $!); -- Bruce Therrien [EMAIL PROTECTED] This is the end of the internet. Please turn around and go back. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

using WHERE and OR in a query

}', gold = gold+'$adata{gold_credit}' WHERE subscribe != '' OR artist = '1' OR rank_change != '1' SQL $dbh-do($SQL) || cgierr(Reason: $!); -- Bruce Therrien [EMAIL PROTECTED] This is the end of the internet. Please turn around and go back. -- MySQL General Mailing List For list archives: http

Re: simple addition in a query?

I think the following should work, try taking a look on the net for help on MySQL queries that use aggragate functions, there is probably a lot of info on there. select exim.hour,sum(exim.count) from exim,servers where exim.machine=servers.id and servers.type='MX' and exim.date='2006-02-22'

RE: [SPAM] - Re: Inner join with left join - Bayesian Filter detected spam

If you want to see all of the products {even those that have never been ordered} then you need to SELECT ... FROM products ... LEFT JOIN orders I think you also have to do a LEFT JOIN on order_items And pull prod_name from products {don't know what the column name in products is}. SELECT o.id,

MySQL Certification Questions

Hi Does anybody know where i can get a load of sample questiosn for the MySQL certificate exams, i know there are a few on mysql's site but i was hoping to find quite a few to practice on. Thanks Ade -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

RE: Byte Swapping (Re Post)

If the order of the bytes is opposite between big-endian and little-endian, then if you can get the bytes in a string REVERSE() should flip the order. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 14, 2006 3:25 PM To: gerald_clark Cc:

MySQL PDA Synch

hi I have an online registration system made with PHP and MySQL that i would like to make available for use with PDA's. We have a wireless network that covers only certain parts of our area and when the PDA's can connect there will be no problem as I have PDA style sheets set up. When the

Sudden Mysql Crashes - table damage?

HI MySQL 5.0 (windows XP) I have a problem where i think some of my tables have somehow been corrupted, if i try to run a check table command against some tables the mysql service crashes and i have to restart it. I am not sure how this damage has occurred but has anyone got any

Re: Sudden Mysql Crashes - table damage?

Thanks for the reply yep mysqldump also causes the service to crash. i have a few innodb tables mixed in amongst the myisam, it seems that it is the innodb tables that may be causing the problems but i am not sure why ??? Imran Chaudhry wrote: On 1/31/06, Adrian Bruce [EMAIL PROTECTED

RE: [SPAM] - Trans.: Re: Finding the row number satisfying a conditon in a result set - Bayesian Filter detected spam

You can use a user variable [EMAIL PROTECTED] in the sample below} to number the rows in the result set. mysql set @row:=0; Query OK, 0 rows affected (0.00 sec) mysql select @row:[EMAIL PROTECTED], city_Name from citiesw limit 10; +--+-+ | @row:[EMAIL PROTECTED] |

Auto-increment indexes

Hi, im hoping to solve a problem that is bugging me! I just moved a database from a development server to production (test), several of the fields have auto-increment ticked but as it is mainly a data warehouse i thought nothing of it. I then found that a lot of my queries were running slow

is UNION allowed in a MySQL stored procedure?

I have a simple stored procedure which works as intended. As soon as I add a UNION in the SELECT I get the error message ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select phon_Lvl INTO

RE: Show Description options??

If you are on 5.0.x you can use SELECT column_Name FROM INFORMATION_SCHEMA.columns; INFORMATION_SCHEMA is a set of VIEWS that lets you access the database structure. See http://dev.mysql.com/doc/refman/5.0/en/information-schema.html -Original Message- From: Mike OK [mailto:[EMAIL

RE: [SPAM] - convert help - Bayesian Filter detected spam

I just added a user variable @fdata to get visabilility outside of the procedure and this is what I get. mysql delimiter // mysql create procedure test20 () -BEGIN - DECLARE fdata BLOB; - DECLARE foffset INT UNSIGNED; - DECLARE flength INT UNSIGNED; -

Re: table missing

The table may be damaged and seemingly unavaible to languages like php(has your box crashed recently??), run 'SHOW TABLES' from the command prompt and it should appear.If it does try running 'CHECK table' to see if is damaged or not Jon Miller wrote: I've created a database with a table and

Re: Semi-complicated delete

IN MySQL 5 you could use a sub query( http://dev.mysql.com/doc/refman/5.0/en/any-in-some-subqueries.html). However, i would try using a left join between cart and products and then bring back the results where the products.id field is 'NULL'. There may be a better way of doing this but

RE: [SPAM] - Re: mysql 5 - disk bound - fixed - Email found in subject

One huge problem with this approach. The new table doesn't have any of the indexes that were present in the previous table. You may be better off to build a script that renames the current tables followed with the full CREATE TABLE statement(s). Do a SHOW CREATE TABLE current table; Then take

RE: [SPAM] - Adding data from one table to another - Bayesian Filter detected spam

You probably want a multi table update assuming you are running at least 4.0.x. Add the column(s) to A with an ALTER TABLE UPDATE A INNER JOIN B ON (... SETA.col_name = B.col_name, A.col_name_2 = B.col WHERE .. You can copy the join structure from the

Re: move to 64 bit

. Best Regards, Bruce On Jan 11, 2006, at 7:19 AM, Roland Carlsson wrote: Hi! What must I do to move our mysql-database from 32-bit binaries to 64-bit (mac os x). Is it as simple as just changing binaries for must I prepare the data-files somehow? Thanks in advance Roland Carlsson -- MySQL

RE: Converting decimal to binary

If by Decimal you mesn HEXIDECIMAL you can use CONV where the 1st arg is the HEX value, 2nd arg is From Base and 3rd arg is To Base. You will have to suround the aliases with `'s if you really want the names to be numeric. mysql select MID(CONV('A5',16,2),1,1) AS `7`, -

RE: [SPAM] - Re: Converting decimal to binary - Bayesian Filter detected spam

Actually CONV converts from any base to any base so if it is base 10 then just replace the 16's with 10's. Too much time looking at dump's. -Original Message- From: Bill Dodson [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 3:09 PM To: Gordon Bruce Cc: Ed Reed; mysql

RE: [SPAM] - concat string and update question - Found word(s) remove list in the Text body

Try this UPDATE people SETphone = CASE WHEN LEFT(phone,4) = '405_' THEN MID(phone,5,20) WHEN LEFT(phone,3) = '405' THEN MID(phone,4,20) ELSE phone END FROM people WHERE LEFT(phone,3) = '405' AND LENGTH(phone)

Re: How come this update does not work??

Carlos Vasquez wrote: How come this doesn't work? Wp_photos.photo = IMG_1234.JPG Pixelpost_pixelpost.headline = /this/path/to/directory/IMG_1234.JPG So I need to just match the latter-bit of the file. update pixelpost_pixelpost,wp_posts,wp_photos set

RE: [SPAM] - Re: SQL Question - Bayesian Filter detected spam

Why not just use the ABS Function update ev98nv_tm set mome=ABS(b) where tm.tr=tr and tm.ra=ra and tm.ke=ke and tm.moti=moti ; 12.4.2. Mathematical Functions All mathematical functions return NULL in the event of an error. ABS(X) Returns the absolute value of X.

FW: Re: SQL Question

Why not just use the ABS Function update ev98nv_tm set mome=ABS(b) where tm.tr=tr and tm.ra=ra and tm.ke=ke and tm.moti=moti ; 12.4.2. Mathematical Functions All mathematical functions return NULL in the event of an error. ABS(X) Returns the absolute value of X.

RE: Can this SELECT go any faster?

Try this SELECT replace(left(history.time_sec,7),'-','') AS month FROM history WHERE history.account_id = 216 GROUP BY month ORDER BY history.time_sec DESC; This is what I get on 1 of my tables with no index on perm_user_ID , 80,000 rows in the table and 7,000 rows where perm_user_ID =

RE: Changing types on the fly in select queries?

Generally MySQL does format conversion for you to match data types. You can also force the CONCAT result to be integer by the following where concat(year,period,week) + 0 2007031 ^^^ -Original Message- From: Jay Paulson (CE CEN) [mailto:[EMAIL PROTECTED]

Is this a MySQL 5.0.x bug OR What am I missing?

| gbruce   | rgbjs1jc  | Ralph  | Bruce  | Gordon | Yes | AGB1 | 2005-12-23 08:59:31 | NULL

RE: [SPAM] - Re: locating ibdata1 and *.ibd files in different directories. - Bayesian Filter detected spam

The following takes a little effort, but it should get you close to dump file size. On 5.0.x you can use Information_schema.columns to get average row length for MyISAM tables. Take that plus the punctutation {~35 + 3* # cols for insert per row if you enclose your columns in 's} in the insert

this listserv function...?

I am experiencig an odd thing when usig this listserv. When replying to posts, my replies are being addressed to the sender, not going back to the list. Does this list not have the reply-to enabled? Going to be annoying to have to watch that all the time. Let me know, thanks, Bruce

Re-REQUEST: proper way to export with the --tab function???

I posted this earlier, could someone take a look at it? TIA, Bruce. On Mon, 19 Dec 2005 02:15:54 -0500 Bruce Carey [EMAIL PROTECTED] wrote: Hi List, I have recently had a crash coursh in the fineer points of db recovery due to a mis-managed server. Could someone help me out with advice

Re: Re-REQUEST: proper way to export with the --tab function???

/record terminator? can those be more than one character? TIA, Bruce On Mon, 19 Dec 2005 11:39:06 -0800 Hassan Schroeder [EMAIL PROTECTED] wrote: Bruce Carey wrote: I posted this earlier, could someone take a look at it? In the time since you first posted, you could have at least glanced

Re: Re-REQUEST: proper way to export with the --tab function???

/record terminator? can those be more than one character? TIA, Bruce On Mon, 19 Dec 2005 11:39:06 -0800 Hassan Schroeder [EMAIL PROTECTED] wrote: Bruce Carey wrote: I posted this earlier, could someone take a look at it? In the time since you first posted, you could have at least glanced

proper way to export with the --tab function

my data after a catastrophe like this again. TIA, Bruce Carey -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: copying data!!!

This is kind of ugly, but with the multitable limitations of 3.23 it probably works. CREATE TABLE TEMP SELECT table_1 columns except age, table_2 age FROM table_1 INNER JOIN table_2 USING (name); TRUNCATE table_1; INSERT INTO table_1 SELECT * FROM TEMP; DROP TABLE_1;

RE: copying data!!!

Sorry the DROP TABLE Should be TEMP not table1 -Original Message- From: Gordon Bruce [mailto:[EMAIL PROTECTED] Sent: Friday, December 09, 2005 3:51 PM To: Sachin Bhugra; mysql@lists.mysql.com Cc: [EMAIL PROTECTED] Subject: RE: copying data!!! This is kind of ugly

Re: Duplicate Insert Crashes Client

the 'CREATE' statement for you table and sample data. Provide information about operating system and MySQL version. Bruce Martin wrote: Hello again, Ok new problem. If for some reason, my client tries to INSERT something to the database that is identical to a record already there, my

Re: Background tasks performed by MySQL?

of what's doing what at the time and will give you some idea on where to look. Best Regards, Bruce On Nov 15, 2005, at 2:20 AM, Viktor Fougstedt wrote: Hi. We have a MySQLd with both MyISAM and InnoDB tables that at uneven intervals stops responding correctly to connections. At all times

Duplicate Insert Crashes Client

Hello again, Ok new problem. If for some reason, my client tries to INSERT something to the database that is identical to a record already there, my client crashes. Is there an error I can trap for this? The DB does insert the new record. Bruce Martin The Martin Solution PO Box 644 Delaware

Re: mysql_init(m) changes values of variables

Ok I have an update. I fixed my problem by passing a NULL parameter to mysql_init() to do this I did this: MYSQL *m; m=mysql_init(NULL); connection=mysql_real_connect(m,cStrdbServer,cStrdbUser,cStrdbUserPass,c StrdbName,0,NULL,0); On Nov 12, 2005, at 7:44 PM, Bruce Martin wrote: Hello all

mysql_init(m) changes values of variables

first set it up the length is 23 which is correct. I then call mysql_init(m), then I check the length again, well the value of the int I set earlier, and it is 0. What's the deal? why would mysql_init() change the value of my int? Bruce Martin The Martin Solution PO Box 644 Delaware Water Gap

Re: libmysqld as shared library

quite desperate at the moment because our first demo is due next week What am I doing wrong? Regards, Peter -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Bruce Martin The Martin Solution PO Box 644

RE: Format for saving date field.

What is the source of the data that is displayed on the screen. If it is a field in a MySQL table and the data type for that field is either DATE or DATETIME then it will intsert/update without any manipulation. Try doing a SELECT datefield FROM table Limit 15; outside of your ASP.NET

RE: Query producing default values

Try this {I wasn't sure whether cd_nature_ltr is in ligne_trans or transaction. This assumes ligne_trans. If it is in transaction thatn move cd_nature_ltrsn = 2 into the ON clause.} SELECT CASE id_ltrsn WHEN NULL THEN 0 ELSE id_ltsrn END AS id_ltrsn, CASE

RE: Help optimize this simple find

Is it possible to change the geocodes table to look like CREATE TABLE `geocodes` ( `ip` int(10) unsigned zerofill NOT NULL default '00', `lat` double default NULL, `lon` double default NULL, PRIMARY KEY (`ip`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; Then you could do

Re: Add New User

for the help. On Nov 6, 2005, at 12:23 AM, Michael Stassen wrote: Bruce Martin wrote: When I log in as root using: mysql -u root -p mysql I get the mysql prompt: mysql I then issue this command or statement: mysqlGRANT ALL PRIVILEGES ON *.* TO 'testUser'@'' IDENTIFIED BY 'some_password

Re: Add New User

Ok thank you, I think I have it now. Now to get my Client application working. On Nov 6, 2005, at 1:16 PM, Björn Persson wrote: söndagen den 6 november 2005 18:39 skrev Bruce Martin: However, even though I specified 'test.*' my test user can access the mysql database. That's because

Sub Selects, Alias Names and stored procedures

After reading one of the recent posts from Gobi [EMAIL PROTECTED] I took his successful query and modified it for one of my tables. It indeed produce the correct result, but in the process raised some questions. 1. Why do list_ID and acct_ID not have to be qualified with a table name

RE: SQL Statement Conversion

If your MySQL server is a *nix system than table names are case sensitive. SELECT A.*, CASE CounselorOnly WHEN 1 THEN 'Yes' WHEN 0 THEN 'No' END AS CO FROM Activities A ORDER BY Activity I also just noticed, remove the CO = and add AS CO following the END of

Add New User

) Why is this not working? To test it further I try to log in as testUser but it tells me access denied for user [EMAIL PROTECTED] Even if I grant the testUser @ localhost. I can look in the user table and sure enough user [EMAIL PROTECTED] is there. Bruce Martin The Martin Solution PO Box 644

Re: Help starting mysql

should be OK. Bruce Ferrell Logg, Connie A. wrote: I have installed the following rpm's for mysql on my node [EMAIL PROTECTED] mysql]# rpm -qa | grep -i mysql MySQL-client-standard-5.0.15-0.rhel4 MySQL-server-standard-5.0.15-0.rhel4 MySQL-shared-standard-5.0.15-0.rhel4 MySQL-devel-standard-5.0.15-0

Permissions for the install

What should the permissions be for the MySQL 5 install on Mac OS X. By default it was Owner = System Group = wheel. Could someone give me a list of directories and what owner:group settings I should have? Bruce Martin The Martin Solution PO Box 644 Delaware Water Gap, PA (570) 421-0670

mysql_library_init()

, char **groups) Can someone explain what the 3 parameters are and what they need for info? The docs are a bit light on this subject and it says it is synonym for the mysql_server_init() function, but that function is not listed and is not linked to in the on-line docs. Bruce Martin The Martin

Trouble running mysql_install_db

mail us, you MUST use the ./bin/mysqlbug script! I then checked the permissions for the /usr/local/mysql/data/ directory and it shows: drwxr-x--- 13 mysql wheel What am I missing? I installed MySQL using the installer package. Bruce Martin The Martin Solution PO Box 644 Delaware Water Gap

MySQL for a single user

. Thanks much, Bruce Rollier -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

<    1   2   3   4   5   6   >