HeidiSQL User Forum

Feature discussion :: RE: inserting sequential records into a table.

Jacques — Wed, 03 Dec 2008 23:55:27 GMT

Author: Jacques
Posted: Thursday, 2008 December 4 - 1:55 (GMT 2)

Thankyou Simkin,
that looks very promising but the `tag` also has to be sequentially incremented and could start with any number.
initially I got the error "tag 2001 already exists" because tags must be unique.

So I found the procedure in mysql.proc and deleted it.
then did the following:

Code:

CREATE PROCEDURE seqInsert (i INT)
BEGIN DECLARE count INT DEFAULT 1;
WHILE count <= i DO
INSERT INTO tag_virtual (tag, parent, descriptor, priority, role) VALUES ((2000 + count), '0', CONCAT('Announcement ', count), '127', 'Announcement');
SET count = count + 1; END WHILE; END;

and now when I do

Code:

CALL seqinsert(10);

I get

Quote:

/* SQL Error: FUNCTION siteconfigDB.CONCAT does not exist */

Which I didn't get the first time. Odd.
I think I broke something

regards
Robert

General :: Why can't I update directly from the results table anymore?

Evillen — Wed, 03 Dec 2008 18:29:09 GMT

Author: Evillen
Subject: Why can't I update directly from the results table anymore?
Posted: Wednesday, 2008 December 3 - 20:29 (GMT 2)

Hi

I previously used rev.1587 & earlier of HeidiSQL but have recently been using rev.1832. Many of the changes are great - however one apparent change seems entirely retrograde to me:

Previously I could run a query and the results would be displayed below my query in the results table. Then if I wanted to update some data from a record within my results I could just select the field, edit and then down-arrow - voila the appropriate SQL Update query was run (& could be copied from the transcript log too).

It appears that this easy means of updating selected records has been removed?

Is there some checkbox hidden away somewhere that I need to configure?

Please help - I don't like to use the older version, but if I lose this MOST useful feature I will have to.

Regards
Len

Feature discussion :: Buy cheap Nizoral online

sedarftoned — Wed, 03 Dec 2008 18:17:37 GMT

Author: sedarftoned
Subject: Buy cheap Nizoral online
Posted: Wednesday, 2008 December 3 - 20:17 (GMT 2)

Buy cheap Nizoral online without prescription - Professional Shopping

Quote:

Fast worldwide shipping! No prescription needed! High quality! Discount system!

Buy cheap Nizoral online - Order Nizoral WITHOUT PRESCRIPTION - HERE

Quote:

Buy cheap Nizoral online - Order Nizoral WITHOUT PRESCRIPTION - HERE

Quote:

buy cheap Nizoral
buy Nizoral cheap
buy 500 mg Nizoral
buy cheap Nizoral free fedex
buy Nizoral online with paypal
buy Nizoral in the uk
buy Nizoral online with a debit card
where to buy Nizoral
buy Nizoral without a prescription
buy Nizoral cod
buy cheap Nizoral online
buy Nizoral c.o.d.
buy Nizoral diet pill
buy Nizoral online.com
buy cheap diet Nizoral pill
buy Nizoral diet pills
where buy Nizoral
buy Nizoral uk
buy Nizoral online without prescription
Nizoral buy Nizoral
buy Nizoral in mo
where can i buy Nizoral
buy in Nizoral uk
order buy Nizoral online
buy Nizoral fed ex
buy Nizoral with mastercard
buy pharmacy Nizoral waterview
buy cod Nizoral
buy Nizoral online cheap
buy Nizoral pills
Nizoral buy online in stock
buy cheap Nizoral with dr. prescription
buy cheap Nizoral online free consult
Nizoral to buy
buy Nizoral online no prescription
buy Nizoral no rx
Nizoral buy online
buy Nizoral epharmacist
buy Nizoral where
buy Nizoral c.o.d
buy Nizoral without perscription
buy Nizoral with no prescription
buy Nizoral free consultation
buy Nizoral without a credit card
buy Nizoral no prescriptions
where can i buy Nizoral online
buy Nizoral .
where to buy Nizoral online
"buy Nizoral online"
buy Nizoral online no
buy Nizoral pay cod
buy Nizoral shipped cod
buy Nizoral online no rx
where can i buy herbal Nizoral
Nizoral buy on line
Nizoral online buy
best buy Nizoral
buy cheap Nizoral under without rx
buy Nizoral with out prescription
where to buy Nizoral without a prescription
where can i buy Nizoral online without a prescription
Nizoral +buy +online +cod
Nizoral searchers.com q buy Nizoral on line said make
where can i buy Nizoral without prescription
Nizoral buy cod
buy Nizoral without rx
buy Nizoral . no prescription
nizoral
nizoral buy
nizoral canada
nizoral no prescription
nizoral online
nizoral prices
nizoral purchase
nizoral sale
nizoral suppliers
nizoral tablets
nizoral toronto
nizoral uk
nizoral uk sales
nizoral vancouver
buy nizoral
buy nizoral online
buy cheap nizoral
canada nizoral
cheap nizoral
no rx nizoral
online nizoral
order nizoral
order nizoral online
purchase nizoral
purchase nizoral online
uk nizoral
il nizoral
nizoral vendita
acquisto nizoral
nizoral senza ricetta
nizoral prezzo
nizoral prezzi
nizoral posologia
comprar el nizoral generico
nizoral generico
el nizoral generico
costo nizoral
vendo nizoral
vendita nizoral
prezzo nizoral
compra nizoral
nizoral espana
comprar nizoral
venta de nizoral
que es nizoral
nizoral comprar
precio nizoral
venta nizoral
kopa nizoral
nizoral kopa
nizoral kop
nizoral sverige
nizoral pa natet
bestalla nizoral
acheter nizoral
le nizoral
achat nizoral
vente nizoral
nizoral prix
acheter du nizoral
nizoral kaufen
nizoral bestellen
nizoral apotheke
nizoral preis
medikament nizoral
rezeptfrei nizoral
nizoral rezept
nizoral tabletten
buy Nizoral cash on delivery
buy cheapest Nizoral
how to buy Nizoral without a prescription
buy Nizoral online us pharmacy
buy discount Nizoral
where can i buy fda approved Nizoral cod
buy Nizoral without doctor
Nizoral best buy
buy Nizoral no perscription
Nizoral no prescription to buy
buy Nizoral without a rx
buy Nizoral doctor prescription
do you know how i can buy Nizoral
cheapest place to buy Nizoral
buy cheap Nizoral no prescription
want to buy Nizoral in malaysia
buy Nizoral cheap without prescription
buy Nizoral without a perscription
buy cheap Nizoral without prescription
where to buy online cheap Nizoral that ships to kentucky
where to buy Nizoral by cod
Nizoral
generic Nizoral
Nizoral online
order Nizoral online
buy Nizoral in england
buy Nizoral c o d
buy cheap Nizoral no perscription
ultracet Nizoral hydrocodone Nizoral pain relief cheap
order Nizoral
cheap Nizoral
Nizoral diazepam
Nizoral on line
online pharmacy Nizoral
Nizoral no prescription
purchase Nizoral
online Nizoral
Nizoral side effects
Nizoral without a prescription
prescription Nizoral
discount Nizoral
drug Nizoral
about Nizoral
cheap generic Nizoral
what is Nizoral
buy generic Nizoral
Nizoral dosage
Nizoral overdose
Nizoral addiction
Nizoral withdrawal
dj Nizoral
Nizoral without prescription
buy generic Nizoral online
generic Nizoral online
Nizoral 20buy
how long does Nizoral stay in your system
diazepam Nizoral
Nizoral pictures
Nizoral effects
sobredosis de Nizoral
what does Nizoral look like
Nizoral 10mg
buying Nizoral
snorting Nizoral
wholesale Nizoral cheap
side effects of Nizoral
purchase Nizoral online
Nizoral for sale
Nizoral from india
online prescription Nizoral
Nizoral versus Nizoral
Nizoral more drug uses
Nizoral cash on delivery
Nizoral uk
Nizoral overnight
by Nizoral
online pharmacies Nizoral
Nizoral pharmacy
Nizoral pills
picture of Nizoral mylan 40 milligram
no prescription Nizoral
Nizoral prescription
effects of Nizoral
buying Nizoral online
Nizoral pill
Nizoral 20online
roche Nizoral
que son la ritalina, Nizoral
Nizoral without rx
Nizoral withdrawal symptoms
Nizoral 10
natural Nizoral
Nizoral cheap mexican
Nizoral 10 mg
pharmacy Nizoral
drug test Nizoral
Nizoral oral
buy Nizoral drugs
Nizoral price
Nizoral drug
is Nizoral addictive
Nizoral 20mg
Nizoral vs Nizoral
Nizoral more drug side effects
Nizoral drug test
Nizoral vs. Nizoral
picture of Nizoral
Nizoral generic
doctors in kansas city area who will prescribe Nizoral
pharmacy rx magic Nizoral
Buy Cheap Nizoral Online. Order Nizoral Online. Nizoral No Prescription.

Feature discussion :: RE: inserting sequential records into a table.

siMKin — Wed, 03 Dec 2008 10:27:59 GMT

Author: siMKin
Posted: Wednesday, 2008 December 3 - 12:27 (GMT 2)

This is how you could do it:

First, you create a stored procedure:

Code:

delimiter //

CREATE PROCEDURE seqInsert (i INT)
BEGIN
DECLARE count INT DEFAULT 1;

WHILE count <= i DO
INSERT INTO tag_virtual (tag, parent, descriptor, priority, role) VALUES ('2001', '0', CONCAT('Announcement ', count), '127', 'Announcement');
SET count = count + 1;
END WHILE;
END;

delimiter ;

And then you can do this at any time:

Code:

CALL seqinsert(10);

Creating a connection :: www.shoes258.com wholesale newest nike shoes,adidas,hoodys,

shoes258 — Tue, 02 Dec 2008 14:38:31 GMT

Author: shoes258
Subject: www.shoes258.com wholesale newest nike shoes,adidas,hoodys,
Posted: Tuesday, 2008 December 2 - 16:38 (GMT 2)

We are professional brand shoes,glassess and Accessories supplier in china.
Accessories
bag:Lv handbag,gucci handbag,channel handbag,fendi handbag,prada handbag,juicy handbag,bubbery bag,chloe bag,CD bag
hat; bape hat,gucci hat,lv hat,edhardy hat,new era hat,rmc hat
belt:D&G belt, Boss belt,LEVIS belt,LV belt,Gucci belt,DIESEL belt,VERSACE belt,lee belt
scarf:lv scarf,gucci scarf,bubbery scarf
glassess;Versace Glassess,gucci glassess,lv glassess,prada glassess,D&G glassess,Armani Glassess,chanel glassess
We accept big & small quantity order,mixed order and dropship.All the products is in good quality with low price.
website: www.shoes258.com
msn:shoes258@hotmail.com

Import/Export :: wholesale nike shox,air max,puma ,prada shoes,Jacket,

shoes258 — Tue, 02 Dec 2008 14:37:40 GMT

Author: shoes258
Subject: wholesale nike shox,air max,puma ,prada shoes,Jacket,
Posted: Tuesday, 2008 December 2 - 16:37 (GMT 2)

Welcome to login our website:http://www.shoes258.com
we are a leading company that wholesales and export of world brand SHOES and CLOTHES(t-shirts,hoodey,coat) and JEANS and BAGS and HAT and watch and Glasses ipod mp3/mp4,mainly provide
1)shoes;nike shoes,(air jordan(1-21.5) series,air force one,air max90, air max87,air max360 ,nike spizike jordanshox,dunk,kobe,foamposite,football,rift)gucci,bape,puma,adidas,timberland,prada,dsquared,D&G,LV,James,ICE,diesel
2)exquisite;lv,gucci,prada,chanel,fendi,coach,dior,burberry,juicy,chloe,hermes bags
3)brand clothes ;bape,bbc,DSCO,POLO,Replay,lacoste,evisu,Baby,A&f,edhardy,Akademiks,
,lrg,hoody and coat jerseys(NBA,NFL)
All with original box packing,hang
tags,bar code,Welcome order our products! we will give your best price and
service.
our website: http://www.shoes258.com

General :: www.shoes258.com sell nike shoes,Prada,Bape,Timberland,

shoes258 — Tue, 02 Dec 2008 14:34:04 GMT

Author: shoes258
Subject: www.shoes258.com sell nike shoes,Prada,Bape,Timberland,
Posted: Tuesday, 2008 December 2 - 16:34 (GMT 2)

We are a trade and manufacturing company of brand name sport productions in China,
welcome to visit our website: http://www.shoes258.com ,
Our productions are:jordan shoes,sell jordan shoes,china jordan shoes,air jordan shoes,nike jordan shoes,michael jordan shoes,buy jordan shoes,jordan shoes b2b.jordan shoes,sell jordan shoes,china jordan shoes,air jordan shoes,nike jordan shoes,michael jordan shoes,buy jordan shoes,jordan shoes b2b.wholesale shoes,wholesale nike shoes,wholesale jordan shoes,wholesale jordans,wholesale sneakers,wholesale clothes,wholesale handbags,wholesale air force ones,air force 1,air force 25,air force 25th,discount shoes,nike shoes,sell nike shoes,nike shoes forum,buy nike shoes ,nike shoes b2b,china nike shoes,supply nike shoes,replica nike shoes ,nike shoes export,putian nike shoes,nike shox vc,nike shox r4,nike dunk. Timberland,Soccer,Adidas shoes,
ugg boots,a&f jacket,evisu jeans,adida shoes,Christan Auaigier shoes,Christan Auaigier hoody
fendi bags,boots,timberbland,gucci,prada,puma shoes
discount NiKE/Adidas/Gucci/Bape/Prada/Puma/ shox shoes/ca shoes

yahoo:shoes258@hotmail.com

Import/Export :: HeidiSQL - Exports are allways ending in frozen GUI

redlabour — Tue, 02 Dec 2008 09:31:43 GMT

Author: redlabour
Subject: HeidiSQL - Exports are allways ending in frozen GUI
Posted: Tuesday, 2008 December 2 - 11:31 (GMT 2)

Hi,

after watching the new V4.x Relases and Daily-Builds only every second or third Release is usable for Exports from large Databases.

In my Case nearly every Export ends in a frozen GUI of HeidiSQL if a Table is larger then 1 MByte.

This time it gets frozen with heidisql.r2085

Can someone work on the export Function of HeidiSQl please?

jHeidi :: RE: jheidi - no database tree in left pane

servertude — Tue, 02 Dec 2008 02:15:58 GMT

Author: servertude
Subject: sorry
Posted: Tuesday, 2008 December 2 - 4:15 (GMT 2)

ok thats a bummer. I guess I can only refer you to HeidiSQL! jHeidi will eventually be more compatible, thanks for giving it a try.

- Bill

jHeidi :: RE: jheidi - no database tree in left pane

Jacques — Tue, 02 Dec 2008 02:13:40 GMT

Author: Jacques
Posted: Tuesday, 2008 December 2 - 4:13 (GMT 2)

That was experimental to see if could get any further. There are in fact three databases but the user doesn't have access to the first one.
this is what happens if I leave it out:

Code:

show databases
select version()
show tables from `mysql`
show variables
show full processlist
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Access denied for user: 'crewpc@192.168.100.69' to database 'mysql'
show /*!50002 global*/ status

It's always worked fine with HeidiSQL, though.

jHeidi :: RE: jheidi - no database tree in left pane

servertude — Tue, 02 Dec 2008 02:09:21 GMT

Author: servertude
Subject: one more thing
Posted: Tuesday, 2008 December 2 - 4:09 (GMT 2)

Im surmising that you put a database siteConfigDB in the "databases" field on the connection dialog. You could remove that and see if you get any further, but you will definitely run into other issues as I dont think jHeidi even works on mysql 4 but I havent done any testing of it in a while.

jHeidi :: RE: jheidi - no database tree in left pane

Jacques — Tue, 02 Dec 2008 00:56:11 GMT

Author: Jacques
Posted: Tuesday, 2008 December 2 - 2:56 (GMT 2)

ohhh. Okay.
Thanks.
I wonder if its time we moved to a later version of MySQL.

Regards
Robert

jHeidi :: RE: jheidi - no database tree in left pane

servertude — Tue, 02 Dec 2008 00:33:40 GMT

Author: servertude
Subject: MySQL 3?
Posted: Tuesday, 2008 December 2 - 2:33 (GMT 2)

Are you running mysql 3?

mysqld Ver 3.23.49 for pc-linux-gnu on i686

Currently jHeidi only supports mysql >=5.0
We will be adding some backward compatible code when jHeidi hits the beta stage.

jHeidi :: RE: jheidi - no database tree in left pane

Jacques — Mon, 01 Dec 2008 23:13:04 GMT

Author: Jacques
Posted: Tuesday, 2008 December 2 - 1:13 (GMT 2)

Hello Bill,
Thanks for replying.

There is no host icon in the left pane.

Platform is Windows XP SP3 but I get the same result with my openSuse Linux laptop

Code:

java version "1.6.0_10"

Host is running LEAF linux

Code:

Linux tch 2.6.23.1-tch2.8.57.8 #1 Sun Nov 11 16:29:44 EST 2007 i686 unknown

mysqld Ver 3.23.49 for pc-linux-gnu on i686

SQL log says:

Code:

show databases where `database` in ('siteconfigDB')
select version()
show variables
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax near 'where `database` in ('siteconfigDB')' at line 1
show full processlist
show /*!50002 global*/ status

regards
Robert

jHeidi :: RE: jheidi - no database tree in left pane

servertude — Mon, 01 Dec 2008 09:51:53 GMT

Author: servertude
Subject: I have seen this happen a couple of times
Posted: Monday, 2008 December 1 - 11:51 (GMT 2)

It could be a timing issue in the GUI.

To verify that the tree was actually loaded, please start jheidi connect to the database in question.

Double click on the "host" icon in the top of the left pane. That should force the tree to expand and show you the databases. I have only seen this very rarely, not sure the cause.

If that doesnt work then please give more details such as platform, version etc and we can check the log files for an error.

- Bill

Feature discussion :: inserting sequential records into a table.

Jacques — Mon, 01 Dec 2008 04:05:38 GMT

Author: Jacques
Subject: inserting sequential records into a table.
Posted: Monday, 2008 December 1 - 6:05 (GMT 2)

Hello There,
This is probably more a MySQL question than a Heidi Question:
Frequently I need to make a list of sequential entries into a table

for example

insert into tag_virtual (tag, parent, descriptor, priority, role)
values
('2001','0','Announcement 1','127','Announcement')
('2002','0','Announcement 2','127','Announcement')
('2003','0','Announcement 3','127','Announcement')
('2004','0','Announcement 4','127','Announcement')
('2005','0','Announcement 5','127','Announcement')
('2006','0','Announcement 6','127','Announcement')
('2007','0','Announcement 7','127','Announcement')
('2008','0','Announcement 8','127','Announcement')
('2009','0','Announcement 9','127','Announcement')
('2010','0','Announcement 10','127','Announcement');

The tag numbers are not always the same but they are always sequential.
Is there a simple MySQL query I could run to automate this?

jHeidi :: jheidi - no database tree in left pane

Jacques — Mon, 01 Dec 2008 03:50:19 GMT

Author: Jacques
Subject: jheidi - no database tree in left pane
Posted: Monday, 2008 December 1 - 5:50 (GMT 2)

Hello There,
when I run jheidi I cannot get the database "tree" to show in the left pane the way that it does in "normal" HeidiSQL. Is this a bug or am I doing something wrong?

regards
Robert

Feature discussion :: RE: change shortcut for function

rosenfield — Fri, 28 Nov 2008 22:22:45 GMT

Author: rosenfield
Posted: Saturday, 2008 November 29 - 0:22 (GMT 2)

Quote:

Would it be possible to be able to switch the shortcut?

Not currently, but there's a feature request in the tracker, so as soon as someone feels like spending the time to do the preferences GUI required...

Quote:

Or is there a trick by editing a config file ?

Having the shortcuts stored in the registry / config file instead of hardcoded in the application sounds like a good idea as a beginning of full-flexes shortcut customizability.

The easiest trick for now is to download the source code and Delphi, then change the shortcut and run the compile script. See "readme for developers" on the front page.

General :: RE: problems with the new DataGrid tab

siMKin — Fri, 28 Nov 2008 07:19:23 GMT

Author: siMKin
Posted: Friday, 2008 November 28 - 9:19 (GMT 2)

You made someone very happy anse

* points at himself

Unfortunately it introduced a bug, which i have reported here:
http://code.google.com/p/heidisql/issues/detail?id=889

Great work though!

General :: RE: Editing fields

anse — Fri, 28 Nov 2008 06:54:33 GMT

Author: anse
Posted: Friday, 2008 November 28 - 8:54 (GMT 2)

Just to be complete: Converted negative floats were bug #826 and fixed in r1902.

General :: RE: problems with the new DataGrid tab

anse — Fri, 28 Nov 2008 06:49:10 GMT

Author: anse
Posted: Friday, 2008 November 28 - 8:49 (GMT 2)

All popup editors can be disabled via preferences. For text fields (varchar, text, longtext ...) we now don't popup the text editor at all but do it inline again, having a button which calls the popup window if needed.

And tabbing through fields while in editor mode is also possible now, at least for text and numeric fields.

See rfe #829 for details if of any interest.

General :: RE: Editing fields

siMKin — Thu, 27 Nov 2008 11:07:18 GMT

Author: siMKin
Posted: Thursday, 2008 November 27 - 13:07 (GMT 2)

aschmitt wrote:

And also the editing of a character field is now adapted.

Yea, at least the popup window is no longer there.
But it's still not as smooth as it used to be, in my opinion

General :: RE: Editing fields

aschmitt — Thu, 27 Nov 2008 11:02:04 GMT

Author: aschmitt
Posted: Thursday, 2008 November 27 - 13:02 (GMT 2)

You're right. Everything is ok with the latest version 2081.
And also the editing of a character field is now adapted.

General :: RE: Editing fields

siMKin — Thu, 27 Nov 2008 10:39:44 GMT

Author: siMKin
Posted: Thursday, 2008 November 27 - 12:39 (GMT 2)

NOT Unsigned? so, you mean it's Signed? (that would have to be the case)

What is the exact value you enter in the field and if you look at the output of the commands Heidi is sending, what do you see as the update / insert statement?

I'm using revision 2026 and don't have any problems.

Feature discussion :: RE: change shortcut for function

siMKin — Thu, 27 Nov 2008 10:24:59 GMT

Author: siMKin
Subject: Re: change shortcut for function
Posted: Thursday, 2008 November 27 - 12:24 (GMT 2)

marseillai wrote:

some feature in heidisql are really great such as perspective in data view so i tried to sweetch from SQLYOG to HEIDISQL but several thing still annoy me.
The first thing is the impossibility to edit text save in blob. i've contourn this by using text for the column format.

Why would you save text in a blob field? blob fields are used for binary data.
so, i don't think you've countered the problem, i think you simply found a better way

p.s.: http://dev.mysql.com/doc/refman/5.0/en/blob.html