We do not allow SSH access to our virtual hosts but we have dedicated
servers starting at $49 per month.
JR
--
RHCE #808003122507415 MySQL #206067847
Ask Me About Top Notch Web Hosting & Programming!
--
"Computers are like air conditioners:
They stop working properly if you ope
I am getting the following error when trying to dump my DBs.
/usr/bin/mysqldump: Got error: 1103: Incorrect table name
'/home/jr/backups/20040420/wcp.sql' when doing LOCK TABLES
Version is: 4.0.18-standard
These DBs where on another box running the same version. MySQL was
shutdown o
as add, edit, search, etc., you may want to take a look at
phpMyEdit at:
http://phpmyedit.sourceforge.net/
JR
-
SallyJo, Inc., is your source for Web Hosting & Programming Services.
Visit: http://SallyJoInc.com
> -Original Message-
> From: Edwin Davidson [mailto:[EMAIL
Show Tables;
-
VirtualChicagoLand.com Is Your Chicagoland Resource!
Visit: http://VirtualChicagoLand.com
On Wed, 16 Jan 2002, Bret Ewin wrote:
> I need to know how to get a list of all the tables in a database. In Oracle
> you could "select OWNER, TABLE_NAME from ALL_TABLES" to get a list
(-MM-DD HH:MM) and then they crash ! :(
What can I do / configure to get the same response on server and the clients
?
Thanks
Rubens Jr.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.496 / Virus Database: 295 - Release Dat
You have to run the 'mysqld_safe &' command before you run 'mysql'. That
creates the socket for you.
J.R.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
This is for those who love a challenge.
I am trying to come up with a query that would calculate the Standard
Deviation and Variance for 15 fields. Although in theory this is easily done
in Access, MySQL does not have the same mathematical calculations that
Access/SQL does.
Here is the query as i
> [...]
> > Why does MySQL needs to scan the Entire Table (all 200 MB) when I only
have
> > selected ID & ProductionYear in the SELECT statement ??
>
> Because you have a table with variable-width records and there is no
> way to easily find out where a field of a record is stored without
> reading
I have this SQL statement:
CREATE TABLE rooms (
idSERIAL,
room_name TEXT UNIQUE,
location TEXT,
last_updated TIMESTAMP DEFAULT
CURRENT_TIMESTAMP NOT NULL,
I have been trying to create a table but mysql 5.0.15-nt-max is having a
problem parsing the statement. Anyone know what the problem is in the
syntax of the following table creation statement:
CREATE TABLE registration_and_attendance (
idSERIAL NOT NU
-resetting of
the timestamp on updates. Is
that what you want? To get auto-setting on INSERTs and UPDATEs, just
write
last_updated TIMESTAMP,
Also the manual doesn't mention TIME WITHOUT TIME ZONE. Are you
thinking of PostgreSQL?
PB
-
Ferindo Middleton Jr wrote:
I have been tryi
I have these two tables: 'registration_and attendance' and 'schedules'
They both share a common class_id field. I'm trying to write a Trigger
which will set the class_id field for 'registration_and attendance'
equal to the schedules.class_id matching the
registration_and_attendance.schedule_id
Is it possible to SET values on fields that involve the TABLE that
invoked the TRIGGER with SET actions.
I have the following lines in my trigger:
delimiter //
CREATE TRIGGER trigger_registration_and_attendance_before_insert
BEFORE INSERT
ON registration_and_attendance
FOR EACH ROW
BEGIN
DECL
Middleton Jr wrote:
Is it possible to SET values on fields that involve the TABLE that
invoked the TRIGGER with SET actions.
I have the following lines in my trigger:
delimiter //
CREATE TRIGGER trigger_registration_and_attendance_before_insert
BEFORE INSERT
ON registration_and_attendance
FOR EACH ROW
Ferindo Middleton Jr wrote:
Gleb Paharenko wrote:
Hello.
It seems that you forgot to OPEN the cursor. The trigger should be
similar to this one:
CREATE TRIGGER trigger_registration_and_attendance_before_insert
BEFORE INSERT
ON registration_and_attendance
FOR EACH ROW
BEGIN
DECLARE
I have the following table where I have a CHECK CONSTRAINT to check for
logical data values but for some reason it's not working on INSERTs to
the table. MySQL doesn't give any error message when I CREATE TABLE. Any
ideas what I'm doing wrong?... or Is this type of declaration not
supported...
I have two tables, registration & schedules, that look like this:
CREATE TABLE registration (
idSERIAL NOT NULL UNIQUE,
firstnameVARCHAR(256) NOT NULL,
middlenameTEXT,
la
Paul DuBois wrote:
At 17:56 -0500 1/28/06, Ferindo Middleton Jr wrote:
I have two tables, registration & schedules, that look like this:
CREATE TABLE registration (
idSERIAL NOT NULL UNIQUE,
firstnameVARCHAR(256)
Ferindo Middleton Jr wrote:
Paul DuBois wrote:
At 17:56 -0500 1/28/06, Ferindo Middleton Jr wrote:
I have two tables, registration & schedules, that look like this:
CREATE TABLE registration (
idSERIAL NOT NULL UN
Ferindo Middleton Jr wrote:
Ferindo Middleton Jr wrote:
Paul DuBois wrote:
At 17:56 -0500 1/28/06, Ferindo Middleton Jr wrote:
I have two tables, registration & schedules, that look like this:
CREATE TABLE registration (
idSERIAL NOT NULL UN
Paul DuBois wrote:
At 18:03 -0500 1/29/06, Ferindo Middleton Jr wrote:
Ferindo Middleton Jr wrote:
Ferindo Middleton Jr wrote:
Paul DuBois wrote:
At 17:56 -0500 1/28/06, Ferindo Middleton Jr wrote:
I have two tables, registration & schedules, that look like this:
CREATE TABLE registra
Paul DuBois wrote:
At 20:41 -0500 1/30/06, Ferindo Middleton Jr wrote:
Paul DuBois wrote:
At 18:03 -0500 1/29/06, Ferindo Middleton Jr wrote:
Ferindo Middleton Jr wrote:
Ferindo Middleton Jr wrote:
Paul DuBois wrote:
At 17:56 -0500 1/28/06, Ferindo Middleton Jr wrote:
I have two tables
If say something like the following from the mysql command line tool:
SELECT * FROM dognames INTO OUTFILE 'C:/outfiles/dognames.tab';
How do I get mysql to include the column names in the file's output?
Ferindo
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To un
I have the following query which counts the records from a table called
registration that have an schedule_id that matches a record in another
table called schedules. The below query works fine but how can I get it
to return a COUNT() of 0 each instance where there is no record in the
registr
I think I've seen this complaint posted before but I ignored but now I
realize that in some of my db tables' last_updated field the value is
automatically updating on UPDATEs to records while in other tables the
last_updated fields for some strange reason aren't automatically updating.
I'll us
jonathan wrote:
are you having two timestamp fields in a table (ie a created and a
last_updated)?
-j
On Mar 30, 2006, at 5:17 PM, Ferindo Middleton Jr wrote:
I think I've seen this complaint posted before but I ignored but now
I realize that in some of my db tables' last_updated
Hank wrote:
Are the other fields in the update statement actually changing the
data? I don't know for sure, but if the data on disk is the same as
the update statement, mysql won't actually update the record, and
therefore might not update the last_updated field also. Just a
thought.
Yes, I
Ferindo Middleton Jr wrote:
Hank wrote:
Are the other fields in the update statement actually changing the
data? I don't know for sure, but if the data on disk is the same as
the update statement, mysql won't actually update the record, and
therefore might not update the last_updated
lp me align my scope with my
equipment/location in mind, kinda doing through the process step by step? I
would really appreciate any input since I´m a dummie about these things.
Thanx !!
Newton Varella, Jr.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Hi there !
Does anyone knows if there is a specific MySQL ERROR (SQLSATE)
for DELETE of a not found key?
I have tried MySQL Error 1032 e 1176 (SQLSTATE HY000) but it
does not seems to work ..
Thanks in advance
Ni
r:
'@localhost' to database 'desenv''
The directory "/usr/local/mysql" and subfiles owner and group are "mysql"
Anybody can help me!
Thanks!
Paulo Fonseca Jr.
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysq
Hi,
I'm having a problem every so often with the following error message:
040718 15:21:59 InnoDB: Started
/usr/sbin/mysqld: ready for connections.
Version: '4.0.16-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306
Number of processes running now: 1
mysqld process hanging, pid 12141 - ki
How do I compare blank spaces in a string using LIKE ?
I tried the following:
SELECT * FROM table WHERE name LIKE '% John %';
But it didn't work.
To explain: I don't want the string 'Johnson' to be shown when running the query
above.
Th
I'm attempting to install using INSTALL-BINARIES and get this message
while executing mysql_install_db:
[cuppjr mysql]$ scripts/mysql_install_db
scripts/mysql_install_db: ./bin/my_print_defaults: cannot execute binary
file
WARNING: The host 'raq2.homeunix.org' could not be looked up with
resolveip.
Carmichael [mailto:[EMAIL PROTECTED]
Sent: Friday, October 03, 2003 11:44 PM
To: Michael Cupp, Jr.
Subject: Re: Installing
> I'm attempting to install using INSTALL-BINARIES and get this message
> while executing mysql_install_db:
Did you download the binaries or compile from source?
> [
l++-1.7.9/sqlplusint/connection2.hh:5,
from /usr/local/mysql++-1.7.9/sqlplusint/mysql++:37,
from atletas.cpp:3:
/usr/local/mysql++-1.7.9/sqlplusint/query2.hh: In method `void
MysqlQuery::storein_sequence(Seq &, SQLQueryParms &, query_reset =
RESET_QUERY)
Does anyone know where I can read more on how to redirect incoming email
(via Sendmail) into MySQL for a given email address?
I understand that I can use "<[EMAIL PROTECTED]> | /path/mysql ..." in the
/etc/aliases file to do this, but I would like to see if anyone has had
success with this. I also
I believe this is close to what I am needing.
Thank you for your time and detail.
My thank you to everyone else for their comments.
Thanks,
Jeff
On Thu, 2003-02-27 at 12:13, Vikash K Agarwal wrote:
> We have used procmail and PHP combination to achieve this for our
> department mail management
Hi,
I'm looking to Import complete MS Access Table with
Data into a MySQL Database. How can i do that?
Especially if i have to do it for a site on the
internet...
Thanks,
T. Edison Jr.
__
Do You Yahoo!?
Yahoo! Movies - coverage of the
I actually tried this just a few moments ago and it
worked! But thanks!
T. Edison jr.
--- Andrew Hazen <[EMAIL PROTECTED]> wrote:
> Print out a "documentation" of the Access database.
> Use phpMyAdmin
> interface to build the same table structures in
> MySql.
How do i import MS Excel Data into MySQL Tables??
T. Edison jr.
=
Rahul S. Johari (Director)
**
Abraxas Technologies Inc.
Homepage : http://www.abraxastech.com
Email : [EMAIL PROTECTED]
Tel : 91-4546512/4522124
It doesn't return me a user... but it's there, registered...
Is there a way to do that or no... if there is, something give me a hint...
My client's website is running in a Windows 2000 server but the MySQL server
I thank all the people that helped me... was very usefull, I tried each one...
But i'm using ASP with a DSN Connection
Check the code:
Set MyConnection = Server.CreateObject("ADODB.Connection")
MyConnInfo = "DSN=MyDSN;UID=MyUser;PWD=MyPass;"
MyConnection.Open MyConnInfo
SQL = "INSERT INTO user
This data was exported via SQL Server.. using Oracle.
I need to use this data in my mySQL Database and work
on it through PHP.
Can i use phpMyAdmin for this.. or some other method?
Thanks,
T. Edison Jr.
=
Rahul S. Johari (Director)
**
Abraxas
Hello,
I'm looking for a solution to INSERT data from a text file that is used
for logging into a MySQL table.
A hypothetical example...
I have a server (any server, could be a RADIUS, a DNS or a MTA) that
logs to a file in "/var/logs/log-file". Is there a way to take the raw
data sent to the l
show data to users on the Website. It's something
like that. The software involves a lot of processing,
decryption, conversion etc. to convert a .dat data
into usable mySQL Tables Data.
Hope somebody can help.
Thanks,
T. Edison Jr.
__
Do You Ya
Hi,
I would like to export Table Data which is on my
localhost mySQL Server, to a Table in mySQL on the
Internet Web Server. How can i do that? Basically it's
just moving mySQL Table Data from localhost to web
server on the internet! Is it possible? if so, how?
Thanks,
T. Edis
them? I coudln't find a
suitable description on using the Foriegn Keys in the
mySQL Manual.
Thanks,
T. Edison Jr.
__
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc
Glory!
I'm looking for a Provider for the myODBC Driver to
connect my Visual Basic code with my mySQL database.
I have in kknowledge one such provider known as
MSADSQL..but niether do i know where to find it nor do
i know whether it's the right thing or not.
T.
I am using perl 5 and linux 6. I am currently capable
of retrieving information from my databases, but am at
a complete loss as to how to parse the results into 20
results per page.
Can / will you help?
__
Do You Yahoo!?
Check out Yahoo! Shopping a
please help:
I cannot figure out how to parse SELECT query into
html pages.
__
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com
HI!
there is a problem in mysql database.there r two
tables.one table is named as transactions and the
other is named as the code.the transactions table has
got the 12 fields which r the following 1.clientid int
2.date date 3.isinno text 4.debit int 5.credit
int 6.desc text
7.dpid1 text
I have a table with names in it where the names can function as 1 of 2 things -
either an artist or a group. In order to make searching easy I wished to keep
these names in one table. EG: searching for artist name, whether a group or
soloist you would have to search only one table. The problem aris
This is probably going more into db design than pure mysql issues...on
the other hand if performance is at stake with these different
designs.
After several inputs - which I am EXTREMELY thankful for - here are
some of my thoughts. The solution using Joseph's table aliases works
beautifully. Wi
I'm just not understanding what I'm reading in Ch. 7.
I created a table, in my database, now I just want to add 2 more varchar
columns to it. I tried following along with the manual, but, I'm not seeing
it, and I get errors every time in telnet. If someone would be so kind as
to help me, I appr
Billy, and friends,
Always helpful info: What have you tried, and what errors are you
getting?
alter table web_guests add column (p1 varchar(15), p2 varchar(15));
Error 1064 You have an error in your sql syntax near '(p1 varchar(15), p2
varchar(15))' at line 1
TIA,
Dean MacIsaac
---
Anyone know how to bind / set mySQL to listen on a specified IP on a
multi-homed machine (my machine running mySQL as 3 diff Interfaces, and I
only want to accessible via the local eth0 interface)
-
Before posting, please check
So is there a place where MySQL stores all warning messages which occured
during LOAD DATA ?
-Arnis
>
> Hi
>
> This is not a response to Malcolm, but rather a query.. if the CSV file
> to be imported into a MySQL table using LOAD DATA command had ASCII
> char(13) and/or ASCII char(10) in it, wo
quot; not found
Installation of grant tables failed!
---SNIP
--
Jeff Neuffer Jr.
Data Services Technician
North State Telephone
This mail was processed by Mail essentials for Exchange/SMTP,
the email security & management gateway. Mail essentials adds
content checking, email encryption, a
Several of my DISTINCT searches are frequently showing up in the slow query
log. These queries use multiple table joins. Using EXPLAIN shows that the
queries are using the appropriate keys, as far as I know. Are DISTINCT
searches using multiple joins slow?
TIA.
Stephen P. Fracek, Jr.
[EMAIL
s query is now
frequently in the slow query log.
Stephen P. Fracek, Jr.
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
y doesn't work - it finds ALL the rows in Project table and hence
repeats the sites..
I do have an index on the Site table, it is the Site_ID. The
Project.Site_ID is also indexed.
Stephen P. Fracek, Jr.
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have not been monitoring my databases now I am using a 100% disk space.
thank you,
Raymond
-Original Message-
From: Gary Richardson [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 03, 2006 14:10
To: Jacob, Raymond A Jr
Cc: mysql@lists.mysql.com
Subject: Re: Can I delete old -bin.x files in order to free up some
space?
Yes you can. Be sure not to delete the one the
Thank you
Raymond
that did the trick.
-Original Message-
From: Gary Richardson [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 03, 2006 14:39
To: Jacob, Raymond A Jr
Cc: mysql@lists.mysql.com
Subject: Re: Can I delete old -bin.x files in order to free up some
space?
I believe the
Environment: Freebsd 6.0
Mysql : mysql Ver 14.7 Distrib 4.1.18, for porbld-freebsd6.0 (i386)
using 5.0
On the client, I get /var/log/messages, I get the errors:
kernel: 9643D22706C
and
database: mysql_error: The table 'data' is full SQL=INSERT INTO data
(sid,cid,data_payload) VALUES"
I hav
12:43
To: Jacob, Raymond A Jr
Cc: mysql@lists.mysql.com
Subject: Re: Sorry for the dumb question how do I fix table is full?
Raymond, can you post the output of
SHOW TABLE STATUS LIKE 'data';
that should show how big your table is and how big it can be...
Dan
On 6/28/06, Jacob, Raym
thank you,
raymond
-Original Message-
From: Dan Buettner [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 28, 2006 16:07
To: Jacob, Raymond A Jr; mysql@lists.mysql.com
Subject: Re: Sorry for the dumb question how do I fix table is full?
I agree it's not very clear. I think Br
Yesterday:
I ran the following command:
ALTER TABLE data max_rows=1100
Today:
The client still reported table is full.
I rebooted the client and stopped and started the mysql server.
I still get the table is full error on the data table.
I ran the command:
\ echo "SHOW TABLE STATUS LIKE 'da
y, June 29, 2006 15:53
To: Jacob, Raymond A Jr; mysql@lists.mysql.com
Subject: Re: Client still reports table full
Oops, left out an important part. You should change the Avg_row_length
also.
ALTER TABLE AVG_ROW_LENGTH = 50
You need to specify an average row length if you have dynamic length
fie
]
Sent: Thursday, June 29, 2006 17:55
To: Jacob, Raymond A Jr
Cc: mysql@lists.mysql.com
Subject: Re: Client still reports table full
I'm not sure that avg_row_length has a bearing on your problem right now
... the output of show table status you posted earlier shows that you
have:
current
Baisley [mailto:[EMAIL PROTECTED]
Sent: Friday, June 30, 2006 8:49
To: Jacob, Raymond A Jr; mysql@lists.mysql.com
Subject: Re: Client still reports table full
Wow, I'm really sorry about that. Left out a zero. I should stop
answering questions before the holiday weekend.
I was suggesting a
I ran the following commands:
USE snort;
CREATE TEMPORARY TABLE sidtemp SELECT cid FROM event WHERE timestamp <
'2006-05-01';
...
SELECT count(*) from sidtemp;
count(*)
7501376
DELETE FROM data WHERE data.cid = sidtemp.cid;
ERROR 1109 (42S02): Unkown table 'sidtemp' in where clause
SHOW ta
Thank you,
I was definitely on the wrong track on this one.
I annotated your commands to make sure that I understood what they
were doing. Are my comments correct?
---
You have the wrong syntax. You can't mention a table in the WHERE
clause that wasn't in the FROM clause. Try
DELE
Thanks again,
raymond
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 05, 2006 14:54
To: Jacob, Raymond A Jr
Cc: mysql@lists.mysql.com
Subject: Re: Temporary table ERROR 1109 (42S02) where are temporary
tables kept?
Jacob, Raymond A Jr wrote
Env: Freebsd 6.0
MySql 4.1.18
Mem: 1GB(?) can not tell without rebooting
Disk Avail: 4GB
Problem: the table data is 4.5GB.
I created a temporary table sidtemp in the database snort by typing:
CREATE TEMPORARY TABLE sidtemp
SELECT cid FROM event
WHERE timestamp < '2006-05-01';
Query OK, 7501376
-Original Message-
From: Dan Buettner [mailto:[EMAIL PROTECTED]
Sent: Friday, July 07, 2006 15:48
To: Jacob, Raymond A Jr
Cc: mysql@lists.mysql.com
Subject: Re: How does one speed up delete.
Raymond, I would expect that adding an index on 'cid' column in your
'sidte
I started the operation below on Friday at 1300hrs EST
DELETE data
FROM data, event
WHERE data.cid = event.cid
AND event.timestamp < "2006-05-01"
It is now Sunday 22:00hrs EST and the operation is still running.
Question: Should it take this long to delete 7.5 million records from a
4.5GB
T
Could the problem the Locked data table in this case?
mysql> show processlist;
+-+---+---+---+-+---
-+--+---
---+
| Id | User | Host
It appears that every time I start query the event or the data table
gets Locked.
Could this have any affect on why it takes so long to delete records.
Grasping at straws,
Thank you,
Raymond
mysql> show processlist;
+-+---+---+---+-
When I try to retrieve all rows in the event table that are in a
particular range and then
try to determine if the cid is in the data table the join takes
forever.
So I tried just tried adding the table to see if the where clause was
slowing things down. Below is a portion on my session.
mys
Now, I when I do a desc on data table, I get the error
ERROR 1016 (HY000): Can't open file: 'data.MYI' (errorno: 144).
As I recall I ran:
optimize data;
The Optimize command did not complete the error as I recall was /var
filesystem full.
Running the following commands:
ls data.*
data.MYD
Thank you,
raymond
-Original Message-
From: Dan Buettner [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 13, 2006 18:07
To: Jacob, Raymond A Jr
Cc: mysql@lists.mysql.com
Subject: Re: I ran of disk space running optimize on table Now I can
not open "data.MYI"
Hmmm. Do
db.tab_f WHERE tab_a.id = 'value' AND tab_a.id2 = tab_e.id2 AND tab_e.id3 =
tab_f.id3 LIMIT 1; <- this is ok
Why doesn't the original query work in MySQL 5.0? What do I need to do to
make it work?
TIA
Stephen P. Fracek, Jr.
[EMAIL PROTECTED]
--
MySQL General Mailing List
For l
recedence with
the comma operator and the join, I realized there was a
simple fix and that I had misinterpreted the section on the first read.
The revised query works.
Stephen P. Fracek, Jr.
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Problem: I use two applications one called snort, the client that
inserts data into eleven(11) tables.
The other application BASE joins the tables into one table. When the
tables become 4GB in size,
deleting records for one month becomes unbearably slow(20-30days). The
search(Select ) is slow too
-Original Message-
From: Brent Baisley [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 06, 2006 10:24
To: Jacob, Raymond A Jr; mysql@lists.mysql.com
Subject: Re: Adding and Removing tables from MERGE tables dynamically
I've got a similar setup, total records across about 8 tables ho
400 MB.
Any insights would be greatly appreciated.
TIA
Stephen P. Fracek, Jr.
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have three(3) instances of an application inserting data into a MYSQL (4.X)
database. I have to change the password.
I would like to know, if I can change the password of the application on the
server without disrupting existing
connections then modify the password in the startup file for the
After a 23days of running mysql, I have a 3GB database. When I use an
application
called base(v.1.2.2) a web based intrusion detection analysis console, the
mysqld utilization
shoots up to over 90% and stays there until the application times out or is
terminated.
Question: Have I made some err
Hello all.
I have recently finished my migration from an older server to a newer
server running RHEL 6. The MySQL version went from 5.0.77 to 5.1.52.
In my application, this query used to work just fine:
$paid_query = mysql_query("UPDATE $table_name SET owed = 0 WHERE s_id
= $student");
Where t
column equals the value in the
modification column? I don't want to specify a specific id in either
of the columns.
TIA
Stephen P. Fracek, Jr.
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[
I apologize for asking this question.
I am somewhat confused by Microsoft's Licensing and I personally can not
justify to senior management why
MS SQL should be procured instead of procuring software more urgent
requirements.
I had the not so bright idea that maybe a MS SQL emulator or
compatibili
I am using MySql 5.1.14-beta with Java/ConnectorJ on the client.
Section '5.14. The MySQL Query Cache' states 'The query
cache is not used for server-side prepared statements' and I
have confirmed that the results of a stored procedure that
makes use of a passed in parameter are not in fact stored
I have a table:
Id |path1 | display| value
1 | ostype | os|windows
1 | ostype | ver |NT4
2 | ostype | os | linux
2 | ostype | ver | RHEL 5.4
That I would like to tranform into
Id | os| ver
1 |windows | NT4
2| linux |RHEL 5.4
Thank you,
Raymond
smime.p7s
How does one insert records based on some kind of meta data or key in
particular table belonging to a merge table?
I have a network logging program and would like to partition the table so that
analysts can query certain tables belonging
to the merge table instead of the whold table to corelate e
Question: I frequently would like to summarize the results of my query in
heiarchical layout also
known as a Pivot table.
Here is an example of what I would like output. NULL will be printed as a space
when output.
sum of broken| source of | qty |reseller of |qty |customer with |qty
Does such a JOIN exist that can create a pivot table?
Thank you:
182361 by: Dan Bolser
182362 by: Peter Brawley
Now I must go into my cave and meditate on these queries: Ommm,Ommm,...Ommm :-)
raymond
running: mysql Ver 12.22 Distrib 4.0.23, for Win95/Win98(i32) downloaded from
www.devside.net/web/servers/free/download.
When I run a script with the following commands I get sql syntax errors:
Create table 'test' ( 'helper' varchar(22) )
ENGINE=MYISAM DEFAULT CHARSET=latin1;
I get a sql error
I'm trying to upgrade the glibc on some machines that do not yet have glibc2
in order to support > 1000 threads. It seems that some of the instructions
concerning setting a pthread maximum for older glibc's are no longer
pertinent.
I wonder if the glibc 2.3.2 is known to be compatible with MySQL
1 - 100 of 172 matches
Mail list logo
