MySQL Database Forum

The following query (modified from original to make it easier for you to read) select all of the clients whose fisrt initial of their last name equals a specified character ($lastInitial). It works fine for characters A-Z but I need to know what to set $lastInitial to for it to select clients last names that start with a different character...

what is the function to check whether a date, eg 2005-02-44, exists? in php, there is a checkdate() function.

Greetings for a while I simply can not import properly timestamp data back to database. I dump all databases with mysqldump --opt --all-databases > backup.sql and backup file is correctly created. All my tables have timestamp column since VB programs and MyODBC do not work properly without it. When I import data back, every timestamp column...

The database was not designed by me. I am just the guy to follow up. I just pick up the task for 4 days. It is quite hard. The web site consists of PHP and js files. I do not know the version of PHP is running. I am new to PHP. It crashes with message like 1. error in sec index entry update in ...

Is there a simple front-end that would let me select records from multiple related tables and edit their field data? Right now, I am opening each table individually in mysql control center, entering the new record, or editing the existing one, then moving on to the next table. I know there’s got to be something better, and I am to busy...

I am using Access 2K as a front end to a MYSQL database. I am trying to run a Union query on a MYSQL database. The query is SELECT as ID from faxdata UNION SELECT as ID from letdata UNION SELECT as ID FROM MEMODATA; I get an ODBC error. The same query runs when the backend files are MDB files and it runs with MYSQL if I only combine...

----04-91951-3807-519-03855 Content-Type: text/plain; Content-Transfer-Encoding: 7Bit Why pay more when you can enjoy the best and cheapest pills online? Nearly 80 types to choose which makes ours pharmacy the largest and the best available. No Appointments. No Waiting Rooms. No Prior Prescription Required.

I have a table over 400,000,000 rows. It has primary key composed of 10 fields. The database runs on MySql 3.23.68 Redhat 7.3 It is very slow, even SELECT COUNT(*) It crashes nearly once week.

I'm logging mail to a database, and using php to make queries. The mail is coming in constantly, so the table is being added to, in batches of up to 30 mails. I have around 600k records. The queries are properly indexed, i think; i have index on date and domain, the fields I query on. Mostly the queries run quite fast, but sometimes the...

How do I change a MYSQL Fulltext relevance value to: 0 to 100%. I'm just thinking about usability for the "average" user - maybe they would like to know...and would not understand the raw value. Any snips, ideas or links appreciated. Thanks

Hi, For my final project,I must do cafeteria systems with mysql backend database. This is my system. Student will have $10 and will deduct for breakfast,lunch and dinner.If they eat breakfast $2,so the money will become $8.At the end of the day,they will have $0.

I am using the following code in Access 2k to establich a connection to a MYSQL database Dim conn As ADODB.Connection Set conn = New ADODB.Connection conn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};DESC=;USER=" & myUsername_ & ";DATABASE=" & mySQLDatabase_

I have columns called repeat_date and repeat_month and I would like to use the info within them in my WHERE clause as part of a UNIX_TIMESTAMP(). Essentially, I would like to say something like: SELECT * FROM table WHERE UNIX_TIMESTAMP(repeat_date-repeat_month-$curYear 0:00:00) > $date_start AND...

We have mysql running on a Linux server now, but an exercise we are running are causing this machine to bog down. We'd like to just shut down the server on this machine and start it up on another using the same database. The setup between the two machines (both Linux RedHat) are essentially the same. The database is on a separate file server....

can anybody assist me with the following procedure? it can compile and works when i do any of the following: CALL ACTIVATE_ACCOUNT('') CALL ACTIVATE_ACCOUNT('123') but when i do a CALL ACTIVATE_ACCOUNT('0394df......') <-- forty alnum chars long, the

Hi all I am running Red Hat and MySQL, I am needing to make it that mysql logs all queries done on the server, at the moment my /etc/my.cnf file looks like this. datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock

Hello, I try this sql, but it don't work :( Have you a solution ? ---------------------------------------------------------------------- SELECT galleries.id_gallerie as lid , ( SELECT

I have a country table with code and name columns and create a stored procedure 'get_countries()' but have no idea what is the syntax to return multiple rows. I have searched the newsgroups and understand that the solution is to use cursors. Searching for the mySQL solution is to no avail. Do assist me with the syntaxt.

Hello, I try to develop a query to match wildcards following the LIKE guidline in the MySQL manual (http://dev.mysql.com/doc/mysql/en/pattern-matching.html) Who can help me solve the matching problem? The string I am looking for consists of 2 charachters a capital B folowed by one digit not neccesarilly at the beginning of the record....

Upgrade your P.C W1ndOws X*P PrO 2oo2 .............. 5O D0|lars Off1ce X'P Pro 2O02 ................. 6O D0LLars DO yOu want th!s stuff: http://bone.allthexpsoft.info/ We Als0 Have: -COre| Draw Graphics Suite 11 -Off1ce 2oOO

Hi there, SUMMARY: 1) When I use phpadmin to export a large database, the file created on my local PC never containes all the tables and information. It seems to max out at about 10mb. 2) Will running mysqldump from command line on a live in-use DB (with one table containing 350,000 rows) pose any risks and have any large effect of...

I started the mysql database with the "safe_mysqld" command and with the user who own mysql. in the errr-log file, I have that: 050123 23:16:50 mysqld started Warning: One can only use the --user switch if running as root /exlibris/sfx_ver/sfx_version_2/app/mysql/libexec/mysqld: ready for connections

Great that worked! I would also like to only provide a date in the where clause and not a timestamp (the field is of type datetime). I have tried using the date function but it does not appear to work. I tested the date function as per mysql manual(http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html) but I get the following...

Hi everyone, Sorry to fill up this newsgroup with this request, but for coursework at Erasmus University (the Netherlands) I need to conduct a survey regarding the use of certain open source projects and I'm therefore looking for some volunteers to participate in this survey. The survey is located at:...

is there a '@@rowcount', '@@error' equivalent in mysql to use inside a stored procedure after a query statement?