Re: innodb_flush_log_at_trx_commit

On Mon, Jun 03, 2002 at 07:07:29AM +0100, ritu singla wrote: Hello, in InnoDB tables in MySQL, if innodb_flush_log_at_trx_commit is set to 1, then on COMMIT, the buffer log is flushed to disk log... Right. or the changes are reflected in the disk copy of the database??? i mean what is

Command line interface

Hi Very new to MySQL and just wondering if there is an alternative interface to the command line. The beginners tutorial I am working through from WWW.Mysql.com seems to do all tasks from the command line. This seems very cumbersome in modern times. I understand there is a graphical

mysql not supporting php.

mysql support is not available to php on this server This is the error I receive. MySQL is working fine, but I need to know how get php working with sql. Also, does anyone know the command to list all the db's? thanks. Dave

Re: Command line interface

I use exclusevely command line interface, and i believe most of the programmers prefer command line interface over GUI. As to large queries... just save them in yor files or use 'edit' command. On Mon, 3 Jun 2002, Ehmer David wrote: Hi Very new to MySQL and just wondering if there is

subselects in mysql 4.1 and other questions

Hi, 1. I am reading 'internals' list and I see some words about subselect in 'bk commit into 4.1 tree' messages... Seems like we can expect subselect in 4.1 branch !?? :) 2. When 4.0.2 beta will be released? 3. Seems like gcc 3.0 (or 3.1?) becomes an official recommended compliler for mysql

command line interface

Hi Very new to MySQL and just wondering if there is an alternative interface to the command line. The beginners tutorial I am working through from WWW.Mysql.com seems to do all tasks from the command line. This seems very cumbersome in modern times. I understand there is a graphical

Re: mysql not supporting php.

David Grant wrote: This is the error I receive. MySQL is working fine, but I need to know how get php working with sql. This means your PHP was not compiled with MySQL support. Recompile PHP. Also, does anyone know the command to list all the db's? thanks. show databases; -- H

RE: mysql not supporting php.

The follow lines will -list DBs -allow to select one -list tables under the selected DB mysql show databases; mysql use databasenamehere mysql show tables; hope this helped! -Original Message- From: David Grant [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 12:21 PM

Problem with crystal reports

I am using mysql 3.23.49-Max on Windows and I have configured InnoDB for transactions My front-end is created in Visual Basic connecting using MyODBC 3.51.02 I can be able to access the data using visual basic perfectly and it is supporting transactions okey. I am creating the reports in Crystal

Re: mysql_ping()

What I want to know, is: 1) after reading the header, how should one respond? 2) Is a command necessary, or can one close after succesfully authenticating? 3) Is there a sign-off? Ie - what does a minimal valid connection look like? I may be totally off, but couldn't you just try to open

MySQL timer

Hello, can somebody tell me, how to execute some actions automatically at the specified time, on MySQL server? --- Best Regards, zygiz === Dalyvauk pasaulio futbolo cempionato totalizatoriuje! Kiekviena rungtyniu diena

RE: mysql_ping()

I may be totally off, but couldn't you just try to open a socket to the relevant port - if it goes OK, you're fine. If not, well... example code in PHP: if($fp = fsockopen($host_domain, $port, $errno, $errstr, $timeout)){ // - juhuu! }else{ // - boohoo... } This

Re: mysql_ping()

Hi Melvyn, If i understand well you need to make a diagnostic of your network ... you must read the ICMP packets to do this. Anyway MySQL recovery the last session(connection) ignoring the time out settings. Regards, Gelu _ G.NET SOFTWARE

Re: command line interface

How do most users of MySQL interact with the program. I would imagine entering or editing large amounts of data at the command line would be quite a task. I have to say thhe comannd line interface is by far my preferred interface against MySQL. There are a few free GUI tools running on windows

Re: mysql_ping()

At 03:52 3-6-2002, Mark Matthews shared with all of us: So - indeed - I'm probably barking up the wrong tree, by looking at mysql_ping(), but I basically want to mimmick the behavior, so the there's no connection error for the webserver involved. See it as Net::SMTP, using a simple HELO -

Re: MySQL timer

there is no such thing built in MySQL. you should use cron to have this job done. zygiz wrote: Hello, can somebody tell me, how to execute some actions automatically at the specified time, on MySQL server? --- Best Regards, zygiz

Re: mysql not supporting php.

On Monday 03 Jun 2002 9:50 am, David Grant wrote: mysql support is not available to php on this server This is the error I receive. MySQL is working fine, but I need to know how get php working with sql. PHP isn't compiled with MySQL support. Recompile php and add --with-mysql to the

MySQL query efficiency - JOINs

I have a question regarding the efficiency of an explicit JOIN statement vs. an implicit one. What I mean: I have a many-to-many mapping through a mapping table. I.e. I have different types of tools mapped to several categories in which they might belong. For instance, a complete programming

Re: how to deinstall old mysql version?

On Fri, 31 May 2002, andy wrote: I am just trying to configure my root server. The provider has preinstalled mysql on suse72. So I did try to get rid of this installation with yast, but this did not work out. After compiling php,apache and mysql, PHP is still trying to connect to the old

Re: smaller mysql docs?

On Fri, 31 May 2002, Ray a PowerWeb Tech wrote: is there a place to get the manual that is split a bit more then the current manual_split. these are the 2 pages i end up reading the most even though its usually for just the grant, create, insert syntax (human in need of memory

Re: Installation process

Mary, Friday, May 31, 2002, 7:39:34 PM, you wrote: MD I am a newbie, to group and MySQL. MD I just downloaded MySQL for win 2000. MD The zip file, when opened and clicked on install, MD it created c:\mysql directory and did the install. MD Now what next? MD DOnt I have to start the server?

Re: Re: mysqldump -A dump.txt

Eric, Monday, June 03, 2002, 1:49:24 AM, you wrote: EF I didn't get that deeply into why exactly, but it seems that when I removed EF the mysql database from the file, that the rest went fine with EF mysql -u -p dumpfile If you use -A option for mysqldump, mysqldump makes backup of all

Re: MySQL timer

zygiz, Monday, June 03, 2002, 11:58:42 AM, you wrote: z Hello, can somebody tell me, how to execute some actions automatically at the specified time, on MySQL server? You can't do it with MySQL only. z zygiz -- For technical support contracts, goto https://order.mysql.com/?ref=ensita

Re: Re:Installing

weng, Thursday, May 30, 2002, 2:52:29 AM, you wrote: If you start MySQL server from MS DOS prompt as: C:\mysql\binmysqld-nt --standalone --debug mysqld shows you warning message. wc hi! i tried this already.. And? What result did you get? Does MySQL server run with --standalone --debug

Re: install MySql on drive other than C

Inbal, Sunday, June 02, 2002, 11:42:01 AM, you wrote: IO I read in the manual about building mysql not on c:\ IO and i found that i need to change the file my.ini IO my questions are: IO 1) can i build this file by my self and not with winmysqladmin.exe? Yes, you can create file my.ini or

Interbase vs MySQL

Hi all. I'm looking for a comparison between Interbase and MySQL. Thanks in advance. Iago. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

MySQL startup error

This is the error message that I get Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Could ayone please show me how to sort this out I had MySQL running before this. This has happened all

Re: Fw: fault tolerance

On Sun, 2 Jun 2002 16:39:36 -0500 Khaled Elmeleegy [EMAIL PROTECTED] wrote: What if the MySQL server crashes during an Insert or delete or update statement, In what state would that leave the database, and would MySQL recover? If so how would it do that? If not what would happen, half of the

RE: Bug with multi-table DELETE in MySQL 4.0.1

Leeuw van der, Tim writes: Hello, Thank you very much for your reply! I was hoping that this was indeed fixed in 4.0.2. I was using 4.0.0 when the bug occurred and upgraded today to 4.0.1; I will retest the query with 4.0.2 as soon as it's released. Apologies btw for not mentioning the

Re: MySQL + cygwin

Hello Chris, I would recommend to try to compile MySQL itself under cygwin (or you already tried it?). Just use GCC version they suggest (I failed to compiled it using GCC 3.1). BTW, if you succeed, I would really appreciate if send me mysqlclient-library compiled under cygwin.

Re: ENCODE algorithm

On Mon, 2002-06-03 at 04:58, Evgeny Chuykov wrote: What algorithm do ENCODE-DECODE functions use? This is noname algorithm with questionable security level. Use DES_ENCRYPT/DES_DECRYPT instead. This uses triple DES. Tõnu sql

Get message

How can I get the message when I make a query like e.g: 8 rows in set (0.01 sec) How can I get with Delphi. I use the component Zeos dbo to access Mysql Regards Alexander Curitiba/BRA A busca mais veloz e precisa da internet. Acesse agora:

Re: subselects in mysql 4.1 and other questions

Alexander, Monday, June 03, 2002, 9:46:40 AM, you wrote: AB 1. I am reading 'internals' list and I see some words about subselect in 'bk AB commit into 4.1 tree' messages... AB Seems like we can expect subselect in 4.1 branch !?? :) Yeah, sub-selects is in our TODO for 4.1, look at:

Re: MySQL startup error

Neville, Monday, June 03, 2002, 1:44:25 PM, you wrote: NL This is the error message that I get NL NL Can't connect to local MySQL server through socket NL '/var/lib/mysql/mysql.sock' (2) NL NL Could ayone please show me

Re: Setting Auto Increment

Arul, Saturday, June 01, 2002, 8:34:40 AM, you wrote: A Is it that i can make a column auto increment only if its data type is A integer. A Can i not set auto increment value for a numeric datatype You can set up AUTO_INCREMENT attribute for all int's and float's types. A -Arul -- For

RE: replication problem

Hello, More than likely you have missed the step that the slave database has to be the exact one that the master has before the start of the binlog. Shutdown both servers, grab a copy of the master's data directory and tar that up, move that to the slave, delete the slave's current data

Autorefresh MyODBC

Hi. Can we use Access to link table in MySQL and force Access to refresh data from MySQL automatically when data in MySQL table have change. Kittiphum Worachat,M.T. www.hatyailab.com - Before posting, please check:

RE: MySQL + cygwin

hi, i have mysql compiled with cygwin with gcc version 2.95.3 you can fetch installed version from http://www3.ibt.com.pl/mysql.tar.gz it is prepared to be installed in /opt in cygwin's directory structure best regards, terry -Original Message- From: Yegor N. Bryukhov

RE: Autorefresh MyODBC

Since Access is using ODBC to get to the tables I'm pretty sure this is not possible. You could write an access form with a timer on it that requereies the data ever x seconds to refresh it. (But this is bad...m'Kay?) =C= * * Cal Evans * Journeyman Programmer * Techno-Mage *

RE: Get message

you can't. Check the archives, this was discussed about 2 weeks ago. * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 7:13 AM To: [EMAIL PROTECTED] Subject:

Re: Command line interface

Have a look at urSQL from http://www.urbanresearch.com/ursql On Mon, 3 Jun 2002, Ehmer David wrote: Hi Very new to MySQL and just wondering if there is an alternative interface to the command line. The beginners tutorial I am working through from WWW.Mysql.com seems to do all tasks from

1 or 2 tables with the same data

I have a MySQL table called questions where I have (qid, catid, userid, title, question, point, status, timestamp) title and question are of type text with a FULLTEXT index and never change. I use the table for: - Get all data - Get results from several rows without fetching the title and

Re: Autorefresh MyODBC

This depends on whether the table will always be open I believe you are using MyODBC connection. Create a new table and then choose link table in access. While linking choose to save the password. Any changes which will occur in the mysql table will be viewable from access. But this will occur

RE: Get message

Unfortunately, I don't have. I subscribed today. -- Mensagem Original -- you can't. Check the archives, this was discussed about 2 weeks ago. * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

Re: mysql not supporting php.

It sounds as if you didn't compile in mysql support with you php executable. You can check this using the phpinfo() function. If you are using the cgi only, try something like... 'php -q -i | grep configure' This will show you all the configuration options you selected when

is there a whoami for mysql?

is there a show grants self or a whoami type command? i'm trying to setup security, but i'm not show who i'm login in as? root@% or [EMAIL PROTECTED]/255.255.255.0 i am logging in just fine, but i don't really want to delete root@% until i know i'm getting the right login. \s just shows me

RE: Get message

'salright. Short answer. The driver does not give you this message. you can time the execution yourself and then count the rows. For the full discussion try digging around at: http://www.mysql.com/documentation/searchlists.html HTH, =C= * * Cal Evans * Journeyman Programmer * Techno-Mage *

INSERT performance when indexes are used

Hi, I have a table with about 5 million records, and an index on that table's VARCHAR(255) field, as well as a couple of integer indexes. The VARCHAR-index is essential to my application as I frequently need to search through the whole table by using the VARCHAR field. When I do INSERTs into

Big table and Mysql

Hi all, I would like to ask if is possible create and use this table size with MySQL. So, I have 15 columns in 1 row and it contain 100B of data. I have in plane insert cca 30 000 000 rows per year - 3 GB/year * 4 years = 12 GB of data (120 000 000 rows and 1 800 000 000 ). HW configuration is:

Re: mysql not supporting php.

At 01:50 AM 6/3/2002, you wrote: mysql support is not available to php on this server This is the error I receive. MySQL is working fine, but I need to know how get php working with sql. Also, does anyone know the command to list all the db's? thanks. Dave Dave, Switch to PHP 4.2.1

Re: Interbase vs MySQL

At 05:28 AM 6/3/2002, you wrote: Hi all. I'm looking for a comparison between Interbase and MySQL. Thanks in advance. Iago. lago See http://lists.mysql.com/php/search.php?ps=10q=interbaseps=20m=and. Mike -

Re: MySQL + cygwin

Hi Chris, I have tried to compile following version of the MySQL under cygwin. - 3.23.47 - 3.23.50 - 4.0.1 I was able to compile (client + server ) all of mentioned version, BUT most of the test have failed except for the version 3.23.50 that seem to me to work in most cases but not in all. I

Re: is there a whoami for mysql?

Hi Ray, You can see what user you is with: select user(); Ray wrote: is there a show grants self or a whoami type command? i'm trying to setup security, but i'm not show who i'm login in as? root@% or [EMAIL PROTECTED]/255.255.255.0 i am logging in just fine, but i don't really want to

INSERT performance when indexes are used

Hi, I have a table with about 5 million records, and an index on that table's VARCHAR(255) field, as well as a couple of integer indexes. The VARCHAR-index is essential to my application as I frequently need to search through the whole table by using the VARCHAR field. When I do INSERTs into

Re: INSERT performance when indexes are used

One thing you could try is limiting your index length ALTER TABLE `sometable` ADD INDEX(`somecolumn`(10)) This will only index off of the first 10 characters of your data. Depending on the type of data you store, this may improve your performance. - Original Message - From: Mikko

How to select last record?

Hello! :) Is there any chance to select last record in one sql statement? Thanks. Kosyo __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com

RE: How to select last record?

[snip] Is there any chance to select last record in one sql statement? [/snip] Try this query; SELECT * FROM tableName ORDER BY id DESC LIMIT 1 HTH! Jay - Before posting, please check: http://www.mysql.com/manual.php

Re: is there a whoami for mysql?

mysql select user(); +---+ | user()| +---+ | [EMAIL PROTECTED] | +---+ mysql show grants for [EMAIL PROTECTED]; ERROR 1141: There is no such grant defined for user 'root' on host '192.168.0.17' mysql show grants for user(); ERROR 1064:

support UTF-8

Hi , Do mysql ver 2.23.X support UTF-8 . If yes , to what extends. I have tried UTF-8 with mysql ver 3.23.37 on windows. It seems as that it support UTF-8 , but tools (utilities ) for mysql does not fully support utf . Have any body have tried that. Regards, shahzad sarwar

Insert into longblob column, it's limitation

Good Day I will attempt to give you as much information about the software as I can before I ask the question. OS : RedHat 7.1 MySQL : Version 3.23.49a for Linux - binary distribution for pc-linux I want to insert into longblob column very big large data. but.. I have strange

Sluggish performance on medium sized table.. EXPLAIN SELECT's included.

A database is being used to log support calls for a call center. There are around 25,000 clients in the database. The existing call notes were imported from flat text files. One table (call_notes) contains the call time, ticketid, noteid, ect.. Another table (call_notes_text) only contains

Sluggish performance on medium sized table.. EXPLAIN SELECT's i ncluded.

A database is being used to log support calls for a call center. There are around 25,000 clients in the database. The existing call notes were imported from flat text files. One table (call_notes) contains the call time, ticketid, noteid, ect.. Another table (call_notes_text) only contains

No response from mysql; mysql_install_db freezes

From: Peter Lloyd [EMAIL PROTECTED] To: script Subject: No response from mysql; mysql_install_db freezes Description: I am following the installation instructions in the documentation, and after invoking the script 'mysql_install_db', I see a few announcements, then nothing happens. I waited

4.0 When?

Hi, Is there a roadmap for mysql 4.0? We'd like to upgrade our MySQL DB server to another one which can use some useful techniques eg. sub-selects, transaction handling, etc. I like mysql very much and I know that in 4.0 these techs will be implemented. But I don't know when will this new

RE: 4.0 When?

Oh, not the alpha, but the stable version, of course! Is there a roadmap for mysql 4.0? We'd like to upgrade our MySQL DB server to another one which can use some useful techniques eg. sub-selects, transaction handling, etc. I like mysql very much and I know that in 4.0 these techs will

MySQL crash on ALTER TABLE command

Hi all, I have a problem with MySQL under Windows NT/2000 where it crashes every time I issue an ALTER TABLE command while the table is being written to under high load. I've tried several versions of MySQL on a few different machines/OS and still the problem remains. I'm hoping someone

All records returne with JOIN

The following query takes a very long time to process. It finally returns only the row I'm wanting, but when I run an EXPLAIN SELECT on it, it looks like all 14687 rows are being examined for the record -- instead of mysql honing in on the desired row immediately. SELECT

RE: InnoDB and Windows

-Message d'origine- De : Alexandre Zglav [mailto:[EMAIL PROTECTED]] Envoyé : lundi, 3. juin 2002 19:05 À : mysql (Elektronikus levelek) Objet : InnoDB and Windows Hello all . Nice to meet you. Maybe this thread has already been solved. If so im sorry for the disturb. Here is my

Updating stock data

I have a database containing stock data which I want to keep up to date. The relevant fields are the symbol, date, high, low, and last prices. When a new price comes in for an existing date, I want to update the high if the price is higher, the low if the price is lower, and I always want to

Re: MySQL + cygwin

Hey everyone, Thanks for all the help / comments re cygwin. I'll definitely be giving some of them a try. Terry offered a pre-compiled binary which I am busy getting at the moment that I'll have a look at to see how nice it is. I'll also be very tempted to compile my own versions However,

Re: All records returne with JOIN

Michael, In Oracle, with which I am much more familiar, only primary keys are indexed automatically. Foreign keys are not indexed automatically. You have to create the indexes on the foreign key columns explicitly. My guess is that MySQL works the same way, and that this is the source of

Uninstalling MySQL

I have built a MySQL binary from source and have installed it with no problem. However, when I go to make uninstall, make bombs on me. Any recommended way for uninstalling a MySQL distro? - Before posting, please check:

Re: Sluggish performance on medium sized table.. EXPLAINSELECT's i ncluded.

Try changing your WHERE clause from: WHERE call_notes.ticketid = '1' call_notes.userid = users.userid call_notes.contactid = facility_contact.contactid call_notes_text.noteid = call_notes.noteid To WHERE call_notes.ticketid = '1' call_notes.userid = users.userid call_notes.contactid =

RE: Sluggish performance on medium sized table.. EXPLAIN SELECT's i ncluded.

First of all, sorry for the multiple mailings of the same message. I was receiving bounce messages, so I thought they weren't going through. On to the reply... I saw that a while ago and decided to try reversing, but I still have the same delay. Mike -Original Message- From:

Re: Sluggish performance on medium sized table.. EXPLAIN SELECT's i ncluded.

On 3 Jun 2002, at 11:49, Stembridge, Michael wrote: FROM call_notes, call_notes_text, users, facility_contact WHERE call_notes.ticketid = '1' call_notes.userid = users.userid call_notes.contactid = facility_contact.contactid call_notes_text.noteid =

Re: mysqldump -A dump.txt

You are loading all databases, but the security database (mysql) is already there. Assuming you are starting with nothing and restoring all databases that the server knows about, one method that works is to start the server with --skip-grant-tables, then load the dump file, then flush

Re: Updating stock data

On 3 Jun 2002, at 10:06, Mike G wrote: Basically, I look to see whether the currect date exists by retrieving the high and low for the date. If it succeeds, I calculate whether the new price is higher than the existing high or lower than the existing low. Then I update the high, low and last

Re: Get message

http://www.mysqldeveloper.com/lists/index.pcgi?readlist=mysql [EMAIL PROTECTED] wrote: Unfortunately, I don't have. I subscribed today. -- Mensagem Original -- you can't. Check the archives, this was discussed about 2 weeks ago. * * Cal Evans * Journeyman Programmer * Techno-Mage

RE: Sluggish performance on medium sized table.. EXPLAIN SELECT's i ncluded.

Thank you Keith - I worked with your example and LEFT JOIN has solved the problem. Best Regards, Mike -Original Message- From: Keith C. Ivey [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 2:26 PM To: [EMAIL PROTECTED] Cc: Stembridge, Michael Subject: Re: Sluggish

Re: Get message

Hi. On Mon 2002-06-03 at 10:22:35 -0300, [EMAIL PROTECTED] wrote: Unfortunately, I don't have. I subscribed today. Irrelevant. What he meant is, check the online archives (it is the recommended thing to do before posting a question at all): http://www.mysql.com/documentation/searchlists.html

Newbie - How 2 ODBC/JDBC to MySQL

Hello! I just installed MySQL. Win 2000 Professional. I am logged in as none. No User Id. No Password. I wonder how. :) I could create tables, update records, query etc,. Now I would like to make ODBC connections. And eventually make JDBC connection from my \ Java

Record dependancies

Is there a way to do this in one query (never mind the possibilities for endless loops): Say you have a table that looks like this: fieldName dependantOn joe monster bob joe briggs monster briggs vision I want to do a query so that the records are

RE: Newbie - How 2 ODBC/JDBC to MySQL

Need to go grab myodbc. Check downloads at www.mysql.com. grab the binaries unless you are brave enough to compile. :) Install (It comes with a setup) and then configure an ODBC source like normal. it works, I've done it. =C= * * Cal Evans * Journeyman Programmer * Techno-Mage *

Re: 4.0 When?

Hi. As MySQL AB normally only does a stable release, when the appropriate state is reached, the only valid answer is when it's ready. A more useful answer may be http://www.mysql.com/doc/M/y/MySQL_4.0_In_A_Nutshell.html Btw, (stable) transactions are already available in the 3.23.x releases.

files in /tmp

Hey guys, there are 2 files in my /tmp directory that look like mysql datafiles: #sql208_ecc_0.MYD #sql208_ecc_0.MYI They're on the same box as our development mysql instance but I don't see them on any of our other instances. Anyone have any idea what they are/if I can delete them? They're

Re: Sluggish performance on medium sized table.. EXPLAIN SELECT's i ncluded.

Hi. On Mon 2002-06-03 at 14:17:42 -0400, [EMAIL PROTECTED] wrote: Try changing your WHERE clause from: WHERE call_notes.ticketid = '1' call_notes.userid = users.userid call_notes.contactid = facility_contact.contactid call_notes_text.noteid = call_notes.noteid To WHERE

Re: Record dependencies

SQL for Smarties by the demigod Joe Celko. Chapters 28 and 29 describe this tree structure. READ BOTH OF THEM, even though you won't use the code in 28. Chap 29 holds the simplified concepts to make a tree structure work with single select. It's not easy. It's a complex concept but once

Re: Sluggish performance on medium sized table.. EXPLAIN SELECT's i ncluded.

Hello. You missed to mention that using LEFT JOIN changes the meaning of the SELECT in question and it may also be a lot slower, dependend on the data. I think STRAIGHT_JOIN is more appropriate to force the tables to be read in a certain order. Bye, Benjamin. On Mon 2002-06-03 at

RE: Record dependencies

Yes, the concepts he presents are in generic SQL. I've used them in 2 different systems (menus and security) and they work fine. (NOTE: You DO have to write your own code.) ;) =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Original Message-

Re: convertion probleme from string to char *

Hello, I use a little function to solve this problem in mysql++ . char* c_string(const string s){ char* p = new char[s.length() + 1]; s.copy(p, string::npos); p[s.length()] = 0; return p; } char *temp = c_string(row[ YOUR COLUMN].c_str()); MArio H.C.T.

mySQL++ 1.7.9 installation help

Hi, I try to install mySQL++ 1.7.9 in Linux 7.1 (gcc 2.96). I put the mySQL++ source code in /home/group2/ and type the following commands: automake autoconf ./configure --with-prefix='/home/group2/' but there is an error message: checking for MySQL library directory... configure: error:

Re: Sluggish performance on medium sized table.. EXPLAIN SELECT's included.

On 3 Jun 2002, at 22:23, Benjamin Pflugmann wrote: You missed to mention that using LEFT JOIN changes the meaning of the SELECT in question and it may also be a lot slower, dependend on the data. I think STRAIGHT_JOIN is more appropriate to force the tables to be read in a certain order.

changing the root password

I can't remember my root password. I know that there is a way to set it by starting mysql with certain parameters, but I can't remember what those parameters are. Can you help me out? Thanks! - Before posting, please check:

Re: mySQL++ 1.7.9 installation help

Hi, If you have installed MySQL, the library it is on the right place. Gelu - Original Message - From: Shaorong Liu [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 12:01 AM Subject: mySQL++ 1.7.9 installation help Hi, I try to install mySQL++ 1.7.9 in Linux

Re: mySQL++ 1.7.9 installation help

1.You need libraries+headers from MySQL installation 2.You have to specify their locations in configure parameters (--with-mysql-lib=..., --with-mysql-include=...) As I remember one of these parameters does not recognize well on RH 7.2 (and 7.1 also I guess) I try to install mySQL++ 1.7.9

How to back up multiple times

Hello: A newbie here using Lasso5, MySQL on a Mac OSX I would like to back up the MySQL dbs at certain intervals during business hours. The backups should not be overwritten but kept as archives. Is there a commercial/shareware product which will automate this process as well as reconstruct the

stupid error, please kick me (and send me a solution)

Hey guys, i'm getting this error with the following sql script using php: --error-- Warning: Supplied argument is not a valid MySQL-Link resource in /var/www/phpquiz/register_user.php on line 12 --error-- --script-- $link_glob = mysql_connect('$host_glob', '$un_glob', '$pw_glob'); $query =

Cyber Cafe software

Does anybody know of any software all ready written or what would have to be done, to allow us to run a cyber cafe style setup. What we need the software to do is to allow someone to come in and plug in their computer to our network (actually a customers network). They want the following: 1.

Re: stupid error, please kick me (and send me a solution)

Your missing your closing } at the end of the else statement. - Original Message - From: Jule Slootbeek [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED]; php-general [EMAIL PROTECTED] Sent: Monday, June 03, 2002 5:09 PM Subject: stupid error, please kick me (and send me a solution) Hey

RE: stupid error, please kick me (and send me a solution)

It would also appear you are missing a closing ) at the end of the '$query=...' line. You have two opening backets and only one closing. Greg -Original Message- From: Bruce Lewis [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 4 June 2002 7:50 To: [EMAIL PROTECTED]; mysql; php-general

  1   2   >