MySQL Database Forum

How to do paging in mysql store procedure?? input paramter will be (in pageno INT, IN no_records) result will be for example i pass value 1 and 10 : first 10 records it will show. or 2 and 10 then it will show 11 to 20 records.. please help..

I want to count size of all rows in mysql table? is it possible? how?

Hi Guys, I am using Java in Eclipse to create tables in a MySQL Database. Everything has been working fine until it inexplicably stopped working the other day. My code runs but nothing happens to the database due to an error when I try to initialise the connection. The code actually runs to the end, the error is only viewable when I step...

I have functions saved under proc. I am using MySQL Workbench. I just tried to alter a function which resulted in an error (something about it being unsafe and binary logging); however, when I clicked "Apply", it dropped my function... and then as I was searching for the relevant option setting, Workbench crashed! What's the easiest way to...

Dear All, I have a strange problem. I have a Synology NAS server with SQL databases. When connecting from my client workstation with mysql workbench 6.2 CE it all works perfect and could access the database. Sometimes I have to execute flush-hosts but then again access granted. User previleges on database set '%'. Also telnet 3306 works fine...

I get these error each time I write the syntax in quotes. Please can someone help me? ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'book( saleID int not null,isbn varchar(20) not null,quantity int not null,salePri' at line 1

Hello Bytes Community, I am not programmer at all. I run a free forum as a hobby for organised racing and I'm just managing with HTML and CSS right now. I've been doing this since January, never touched a line of HTML really until then but I'm enjoying learning as I go. So... this post is just a different method I'm trying, to see if I can...

I have a StudentsTable which has 3 fields to describe which class a student belongs to. The first is session, in the db it is stored as 1 or 2. afternoon,morning (values 1, 2) Language, also stored as 1, 2. English, Chinese (values 1, 2) Class number which has values K1,K2,3,4,G...etc. This list is long and changes from time to time.

How can a read only MYISAM table become corrupt? I have to do a myisamchk -r approx. once a week as the table gets marked as crashed. I can't see how this is happening though as no changes are being made to it, it's read only. It's running on mysqld-nt version 5.0.51b, the same table running on a mac and a linux box have not done this, so...

I'm trying to get a web page working so that visitors to the website can leave reviews of the business, or read reviews others have left. But I'm having trouble getting it working on the production server, even though it worked in development. Here's the code I'm using to inert the reviews into the database; <?php $dbc =...

Please help me to fetch data from table B to table A: Its my input form coding(insertdata.php): <?php include ( 'header.html'); include ('selectdriver.php'); include ('selectdestination.php'); include ('selectloading.php'); ?>

Hi Experts, I encountered the following problem when I'm trying to open SOME tables in MySQL database: "Incorrect information in file .//.frm" Other tables within the same database can be opened without any issues, only some tables have this problem. And this is not just happening in one database, but the other database on the same server...

hi, I managed to export whole table using following code. Now I want to export data to excel using from and to date or using any date picker. <?php //include 'connectdb.php'; mysql_connect("localhost", "root", "123") or die(mysql_error()); mysql_select_db("nadaehsan") or die(mysql_error());

Table1 fields and datas : (itemcode,itemdesc) (101, aaa) (102, bbb) (103, ccc) (104, eee) (105, fff) (106, ggg) (107, hhh) Table2 fields and datas : (itemcode, finperiod, finyear)

i have encrypted admin passwords in mysql, now i want to make the login page work. but my code seems to be failing to login. please help: here is my .php file to connect and make validation: mysql_connect($host,$user,$pass); mysql_select_db($db); if (isset($_POST) || ($_POST)) {

Hi i got this error help Error: Error creating database: Access denied for user ''@'localhost' to database 'mydb' The code is: <html> <body>

How can I change the below oracle sql code so that: The current enrollment of an offering must be less than the maximum enrollment. CREATE TABLE COURSES (COURSE VARCHAR(6), DESCRIPTION VARCHAR(60), CREDITS INT, CONSTRAINT pk PRIMARY KEY (COURSE));

I have table items | iid | iname | quantity | did | price_kg | | 1 | rice | 40 | d2 | 2 | | 2 | sugar | 20 | d2 | 16 | | 3 | dall | 30 | d1 | 20 | | 3 | dall | 30 | d3 | 20 | | 3 | dall | 30 | d2 | 20 | I have another table soldtable | iid | pid |...

I have 2 tables, items and sold . In items table I have itemid , item name , quantity and in sold table I have itemid , peopleid, itemname , soldquantity. I want the output as itemid, itemname,remquantity(quantity-soldquantity) and where will the final output will store?

<html> <body> <table border="0" color="red" > <tr><th> <form method="POST" action="frame1.php" name="form1"> <input type="textbox" name="did" value="enter dealer ID"> <input type="submit" name="submit" value="show dealer"> </form> </th> <th>

Command: phpunit -c app is not working under Symfony, Bitnami WAMP, Windows 7. I changed compose.json file in symfony project; C:\Bitnami\wampstack-5.4.38-0\sym_prog\myproject\composer.json .... "require-dev": { "sensio/generator-bundle": "~2.3" "phpunit/phpunit":"4.5.*"

Hi All, I tried lots ways to solve my problem.But i am not getting my required output. I am explaining my requirement in detail below. I have two tables in my database.From those two tables i want to get the entire data(all rows) of first table with join condition. Along with that i am using where condition to get the maximum value...

I sit already 2h browsing internet and i am not able to find a solution. Could you please help me. Bitnami WAMP, Symfony 1) I am not able to login to MYSQL through console using command: mysql -u root -p using command: mysql -h localhost -u root -p using command: mysql -h localhost -u root -p -P 3006 using command: mysql -h 127.0.0.1 -u...

Hey folks, I'm curious about how to perform following task: I need to update a MySQL database every day in terms of deleting expired entries.Therefore, I have to fields in the db named 'date' and 'expired' (which is the actual date ... How do I get that again?). So, I want to run a script that compares both fields and deletes respective...

i am using one database in mysql in which it is having a record of source IP(sip), destination IP(dip), source port(sport), destination Port(dport). when doing select query (select count(sport) as port, sport from IPtable limit 20); the result is as this query states means port sport 3 | 80 5 | 8080 15 | 21 3 | 20 25 | 443 16 | 1234 49 |...