(Newbie) Apachie->PHP->MySql

Greetings all. A bit of history, I have a small.no actually...TINY website. :-) I am using PHP and mySql there without any problems. But uploading and testing each PHP page/program was a pain in the . so i installed Apache,MySql and PHP on my WINDOWS 2000 machine for testing before goi

Auto increment (Newbie)

Hey there, I know this might sound like a stupid question to a lot of you guys out there but please keep in mind I come from an oracle background and am new to this: I am accessing MySql from PHP, I have two questions regarding Auto_Increment 1) how to create an auto_increment? create table MyT

timestamp

Greetings guys, Special greetings to all of you who helped me in the last question, one last one in a timestamp field, do I have to provide the values? eg create table ryan(t_imestamp timestamp(8), name varchar(30)); how do I insert? do I have to specify the value? if so how do I g

count...I think

Hey guys, I have a very simple question, I though I knew the answer but the MySql manual has confused me I have a simple select from a database of say...1k records...I use select id from myTable where sal>1000; Lets say this statement would normally return 132 records, but how do I kn

Re: Importing dBase II +

Alle 08:21, giovedì 13 ottobre 2005, Huub ha scritto: > Hi, > > Can someone tell me if it is anyhow possible to import a dBaseIII+ > database into MySQL and if so: how? > On linux there is "dbf2mysql" http://packages.debian.org/stable/misc/dbf2mysql On windows you could import the tables in m$acc

User defined Variables

I was wondering if there is a way to increase the size of user defined variables ? I am not able to attribute a type to them and when I assign @sql = 'a_text _field' , 'a_text_field' gets truncated if it exceeds the size of @sql. This is not wholesome as I am using @sql in a subsequent prepare sta

Re: User defined Variables

ut I it doesn't error out with the same problem. I suspect server variables or what not .. not sure what. Thanks for the feedback Dan I will post with more information. Kailash. On Sat, Oct 15, 2011 at 9:38 PM, Dan Nelson wrote: > In the last episode (Oct 15), Kailash R said: > &g

Re: User defined Variables

. Thank you for answering my question. Please consider my question resolved. Kailash. On Sun, Oct 16, 2011 at 10:06 PM, Dan Nelson wrote: > In the last episode (Oct 16), Kailash R said: > > Nice input Dan. Let me run some checks. My query is as follows: > > > > select group_c

InnoDB: Error: unlock row could not find a 4 mode lock on the record

Hi All, InnoDB repeatedly prints this message in the error log: # InnoDB: Error: unlock row could not find a 4 mode lock on the record Im not sure if the error message is critical or not, but its definitely not nice to have in the error log. After some exploration, I found this error is relevant

Performance problem - MySQL at 99.9% CPU

Hello, I am running a community site mainly based on phpBB. It has about 9.300 registered users, 650.000 posts and about 200.000 visitors/month (12 mill "hits"). The SQL database is about 700MB. It's all running on a couple of years old Dell box with two P4 Xeon 1.7Ghz CPUs, 1GB of RAMBUS memory

Re: Performance problem - MySQL at 99.9% CPU

31 0:01 /usr/sbin/httpd apache3602 0.7 1.2 26244 13384 ?S22:31 0:01 /usr/sbin/httpd apache3607 1.1 1.2 26268 13424 ?S22:31 0:02 /usr/sbin/httpd apache3608 0.7 1.2 26264 13416 ? S22:31 0:01 /usr/sbin/httpd qmaild3658 0.0 0.0 5320 944

RE: Performance problem - MySQL at 99.9% CPU

USER PR NI VIRT RES SHR S %CPU %MEMTIME+ COMMAND 2410 mysql 15 0 470m 310m 4464 S 99.9 30.8 4200:25 mysqld How come the CPUs can have idle time even though mysqld is running at 99.9%, AND there's a processor queue (4.36)? Cheers, Gunnar R. On ons, januar 2, 2008, 13:

Re: Performance problem - MySQL at 99.9% CPU

c, > perhaps optimizing the indexes etc on the table might help with the > performance. > > Also, make sure your HD's aren't full... that will kill performance > very quickly if the needed disk space isn't there. > > Erik > > > On Jan 3, 2008, at 3:44 PM, Gunna

Re: Performance problem - MySQL at 99.9% CPU

c, > perhaps optimizing the indexes etc on the table might help with the > performance. > > Also, make sure your HD's aren't full... that will kill performance > very quickly if the needed disk space isn't there. > > Erik > > > On Jan 3, 2008, at 3:44 PM, Gunna

Unique Id generation

Hi all, I try to generate a unique id for each row in a Mysql-InnoDB Table. Because of many deletes I can’t use an auto_increment column. After a Mysql restart, the next value for an auto_increment-column is max(auto_increment-column)+1, and I need a really unique id. My first solution looks

Re: RE: Unique Id generation

> >I try to generate a unique id for each row in a Mysql-InnoDB Table. > >Because of many deletes I can't use an auto_increment column. > >After a Mysql restart, the next value for an auto_increment-column is > >max(auto_increment-column)+1, and I need a really unique id. > > > [JS] See if the

Re: Unique Id generation

> Why would the auto_increment not work for you? The only case where you > would have a problem is if the last record was deleted before mysql > shutdown. If you are really concerned about this unique scenario, > insert a dummy record before shutdown to guard against it and delete > the dummy reco

mysql total replication question

Hi All! I'm using the latest mysql 4.0.x and I've successfully set-up database replication on it over 2 machines. I have noticed though that mysql doesn't seem to replicate CREATE TABLE operations on the master to the slave. Is this a limitation? Or I just missed something. If so, can someone ple

gui front-end tool in Linux

Hi there!!! I am using Debian Woody. I am searching for a good front-end gui tool for mysql in Linux which will create UML out of the database schema, something like MS SQL. Are there any tools out there which can do it for me. Regards, R Karthick -- You are the one, the only one -- MySQL

transferring MySQL db from RedHat to Debian

hello list! i'll be moving from a RedHat server to a Debian server very soon. despite the different linux distributions, is it ok to transfer my entire mysql database by just copying everything in /var/lib/mysql of the RedHat system to the Debian system? has anyone tried this before? the r

problem with making mysql accessible from other machines

good day all! i'm getting really confused with how to properly allow users to access mysql from other machines. that is, i tried this as mysql root user: GRANT SELECT, INSERT, UPDATE, DELETE ON my_sql_db.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password'; after this, i can access mysql as 'dbus

on big mysql .MYD files and linux's 2GB file size limit

Is the 2GB filesize limit in linux still there? Specially in Gentoo and Debian linux? If so, how can this be addressed when your mysql's .MYD files reach 2GB? Is there any way MySQL can split really big .MYD files? Regards, Shannon __ Do you

mysqldump exclude table option

Is there a way to tell mysqldump to dump all tables in the specified database except certain specified tables? Like maybe: "mysqldump dbname !exclude_this_table > data.sql"? I have about 200 tables in my database and I only need to back-up about 98% of them. The other 2% are HUGE temporary searc

Going from 3.23 to 4 - sql statement errors

I am using php with mysql, and after moving my tables to a new server, I am suddenly getting this error: Query failed: 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 'this = 'No', fp_ext = 'No', username = 'jre

Going from 3.23 to 4 - sql statement errors

Sorry if I posted this twice - I had some email issues yesterday, and I didn't know if this made it to the list: I am using php with mysql, and after moving my tables to a new server, I am suddenly getting this error: Query failed: You have an error in your SQL syntax. Check the manual that cor

RE: Going from 3.23 to 4 - sql statement errors

x27;, host_price = '$host_price_edit' WHERE domain = '$domainhosted'" -Mike > -Original Message- > From: Victoria Reznichenko [mailto:[EMAIL PROTECTED] > Sent: Friday, March 19, 2004 8:21 AM > To: [EMAIL PROTECTED] > Subject: Re: Going from 3.23

msvcr70.dll was not found error when double click on desktop icon

I am a personal user who just downloaded the version 4.0 and mysql > administrator. The first time I clicked on the > "Administrator" icon > on my desktop I get an error that says "failed to start because > msvcr70.dll was not found. Try to reinstall. I did remove the > program a

Calculation in a mysql column

I am using mysql 4.0.16. Is it possible to put a calculation of two other columns as the default value for a third column? Like: time = decimal 3,2 rate = decimal 3,2 totals = default is time * rate Thanks, -Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mys

help / MySQL 3.23.49 vs. BerkeleyDB 4.0.14? (fwd)

hi all, i've built mysql-3.23.49 on MacOSX Server 10.1.4, as well as Sleepycat's BerkeleyDB 4.0.14. i note the "--with-berkeley-db" options in configure, but am stumped as to if/how to allow support for the bdb 4.0.14 version. mysql (in configure, acinclude.m4 & aclocal.m4) seems to limit to bd

help / MySQL 3.23.49 vs. BerkeleyDB 4.0.14?

al.m4) seems to limit to bdb-3.x.x support. also, i've read that a "patched bdb" is required in the manual, and that use of a NON-patched bdb will not work . fyi, InnoDB support seems to work fine as an alternative .. comments on status/implementation? thanks! richard -

help / MySQL 3.23.49 vs. BerkeleyDB 4.0.14?

hi all, i've built mysql-3.23.49 on MacOSX Server 10.1.4, as well as Sleepycat's BerkeleyDB 4.0.14. i note the "--with-berkeley-db" options in configure, but am stumped as to if/how to allow support for the bdb 4.0.14 version. mysql (in configure, acinclude.m4 & aclocal.m4) seems to limit to bd

problem with pthreads support on Darwin/MacOSX?

yet figured this out .) one option around this, i suppose, is to delete all references to "-lm" in all mysql files, but i don't think this is the right solution .. help please? richard ---

Replication error

Placed At : Hi.. I have come across a wierd error in my replication setup..I run mysql 3.23.49 on two servers .one is the master and the other the slave..I have jus one DB with jus a single table in it. I 'm getting the follwoing error on my slave

replication error

Placed At : Hi.. I'm facing another problem with replication..I have jus one table with over 4 million records in it. I run mysql-3.23.49 on both my master and slave.following is the problem am facing.. I had taken a consistent dump from the mast

replication error

Placed At : Hi.. I'm facing another problem with replication..I have jus one table with over 4 million records in it. I run mysql-3.23.49 on both my master and slave.following is the problem am facing.. I had taken a consistent dump from the mast

Mysql..Python..& ..MSQLdb

I have been using perl and Mysql together but have decided to try python and Mysql together. I download and extracted MYSQLdb 0.35-1 from Andy Dustman's page. The module does not seen to have instructions for use. Can anyone point me to intructions or examples. My purpose is a user friendly GUI

Re: Mysql..Python..

> My sense is that it's not as popular for use with MySQL as PHP or > Perl, but yes, there are people using it. A few of the MySQL books > out there have descriptions of how to use the Python interface for > MySQL, and (shameless plug) it's one of the 4 languages covered in > the upcoming MySQL C

repost: MySQL 3.23.49 vs. BerkeleyDB 4.0.14? (anybody?) (fwd)

al.m4) seems to limit to bdb-3.x.x support. also, i've read that a "patched bdb" is required in the manual, and that use of a NON-patched bdb will not work . fyi, InnoDB support seems to work fine as an alternative .. comments on status/implementation? thanks! richard -

replication error

Placed At : Hi.. I run a replicated mysql server set up..The version i use on the master is 3.23.49 and on the slave is 3.23.46. following is the problem I'm facing.. the binlog postion on the master and the slave are always in sync with each other

mysql-4.0.2-alpha BROKEN on OSX 10.1.4 Server; WORKAROUNDS incl.,but need help with FIXes

cru .libs/libmysqlclient.a viosocket.o : .libs/libmysqlclient.a ar cru .libs/libmysqlclient.a viossl.o : .libs/libmysqlclient.a ar cru .libs/libmysqlclient.a viosslfactories.o : .libs/libmysqlclient.a ar cru .libs/libmysqlclient.a ar: no archive members specified usage: ar -d [-TLv] archive file ...

mysql-4.0.2-alpha BROKEN on OSX 10.1.4 Server; WORKAROUNDS incl.,but need help with FIXes

bmysqlclient.a viossl.o : .libs/libmysqlclient.a ar cru .libs/libmysqlclient.a viosslfactories.o : .libs/libmysqlclient.a ar cru .libs/libmysqlclient.a ar: no archive members specified usage: ar -d [-TLv] archive file ... ar -m [-TLv] archive file ... ar -m [-abiTLv] position archive

Re: mysql-4.0.2-alpha BROKEN on OSX 10.1.4 Server; WORKAROUNDSincl., but need help with FIXes

dan, thx for your reply! --On Sunday, July 14, 2002 2:04 PM -0500 Dan Nelson <[EMAIL PROTECTED]> wrote: > In the last episode (Jul 13), R Blake said: >> BUG #1: >> does not seem to exist in BSD variants (cref: >> http://www.netsys.com/bsdi-users/2001-11/msg0009

Re: mysql-4.0.2-alpha BROKEN on OSX 10.1.4 Server; WORKAROUNDSincl., but need help with FIXes

ries.o : .libs/libmysqlclient.a ar cru .libs/libmysqlclient.a ar: no archive members specified usage: ar -d [-TLv] archive file ... ar -m [-TLv] archive file ... ar -m [-abiTLv] position archive file ... ar -p [-TLv] archive [file ...] ar -q [-cTLv] arch

AW: Installing MySQL 3.23.51 on AIX 4.3.3

Hi Scott, you have to set the PATH variable. PATH=/usr/local/bin:$PATH in your profile. Then the mysql_install_db runs. -Ursprüngliche Nachricht- Von: Scott Pippin [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 31. Juli 2002 21:17 An: [EMAIL PROTECTED] Betreff: Installing MySQL 3.23.51

Select and = MAX()

Following the Tutorial Creating and populating the table Shop in the db Test.. Why won't the following syntax work? mysql> select price -> from shop -> where price=Max(price) ; ERROR : Invalid use of group function Bob T

RE: Select and =MAX()

Jorge When I issue your suggested commands here are the resulted rows.. mysql> SELECT price ->FROM shop ->HAVING price=MAX(price); Empty set (0.01 sec) But when I issue... mysql> select price from shop order by price desc; +---+ | price | +---+ | 19.95 | | 10.99 | | 3.9

Some Frusrations!!

Jorge, I am spending considerable time working with MySQL...DB2...Sybase..PostgreSQL I am deciding on Project development tools.. Each RDBMS has some short coming for me.. Addressing MySQL which I like very much.. I use v. 3.22.32 because there is not a binary RPM for Caldera 2.3 and 2

Version 3.22.32 Source to upgrade??

I am spending considerable time working with MySQL...DB2...Sybase..PostgreSQL I am deciding on Project development tools.. Each RDBMS has some short coming for me.. Addressing MySQL which I like very much.. I use v. 3.22.32 because there is not a binary RPM for Caldera 2.3 and 2.4 edeskt

@variableName What Version?

I currently use MySQL 3.22.32-log I compiled the source code to use with Caldera 2.3.. Does my version support the use of the @variable syntax.. When I attempt to use this I get error Error 1064 .. I find that this also would not work set @min_price=min(shop.price); P.S What is the log

Mysql Daemon starts at boot then Terminates??

I have deleted the Mysql 3.22.32 install and compiled source for and installed Mysql 3.23.40. The new installation resides at /usr/local/mysql. Make Test did fail onlymerge >From the command line The daemon starts perfectly with either mysql.server startor safe mys

Compiled v. 3.23.40 and 3.23.42 to 12 test Failures

CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Jul 18 2000 /lib/libc.so.6 -> libc-2.1.1.so -rwxr-xr-x 1 root root 1245005 Aug 10 1999 /lib/libc-2.1.1.so -rw-r--r-- 1 root root 2256720 Aug 10 1999 /usr/lib/libc.a -rw-r--r-- 1 roo

Re: Compiled v. 3.23.40 and 3.23.42 to 12 test Failures

Sasha Pachev wrote: > On Thursday 20 September 2001 20:37, R Talbot wrote: > > My problem is probably my lib-2.1.2.so and GNU Make v. 3.78.1 > > being too old but how muc trouble is it to upgrade.the LIB > > V. 3.23.40 is running but with 12 failed tests including

Compiled v. 3.23.40 and 3.23.42 to 12 test Failures

Sasha Pachev wrote: > On Thursday 20 September 2001 20:37, R Talbot wrote: > > My problem is probably my lib-2.1.2.so and GNU Make v. 3.78.1 > > being too old but how muc trouble is it to upgrade.the LIB > > V. 3.23.40 is running but with 12 failed tests including

Re: Compiled v. 3.23.40 and 3.23.42 to 12 test Failures

R Talbot wrote: > Michael Widenius wrote: > > > Hi! > > > > >>>>> "R" == R Talbot <[EMAIL PROTECTED]> writes: > > > > R> Sasha Pachev wrote: > > >> On Thursday 20 September 2001 20:37, R Talbot wrote: > > &

Re: Compiled v. 3.23.40 and 3.23.42 to 12 test Failures

R Talbot wrote: > Boyd Lynn Gerber wrote: > > > What version of Caldera are you running? I may be able to help next week. > > > > tt, > > > > -- > > Boyd Gerber <[EMAIL PROTECTED]> > > ZENEZ 3748 Valley Forge Road, Magna Utah 84044 >

Compiled v. 3.23.40 and 3.23.42 to 12 test Failures

Monty, Took your advice and downloaded mysql-3.23.42-pc-linux-gnu-i686.tar.gz Placed it in /usr/local Renamed /usr/local/mysql to /usr/local/mysql-old unpacked with tar -zxvf mysql-3.23.42-pc-linux-gnu-i686.tar.gz which made /usr/local/mysql-3.23.42-pc-linux-gnu-i686 I checked out the dir (

Help - I'm completely locked out of mysql

> mysql >Subject: Help - I'm completely locked out of mysql >From: Derek Fage <[EMAIL PROTECTED]> >Date: 2001-09-22 14:36:08 >[Download message RAW] > Hi there, If your forgot yout root password try #/bin/mysql > -Skip-grant use mysql;

Re: Compiled v. 3.23.40 and 3.23.42to 12 test Failures

Michael Widenius wrote: > Hi! > > >>>>> "R" == R Talbot <[EMAIL PROTECTED]> writes: > > R> Monty, > R> Took your advice and downloaded > R> mysql-3.23.42-pc-linux-gnu-i686.tar.gz > R> Placed it in /usr/local > R> Rena

Re: Help - I'm completely locked out of mysql

Derek Fage wrote: > Hi Bob, > > Sorry to appear a bit dense, but how do I use the -Skip-grant? > > I don't see a -Skip-grant option in mysql (mysql --help) > > Thanks, > > Derek... > > -Original Message- > From: R Talbot [mailto:[EMAIL PROTECT

Iist number of connections/users

What is the command to list all the users connected to mysql server? Thanks Raj - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To req

Compiled v. 3.23.40 and 3.23.42 to 12 test Failures

Michael Widenius wrote: > > The problem is probably that your tar program doesn't use user-names > but user-ids, in which case the files may be owned by 'anyone. > What output do you get for: > > ldd bin/mysqld > [root@thinkpad]# ls -l /bin/mysqld -rwxr-xr-x 1 root root 1832912 Se

Re: Compiled v. 3.23.40 and 3.23.42 to12 test Failures

R Talbot wrote: > Michael Widenius wrote: > > > > > > The problem is probably that your tar program doesn't use user-names > > > but user-ids, in which case the files may be owned by 'anyone. > > > What output do you get for: > > >

Re: Compiled v. 3.23.40 and 3.23.42 to12 test Failures

R Talbot wrote: > R Talbot wrote: > > > Michael Widenius wrote: > > > > > > > > > > The problem is probably that your tar program doesn't use user-names > > > > > but user-ids, in which case the files may be owned by 'anyon

Re: Compiled v. 3.23.40 and 3.23.42 to12 test Failures

R Talbot wrote: > R Talbot wrote: > > > R Talbot wrote: > > > > > Michael Widenius wrote: > > > > > > > > > > > > > > The problem is probably that your tar program doesn't use user-names > > > > > > >

Re: Select statement problem

I am assuming from your email that the field ID allows duplicates. In that case, use the SELECT DISTINCT syntax ... that will get you back the 1 row you are looking for. However, if the (ID,CompetitorName) tuple is unique, SELECT DISTINCT will NOT help. Hope this helps Raj At 06:12 PM 9/23/200

Re: Compiled v. 3.23.40 and 3.23.42 to12 test Failures

R Talbot wrote: R Talbot wrote: Still having compile problems and GNU binary produces the following info > Michael Widenius wrote: > > > > The problem is probably that your tar >program doesn't use user-names > > > but user-ids, in which case the

Re: Client-side developing

At 02:56 PM 9/25/2001, Walter Omar Autalán wrote: >I want to develop Windows-based client to interact with linux-based >MySQL and I can't realize the best programming language suitable for >that task. >Clients must be run in Windows because customer requirement. Hi Walter, I have been develop

Mysql GUI doesn't like localhost/ New Install..

I obviously missed something because I have installed MySQL many times but this time MySQL GUI would not except localhost in MySQL GUI Options.. but it would work with the actual Host name. Note same versions of all the above with the same Linux kernel work on two other installs.. All have localh

mysql-3.22.33

Please solve the problems # # groupadd mysql # useradd -g mysql mysql # cd /export/home0 # gunzip < mysql-3.23.33.tar.gz | tar xvf - # cd mysql-3.23.33 # ./configure --prefix=/usr/local/mysql # make make all-recursive I have compiled 3.22.32, ...3.23.40.. 3.23.42 All on Linux w/ kernel 2.2.10

Re: 3.23.43 fails merge test ON make test of src.

Michael Widenius wrote: > Hi! > > >>>>> "R" == R Talbot <[EMAIL PROTECTED]> writes: > > R> Hi! > >>>>> "rjtalbo" == rjtalbo <[EMAIL PROTECTED]> writes: > > rjtalbo> I am using Mysql 3.23.40 on Linux ke

Re: 3.23.43 fails merge test ON make test of src.

Michael Widenius wrote: > Hi! > > >>>>> "R" == R Talbot <[EMAIL PROTECTED]> writes: > > > > R> Below is My bug report... > R> Mysql 3.23.40 is runjning after the compile but, > R> after a compile with errors 3.23.42 or

mySql vs Interbase

> > > Hello, > I saw somewhere that this comparaison existed but I can't remember > where. > Does it talk to anyone ? > > TIA, > Fabien (mysql) - Before posting, please check: http://www.mysql.com/manual.php (the ma

MySql and replication

Hello, I have 2 application running in a master/slave mode. - Application A linked to a database D - Application A' linked to a database D' While A is master, A' is in standby mode and D' replicates D. If a problem occurs on A, A' becomes master and D must replicate D'. 1) Is it possible for a

Can't upgrade: "Can't change to run as user 'mysql'"

I have exactly the same problem, with version 3.23.53a. I ask myself if the problem is related with this binary distribution? If I install the rpm from the same version, there is no problem to run mysql. I just don't like the layout of the directories, therfore I would like to install the binary

InnoDB + fulltext + search + support

Hi all, I'm working on design step for a new application and I'm interested about fulltext indexes. I need a safe transaction tables also. Does Mysql support this or is a feature? In need a SOLUTION for a fulltext search on the InnoDB table. Advices or alternative solutions on this topic are

How many Mysql PIDs ?

Please explain why I get multiple Daemon process when I start mysql.server..Such as 1075 pts/0S 0:00 sh /usr/local/mysql/bin/safe_mysqld --user=root --pid 1093 pts/0SN 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/ 1095 pts/0SN 0:00 /usr/local/mysql/libexec

Too many PIDs

Jeremy So what your pointing out is I am seeing several threads generated by mysqld... But that does not answer as to why the rpm installation start with one thread?? Both installations which I compiled from source start with multiple threads.. ( diffrent machines Caldera 2.3) Sa

How many Mysql PIDs ?

> Re: How many Mysql PIDs ? > Date: > Thu, 7 Jun 2001 15:42:15 -0700 > From: Jeremy Zawodny <[EMAIL PROTECTED]> > Reply-To: > [EMAIL PROTECTED] > To: R Talbot <[EMAIL PROTECTED]> >CC: >

Re: Too many PIDs

Jeremy.. Apoligies I shot off an email to you 3 seconds before I saw this one. Please read both..this email and that email.. Jeremy Zawodny wrote: > On Thu, Jun 07, 2001 at 07:36:54PM -0400, R Talbot wrote: > > Jeremy > > > > So what your pointing out is I am s

Help me HOw to load Images or pictures into MYSQL database

hello Please inform me how to load IMAGES INTO MYSQL TABLES. thanks Palaniappan _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Console Remote connect Commands

As a long time DB2.. Sybase.. & Postgresql user upon turning to MySQL I find only some functionalities not intuitive. 1. What command syntax to use and connect to a database on another host. ( where I have granted permissions in mysql tables User..Host..and ..DB ) ( have been successf

Couldn't select database

Hi Jake, Your problem appears similar to a problem I had but... you aren't providing quite enough information.. Are you working as a user on the same local host or are connecting across a network? To eliminate a MySQL problem ( so you can concentrate your efforts on PHP code) try to connect d

From amar

Hi All, I have one doubt. What is the maximum no of records that can be added to the table,in mysql database?(i.e)Maximun number of rows. If any one knows the answer please send me to the following mail-id amar -

Re: New User Setting up MYSQL

ing the installation. I wasn't sure what to use > to Default Schema so I just put in test. I keep getting a connection error > number 2003 stating I can't connect to MYSQL server. Is there something > that someone can suggest? > > > > Thanks, > > > > Chu

Re: Connection Pooling

romyd misc said: > Hi Everyone, > > I'm developing an application using C# .NET and mysql as database. It's a > multithreaded application, we open a mysql database connection at the very > beginning when the application is started and all the database requests > use > the same connection. But under

RE: LIMIT Question

somewhere >> > between 1000 and 2000 rows, but you just want to see the >> last 50. These >> > last 50 might be the most recent entries, for example. Can >> this be done >> > in single query? >> > >> > Dirk Bremer - Senior Systems

MySQL 5.0.22 install problem with NetBSD

D] 20050518 >Environment: System: NetBSD roswell.lazyrockinw.com 3.99.20 NetBSD 3.99.20 (piggy) #2: Mon Jun 12 22:59:37 CDT 2006 [EMAIL PROTECTED]:/stuff/src_current/sys/arch/i386 /compile/obj/piggy i386 Some paths: /usr/pkg/bin/perl /usr/bin/make /usr/pkg/bin/gmake /usr/bin/gcc /u

Re: 1 to many relationships

ore issues, but no issue can 'belong' to more than one customer then its 1 to many and you can put the customer ID in the issues table. If several customers can have the same issue (row) then you will need an intermediate table which has two columns: customerID and issueID. --- Wi

Re: Windows Server Configuration

Just noticed that you said partitions. I am assuming that you meat multiple drives in a raid array. Bill David Lazo said: > Thanx again. > > For the time being, we will keep 4 drives with Dan's suggestion. OS and > MySQL running from there. > > > > On 8/25/06 11:03 AM, "Dan Buettner" <[EMAIL PR

Re: file i/o operations...

A couple of comments: - Simultaneous connections can be increased, but at some point the user than runs the mysqld process will run out of file handles it can allocate (each table takes 2 or 3). - If we are talking about a database server and test server being the same box then what are you trying

RE: RE: How to rewrite query

Would it not be best to have the field with the fewest repeats (i.e., the closest to unique) first, or is that what you meant. Bill On Tue, October 17, 2006 10:12, Jerry Schwartz said: > I didn't think of that (combinations). You are probably right. Due to my > background, I tend not to think a lo

Re: Simple JOIN on three tables

; -- > http://www.spacemarc.it Well that's what you asked it to do, if you look closely at your query. How are table a, b, and c related to each other? Do you want all the information from each of the tables (which are NOT related to each other) between the specified dates? If that is the

Re: Simple JOIN on three tables

it a RELATIONAL database. If the tables don't have such a relationship you are asking for the UNION of the separate information from table a, where it meets its WHERE conditions, and the information from table b where it meets its WHERE conditions. The fact that both where conditions are the

Re: Simple JOIN on three tables

t; Then it is really a UNION. I hope you have the date field as an index otherwise you are looking at a table scan which is always slow. --- William R. Mussatto, Senior Systems Engineer http://www.csz.com Ph. 909-920-9154 ext. 27 FAX. 909-608-7061 -- MySQL General Mailing List For list

Re: Alter Table Add Column - How Long to update

to match the new structure), drop the old table and rename the new table to the old tables name. So the time might be realistic. It depends on the hardware you are using and what else is going on on the system. Hope this helps. --- William R. Mussatto, Senior Systems Engineer http://www.csz.

Re: copying rows from one MySQL server to another

aptop clients connect to, which handles the syncranization of the data. I have built a few like this in the past (working on another now) and it works great. Basically, all you have to do is track which records have not been synced each way and then have the client & server do it w

Re: storing php pages with sql queries in a mysql database

d: You have an error in your SQL syntax near 'temp' > > how do stop mysql from trying to interperate this data and blindly store it > ?? Another solution would be to base64 encode the data before storing it in the database. -- Lamont R. Peterson <[EMAIL PROTECTED]> F

Re: Regex problem..

s: > > <http://dev.mysql.com/doc/mysql/en/string-functions.html> > <http://dev.mysql.com/doc/mysql/en/string-comparison-functions.html> As Michael suggests, better to do this in an app. It should not take you very long to write a quick data importer in PHP that woul

Difference between Blob and varchar binary

I was storing some 8 bit information in a varchar binary field (encrypted stuff) and I think its getting corrupted. I thought they were (except for size) interchangable? I'm running debian GNU Linux and haven't moved to sarge so I'm still on 3.23.x but will be moving shortly. ---

Re: Difference between Blob and varchar binary

Gleb Paharenko said: > Hello. > > In my opinion, one of the causes of the problem can be the processing of > trailing spaces in varbinary fields. See: > http://dev.mysql.com/doc/mysql/en/binary-varbinary.html Thanks, you may be right since the results are too short. > >

  1   2   3   4   5   6   7   8   >