Re: Total newbie asking for guidance

if you have a windows box that you can use as a front end, get a copy of corereader. i recommend it to you because, among other things, it's a teaching tool. it allows you to do (genuine) point and click queries. you can do complex queries simply by clicking on selections. furthermore,

JDBC J/Connect driver is seriously slow against InnoDB

Hi: Thought I'd mention this (using the latest dev J/connect): A) DatabaseMetaData.getColumns() does not return the last 4 columns (SCOPE_*) but it should according to the API spec B) InnoDB, on their benchmark page, say that inserting 100,000 rows into the DB is about 5 seconds.

mysql DATETIME substraction problem/?

Hello! I am working on an analysis that is very much dependent on calculating time differences in seconds. The most simple example: I have 3 variables: time_begin (DATETIME) time_end (DATETIME) and elapsed_ seconds (INT). The data in these DATETIMES looks fine -MM-DD HH:MM:SS as

Re: JDBC J/Connect driver is seriously slow against InnoDB

j.random.programmer wrote: Hi: Thought I'd mention this (using the latest dev J/connect): A) DatabaseMetaData.getColumns() does not return the last 4 columns (SCOPE_*) but it should according to the API spec I'll look into fixing this right away. You should write Sun as well, as their JDBC

What if binary log's suffix number exceeds 999?

Hi! Chung == Chung Ha-nyung [EMAIL PROTECTED] writes: Chung Dear, Chung By default, binary log file uses 3-digit number suffix as its counter. Chung Then, without reseting master logs suffix number may reach 999. If so, Chung what happens? Chung next suffix number is 1000 or 001?

explain bug?

Hi, I've tried an EXPLAIN of the SELECT below. Please can anyone tell me why it's Impossible WHERE noticed after reading const tables ? I've droped and created the table - but the error/message occurs. When I leave '(chetPosition = 1)' away, it works! A bug or ??? The statement works without

FW: Select from mulitple tables:

Helllo Im trying to run a select from 5 different tables, depending on the key in the main one like this: select JOB_ASS.JOB_ASS_ID, JOB_ASS.START_DATE, JOB_ASS.STOP_DATE, JOB_ASS.JOB_NAME, JOB_ASS.LOCATION, JOB_ASS.NOTE, JOB_ASS.ORDER_ID, JOB_ASS.CONTRACT_VALUE, USER.SURNAME, USER.FIRSTNAME,

tricky problem with two db-sites

Hi, I'll soon run in a probaply pretty common problem with 2 site replication. We currently hold our customer and buisiness data in one mysql server. Soon we'll get another site which basically will work on a regional separate project. While the set of potential costomers that overlap will be

Help with JOIN, please!

Hi, I'm having some real problems figuring out a seemingly simple join statement. I've looked through some of the mailing list posts, but I can't seem to find what I'm looking for. Here's what I have - 2 tables: table1 (id, stimulus_number, stimulus_type) table 2 (id, stimulus_number,

Help with simple JOIN

Hi, I'm having some real problems figuring out a seemingly simple join statement. I've looked through some of the mailing list posts, but I can't seem to find what I'm looking for. Here's what I have - 2 tables: table1 (id, stimulus_number, stimulus_type) table 2 (id, stimulus_number,

Re: Help with simple JOIN

Ken, Don't you want ... ... INNER JOIN table_2 as b ... ... PB - I'm having some real problems figuring out a seemingly simple join statement. I've looked through some of the mailing list posts, but I can't seem to find what I'm looking for. Here's what I have - 2 tables:

help create new user

Does anyone know why? create database visitor; grant all on visitor.* to visitor_user identified by 'visitor'; use visitor; mysql -u visitor_user -p I get ERROR 1045: Access denied for user: 'visitor_user@localhost' (Using password: YES) From Mozilla

Re: help create new user

On Mon, Nov 04, 2002 at 12:37:12AM -0500, Bob Lockie wrote: Does anyone know why? create database visitor; grant all on visitor.* to visitor_user identified by 'visitor'; use visitor; mysql -u visitor_user -p I get ERROR 1045: Access denied for user: 'visitor_user@localhost' (Using

Re: help create new user

Jeremy Zawodny wrote: On Mon, Nov 04, 2002 at 12:37:12AM -0500, Bob Lockie wrote: Does anyone know why? create database visitor; grant all on visitor.* to visitor_user identified by 'visitor'; use visitor; mysql -u visitor_user -p I get ERROR 1045: Access denied for user:

Re: help create new user

On Mon, Nov 04, 2002 at 12:54:17AM -0500, Bob Lockie wrote: That fixed it, thanks. What did it use since I didn't specify an @'localhost'? It used '%' which matches everyhing *except* localhost. The manual explains this. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine,