MySQL Database Forum

Hello, I am trying to filter an array that I am pulling from a mySQL database using PHP. My question is if there is a way to LIMIT the number of rows that are pulled from the database with a mathematical operation in the SQL statement. I think it would something like: $sql = sprintf(SELECT * FROM data WHERE day = CURdate()-INTERVAL 1...

Current Sybase SQL Query (Referance = http://manuals.sybase.com/onlinebooks/group-asarc/srg1100e/sqlref/) SELECT requisition.reqn requisition.pn requisition.ord_time status.status status.status_time requisition.del_time

Hi, I installed "mysql-connector-net-5.2.3" and "mysql-gui-tools-5.0-r12-win32". The install seems ok. When I start the "Administrator" or "Query Browser", the login asks for connection/user/password values. I don't know what these should be because the installation procedure didn't ask me for an user/password to begin with. I have tried...

Hi my question is that what is the difference between mysql and mysql enterprise edition our client has demanded the if we will use mysql enterprise edition because in future he wanted to shift the db to oracle and the stored procedures in the mysql enterprise would be working as is for oracle too now what should i recommend to them , does...

Hi! I would like to insert the date in specified format in DB, the date type is Date Type, I am using the following queries to insert the data 1) INSERT INTO EMP VALUES (1, 'red', 'CLERK', 2, date(date_format('17-DEC-1980', '%d-%b-%Y')), 800, NULL, 20) 2)INSERT INTO EMP VALUES (1, 'red', 'CLERK', 2,

Hi this my second request at bytes, i am having a db with two tables, table1 - has the details of student, stud_id as primary key set to auto increment, stud_name and other details table2 - has the details of courses applied by each individual students, stud_id as foreign key and course_id as primary key any help, i will be very...

This is an SQL algorithm developed by Joe Celko. Has anyone converted the following SQL to vba? ***************************************** To convert an adjacency list model into a nested set model, use a push down stack algorithm. Assume that we have these tables: -- Tree holds the adjacency model CREATE TABLE Tree

is it possible to run xampp on windows 2007?actuly i hv created data base on xp but now i m using 2007 n itried .......its not working

can u help me to get below example table field status holds Integer, Status 0 1 I need to display in runtime like Status User

Hi all, I have created a small Bank form GUI in gtk. I want to store the information in the database. Values(string) are present in variable say entry1. e.g. entry1="Amit" how can i insert string present in entry1 into table. I have tried different syntax's like

I have two tables which have a field, let's call it FORM_TYPE, in which table 1's FORM_TYPE is LA-- and table 2's FORM_TYPE is LA---. Now I want to use a Where clause of Table1.FORM_TYPE = Table2.FROM_TYPE which always fails because of the extra -. I can't go change the database to make them the same. I was trying to use Where...

Have a table that needs to have results written to it, that will later be updated. To check if the table has been written to yet I'm using this code: $sql="SELECT DISTINCT field FROM table WHERE field=".$value; $new_result=mysql_query($sql,$db); if (!$new_result) { do xyz } When I do this it doesn't enter the...

Hi I have 1 textbox and 3 drop down menus. textbox is to pick a topic_head and the other dropdown lists are to select dept_name,category name and sub actegory name from different tables into single topics table. The user selects any of these fields then hits submit he should list all entries in the table. How would I formulate the...

how can I convert from nafitha DBF to SQL

Hi, I have a list of tables in a Netezza database and I want to get the name of primary key for each of the tables. Can anyone provide me the query.

I have run 2 queries in Access which has the same field names, Qry1: Mgr ID Mgr Name Qry2: Mgr ID Mgr Name

Hi to all, I am doing a project in that the user log in and downloads the different files. every thing is working perfect but problem is...In admin area the all the details are storing in DB, I have kept separate table for that... where the columns are id-> primary key uid-> user id docid-> document id status-> how many times user...

Hi all, After a long time i am back with a new problem. Right now I am having a problem with stored procedure. I am using stored procedure with PHP/MYSQL. And evry time I am changing the condition of query in stored procedure. when I am passing numeric value then its working fine but when I am passing varchar or text in parameter then it ia...

table weather (date, temphi, templo). Looks like this: 2010-7-24, 83, 57 2010-7-25, 94, 60 2010-7-26, 98, 58 2010-7-27, 93, 61 2010-7-28, 87, 59 Statement is:

hi, i have posted this question here, regarding Access SQL i believe someone here is good in SQL. anyone can help me? http://bytes.com/topic/visual-basic/answers/894647-access-vba-how-create-crosstab-table-using-two-queries#post3602456 thanks in advance.

Hi, I'm using the following command to backup all databases creation only: mysqldump -u username --password=password --host=host --port=port --all-databases --no-data > D:\all_databases_creation.sql and I'd like to exclude specific database from those all databases. Is there any option like --ignore-table but to ignore database ? can I...

Brothers in the house. I plan developing an online database application with PHP and MYSQL. In my database design structure, I plan to have maximum of 50 columns and maximum of 20,000 rows in a certain table. But then I will to like have the experience of the members in the house. What exactly is the maximum number of rows and columns in a...

Recently I downloaded the latest version of MySQL for 32-bit, installed it. No errors installing it. When I go to run it though, all it does is flash a DOS-like window for a fraction of a second and that's it. Okay, here is what I am doing and the operating system info... I am running XP Home Addition with SP3. In the windows explorer, i...

Hi i have the following SQL tables: prefix_bookings: +---------+------------+-----------------+-------------+---------------+ | book_id | book_place | book_customerid | book_adults | book_children | +---------+------------+-----------------+-------------+---------------+ | 3 | 1 | 1 | 2 | 2 ...

Hi, I'm trying to send an email to' sample@sample.com' when a new row on my table contactform_con is inserted. Basically, when a person fills out the contact form (contactform_con) I want one email to go to one person to let them know. I've tried doing this using both navicat and PHPMyAdmin, but I've had no success. I've tried using...