Re: table conversion problems

Sergei Skarupo wrote: Hi Donny, Thanks for your reply. This table only uses ints and floats, but the floats are allowed to be null, which means, as far as I understand, that it's not a fixed row length... What makes you think that? VARCHAR, TEXT, and BLOB are the variable-length column types

Re: another newb question for you help...

- Original Message - From: "B Wiley Snyder" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 26, 2004 10:31 PM Subject: another newb question for you help... > Hi again, I'm inserting some test products into my new mysql database but > it only lets me enter so much? I

RE: table conversion problems

Hi Donny, Thanks for your reply. This table only uses ints and floats, but the floats are allowed to be null, which means, as far as I understand, that it's not a fixed row length... By the way, Paul DuBois writes about the 4G limit in MySQL, second edition, and does not mention that fixed r

another newb question for you help...

Hi again, I'm inserting some test products into my new mysql database but it only lets me enter so much? I thought BLOB would allow alot more characters? Anyway, this was how I constructed the database. CREATE TABLE jspCart_products ( ProductID int primary key, CategoryID int, ModelNumber va

RE: table conversion problems

Sergei, I don't know much about innodb, but myisam doesn't have a 4 gig limit unless you are using a dynamic type of table. If you are using a fixed table which is by using int, char, etc... Not text, varchar, blobs. As long as you don't use the last ones, you don't have a 4 gig limit. As far

table conversion problems

Hi all, Started a conversion from MyISAM to InnoDB; it's been almost two days and the statement is still executing... The (MyISAM) data table size is almost 4G. There were two reasons for this conversion: to start supporting transactions and to avoid the 4G limit of MyISAM tables; this tabl

RE: Slow Queries on Fast Server?

John, >From my experience it is a lot more on how big is your data, not necessarily the amount of data. Which version of mysql are you running? Are you using a mysql prepared version (you downloaded it from mysql.com). I'm using 4.1.3 and I have a table that has a char 68 with 29 million rows th

Re: Brainstorming' time! (export to excel via java)

As for programming skills, I'm pretty familiar with Java so I feel sure I could write a suitable utility with that. In fact, unless I had a really urgent need, I would prefer to write my own stuff just because I like writing code If you wanted to go the java route I suggest checking out http://jdb

RE: 4.1.3 and prepared statements

Looks like my attachment did not make it to the post. So here's the code in question - any thoughts?: #include #include #include #include #include "mysql.h" using namespace std; int main(int argc, char *argv[]) { cout << "start up" << endl; MYSQL * connection; connection = mysql

DBI and Mysql error 2006

Hi there, I'm having a problem with MySQL within a Perl::DBI usage. I've turned it upside-down and cannot find what it's related to. My Perl script creates multiple databases and populates them with tables. The problem appears when creating the second database (in the foreach statement): # # Get

4.1.3 and prepared statements

Title: 4.1.3 and prepared statements Hi all- Is the MySQL C API for prepared statements working at all in 4.1.3?  I'm trying to do a relatively simple select test, and I consistently get an error on execute = "MySQL client run out of memory".  But it's a singleton select of one column and th

Update Questions

Greetings All. I am currently running 3.23.14alpha and have just downloaded the 4.0.20 binary version. I am running under the Slackware Distribution of Linux. I have a variety of PHP related things running currently. Without destroying the current databases and the current tables under the my

huge innodb data files

Our DB in production currently has 2 innodb data files, the second one (which is marked autoextend) has now grown past 26 gigs. We are experiencing weird speed problems with one of the tables. Even though there are no rows in this table, performing any kind of select takes about 2 minutes to exec

Re: Sanity Check : Error in sql

Okay ..got to be looking for id's with string, not numerics. Case closed. Oi Stuart --- Stuart Felenstein <[EMAIL PROTECTED]> wrote: > I'm running into a problem here where mySQL is > saying > unknown column. > Education_table > TypeID Type > HS High School > CO College > M

Re: Sanity Check : Error in sql

Stuart Felenstein wrote: SQL: Select * from Education_table (and no the table is not named table) From: TypeID = Value , Type = Label Choose High School Error Msg: Unknown column 'HS' in 'field list' You need to show the exact SQL statement that you're sending. Obviously "SELECT * FROM Educa

RE: Sanity Check : Error in sql

From: Stuart Felenstein [mailto:[EMAIL PROTECTED] > I'm running into a problem here where mySQL is saying > unknown column. > Education_table > TypeID Type > HS High School > CO College > MA Masters > > SQL: > Select * from Education_table (and no the table is not >

Re: Template

How many places have you looked? I would use a search engine (Google, Yahoo, etc) and try various combinations of terms like "PHP", "Samples", "Production", "Source code", "sample", and so on. I would keep searching until I felt confident that: a) nobody else has posted any code for a series o

Sanity Check : Error in sql

I'm running into a problem here where mySQL is saying unknown column. Education_table TypeID Type HS High School CO College MA Masters SQL: Select * from Education_table (and no the table is not named table) From: TypeID = Value , Type = Label Choose High School Error

SELECT from two tables with condition

Hi! I have got two tables: 'item' and 'propertie'. Table 'item' has index column named 'id_propertie' which refers to one row in table 'propertie'. Table 'propertie' has string column 'value'. I want to get the value of colun 'value' from table 'propertie' which index is same than in table 'item

MySQL C API Examples

I have arranged some MySQL C API examples at http://www.geocities.com/jahan.geo/mysql_c_by_example.html Comments/ Suggestion welcome. -- Aftab Jahan Subedar CEO/Software Engineer Subedar Technologies Subedar Baag Bibir Bagicha #1 North Jatrabari Dhaka 1204 Bangladesh http://www.SubedarTechnologies

Re: Template

- Original Message - From: "Scott Hamm" <[EMAIL PROTECTED]> To: "'Mysql ' (E-mail)" <[EMAIL PROTECTED]> Sent: Thursday, August 26, 2004 2:37 PM Subject: Template > I finally got Php/MySQL/Apache all set on Windows 2000 professional > workstation. I'm looking for various php templates th

Template

I finally got Php/MySQL/Apache all set on Windows 2000 professional workstation. I'm looking for various php templates that keeps track of associates, quantity produced, hours for each quantity produced and so on. Is there such a template out there on the web that I can use? TIA, Scott -- MySQL

Re: Mysql command line queries not working....

OK, more debugging, and this is what I have come up with The latest_distribution.sql file was NOT created via a mysqldump, but rather via phpmyadmin export... The comments from phpmyadmin are denoted with the '#' character The comments from a true mysqldump are denoted with the '--' char

MySQL 4.0.18/Dual AMD64 thread zombie even when wait_timeout is set to 60 seconds! Bug?

Hi guys, We have a problem with Dual AMD64 Opteron/MySQL 4.0.18/Mandrake 10 for a very high volume site. We are evaluating the performance on our new server AMD64 and it seems it's slow compared to Dual Xeon/MySQL 4.0.15/RedHat8 and Dual Xeon/MySQL 4.0.18/Mandrake 10. And it seems there are zomb

RE: Mysql command line queries not working....

Can you run this from inside the monitor and see if any messages are sent to the consol? \. latest_distribution.sql -Original Message- From: Mike Morton To: [EMAIL PROTECTED] Sent: 8/26/04 12:05 PM Subject: Mysql command line queries not working I know the subject is not totally desc

Mysql command line queries not working....

I know the subject is not totally descriptive of the problem, but: mysql -h -u *** -p*** mikerocks < latest_distribution.sql Is producing no results. I mean none, totally, no errors, nothing. The host, user and pass are all correct (of course removed here for security ;) ) and have the

Re: Correct date query syntax

I believe you are not letting MySQL do enough work for you. The date format is perfect, even as a string, to perform the comparison you are trying to perform. SELECT @currTime := NOW(); +-+ | @currTime := NOW() | +-+ | 2004-08-26 12:48:16 | +

Re: Correct date query syntax

On Thu, 26 Aug 2004 11:31:46 -0500, Yong Wang <[EMAIL PROTECTED]> wrote: > > I have a database which contains date attribute in string format > (like 2004-08-12). I want to genearte a report based on period time. > I use the syntax: > date1 ='2004-08-12' > date2='2004-08-18' > SELECT * FROM ac

Correct date query syntax

Hi, All: I have a database which contains date attribute in string format (like 2004-08-12). I want to genearte a report based on period time. I use the syntax: date1 ='2004-08-12' date2='2004-08-18' SELECT * FROM account WHERE (TO_DAYS(date) >= TODAYS(date1)) and (TO_DAYS(date) <= TO_DAYS(date

RE: replication threads on different CPUs

Luke, As far as I know you can't do that in mysql, it would have to be at the kernel level. Replication threads, really don't use much cpu anyway at least not on the master, since all it's doing is basically reading a binary file. Now the kernel itself does do something like you are talking about

Re: Slow Queries on Fast Server?

Capable? I can't think if why it wouldn't be capable. From your posts I assume your definition of "capable" in this case is a quick response. Are you running 4.0 or 4.1? I think the indexing was changed in 4.1 so it would give you better response. 5-20 seconds does seem long, assuming your

Re: ANNC: MySQL Administrator 1.0.11

Alfredo Kengi Kojima said: > > MySQL Administrator 1.0.11 has been released. > > MySQL Administrator is a GUI management console for MySQL, with support > for tasks such as managing users, configuring MySQL, performing backups, > editing table definitions etc. > > More information at: > h

replication threads on different CPUs

I'm a bit of a linux newbie and a newbie to replication, so I'll try to ask this question simply... we're using mysql 4 to do replication, and I notice on the master I have this from using mytop: Id User Host/IP DB TimeCmd Query or State --

Re: Could this be dangerous :Values and Labels

I actually did make the switch to mnemonics (as suggested by Rhino) I've gone slightly beyond 2 letters though due to the fact that some of my labels might be more then confusing. I've tried to stick with 3 letters on average. It does seem like a better way to go. Stuart --- mos <[EMAIL PROTECTED

Re: Could this be dangerous :Values and Labels

At 02:36 PM 8/25/2004, you wrote: Or maybe just bad practice. Thought before I go any further I'll ask. I have a few static tables that list out "items" and the primary key is an "assigned" ID. Meaning I did not set auto-increment. As I add items I will add the associated ID number. Now to the tr

ANNC: MySQL Administrator 1.0.11

MySQL Administrator 1.0.11 has been released. MySQL Administrator is a GUI management console for MySQL, with support for tasks such as managing users, configuring MySQL, performing backups, editing table definitions etc. More information at: http://www.mysql.com/products/administrator

Re: Slow Queries on Fast Server?

I'm gathering by the lack of response that perhaps MySQL is incapable of executing a count of the number of fulltext matches on 3 million rows. I really thought that MySQL 4 was really suppose to be able to handle such a load I still think my configuration may be to blame ? - John

Re: mySQL beginner question

- Original Message - From: "B Wiley Snyder" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 26, 2004 1:56 AM Subject: mySQL beginner question > Hello, hope this is the right list > > I created a table with the following code > > > CREATE TABLE jspCart_products ( >

Re: PHP / Mysql people question

Right, I am not on any list for a line by line feed / analysis. Actually I tried signing up twice yesterday for the PHP general and never received email confirmation. Anyway sure I'll find my way ! Thank you Stuart --- [EMAIL PROTECTED] wrote: > i would suggest that your questions would be more

Re: mySQL beginner question

Having duplicates is not a problem. As long as you don't have a UNIQUE index on it. Something else is happening in your code that is putting out the HTML I would guess. P.S. It should be SELECT * FROM jspCart_products; (your table, not your database) B Wiley Snyder wrote: Hello, hope this is th

Re: PHP / Mysql people question

First let me say thank you for all the responses. Now, let me say I'm not sure what exactly I need to do. Explanation - Primarily I have absolutely no experience with PHP , but I can learn, so that's helpful :) The thing I'm trying to figure out is what I need to learn, because currently I'm develo

RE: MySQL Secure Connection(e.g. SSL) Question

Ah I did not know that. Excellent. Still does not get round the issue that MySQL in most default binary distributions does not include SSL. Which I think is a shame, but then again is probably a lib issue. Thanks for that. Greg > -Original Message- > From: Eamon Daly [mailto:[EMAIL P

Re: PHP / Mysql people question

Hi, First mysql_fetch_row() returns an array so it doesn't make much sense to compare it to 5. If you want to check tne number of records the query has returned you should use mysql_num_rows() - like this if(mysql_num_rows($result)>=5){ } or if you want to check the value returned by the query