Ordering rows whit a select from where in ( exp )

der as the in list of ids.Any ideas? Should I use order by? Whit witch option ? Thanks for your help. Adrian.

Re: Coded fields

I would approach this in practically the same way as yourself but used an enum field in the student table (like what you were thinking). When a user wants to add or remove an enum value you can build an appropriate MODIFY statement like: ALTER TABLE my_table MODIFY my_col ENUM('K','X') NOT NU

Re: How to rename a DB

Stop the server, go to the MySQL data directory and physically change the name of the directory that corresponds to the database. Restart MySQL server and SHOW DATABASES to see the change take effect. George Law wrote: Hardi I rotate tables out on a monthly basis. The way I do it is: ren

Certification examples

Hi I have bought the MySQL certification study guide (v 5.0) and am almost ready for the exams, does anyone know if the questions in the self study guide are very similar to the ones that you get in the exam? and is there anywhere else that i can get more questions like this for practice pur

Re: Multiple engines in one DB a problem?

/en/storage-engines.html Regards Adrian [EMAIL PROTECTED] wrote: I'm trying to find a weird performance problem in a MySQL database. I use MySQL v5.0 but the db was migrated forward from a v4.1(?) system. Looking at the schema in a recent backup, I was surprised to find different engines

Re: Replacing A Value

UPDATE Query Tip No. 1: Manuals, Google etc Tip No. 2: Posting a question like this may result in sarcastic responses and possibly mass flaming Ed Curtis wrote: I have a column in a table I need to replace a value of certain records in. The current value is /realtors/Value/. I need to ch

Re: Selecting Common Data

John I think you are saying you want the "Mode"? if you are then the following might work: SELECT col2 as val, count(col2) AS cc FROM my_table GROUP BY val ORDER BY cc DESC LIMIT 1; in your case this will retrun the value '2' Regards Ade John Nichel wrote: Running MySQL 4.0.20 on a RHEL3 b

Re: Too many table-locks

could consider splitting the posts table and compressing the old threads, how you could implement something like this would depend greatly on your forums application however. Hope this helps Adrian Marco Simon wrote: Hi everybody, I've got a little problem with a web and mysql based bull

Re: HELP!

Not the best start to the day, if you have a fairly recent backup and have enabled binary logging then you can recover up to the point before you screwed the data. Peter Lauri wrote: Hi, I did something terrible similar to UPDATE table SET testdate=NOW() And I kind of forgot the WHER

Re: Semi-complicated delete

IN MySQL 5 you could use a sub query( http://dev.mysql.com/doc/refman/5.0/en/any-in-some-subqueries.html). However, i would try using a left join between cart and products and then bring back the results where the products.id field is 'NULL'. There may be a better way of doing this but that

Re: table missing

The table may be damaged and seemingly unavaible to languages like php(has your box crashed recently??), run 'SHOW TABLES' from the command prompt and it should appear.If it does try running 'CHECK table' to see if is damaged or not Jon Miller wrote: I've created a database with a table and

Auto-increment & indexes

Hi, im hoping to solve a problem that is bugging me! I just moved a database from a development server to production (test), several of the fields have auto-increment ticked but as it is mainly a data warehouse i thought nothing of it. I then found that a lot of my queries were running slow

Sudden Mysql Crashes - table damage?

HI MySQL 5.0 (windows XP) I have a problem where i think some of my tables have somehow been corrupted, if i try to run a check table command against some tables the mysql service crashes and i have to restart it. I am not sure how this damage has occurred but has anyone got any suggestions

Re: Sudden Mysql Crashes - table damage?

Thanks for the reply yep mysqldump also causes the service to crash. i have a few innodb tables mixed in amongst the myisam, it seems that it is the innodb tables that may be causing the problems but i am not sure why ??? Imran Chaudhry wrote: On 1/31/06, Adrian Bruce <[EMAIL PROTEC

MySQL PDA Synch

hi I have an online registration system made with PHP and MySQL that i would like to make available for use with PDA's. We have a wireless network that covers only certain parts of our area and when the PDA's can connect there will be no problem as I have PDA style sheets set up. When the w

MySQL Certification Questions

Hi Does anybody know where i can get a load of sample questiosn for the MySQL certificate exams, i know there are a few on mysql's site but i was hoping to find quite a few to practice on. Thanks Ade -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: simple addition in a query?

I think the following should work, try taking a look on the net for help on MySQL queries that use aggragate functions, there is probably a lot of info on there. select exim.hour,sum(exim.count) from exim,servers where exim.machine=servers.id and servers.type='MX' and exim.date='2006-02-22' g

Re: query problem

one solution (may not be the best but would work) would be to use 'like' instead of '=' and then put wildcards %%$var % around the variable so that if it is not there then it wount effect the query. Ade [EMAIL PROTECTED] wrote: I am fairly new to sql and am now getting into the area of slight

Re: Please help: recovering db from crash

not sure, but it may be worth trying the following run the script: mysql_install_db --user=root In the installation dir this should change ownership and make mysql recognise the data dir. good luck Ade Foo Ji-Haw wrote: Hi all, My Windows-based database server crashed (no fault of MySQL. pr

Re: LOAD DATA giving BIG mysql-bin files ...

I think this is normal as the binary log will contain a record of all changes made to the data, therefore if you are loading large files regularly- the bin logs will be quite large. If you do not want the binary logging, edit the my.cnf file, comment out the line log-bin (#log-bin) and restart

Determining if a trigger exists

Hi, Whats the simplest way to determine if a trigger already exists? i.e. For tables you have: CREATE TABLE IF NOT EXISTS ... Is there a way to do CREATE TRIGGER IF NOT EXISTS I'm using MySQL 5.0 btw. Thanks! Regards, Adrian -- MySQL General Mailing List For list archives:

Re: Determining if a trigger exists

s the basic things like create database if not exists, create table if not exists, etc. I was hoping the same thing for triggers maybe? Is this possible? Regards, Adrian Co Jim wrote: There is a TRIGGERS table in the information_schema Eg. select Trigger_Name from TRIGGERS where trigger

Re: Determining if a trigger exists

syntax is not valid. Alternatively, you could try it yourself and see that it fails. -Sheeri On 4/7/06, Adrian Co <[EMAIL PROTECTED]> wrote: Hi, Sorry if I wasn't very clear with my question. I was hoping to obtain the functionality such that I could do something similar to

Getting mySQL to ignore case sensitivity of field names

tainly set any options. When I Google all I seem to get are hits about ignoring case in select query values not field names. Many thanks Adrian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Getting mySQL to ignore case sensitivity of field names

o only talk about field values. Regards Adrian - Original Message - From: Scott Haneda To: Adrian Aitken Cc: mysql@lists.mysql.com Sent: Thursday, August 27, 2009 11:04 PM Subject: Re: Getting mySQL to ignore case sensitivity of field names http://dev.mysql.com/doc/refman/5.0/en/case-se

How to quickly detect if there are any crashed tables

utes, it hasn't finished. I am looking for a solution that will give me an answer in at least 3-4 minutes. I apreciate any sugestions you might have. Thanks, -- Fita Adrian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: How to quickly detect if there are any crashed tables

useable solution. Do you know if during the auto-repair at startup, the server with all the tables will be available and answering to queries? Or will it make the tables available as it progresses with the repair? -- Fita Adrian -- MySQL General Mailing List For list archives: http://lists.mysql.c

Re: How to quickly detect if there are any crashed tables

Indeed, I was thinking about scanning the log file as a last resort, but I'm thinking how can the daemon report that some tables are crashed and need repairing at startup so fast? Shouldn't it be possible to apply the same method after the daemon has started via an external command or

Re: Looking for consultant

ditional production capacity >> then the terms you may want to investigate are 'scale out', >> 'partitioning', and 'replication'. All high-availability solutions >> require at least some level of hardware redundancy. Sometimes they >> require multiple layers in multiple locations. >> >> Several of those features of MySQL also help with meeting some >> high-availability goals. >> >> Are you willing to discuss your specific desired availability >> thresholds in public? -- Adrian Fita -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: Query question.

you need to group the result sets by date, look at the manual link below: http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html Richard Reina wrote: I have a database table paycheck like this. empno, date, gross, fed_with 1234 "2007-09-01" 1153.85 108.26 1323 "2007-09-01"

Re: query question

there should be no space between function name and () i.e. it should be group_concat(hosts.name) (unless you have the sql mode IGNORE_SPACE set) Andrey Dmitriev wrote: I knew I’ve seen this error before ☺ Thanks a lot. -andrey From: Peter Brawley [

Re: Large import into MYISAM - performance problems

You could load the data into several smaller tables and combine them into a merged table which would have no real effect on the schema. Ade Simon Collins wrote: I'm loading the data through the command below mysql -f -u root -p enwiki < enwiki.sql The version is MySQL 5.0.51a-community I've

mysql query, min, max with where conditions

Hello there, What is the corect syntax for selecting something like: select a, b, (min(q) where date<100), (max(q) where date>100) from a left join b left join c group by a.p i need min() max() values each of them with other WHERE clause. How can I do that? Adrian. -- MySQL General M

Re: mysqldump slows to crawl

Try dropping the indexes first if you can, would save you about half the time and then re-build them after the dump finishes. Obviously you would need to do it at a quite time though when the DB is not being used. Is a binary backup not an option? at 29G is a large text file to write Ade D

Re: Selecting just the first 2 values

add "LIMIT 2" to the end of the statement goose wrote: Hi All, I have the following SQL statement SELECT channel.channel_name, program_title, start_time, finish_time FROM program, channel WHERE program.channel_id='3' AND program.channel_id=channel.channel_id UNION SELECT channel.ch

Re: Pointers about replication

link for more info: http://www.onlamp.com/pub/a/onlamp/2006/04/20/advanced-mysql-replication.html hope this helps Adrian Cabbar Duzayak wrote: Hi All, Would it be possible to provide some advanced pointers (articles/books/tutorials/sites) for learning more about replication? I am particularly

RE: Trouble with LEFT JOIN

Hi There, If I interpreted what you are trying to do is to return all the rows from Challenge and reference Patrocinio excluding those rows in Patrocinio where PTRN_ID is 1? Not sure if the below is possible in MySQL but I've used this in other places when doing a left join and needing to excl

Restoring mySQL dump

Hello, I need to restore a mySQL dump file but cannot find the right syntax. I have root access and have used: mysql -u root -p account_databasename < backupname But I am getting: Access denied for user '[EMAIL PROTECTED]' (Using password: YES) I have also removed the root password and got: Acces

Re: Restoring mySQL dump

correct. The password for mysql root is probably not the same as the system root. ddh Quoting Adrian Cooper <[EMAIL PROTECTED]>: Hello, I need to restore a mySQL dump file but cannot find the right syntax. I have root access and have used: mysql -u root -p account_databasename < backu

Re: Restoring mySQL dump

SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE="NO_AUTO_VALUE_ON_ZERO" */; Thanks very much. Best regards, Adrian. [snip] mysql -u root -p dbname < backupname.sql And getting: ERROR 1064 at line 20: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL serve

Re: Restoring mySQL dump

Hello, None of these lines describe the problem that you are having with syntax. Can you give us 5 lines either side of the line that includes 'DEFAULT CHARSET=latin1'? Yes, here it is: `user_id` mediumint(8) unsigned NOT NULL default '0', `group_id` mediumint(8) unsigned NOT NULL default '0', `quo

Can't start up - access denied to root

is the reason.] So - please excuse what is probably a rather basic question but can anyone suggest what I should explore to get this going again? Or point me at an archive thread that deals with it? Regards Adrian G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: Problem with data import from text file

file? I do not know how to do that. Can someone explain what is probably a very simple matter or is something still not happening correctly? Or should I revert to version 3 for my fairly simple training purposes? I am puzzled because previously this did work. Thank you. Regards Adrian

Re: Problem with data import from text file (part two)

gards Adrian Greeman please also send a separate smaller message to tell me the other one is coming. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Subject: Re: Problem with data import from text file (part two) Thanks

those more knowledgeable. Regards Adrian Greeman -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Problem with data import from text file

see that I am doing anything different. I have MySQL 4.0.12 on Windows ME PC with a local Apache server and PHP. Any ideas please? Regards Adrian Greeman PS I sent a long message about this and a connection problem yesterday which was not succint enough. Apologies -- MySQL General Mailing Li

Load data: odd behaviour

m start to finish. Anyone heard of this behaviour before? Maybe a mysql config blip? Adrian ** Granada Sky Broadcasting Limited ("GSB") Franciscan Court, 16 Hatfields, London SE1 8DJ Tel 020 75

RE: Load data: odd behaviour

o 6am, would you believe! So Friday 26th starts at 6am. 4am tonight is classified as 2003-09-25. It just helps to have the transmission order in place right from the start! Thanks Adrian -Original Message- From: gerald_clark [mailto:[EMAIL PROTECTED] Sent: 25 September 2003 14:32 To: Adrian

ERROR ON INSERT DATA FROM FILE

; instruction which phpMyAdmin creates. It refused to do it and returned the error message: #1148 - The used command is not allowed with this MySQL version I feel there must be a simple explanation May I ask if anyone can help??? Regards Adrian PS I am

Re: ERROR ON INSERT DATA FROM FILE

Thanks for the answer - but I am already the root user and have phpMyAdmin using the root also (because this is just a single computer for testing work and there are not any bit security issues). - Original Message - From: "Remi Mikalsen" <[EMAIL PROTECTED]> To:

files stored in fields

field do I need for those and again how to insert? Regards Adrian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

simple question on WHERE SELECT query

t to enter a row into a book table which uses author_id but you only know the name. I think the statement involves a WHERE followed by a SELECT but am unsure of the precise syntax. Regards Adrian -- MySQL General Mailing List For list arch

Can't connect to MySQL server & Access denied for root

Hi, I removed an old mysql version and I installed a new one on a machine running Suse 8.1 Linux. shell>rpm -i MySQL-client-3.23.54a-1.i386.rpm shell>rpm -i MySQL-shared-3.23.54a-1.i386.rpm shell>rpm -i MySQL-devel-3.23.54a-1.i386.rpm shell>rpm -qa | grep -i mysql shell>reboot shell>safe_mysqld --

MySQL Replication

? % show databases; Output: Database_A Database_B Thanks. -- +-++ | Adrian Hoe | [EMAIL PROTECTED]| | Procrastination prevents creativity | [EMAIL PROTECTED

Re: MySQL Replication

Dicky Wahyu Purnomo wrote: > > On Wed, 03 Apr 2002 18:53:00 +0800 > Adrian Hoe <[EMAIL PROTECTED]> wrote: > > > Hi, > > > > My department is migrating our application from MySQL-3.22.x to 3.23.49. > > I am > > interested in the new replication f

Romanian translation of error messages

not present in the standard characters of the linux. In what character set must I save the files? My name is Stefanescu Adrian. e-mail: [EMAIL PROTECTED] the source is of the file is: /* Copyright Abandoned 1997 TCX DataKonsult AB & Monty Program KB & Detron HB This file is

3.23.51.make error: libmysql.c:1325: warning: passing arg 5 of `gethostbyname_r'

local/mysql-3.23.51' make: *** [all-recursive-am] Error 2 mail:/usr/local/mysql-3.23.51 # i've done ./configure --prefix=/usr/local/mysql \ --enable-assembler \ --with-innodb Further details: OS: SuSE Linux 8.0 Pro PC: AMD 750, 30 GB drive, 384 MB Memory Many thanks i

mysql error

mp/mysql.sock but I still get the error ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) How do I solve this as I am in the middle of a web database project TIA Adrian --

RE: mysql error

Hi, Thanks. After sending my mail I found out that the mysqld was not running. Now it is fine. Thanks once again Adrian On Tue, 17 Jul 2001 [EMAIL PROTECTED] wrote: > as opposed to using safe_mysqld > try starting mysql using > /etc/init.d/rc.d/mysql start > and stopping

rand()

version() | +---+ | 3.23.36 | +---+ How do I do this. Adrian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this t

How do I do this?

display another sent of 7 >records but it just keeps displaying the same. > >+---+ >| version() | >+---+ >| 3.23.36 | >+---+ > >How do I do this. > >Adrian > - Before posting, please c

MySQL with Redhat 7.1

quot;MySQL ends") without an error!! The user "mysql" exists (Created by the install). Are there any other actions I need to do before trying to start MySQL? Can anybody help? Many Thanks, =Adrian= Information in this message is confidential and may also be legally privileged. I

Re: Problem with Mysql

I think that you would have got the answer by now, but initally mysql does not need a password. You can just login without the password, then change it using mysqladmin newpassword. Adrian On Fri, 9 Mar 2001, Luis wrote: > I read the manual plus look on the site. I been having trou

Re: Problem with Mysql

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sun, 19 May 2002, Luis wrote: > #mysqladmin -u root -p password 'newpassword' > > or > > #mysqladmin -u root password 'newpassword' > > i got a error. but when i tried the 2 one it work. But in the manual it says to do >the top one

members list categories & inserting db into webpage

First of all, since you are not a programmer, it is going to be difficut. I have done something similar but for a travels site using php and mysql. I suggest you send me a private mail I will help you if I can Adrian I've got mysql and php installed on my server and i was wondering if a

Re: Betr.: information

I know this question is not related here, but while on the Oracle Question, could someone tell me how to install Oracle for Linux of the list :) Adrian On Thu, 29 Mar 2001, Freaked Personality wrote: > Yea oracle has been ported for a while already, been running it for like 6 > months o

Re: Error

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 What did you do to get the error Adrian On Fri, 30 Mar 2001, Lebrun Jonathan wrote: > What's error 1062 ? > > Thanks. > -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.2 (GNU/Linux) Comment: For info see http://www.gnupg.

Re: help on mysql tables

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 What are the results you expect. There are always workarounds Adrian On Fri, 30 Mar 2001, Ramasamy Palaniappan wrote: > Sir, > > created the following tables as primary and secondary > > primary : partycode(primary key),partyname

Re: HELP me!

Could you do a ps -aux |grep mysql This will tell you if mysql is already running. Adrian On Fri, 6 Apr 2001, François Grenapin wrote: > the file error_lod said me that : > 10406 10:59:50 mysqld started > 010406 10:59:51 Can't start server : Bind on unix socket: Permission

Problems with transactions on InnoDB tables

Hi, I'm a beginner with MySql. Could anyone give me an example how transaction isolation works on InnoDB tables under Win2000? (If you have any examples I'll be happy). Thanks in advance. Adi - Before posting, please check: h

Problems with my.cnf

Hi, Could anyone tell my why from time to time, the file my.cnf (under Win2000 and MySql) is automatically renamed into my_cnf.bak? Adrian - Before posting, please check: http://www.mysql.com/manual.php (the manual

last week, this week

Hi, I have a table that hold a lot of information about pricing and dates. I would like to list the of differnce of prices between last week and this week. Adrian - Before posting, please check: http://www.mysql.com

RE: last week, this week (fwd)

> -Original Message- > From: Adrian D'Costa [mailto:[EMAIL PROTECTED]] > Sent: Friday, September 21, 2001 12:56 AM > To: Mysql Mailing List > Subject: last week, this week > > > Hi, > > I have a table that hold a lot of information about pricing and da

Re: strange

gt; whereas you probably meant > > WHERE na.nid=nc.id AND (na.nid=1 OR na.nid=3 OR na.nid=9) > > which also can be written as > > WHERE na.nid=nc.id AND na.nid IN (1, 3, 9) Interesting. I never knew that I could you thi

how to get the correct result -- Thrid Time --

rtrim nothing works. Second, using the same data I get some of the hotel names in CAPS and I need to convert it to lower and then group by. How do I get these two done? Thanks Adrian - Before posting, please check: htt

Re: why

On Wed, 17 Oct 2001, Jani Tolonen wrote: > Adrian D'Costa writes: > > Hi, > > > > I have been using Mysql that was provided on my RH7.0 cd. It works on my > > office system and it shows only one process. The same thing I installed > > on m

Re: why

On Thu, 18 Oct 2001, Jani Tolonen wrote: > Adrian D'Costa writes: > > > If you 'office system' is, for example, Sun Solaris, you will see only > > > 1 mysqld process with 'top'. The fact that in Linux 'top' shows > > > actu

RE: how to get the correct result -- Thrid Time --

If there's still a problem, >replace all tabs (\t) and carriage returns (\r) with a space, and repeat the above. >And from now on, make sure the data gets put in right :) Well that would only get the first two spaces. I do not know how many spaces are there Adrian > >

RE: how to get the correct result -- Thrid Time --

| | 9757 | aegean village | | 7973 | aegean | | 8917 | aegean village | | 8122 | aegeon | | 8284 | aeneas | +--+-+ Atain 5208 and 3063 are the same so is 9757 and 8917. I just want only one of them to ap

Re: how to get the correct result -- Thrid Time --

he space (" ") will match if there are two spaces. I am not sure how may are there. Adrian > > > > On Fri, 19 Oct 2001, Adrian D'Costa wrote: > > | Date: Fri, 19 Oct 2001 10:43:31 +0530 (IST) > | From: Adrian D'Costa <[EMAIL PROTECTED]> &

Re: how to get the correct result -- Thrid Time --

| | 8917 | Aegean Village | | 8122 | Aegeon | +--+-+ Thanks Adrian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To r

MySQL on QNX6_10 (newest RTP)

Can anyone help me? gruß, Adrian Skupien -- Adrian Skupien Web-Entwickler E-Mail: [EMAIL PROTECTED] Friedrich-Ebert-Strasse 153 42117 Wuppertal Fon +49 (0)202 69 50 306 Fax +49 (0)202 69 50 299 Didn't take a look at http://www.ers

winadmin stopped on Beta

elp - what might I have done wrong? Or is theresome reason why WinSQLadmin will not pull running information out of the beta version Thanks Regards Adrian Greeman Telephone +44 20 8672 9661 Mobile +44 780 329 7447 e-mail:- [EMAIL PROTECTED] or [EMAIL

winSQLadmin stopped on Beta

son why > WinSQLadmin will not pull running information out of the beta version > > > > > Thanks > > > > > Regards > > > Adrian Greeman > > - Before posting, please check: http://www.mysq

Interesting innodb activity with 3.23.52

ke to take advantage of all the changes made between .49a and .52. Adrian Liang Em: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the

RE: Interesting innodb activity with 3.23.52

Thanks Heikki, Is there an easy way for me to see which version of glibc a particular RPM was compiled against? Adrian Liang Em: [EMAIL PROTECTED] -Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Sent: Saturday, September 21, 2002 1:34 PM To: [EMAIL PROTECTED

Using a query as a source for another query?

ndows 2000 (SP3) platform. Adrian [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail &l

how to recover innodb tables

st do a "select into outfile" and my data, but it won't start (I've tried values of 4, 5 and 6). What else can I do to get at the data? Thanks! -Adrian uname -a: Linux db1f2 2.4.2-13-p1-psmp-4g #1 SMP Mon Aug 20 13:24:15 PDT 2001 i686 unknown Error log snippet: 021101

Replication error?

ould be able to act as a slave reading from B. However, whenever I start A it starts to skip large chunks of the update log. C doesn't seem to have this problem. Does anyone know what is making this happen? Using: 3.23.49a-Max kernel: 2.4.9-34enterprise Thanks, Ad

Re: mysql database export

somename.sql connect to phpMyAdmin on your server and there will be a box to load your text file. That should upload your database Adrian On Tue, 10 Apr 2001, ashok wrote: > hi, > > sir,we have to upload mysql database on our website,the isp people has enable mysql >for our

Re: event errors - Registry problems 3.23.36 win-2000

I think you need myODBC. Adrian On Tue, 10 Apr 2001, Daniel Chase wrote: > I have just installed version 3.23.36 on an Intel running windows 2000 > Pro. > > I am trying to use MS Access as a front end but can not get a connect > string to recognize the mysqld server. > &g

Re: MyODBC, NT 4.0 WS, and Access 2000

In your odbc setup did you give the host name that you defined on the linux box? Adrian On Wed, 11 Apr 2001, Fenn Rider wrote: > I am trying to get myODBC working on an NT 4.0 ws, sp6a client, connecting > to a MySQL db running on a linux box. When I try to connect, I get a dialoge >

Re: ms frontpage

On Thu, 12 Apr 2001, ilker YILDIZ wrote: Install MyODBC Adrian > Hi, > I want connect mysql databse with ms front page 200. > How? > What do i? > Thanks. > - Before posting, please check: http://www.my

how is this done

. What would be the correct syntax for the select statement? TIA Adrian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this

Re: how is this done

ULL| auto_increment | city | varchar(35) | | MUL | || countryid | int(5) | Special: id int(5) contid int(5) cityid int(5) Adrian - Before posting, please check: http:/

Re: how can I do this?

Hi, I have four table that have common fields like: date, destinazione and price. I what to create a temporary table with all four fields from four tables, what would be the correct sql syntax. TIA Adrian

why does it not work

4: You have an error in your SQL syntax near 'RAND() limit 1' at line 3 select version(); +---+ | version() | +---+ | 3.22.32 | +---+ What could be the problem Adrian - Before posting, please

RE: why does it not work

On Mon, 21 May 2001, indrek siitan wrote: > order by rand() didn't work back in 3.22. > > if i remember correctly (if this doesn't work, you can try to search > the list archives), the workaround was: > > SELECT col1,col2,RAND() as r FROM table ORDER BY r LIMIT 1; Thanks. Now I am into anoth

bug report

Hello, I think me and my fellows here at office, found a bug in mysql. The system is: RedHat 7.0, kernel 2.2.16, on Celeron 700MHz mysql version 3.23.22 Here is the script: ( cat

RE: why does it not work

u php3 online. Take a look at vvmm.net TIA Adrian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <

  1   2   >