Re: Where is mysql-workbench SCM?

2015-10-16 Thread Karl-Philipp Richter
Found it (after some days of searching): https://code.launchpad.net/ubuntu/+source/mysql-workbench must be the official repository according to https://dev.mysql.com/doc/refman/5.7/en/installing-development-tree.html. -Kalle Am 15.10.2015 um 22:11 schrieb Karl-Philipp Richter: > Hi, > Th

Where is mysql-workbench SCM?

2015-10-15 Thread Karl-Philipp Richter
Hi, The only list of mysql-related SCM repositories I found was https://github.com/mysql which didn't contain a repository for `mysql-workbench`. I only found the source tarball at http://dev.mysql.com/downloads/workbench/. The development section at http://dev.mysql.com/downloads/workbench/ doesn'

From DATE_FORMAT and back to origin date in mysql date column

2013-07-24 Thread Karl-Arne Gjersøyen
the origin date format in WHERE dato >= '$standard_date_format'; What need I do to fix this? Thanks for your time and help to learn me programming! Karl

Setting up version 5

2006-12-18 Thread Karl Larsen
Is there a paper I can d/l that covers intalling MYSQL on Red Hat Linux? Karl Larsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

How a VIEW is stored

2006-08-26 Thread Karl Larsen
other VIEW. Karl Larsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

First View

2006-08-24 Thread Karl Larsen
I wrote my first VIEW in version 5 and it works just fine. It will be a powerful way to generate output for the Bosses. Why it was taken out on version 4 I have no idea. Karl Larsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Help Thanks!

2006-08-21 Thread Karl Larsen
e the Reference Manual in Info form will allow me to correct these. For some reason unknown $ mysqladmin -U make new password for root doesn't work. and I can't get other things to work until I get this fixed. But the work is for tomorrow. I'm 71 years old and yes I am slowing

Punt Worked

2006-08-21 Thread Karl Larsen
s now running. None of the above is in the referance manual. It's no wonder very few ever use mysql... Karl Larsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Back up and punt

2006-08-21 Thread Karl Larsen
s for root and k5di.com. Let you all know how this works out. Karl Larsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Become mysql user

2006-08-21 Thread Karl Larsen
I think I need to su - mysql and it askes for a password. What is that password? Karl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Can't get mysqld to run

2006-08-21 Thread Karl Larsen
out saying it can't use the /var/run/mysald/mysqld.pid file. This is because there is no mysqld.pid in that directory. The directory has root permissions. What have I done wrong? Karl Larsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Getting 5 to run

2006-08-20 Thread Karl Larsen
am doing wrong? I'm just following the info instructions. Karl Larsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Query

2006-08-04 Thread Karl Larsen
with Fedora Core 4. Has anyone got mysql version 5 to work on my version of Linux? Karl Larsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

yum version 5.*

2006-07-26 Thread Karl Larsen
could not see a way to do that. Karl Larsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

CREATE VIEW xxxx

2006-07-17 Thread Karl Larsen
I'm using mysql on Linux and all is going well but I can't find the proper way to write a CREATE VIEW. I'm using 4.1 and is this function still in mysql? Karl Larsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://

log

2006-07-11 Thread Karl Larsen
I have found that \T /home/karl/sql_log will cause evcrything I do to be saved in the file sql_log. Alas if I turn off mysql as I do daily, the log is lost and I have to do it again. Is there a way to get a log like this to be perminant :-) Karl Larsen -- MySQL General Mailing List

Money

2006-07-04 Thread Karl Larsen
s like money. I have not yet found how I can put a $ in front of all the money columns :-) But to date I have become real pleased with mysql and all the SQL I learned from using Oracle works fine. Karl Larsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysq

Re: PostgreSQL or mySQL

2006-07-03 Thread Karl Larsen
this is a fine comparison and worth reading. Karl Larsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Bookbiz DB

2006-06-29 Thread Karl Larsen
read this it is obvious what is going to happen. When you have multiple SELECT and get an output from several tables you see the power of SQL. Karl Larsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

How to get bookbiz.sql

2006-06-28 Thread Karl Larsen
nd d/l it. To do this go to www.zianet.com/k5di/ and part way down the page where you see MySQL just click on bookbiz and it will d/l to your computer. If you don't have the book look in used book stores. Karl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: multi-column indexes on InnoDB tables

2006-06-27 Thread Karl Larsen
x or Max. Since we know nothing about this there is no answer. Please tell us what operating system your using. For example the Linux EXT3 file system is very tolerant of sudden power failures. Karl You can't just randomly take a bunch of abrupt power failures without a UPS system and

Re: mysqld refuses to run on boot

2006-06-25 Thread Karl Larsen
Karl Larsen wrote: Duncan Hill wrote: On Saturday 24 June 2006 12:49, Karl Larsen wrote: Hi Joerg, I'm using Ferdora Core 4 of Red Hat and I have in /etc/rc.d/init/ a file mysqld which when I use ./mysqld start does start the system. But it has to be done every time I turn o

Re: QUERY

2006-06-24 Thread Karl Larsen
John Hicks wrote: Karl Larsen wrote: I and a friend have written SQL to big Oracle DB but not much to MySQL on our own computers. I find that there is a QUERY in the list for MySQL but it does nothing much. Also I was glancing through the mamouth MySQL reference manual and saw there are a

Re: mysqld refuses to run on boot

2006-06-24 Thread Karl Larsen
Duncan Hill wrote: On Saturday 24 June 2006 12:49, Karl Larsen wrote: Hi Joerg, I'm using Ferdora Core 4 of Red Hat and I have in /etc/rc.d/init/ a file mysqld which when I use ./mysqld start does start the system. But it has to be done every time I turn on the computer. I d

Re: mysqld refuses to run on boot

2006-06-24 Thread Karl Larsen
ld which when I use ./mysqld start does start the system. But it has to be done every time I turn on the computer. I do not understand your patch. I can't find what I think is where you want to put one line of code. The other lines do not exist. Or I don't know what I.m doing :-) Karl

Re: Math problem

2006-06-23 Thread Karl Larsen
Well that works fine, but I want to put a $ sign in front of every dollar amount. I will do that but I'm not there yet. Karl C.R.Vegelin wrote: Hi Karl, Your question: can I add a $ when you select a view. I suggest to include $ sign in the field alias, like: Select title_id, ytd_

Re: Autoindexing

2006-06-23 Thread Karl Larsen
Hi Remo, your method works fine on version 4.1 and the one shown for version 5 does not work here. Nice to know there is a SQL word AUTO_INCREMENT to do the job. Karl Remo Tex wrote: If you are using autoincrement filed you could try this: ALTER TABLE `my_database`.`my_table

Re: Exclusion Query

2006-06-22 Thread Karl Larsen
DX_Coded_RES is your table. I would do this: SELECT * FROM tbl_IDX_Coded_RES WHERE tbl_IDX_Coded_RES.StreetNumDisplay AND != (select status.fld_house_number from status where (fld_file_number like 'L0%') and (fld_archived = '0')); Karl -- MySQL General Mailing List For list a

Re: Importing large data sets

2006-06-22 Thread Karl Larsen
ta into a table. Well you need to design a table that has columns for each set of data your entering, and then you will use a INSERT INTO file_name VALUE ( your data ); and your going to need to change all those " to '. In Linux I use the joe editor and it's a simple matter to change all " to '. Karl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Math problem

2006-06-22 Thread Karl Larsen
Chris W wrote: Karl Larsen wrote: I'm trying to multiply numbers one of which is money. The money looks like this: SELECT price FROM titles; | price | ++ | $20.00 | | $19.99 | | $7.99 | | $19.99 | | $11.95 | | $19.99 | | $14.99 | | $11.95 | | $22.95 | | $2.99 | | $

Math problem

2006-06-22 Thread Karl Larsen
other number. Has anyone else seen this problem? Karl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

The Practical SQL Handbook

2006-06-21 Thread Karl Larsen
done. It loads with just a couple of warnings on my version 4.1.10. 73 Karl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Copy database to a file

2006-06-20 Thread Karl Larsen
I have been reading the Reference and saw how to convert my database tables and stuff to the words that made them and puts it into a file. But now I need it I can't find it. If you know how please send along how or a page(s) in the Reference. Karl -- MySQL General Mailing Lis

QUERY

2006-06-19 Thread Karl Larsen
of the interpreter and one has in it's title query. It seems this software will do a job like the Oracle QUERY. I have not verified this but hope to do so soon. If anyone on this list has done serious QUERY with MySQL I would sure like to know how you did it. Karl Larsen --

localhost

2006-06-16 Thread Karl Larsen
DB and every time I get ERROR 1044 and so of course I can't use mysql. Does anyone know what error I have made? I loaded mysql from the Linux version I'm using and had the problem. I then deleted all and yum got the latest version which is up now. Karl Larsen -- MySQL Ge

report of last transaction?

2006-05-30 Thread Karl Berry
f there is nothing at the database level, of course I can (attempt to) keep track in my application and report it that way. I just thought it would be easier and more reliable to get the info from the db, if it's available. Thanks, Karl ([EMAIL PROTECTED]) -- MySQL General Mailin

Re: How can I observe mysqld?

2006-03-08 Thread Karl Schock
eant to confuse clueless people like me. ;-) > SHOW FULL PROCESSLIST - to get a list of running proceses ( SELECT, INSERT, > UPDATE, CREATE ... ) in *every* database - now I see it because I caused a little bit traffic in two databases and mytop shows all processes in all databases.

RE: How can I observe mysqld?

2006-03-08 Thread Karl Schock
ore than one database at once with mytop? I read the mytop-documentation and tried "mytop -d", "mytop -d db1 -d db2" and "mytop -d db1,db2" but it didn't work. Bye Karl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How can I observe mysqld?

2006-03-07 Thread Karl Schock
ry "--log-everything". ;-) > Also try lowering the timeouts for connections... The value is 5 at the moment. I will lower it. Thank you. Bye Karl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How can I observe mysqld?

2006-03-07 Thread Karl Schock
at the "connect failed" even phpmyadmin doesn't work anymore. Do you know programs like tcpdump to monitor a network interface or top to watch the processes on a linux host? Is there a similar program to observe mysqld? I would like to use it. Or can I do that with phpmyadmin but I

Re: How can I observe mysqld?

2006-03-07 Thread Karl Schock
Hello, > how can I see the value of max-connections I found it in phpmyadmin. It is 100. > Can I set max-connections? If so: where can I set it? In /etc/my.cnf? I found the answer in the mysql-documentation. RTFM I know. ;-) Bye Karl -- MySQL General Mailing List For list archives

Re: How can I observe mysqld?

2006-03-07 Thread Karl Schock
27;t and I think the server is not very busy all the day. It is only a small forum with usually 5 to 10 visitors at the same time. "mysqladmin status" says "Queries per second avg: 0.7" for example. I think that is not very much or is it? > and what happens after the circl

How can I observe mysqld?

2006-03-07 Thread Karl Schock
a log-file, but as far as I can judge it there are no error-messages in the log-file but only innocent queries. The mysqld.err-log-file is allways empty (0 Bytes). What else can I do to observe myslqd? If this mailing list is not the right place to ask such questions please let me know. Bye K

CHAR vs TEXT and fast Row Updates

2006-01-17 Thread Karl Pielorz
s it not that 'clever'? I realise the savings from the above could be fairly small, but when you're processing thousands of updates an hour, it all adds up - if we can have MySQL doing 'less work' for the updates. Thanks in advance, -Karl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

doubled words in 5.0.17 manual

2005-12-28 Thread karl
If you result result or a temporary table with an index for larger results. contents seen each time the the statement is executed later will >How-To-Repeat: dw Fix: >Submitter-Id: >Originator:Karl Berry >Organization: >MySQL support: none >Synopsis

Re: Error 1013

2005-12-17 Thread Karl Krelove
David Logan wrote: Karl Krelove wrote: I'm trying to import a large amount of data from an Access database containing information about 9,000+ students in a school system. I've created a table 'student_list' to hold the data and issued the following command: LOAD DA

Error 1013

2005-12-16 Thread Karl Krelove
I'm trying to import a large amount of data from an Access database containing information about 9,000+ students in a school system. I've created a table 'student_list' to hold the data and issued the following command: LOAD DATA INFILE 'home/karl/Student_List.csv

query mysql fulltext index

2005-10-04 Thread Karl Prinz
e would be extremly helpfull generating context sensitive select boxes or select boxes with a little bit of artificial intelligence. Best regards Dr. Karl Prinz SCREAMDESIGN GmbH Häberlstraße 21 D-80337 München Tel.: +49 89 550599 80 Fax: +49 89 550599 79 http://www.screamdesign.de -- MyS

testing

2004-09-28 Thread Karl James
Testing Karl James (TheSaint) [EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]> http://theufl.com/<http://theufl.com/>

need voluntary help regarding project

2004-09-23 Thread karl james
l.com/ufl_project.htm Karl James (TheSaint) [EMAIL PROTECTED] http://theufl.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How to get the last record from the slected record set

2004-08-23 Thread Karl Pielorz
--On 22 August 2004 21:05 +0800 Manisha Sathe <[EMAIL PROTECTED]> wrote: I want to select first 10 records out of 100. And then get the 10th position. If i make use of order by score asc limit 1 then I will get 100th record, How shall i pick up 10th position? I'm not quite sure I follow what you

Re: How to get the last record from the slected record set

2004-08-23 Thread Karl Pielorz
--On 22 August 2004 20:31 +0800 Manisha Sathe <[EMAIL PROTECTED]> wrote: I am having more than 10 records in a table. I want to select only first top 10 records (depending on one field score) and then want to select 10th position record. select * from table1 order by score desc LIMIT 10 This wil

Language Searching

2004-08-14 Thread Karl Timmermann
Hi, Does anyone how I could accomplish this: Basically, I have a MySQL database of names - some names have Spanish accents in them. I want to build a web interface in PHP to search this database. However, I want the names with Spanish accents to be shown in the search results, regardless if the sea

RE: SQL Syntax Question

2004-08-04 Thread Karl-Heinz Schulz
Event 2 Details 1 for event 2 Details 2 for event 2 Details 3 for event 2 Is this even possible? TIA -Original Message- From: Philippe Poelvoorde [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 04, 2004 5:52 AM To: Karl-Heinz Schulz Cc: [EMAIL PROTECTED] Subject: Re: SQL Syntax

RE: SQL Syntax Question

2004-08-04 Thread Karl-Heinz Schulz
event 1 But not what I need Event 1 Details 1 for event 1 Details 2 for event 1 Details 3 for event 1 Event 2 Details 1 for event 2 Details 2 for event 2 Details 3 for event 2 -Original Message- From: Rhino [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 04, 2004 12:08 AM To: Karl

SQL Syntax Question

2004-08-03 Thread Karl-Heinz Schulz
h_row($eventdetail_query)){ print("".html_decode($eventdetail[0]).""); print(" ".html_decode($eventdetail[1]).""); print("".html_decode($eventdetail[2]).""); } } ?>

convert

2004-02-07 Thread karl james
Hey guys, I was wondering if there is a converter for access databases to mysql or phpmyadmin I downloaded some stats files for my football league, but they are in access, Anyway I can convert them? Karl James (TheSaint) [EMAIL PROTECTED] http://theufl.com/ -- MySQL General Mailing List

Login scripts

2004-01-22 Thread karl james
intested in helping me out? Please email me directly Karl James [EMAIL PROTECTED] http://theufl.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

test

2004-01-18 Thread karl james
test Karl James [EMAIL PROTECTED] http://theufl.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

test

2003-12-03 Thread karl james
test Karl James [EMAIL PROTECTED] http://www.theufl.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

read (Off subject Help) ACCESS!!

2003-12-01 Thread karl james
Does anyone use Microsoft access? I need help with creating a query that will delete records, If you can help me please email me directly! Karl James [EMAIL PROTECTED] http://www.theufl.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

read: Off subject regarding the mysql list!

2003-12-01 Thread karl james
mysql list! Your help would greatly be apprectiated, please email if you can help!!! Karl James [EMAIL PROTECTED] http://www.theufl.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

OT: Congratulation

2003-08-01 Thread Andreas Karl Wittwer
Hi, Congratulation to MySQL for a two pages article published by the leading business journal in Germany (Wirtschaftswoche). Sorry, no online resource available only a headline http://www.wiwo.de (German language) sql, mysql Andreas Karl Wittwer I'm not related to wiwo in any case, j

problems with mysql thru command line

2003-07-31 Thread karl james
Hello guys, Im kinda new at creating databases thru the command line When I try to login using. Mysql -h hostname -username -p I get this message on command line. C:\Documents and Settings\Karl James>mysql -h hostname -u username -p -p; 'mysql' is not a recognized as a interna

Re: Date query optimization

2003-07-01 Thread Karl J. Stubsjoen
any results. Must I convert the field first? But then is my query unoptimized? Should I consider storing date parts into my database; seperate column for year - month - date and (time parts..) Karl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Date query optimization

2003-07-01 Thread Karl J. Stubsjoen
also be searching for a range of dates (as in the commented out "and" clause above). Is the to_days function faster than these date functions, or have any effect whatsoever? Thanks for the help. Karl -- MySQL General Mailing List For list archives: http://lists.mysql.com/m

Re: Strange "Mull" in show fields and table keeps crashing

2003-06-25 Thread Karl J. Stubsjoen
I'm not sure what errors are being reported to the server. I'm not sure how to get those. I am not local to the box. Is there a way to look at the log files without being at the box? Karl - Original Message - From: "Victor Pendleton" <[EMAIL PROTECTED]&g

Strange "Mull" in show fields and table keeps crashing

2003-06-24 Thread Karl J. Stubsjoen
1/2 dozen times or so... and copied/renamed about 4 of the columns as they took on this "MUL" characteristic. Any ideas how to fix this problem? Any ideas what is going on? Here is my version of MySQL: Server version: 4.0.0-alpha Karl -- MySQL General Mailing List For list archives

Group by and Count query

2003-06-11 Thread Karl J. Stubsjoen
. (nothing distinct about the result of a count) select distinct count(host) from TABLE_HOST where path_a='' So, is it possible to perform this query? Karl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: mysqladmin -u root -h myhost password 'new-password' fails

2003-03-26 Thread Karl Berry
know enough to even guess what the underlying problem might be. Thanks, karl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysqladmin -u root -h myhost password 'new-password' fails

2003-03-25 Thread karl
ECTED] with set password. But the point is that the mysql_install_db script is telling me to do something that doesn't work. Any help appreciated ... >How-To-Repeat: ... follow INSTALL-BINARY instructions and: ... root# mysqladmin -u root -h tug.org password mynewpassword mysqladmin: unable to

sql,query

2003-03-21 Thread Karl James
? Thanks Karl ultimatefootballleague.com/index.php [EMAIL PROTECTED] ultimatefootballleague.com/index.php [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

[help] with browsing table?

2003-03-03 Thread Karl James
why am i not able to select the browse link on mysql phpmyadmin to view my table ultimatefootballleague.com/index.php [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) h

BUG: Format function fails when query ordered

2003-02-24 Thread Karl Stubsjoen
dered. In the first example, the format function indeed works, but not in the 2nd. Is this indeed a bug, or something I am doing wrong? MySQL Version: 4.0.0-alpha Karl - Before posting, please check: http://www.mysq

RE: Generating an automatic e-mail via MySQL

2003-02-12 Thread Karl Dyson
$z"; } $sth->finish; open(MAIL,"|sendmail $recipients") || die "cannot open sendmail\n"; print MAIL "To: $recipients\n"; print MAIL "From: My_Script\n"; print MAIL "Subject: $subject\n"; print MAIL "\n"; print MAIL @m

RE: Percentile calculations

2003-02-09 Thread Karl Dyson
); Thanks for all help supplied, Karl -Original Message- From: Adam Nelson [mailto:[EMAIL PROTECTED]] Sent: 05 February 2003 18:32 To: 'Benjamin Pflugmann'; Karl Dyson Cc: [EMAIL PROTECTED] Subject: RE: Percentile calculations I believe you can do: select avg(scantime) from pe

Percentile calculations

2003-01-31 Thread Karl Dyson
ed to do on the data specified by is easily accomplished by a sum(processingtime) and avg(processingtime) -- I guess I was basically looking for perc(processingtime,95) or something, but don't appear to be able to fine it! Thanks in advance for any help/suggestions

ADODB XML Update Recordset

2002-12-14 Thread Karl Stubsjoen
Has anyone any luck performing batch update with a persisted ADO XML recordset? I'm trying to save data from one MySQL server and then upload/insert to another. I'm trying to get these persisted XML recordsets to work, but having no luck. Any id

Help downgrading

2002-10-15 Thread Karl Stubsjoen
Hello, Any help downgrading my MySQL Server from 4.0.0.0ALPHA to 3.23 would be a huge help. I'm not sure where to start. Do I need to save records to a flat file and then reimport them? Karl - Before posting, please

RE: Flakey Updates

2002-10-15 Thread Karl Stubsjoen
taken owner of this box, and are discovering this now. What are the steps to downgrade to this stable production version? Thank you, Karl -Original Message- From: Keith C. Ivey [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 9:52 AM To: [EMAIL PROTECTED] Cc: Karl Stubsjoen Subj

Flakey Updates

2002-10-15 Thread Karl Stubsjoen
x27;m going to be upgrading MySQL (I know it isn't current). Any ideas? Karl - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)

How to retrieve "Insert Into Select From" records effected

2002-09-08 Thread Karl J. Stubsjoen
there a way to capture this error, or look up a list of errors for the last SQL command. Thanks, Karl - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (t

Request for help - Table Crashing

2002-08-31 Thread Karl J. Stubsjoen
ell as the pertinent hardware/software supporting my DB. I'm wondering if the problem might be with the FullText indexes? Please Advise. Karl TABLE STRUCTURE: # MySQL dump 8.16 # # Host:Databas

My Table Crashes Frequently

2002-08-30 Thread Karl Stubsjoen
d uses ADO / SQL via the MYSql ODBC. I've included the structure of the table below. Thanks for the help!! Karl CREATE TABLE submit ( submitid int(11) NOT NULL auto_increment, name varchar(50) default '', title varchar(80) NOT NULL default '', url varchar(100) NOT

Can't build MySQL-3.23.52 with GCC 3.2 on Solaris 7

2002-08-21 Thread Karl A. Anderson
ke[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/opt/local/src/mysql-3.23.52' make: *** [all-recursive-am] Error 2 Does anyone have a clue what the problem is? Karl Anderson Computer Sciences Corporation, under contract to U.S. EPA --

RE: Help with Insert.. Select From... Query

2002-07-15 Thread Karl Stubsjoen
] Subject: Re: Help with Insert.. Select From... Query On Sun, 2002-07-14 at 03:59, karl wrote: > Hello, > I need help. I am trying to insert into TABLEA records from TABLEB where the records do not exist in TABLEA (the primary key in TABLEA works fine). I am trying to limit the result se

Updates

2002-07-13 Thread karl
using script to step painlessly through the tables record for record to apply HOLDS on records. Any good ideas? Karl - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Help with Insert.. Select From... Query

2002-07-13 Thread karl
ed from. I thought a complex left join would do the trick, but it seems that you are not able to perform a query of this sort when doing an insert into... select from.. I've included this code, along with the error produced. If you have any ideas, please shoot them my way! Thanks, Karl insert

Distribute MySQL with VB App

2001-12-14 Thread Karl J. Stubsjoen
Hello, Is it possible to distribute a MySQL db with a visual basic application - in other words, use MySQL as the backend DB for a Visual Basic app? Karl Stubsjoen www.excelbus.com/info-m - Before posting, please check

possible bug?

2001-12-14 Thread Karl J. Stubsjoen
database,sql,query,table Hello, Where is the correct place/procedure to report a possible bug? I think I found one. Karl Karl Stubsjoen excelbus.com/info-m - Before posting, please check: http://www.mysql.com/manual.php

Hang???

2001-12-10 Thread Karl Stubsjoen
for awhile until the command is finished, at that time you get a prompt again). Thanks! Karl www.excelbus.com/info-m ..opportunity knocking.. - Before posting, please check: http://www.mysql.com/manual.php (the manua

Kill Thread

2001-12-10 Thread Karl J. Stubsjoen
out of view in my little Win98 dos window when I issue: Show Processlist. So, any suggestions? We are running mysql on a linux server (ver 4.0???) and connect from a Win98 MySql emulation. Thanks Karl www.excelbus.com ..op

Re: Running queries while queries are still running

2001-11-30 Thread Karl Uscroft
Please show us your Perl code and then we can have a look and try to find what is wrong, Cheers Karl. - Original Message - From: "Ken Kinder" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 30, 2001 10:25 PM Subject: Running queries while que

Rename a database

2001-11-24 Thread Karl Uscroft
;s done in MySQL but that's how I do it. PS I've no idea about Unix and the like. Karl. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

How do I count using two tables

2001-11-22 Thread Karl Uscroft
and 4 but not giving 2 and 3 were I want 1,2,3,4.100. Please help, sorry if this is kids stuff but I'm only just starting with MySQL. Cheers Karl. - Before posting, please check: http://www.mysql.com/manual.ph

RE: Delete Match Against

2001-11-21 Thread Karl J. Stubsjoen
"Wooohooo! that is the first bug i ever found!" Do I get any points : ) Karl www.excelbus.com ..opportunity knocking.. -Original Message- From: Sergei Golubchik [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 21, 2001 6:33 AM To: Karl J. Stubsjoen Cc: MySql list S

Delete Match Against

2001-11-20 Thread Karl J. Stubsjoen
ommand, no records are deleted. Is there a limitation to issuing the delete command with the Match and Against syntax in a where clause? Thank you! Karl - Before posting, please check: http://www.mysql.com/manual.php (the manua

Lock Table for new index?

2001-11-13 Thread Karl J. Stubsjoen
Hello, I have a fairly active and large DB. I need to create a new index on a column. It will take (just guessing) 15-30 minutes for the entire creation. I've got different people hittiing this table all the time, mostly with new inserts (not really any updates). My question is: Can I create

Hash Tables / Indexes

2001-11-12 Thread Karl J. Stubsjoen
Hello, Can someone explain hash tables or hash indexes and if we can take advantage of them in MySQL? Thanks! Karl - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Search Engines

2001-11-12 Thread Karl J. Stubsjoen
text fields. Any ideas about where I can look to set up a database optimized for searching in this way? Thanks, Karl - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

  1   2   >