MySQL Database Forum

I'm been looking for a way around this. There doesn't seem to be, but I'm hoping someone here knows. It seems to have to add a user to the mysql.users table for each HOST they want to connect from. Well, we have a few users (admins) who access the company DB from home and they have dynamic IP addresses (dialup or DSL.) Is there any way to...

Hello Everyone, I have been searching around for an answer to this question with no luck. I hope that some of you may have a couple of good ideas I could try. I am running MySQL 4.1.20. In one of my databases, I have two tables: patients, visits.

Hi, I want to start the mysql services by manually in the dos on windows...... Starting an Mysql Service : shell>net start mysql The service name is invalid.

The following code works fine select concat( case t1.testColumn when 'value1' then t1.column1 when 'value2' then t1.column2 when 'value3' then t1.column3 else t1.column4 end

Hey all I have a column of user membership ids that is 8 characters long. These ids are based on the users surname with number added on the end to uniquely identify each user. My problem is that if the users surname is short, there are spaces between the end of the surname and the numbers. There are 18000 or so members in the database...

Helo, I have problem in finding right tutorial how to create multi key in DB. I have 4 tables. in each I have TIME datatime Nr int I want them as a MUL key, could You help me in creating the right code to create such a tables.The code has a bug in sql syntax, can You see CREATE TABLE table1 ( value int(11) NOT NULL default '0',

Query a list of CITY names from STATION with even ID numbers only. You may print the results in any order, but must exclude duplicates from your answer. This Was My Solutino.... SELECT CITY FROM STATION WHERE MOD(ID,2) = 0; BUT ITS NOT WORKING

------=_NextPart_000_003E_01C34934.FBC032B0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Hello, I'm looking for a solution to write a sql query that inserts a set of = data if the data id is not present and otherwise update the set.

I'm currently working on a component tracking file and we are using an hour meter query to always have up to date information. My problem is that I need the hour meter query to display the reading of the most recent date for each equipment number. My columns are: EQUIP_NO DATE_READING CONDITION LIFE_TO_DATE I want a single SQL query...

Hi, I haven’t select data from any table in mysql database. While I selected the data I got ERROR 1033 (HY000): Incorrect information in file error. I have not changed any configuration in mysql database. How can I resolve it? Thanks, Michael

Hello I have a problem with mysql. Using the tables of type INNODB, mysql it has created the archives (ibdata1) whose dimensions exceed the 3G. I have cancelled all the database but the occupied space is remained the same one. How I can make in order to compattare this space? Thanks

I'm not finding what the maximum number of characters that a statement can be. Anyone know where I can find that spec?

Hello all I installed php, mysql and IIS in xp. Problem is this while i run following file <?php phpinfo(); ?> it doesnt show mysql info table in result. I seen mysql server it is running well. While i am trying to connect my php file to mysql database then it doesnt connect. why it is happening? how to short out this problem, please...

Hello, I'v installed mysql 5.0 (MySQL-server-standard-5.0.27-0.rhel4.i386.rpm) on RedHat AS4. When I start mysql through command line (i.e. /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/tmp/mysql.pid & ), everything is ok. But when I use "service mysql start" command launch it, mysql just quit silently. The log file report is:

Hi List Me again. I'm trying to return from multiple tables, the records that have field "information_sent" between two dates. The tables are all related by means of the id of the entry in the main table, ie.. main id entity_name ...

Hello, I am using a GROUP BY in a query as follows --> SELECT * FROM log GROUP BY name ORDER BY name,arrive,id desc I want the rows which have the maximum id in the result of each "group by". Please tell me how to do that ?

I have a MySQL-server running Innodb. We have installed ~ 2GB of memory in the server. In spite of this MySQL keeps crashing due to out-of-memory errors. The server is a dual xeon i686 running kernel Linux 2.4.20-8smp redhat stock. Top shows mysql steadily consuming more resourses over a period of 2 hours, up to 1.2 Gb, before it...

hi can anybody tell, how can i fetch last record from table. In that table only one varchar type column is there like name

Hi, I'm fairly new to MySQL and learning as I go, generally speaking so far so good. At present I have a question to which I cannot find an answer, so I was hoping someone may be able to help me out. For the site I am writing the user my apply to become a member (this is for a leadership forum) in doing so they have to supply a user...

Sub: Append a string to all the values in a column SQL Hi all, This might be a very simple query. But I am new to SQL programming. Hope someone can help me. I have a table --- 1634 Fred los angeles 123 Sam

Our production database in an exported textfil runs about 60 MB. Compressed that's about 9 MB. I'm trying to import the export into another machine running FC3 and mySQL 11.18, and it appears as though the file may be too big! When I try to do it via command line: mysql -u root --host=localhost printing < ./printing.txt It eventually...

Hi, I have a site with various parts which allow users to enter info via forms which gets entered into various tables in a MySQL db (I'm using ASP, rather than PHP). I have an ecards bit, and when users send a card, their data is entered into the db via something like: INSERT vars into ecard_tbl....

hai guys i am facing a small problem... i am trying to upload a file of size 4mb .....but i am getting this error "Got a packet bigger than 'max_allowed_packet' bytes" how to solve this Thanks , pradeep

I just installed Slackware 10.1 Still need to install some missing needed libraries, but I think that's unrelated. Every time it boots up, or I try "/etc/rc.d/rc.mysqld start" I get this: Starting mysqld daemon with databases from /var/lib/mysql STOPPING server from pid file /var/run/mysql/mysql.pid mysqld ended

Am i able to an INSERT into a row that adds to and doesn't replace the current data? I know i can SELECT the data and concat it with the new data in PHP then INSERT it but i was wondering if i can do it with SQL only? I haven't been able to find anything on it... Thanks