Re: Help with AES_DECRYPT

$query = "SELECT date, AES_DECRYPT('cardnumber1','jmbjd'), AES_DECRYPT('cardnumber2','jmbjd'), AES_DECRYPT('cardnumber3','jmbjd'), AES_DECRYPT('cardnumber4','jmbjd'), upload_type, z_errors, a_errors, db_errors FROM customers WHERE refrence_number = '$refnum'"; If 'cardnumber1' is the name of the c

FLUSH error

I've been getting this error in myPhpAdmin. Database /mydb/ - table /testing_table/ running on /localhost/ *Error* SQL-query : FLUSH TABLE `testing_table` MySQL said: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)

Re: 2 datatables 1 db

> Eg, I have say mod_calendar_events which is old and > mod_mod_calendar_events which is new. How can I combine the the old > into the new? I read about union but dont know how to do the query. Maybe it's easier to run a query like: INSERT INTO mod_mod_calendar_events SELECT * FROM mod_calendar_

2 datatables 1 db

Hi, Im running phpwebsite. I installed and then it crashed with dbs left untouched. I reinstalled and directed the new install to existing dbs. But a new set of data tables were created and phpwebsite now reads the new tables which are now empty. Eg, I have say mod_calendar_events which is old

Re: Problem with UTF-8 in 4.1.1a [SOLVED]

Thanks Jeremy a lot, it did help. You were right; I've been entering data correctly. I only could not see it the right way. After a little of tests, I finally figured it out how to do this and I'm going to tell it here so if any one had my problem, so he can use this. ==

SQL SECURITY

Hi, I have created a stored procedure in mysql with definer sql security. If there is another user 'X' how to give him the invoker rights in the procedures itself. Thanks and Regards, Sunil.K -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsu

A "current row updating" counter for a mass "Update" or similar?

Hi all, I'll just get straight to the problem (simplified): Say I have the following table/columns: ID, Score, Rank 1, 20, 0 2, 50, 0 3, 10, 0 4, 5, 0 5, 97, 0 Is it possible, in a single query (using sub-queries if necessary), to give all of these "ID's" the correct rank... ie if such a thing ex

Re: Automatic conversion from `char` TO `varchar`

OK, this will be my last post on this topic. Mainly I want to point out that I was taking the wrong conclusions from the results of my tests. I followed the advice of Michael Stassen and ran some more tests using int columns for joins and got pretty much the same trend. So I guess the real answer i

Help with AES_DECRYPT

Hey, I am currently having alot of trouble using the AES_DECRYPT function. Can anyone explain to me where I am going wrong. I can get the inserts to work, but I cannot retrive the decoded string with the following Select statement: $query = "SELECT date, AES_DECRYPT('cardnumber1','jmbjd'), AES_D

Re: There has to be a way to do this

Ignore this as aparently someone already posted almost the exact same thing :) Thanks, Ryan Yagatich ,_, \ Ryan Yagatich [EMAIL PROTECTED] \ / Pantek Incorporated (877) LINUX-FIX / \ http://www.pantek.com/s

Foreign Key Reference to a VARCHAR

Hi, I hope this is not a well known problem since I just signed up to this list. But I checked the February archive and couldn't find anything on this. I was trying for a couple of hours now to create a foreign key reference on a varchar field: CREATE TABLE users ( loginVARCHA

Re: HOW TO RUN SQL

hi, to run a sql script from mysql shell just use command "source your_sql_script.sql" if you want to run it directly from prompt use this mysql --force -uusername -ppassword -e"source your_sql_script.sql" - Original Message - From: "Seena Blace" <[EMAIL PROTECTED]> To: "Remko Lodder" <

Re: There has to be a way to do this

Try something like this: MYSQLSTRING="/usr/local/mysql/bin/mysql -u $username -p $password -h $server cetechnology" RESQUERY="SELECT COUNT(*) FROM hardware_assets WHERE ethernet_address='$ethernet_address'" RESULT=`echo "$RESQUERY;" | $MYSQLSTRING` INSERTQUERY="INSERT INTO hardware_assets (ethe

Re: Admin Question

Ronan, The command you are looking for is 'SHOW PROCESSLIST' or 'SHOW FULL PROCESSLIST'. Additionally, take a look at 'mytop', which you can find at http://jeremy.zawodny.com/mysql/mytop/ mytop - a top clone for MySQL mytop is a console-based (non-gui) tool for monitoring the threads an

RE: HOW TO RUN SQL

if you want to do sql scripting then i suggest you use a bash script with the settings i provided to you oh If you are able to, please don't use HTML mail thanks cheers -- Kind regards, Remko Lodder Elvandar.org/DSINet.org www.mostly-harmless.nl Dutch community for helping newcomers on the

HOW TO RUN SQL

how to run sql script like if i have mysql prompt mysql > at above prompt I want to run sql script. how to do this? what will be extenstion of file? Remko Lodder <[EMAIL PROTECTED]> wrote: mysql -p -u -e that can be runned from any shell script. use enum to check Y/N TRUE/FALSE etc. CREATE

Re: There has to be a way to do this

When I run this, it always updates the record, not matter what the value for $ethernet_address is. I have tested this by changing the line under else to echo "Update" Every time the script is run, it comes back with update. I then we back and commented out the whole if/else statement and had only

Re: LEFT JOIN to a table using 2 keys from different tables

It's tough to answer your question without seeing your actual table structure. You can use AND in a join: SELECT * FROM a1 LEFT JOIN b1 ON a1.f1=b1.f1 AND a1.f2=b1.f2 In you example query, MySQL will try to do the LEFT JOIN first (I'm pretty sure), which is not what you what. But if you change i

question about replication

Hi, I tried to create replication. I have edited my.cnf on master and slave side. Grant necessary privileges on master side, then start both servers, when I update the database in master side, I could see the query showed up in ***-bin.001, and it is passed to slave side successfully, shown

RE: [Mysql-discussions] HOW TO RUN SQL and default value ?

mysql -p -u -e that can be runned from any shell script. use enum to check Y/N TRUE/FALSE etc. CREATE TABLE testtest ( test ENUM( 'TRUE', 'FALSE' ) NOT NULL ); it automaticly sets true as default value with me. otherwise add: DEFAULT 'FALSE' after not null Hope this helps -- Kind regards

HOW TO RUN SQL and default value ?

Hi, How to run script at mysql prompt? Like if i want to create a table or select some query and I want to put those sql statement into one file ,how to run that and what would be the extention of that query? I want to create on column which contains only default value TRUE or False.how to do tha

Re: LEFT JOIN to a table using 2 keys from different tables

Not sure if this is what you are asking, but how about: SELECT * FROM t1 LEFT JOIN t2 ON t1.c1 = t2.c2 Big Brother tells me that David Perron wrote: > > Is there a way to do this? Im trying to LEFT JOIN to a table that needs to > select based on 2 keys, but the query Im writing only has the

LEFT JOIN to a table using 2 keys from different tables

Is there a way to do this? Im trying to LEFT JOIN to a table that needs to select based on 2 keys, but the query Im writing only has the keys individually in two separate tables, like this. The documentation shows how to do this when you are using 2 keys from both tables, but not 1 key from 1 tab

Re: There has to be a way to do this

This is NOT a script that can run under mysql. It is a bash script that calls mysql. MYSQL="/usr/local/mysql/bin/mysql --user=$username --password=$password --host=$server cetechnology" RESULT=`echo "select count(*) from hardware_assets where ethernet_address='$ethernet_address'" | $MYSQL if [

unhex a varchar column

Hello, Using MySQL 4.017 on Win2k sp3: using MySQL built-ins: how can I convert a value stored as a hexadecimal string back to a binary string while logged into the shell? >set @t1=616263; >select 0x616263; how can I turn @t1 back into 0x616263? What is the syntax? I tried sele

error connecting using ByteFX ADO.NET data provider to a MySQL 5.0.0a database

I was wondering if someone has had the error "ByteFX.Data.MySqlClient.MySqlException: Bad handshake" when trying to talk to a MySQL 5.0.0a database when using ByteFX's ADO.NET data provider. I used pretty much the same code to connect to a table in an Access Database with no problem. The code and

Admin Question

Hello, We have an MySQL-4.0.14 Server installed and sometimes the it takes 90% from CPU. So, my question is: Is there a way to know what is taking so many CPU process? What query is causing such problem? Thanks Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mys

Re: Version 4.1.2. when?

Mirza, - Original Message - From: "Mirza" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Monday, February 09, 2004 1:54 PM Subject: Version 4.1.2. when? > Is there any info on when 4.1.2. is scheduled for relase? I am stucked > in 4.1.1. with fulltext problem (bug #2490).

Re: SQL2000 and MySql

Hi, > I have a software of insurance to do quotations directly on the web. It uses > a SQL 2000 database and I want to use MYSQL database. Do you think it is > possible ? That depends on the requirements, doesn't it. What do you use in your MS SQL 2000 database? For example, MySQL doesn't have

(FOUO) Anyone seen any Banking/Database Web applications ....

CLASSIFICATION: UNCLASSIFIED SECURITY CONTROL MARKING: FOR OFFICIAL USE ONLY I am looking for a Banking Web application with all the Web pages, content and Database behind it. Any example will do. Thanks, Mike Classification: UNCLASSIFIED Security Control Marking: FOR OFFICIAL USE ONLY --

Re: auto_increment pseudo sequence?

alter table AUTO_INCREMENT=x Scott Purcell wrote: Hello, I have an application in which I am using auto_increment as a kind of sequence replacement. The only problem I have is trying to get the auto_increment to start at a larger number than 0. Is auto_increment the replacement for sequences?

Re: auto_increment pseudo sequence?

When you create the table I think you just set it.. ie- create table blah AUTO_INCREMENT= P -"Scott Purcell" <[EMAIL PROTECTED]> wrote: - To: <[EMAIL PROTECTED]> From: "Scott Purcell" <[EMAIL PROTECTED]> Date: 02/09/2004 12:21PM Subject: auto_increment pseudo sequence? Hello

Re: There has to be a way to do this

Mike Tuller <[EMAIL PROTECTED]> wrote on 09/02/2004 16:53:00: > I have posted this question a few times, and have not seen the answer that I > need. > > I have a shell script, that gathers information from systems, and I want > that info to be entered into a database. I want it to check fir

Re: Problem with UTF-8 in 4.1.1a

It sounds like you are using the mysql client to display your queries. You should do: SELECT HEX(arabic_column) FROM your_table; to really see what characters are stored in the table. To see the unicode codepoints you can do this: SELECT HEX(CONVERT(arabic_column USING ucs2)) FROM your_table;

Re: SQL2000 and MySql

And then there's the whole opensource thing :) Your platform focus depends a lot on it too. If you're a MS shop, I'd imagine SQL would be the way to go. All the fancy MS integration stuff is there. Connecting to it from other OS's is generally done with ODBC. ODBC is pretty stinky as it's an abb

Re: There has to be a way to do this

I changed my script to this: /usr/local/mysql/bin/mysql --user=$username --password=$password --host=$server RESULT=`echo "select count(*) from hardware_assets where ethernet_address='$ethernet_address'" | cetechnology' if [ "$RESULT" = "0" ] ; then echo "INSERT INTO hardware_assets (ethern

auto_increment pseudo sequence?

Hello, I have an application in which I am using auto_increment as a kind of sequence replacement. The only problem I have is trying to get the auto_increment to start at a larger number than 0. Is auto_increment the replacement for sequences? and if so, is there a way to set the digit to a l

RE: There has to be a way to do this

If you are always updating the entire row you could delete the record (ignoring failures) and then insert the record. Not efficient but it would work. If you are able to trap errors in your shell script and there is a unique index on the ethernet_address field then you can do this: Update Record

Re: SQL2000 and MySql

Hi, > Does somebody can explain the technical difference beetwen SQL2000 and MySQL In exactly what area? In short: MS SQL 2000 is more advanced, has more build in stuff, is more expensive, most probably has more security leaks :-) With regards, Martijn Tonies Database Workbench - developer t

Re: There has to be a way to do this

IF works on the selections not on the query. Select IF(lastname='clark','Correct',''Incorrect'), firstname from namefile; You need to do the checking in your script. For example in bash: RESULT=`echo "select count(*) from manefile where lastname='clark'" | mysql database` if [ "$RESULT" = "0" ]

Re: There has to be a way to do this

You could create a User defined Function that contains this logic. At the present time, an UDF needs to be coded in C. Depending on how your `users` interface with the application, you could write a C/C++ or java command line interface as well. >> Original Message <<<

There has to be a way to do this

I have posted this question a few times, and have not seen the answer that I need. I have a shell script, that gathers information from systems, and I want that info to be entered into a database. I want it to check first to see if the data is already entered, and if not, add it. If it has already

SQL2000 and MySql

Does somebody can explain the technical difference beetwen SQL2000 and MySQL Thks a lot Bertrand -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mySQL search engine

Have you tried "explain?" Have you indexed the table? Curtis On Sun, 8 Feb 2004, ___bug wrote: > Hello, > > > What is the best way to search a table with about 500.000 rows of varchar > type. > --- > / id / time / name / > --- > Like '%blah%' and x Like '%blu

Re: Stored procedures

"Prasad Budim Ram" <[EMAIL PROTECTED]> wrote: > Hi, > I'm testing stored procedure on MySQL5.0.My question is can I change > the definition of a procedure body using ALTER PROCEDURE?(Not the > characteristics). I'm not sure if it is implemented! > You can't do it with ALTER PROCEDURE. Only DROP

RE: MySQL and Coldfusion

Hi Ian, What is the problem you are hitting? I have been successfully using MX with MySQL. Matt -Original Message- From: Ian O'Rourke [mailto:[EMAIL PROTECTED] Sent: Sunday, February 08, 2004 10:52 AM To: [EMAIL PROTECTED] Subject: MySQL and Coldfusion Is anyone on the list using Col

RE: Advice

Hi Alexander, Perhaps the console application would be better suited for you. That way the response is always ASCII text, and you only need to type the commands. In case you haven't tried the console before ... To start the console application: 1. Open a DOS prompt (in windows) or a command she

Re: Last record

the idea is: table1: id own 1A 2B 3A 4C table2: id type 13 14 12 34 35 41 I need as result query: own type A 2 A 5 C 1 Thanks in advance - Original Message - From: "Michael Satterwhite" <[EMAIL PROTECTED]> To: <[EMAIL PROTECT

Re: Problem with UTF-8 in 4.1.1a

Hi Lorenzo, Well I've tested all the possible ways. I even made a php file to insert data into the data base without getting it from user (inserting a constant string). In that file I'm sure that my string is encoded in UTF-8. Even though I'm sure that with IE's encode set to UTF-8, it will send

2000 Vs. NT [No Virus found]

Hi All, We recently migrate our MySql DB from a Win NT Server (Biprocessor, RAM 2Go) to a Win 2000 Server (Quadriprocessor, RAM 4Go). Hopefully we noticed a global performance gain, but some scripts seem to be slower than before ! For some reason, we are still running the old 3.23.51 release.

RE: non unique index on MySQL 5.0

Sorry for the repost, but I just realized that the index information for key 3 did not get copied into the 1st email. -Original Message- From: Gordon [mailto:[EMAIL PROTECTED] Sent: Monday, February 09, 2004 8:48 AM To: [EMAIL PROTECTED] Subject: non unique index on MySQL 5.0 I just inst

non unique index on MySQL 5.0

I just installed MySQL 5.0 on my windows machine and was trying to load the output from a MySQLFront export from our 4.0.16 production system when I got the following error.. C:\>mysql -u root mailprint < e:\mp20040205.sql ERROR 1062 at line 7893168: Duplicate entry 'Name-4928 N Brooklyn Kansas

Re: reg MySQL C API Prepared statements

Arunachalam <[EMAIL PROTECTED]> wrote: > Hi! > > MySQL C API Prepareed statements routines; > mysql_prepare, > mysql_bind_param, > mysql_fetch, > mysql_execute are present in *libmysql.lib* file - right... > > I have currently used MySQL 4.0.17-max > > I want to clarify

Re: WHERE NOT EXISTS

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Monday 09 February 2004 08:05, Carl Schéle, IT, Posten wrote: > I use php 4.1.1. mysql 3.23.49 and phpmyadmin 2.5.4 > > I have two tables > > classes > > - class_id (int) > - class_name (text) > > HS > HD >

Re: Last record

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Monday 09 February 2004 08:44, Patricio Gigoux wrote: > Hi: > How Can I do for after a query I put at the its last record? I'm not sure I followed the question, but I think you're asking how to look at the last record in the set you just returned.

Re: WHERE NOT EXISTS

"Carl Sch?le, IT, Posten" <[EMAIL PROTECTED]> wrote: > I use php 4.1.1. mysql 3.23.49 and phpmyadmin 2.5.4 [skip] > What I want to do is to list all class_name from classes that aren't represented a > specific year. > > So what I want as result is HD, DD, MD > > I'm trying to use the followin

Re: Remote Access with Linux

One way is to expose the port that MySQL is running on via the firewall. Another option could be to run ssh on the target MySQL machine and forward the MySQL ports giving you a secure connection. >> Original Message << On 2/9/04, 6:41:19 AM, Carlos J Souza <[EMAI

reg MySQL C API Prepared statements

Hi! MySQL C API Prepareed statements routines; mysql_prepare, mysql_bind_param, mysql_fetch, mysql_execute are present in *libmysql.lib* file - right... I have currently used MySQL 4.0.17-max I want to clarify that starting from which version, MySQL provides this? t

Re: Version 4.1.2. when?

Mirza <[EMAIL PROTECTED]> wrote: > Is there any info on when 4.1.2. is scheduled for relase? I am stucked > in 4.1.1. with fulltext problem (bug #2490). > Binaries of 4.1.2 will be available in a month. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is

Re: WHERE NOT EXISTS

Hello Carl. You are using mysql version 4+ ? Gesundheit, Rudi Dorn Fa. AllesKunst.net I.D. GesmbH A - 1020 Wien Zirkusgasse 39/37 Tel.: 0699 - 10 242 880 Die Firma: http://www.alleskunst.at Das Projekt: http://www.alleskunst.net ---

Re: Multiple mysql on same linux Box.

Hai 1. To use another conf file Use this option "--defaults-file=#" to refer the default values from the file other than /etc/my.cnf file. In t eg: # mysql --defaults-file=/opt/mysql/share/my.cnf 2. To change the data dir Do the following changes to change the "data dir" ot

WHERE NOT EXISTS

I use php 4.1.1. mysql 3.23.49 and phpmyadmin 2.5.4 I have two tables classes - class_id (int) - class_name (text) HS HD DD DS MD champions - champions_id (int) - year (text) - class_name (text) - winner (text) --

Last record

Hi: How Can I do for after a query I put at the its last record? Thanks in advance -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Problem with UTF-8 in 4.1.1a

> So, am I doing anything wrong or there’s a problem with MySQL itself? I'am not sure but I had a bug like that. You use Explore when you insert data in db? Exlorer use UTF-16 when send data. Mozilla use UTF-8. try change Browser. I have solved with this line in my jsp: request.setCharacterEncodi

Stored procedures

Hi, I'm testing stored procedure on MySQL5.0.My question is can I change the definition of a procedure body using ALTER PROCEDURE?(Not the characteristics). I'm not sure if it is implemented! TIA, Ram -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscrib

Problem with UTF-8 in 4.1.1a

Note: to see this script correctly, please set your encoding to UTF-8. Hi I'm trying to use the new capabilities of the MySQL 4.1.1a, which is supporting of Unicode. I prefer to use UTF-8 instead of UCS-2 since I'm working on web and for web UTF-8 is much more suitable. Before asking my current

Version 4.1.2. when?

Is there any info on when 4.1.2. is scheduled for relase? I am stucked in 4.1.1. with fulltext problem (bug #2490). Thanks for info, mirza -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Remote Access with Linux

Hello ALL, I have a Linux Debian server and need access remotely Mysql Server from other windows client. When i try to connect mysql server via internet, one error occurs that as follows: Error no. 2003 - can´t connect to mysql server on 200.153.25.58 ( 10061). My Username and Password are corre

Re: Stability of MyISAM-Ststis vs. Dynamic - (was: Automatic conversion from `char` TO `varchar`)

Hi, If all your fields have a fixed length, you can change the type of the table by doing : ALTER TABLE your_table ROW_FORMAT=fixed; Regards, Jocelyn - Original Message - From: "Merten Christian" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, Februar

Re: primary key - user entered/auto increment

David Johnston <[EMAIL PROTECTED]> wrote: > I am starting to design a database in sql, to replace a flat file db. > > The database holds records, currenlty there is a new database for each > record, so each record for each project starts with a id and increments. > > I want to create a sql datab

primary key - user entered/auto increment

I am starting to design a database in sql, to replace a flat file db. The database holds records, currenlty there is a new database for each record, so each record for each project starts with a id and increments. I want to create a sql database that will hold all records for all projects, so I

Re: Insert with multiple value lists

Duncan Hill <[EMAIL PROTECTED]> wrote: > While reading the manual the other day, I noticed that MySQL supports a syntax > of INSERT INTO table VALUES (x),(y),(z). Very handy, and nice and fast. > However, when this syntax was tested on an AS/400 and an Ingres installation, > it doesn't work.

Re: New Timestamp format woes

DALive Editor <[EMAIL PROTECTED]> wrote: > > I just upgraded my MySQL to distribution version 4.0.17 up from 4.0.15 > (i think). I read in the readme file i think it was that the mechanics > or output of the timestamp column had changed. I had grown to like that > column type. What's the best w

Stability of MyISAM-Ststis vs. Dynamic - (was: Automatic conversion from `char` TO `varchar`)

As to the discussion about char vs. varchar fields, I am now into a problem which is near by the above one: We are about to design a new database with high importance to stability and crash recovery. So I found, that two types of MyISAM tables exist (static and dynamic). If you have only fixed len

Multiple mysql on same linux Box.

Hello, I have installed multiple mysql servers on the same box running Redhat linux 9.0. one through mysql RPM (version 3.2.54a) and other through source (version 3.2.58). The RPM installation has default configuration (like /etc/my.cnf, /var/lib/mysql etc etc). The second source installation has

problem connecting with PHP

Hello, I've recently upgraded from 3.23 to 4.0.16. Before upgrading my PHP scripts connecting to mysql server from another machine (not from localhost) were doing just fine. But, since upgrading, I get tihs warnings: Warning: Lost connection to MySQL server during query in /home/users2/nick/publ

RE: is it possible...

Boy do I feel dumb. :^) -Original Message- From: Chris [mailto:[EMAIL PROTECTED] Sent: Monday, February 09, 2004 4:54 PM To: [EMAIL PROTECTED] Subject: RE: is it possible... UPDATE EMAIL_TEST_LIST SET EMAIL_DATE = curdate(); -Original Message- From: Ligaya Turmelle [mailto:[EMA