MySQL Database Forum

Hello Everybody, glad I found you all here. I desprately want to understand PHP and MYSQL in relation to develope web sites. I'm sick and tired of build static pages. Brief reading PHP and MYSQL its sounds sexy. This is my situation: I'm comfortable with HTML and CSS, I'm not really understanding the logic of javascript but I can use it...

I am trying to setup MySql 4.0.2.6 according to my school book "PHP fast&easy web development" on a WinXP Professional SP2 system. Everytime I try to create a database this message below comes up. If you can please give me any assistance, I would greatly appreciate it. mysqladmin: CREATE DATABASE failed; error: 'Access denied for user:...

I just installed MySQL and phpMyAdmin in Yahoo! webhosting but when I try to create a table I get the error message: #1044-Access denied for user ****@localhost to _DBNAME_. I am sure I have a database persmission problem that doesn't allow me to do basically anything but I don't know how go fix it. I also notice that the error message says...

I have the following script that use for the following after i have made my search for a name in my database. I select the name and it bring up this from with all the information of the person. It works great up to the point of the date entries. It will bring up the fromat date ok, but when I try and change it and head the submit buton it wipes...

When adding a new record in my forum, if the new thread is the parent thread, the Parent_Ancestor takes on the record ID (field called Forum). For some reason, new threads are not inheriting the record ID, but always receive the number 65535 in its place. When I try to update a field in a record through PHPMyAdmin, the query executes, but...

Dear Everyone, I have a small but hopefully simple problem. Please forgive my misuse of technical terminology but I am hoping someone can provide some advise. We have a database of nearly 1.6 million UK business address (MYSQL) all with post codes (zip codes). Post codes can have either 6 or 7 digits, for example: RG28PL or TR129BM (noptice...

Dear all, I am very new in MySQL, I am working on image database project for my research and I have problem how to convert blob field into float in MySQL so that I can calculate the blob field with the MATH operation. Does any one how to do it ???? Thank you very much indeed , for your help.

I have a field that contains an underscore. How can I do a query for the underscore since I just found that underscore really doesn't find underscore it is a wildcard in mysql. I need to be able to query for the actual underscore. For example. Select Title where Title LIKE '10_%' doesn't give me what I want. Results 10_1 100_2

hi i`m quite new in mysql programming.i have a problem: when i try to insert a row in a table i get an error 'Duplicate entry '' for key 1' what does that mean? my indexes are unique and i don`t think they have any problem . would you please tell me where`s my error here is the troublesome line: $query="INSERT INTO personalinfo (...

I have MySQL 5.0 on my W2K network. It has always worked fine. For some unknown reason, this morning one of my applications that uses the database, gave the following error message: Warning: mysql_connect(): Can't connect to MySQL server on 'localhost' (10061) ... The Windows Event Viewer tells me: Default storage engine (InnoDB) is not...

HI, i have a set of tables reffering to various aspects of a nigh-life listings system. I have tables named gigs and venues. Each gig has a venue. So when displaying the data on the site people might search for a specific gig and then see what venue it is heled at and want to see what other gigs are heled there. Pretty simple.

When I execute the command "show create view" while logged in as root I get this error: "select command denied to user 'root'@'%' for column (a table that from which the view draws part of its data)" I can select the data from the column using the standard select syntax. I can also get the data from the view itself by running it using the...

I would like to ask , if I can restrict a user from a single table. I want him to be able to create,alter,delete all the tables but one, which I want him not to delete it, not to update it not to create it.Just to use it. Can I do it? As long as I have read there is only the way to give credentials for all the objects of the database.

Having just upgraded to from Suse 10.0 to 10.1 mysql-administrator will not work. When I try to acccess it I get the following message. linux:/home/grabro # mysql-administrator /usr/bin/mysql-administrator-bin: Symbol `_ZTIN4Glib9InterfaceE' has different size in shared object, consider re-linking /usr/bin/mysql-administrator-bin: Symbol...

I have simple text entered into a MySQL database (with the DB field type set as 'text'). This text contains regular carriage returns which form paragraphs and the resultant gaps in between section of text. My problem is when I do a query from a web browser and display the text, all the Carriage returns are stripped and I'm left with one giant...

Hi wizards, I have multiple MySQL databases on one server. I would like to be able to automatically syncronize tables A, B from database 1 to database2 , somebody knows how to do that? . Thanks in advance.

Let's say I have a query that will return a collection of rows with a datetime field: SELECT User,Activity,Timestamp FROM `table` WHERE Activity = 'TEST' Which returns 'Steve','TEST','2006-01-01 12:00:00' .... etc... So the query tells us who and when did activity "TEST."

Can the "WHERE" component of a query have the equivilants of brackets to seperate AND & OR conditions. eg: WHERE letter_id = "1", AND letter_author = "fred", AND (authors_city = "london" OR authors_city = "new york"),

Hi, i've installed OCS Inventory NG for inventory and it has installed Mysql ver: mysql Ver 14.12 Distrib 5.0.18, for Win32 now i have to make a dump for save database but don't forget the root password. I've try to reset password with resetpassword.bat and also with this

I am in need of assistance. The particular table that I am working with is set up such that for each type of entry in a given code field, the individual would have data on distinct rows. For example: ID Code Amount --------------------------------- 132 BELL 432 132 GETA 111 132 HUTR 854

I'm new to this forum and was interested in finding a pretty comprehensive list of operators used in searching databases. I've been working with Siebel for a while, but haven't ever seen any documentation with any of the different companies as to all the queries that work within the application. It does use an SQL db engine I believe, but I...

My understand is that MYSQL only supports indexes on the beginning of a string of data. for example, if you have a list of email addresses, searching for something like '%@yahoo.com' would need to do a full table scan. why doesn't mysql offer a feature where it indexes by the END of the string, so we can do these types of searches...

I have the following query: SELECT a.address1, a.address2, a.address3, a.address4, a.name, a.id id, c.description, c.id category_id, c.name cat_name, MATCH (keywords)AGAINST ('".$search_keywords." ".$search_city."' IN BOOLEAN MODE) AS score FROM (sites a left join site_keywords b on b.site_id = a.id) left join site_categories c on...

not sure of this should go here or in the access post i'm linking to mysql backend from access and if you try to create a new record without a timestamp column you get #deleted showing in the fields even though the record updates while adding a timestamp column fixes the problem my question is: why does this fix the problem ? or perhaps...

Hi, Heres a little test sp, I can't get it to use the @H variable in the select , what am i doing wrong?, been messing for days now :( The row caount always comes back as 0 , but if I just change the line "SELECT count(*) INTO s from test where url=@'H';" to use url='tony' for example or any other value it works as expected.