>Could you please advise me on how to export data in
> LINUX/MySQL table
> for web publishing?
If you need the data in a mysql table displayed in an HTML table, a quick
and dirty way to get a static file is to run this from the command line...
#mysql -uroot -p -H -e"SELECT * FROM Employee"
> After I set starttime to now(), anytime I run another update query against
> the row starttime changes to a new value.
If starttime is the timestamp data type, and the first timestamp in the row,
it will automatically update every time you update the row. This is not a
bug, it is expected behav
> One should always use the
> LAST_INSERT_ID() or after an insert, select max(id) from myTable.
Select max(id) from myTable should never be used to get the last insert id.
On a high traffic table you are not guaranteed it will be the ID for the
record you just inserted, another could have been in
> I am changing a database and changing the user and password of an
> existing
> database. when I enter the line.
>
> mysql> insert into user (host, user, password) values ('localhost',
> 'newuser', password ('newpswrd'));
>
> the error 1062: Duplicate entry 'localhost-newuser' for key 1
> mysql>
>what would be causing the error:
>
> SELECT certificate.cert_num, master_info.uid
> FROM certificate
> JOIN master_info ON ( certificate.uid = master_info.uid )
> LEFT JOIN endorsements ON ( certificate.cert_num =
> endorsements.cert_num )
> WHERE certificate.active = 1
> AND certificate.referred
> > Worked like a charm! I couldn't find anything about this in
> > MySQL docs
> You have to search for 'string functions' to find it. Problem is that a
> search for REPLACE will bring up the REPLACE syntax, not the REPLACE()
Or you can look at the function index
http://www.mysql.com/doc/en/Funct
> I am running php 4.2.2 and mysql 3.23.54.
This is a PHP question, not mySQL.
> This is my query:
>
> $sql = "SELECT MAX(esn) FROM address"; // line 37
> $max_esn_result = mysql_query($sql) or print mysql_error(); // line
> 38
> $max_esn = mysql_result($max_esn_result,$i,"esn
> Ok, I know it WAS there because we have two similar tables that should
> contain sister records. One table has a record the other doesn't so it
> had to have been deleted. I need to find out WHEN it was deleted.
>
> How do I create a log of record deletes?
>
If you keep the update log or the
I have a stand alone database server. It is a RAID5 running mySQL 3.23.55
on FreeBSD 4.1 and has 768MB of RAM, I'm not sure on the processor speed,
but I think it's a P3 1GHz. It has several tables with 20-40 million rows
and a ton of smaller tables with less than 1 million rows. All tables are
> Setting skip-name-resolve will avoid this code path and the bug. It
> looks like some DNS funkyness...
>
I've implented this and so far I can't get the box to hang in authentication
no matter how mean I am to it. I feel so dumb, for not thinking of this
before, I swore I had already done it ab
> > One of my coworkers insists that this is due to corrupt indexes, stating
> > that if an index points to a location outside of the record set
> mysql gets
> > confused and hangs.
>
> Does he have any evidence whatsoever for that? I'm 99% sure he's
> wrong--at least in *our* cases. :-)
A crash
> > A crash was recreated by running a specific query.
>
> Oh.
>
> You didn't mention crashes in your first note. That changes
> everything.
Sorry, I'm a dork. Buy crash I mean "all new connections getting stuck in
authentication mode." As the day wears on my Jennifer Vernacular -> English
tran
> I have 2 tables used for an online calendar...
>
> first table fields: primary_key , start_date, event_name,
> event_description
> second table fields: primary_key, end_date
>
> Tables fields are shortened and can't be changed.
>
> My second table only contains events that have a end date. I want
-- Original message from Richard Whitney <[EMAIL PROTECTED]>:
--
> Hello!
>
> I have situation where I need to find the next autoindex of a table - not just
> max(field) because the next autoindex may not jive with the number created by
> max(field)
http://dev.mysql.
-- Original message --
From: Tom Crimmins <[EMAIL PROTECTED]>
>
> $ mysqldump -u root -p govern > test.sql
> Enter password:
> mysqldump: Got error: 1017: Can't find file: './govern/VT_SY_LANGUAGE.frm'
> (errno: 24) when using LOCK TABLES
>
perror says 24 is too m
-- Original message --
From: none none <[EMAIL PROTECTED]>
> Perhaps you did'nt grant access to for your home workstation IP
> address to have permission to log into the mysql server? Check out the
> grant command:
>
> http://dev.mysql.com/doc/mysql/en/GRANT.html
I
-- Original message --
From: -{ Rene Brehmer }- <[EMAIL PROTECTED]>
> Task at hand: deleting or selecting (same difference) several numbers of
> records using only 1 query.
>
> My first version simply looped through all the ticked off IDs and ran a
> single query
Not being an MSSQL expert, I don't know what MM does, and since you did not specify
what type of conversions you wish to perform, I can't say exactly which function would
suit your needs, but here is a link to the manual page that lists all date and time
functions --
http://dev.mysql.com/doc/my
> When I run a query that has a timestamp field, How can I query on just the
> date. Time stamp puts in the min, hour, and sec. All I need is the year,
> month, and day.
>
> SELECT * FROM table_name WHERE date = '2003-08-25';
select * FROM table_name WHERE DATE_FORMAT(date,'%Y-%m-%d') = '2003-08
> I then try to connect to the server from a remote location and get
> ERROR 1130: Host 'xxx.yyy.zzz' is not t allowed to connect to
> this MySQL server
> which is normal since i did not create a user yet
>
> I do this:
> GRANT ALL PRIVILEGES ON *.* TO stew@'%' IDENTIFIED BY '123' WITH
> GRANT OPTI
> Is there some way to do something like:
>
> SELECT * FROM tables WHERE name = "table_name";
>
> And get a result I could test for truth, and thus run my script?
Show tables like 'table_name';
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:htt
> 2 index on this table:
> - one unique index on user_id and att_id (pk)
> - one index on att_id and user_id.
>
> I need to have the following query:
>
> select value from user_att where att_id = ? and value like '?'
> (no wildcard)
> 1. when I do a explain, this query use the second index. But,
I have recently re-entered the job market and I was wondering if anyone has
found that having certification really helps in landing a position. If so,
which cert do you have?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/
http://www.mysql.com/doc/en/INSERT_SELECT.html
You cannot select from the table you are inserting into. Insert into a temp
table and then insert into holds from that table.
-Original Message-
From: Eric [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 21, 2002 1:14 PM
To: [EMAIL PROTE
http://www.mysql.com/doc/en/SHOW_PROCESSLIST.html
Repair with keycache - The repair code is using creating keys one by one
through the key cache. This is much slower than Repair by sorting.
It is going to take a long time to build an index on a table that big,
especially if you still have questio
Read the documentation.
http://www.mysql.com/doc/en/SELECT.html
The link has been sent out on this list about 6 times this morning, all in
posts regarding the limit clause.
The LIMIT clause can be used to constrain the number of rows returned by the
SELECT statement. LIMIT takes one or two numeri
If you don't care about the data being out of sync with the master and are
not concerned with any problems it might cause, such as the slave thread
stopping due to replication errors caused by out of sync auto_increment
fields and the like.
-Original Message-
From: Heikki Tuuri [mailto:[EM
$item is probably undefined, unless you are assigning it a value somewhere
else in your script. mysql_fetch_array is putting the result set in an
associative array called $line, so $line['item'] would hold the result from
your query.
-Original Message-
From: Beauford.2003 [mailto:[EMAIL
mysql> show variables;
3306 is the default.
-Original Message-
From: Mike At Spy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 9:05 AM
To: [EMAIL PROTECTED]
Subject: mysql port number
How can I tell what port number mysql is running on? I need it for a chat
program
http://www.mysql.com/doc/en/perror.html
>perror [errornum]
i.e.
> perror 13
Error code 13: Permission denied
-Original Message-
From: Jason Hall [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 05, 2002 11:59 AM
To: '[EMAIL PROTECTED]'
Subject: Error Message Documents - where to fin
I have been experiencing a problem where mysql appears to hang when
authenticating connections. I am running mysql 3.23.52-log on a dedicated
PIII server with 768MB of RAM and FreeBSD 4.1. Nothing else runs on this
server and 99.9% of the connections come in remotely. What appears to be
happenin
http://www.mysql.com/doc/en/JOIN.html
mysql> SELECT table1.* FROM table1
->LEFT JOIN table2 ON table1.id=table2.id
->WHERE table2.id IS NULL;
So...
Select n.uid, n.name from names_table n
LEFT JOIN exclude ON n.uid = exclude.n_uid
WHERE exclude.n_uid IS NULL;
-Origi
UPDATE $table SET Column3 = CONCAT(Column1," ",Column2);
http://www.mysql.com/doc/en/String_functions.html#IDX1162
-Original Message-
From: Andrew Kuebler [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 12:45 PM
To: [EMAIL PROTECTED]
Subject: UPDATE 1 Column from merging 2
select name, SUM(count) from stats group by name;
-Original Message-
From: news [mailto:[EMAIL PROTECTED]]On Behalf Of Max Clark
Sent: Wednesday, December 11, 2002 4:05 PM
To: [EMAIL PROTECTED]
Subject: Newbie - group and tally help
Hi-
I am trying to write a sql query that will select,
ORDER BY col [ASC|DESC]
http://www.mysql.com/doc/en/SELECT.html
-Original Message-
From: Mike(mickako)Blezien [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 12, 2002 11:45 AM
To: MySQL List
Subject: Sorting Results
Hello all,
Is there away, within the sql query, to sort the query r
It sounds like you need to edit your hosts.allow file to allow from the IP
you want to connect from.
add either
mysqld : ###.###.###.### : allow
or
mysqld : all : allow
I'm not a sysadmin though, so you might want to do a search on the proper
way to do this.
-Original Message-
From: Kr
Have you tried optimizing your query? It is more likely that the problem is
a poorly optimized query and/or poorly tuned server than it is mySQL. Joins
will be slow if you do not take the time to figure out the best way to do
what you are trying to accomplish. Forcing the table order can really
Problem is not in the connecting it is in the mysql_select_db as you are
denied access to the database, not the server. Your permissions might be
off or the php might not be right. It would be helpful if you posted more
of your code.
-Original Message-
From: Gary Hostetler [mailto:[EMAIL
With the same user? It sounds like you might want to read the documentation
on GRANT and permissions. It is always a good idea to try the documentation
before asking questions on the list.
http://www.mysql.com/doc/en/User_Account_Management.html
-Original Message-
From: Gary Hostetler
http://www.mysql.com/doc/en/CREATE_INDEX.html
you key needs a length, not your field.
index (hashsum(length)) # for quick lookups
-Original Message-
From: David T-G [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 30, 2002 1:53 PM
To: mysql users
Subject: indexing a blob
-
Are you using indexes on your tables? This does not sound like a mysql bug,
but rather a problem with your table structure or query. I have seen much
more complicated joins work on much larger tables without any problem, as I
am sure many people on this list have as well. You should run an expla
It would be helpful if you posted that error. You can get it by changing
the die to
$queryr = mysql_query($query) or die(mysql_error());
Without knowing the error, you problem will be harder for everyone to debug.
-Original Message-
From: Nuno Lopes [mailto:[EMAIL PROTECTED]]
Sent: Mon
I bet the answer Paul DuBois was nice enough to post yesterday evening when
you asked this same exact question still applies.
You might want to search on your previous thread.
http://marc.theaimsgroup.com/?l=mysql&m=104198809410342&w=2
-Original Message-
From: Beogradjanin [mailto:[EMAIL
>Imagine an ISP giving every customer write privileges for the mysql/bin
directory ... ;-/
Why would they have to do that? The file does not need to be in that
directory. In order to use LOAD DATA INFILE without LOCAL the file just
needs to be somewhere on the server that mysqld is running on and
HTML doesn't just see a URL and automatically make it a hyperlink it is not
"helpful" like MS products. So what you are seeing is expected behavior. I
would alter the while loop to look like this...
while ($row = mysql_fetch_array($resultID)){ #fetch_array adds little
overhead and gives you an
>ERROR 7: Error on rename of '.\helpdesk\call_information.MYI' to
>'.\helpdesk\#sql2-b90-81.MYI' (Errcode: 13)
>Any ideas on why I would get this??
Errorcode 13 is permission denied or file not found. Either
.\helpdesk\#sql2-b90-81.MYI exists and your mysqld user does not have
permission to over
>Did you already announce this several days ago?
Once last Monday and once in November, but isn't this the
messageboard-announce-spam list? :)
I'd hate to think a list called mysql is for questions about SQL and mysql
and not useless announcements about personal sites.
--
Blend will be a cross reference with a one to many relationship
This is very simplified but an example of your data could be:
Select * from Wine;
++--+
| WineID | WineName |
++--+
| 1 | XYZ |
++--+
Select * from Grape;
+-+
>can anyone point me to a reference regarding the Com_ status information
What exaclty do you mean? http://www.mysql.com/doc/en/SHOW_STATUS.html
states that the com_ is just how many times the command has been
issued. So if com_select = 34021 there have been 34021 selects issued to
the
I am not a guru, but I figured I'd try to answer anyway. It needs an extra
bit because it has NULLs. I think it uses the bit to mark if the field is
NULL or not, but I've been known to be wrong.
http://www.mysql.com/doc/en/Data_size.html
-
Dear gurus,
here's my final stupid question
Sounds a lot like the grape blends in different wines question posted last
week. :)
You'll need a cross ref table with a one to many relationship and possibly a
field that says what the person did.
like
| SongID | ComposerID | Role |
++-++
|1 | 1 | P
MySQLCC probably uses the backtick (`) to escape stuff so it issued
UNIQUE KEY `IDX_Postcode-Location` (Postcode,Location)
and not
UNIQUE KEY IDX_Postcode-Location (Postcode,Location)
It has been mentioned on the list a few times in the last couple months that
if you escape strings containing hyph
>My feeling is that MySQL shouldn't allow reserved words / characters
>like this, whether they are in quotes or not.
...
>Does anyone know the logic behind allowing reserved words when inside
>quotes like this? It clearly causes problems - especially for people
>using GUIs - and these people will b
Does the box have PHP installed and configured to use MySQL?
I wouldn't go with the php3 extension, as it is outdated, PHP4 has been
stable for a while.
-Original Message-
From: Will Standley [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 16, 2003 3:14 PM
To: [EMAIL PROTECTED]
Subjec
Are you creating new tables or importing from an old application? If you
are building something from scratch it is a really really bad idea to use
spaces in the names or start putting in special characters, you're just
making more work for yourself, and anyone that works on the application
after y
Your joins are probably not using indexes and the tables could be joining in
an inefficient order. Try running an explain on your query to see how it is
being done.
-Original Message-
From: Steve Quezadas [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 21, 2003 1:31 AM
To: [EMAIL PROT
Try a straight join with the cases table first. You have to play with your
queries to get the best results.
Creating a temporary, as you mentioned, table might be a very good option in
this case, but you need to make sure that your programming takes into
account that your page might be hit more t
>They run in 8 minutes on my test server , about 4 minutes each. Printing to
>a PDF driver.
>On the Production Server they take HOURS to run and print.
The production server is probably trying to do other stuff at the same time,
making your reports slower. A machine with one active connection wi
on
while you are running your reports?
Is the production server tuned for the type of complex queries you are
running?
-Original Message-
From: Mary Stickney [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 30, 2003 12:02 PM
To: Jennifer Goodie; [EMAIL PROTECTED]
Subject: RE: timing
The problem is probably in either your PHP or HTML, not MySQL. It is common
to store mutliple words separated by a whitespace in varchar and text
fields.
-Original Message-
From: Anna Noel Leavitt [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 30, 2003 8:40 AM
To: [EMAIL PROTECTED]
Su
PHP is server side, javascript is client side, they do not interact with
each other. PHP gets parsed by on the server before the page is rendered,
javascript is interpreted by the browser. You can either have PHP generate
the javascript or just put it in the page. Rollovers have nothing to do
wi
Read the section in the manual about timestamps, this is expected behavior,
it is how it is supposed to work.
http://www.mysql.com/doc/en/DATETIME.html
The TIMESTAMP column type provides a type that you can use to automatically
mark INSERT or UPDATE operations with the current date and time. If yo
A Left join using IS NULL will work. You can get the syntax and see an
example in the manual
http://www.mysql.com/doc/en/JOIN.html
>From the maunal...
If there is no matching record for the right table in the ON or USING part
in a LEFT JOIN, a row with all columns set to NULL is used for the righ
Are you referring to the data type SET or the Command SET? The manual page
you point to is talking about the data type, but usually when seen in an
insert it is the Command. I can't recall seeing the datatype referred to in
an INSERT, but maybe my brain isn't fully on yet today.
http://www.mysql.
This is probably a dumb question, but are you running all the queries in
eod_stocks? I ran all the queries and they worked fine. I undotted the
select though because my database was not called eod_stocks. Since you did
not include the part where you select the database to run these queries in,
o
You could have PHP escape it for you. Look into the addslashes function.
It adds slashes to escape characters.
http://www.php.net/manual/en/function.addcslashes.php
If your server has magic quotes turned on it will automatically escape
characters, but it is not a good idea to rely on that.
If yo
>Yes. You can use INSERT INTO select from ..
>> If this matters, I will be doing this in 2 different applications. 1
>> database is MySQL, and the other is MS Access.
Not if the two tables are on different database servers. But maybe I'm
reading that wrong and the application is just being de
SHOW TABLES;
Then treat the output as a normal result set.
see the manual for more about SHOW syntax
http://www.mysql.com/doc/en/SHOW.html
-Original Message-
From: Jeff Pearson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 20, 2003 2:31 PM
To: [EMAIL PROTECTED]
Subject: List of Tabl
It does not sound like your data is properly normalized. You might want to
take a look at the way you have things set up, this sounds like it cause
problems later on.
-Original Message-
From: Danny [mailto:[EMAIL PROTECTED]
Sent: Monday, February 24, 2003 1:54 PM
To: [EMAIL PROTECTED]
Sub
What language are you using? As far as I know Apache doesn't connect to
databases, you have to use a programming language to do that. I'm guessing
you are using PHP and you have possibly upgraded it without compiling in
mysql support.
-Original Message-
From: Henning Olsen [mailto:[EMAIL
Database name goes after options. It is showing you the help page because
it does not understand what you are passing to it. It's kind of saying
"Here, look at this, this is how I work, follow these directions they might
help you out."
-Original Message-
From: Anil Garg [mailto:[EMAIL PR
What does it say when you run SHOW MASTER STATUS on the master? Are you
sure the slave is the problem and not the master?
-Original Message-
From: trashMan [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 13, 2003 7:29 AM
To: [EMAIL PROTECTED]
Subject: Replication error
Please.seven
It says in the change log that it added the port to make it easier to see
where the connection is coming from. 146.101.143.72:48753 gives you a lot
more information than "host1"
>From the release announcement --
* `SHOW PROCESSLIST' will now include the client TCP port after the
hostname to m
It is not strange, it is expected behavior. A browser can only handle so
many lines of html before getting all wonky. Running a query that takes
over 5 minutes to run in a web application is a bad idea, no one is going to
want to sit there and wait for it and if there is no output for an extended
I wouldn't run 3.23.51, there have been major security patches since then.
I always mess up the byte math, but it looks to me like you have 2 gigs of
ram in your box and you are allocating 2.3 gigs to mysql. With 263
connections you would have been using about 1.4 gigs, if you have anything
else r
On a linux box you do not have to stop everything like on Windows. We
always leave our current version running, install the upgrade in a new
location with a new data dir (a snapshot of the live one). We run the new
install on a different port than the live install so we can test it and what
not b
Probably a permission problem. If it cannot read the file it cannot import
it.
monster> perror 13
Error code 13: Permission denied
-Original Message-
From: James E Hicks III [mailto:[EMAIL PROTECTED]
Sent: Monday, March 24, 2003 11:48 AM
To: Mysql
Subject: mysqlimport: Error: Can't get
You don't.
http://www.mysql.com/doc/en/Fulltext_Search.html
There was a discussion on this mailing list last week or the week before on
when innoDB support would be implemented. I'm too lazy to look it up, you
should search the list archives for it.
-Original Message-
From: Sidar Lopez C
ALTER TABLE table_name DROP col_name
http://www.mysql.com/doc/en/ALTER_TABLE.html
So...
mysql> use hitcounter;
mysql> ALTER TABLE info DROP count;
Assuming info is the table name and count is the column you'd like to drop.
-Original Message-
From: Wileynet [mailto:[EMAIL PROTECTED]
Sent
You said that you changed the password to the password you wanted, but in
all the examples you are trying to access the server without a password.
Try using the -p flag so it prompts you for your password, then type in
whatever you set the password to be.
-Original Message-
From: katherin
I don't use Dreamweaver so I have no clue what the interface is like. But
basically the php function mysql_connect or mysql_pconnect will be somewhere
in the page. It takes the username, host, password ect. as arguments. You
script might be set up with variables that hold these defined at the to
That would grant the user select on everything in every database no matter
what host they are coming from. He wants to only grant on specific tables,
and did not mention anything about allowing from all hosts.
To answer the original question, I have tried a lot of different ways, but
the only sol
>I've tried it both as fixed (char) and variable (varchar). Interestingly
>when I set is as char when building the table, MySQL changes it to varchar
>sometimes (but not always).
It will change a char to varchar if there is another column of variable size
in the table.
--
MySQL General Mailing
It the master actually writting to the binlog? What does the master say
when you run SHOW MASTER STATUS? Is the size of the binlog growing?
-Original Message-
From: trashMan [mailto:[EMAIL PROTECTED]
Sent: Monday, March 31, 2003 1:29 PM
To: [EMAIL PROTECTED]
Subject: Replication don't wo
31, 2003 2:04 PM
To: 'Jennifer Goodie'; [EMAIL PROTECTED]
Subject: R: Replication don't work.
The error.log on the master dont' report anything...
MySql: ready for connections
Other info
>Show master status;
***
Headeransw
Just my two cents
> -Original Message-
> From: Seth Brundle [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 31, 2003 3:29 PM
> To: David Brodbeck; [EMAIL PROTECTED]
> Subject: Re: Could we make this a web discussion forum?
>
>
> > > I really hate on-line forums. They're difficult to track
-
From: trashMan [mailto:[EMAIL PROTECTED]
Sent: Monday, March 31, 2003 2:20 PM
To: 'Jennifer Goodie'; [EMAIL PROTECTED]
Subject: R: Replication don't work.
The binlog and the pos are the same in master and slave !
Webserver-bin.008 pos 73
Ehmm...i don't know how to sav
Why the join? Why not just "select p1.email, count(*) as occurances from
table p1 group by p1.email having occurances > 1"? Am I missing something?
> -Original Message-
> From: Andy Eastham [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, April 01, 2003 12:29 PM
> To: [EMAIL PROTECTED] Mysql.
You can rename a table by using the alter syntax
http://www.mysql.com/doc/en/ALTER_TABLE.html
ALTER TABLE tbl_name RENAME [TO] new_tbl_name
> -Original Message-
> From: Mark Wilson [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 31, 2003 4:41 PM
> To: Mysql Mailing List
> Subject: Rename/C
Because you are using a float. There has been much discussion of this on
the list, search the archives. Floats aren't so good if you need your math
to be right.
http://www.mysql.com/doc/en/Column_types.html
> -Original Message-
> From: LeTortorec, Jean-Louis [mailto:[EMAIL PROTECTED]
>
They are only sending one. It is proper form when replying to reply to both
the sender and the list. Since you are on the list you are getting the list
copy as well as the copy sent directly to you.
I think their problem was the fact that you admitted you were just asking
(vauge) questions becau
Do I need to post any further information to make this question easier to
answer? I have snippets from SHOW STATUS and SHOW VARIABLES if needed.
> -Original Message-
> From: Jennifer Goodie [mailto:goodie@;apollointeractive.com]
> Sent: Friday, October 18, 2002 5:19 PM
>
I'm having trouble with a an obscene amount of aborted_connects on my
MySQL database servers. I have 3 dedicated database servers, one of them is
a master database with 2 slaves, and the other 2 are stand-alone
database servers. All connections are being made by PHP pages on Apache web
servers.
>From looking at http://www.mysql.com/doc/en/News.html
it looks like
3.23.32 22 Jan 2001
3.23.36 27 Mar 2001
3.23.49 ?
3.23.52 14 Aug 2002
3.23.53a ?
Or maybe that is when the change log was released? I'd look around the site
if I were you.
> -Original Message-
> From: Luc Foisy [mailto:
The column's name is 'name ' not 'name' run an alter to get rid of the space
at the end.
> -Original Message-
> From: Insanely Great [mailto:insanely420@;PunkAss.com]
> Sent: Thursday, October 24, 2002 8:59 AM
> To: MySQL List
> Subject: Insert Error
>
>
> Greetings...
>
> I have a table i
We had a similar problem, we could connect through a socket (localhost), but
not TCP/IP.
Check your hosts.allow and hosts files. It is most likely that either
hosts.allow isn't set up to allow connections or the server connecting isn't
in the hosts file. This only applies when the 2013 happens du
'command not found' means that the server cannot find the application.
Either alias it or add
/usr/local/MySQL/mysql-3.23.52-pc-linux-gnu-i686/bin/ to your path or try
cding to /usr/local/MySQL/mysql-3.23.52-pc-linux-gnu-i686/bin/ and then
running it or just type the entire path at your prompt.
th
select * from theTable where theColumn like 'test%';
or
select * from theTable where LEFT(theColumn,4) = 'test';
depending on the table structure and data and indexing, etc. I have seen a
performance difference between the two, test and see which works best for
your application.
Hi there,
how c
mysql_fetch_row does not return an associative array, only enumerated.
http://www.php.net/manual/en/function.mysql-fetch-row.php
Try mysql_fetch_array instead.
-Original Message-
From: Tom Rogers [mailto:trogers@;kwikin.com]
Sent: Friday, November 01, 2002 7:53 PM
To: Steve Jackson
Cc: MyS
If it was a problem with mysql permissions you would get an access denied
for user@host using password(YES/NO) error. Since the error is cannot
connect through socket, either the socket is not in the specified directory
or you do not have permission to it or mysqld is not running.
-Original M
1 - 100 of 102 matches
Mail list logo
