problem solved :) I removed the mysql_error() part :)
$dresult = mysql_db_query($db,$dsql,$link); this works :)
Regards,
Arup Bhanja,
Kolkata, INDIA.
Content is king - but Bandwidth is the real queen!
-
Before posting, please ch
The website works fine for me, Bhanja. It seems like a select query, so I
wonder why you would expect an "insert failed" error? How do you get to know
that you get an insert failed error?
Some more info would be useful. You say, "When I am trying to insert *a*
record, after *10* or so records" --
Hi All,
I am Arup based at Kolkata India. Mysql problem: when I am trying to
insert a record to a table after 10 or so records I get Insert Failed
but no mysql_error(). I am using php4
see: holland.info/search/qs.php?q=mysql&all=1
Regards,
Arup Bhanja,
Kolkata, INDIA.
Content is king - but Ban
Can someone provide insight into what a good maximum number of
columns is in a MySQL database? I have an extensive list of variables
for an engineering application which number in the 700+ range with
more additions possible down the road. My question is: should I break
up the variables into sev
myODBC and MS Access will let you link (live) to a mysql database. Is there
a way to get the mysql linux client to link to another database system?
Could mysql create a live view of data from a as400/DB2 table ? Using odbc I
presume ?
Thanks
I'm trying to start up mysql through dos prompt. When I enter a command
like c:\mysql\bin\mysqld or anything similar (any command in the bin
directory), it just waits there. I can't Ctrl-C out of it. I can end the
process to get out. What's happening?
--
Shion Deysarkar
http://www.contrib.a
Hello everyone,
We can find at mysql documentation, that using transaction may slow down
up to 4 times mysql. This because working with transfaction means to do
a lot of things while updating tables. I'm currently working in a system
where in some cases (very few cases) I realy need to use transa
This almost belongs on the bugs list, but I don't have a stable, sure way
to trigger it.
Symptoms:
mysqld locks itself in a tight loop, consuming all available CPU cycles.
a simple "kill" sometimes kills the daemon, other times a -9 is required.
While in this state, any access to the daemon stop
Mascon from Scibit (www.scibit.com) has cut, copy, and paste in its query
manager.
>Cut, Copy, and Paste functions are not available in the SQL Query tool in
>my MySQLManager tool. Any ideas? Thanks.
>
>
>Mark Herzog
>Contour Systems
>Phone: (952) 935-0141
>Cell:(612) 207-6530
>Email:
I would use the Windows 'AT' command (make sure the Scheduler service is
running) to call a .CMD script with a mysqldump query.
Here's one we use ... the filename is dbbak.cmd:
mysqldump --all --add-drop-table --add-locks --complete-insert --compress --
extended-insert --flush-logs --force --opt
We just brought a database back up after bringing it down for a hardware
upgrade (added hard drives) and after we brought it back up it started
crashing a lot. The queries that crash it vary. I realize it might be
simple case of database corruption (the data files are now on a
different physical
Hi Folks,
Have only known enough SQL to do what we needed.
Today on mysql-3.23.51 we found out that :
select something from table where index1 = 'value' or index2 = 'value';
Runs considerably slower than:
select something from table where index1 = 'value';
or
select something from table wher
Is it possible to use MySQL with a chinese charset (utf8) ?
If not, what do you suggest to do if I want to develop a database for a
chinese web site ?
thanks
-
Before posting, please check:
http://www.mysql.com/manual.php
Bhavin,
> Is there a way to have DB-A and DB-B such that DB-A is the master and DB-B
Can't help you with the replication question - but here is a replication
answer - have everyone in your installation repeat after me: "the DBA is
your master"! (and say it again...and again...)
=dn
List fodder
Any suggestions on replicating data from DB2 files to a mysql database
across a network? Is it possible to link a mysql table like to a portion of
the DB2 data/tables then hotcopy is across the network to the remote
database?
Thanks
Jon
On Wed, 31 Jul 2002 [EMAIL PROTECTED] wrote:
> Date: Wed, 31 Jul 2002 12:49:35 -0300
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> Subject: Automatic timestamping
>
> Hi all,
>
> As I'm not very experienced with DB technology, I'm very sorry if my
> question seems stupid.
>
> I have set
In the last episode (Jul 31), David Kramer said:
> Im looking for info on Mysql's Bulk Data Loading Utility? Does it
> even have one? Does it just use Perl's DBI? Any syntax would be
> greatly appreciated...
Check out http://www.mysql.com/doc/L/O/LOAD_DATA.html . It's a
stripped-down version
In the last episode (Jul 31), Richard Baskett said:
> Ok I've Analyzed each table and it looks like it has cut around 20 seconds
> off of the average time.
>
> Im trying to figure out how I can take out the left joins.. I need
> some of that data to be displayed to the user.. Would it be quicker
Im looking for info on Mysql's Bulk Data Loading Utility? Does it even have
one? Does it just use Perl's DBI? Any syntax would be greatly
appreciated...
Thanks,
DK
David Kramer
Software Developer
Reflect.com
Direct: 415.369.4856
Cell: 650.302.7889
--
Make sure you're using the latest version of the driver (2.0.14 right now)
from http://mmmysql.sourceforge.net/
Also, make sure you add "useUnicode=true" to your URL if you're not going to
be using straight ASCII.
-Mark
- Original Message -
From: "Daniel Flöijer" <[EMAIL PROTECTED]>
The "," is required before the PRIMARY KEY declaration.
It fails without it.
Removing the "," before the CHECK declaration simply generates a similar
error sooner:
ERROR 1064: You have an error in your SQL syntax near 'CHECK (max_sched
REGEXP "[0-9]")) TYPE=Innodb;'
v> From create syntax, you can
Actually if I just run the Location/Category query once and throw it into an
array, then take the variables that way.. That should cut off that part of
the MySQL query.. Very nice! You've given me a light.. This tunnel was
really beginning to get dark.. :)
Thanks! And of course anymore ideas wo
The problem with upgrading hardware is that it belongs to the host, not to
us :) So that's why I was hoping to be able to optimize the query as much
as possible and then if that still doesn¹t work, email my host and see if
they can upgrade their hardware...
Cheers!
Rick
"Continuing to cling to
Ok I've Analyzed each table and it looks like it has cut around 20 seconds
off of the average time.
Im trying to figure out how I can take out the left joins.. I need some of
that data to be displayed to the user.. Would it be quicker to get rid of
the location and category left join and then for
i understand , it's your desire to said us that you don't know to much
about Windows.We can help you but not in this list.
> I don't understand very well what you try to say ?
>
> sql,query
>
> - Original Message -
> From: "Dan Nelson" <[EMAIL PROTECTED]>
> To: "Gelu Gogancea" <[
Subject: Re: Speed issues...
From: "Jared Richardson" <[EMAIL PROTECTED]>
===
"Richard Baskett" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]...
> This is my first post here.. So be nice! ;)
>
> I have a database with a little over 60,000 records and when I do a search
> on that db
In the last episode (Jul 31), Richard Baskett said:
> When they are searching sometiems they do not search for Location..
> When that's the case I leave the location string out, if they do not
> search for Category, I leave the Category string out, but when they
> do.. That's the query I get.. The
Scott Pippin wrote:
> I need to run a file called sms.sql from the command line. Is this
> possible and what is the syntax?
> Thanks in advance.
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the m
On Tue, Jul 30, 2002 at 10:04:33AM +0100, Andrew Bryant wrote:
>
> How big have people pushed MySQL databases. Has anyone attempted
> terabyte size databases, especially large database that are not just
> read-only resources. Databases with some OLTP activity.
Well, I just got access to 0.8TB th
When they are searching sometiems they do not search for Location.. When
that's the case I leave the location string out, if they do not search for
Category, I leave the Category string out, but when they do.. That's the
query I get.. There has got to be a way of making this faster.. It seems
like
I need to run a file called sms.sql from the command line. Is this
possible and what is the syntax?
Thanks in advance.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
I get the following error when installing the MySql Binary in AIX:
exec(): 0509-036 Cannot load program mysql because of the following
errors:
0509-130 Symbol resolution failed for mysql because:
0509-136 Symbol stpcpy (number 125) is not exported from
depend
Hello,
I'm having really strange problems with characters when retrieved to Java from MySQL.
On some columns (or if it is in some tables) it works, in others it do not. I have
checked what charset Java thinks it should be, and that is cp1252 in both cases. I've
checked the list of MySQL suppor
On Wed, Jul 31, 2002 at 10:54:54AM +0200, mr wrote:
>
> Hello everybody
> I'd like to know what does that means: "Writing to net" in the state row of
> processlist.
> I have to launch a perl script which do traitement on a mysql table with
> 1.750.000 records.
It means just what it says--MySQL
On Tue, Jul 30, 2002 at 10:35:06PM -0700, Bhavin Vyas wrote:
> Is there a way to have DB-A and DB-B such that DB-A is the master and DB-B
> is the slave. However, I also want to make DB-B the master and DB-A it's
> slave so that if I have to fail over to DB-B then DB-A is automatically
> followin
On Tue, Jul 30, 2002 at 10:34:36AM +0200, Inbal Ovadia wrote:
> Hi All
> Is MySQL works with XML?
Yes.
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]> | http://jeremy.zawodny.com/
MySQL 3.23.51: up 62 days, processed 1,313,326,706 queries (242/sec. avg
On Tue, Jul 30, 2002 at 01:37:26PM +0200, Mozzi wrote:
> Hallo all
>
> I have a database that corrupted.
> I managed to save the
> radacct.frm
> radacct.MYD
> radacct.MYI
> radacct.TMD
> files and recreate the table.This is just a logging file so no real
> crisis if I lose some data.
>
> How do
Can anyone tell me if it is possible to connect to a MySQL server running on
Linux from a Windows Visual Basic application without setting up a DSN on
the Windows computer?
I know this can be done with MS SQL Server and I have heard it can be done
with Oracle so I am wondering if there is a conne
I don't understand very well what you try to say ?
sql,query
- Original Message -
From: "Dan Nelson" <[EMAIL PROTECTED]>
To: "Gelu Gogancea" <[EMAIL PROTECTED]>
Cc: "Dan Vande More" <[EMAIL PROTECTED]>; "Mark Herzog" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Wednesday, July 31,
In the last episode (Jul 31), Richard Baskett said:
> >> SELECT DISTINCT Location.SortID AS Loc, LocName, JobTitle AS Job, Company
> >> AS Comp, Jobs.JobID, Employers.EmpID
> >> FROM Employers
> >> LEFT JOIN Jobs USING (EmpID)
> >> LEFT JOIN JobsLocation USING (JobID)
> >> LEFT JOIN Location USING
From create syntax, you cannot put , after VARCHAR(1). You have another ,
after AUTO_INCREMENT, maybe it is not correct too.
At 01:56 PM 7/31/2002 -0400, Larry Irwin wrote:
>Using MySQL 4.02 on SuSE Linux 7.3
>The MySQL docs at http://www.mysql.com/doc/C/R/CREATE_TABLE.html state that
>CHECK (ex
Hi,
Anywhere under Windows work next sequences:
Ctrl+x-cut selected text
Ctrl+c-copy selected text
Ctrl+v-paste
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
On Tue, Jul 30, 2002 at 12:31:32PM -0400, Chris Friedline wrote:
> hello everyone,
>
> i'm a newbie so please excuse the probably dumb question.
>
> i'm using monitoring software to record the number of processes at a current
> time. currently, i'm just sending a show processlist and my monit
I decreased wait_timeout (from 28,800 to 300) to kill off sleeping threads.
This morning, the server stopped accepting connections and gave me this
error:
ERROR 1129: Host 'hostname' is blocked because of many connection errors.
Unblock with 'mysqladmin flush-hosts'
flush-hosts worked and I
Using MySQL 4.02 on SuSE Linux 7.3
The MySQL docs at http://www.mysql.com/doc/C/R/CREATE_TABLE.html state that
CHECK (expr) is not parsed for table types other that innodb. But when the
table type is innodb I assume it is parsed. I'd like to retain the CHECK
parameters in my CREATE scripts, but ca
Ok here is the EXPLAIN query:
table, type, possible_keys, key, key_len, ref, rows, Extra
Employers, ALL, NULL, NULL, NULL, NULL, 46175, where used; Using temporary;
Using filesort
Jobs, ref, EmpID, EmpID, 4, Employers.EmpID, 3, where used
JobsLocation, ref, PRIMARY, PRIMARY, 4, Jobs.JobID, 581,
If you use IGNORE in the insert IGNORE into new_table you will get the
result you want.
> -Original Message-
> From: walt [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, July 30, 2002 3:11 PM
> To: David Kramer; [EMAIL PROTECTED]
> Subject: Re: removing duplicate records
>
> Thanks David!
>
You can also use Microsoft Query or Microsoft Access to construct queries if you're
running Windows.
> -Original Message-
> From: Dan Vande More [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 31, 2002 11:35 AM
> To: Mark Herzog; [EMAIL PROTECTED]
> Subject: RE: Cut Copy Paste
>
> My
"Desmond Lee" <[EMAIL PROTECTED]> writes:
> Hi there
>
> I'm doing fine with the command line interface of mysql, no complaints
> from me. Howerver, another team member who knows nothign about mysql
> is more familiar with the windows stuff like access. Is there an
> graphical interface for mysq
Yes, just change the row in some way(or insert a row), and it will insert the date
automatically. (be sure to insert null in the timestamp field, or leave it out of your
update query)
I use the feature for many things.
Thanks
dan
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EM
Mysqlfront works well, though I don't believe you can cut.
-Original Message-
From: Mark Herzog [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 31, 2002 10:02 AM
To: [EMAIL PROTECTED]
Subject: Cut Copy Paste
Cut, Copy, and Paste functions are not available in the SQL Query tool in
my
Hi all,
>I gave not enough info about indexes. Use SHOW INDEX FROM table_name
sorry, now 2nd try with more info.
>> This bug was reported to fixed in 3.23.38.
>> But the mysql versions 3.23.49 and in 4.0.2
>> both look like as the bug is in them again.
>>
>> Example:
>> The following query
If you've got to make copies to disk then why not just maintain copies on
disk via replication? Stop the slave, backup the slave, restart the slave.
-Original Message-
From: Nicholas Stuart [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 31, 2002 8:55 AM
To: [EMAIL PROTECTED]; [EMAIL PRO
Cut, Copy, and Paste functions are not available in the SQL Query tool in
my MySQLManager tool. Any ideas? Thanks.
Mark Herzog
Contour Systems
Phone: (952) 935-0141
Cell:(612) 207-6530
Email: [EMAIL PROTECTED]
-
Befor
Hi all,
As I'm not very experienced with DB technology, I'm very sorry if my
question seems stupid.
I have set up a MySQL server as a central data repository where various
clients are to write and read data concurrently. One of the attrbutes
of the tables that are going to be managed by the M
I'm glad to announce that the new version 1.0.15 is now available. Before
downloading it be aware that some of the mirrors are not yet updated and it
may take some time. You may use the ZEON Host mirror which has a large
bandwidth and is automatically updated.
The list of changes and new features
Hi All,
I am hoping this question has already been answered somewhere and I just can't find
it. I recently had my machine upgraded from WindowsNT to Windows2000. Since this
upgrade my access to my MySQL database is degraded noticeably. There seems to be a
constant delay when I connect to the d
I am also using win2k advanced server - what does the back-up syntax look
like if I wanted to to it on Windows?
thanks
Mark
- Original Message -
From: "Nicholas Stuart" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, July 31, 2002 8:54 AM
Subject: RE:
are there indexes on the right fields? do a "describe" on the query and
let us know what you get.
On Wednesday, July 31, 2002, at 02:17 AM, Richard Baskett wrote:
> This is my first post here.. So be nice! ;)
>
> I have a database with a little over 60,000 records and when I do a
> search
> on
Aye, I forgot to mention to lock the db before backing up...my bad. But
again the idea is the same just schedule win2k to do it.
-Nick
Ed Carp said:
>> >> On windows you could simply copy the entire data directory with a
>> Scheduled job. Copying the files should be all you need to do for
>> win
Thanks.
On 31 Jul 2002, Martin Waite wrote:
> On Wed, 2002-07-31 at 12:03, Luis Rodrigues wrote:
> > hi,
> > I have some sql code that I need to use with mysql
> > it uses nested queries and since mysql doesn't implement them
> > I would like to know how to do this.
> >
> > SELECT * FROM apart
> >> On windows you could simply copy the entire data directory with a
> >> Scheduled job. Copying the files should be all you need to do for
> windows.
> >> For a cleaner, and what most people would say is a better way you could
> >> schedule a batch file to run mysqldump that would dump the data
i've read up and am able to add users with encrypted passwords.
t> what i want to do is restrict a user to a database.
t> in the mysql db there is the users table and the db table. i understand
t> that permissions in the users table override those of the db table.
t> so what i do is this:
t>
Guilherme,
Tuesday, July 30, 2002, 10:12:57 PM, you wrote:
G> Is there any option to substitute Triggers or Stored Procedures on MySQL?
Nope.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___
von,
Wednesday, July 31, 2002, 3:06:12 PM, you wrote:
vB> this bug was reported to fixed in 3.23.38.
vB> But the mysql vesions 3.23.49 and in 4.0.2
vB> both look like the bug is in them again.
vB> Example:
vB> The following query should use the index on
vB> dog.dog_timestamp_cr but uses fileso
Pushkar,
Wednesday, July 31, 2002, 7:00:19 AM, you wrote:
PP> I'm using 3.23.49, and trying to load the menagerie database (online
PP> examples) by executing the example:
PP> LOAD DATA LOCAL INFILE 'pet.txt' INTO TABLE pet;
PP> This is the error I get:
PP> ERROR 1148: The used command is not allo
stcuppet,
Wednesday, July 31, 2002, 3:04:45 PM, you wrote:
>>Description:
s> When joining tables using a SELECT statement and using the DISTINCTROW modifier, I
noticed a difference in the resultset by adding the ORDER BY directive on the end of
the SQL command on a column
s> that is not includ
Kevin,
Wednesday, July 31, 2002, 7:27:22 AM, you wrote:
K> I am hosted on a shared/virtual hosting plan and would like to backup the
K> one of the mysql tables on a daily basis. mysqldump is not available.
K> I attempted to run the query - SELECT * INTO OUTFILE
K> '/path/to/my/file/file.sql' FRO
>> On windows you could simply copy the entire data directory with a
>> Scheduled job. Copying the files should be all you need to do for
windows.
>> For a cleaner, and what most people would say is a better way you could
>> schedule a batch file to run mysqldump that would dump the data and
>>
Hello,
I have just imported from a textfile database to mysql.. In the
database table, I have the following values:
Id. date
00ca. 1900
011900
021900-tallet => meaning 1900 - 1999
031950-tallet => meaning 1950 - 1959
041500-1600
...
I want to use
> -Original Message-
> From: Nicholas Stuart [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 31, 2002 8:38 AM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: Backup automation..
>
> On windows you could simply copy the entire data directory with a
> Scheduled job. Copying the
Here's the doc page.
http://www.mysql.com/doc/S/o/Sorting_rows.html
Later,
Larry
>From: "DonPro" <[EMAIL PROTECTED]>
>Subject: Key in reverse order
> Hi, I have a MySQL table key on a 7 character VarChar field. Th efile
> contains
> numeric characters only which I've inserted right justified. Is
On Wednesday 31 July 2002 05:17 am, Richard Baskett wrote:
> This is my first post here.. So be nice! ;)
OK, no flames ;o).
I'd want a bit more information in order to really diagnose this. The first
thing I would tell you to do is to EXPLAIN this query. To do that just tack
the keyword EXPLAI
Did you also update the perl DBI modules to match?
Luca Bonci wrote:
>Hello everybody.
>
>I was running a web server with mysql-server 3.22.32-log
>on a debian box and using perldbi as an interface
>from html pages and mysql-server.
>
>I upgraded the dedian package to 3.23.49-log and I am not
On windows you could simply copy the entire data directory with a
Scheduled job. Copying the files should be all you need to do for windows.
For a cleaner, and what most people would say is a better way you could
schedule a batch file to run mysqldump that would dump the data and
structure to a fi
* Richard Baskett
> This is my first post here.. So be nice! ;)
:)
> I have a database with a little over 60,000 records and when I do a search
> on that db it takes a little over a minute and a half to return results.
That sounds slow, yes.
> This is very unacceptable, but Im just not sure wh
Hi,
I am looking for a way to automate the way i take backups.
I run mysql on w2k server and I seek for a way to take backups of the
database at certain times automaticaly.
Is out there any suggestion?
thanks..
-
Before postin
> -Original Message-
> From: Simon Hester
> Sent: Tuesday, July 30, 2002 4:31 PM
> To: '[EMAIL PROTECTED]'
> Subject: Install MySQL from the command line
>
>
> Hello
>
> OS= Windows 2000 Professional
> Mysql Version = Mysql servers and clients 3.2.51
>
> I woul
Hello everybody.
I was running a web server with mysql-server 3.22.32-log
on a debian box and using perldbi as an interface
from html pages and mysql-server.
I upgraded the dedian package to 3.23.49-log and I am not able anymore to
connect
I use the following PERL sintax:
# database infor
* saraswathy saras
> i have a problem with query.I have no idea about it,whether it
> can be done
> or not.i want to query out name order by alphabet,The range is
> provided like
> Aa - Ad.
> so the result should be like this:-
>
> Browse Aa to Ac
>
> Name
>
> A
...hm... 'A' is not in the ra
Hi folks,
I am the maintainer of NSS MySQL which is, as you may have guessed, a
nss module using MySQL as backend. It shares a mysql connection between
threads. As explained in the documentation, I use my_thread_init and
my_thread_end functions to properly manage that situation.
As you may know,
* Bhavin Vyas
> Is there a way to have DB-A and DB-B such that DB-A is the master and DB-B
> is the slave. However, I also want to make DB-B the master and DB-A it's
> slave so that if I have to fail over to DB-B then DB-A is automatically
> following the changes. It doesn't seem probable that thi
Hi,
this bug was reported to fixed in 3.23.38.
But the mysql vesions 3.23.49 and in 4.0.2
both look like the bug is in them again.
Example:
The following query should use the index on
dog.dog_timestamp_cr but uses filesort instead.
mysql> EXPLAIN SELECT dog.dog_id, dog.dog_name, sire.dog_na
>Description:
When joining tables using a SELECT statement and using the DISTINCTROW modifier, I
noticed a difference in the resultset by adding the ORDER BY directive on the end of
the SQL command on a column that is not included in the result. If no join is
performed and the DISTINCTROW/ORD
On Wed, 2002-07-31 at 12:03, Luis Rodrigues wrote:
> hi,
> I have some sql code that I need to use with mysql
> it uses nested queries and since mysql doesn't implement them
> I would like to know how to do this.
>
> SELECT * FROM apartamentos
> WHERE vendido=0
> AND Concelho=$row["ConcelhoP"]
No can do. Replication is one-way.
You can, however, have multiple Slaves.
- Original Message -
From: "Bhavin Vyas" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 31, 2002 12:35 AM
Subject: Replication Circle
Hello,
Is there a way to have DB-A and DB-B such that DB-A
MySQL does not support sub-queries. Take a look at JOINS
(http://www.mysql.com/doc/J/O/JOIN.html)
- Original Message -
From: "Luis Rodrigues" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 31, 2002 6:03 AM
Subject: Problem with subqueries
hi,
I have some sql code that
hi,
I have some sql code that I need to use with mysql
it uses nested queries and since mysql doesn't implement them
I would like to know how to do this.
SELECT * FROM apartamentos
WHERE vendido=0
AND Concelho=$row["ConcelhoP"]
AND Localidade LIKE '&$row["LocalidadeP"]&' ...
WHERE Referencia
>Description:
If an update is made to a master using the syntax
'INSERT INTO database.table' etc... on a mysql connection
where no 'USE database' command has been given then the updates
are written to the master binary log correctly, and update
the slave co
Please !
I thought I had this working, but it seems unfortunately not !!!
I'm trying to list events for each month and my select query is as follows
SELECT DISTINCT t_city_name,t_city_id_city FROM
t_city,t_zipcodecity,t_location,t_event WHERE (t_city_id_city =
t_zipcodecity_id_city) AND (t_zipc
not an sql query
> > Heh, Get a bigger mail box I guess ;-) Or unsubscribe your self while
> > you're out.
>
> true, but more hassle
Has anyone ever suggested a put-on-vacation command for this (or any?)
list server?
I'm thinking a put-on-vacation and put-off-vacation commands would not
need
hai everybody,
i have a problem with query.I have no idea about it,whether it can be done
or not.i want to query out name order by alphabet,The range is provided like
Aa - Ad.
so the result should be like this:-
Browse Aa to Ac
Name
A
Aa
aa
Aabenraa
Aachen
Aakjaer, Jeppe
Abadan
Abaddon
A
Hello to everybody,
I installed mysql ver 11.17 distrib 3.23.49a on redhat
7.2.
I would like to import data into database table using
command line instructions.
I tried mysqlimport but I got the following error
messagge
mysqlimport: Error: The used command is not allowed
with this MySQL version,
well this seems to be a very controlled list, this reply had been blocked,
suggestion is to put some keywords in it like sql,query. ok then here it is,
sql query
although i have received some posts to stop this thread i will reply one
more time.
following is what i had intended to write, but did
This is my first post here.. So be nice! ;)
I have a database with a little over 60,000 records and when I do a search
on that db it takes a little over a minute and a half to return results.
This is very unacceptable, but Im just not sure what I can do to remedy
this. Here is what the query loo
Hello everybody
I'd like to know what does that means: "Writing to net" in the state row of
processlist.
I have to launch a perl script which do traitement on a mysql table with
1.750.000 records.
The request blocks during a long time everytime on the select of the hole
table and i can see in
I posted a query on this a couple of days ago, but have tried an alternative
tack.
Using MyCC to add a field to a table, I get an error
[localhost] ERROR 7: Error on rename of '.\rocktest\companies.MYI' to
'.\rocktest\#sql2-15c-15.MYI' (Errcode: 13)
But If I use mysql from the command line
mys
i've read up and am able to add users with encrypted passwords.
what i want to do is restrict a user to a database.
in the mysql db there is the users table and the db table. i understand
that permissions in the users table override those of the db table.
so what i do is this:
1) create a user
The the configure file and make file are so complicated. Could you tell me a
straightforward method to compile MySQL dynamicly. :-)
I want to run the MySQL upon NGPT.
Thanks!
yours sincerely
Yu Ronghua (Jerry)
Intel China Software Lab
Tel: 021- 52574545 ext. 1328
INet: 8-752-1328
--
Hi!
I think that the problem that MySQL complains about an uncommitted open
transaction in RENAME TABLE has been reported before. I will take a look at
this. The fix will probably be in 3.23.52.
The behavior that you cannot roll back a RENAME TABLE is as expected. To
perform a data dictionary op
1 - 100 of 101 matches
Mail list logo
